climate_data

Average monthly temperature per region.

12 rows where region_id = "DE14"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DE14,1 Tübingen DE14 1 -0.29
DE14,2 Tübingen DE14 2 0.4
DE14,3 Tübingen DE14 3 4.26
DE14,4 Tübingen DE14 4 8.47
DE14,5 Tübingen DE14 5 12.76
DE14,6 Tübingen DE14 6 16.25
DE14,7 Tübingen DE14 7 18.11
DE14,8 Tübingen DE14 8 17.97
DE14,9 Tübingen DE14 9 13.68
DE14,10 Tübingen DE14 10 9.21
DE14,11 Tübingen DE14 11 3.91
DE14,12 Tübingen DE14 12 0.56

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