climate_data

Average monthly temperature per region.

12 rows where region_id = "DE60"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DE60,1 Hamburg DE60 1 1.84
DE60,2 Hamburg DE60 2 2.26
DE60,3 Hamburg DE60 3 4.72
DE60,4 Hamburg DE60 4 9.03
DE60,5 Hamburg DE60 5 13.22
DE60,6 Hamburg DE60 6 16.29
DE60,7 Hamburg DE60 7 18.46
DE60,8 Hamburg DE60 8 18.26
DE60,9 Hamburg DE60 9 14.69
DE60,10 Hamburg DE60 10 10.24
DE60,11 Hamburg DE60 11 5.71
DE60,12 Hamburg DE60 12 2.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)
  );