climate_data

Average monthly temperature per region.

12 rows where region_id = "DEA5"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DEA5,1 Arnsberg DEA5 1 0.66
DEA5,2 Arnsberg DEA5 2 1.0
DEA5,3 Arnsberg DEA5 3 4.05
DEA5,4 Arnsberg DEA5 4 8.07
DEA5,5 Arnsberg DEA5 5 12.05
DEA5,6 Arnsberg DEA5 6 15.02
DEA5,7 Arnsberg DEA5 7 17.05
DEA5,8 Arnsberg DEA5 8 16.86
DEA5,9 Arnsberg DEA5 9 13.3
DEA5,10 Arnsberg DEA5 10 9.27
DEA5,11 Arnsberg DEA5 11 4.88
DEA5,12 Arnsberg DEA5 12 1.75

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