climate_data

Average monthly temperature per region.

12 rows where region_id = "BE35"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
BE35,1 Prov. Namur BE35 1 2.55
BE35,2 Prov. Namur BE35 2 2.98
BE35,3 Prov. Namur BE35 3 5.75
BE35,4 Prov. Namur BE35 4 8.97
BE35,5 Prov. Namur BE35 5 12.67
BE35,6 Prov. Namur BE35 6 15.66
BE35,7 Prov. Namur BE35 7 17.71
BE35,8 Prov. Namur BE35 8 17.54
BE35,9 Prov. Namur BE35 9 14.28
BE35,10 Prov. Namur BE35 10 10.62
BE35,11 Prov. Namur BE35 11 6.29
BE35,12 Prov. Namur BE35 12 3.3

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