climate_data

Average monthly temperature per region.

12 rows where region_id = "EL54"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
EL54,1 Ipeiros EL54 1 1.5
EL54,2 Ipeiros EL54 2 2.43
EL54,3 Ipeiros EL54 3 5.39
EL54,4 Ipeiros EL54 4 9.32
EL54,5 Ipeiros EL54 5 14.12
EL54,6 Ipeiros EL54 6 18.86
EL54,7 Ipeiros EL54 7 21.87
EL54,8 Ipeiros EL54 8 21.93
EL54,9 Ipeiros EL54 9 16.92
EL54,10 Ipeiros EL54 10 12.15
EL54,11 Ipeiros EL54 11 7.16
EL54,12 Ipeiros EL54 12 2.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)
  );