climate_data

Average monthly temperature per region.

12 rows where region_id = "AT12"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
AT12,1 Niederösterreich AT12 1 -0.27
AT12,2 Niederösterreich AT12 2 1.11
AT12,3 Niederösterreich AT12 3 5.09
AT12,4 Niederösterreich AT12 4 10.24
AT12,5 Niederösterreich AT12 5 14.74
AT12,6 Niederösterreich AT12 6 18.44
AT12,7 Niederösterreich AT12 7 20.35
AT12,8 Niederösterreich AT12 8 20.14
AT12,9 Niederösterreich AT12 9 15.28
AT12,10 Niederösterreich AT12 10 10.08
AT12,11 Niederösterreich AT12 11 4.96
AT12,12 Niederösterreich AT12 12 0.65

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