EquationDB

Weather desk basics

For anyone starting with the Weather database: analysts, meteorology-curious traders, data teams

Read any of 399 US stations and 55 world cities like a symbol: today's conditions, long history, units, anomalies against the station's own normal, and the catalog of what can be asked. Stations are named by airport code (KORD), city (CHICAGO) or station id.

  • Weather
  • 8 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. The last two weeks in Chicago

    Highs, lows, rain and snow at O'Hare for the last fourteen days (calendar days back from the newest observation).

    GET weather:CHICAGO SELECT tmax, tmin, prcp, snow LAST 14d
    Try it →
  2. A record from 1869

    Central Park's record 106 °F on 9 July 1936: the history goes back to 1869 for New York and to the 1940s for most stations.

    SERIES weather:KNYC.tmax FROM 1936-07-08 TO 1936-07-10
    Try it →
  3. How far from normal is it?

    The daily mean and its distance from the station's own 1991–2020 normal for that time of year.

    GET weather:KNYC SELECT tavg, tavg_anom LAST 14d
    Try it →
  4. Monthly rain in Miami

    Rain is a flow, so ALIGN monthly sums it: the June–October wet season stands out.

    SERIES weather:MIAMI.prcp LAST 3y ALIGN monthly
    Try it →
  5. Snowfall by year in Buffalo

    Yearly snowfall totals at Buffalo since 2000.

    SERIES weather:BUFFALO.snow SINCE 2000-01-01 ALIGN yearly
    Try it →
  6. Celsius and millimetres

    Metric units for any station; world cities like Heathrow arrive about a year late, so they are history.

    GET weather:LONDON SELECT tmax_c, prcp_mm SINCE 2024-06-01
    Try it →
  7. Every series of one station

    All 19 measures for O'Hare with their first and last dates.

    SHOW SERIES FOR weather:KORD
    Try it →
  8. What can be asked

    The weather measures, each a series for all 454 stations.

    SHOW SERIES LIKE 'weather'
    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