climate_data

Average monthly temperature per region.

12 rows where region_id = "AT22"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
AT22,1 Steiermark AT22 1 -2.57
AT22,2 Steiermark AT22 2 -1.01
AT22,3 Steiermark AT22 3 2.96
AT22,4 Steiermark AT22 4 7.82
AT22,5 Steiermark AT22 5 12.35
AT22,6 Steiermark AT22 6 16.02
AT22,7 Steiermark AT22 7 17.79
AT22,8 Steiermark AT22 8 17.58
AT22,9 Steiermark AT22 9 12.97
AT22,10 Steiermark AT22 10 8.31
AT22,11 Steiermark AT22 11 3.28
AT22,12 Steiermark AT22 12 -1.62

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