climate_data

Average monthly temperature per region.

12 rows where region_id = "DE50"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DE50,1 Bremen DE50 1 2.23
DE50,2 Bremen DE50 2 2.66
DE50,3 Bremen DE50 3 5.2
DE50,4 Bremen DE50 4 9.26
DE50,5 Bremen DE50 5 13.2
DE50,6 Bremen DE50 6 16.16
DE50,7 Bremen DE50 7 18.29
DE50,8 Bremen DE50 8 18.1
DE50,9 Bremen DE50 9 14.73
DE50,10 Bremen DE50 10 10.45
DE50,11 Bremen DE50 11 6.04
DE50,12 Bremen DE50 12 3.11

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