climate_data

Average monthly temperature per region.

12 rows where region_id = "DEA1"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DEA1,1 Düsseldorf DEA1 1 3.07
DEA1,2 Düsseldorf DEA1 2 3.57
DEA1,3 Düsseldorf DEA1 3 6.36
DEA1,4 Düsseldorf DEA1 4 10.0
DEA1,5 Düsseldorf DEA1 5 13.96
DEA1,6 Düsseldorf DEA1 6 16.93
DEA1,7 Düsseldorf DEA1 7 19.01
DEA1,8 Düsseldorf DEA1 8 18.7
DEA1,9 Düsseldorf DEA1 9 15.32
DEA1,10 Düsseldorf DEA1 10 11.27
DEA1,11 Düsseldorf DEA1 11 6.95
DEA1,12 Düsseldorf DEA1 12 3.88

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