climate_data

Average monthly temperature per region.

12 rows where region_id = "DEA2"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DEA2,1 Köln DEA2 1 2.66
DEA2,2 Köln DEA2 2 3.15
DEA2,3 Köln DEA2 3 5.95
DEA2,4 Köln DEA2 4 9.5
DEA2,5 Köln DEA2 5 13.45
DEA2,6 Köln DEA2 6 16.56
DEA2,7 Köln DEA2 7 18.66
DEA2,8 Köln DEA2 8 18.43
DEA2,9 Köln DEA2 9 14.88
DEA2,10 Köln DEA2 10 10.89
DEA2,11 Köln DEA2 11 6.53
DEA2,12 Köln DEA2 12 3.51

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