climate_data

Average monthly temperature per region.

12 rows where region_id = "DE21"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DE21,1 Oberbayern DE21 1 -0.34
DE21,2 Oberbayern DE21 2 0.49
DE21,3 Oberbayern DE21 3 4.28
DE21,4 Oberbayern DE21 4 8.55
DE21,5 Oberbayern DE21 5 12.87
DE21,6 Oberbayern DE21 6 16.33
DE21,7 Oberbayern DE21 7 18.17
DE21,8 Oberbayern DE21 8 18.05
DE21,9 Oberbayern DE21 9 13.64
DE21,10 Oberbayern DE21 10 9.26
DE21,11 Oberbayern DE21 11 3.91
DE21,12 Oberbayern DE21 12 0.44

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