climate_data

Average monthly temperature per region.

12 rows where region_id = "EL52"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
EL52,1 Kentriki Makedonia EL52 1 3.35
EL52,2 Kentriki Makedonia EL52 2 5.21
EL52,3 Kentriki Makedonia EL52 3 8.63
EL52,4 Kentriki Makedonia EL52 4 13.08
EL52,5 Kentriki Makedonia EL52 5 18.47
EL52,6 Kentriki Makedonia EL52 6 23.32
EL52,7 Kentriki Makedonia EL52 7 25.79
EL52,8 Kentriki Makedonia EL52 8 25.68
EL52,9 Kentriki Makedonia EL52 9 20.77
EL52,10 Kentriki Makedonia EL52 10 15.31
EL52,11 Kentriki Makedonia EL52 11 9.61
EL52,12 Kentriki Makedonia EL52 12 4.57

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