climate_data

Average monthly temperature per region.

12 rows where region_id = "BE21"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
BE21,1 Prov. Antwerpen BE21 1 3.61
BE21,2 Prov. Antwerpen BE21 2 4.04
BE21,3 Prov. Antwerpen BE21 3 6.67
BE21,4 Prov. Antwerpen BE21 4 9.98
BE21,5 Prov. Antwerpen BE21 5 13.74
BE21,6 Prov. Antwerpen BE21 6 16.59
BE21,7 Prov. Antwerpen BE21 7 18.63
BE21,8 Prov. Antwerpen BE21 8 18.38
BE21,9 Prov. Antwerpen BE21 9 15.31
BE21,10 Prov. Antwerpen BE21 10 11.52
BE21,11 Prov. Antwerpen BE21 11 7.29
BE21,12 Prov. Antwerpen BE21 12 4.27

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