climate_data

Average monthly temperature per region.

12 rows where region_id = "EL41"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
EL41,1 Voreio Aigaio EL41 1 6.25
EL41,2 Voreio Aigaio EL41 2 6.65
EL41,3 Voreio Aigaio EL41 3 8.53
EL41,4 Voreio Aigaio EL41 4 11.82
EL41,5 Voreio Aigaio EL41 5 16.54
EL41,6 Voreio Aigaio EL41 6 21.23
EL41,7 Voreio Aigaio EL41 7 23.71
EL41,8 Voreio Aigaio EL41 8 23.84
EL41,9 Voreio Aigaio EL41 9 20.14
EL41,10 Voreio Aigaio EL41 10 15.76
EL41,11 Voreio Aigaio EL41 11 11.48
EL41,12 Voreio Aigaio EL41 12 7.84

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