climate_data

Average monthly temperature per region.

12 rows where region_id = "DEB3"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DEB3,1 Rheinhessen-Pfalz DEB3 1 0.82
DEB3,2 Rheinhessen-Pfalz DEB3 2 1.56
DEB3,3 Rheinhessen-Pfalz DEB3 3 4.82
DEB3,4 Rheinhessen-Pfalz DEB3 4 8.8
DEB3,5 Rheinhessen-Pfalz DEB3 5 12.88
DEB3,6 Rheinhessen-Pfalz DEB3 6 16.34
DEB3,7 Rheinhessen-Pfalz DEB3 7 18.47
DEB3,8 Rheinhessen-Pfalz DEB3 8 18.3
DEB3,9 Rheinhessen-Pfalz DEB3 9 14.13
DEB3,10 Rheinhessen-Pfalz DEB3 10 9.62
DEB3,11 Rheinhessen-Pfalz DEB3 11 4.84
DEB3,12 Rheinhessen-Pfalz DEB3 12 1.73

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