climate_data

Average monthly temperature per region.

12 rows where region_id = "DE93"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DE93,1 Lüneburg DE93 1 1.39
DE93,2 Lüneburg DE93 2 1.9
DE93,3 Lüneburg DE93 3 4.57
DE93,4 Lüneburg DE93 4 8.96
DE93,5 Lüneburg DE93 5 13.17
DE93,6 Lüneburg DE93 6 16.21
DE93,7 Lüneburg DE93 7 18.35
DE93,8 Lüneburg DE93 8 18.1
DE93,9 Lüneburg DE93 9 14.41
DE93,10 Lüneburg DE93 10 9.93
DE93,11 Lüneburg DE93 11 5.33
DE93,12 Lüneburg DE93 12 2.36

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