climate_data

Average monthly temperature per region.

12 rows where region_id = "EL62"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
EL62,1 Ionia Nisia EL62 1 7.75
EL62,2 Ionia Nisia EL62 2 7.67
EL62,3 Ionia Nisia EL62 3 9.08
EL62,4 Ionia Nisia EL62 4 11.32
EL62,5 Ionia Nisia EL62 5 14.96
EL62,6 Ionia Nisia EL62 6 18.84
EL62,7 Ionia Nisia EL62 7 21.2
EL62,8 Ionia Nisia EL62 8 22.03
EL62,9 Ionia Nisia EL62 9 19.39
EL62,10 Ionia Nisia EL62 10 16.26
EL62,11 Ionia Nisia EL62 11 12.67
EL62,12 Ionia Nisia EL62 12 9.24

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