climate_data

Average monthly temperature per region.

12 rows where region_id = "DEE0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DEE0,1 Sachsen-Anhalt DEE0 1 1.23
DEE0,2 Sachsen-Anhalt DEE0 2 1.93
DEE0,3 Sachsen-Anhalt DEE0 3 4.81
DEE0,4 Sachsen-Anhalt DEE0 4 9.32
DEE0,5 Sachsen-Anhalt DEE0 5 13.76
DEE0,6 Sachsen-Anhalt DEE0 6 17.09
DEE0,7 Sachsen-Anhalt DEE0 7 19.3
DEE0,8 Sachsen-Anhalt DEE0 8 19.09
DEE0,9 Sachsen-Anhalt DEE0 9 14.97
DEE0,10 Sachsen-Anhalt DEE0 10 10.21
DEE0,11 Sachsen-Anhalt DEE0 11 5.4
DEE0,12 Sachsen-Anhalt DEE0 12 2.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)
  );