climate_data
12 rows where region_id = "EL62"
This data as json, CSV (advanced)
| Link | region_id | month | avg_temp |
|---|---|---|---|
| EL62,1 | Ionia Nisia EL62 | 1 | 7.75 |
| EL62,2 | Ionia Nisia EL62 | 2 | 7.67 |
| EL62,3 | Ionia Nisia EL62 | 3 | 9.08 |
| EL62,4 | Ionia Nisia EL62 | 4 | 11.32 |
| EL62,5 | Ionia Nisia EL62 | 5 | 14.96 |
| EL62,6 | Ionia Nisia EL62 | 6 | 18.84 |
| EL62,7 | Ionia Nisia EL62 | 7 | 21.2 |
| EL62,8 | Ionia Nisia EL62 | 8 | 22.03 |
| EL62,9 | Ionia Nisia EL62 | 9 | 19.39 |
| EL62,10 | Ionia Nisia EL62 | 10 | 16.26 |
| EL62,11 | Ionia Nisia EL62 | 11 | 12.67 |
| EL62,12 | Ionia Nisia EL62 | 12 | 9.24 |
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)
);