climate_data

Average monthly temperature per region.

12 rows where region_id = "DE13"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DE13,1 Freiburg DE13 1 -1.48
DE13,2 Freiburg DE13 2 -0.98
DE13,3 Freiburg DE13 3 2.46
DE13,4 Freiburg DE13 4 6.54
DE13,5 Freiburg DE13 5 10.66
DE13,6 Freiburg DE13 6 14.16
DE13,7 Freiburg DE13 7 16.05
DE13,8 Freiburg DE13 8 15.99
DE13,9 Freiburg DE13 9 12.01
DE13,10 Freiburg DE13 10 8.04
DE13,11 Freiburg DE13 11 2.86
DE13,12 Freiburg DE13 12 -0.45

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