climate_data

Average monthly temperature per region.

12 rows where region_id = "EL30"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
EL30,1 Attiki EL30 1 7.63
EL30,2 Attiki EL30 2 8.3
EL30,3 Attiki EL30 3 10.67
EL30,4 Attiki EL30 4 14.32
EL30,5 Attiki EL30 5 19.49
EL30,6 Attiki EL30 6 24.44
EL30,7 Attiki EL30 7 26.84
EL30,8 Attiki EL30 8 26.59
EL30,9 Attiki EL30 9 22.56
EL30,10 Attiki EL30 10 17.94
EL30,11 Attiki EL30 11 13.21
EL30,12 Attiki EL30 12 9.2

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