climate_data

Average monthly temperature per region.

12 rows where region_id = "DE30"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DE30,1 Berlin DE30 1 0.73
DE30,2 Berlin DE30 2 1.58
DE30,3 Berlin DE30 3 4.46
DE30,4 Berlin DE30 4 9.4
DE30,5 Berlin DE30 5 14.12
DE30,6 Berlin DE30 6 17.53
DE30,7 Berlin DE30 7 19.61
DE30,8 Berlin DE30 8 19.48
DE30,9 Berlin DE30 9 15.1
DE30,10 Berlin DE30 10 10.11
DE30,11 Berlin DE30 11 5.14
DE30,12 Berlin DE30 12 1.91

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