climate_data

Average monthly temperature per region.

12 rows where region_id = "CH04"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
CH04,1 Zürich CH04 1 0.99
CH04,2 Zürich CH04 2 1.66
CH04,3 Zürich CH04 3 5.27
CH04,4 Zürich CH04 4 8.98
CH04,5 Zürich CH04 5 13.25
CH04,6 Zürich CH04 6 16.94
CH04,7 Zürich CH04 7 18.92
CH04,8 Zürich CH04 8 18.86
CH04,9 Zürich CH04 9 14.7
CH04,10 Zürich CH04 10 10.45
CH04,11 Zürich CH04 11 5.15
CH04,12 Zürich CH04 12 1.81

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE climate_data (
    region_id TEXT,
    month INTEGER,
    avg_temp REAL,
    PRIMARY KEY (region_id, month),
    FOREIGN KEY (region_id) REFERENCES regions(id)
  );