climate_data

Average monthly temperature per region.

12 rows where region_id = "DE40"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DE40,1 Brandenburg DE40 1 0.77
DE40,2 Brandenburg DE40 2 1.37
DE40,3 Brandenburg DE40 3 4.06
DE40,4 Brandenburg DE40 4 8.64
DE40,5 Brandenburg DE40 5 13.12
DE40,6 Brandenburg DE40 6 16.34
DE40,7 Brandenburg DE40 7 18.51
DE40,8 Brandenburg DE40 8 18.27
DE40,9 Brandenburg DE40 9 14.3
DE40,10 Brandenburg DE40 10 9.61
DE40,11 Brandenburg DE40 11 4.86
DE40,12 Brandenburg DE40 12 1.78

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