climate_data

Average monthly temperature per region.

12 rows where region_id = "BE22"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
BE22,1 Prov. Limburg (BE) BE22 1 3.26
BE22,2 Prov. Limburg (BE) BE22 2 3.76
BE22,3 Prov. Limburg (BE) BE22 3 6.47
BE22,4 Prov. Limburg (BE) BE22 4 9.92
BE22,5 Prov. Limburg (BE) BE22 5 13.81
BE22,6 Prov. Limburg (BE) BE22 6 16.77
BE22,7 Prov. Limburg (BE) BE22 7 18.82
BE22,8 Prov. Limburg (BE) BE22 8 18.5
BE22,9 Prov. Limburg (BE) BE22 9 15.2
BE22,10 Prov. Limburg (BE) BE22 10 11.35
BE22,11 Prov. Limburg (BE) BE22 11 7.01
BE22,12 Prov. Limburg (BE) BE22 12 4.0

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