Weather Forecast Grid (Current + Ahead)

Hourly weather forecasts on the same 0.25 degree latitude and longitude grid as the history table, extending about two days ahead — this is the dataset for current conditions and the hours in front of them, since the ERA5 history trails real time by several days.

Native record
valid hour x grid point x lead-day vintage
hourly (forecast, 1-3 day leads) publication cadence
Evidence
Forecast data
Forward-looking values with an explicit issue time
Time basis
Point-in-time records
UTC · valid_time

Overview

Rich per-point coverage: temperature, apparent and wet-bulb temperature, humidity, cloud cover, shortwave and direct radiation, wind speed and direction at 10, 80, 120, and 180 meters, gusts, precipitation, and CAPE — the drivers behind load, wind output, and solar output. Rows are vintage-stamped by lead_days (days between forecast issue and the valid hour); multiple vintages coexist per valid hour, so take the minimum lead_days per (valid_time, location_id) for the freshest view of any hour. Source: Open-Meteo.

Query contract

For the freshest map-compatible estimate, read FINAL and select the row with latest ingested_at per (valid_time, location_id), retaining lead_days and ingested_at. Reduce vintages before aggregating locations or hours.

Analysis rules

  • Never sum forecast vintages or wind speeds. Resolve one row per valid_time and location_id before spatial or temporal aggregation.
  • For a named place, use bounded coordinates and report the sampled grid point, distance, valid hour and wind height. A point sample does not describe an entire weather zone.

Interpretation

  • This is hourly modeled forecast weather on a 0.25-degree lattice, including estimates for the current hour. It is not a measured station observation, radar velocity, tornado warning or confirmation of a tornado; modeled wind and CAPE cannot confirm or rule out a tornado.
  • valid_time is the forecast target, lead_days is the source vintage label, and ingested_at is when this mirror received the row, not the model issue time. FINAL retains revisions per vintage key; the table does not preserve a complete as-known-at archive.

Access

Query from your own tools

Use the guarded HTTP endpoint directly, or connect an MCP client and load the dataset contract with describe_data before calling query_data.

HTTP endpoint
POST /api/v1/datasets/open_meteo_forecast_grid/query

Need the full history of this dataset in Snowflake, Databricks or your own storage? Data services delivers it on a schedule.

Schema40

Column
Type
valid_timeDateTime64(6, 'UTC')
location_idLowCardinality(String)
lead_daysInt64
latitudeNullable(Float64)
longitudeNullable(Float64)
temperature_2m_cNullable(Float64)
apparent_temperature_cNullable(Float64)
dew_point_2m_cNullable(Float64)
relative_humidity_2m_pctNullable(Float64)
wet_bulb_temperature_2m_cNullable(Float64)
vapour_pressure_deficit_kpaNullable(Float64)
pressure_msl_hpaNullable(Float64)
surface_pressure_hpaNullable(Float64)
shortwave_radiation_wm2Nullable(Float64)
direct_radiation_wm2Nullable(Float64)
diffuse_radiation_wm2Nullable(Float64)
direct_normal_irradiance_wm2Nullable(Float64)
terrestrial_radiation_wm2Nullable(Float64)
cloud_cover_pctNullable(Float64)
wind_speed_10m_msNullable(Float64)
wind_speed_80m_msNullable(Float64)
wind_speed_120m_msNullable(Float64)
wind_speed_180m_msNullable(Float64)
wind_direction_10m_degNullable(Float64)
wind_direction_80m_degNullable(Float64)
wind_direction_120m_degNullable(Float64)
wind_direction_180m_degNullable(Float64)
wind_gust_10m_msNullable(Float64)
precipitation_mmNullable(Float64)
rain_mmNullable(Float64)
showers_mmNullable(Float64)
snowfall_cmNullable(Float64)
cape_jkgNullable(Float64)
evapotranspiration_mmNullable(Float64)
et0_fao_evapotranspiration_mmNullable(Float64)
is_dayNullable(Int64)
weather_codeNullable(Int64)
ingested_atDateTime64(6, 'UTC')
wind_speed_100m_msNullable(Float64)
wind_direction_100m_degNullable(Float64)

Sample data

valid_timelocation_idlead_dayslatitudelongitudetemperature_2m_capparent_temperature_cdew_point_2m_crelative_humidity_2m_pctwet_bulb_temperature_2m_cvapour_pressure_deficit_kpapressure_msl_hpasurface_pressure_hpashortwave_radiation_wm2direct_radiation_wm2diffuse_radiation_wm2direct_normal_irradiance_wm2terrestrial_radiation_wm2cloud_cover_pctwind_speed_10m_mswind_speed_80m_mswind_speed_120m_mswind_speed_180m_mswind_direction_10m_degwind_direction_80m_degwind_direction_120m_degwind_direction_180m_degwind_gust_10m_msprecipitation_mmrain_mmshowers_mmsnowfall_cmcape_jkgevapotranspiration_mmet0_fao_evapotranspiration_mmis_dayweather_codeingested_atwind_speed_100m_mswind_direction_100m_deg
2026-10-20 23:00:00.000000era5_39.50_-99.75439.5-99.7522.419.111.85115.91.331013.5935.519915247627.4335.107.3410.6211.247.3416016616617411.400001000.23102026-10-17 16:45:05.09916911.01166
2026-10-20 23:00:00.000000era5_39.50_-99.50439.5-99.522.11911.85215.81.281014.2943.219514748613.6331.106.9910.3110.888.2415616216317011.40000000.22102026-10-17 16:45:05.09916910.66163
2026-10-20 23:00:00.000000era5_39.50_-99.25439.5-99.2521.618.812.25515.81.161014.9947.719114447608327.106.669.9210.548.5915215815816811.20000000.2102026-10-17 16:45:05.09916910.32158
2026-10-20 23:00:00.000000era5_39.50_-99.00439.5-9920.818.212.86015.80.981015.6952.818714047598323.256.729.9310.519.7115015515616811.30000000.18102026-10-17 16:45:05.09916910.3156
2026-10-20 23:00:00.000000era5_39.50_-98.75439.5-98.7520.417.813.16315.70.881016.3956.318313548583.5319.576.89.8110.4310.6215215715716611.20.100.10000.171512026-10-17 16:45:05.09916910.22157
2026-10-20 23:00:00.000000era5_39.50_-98.50439.5-98.520.41813.36415.90.861016.9965.616410460454.9314.9846.619.5610.1810.85160164164162110000000.16132026-10-17 16:45:05.0991699.97164
2026-10-20 23:00:00.000000era5_39.50_-98.25439.5-98.2520.417.912.96215.60.911017.5965.316210161449.9310.9656.449.469.9511.5817417317416010.70000000.16122026-10-17 16:45:05.0991699.75174
2026-10-20 23:00:00.000000era5_39.50_-98.00439.5-982017.612.56215.20.891017.8964.41386969311.2306.91005.949.099.6912.0816717217216110.60.100.10000.151512026-10-17 16:45:05.0991699.49172
2026-10-20 23:00:00.000000era5_39.50_-97.75439.5-97.7519.116.812.66614.90.751018.3966.91367264328.8302.91005.859.19.6812.3616316516616110.70.400.40000.131512026-10-17 16:45:05.0991699.48166
2026-10-20 23:00:00.000000era5_39.50_-97.50439.5-97.519.416.811.76114.60.881018.8970.416611947550.5298.9135.928.869.3511.716816916916010.30.100.10000.151512026-10-17 16:45:05.0991699.16169
2026-10-20 23:00:00.000000era5_39.50_-97.25439.5-97.2519.616.911.45914.50.941019.1975.216311746548.2294.9355.928.869.4511.416816916915810.10000000.16112026-10-17 16:45:05.0991699.26169
2026-10-20 23:00:00.000000era5_39.50_-97.00439.5-9719.516.5115814.30.951019.5974.11418358394.1290.9866.159.069.6410.7317317417515910.40000000.16132026-10-17 16:45:05.0991699.44175
2026-10-20 23:00:00.000000era5_39.50_-96.75439.5-96.7519.616.810.95714.30.981019.8975.31296663317.6286.31005.98.89.3910.318017917915610.10000000.16132026-10-17 16:45:05.0991699.2179
2026-10-20 23:00:00.000000era5_39.50_-96.50439.5-96.51916.110.15613.60.971020.1969.41216160299.5282.31005.758.719.2810.64167171172153100000000.15132026-10-17 16:45:05.0991699.09172
2026-10-20 23:00:00.000000era5_39.50_-96.25439.5-96.2519.116.210.15613.70.971020.4976.61368353413.3278.3465.448.428.9910.15160164165152100000000.15112026-10-17 16:45:05.0991698.81165
2026-10-20 23:00:00.000000era5_39.50_-96.00439.5-9618.415.9105813.30.891020.8974.61429448474.7274754.727.848.59.571591631641549.70000000.14122026-10-17 16:45:05.0991698.32164
2026-10-20 23:00:00.000000era5_39.50_-95.75439.5-95.7518.416.2105813.30.891021.1981.41256857348.3270984.227.347.979.261581601611548.80000000.13132026-10-17 16:45:05.0991697.81161
2026-10-20 23:00:00.000000era5_39.50_-95.50439.5-95.518.216.210.15913.30.861021.4985.41226656343266873.947.177.838.991531571581518.40000000.12132026-10-17 16:45:05.0991697.67158
2026-10-20 23:00:00.000000era5_39.50_-95.25439.5-95.2518169.95913.10.851021.6985.41236855358.7261.41003.857.087.668.5915215715915280000000.12132026-10-17 16:45:05.0991697.5159
2026-10-20 23:00:00.000000era5_39.50_-95.00439.5-9517.916.19.65812.90.861021.9984.1994851257257.31003.366.046.858.461431531551516.10000000.11132026-10-17 16:45:05.0991696.71155
2026-10-20 23:00:00.000000era5_39.50_-94.75439.5-94.7517.815.99.75912.90.831022.3986.91005050271.9253.31003.346.096.717.841411501541505.60000000.1132026-10-17 16:45:05.0991696.57154
2026-10-20 23:00:00.000000era5_39.50_-94.50439.5-94.517.515.59.25812.50.841022.6990.5995049278.32491003.366.176.767.631501531551485.80000000.1132026-10-17 16:45:05.0991696.62155
2026-10-20 23:00:00.000000era5_39.50_-94.25439.5-94.2517.415.38.55612.20.871022.8985.6924646260.22451003.185.826.447.11671641651455.50000000.1132026-10-17 16:45:05.0991696.31165
2026-10-20 23:00:00.000000era5_39.50_-94.00439.5-9417.815.68.15312.20.961023988.71015447310.4240.9983.145.946.476.881711731741445.30000000.11132026-10-17 16:45:05.0991696.34174
2026-10-20 23:00:00.000000era5_39.50_-93.75439.5-93.7518.316.28.25212.51.011023.2995.51146846397.4236.9953.115.76.026.5517417917914640000000.11132026-10-17 16:45:05.0991695.9179

Coverage

Showing the last 223 days of a 2,029-day history (Apr 1, 2021 → Oct 20, 2026). This dataset holds 9.08B rows — too many to count day by day on every visit — so the calendar and the figures below cover the window from Mar 12, 2026.

100.0% complete0 gap days223 days with data
Show coverage history
Coverage: 100.0%Days with data: 223Gaps: 0
2026
gaplessmore