climate_data

Average monthly temperature per region.

12 rows where region_id = "DE71"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DE71,1 Darmstadt DE71 1 1.66
DE71,2 Darmstadt DE71 2 2.37
DE71,3 Darmstadt DE71 3 5.77
DE71,4 Darmstadt DE71 4 9.92
DE71,5 Darmstadt DE71 5 14.15
DE71,6 Darmstadt DE71 6 17.59
DE71,7 Darmstadt DE71 7 19.74
DE71,8 Darmstadt DE71 8 19.56
DE71,9 Darmstadt DE71 9 15.28
DE71,10 Darmstadt DE71 10 10.48
DE71,11 Darmstadt DE71 11 5.67
DE71,12 Darmstadt DE71 12 2.49

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