climate_data

Average monthly temperature per region.

12 rows where region_id = "DE80"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DE80,1 Mecklenburg-Vorpommern DE80 1 0.64
DE80,2 Mecklenburg-Vorpommern DE80 2 1.17
DE80,3 Mecklenburg-Vorpommern DE80 3 3.64
DE80,4 Mecklenburg-Vorpommern DE80 4 8.17
DE80,5 Mecklenburg-Vorpommern DE80 5 12.6
DE80,6 Mecklenburg-Vorpommern DE80 6 15.81
DE80,7 Mecklenburg-Vorpommern DE80 7 18.08
DE80,8 Mecklenburg-Vorpommern DE80 8 17.91
DE80,9 Mecklenburg-Vorpommern DE80 9 14.11
DE80,10 Mecklenburg-Vorpommern DE80 10 9.52
DE80,11 Mecklenburg-Vorpommern DE80 11 4.87
DE80,12 Mecklenburg-Vorpommern DE80 12 1.77

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