climate_data

Average monthly temperature per region.

12 rows where region_id = "CZ08"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
CZ08,1 Moravskoslezsko CZ08 1 -1.96
CZ08,2 Moravskoslezsko CZ08 2 -0.73
CZ08,3 Moravskoslezsko CZ08 3 2.85
CZ08,4 Moravskoslezsko CZ08 4 8.21
CZ08,5 Moravskoslezsko CZ08 5 12.91
CZ08,6 Moravskoslezsko CZ08 6 16.47
CZ08,7 Moravskoslezsko CZ08 7 18.45
CZ08,8 Moravskoslezsko CZ08 8 18.37
CZ08,9 Moravskoslezsko CZ08 9 13.61
CZ08,10 Moravskoslezsko CZ08 10 8.81
CZ08,11 Moravskoslezsko CZ08 11 4.04
CZ08,12 Moravskoslezsko CZ08 12 -0.66

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