climate_data

Average monthly temperature per region.

12 rows where region_id = "DE72"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DE72,1 Gießen DE72 1 1.17
DE72,2 Gießen DE72 2 1.73
DE72,3 Gießen DE72 3 4.92
DE72,4 Gießen DE72 4 8.98
DE72,5 Gießen DE72 5 13.09
DE72,6 Gießen DE72 6 16.37
DE72,7 Gießen DE72 7 18.46
DE72,8 Gießen DE72 8 18.22
DE72,9 Gießen DE72 9 14.23
DE72,10 Gießen DE72 10 9.66
DE72,11 Gießen DE72 11 5.1
DE72,12 Gießen DE72 12 1.94

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