climate_data

Average monthly temperature per region.

12 rows where region_id = "DEF0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DEF0,1 Schleswig-Holstein DEF0 1 1.77
DEF0,2 Schleswig-Holstein DEF0 2 2.05
DEF0,3 Schleswig-Holstein DEF0 3 4.26
DEF0,4 Schleswig-Holstein DEF0 4 8.34
DEF0,5 Schleswig-Holstein DEF0 5 12.45
DEF0,6 Schleswig-Holstein DEF0 6 15.53
DEF0,7 Schleswig-Holstein DEF0 7 17.77
DEF0,8 Schleswig-Holstein DEF0 8 17.65
DEF0,9 Schleswig-Holstein DEF0 9 14.31
DEF0,10 Schleswig-Holstein DEF0 10 10.03
DEF0,11 Schleswig-Holstein DEF0 11 5.59
DEF0,12 Schleswig-Holstein DEF0 12 2.71

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