climate_data

Average monthly temperature per region.

12 rows where region_id = "DEB1"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DEB1,1 Koblenz DEB1 1 0.64
DEB1,2 Koblenz DEB1 2 1.17
DEB1,3 Koblenz DEB1 3 4.31
DEB1,4 Koblenz DEB1 4 8.21
DEB1,5 Koblenz DEB1 5 12.24
DEB1,6 Koblenz DEB1 6 15.52
DEB1,7 Koblenz DEB1 7 17.61
DEB1,8 Koblenz DEB1 8 17.4
DEB1,9 Koblenz DEB1 9 13.47
DEB1,10 Koblenz DEB1 10 9.11
DEB1,11 Koblenz DEB1 11 4.59
DEB1,12 Koblenz DEB1 12 1.46

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