climate_data

Average monthly temperature per region.

12 rows where region_id = "AL02"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
AL02,1 Qender AL02 1 3.49
AL02,2 Qender AL02 2 4.66
AL02,3 Qender AL02 3 7.96
AL02,4 Qender AL02 4 11.84
AL02,5 Qender AL02 5 16.46
AL02,6 Qender AL02 6 20.72
AL02,7 Qender AL02 7 23.4
AL02,8 Qender AL02 8 23.73
AL02,9 Qender AL02 9 19.05
AL02,10 Qender AL02 10 14.52
AL02,11 Qender AL02 11 9.5
AL02,12 Qender AL02 12 4.87

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