climate_data

Average monthly temperature per region.

12 rows where region_id = "DE92"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DE92,1 Hannover DE92 1 2.06
DE92,2 Hannover DE92 2 2.58
DE92,3 Hannover DE92 3 5.31
DE92,4 Hannover DE92 4 9.44
DE92,5 Hannover DE92 5 13.51
DE92,6 Hannover DE92 6 16.59
DE92,7 Hannover DE92 7 18.8
DE92,8 Hannover DE92 8 18.59
DE92,9 Hannover DE92 9 14.92
DE92,10 Hannover DE92 10 10.54
DE92,11 Hannover DE92 11 6.05
DE92,12 Hannover DE92 12 3.0

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