climate_data

Average monthly temperature per region.

12 rows where region_id = "DED2"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DED2,1 Dresden DED2 1 -0.3
DED2,2 Dresden DED2 2 0.52
DED2,3 Dresden DED2 3 3.66
DED2,4 Dresden DED2 4 8.48
DED2,5 Dresden DED2 5 13.06
DED2,6 Dresden DED2 6 16.44
DED2,7 Dresden DED2 7 18.45
DED2,8 Dresden DED2 8 18.3
DED2,9 Dresden DED2 9 13.98
DED2,10 Dresden DED2 10 9.3
DED2,11 Dresden DED2 11 4.4
DED2,12 Dresden DED2 12 0.93

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