climate_data

Average monthly temperature per region.

12 rows where region_id = "AT13"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: avg_temp

Link region_id month avg_temp
AT13,1 Wien AT13 1 0.17
AT13,2 Wien AT13 2 1.66
AT13,3 Wien AT13 3 5.63
AT13,4 Wien AT13 4 10.81
AT13,5 Wien AT13 5 15.44
AT13,6 Wien AT13 6 19.26
AT13,7 Wien AT13 7 21.32
AT13,8 Wien AT13 8 21.04
AT13,9 Wien AT13 9 16.06
AT13,10 Wien AT13 10 10.81
AT13,11 Wien AT13 11 5.7
AT13,12 Wien AT13 12 1.07

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