climate_data

Average monthly temperature per region.

12 rows where region_id = "DED5"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DED5,1 Leipzig DED5 1 1.1
DED5,2 Leipzig DED5 2 1.91
DED5,3 Leipzig DED5 3 4.93
DED5,4 Leipzig DED5 4 9.57
DED5,5 Leipzig DED5 5 14.12
DED5,6 Leipzig DED5 6 17.48
DED5,7 Leipzig DED5 7 19.59
DED5,8 Leipzig DED5 8 19.44
DED5,9 Leipzig DED5 9 15.17
DED5,10 Leipzig DED5 10 10.42
DED5,11 Leipzig DED5 11 5.45
DED5,12 Leipzig DED5 12 2.21

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