climate_data

Average monthly temperature per region.

12 rows where region_id = "CH07"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
CH07,1 Ticino CH07 1 -4.06
CH07,2 Ticino CH07 2 -2.99
CH07,3 Ticino CH07 3 0.58
CH07,4 Ticino CH07 4 4.06
CH07,5 Ticino CH07 5 8.94
CH07,6 Ticino CH07 6 13.22
CH07,7 Ticino CH07 7 15.32
CH07,8 Ticino CH07 8 15.1
CH07,9 Ticino CH07 9 11.05
CH07,10 Ticino CH07 10 6.54
CH07,11 Ticino CH07 11 1.06
CH07,12 Ticino CH07 12 -3.25

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)
  );