climate_data

Average monthly temperature per region.

12 rows where region_id = "DEA3"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DEA3,1 Münster DEA3 1 2.15
DEA3,2 Münster DEA3 2 2.6
DEA3,3 Münster DEA3 3 5.35
DEA3,4 Münster DEA3 4 9.16
DEA3,5 Münster DEA3 5 13.19
DEA3,6 Münster DEA3 6 16.18
DEA3,7 Münster DEA3 7 18.3
DEA3,8 Münster DEA3 8 18.0
DEA3,9 Münster DEA3 9 14.5
DEA3,10 Münster DEA3 10 10.33
DEA3,11 Münster DEA3 11 5.96
DEA3,12 Münster DEA3 12 2.95

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