climate_data
12 rows where region_id = "BE24"
This data as json, CSV (advanced)
| Link | region_id | month | avg_temp |
|---|---|---|---|
| BE24,1 | Prov. Vlaams-Brabant BE24 | 1 | 3.44 |
| BE24,2 | Prov. Vlaams-Brabant BE24 | 2 | 3.9 |
| BE24,3 | Prov. Vlaams-Brabant BE24 | 3 | 6.53 |
| BE24,4 | Prov. Vlaams-Brabant BE24 | 4 | 9.75 |
| BE24,5 | Prov. Vlaams-Brabant BE24 | 5 | 13.47 |
| BE24,6 | Prov. Vlaams-Brabant BE24 | 6 | 16.38 |
| BE24,7 | Prov. Vlaams-Brabant BE24 | 7 | 18.44 |
| BE24,8 | Prov. Vlaams-Brabant BE24 | 8 | 18.21 |
| BE24,9 | Prov. Vlaams-Brabant BE24 | 9 | 15.13 |
| BE24,10 | Prov. Vlaams-Brabant BE24 | 10 | 11.39 |
| BE24,11 | Prov. Vlaams-Brabant BE24 | 11 | 7.13 |
| BE24,12 | Prov. Vlaams-Brabant BE24 | 12 | 4.11 |
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)
);