climate_data

Average monthly temperature per region.

12 rows where region_id = "DE25"

✎ View and edit SQL

This data as json, CSV (advanced)

Link region_id month avg_temp
DE25,1 Mittelfranken DE25 1 0.16
DE25,2 Mittelfranken DE25 2 0.94
DE25,3 Mittelfranken DE25 3 4.5
DE25,4 Mittelfranken DE25 4 8.92
DE25,5 Mittelfranken DE25 5 13.29
DE25,6 Mittelfranken DE25 6 16.66
DE25,7 Mittelfranken DE25 7 18.67
DE25,8 Mittelfranken DE25 8 18.51
DE25,9 Mittelfranken DE25 9 14.12
DE25,10 Mittelfranken DE25 10 9.46
DE25,11 Mittelfranken DE25 11 4.38
DE25,12 Mittelfranken DE25 12 1.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)
  );