climate_data

Average monthly temperature per region.

12 rows where region_id = "BG34"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
BG34,1 Yugoiztochen BG34 1 1.59
BG34,2 Yugoiztochen BG34 2 3.2
BG34,3 Yugoiztochen BG34 3 6.51
BG34,4 Yugoiztochen BG34 4 11.19
BG34,5 Yugoiztochen BG34 5 16.43
BG34,6 Yugoiztochen BG34 6 20.84
BG34,7 Yugoiztochen BG34 7 23.35
BG34,8 Yugoiztochen BG34 8 23.48
BG34,9 Yugoiztochen BG34 9 18.82
BG34,10 Yugoiztochen BG34 10 13.33
BG34,11 Yugoiztochen BG34 11 8.01
BG34,12 Yugoiztochen BG34 12 3.0

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