climate_data

Average monthly temperature per region.

12 rows where region_id = "DE94"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DE94,1 Weser-Ems DE94 1 2.36
DE94,2 Weser-Ems DE94 2 2.77
DE94,3 Weser-Ems DE94 3 5.33
DE94,4 Weser-Ems DE94 4 9.2
DE94,5 Weser-Ems DE94 5 13.05
DE94,6 Weser-Ems DE94 6 15.92
DE94,7 Weser-Ems DE94 7 18.05
DE94,8 Weser-Ems DE94 8 17.86
DE94,9 Weser-Ems DE94 9 14.61
DE94,10 Weser-Ems DE94 10 10.49
DE94,11 Weser-Ems DE94 11 6.15
DE94,12 Weser-Ems DE94 12 3.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)
  );