climate_data

Average monthly temperature per region.

12 rows where region_id = "BG42"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
BG42,1 Yuzhen tsentralen BG42 1 -0.08
BG42,2 Yuzhen tsentralen BG42 2 1.48
BG42,3 Yuzhen tsentralen BG42 3 4.81
BG42,4 Yuzhen tsentralen BG42 4 9.53
BG42,5 Yuzhen tsentralen BG42 5 14.54
BG42,6 Yuzhen tsentralen BG42 6 18.62
BG42,7 Yuzhen tsentralen BG42 7 20.88
BG42,8 Yuzhen tsentralen BG42 8 21.03
BG42,9 Yuzhen tsentralen BG42 9 16.65
BG42,10 Yuzhen tsentralen BG42 10 11.46
BG42,11 Yuzhen tsentralen BG42 11 6.28
BG42,12 Yuzhen tsentralen BG42 12 1.47

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