climate_data

Average monthly temperature per region.

12 rows where region_id = "AT33"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
AT33,1 Tirol AT33 1 -4.93
AT33,2 Tirol AT33 2 -3.22
AT33,3 Tirol AT33 3 0.74
AT33,4 Tirol AT33 4 4.32
AT33,5 Tirol AT33 5 8.7
AT33,6 Tirol AT33 6 12.98
AT33,7 Tirol AT33 7 15.01
AT33,8 Tirol AT33 8 14.91
AT33,9 Tirol AT33 9 10.85
AT33,10 Tirol AT33 10 6.69
AT33,11 Tirol AT33 11 0.46
AT33,12 Tirol AT33 12 -4.12

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