climate_data

Average monthly temperature per region.

12 rows where region_id = "DK02"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DK02,1 Sjælland DK02 1 1.17
DK02,2 Sjælland DK02 2 1.32
DK02,3 Sjælland DK02 3 3.24
DK02,4 Sjælland DK02 4 7.3
DK02,5 Sjælland DK02 5 11.71
DK02,6 Sjælland DK02 6 15.14
DK02,7 Sjælland DK02 7 17.62
DK02,8 Sjælland DK02 8 17.51
DK02,9 Sjælland DK02 9 14.01
DK02,10 Sjælland DK02 10 9.62
DK02,11 Sjælland DK02 11 5.46
DK02,12 Sjælland DK02 12 2.44

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