climate_data

Average monthly temperature per region.

12 rows where region_id = "EL51"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
EL51,1 Anatoliki Makedonia, Thraki EL51 1 2.97
EL51,2 Anatoliki Makedonia, Thraki EL51 2 3.97
EL51,3 Anatoliki Makedonia, Thraki EL51 3 6.78
EL51,4 Anatoliki Makedonia, Thraki EL51 4 11.14
EL51,5 Anatoliki Makedonia, Thraki EL51 5 16.25
EL51,6 Anatoliki Makedonia, Thraki EL51 6 20.74
EL51,7 Anatoliki Makedonia, Thraki EL51 7 23.42
EL51,8 Anatoliki Makedonia, Thraki EL51 8 23.75
EL51,9 Anatoliki Makedonia, Thraki EL51 9 19.18
EL51,10 Anatoliki Makedonia, Thraki EL51 10 13.94
EL51,11 Anatoliki Makedonia, Thraki EL51 11 9.0
EL51,12 Anatoliki Makedonia, Thraki EL51 12 4.42

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