climate_data

Average monthly temperature per region.

12 rows where region_id = "EL43"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
EL43,1 Kriti EL43 1 2.72
EL43,2 Kriti EL43 2 2.84
EL43,3 Kriti EL43 3 5.11
EL43,4 Kriti EL43 4 8.33
EL43,5 Kriti EL43 5 12.88
EL43,6 Kriti EL43 6 17.02
EL43,7 Kriti EL43 7 19.11
EL43,8 Kriti EL43 8 18.96
EL43,9 Kriti EL43 9 16.21
EL43,10 Kriti EL43 10 12.41
EL43,11 Kriti EL43 11 8.05
EL43,12 Kriti EL43 12 4.33

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