climate_data

Average monthly temperature per region.

12 rows where region_id = "DEC0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DEC0,1 Saarland DEC0 1 1.29
DEC0,2 Saarland DEC0 2 1.92
DEC0,3 Saarland DEC0 3 5.23
DEC0,4 Saarland DEC0 4 9.09
DEC0,5 Saarland DEC0 5 13.11
DEC0,6 Saarland DEC0 6 16.47
DEC0,7 Saarland DEC0 7 18.56
DEC0,8 Saarland DEC0 8 18.35
DEC0,9 Saarland DEC0 9 14.29
DEC0,10 Saarland DEC0 10 9.99
DEC0,11 Saarland DEC0 11 5.27
DEC0,12 Saarland DEC0 12 2.18

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