This heat map like grid (below) is the new bit and took a bit of putting together - hopefully its correct - it displays all days this summer that matched the Met Office heatwave threshold (orange), and those that lasted 3 days longer are heatwaves (red).
Although Heathrow has the highest count of both, it didn't have the longest running heatwave last week which was 5 days and occured at 5 sites mainly in eastern England.
The Moray Firth sites managed a creditable 4 days each.
I would like to add a bit more functionality to allow me to run this across Europe to see how the UKMO thresholds measure up to the European sites especially France.