Data Catalog
Overview
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. 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.
Schema38
Column
Type
valid_timeDateTime64(6, 'UTC')location_idLowCardinality(String)lead_daysInt64latitudeNullable(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')Sample rows
| valid_time | location_id | lead_days | latitude | longitude | temperature_2m_c | apparent_temperature_c | dew_point_2m_c | relative_humidity_2m_pct | wet_bulb_temperature_2m_c | vapour_pressure_deficit_kpa | pressure_msl_hpa | surface_pressure_hpa | shortwave_radiation_wm2 | direct_radiation_wm2 | diffuse_radiation_wm2 | direct_normal_irradiance_wm2 | terrestrial_radiation_wm2 | cloud_cover_pct | wind_speed_10m_ms | wind_speed_80m_ms | wind_speed_120m_ms | wind_speed_180m_ms | wind_direction_10m_deg | wind_direction_80m_deg | wind_direction_120m_deg | wind_direction_180m_deg | wind_gust_10m_ms | precipitation_mm | rain_mm | showers_mm | snowfall_cm | cape_jkg | evapotranspiration_mm | et0_fao_evapotranspiration_mm | is_day | weather_code | ingested_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-07-19 23:00:00.000000 | era5_50.00_-99.75 | 3 | 50 | -99.75 | 31.3 | 33.6 | 21.5 | 56 | 24.5 | 2.01 | 1001.2 | 954.7 | 573 | 503 | 70 | 832 | 801.1 | 6 | 4.69 | 6.72 | 7.09 | 7.89 | 236 | 240 | 240 | 248 | 8.3 | 0 | 0 | 0 | 0 | 2960 | 0 | 0.47 | 1 | 0 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-99.50 | 3 | 50 | -99.5 | 31.4 | 33.1 | 20.9 | 54 | 24.2 | 2.11 | 1001 | 958.5 | 506 | 326 | 180 | 541 | 797.7 | 100 | 4.88 | 7.14 | 7.58 | 7.65 | 223 | 224 | 224 | 244 | 8.7 | 0 | 0 | 0 | 0 | 2770 | 0 | 0.44 | 1 | 3 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-99.25 | 3 | 50 | -99.25 | 31 | 32.4 | 20.6 | 54 | 23.8 | 2.06 | 1000.8 | 959.8 | 396 | 186 | 210 | 309.7 | 794.9 | 100 | 5.24 | 7.92 | 8.45 | 8.32 | 215 | 217 | 217 | 241 | 9.3 | 0 | 0 | 0 | 0 | 2550 | 0 | 0.38 | 1 | 3 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-99.00 | 3 | 50 | -99 | 31.8 | 32.9 | 20.4 | 51 | 24 | 2.31 | 1000.7 | 967 | 389 | 181 | 208 | 302.5 | 792 | 100 | 5.68 | 8.29 | 8.82 | 8.02 | 208 | 210 | 210 | 237 | 9.6 | 0 | 0 | 0 | 0 | 2550 | 0 | 0.4 | 1 | 3 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-98.75 | 3 | 50 | -98.75 | 31.7 | 32.6 | 20.4 | 51 | 24 | 2.3 | 1000.8 | 969.3 | 364 | 167 | 197 | 280 | 789.1 | 100 | 6.11 | 8.76 | 9.39 | 7.99 | 195 | 199 | 199 | 238 | 9.9 | 0 | 0 | 0 | 0 | 2460 | 0 | 0.4 | 1 | 3 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-98.50 | 3 | 50 | -98.5 | 31.2 | 31.7 | 20.1 | 52 | 23.6 | 2.17 | 1001 | 972.2 | 285 | 126 | 159 | 212 | 786.2 | 100 | 6.41 | 9.24 | 9.79 | 7.61 | 191 | 196 | 196 | 242 | 10.1 | 0 | 0 | 0 | 0 | 2300 | 0 | 0.35 | 1 | 3 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-98.25 | 3 | 50 | -98.25 | 31.7 | 33 | 21.2 | 54 | 24.4 | 2.14 | 1001.4 | 973.2 | 438 | 227 | 211 | 384 | 783.4 | 100 | 6 | 8.76 | 9.3 | 7.68 | 191 | 197 | 197 | 252 | 9.4 | 0 | 0 | 0 | 0 | 2580 | 0 | 0.42 | 1 | 3 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-98.00 | 3 | 50 | -98 | 30.9 | 32.6 | 22 | 59 | 24.7 | 1.83 | 1002 | 974.5 | 492 | 315 | 177 | 534.7 | 780.5 | 100 | 6.24 | 9 | 9.53 | 7.63 | 192 | 195 | 196 | 248 | 9.8 | 0 | 0 | 0 | 0 | 3020 | 0 | 0.43 | 1 | 3 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-97.75 | 3 | 50 | -97.75 | 31 | 32.9 | 22 | 59 | 24.7 | 1.84 | 1002.3 | 975.5 | 514 | 385 | 129 | 655.8 | 777.6 | 79 | 5.61 | 8.36 | 8.79 | 7.8 | 202 | 201 | 202 | 247 | 9.6 | 0 | 0 | 0 | 0 | 2860 | 0 | 0.43 | 1 | 2 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-97.50 | 3 | 50 | -97.5 | 31.3 | 33.1 | 21.2 | 55 | 24.3 | 2.06 | 1002.5 | 975.7 | 529 | 430 | 99 | 735.1 | 774.7 | 48 | 5.25 | 7.62 | 8.05 | 8.04 | 211 | 210 | 210 | 235 | 9.1 | 0 | 0 | 0 | 0 | 2500 | 0 | 0.45 | 1 | 1 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-97.25 | 3 | 50 | -97.25 | 32 | 32.8 | 19.9 | 49 | 23.8 | 2.42 | 1002.6 | 976.4 | 534 | 440 | 94 | 754.9 | 771.8 | 51 | 5.56 | 8 | 8.39 | 9.07 | 218 | 217 | 217 | 212 | 8.9 | 0 | 0 | 0 | 0 | 2090 | 0 | 0.48 | 1 | 2 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-97.00 | 3 | 50 | -97 | 32.3 | 32.7 | 19.2 | 46 | 23.5 | 2.6 | 1002.6 | 977 | 536 | 456 | 80 | 785.2 | 768.9 | 7 | 5.69 | 7.96 | 8.42 | 9.89 | 219 | 219 | 219 | 208 | 8.4 | 0 | 0 | 0 | 0 | 1860 | 0 | 0.5 | 1 | 0 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-96.75 | 3 | 50 | -96.75 | 32.4 | 32.8 | 18.9 | 45 | 23.4 | 2.67 | 1002.5 | 976 | 536 | 460 | 76 | 794.9 | 766 | 6 | 5.46 | 7.63 | 8.07 | 10.17 | 215 | 214 | 215 | 210 | 8.1 | 0 | 0 | 0 | 0 | 1770 | 0 | 0.5 | 1 | 0 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-96.50 | 3 | 50 | -96.5 | 32.2 | 32.8 | 18.4 | 44 | 23 | 2.69 | 1002.6 | 974.5 | 537 | 469 | 68 | 814.9 | 762.5 | 7 | 4.61 | 7.08 | 7.6 | 10.3 | 207 | 211 | 211 | 209 | 7.9 | 0 | 0 | 0 | 0 | 1640 | 0 | 0.48 | 1 | 0 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-96.25 | 3 | 50 | -96.25 | 32.3 | 32.5 | 16.6 | 39 | 22.1 | 2.95 | 1002.8 | 971.7 | 535 | 468 | 67 | 816.2 | 759.5 | 7 | 4.13 | 7 | 7.42 | 10.37 | 212 | 211 | 212 | 214 | 7.3 | 0 | 0 | 0 | 0 | 1190 | 0 | 0.48 | 1 | 0 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-96.00 | 3 | 50 | -96 | 32.7 | 32.4 | 15.7 | 36 | 21.8 | 3.17 | 1002.8 | 972.8 | 533 | 466 | 67 | 815.7 | 756.6 | 6 | 4.28 | 7.08 | 7.51 | 10.4 | 217 | 216 | 217 | 215 | 6.9 | 0 | 0 | 0 | 0 | 930 | 0 | 0.5 | 1 | 0 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-95.75 | 3 | 50 | -95.75 | 33 | 32.2 | 14.6 | 33 | 21.3 | 3.36 | 1002.8 | 970.5 | 529 | 461 | 68 | 810 | 753.6 | 6 | 4.38 | 7.07 | 7.58 | 10 | 225 | 224 | 223 | 217 | 6.6 | 0 | 0 | 0 | 0 | 650 | 0 | 0.5 | 1 | 0 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-95.50 | 3 | 50 | -95.5 | 33.4 | 32.3 | 14 | 31 | 21.2 | 3.55 | 1002.8 | 969.1 | 527 | 459 | 68 | 809.5 | 750.8 | 6 | 4.62 | 7.47 | 7.91 | 9.78 | 231 | 231 | 231 | 217 | 6.5 | 0 | 0 | 0 | 0 | 500 | 0 | 0.52 | 1 | 0 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-95.25 | 3 | 50 | -95.25 | 33.6 | 32.3 | 13.1 | 29 | 20.9 | 3.7 | 1002.8 | 965.2 | 526 | 458 | 68 | 810.8 | 747.7 | 6 | 4.33 | 6.91 | 7.33 | 9.56 | 236 | 236 | 235 | 217 | 6.3 | 0 | 0 | 0 | 0 | 440 | 0 | 0.51 | 1 | 0 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-95.00 | 3 | 50 | -95 | 34 | 32.8 | 12.9 | 28 | 20.8 | 3.82 | 1002.8 | 966.5 | 525 | 458 | 67 | 813.9 | 744.8 | 0 | 3.99 | 6.13 | 6.49 | 9.54 | 248 | 246 | 246 | 218 | 6.2 | 0 | 0 | 0 | 0 | 300 | 0 | 0.51 | 1 | 0 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-94.75 | 3 | 50 | -94.75 | 34.6 | 33.7 | 11.7 | 25 | 20.5 | 4.13 | 1002.8 | 965.9 | 522 | 455 | 67 | 811.7 | 741.8 | 0 | 2.8 | 4.81 | 5.12 | 8.77 | 235 | 225 | 226 | 207 | 6 | 0 | 0 | 0 | 0 | 250 | 0 | 0.47 | 1 | 0 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-94.50 | 3 | 50 | -94.5 | 31.7 | 30 | 13.4 | 33 | 20.3 | 3.13 | 1003.3 | 966.1 | 517 | 449 | 68 | 805.6 | 738.7 | 0 | 5.2 | 7.45 | 7.84 | 9.75 | 179 | 187 | 188 | 201 | 6.5 | 0 | 0 | 0 | 0 | 230 | 0 | 0.5 | 1 | 0 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-94.25 | 3 | 50 | -94.25 | 31.2 | 29.9 | 13.5 | 34 | 20.2 | 3 | 1003.6 | 962.9 | 516 | 448 | 68 | 806.9 | 735.7 | 0 | 4.65 | 7.4 | 7.68 | 10.42 | 199 | 196 | 197 | 206 | 6.3 | 0 | 0 | 0 | 0 | 220 | 0 | 0.48 | 1 | 0 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-94.00 | 3 | 50 | -94 | 31.8 | 30.4 | 12.6 | 31 | 20 | 3.24 | 1003.6 | 962.8 | 515 | 448 | 67 | 810.1 | 732.7 | 0 | 4.22 | 6.63 | 6.91 | 10.04 | 216 | 214 | 214 | 215 | 6 | 0 | 0 | 0 | 0 | 220 | 0 | 0.48 | 1 | 0 | 2026-07-17 09:47:59.085807 |
| 2026-07-19 23:00:00.000000 | era5_50.00_-93.75 | 3 | 50 | -93.75 | 31.8 | 30.2 | 11.6 | 29 | 19.5 | 3.34 | 1003.7 | 958.3 | 514 | 447 | 67 | 811.4 | 729.7 | 0 | 3.89 | 6.01 | 6.28 | 9.72 | 226 | 227 | 227 | 220 | 6 | 0 | 0 | 0 | 0 | 160 | 0 | 0.48 | 1 | 0 | 2026-07-17 09:47:59.085807 |
Coverage
100.0% complete0 gap days931 days with data
Show coverage history ▾
Coverage: 100.0%Days with data: 931Gaps: 0
2026
2025
2024
gaplessmore