climate_data

Average monthly temperature per region.

12 rows where region_id = "DEG0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DEG0,1 Thüringen DEG0 1 0.02
DEG0,2 Thüringen DEG0 2 0.78
DEG0,3 Thüringen DEG0 3 3.92
DEG0,4 Thüringen DEG0 4 8.4
DEG0,5 Thüringen DEG0 5 12.66
DEG0,6 Thüringen DEG0 6 15.98
DEG0,7 Thüringen DEG0 7 18.15
DEG0,8 Thüringen DEG0 8 18.0
DEG0,9 Thüringen DEG0 9 13.81
DEG0,10 Thüringen DEG0 10 9.2
DEG0,11 Thüringen DEG0 11 4.4
DEG0,12 Thüringen DEG0 12 1.14

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