climate_data

Average monthly temperature per region.

12 rows where region_id = "DED4"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DED4,1 Chemnitz DED4 1 -0.55
DED4,2 Chemnitz DED4 2 0.08
DED4,3 Chemnitz DED4 3 3.36
DED4,4 Chemnitz DED4 4 8.11
DED4,5 Chemnitz DED4 5 12.53
DED4,6 Chemnitz DED4 6 15.75
DED4,7 Chemnitz DED4 7 17.77
DED4,8 Chemnitz DED4 8 17.67
DED4,9 Chemnitz DED4 9 13.43
DED4,10 Chemnitz DED4 10 8.96
DED4,11 Chemnitz DED4 11 4.04
DED4,12 Chemnitz DED4 12 0.65

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