climate_data

Average monthly temperature per region.

12 rows where region_id = "AT21"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
AT21,1 Kärnten AT21 1 -4.22
AT21,2 Kärnten AT21 2 -2.55
AT21,3 Kärnten AT21 3 1.59
AT21,4 Kärnten AT21 4 6.39
AT21,5 Kärnten AT21 5 10.89
AT21,6 Kärnten AT21 6 14.64
AT21,7 Kärnten AT21 7 16.48
AT21,8 Kärnten AT21 8 16.22
AT21,9 Kärnten AT21 9 11.51
AT21,10 Kärnten AT21 10 6.73
AT21,11 Kärnten AT21 11 1.77
AT21,12 Kärnten AT21 12 -3.4

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)
  );