climate_data

Average monthly temperature per region.

12 rows where region_id = "CY00"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
CY00,1 Kýpros CY00 1 9.29
CY00,2 Kýpros CY00 2 9.86
CY00,3 Kýpros CY00 3 12.64
CY00,4 Kýpros CY00 4 16.64
CY00,5 Kýpros CY00 5 21.5
CY00,6 Kýpros CY00 6 26.3
CY00,7 Kýpros CY00 7 29.45
CY00,8 Kýpros CY00 8 29.21
CY00,9 Kýpros CY00 9 25.67
CY00,10 Kýpros CY00 10 20.99
CY00,11 Kýpros CY00 11 15.29
CY00,12 Kýpros CY00 12 11.11

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