climate_data

Average monthly temperature per region.

12 rows where region_id = "EL42"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
EL42,1 Notio Aigaio EL42 1 11.1
EL42,2 Notio Aigaio EL42 2 11.11
EL42,3 Notio Aigaio EL42 3 12.63
EL42,4 Notio Aigaio EL42 4 15.06
EL42,5 Notio Aigaio EL42 5 18.95
EL42,6 Notio Aigaio EL42 6 22.86
EL42,7 Notio Aigaio EL42 7 25.31
EL42,8 Notio Aigaio EL42 8 25.89
EL42,9 Notio Aigaio EL42 9 23.53
EL42,10 Notio Aigaio EL42 10 20.1
EL42,11 Notio Aigaio EL42 11 16.1
EL42,12 Notio Aigaio EL42 12 12.7

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