climate_data

Average monthly temperature per region.

12 rows where region_id = "AL01"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
AL01,1 Veri AL01 1 1.69
AL01,2 Veri AL01 2 2.82
AL01,3 Veri AL01 3 6.3
AL01,4 Veri AL01 4 10.63
AL01,5 Veri AL01 5 15.4
AL01,6 Veri AL01 6 19.62
AL01,7 Veri AL01 7 22.19
AL01,8 Veri AL01 8 22.58
AL01,9 Veri AL01 9 17.69
AL01,10 Veri AL01 10 13.12
AL01,11 Veri AL01 11 8.02
AL01,12 Veri AL01 12 3.25

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