This morning’s weather forecast:
SUNNY. HIGHS IN THE UPPER 70S TO LOWER 80S. LIGHT WINDS.
May 13th seems very early in the year to hit 80 degrees in Fairbanks, so I decided to check it out. What I’m doing here is selecting all the dates where the temperature is above 80°F, then ranking those dates by year and date, and extracting the “winner” for each year (where rank is 1).
WITH warm AS ( SELECT extract(year from dte) AS year, dte, c_to_f(tmax_c) AS tmax_f FROM ghcnd_pivot WHERE station_name = 'FAIRBANKS INTL AP' AND c_to_f(tmax_c) >= 80.0), ranked AS ( SELECT year, dte, tmax_f, row_number() OVER (PARTITION BY year ORDER BY dte) AS rank FROM warm) SELECT dte, extract(doy from dte) AS doy, round(tmax_f, 1) as tmax_f FROM ranked WHERE rank = 1 ORDER BY doy;
And the results:
|Date||Day of year||High temperature (°F)|
If we hit 80°F today, it’ll be the fourth earliest day of year to hit that temperature since records started being kept in 1904.
Update: We didn’t reach 80°F on the 13th, but got to 82°F on May 14th, tied with that date in 1915 for the fourth earliest 80 degree temperature.