climate_data

Average monthly temperature per region.

12 rows where region_id = "BG33"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
BG33,1 Severoiztochen BG33 1 0.57
BG33,2 Severoiztochen BG33 2 2.14
BG33,3 Severoiztochen BG33 3 5.77
BG33,4 Severoiztochen BG33 4 10.64
BG33,5 Severoiztochen BG33 5 15.92
BG33,6 Severoiztochen BG33 6 20.1
BG33,7 Severoiztochen BG33 7 22.41
BG33,8 Severoiztochen BG33 8 22.46
BG33,9 Severoiztochen BG33 9 17.8
BG33,10 Severoiztochen BG33 10 12.43
BG33,11 Severoiztochen BG33 11 7.19
BG33,12 Severoiztochen BG33 12 2.11

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