climate_data

Average monthly temperature per region.

12 rows where region_id = "DE27"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DE27,1 Schwaben DE27 1 -0.21
DE27,2 Schwaben DE27 2 0.48
DE27,3 Schwaben DE27 3 4.19
DE27,4 Schwaben DE27 4 8.34
DE27,5 Schwaben DE27 5 12.7
DE27,6 Schwaben DE27 6 16.15
DE27,7 Schwaben DE27 7 18.01
DE27,8 Schwaben DE27 8 17.88
DE27,9 Schwaben DE27 9 13.58
DE27,10 Schwaben DE27 10 9.21
DE27,11 Schwaben DE27 11 3.91
DE27,12 Schwaben DE27 12 0.62

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