← Datasets

Daily city weather forecasts

A daily snapshot of the Open-Meteo weather forecast for a fixed panel of eight major world cities: temperature, precipitation, wind, UV and sunrise/sunset for every day of the forecast horizon, recorded as of the day it was published. Because each run keeps what was forecast on that day, the series can be used to study how forecasts change as the target day approaches.

All three stay inside Daily city weather forecasts: the assistant is given this dataset’s schema and nothing else, and the playground attaches only these tables. Ask across every dataset from the home page instead.

Cadence

daily

Rows

64

Size

7.5 KB

Tables

2

Snapshot

2026-08-22

Last ingest

1 day ago

Manifest written

1 day ago

Version

01M0NH25E3QSH5TCFXMRTAR9X0

Source: https://open-meteo.com/en/docs
Machine-readable: manifest.json · catalog

INSTALL httpfs; LOAD httpfs;

CREATE OR REPLACE VIEW daily_weather AS
  SELECT * FROM read_parquet('https://data-directory.fsn1.your-objectstorage.com/public/open-meteo-daily/v/01M0NH25E3QSH5TCFXMRTAR9X0/daily_weather.parquet');

CREATE OR REPLACE VIEW cities AS
  SELECT * FROM read_parquet('https://data-directory.fsn1.your-objectstorage.com/public/open-meteo-daily/v/01M0NH25E3QSH5TCFXMRTAR9X0/cities.parquet');

SELECT * FROM daily_weather LIMIT 10;

INSTALL ducklake; LOAD ducklake;
ATTACH 'ducklake:https://data-directory.fsn1.your-objectstorage.com/catalog/open-meteo-daily/catalog.ducklake' AS lake (READ_ONLY); SELECT * FROM lake.main.daily_weather LIMIT 5;
USE lake;

SELECT c.name, w.forecast_date, w.temperature_min, w.temperature_max, w.precipitation_sum
FROM daily_weather w
JOIN cities c USING (city_id)
WHERE w.snapshot_date = (SELECT max(snapshot_date) FROM daily_weather)
  AND w.lead_days = 0
ORDER BY w.temperature_max DESC;

SELECT w.snapshot_date, w.lead_days, w.temperature_max
FROM daily_weather w
JOIN cities c USING (city_id)
WHERE c.name_lc = 'tokyo'
  AND w.forecast_date = DATE '2026-08-28'
ORDER BY w.lead_days DESC;

SELECT w.snapshot_date, c.name, sum(w.precipitation_sum) AS mm
FROM daily_weather w JOIN cities c USING (city_id)
GROUP BY 1, 2 QUALIFY row_number() OVER (PARTITION BY w.snapshot_date ORDER BY mm DESC) = 1
ORDER BY 1 DESC;