climate_data
12 rows where region_id = "BE31"
This data as json, CSV (advanced)
| Link | region_id | month | avg_temp |
|---|---|---|---|
| BE31,1 | Prov. Brabant Wallon BE31 | 1 | 3.11 |
| BE31,2 | Prov. Brabant Wallon BE31 | 2 | 3.58 |
| BE31,3 | Prov. Brabant Wallon BE31 | 3 | 6.24 |
| BE31,4 | Prov. Brabant Wallon BE31 | 4 | 9.44 |
| BE31,5 | Prov. Brabant Wallon BE31 | 5 | 13.11 |
| BE31,6 | Prov. Brabant Wallon BE31 | 6 | 16.04 |
| BE31,7 | Prov. Brabant Wallon BE31 | 7 | 18.12 |
| BE31,8 | Prov. Brabant Wallon BE31 | 8 | 17.91 |
| BE31,9 | Prov. Brabant Wallon BE31 | 9 | 14.8 |
| BE31,10 | Prov. Brabant Wallon BE31 | 10 | 11.09 |
| BE31,11 | Prov. Brabant Wallon BE31 | 11 | 6.82 |
| BE31,12 | Prov. Brabant Wallon BE31 | 12 | 3.81 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE climate_data (
region_id TEXT,
month INTEGER,
avg_temp REAL,
PRIMARY KEY (region_id, month),
FOREIGN KEY (region_id) REFERENCES regions(id)
);