climate_data

Average monthly temperature per region.

12 rows where region_id = "BG32"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
BG32,1 Severen tsentralen BG32 1 0.31
BG32,2 Severen tsentralen BG32 2 2.36
BG32,3 Severen tsentralen BG32 3 6.66
BG32,4 Severen tsentralen BG32 4 11.98
BG32,5 Severen tsentralen BG32 5 17.07
BG32,6 Severen tsentralen BG32 6 21.01
BG32,7 Severen tsentralen BG32 7 23.2
BG32,8 Severen tsentralen BG32 8 23.36
BG32,9 Severen tsentralen BG32 9 18.55
BG32,10 Severen tsentralen BG32 10 12.88
BG32,11 Severen tsentralen BG32 11 7.26
BG32,12 Severen tsentralen BG32 12 1.97

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