climate_data
12 rows where region_id = "DE11"
This data as json, CSV (advanced)
| Link | region_id | month | avg_temp |
|---|---|---|---|
| DE11,1 | Stuttgart DE11 | 1 | -0.03 |
| DE11,2 | Stuttgart DE11 | 2 | 0.58 |
| DE11,3 | Stuttgart DE11 | 3 | 4.19 |
| DE11,4 | Stuttgart DE11 | 4 | 8.39 |
| DE11,5 | Stuttgart DE11 | 5 | 12.65 |
| DE11,6 | Stuttgart DE11 | 6 | 16.05 |
| DE11,7 | Stuttgart DE11 | 7 | 18.06 |
| DE11,8 | Stuttgart DE11 | 8 | 17.95 |
| DE11,9 | Stuttgart DE11 | 9 | 13.66 |
| DE11,10 | Stuttgart DE11 | 10 | 9.24 |
| DE11,11 | Stuttgart DE11 | 11 | 4.18 |
| DE11,12 | Stuttgart DE11 | 12 | 0.99 |
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)
);