climate_data

Average monthly temperature per region.

12 rows where region_id = "AT11"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
AT11,1 Burgenland AT11 1 -0.49
AT11,2 Burgenland AT11 2 1.13
AT11,3 Burgenland AT11 3 5.32
AT11,4 Burgenland AT11 4 10.54
AT11,5 Burgenland AT11 5 15.06
AT11,6 Burgenland AT11 6 18.83
AT11,7 Burgenland AT11 7 20.72
AT11,8 Burgenland AT11 8 20.47
AT11,9 Burgenland AT11 9 15.58
AT11,10 Burgenland AT11 10 10.48
AT11,11 Burgenland AT11 11 5.31
AT11,12 Burgenland AT11 12 0.3

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