datasets real and made-up data to practise on

Datasets

Data for the Playground, Database Lab and Performance Lab. Pick one and open its files.

dataset

size

Real daily temperature, rain, snow and wind from 100 U.S. airport weather stations, 2022–2024.

363 days of weather3 tablesJan 2022 – Dec 2024

files

Open a file to see what one row means, its columns and a preview. Open in Playground starts a new file there with code that loads it.

cities3 rows · 6 columns · CSV

A city with weather coverage.

In your code: data/cities.csv

stations3 rows · 7 columns · CSV

A weather station, usually at an airport. A city can have more than one.

In your code: data/stations.csv

daily_weather363 rows · 10 columns · CSV

One day at one station. A day the station didn’t report has no row.

In your code: data/daily_weather.csv

station_idtextkey→ stations
Station
observation_datedatekey
Local observation date
tmax_cdecimal · can be empty
Maximum temperature, °C
tmin_cdecimal · can be empty
Minimum temperature, °C
precipitation_mmdecimal · can be empty
Precipitation, mm (0 with precip_trace = 1 means a trace)
precip_traceinteger
1 when precipitation was too small to measure
snowfall_mmdecimal · can be empty
Snowfall, mm; often not reported
snow_depth_mmdecimal · can be empty
Snow depth, mm; often not reported
avg_wind_speed_msdecimal · can be empty
Average wind speed, m/s
peak_gust_msdecimal · can be empty
Fastest 2-minute wind, m/s

relationships

How to join these tables. Left column matches the right column.