EquationDB

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

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.

  1. 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
    Try it →
  2. 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
    Try it →
  3. 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
    Try it →
  4. 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
    Try it →
  5. 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
    Try it →
  6. 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
    Try it →

Run it on your own question

Sign in and press Try it on any step, or ask for a short demo on your data.

Request a trial

More weather use cases