climate_data

Average monthly temperature per region.

12 rows where region_id = "DEB2"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DEB2,1 Trier DEB2 1 1.09
DEB2,2 Trier DEB2 2 1.51
DEB2,3 Trier DEB2 3 4.62
DEB2,4 Trier DEB2 4 8.32
DEB2,5 Trier DEB2 5 12.32
DEB2,6 Trier DEB2 6 15.56
DEB2,7 Trier DEB2 7 17.65
DEB2,8 Trier DEB2 8 17.36
DEB2,9 Trier DEB2 9 13.57
DEB2,10 Trier DEB2 10 9.39
DEB2,11 Trier DEB2 11 4.9
DEB2,12 Trier DEB2 12 1.87

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