climate_data
12 rows where region_id = "BE25"
This data as json, CSV (advanced)
| Link | region_id | month | avg_temp |
|---|---|---|---|
| BE25,1 | Prov. West-Vlaanderen BE25 | 1 | 4.14 |
| BE25,2 | Prov. West-Vlaanderen BE25 | 2 | 4.54 |
| BE25,3 | Prov. West-Vlaanderen BE25 | 3 | 6.82 |
| BE25,4 | Prov. West-Vlaanderen BE25 | 4 | 9.69 |
| BE25,5 | Prov. West-Vlaanderen BE25 | 5 | 13.17 |
| BE25,6 | Prov. West-Vlaanderen BE25 | 6 | 15.98 |
| BE25,7 | Prov. West-Vlaanderen BE25 | 7 | 18.12 |
| BE25,8 | Prov. West-Vlaanderen BE25 | 8 | 18.04 |
| BE25,9 | Prov. West-Vlaanderen BE25 | 9 | 15.31 |
| BE25,10 | Prov. West-Vlaanderen BE25 | 10 | 11.75 |
| BE25,11 | Prov. West-Vlaanderen BE25 | 11 | 7.71 |
| BE25,12 | Prov. West-Vlaanderen BE25 | 12 | 4.74 |
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)
);