climate_data

Average monthly temperature per region.

12 rows where region_id = "DK03"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DK03,1 Syddanmark DK03 1 1.75
DK03,2 Syddanmark DK03 2 1.79
DK03,3 Syddanmark DK03 3 3.61
DK03,4 Syddanmark DK03 4 7.48
DK03,5 Syddanmark DK03 5 11.59
DK03,6 Syddanmark DK03 6 14.58
DK03,7 Syddanmark DK03 7 16.91
DK03,8 Syddanmark DK03 8 16.86
DK03,9 Syddanmark DK03 9 13.77
DK03,10 Syddanmark DK03 10 9.69
DK03,11 Syddanmark DK03 11 5.62
DK03,12 Syddanmark DK03 12 2.82

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