climate_data

Average monthly temperature per region.

12 rows where region_id = "DE12"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DE12,1 Karlsruhe DE12 1 1.85
DE12,2 Karlsruhe DE12 2 2.62
DE12,3 Karlsruhe DE12 3 6.13
DE12,4 Karlsruhe DE12 4 10.18
DE12,5 Karlsruhe DE12 5 14.3
DE12,6 Karlsruhe DE12 6 17.79
DE12,7 Karlsruhe DE12 7 19.88
DE12,8 Karlsruhe DE12 8 19.71
DE12,9 Karlsruhe DE12 9 15.44
DE12,10 Karlsruhe DE12 10 10.99
DE12,11 Karlsruhe DE12 11 5.98
DE12,12 Karlsruhe DE12 12 2.81

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