Climate trends and records
For climate-risk, ESG and sustainability analysts
Climate risk needs long, clean history at named places, not a global average. Follow average temperature in New York back to 1870, compare how three cities have drifted from their 1991–2020 normals since 1990, and list where records keep falling.
- Weather
- 6 steps
- Runs on live data
Built for
How EquationDB answers it
Each step is one query on live data. Run them in order, or open any one and adapt it: change the symbol, the station, the dates or the filter.
New York since 1870
The average temperature in Central Park for every year since 1870: one of the longest continuous records in the country.
SERIES weather:KNYC.tavg SINCE 1870-01-01 ALIGN yearly LIMIT 200
Three cities against their own normal
Each year's average departure from the station's own 1991–2020 normal at New York, Los Angeles and Phoenix: warming is not the same everywhere.
SERIES weather:KNYC.tavg_anom, weather:KLAX.tavg_anom, weather:KPHX.tavg_anom SINCE 1990-01-01 ALIGN yearly
Phoenix, year by year
Phoenix's average anomaly per year: the clearest urban heat trend in the network.
SERIES weather:KPHX.tavg_anom SINCE 1990-01-01 ALIGN yearly
Record highs in Arizona
Days since 2025 that beat a station's all-time record for the date in Arizona, sorted by the margin.
EVENTS record_high IN weather.us SINCE 2025-01-01 WHERE state = 'AZ' SORT magnitude DESC LIMIT 15
The latest records anywhere
The most recent record highs across all 399 US stations, newest first.
EVENTS record_high IN weather.us LAST 1y SORT date DESC LIMIT 25
The coldest records of the year
Records fall at both ends: the year's biggest record lows, sorted by the margin.
EVENTS record_low IN weather.us LAST 1y SORT magnitude DESC LIMIT 10
Run it on your own question
Sign in and press Try it on any step, or ask for a short demo on your data.
More weather use cases
- Severe weather and recordsRisk, insurance and operations teams
- Weather desk basicsAnyone starting with the Weather database: analysts, meteorology-curious traders, data teams
- World citiesGlobal macro, commodity and international teams
- Weather for energy and powerNatural gas, power and utilities desks
- Natural gas: winter demandNatural gas traders, utilities and demand planners
- Texas power: heat and freezePower traders, generators and utility analysts covering Texas