climate_data

Average monthly temperature per region.

12 rows where region_id = "DE73"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DE73,1 Kassel DE73 1 0.31
DE73,2 Kassel DE73 2 0.97
DE73,3 Kassel DE73 3 4.03
DE73,4 Kassel DE73 4 8.24
DE73,5 Kassel DE73 5 12.32
DE73,6 Kassel DE73 6 15.57
DE73,7 Kassel DE73 7 17.68
DE73,8 Kassel DE73 8 17.47
DE73,9 Kassel DE73 9 13.45
DE73,10 Kassel DE73 10 8.95
DE73,11 Kassel DE73 11 4.42
DE73,12 Kassel DE73 12 1.25

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