climate_data

Average monthly temperature per region.

12 rows where region_id = "AT34"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
AT34,1 Vorarlberg AT34 1 -3.79
AT34,2 Vorarlberg AT34 2 -2.31
AT34,3 Vorarlberg AT34 3 1.32
AT34,4 Vorarlberg AT34 4 4.76
AT34,5 Vorarlberg AT34 5 9.31
AT34,6 Vorarlberg AT34 6 13.6
AT34,7 Vorarlberg AT34 7 15.47
AT34,8 Vorarlberg AT34 8 15.43
AT34,9 Vorarlberg AT34 9 11.57
AT34,10 Vorarlberg AT34 10 7.69
AT34,11 Vorarlberg AT34 11 1.59
AT34,12 Vorarlberg AT34 12 -2.94

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