climate_data

Average monthly temperature per region.

12 rows where region_id = "DE26"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DE26,1 Unterfranken DE26 1 0.94
DE26,2 Unterfranken DE26 2 1.63
DE26,3 Unterfranken DE26 3 5.12
DE26,4 Unterfranken DE26 4 9.51
DE26,5 Unterfranken DE26 5 13.71
DE26,6 Unterfranken DE26 6 17.04
DE26,7 Unterfranken DE26 7 19.11
DE26,8 Unterfranken DE26 8 18.94
DE26,9 Unterfranken DE26 9 14.63
DE26,10 Unterfranken DE26 10 9.89
DE26,11 Unterfranken DE26 11 4.96
DE26,12 Unterfranken DE26 12 1.8

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