climate_data

Average monthly temperature per region.

12 rows where region_id = "DE24"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DE24,1 Oberfranken DE24 1 -0.01
DE24,2 Oberfranken DE24 2 0.67
DE24,3 Oberfranken DE24 3 4.32
DE24,4 Oberfranken DE24 4 9.03
DE24,5 Oberfranken DE24 5 13.4
DE24,6 Oberfranken DE24 6 16.68
DE24,7 Oberfranken DE24 7 18.66
DE24,8 Oberfranken DE24 8 18.47
DE24,9 Oberfranken DE24 9 14.08
DE24,10 Oberfranken DE24 10 9.36
DE24,11 Oberfranken DE24 11 4.38
DE24,12 Oberfranken DE24 12 1.05

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