playground explore freely · no grades

SQL Playground

Explore any Runtime dataset with SQL. Nothing here affects course progress.

dataset

Three years (2022–2024) of daily observations from 100 NOAA weather stations serving 96 U.S. cities: temperatures, rain, snow and wind.

110,557 rows5 tables2022-01 – 2024-12

tables

Open a table to see what one row means, its columns and keys, and a preview. Start from daily_weather: it is the dataset's central table.

states51 rows · 4 columns

One U.S. state or the District of Columbia.

state_codeTEXTPK
USPS state code
state_nameTEXT
State name
census_regionTEXT
Northeast, Midwest, South or West
census_divisionTEXT
U.S. region division

cities96 rows · 6 columns

One city with weather coverage, including its map location.

city_idINTEGERPK
City key
city_nameTEXT
City name
state_codeTEXT→ states
State
latitudeREAL
City latitude
longitudeREAL
City longitude
land_area_sq_miREAL
Land area of the incorporated place, square miles

stations100 rows · 10 columns

One weather station (usually at an airport). A city can have more than one station.

station_idTEXTPK
Weather station ID
station_nameTEXT
Station name
city_idINTEGER→ cities
City the station represents
is_primaryINTEGER
1 for the station nearest the city’s internal point
latitudeREAL
Latitude
longitudeREAL
Longitude
elevation_mREAL
Elevation in metres
first_observationTEXT · nullable
Earliest observation date in this dataset
last_observationTEXT · nullable
Latest observation date in this dataset
reported_daysINTEGER
Days with at least one reported measurement

calendar1,096 rows · 10 columns

One calendar date, 2022–2024.

dateTEXTPK
Calendar date (YYYY-MM-DD)
yearINTEGER
Year
monthINTEGER
Month number
day_of_yearINTEGER
Day of the year, 1–366
day_of_weekINTEGER
0 = Sunday … 6 = Saturday
meteorological_seasonTEXT
winter (Dec–Feb), spring, summer or autumn
day_of_monthINTEGER
Day of the month, 1–31
day_nameTEXT
Sunday … Saturday
is_weekendINTEGER
1 for Saturday or Sunday
quarterINTEGER
Calendar quarter, 1–4

daily_weather109,214 rows · 10 columns

One day of weather for one station. If a station did not report that day, there is no row.

station_idTEXTPK→ stations
Station
observation_dateTEXTPK→ calendar
Local observation date
tmax_cREAL · nullable
Maximum temperature, °C
tmin_cREAL · nullable
Minimum temperature, °C
precipitation_mmREAL · nullable
Precipitation, mm; 0 with precip_trace = 1 means a trace
precip_traceINTEGER
1 when precipitation was a trace (too small to measure)
snowfall_mmREAL · nullable
Snowfall, mm
snow_depth_mmREAL · nullable
Snow depth on the ground, mm
avg_wind_speed_msREAL · nullable
Average wind speed, m/s
peak_gust_msREAL · nullable
Fastest 2-minute wind speed, m/s

relationships

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

cities.state_code joins to states.state_code
stations.city_id joins to cities.city_id
daily_weather.station_id joins to stations.station_id
daily_weather.observation_date joins to calendar.date