climate_data

Average monthly temperature per region.

12 rows where region_id = "DE22"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DE22,1 Niederbayern DE22 1 0.04
DE22,2 Niederbayern DE22 2 1.16
DE22,3 Niederbayern DE22 3 5.01
DE22,4 Niederbayern DE22 4 9.61
DE22,5 Niederbayern DE22 5 14.15
DE22,6 Niederbayern DE22 6 17.58
DE22,7 Niederbayern DE22 7 19.38
DE22,8 Niederbayern DE22 8 19.28
DE22,9 Niederbayern DE22 9 14.68
DE22,10 Niederbayern DE22 10 9.87
DE22,11 Niederbayern DE22 11 4.6
DE22,12 Niederbayern DE22 12 0.95

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