climate_data

Average monthly temperature per region.

12 rows where region_id = "CZ01"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
CZ01,1 Praha CZ01 1 0.13
CZ01,2 Praha CZ01 2 1.16
CZ01,3 Praha CZ01 3 4.75
CZ01,4 Praha CZ01 4 9.72
CZ01,5 Praha CZ01 5 14.39
CZ01,6 Praha CZ01 6 17.94
CZ01,7 Praha CZ01 7 19.99
CZ01,8 Praha CZ01 8 19.9
CZ01,9 Praha CZ01 9 15.15
CZ01,10 Praha CZ01 10 10.02
CZ01,11 Praha CZ01 11 4.92
CZ01,12 Praha CZ01 12 1.28

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