climate_data
12 rows where region_id = "CH05"
This data as json, CSV (advanced)
| Link | region_id | month | avg_temp |
|---|---|---|---|
| CH05,1 | Ostschweiz CH05 | 1 | -7.96 |
| CH05,2 | Ostschweiz CH05 | 2 | -6.58 |
| CH05,3 | Ostschweiz CH05 | 3 | -2.6 |
| CH05,4 | Ostschweiz CH05 | 4 | 0.99 |
| CH05,5 | Ostschweiz CH05 | 5 | 5.33 |
| CH05,6 | Ostschweiz CH05 | 6 | 10.0 |
| CH05,7 | Ostschweiz CH05 | 7 | 12.08 |
| CH05,8 | Ostschweiz CH05 | 8 | 12.01 |
| CH05,9 | Ostschweiz CH05 | 9 | 7.89 |
| CH05,10 | Ostschweiz CH05 | 10 | 3.66 |
| CH05,11 | Ostschweiz CH05 | 11 | -2.27 |
| CH05,12 | Ostschweiz CH05 | 12 | -7.06 |
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)
);