climate_data

Average monthly temperature per region.

12 rows where region_id = "AL03"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
AL03,1 Jug AL03 1 0.66
AL03,2 Jug AL03 2 1.57
AL03,3 Jug AL03 3 4.68
AL03,4 Jug AL03 4 8.49
AL03,5 Jug AL03 5 13.24
AL03,6 Jug AL03 6 17.53
AL03,7 Jug AL03 7 20.22
AL03,8 Jug AL03 8 20.5
AL03,9 Jug AL03 9 15.79
AL03,10 Jug AL03 10 11.35
AL03,11 Jug AL03 11 6.32
AL03,12 Jug AL03 12 1.78

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