climate_data

Average monthly temperature per region.

12 rows where region_id = "AT32"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
AT32,1 Salzburg AT32 1 -5.14
AT32,2 Salzburg AT32 2 -3.55
AT32,3 Salzburg AT32 3 0.09
AT32,4 Salzburg AT32 4 3.81
AT32,5 Salzburg AT32 5 8.68
AT32,6 Salzburg AT32 6 12.79
AT32,7 Salzburg AT32 7 14.6
AT32,8 Salzburg AT32 8 14.57
AT32,9 Salzburg AT32 9 10.37
AT32,10 Salzburg AT32 10 6.05
AT32,11 Salzburg AT32 11 0.36
AT32,12 Salzburg AT32 12 -4.03

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE climate_data (
    region_id TEXT,
    month INTEGER,
    avg_temp REAL,
    PRIMARY KEY (region_id, month),
    FOREIGN KEY (region_id) REFERENCES regions(id)
  );