climate_data

Average monthly temperature per region.

12 rows where region_id = "BG41"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
BG41,1 Yugozapaden BG41 1 -1.84
BG41,2 Yugozapaden BG41 2 -0.59
BG41,3 Yugozapaden BG41 3 2.85
BG41,4 Yugozapaden BG41 4 7.45
BG41,5 Yugozapaden BG41 5 12.55
BG41,6 Yugozapaden BG41 6 16.48
BG41,7 Yugozapaden BG41 7 18.53
BG41,8 Yugozapaden BG41 8 18.71
BG41,9 Yugozapaden BG41 9 14.44
BG41,10 Yugozapaden BG41 10 9.67
BG41,11 Yugozapaden BG41 11 4.33
BG41,12 Yugozapaden BG41 12 -0.37

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