climate_data

Average monthly temperature per region.

12 rows where region_id = "CH02"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
CH02,1 Espace Mittelland CH02 1 -1.33
CH02,2 Espace Mittelland CH02 2 -0.59
CH02,3 Espace Mittelland CH02 3 3.03
CH02,4 Espace Mittelland CH02 4 6.6
CH02,5 Espace Mittelland CH02 5 10.78
CH02,6 Espace Mittelland CH02 6 14.51
CH02,7 Espace Mittelland CH02 7 16.51
CH02,8 Espace Mittelland CH02 8 16.41
CH02,9 Espace Mittelland CH02 9 12.43
CH02,10 Espace Mittelland CH02 10 8.36
CH02,11 Espace Mittelland CH02 11 2.94
CH02,12 Espace Mittelland CH02 12 -0.39

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