climate_data

Average monthly temperature per region.

12 rows where region_id = "AT31"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
AT31,1 Oberösterreich AT31 1 -0.38
AT31,2 Oberösterreich AT31 2 0.91
AT31,3 Oberösterreich AT31 3 4.83
AT31,4 Oberösterreich AT31 4 9.58
AT31,5 Oberösterreich AT31 5 14.0
AT31,6 Oberösterreich AT31 6 17.57
AT31,7 Oberösterreich AT31 7 19.32
AT31,8 Oberösterreich AT31 8 19.21
AT31,9 Oberösterreich AT31 9 14.62
AT31,10 Oberösterreich AT31 10 9.91
AT31,11 Oberösterreich AT31 11 4.61
AT31,12 Oberösterreich AT31 12 0.64

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