climate_data

Average monthly temperature per region.

12 rows where region_id = "DE91"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DE91,1 Braunschweig DE91 1 1.09
DE91,2 Braunschweig DE91 2 1.67
DE91,3 Braunschweig DE91 3 4.57
DE91,4 Braunschweig DE91 4 8.92
DE91,5 Braunschweig DE91 5 13.06
DE91,6 Braunschweig DE91 6 16.24
DE91,7 Braunschweig DE91 7 18.45
DE91,8 Braunschweig DE91 8 18.3
DE91,9 Braunschweig DE91 9 14.4
DE91,10 Braunschweig DE91 10 9.92
DE91,11 Braunschweig DE91 11 5.3
DE91,12 Braunschweig DE91 12 2.12

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