climate_data

Average monthly temperature per region.

12 rows where region_id = "DK01"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DK01,1 Hovedstaden DK01 1 1.0
DK01,2 Hovedstaden DK01 2 1.06
DK01,3 Hovedstaden DK01 3 2.93
DK01,4 Hovedstaden DK01 4 7.12
DK01,5 Hovedstaden DK01 5 11.67
DK01,6 Hovedstaden DK01 6 15.11
DK01,7 Hovedstaden DK01 7 17.48
DK01,8 Hovedstaden DK01 8 17.26
DK01,9 Hovedstaden DK01 9 13.74
DK01,10 Hovedstaden DK01 10 9.33
DK01,11 Hovedstaden DK01 11 5.24
DK01,12 Hovedstaden DK01 12 2.27

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