Name: Daily Weather And Forecasts
Creator: Open-Meteo
License: https://open-meteo.com/en/licence

About this Dataset

Daily Weather And Forecasts

Daily historical weather observations and daily weather forecasts retrieved from the Open-Meteo API. The dataset includes temperature, precipitation, snowfall, radiation, weather codes, sunrise/sunset times, and other daily metrics for a set of population-ranked cities sourced from @geonames.geonames.

The dataset includes two long-format tables:

historical_daily_weather – historical daily observations
forecast_daily_weather – all forecast runs accumulated over time

Forecast data retains every forecast run, enabling backtesting, forecast comparison, and analysis of forecast accuracy over time.

Tables

Daily Weather Forecasts

@openmeteo.daily_weather.forecast_daily_weather

254.95 MB
59,080,000 rows
10 columns

CREATE TABLE forecast_daily_weather (
  "date" TIMESTAMP,
  "location_id" VARCHAR,
  "name" VARCHAR,
  "country_code" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "forecast_run_ts" TIMESTAMP,
  "variable" VARCHAR,
  "value" DOUBLE,
  "value_ts" TIMESTAMP
);

Daily Historical Weather

@openmeteo.daily_weather.historical_daily_weather

31.55 GB
7,582,461,260 rows
9 columns

CREATE TABLE historical_daily_weather (
  "date" TIMESTAMP,
  "location_id" VARCHAR,
  "name" VARCHAR,
  "country_code" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "variable" VARCHAR,
  "value" DOUBLE,
  "value_ts" TIMESTAMP
);