climate_data

Average monthly temperature per region.

12 rows where region_id = "DK05"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DK05,1 Nordjylland DK05 1 1.75
DK05,2 Nordjylland DK05 2 1.63
DK05,3 Nordjylland DK05 3 3.29
DK05,4 Nordjylland DK05 4 7.07
DK05,5 Nordjylland DK05 5 11.23
DK05,6 Nordjylland DK05 6 14.52
DK05,7 Nordjylland DK05 7 16.89
DK05,8 Nordjylland DK05 8 16.79
DK05,9 Nordjylland DK05 9 13.65
DK05,10 Nordjylland DK05 10 9.43
DK05,11 Nordjylland DK05 11 5.6
DK05,12 Nordjylland DK05 12 2.88

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