climate_data

Average monthly temperature per region.

12 rows where region_id = "CH03"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
CH03,1 Nordwestschweiz CH03 1 0.84
CH03,2 Nordwestschweiz CH03 2 1.6
CH03,3 Nordwestschweiz CH03 3 5.28
CH03,4 Nordwestschweiz CH03 4 8.99
CH03,5 Nordwestschweiz CH03 5 13.15
CH03,6 Nordwestschweiz CH03 6 16.79
CH03,7 Nordwestschweiz CH03 7 18.75
CH03,8 Nordwestschweiz CH03 8 18.59
CH03,9 Nordwestschweiz CH03 9 14.42
CH03,10 Nordwestschweiz CH03 10 10.06
CH03,11 Nordwestschweiz CH03 11 4.78
CH03,12 Nordwestschweiz CH03 12 1.58

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