climate_data

Average monthly temperature per region.

12 rows where region_id = "EL61"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
EL61,1 Thessalia EL61 1 2.52
EL61,2 Thessalia EL61 2 3.79
EL61,3 Thessalia EL61 3 6.86
EL61,4 Thessalia EL61 4 11.09
EL61,5 Thessalia EL61 5 16.48
EL61,6 Thessalia EL61 6 21.78
EL61,7 Thessalia EL61 7 24.25
EL61,8 Thessalia EL61 8 23.86
EL61,9 Thessalia EL61 9 19.01
EL61,10 Thessalia EL61 10 13.78
EL61,11 Thessalia EL61 11 8.4
EL61,12 Thessalia EL61 12 3.77

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