climate_data

Average monthly temperature per region.

12 rows where region_id = "DK04"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DK04,1 Midtjylland DK04 1 1.31
DK04,2 Midtjylland DK04 2 1.36
DK04,3 Midtjylland DK04 3 3.14
DK04,4 Midtjylland DK04 4 7.02
DK04,5 Midtjylland DK04 5 11.16
DK04,6 Midtjylland DK04 6 14.2
DK04,7 Midtjylland DK04 7 16.51
DK04,8 Midtjylland DK04 8 16.39
DK04,9 Midtjylland DK04 9 13.2
DK04,10 Midtjylland DK04 10 9.08
DK04,11 Midtjylland DK04 11 5.13
DK04,12 Midtjylland DK04 12 2.35

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