climate_data

Average monthly temperature per region.

12 rows where region_id = "BG31"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
BG31,1 Severozapaden BG31 1 -0.63
BG31,2 Severozapaden BG31 2 1.6
BG31,3 Severozapaden BG31 3 6.54
BG31,4 Severozapaden BG31 4 11.99
BG31,5 Severozapaden BG31 5 17.21
BG31,6 Severozapaden BG31 6 21.33
BG31,7 Severozapaden BG31 7 23.68
BG31,8 Severozapaden BG31 8 23.69
BG31,9 Severozapaden BG31 9 18.69
BG31,10 Severozapaden BG31 10 12.74
BG31,11 Severozapaden BG31 11 6.55
BG31,12 Severozapaden BG31 12 0.94

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