climate_data

Average monthly temperature per region.

12 rows where region_id = "BE32"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
BE32,1 Prov. Hainaut BE32 1 3.49
BE32,2 Prov. Hainaut BE32 2 3.95
BE32,3 Prov. Hainaut BE32 3 6.56
BE32,4 Prov. Hainaut BE32 4 9.66
BE32,5 Prov. Hainaut BE32 5 13.26
BE32,6 Prov. Hainaut BE32 6 16.21
BE32,7 Prov. Hainaut BE32 7 18.28
BE32,8 Prov. Hainaut BE32 8 18.09
BE32,9 Prov. Hainaut BE32 9 15.03
BE32,10 Prov. Hainaut BE32 10 11.38
BE32,11 Prov. Hainaut BE32 11 7.12
BE32,12 Prov. Hainaut BE32 12 4.12

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