climate_data

Average monthly temperature per region.

12 rows where region_id = "DEA4"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DEA4,1 Detmold DEA4 1 1.65
DEA4,2 Detmold DEA4 2 2.11
DEA4,3 Detmold DEA4 3 4.99
DEA4,4 Detmold DEA4 4 9.07
DEA4,5 Detmold DEA4 5 13.1
DEA4,6 Detmold DEA4 6 16.14
DEA4,7 Detmold DEA4 7 18.28
DEA4,8 Detmold DEA4 8 18.07
DEA4,9 Detmold DEA4 9 14.37
DEA4,10 Detmold DEA4 10 10.1
DEA4,11 Detmold DEA4 11 5.67
DEA4,12 Detmold DEA4 12 2.61

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