observation

5 rows where name_sv = "över 23°C" and unit = 41601

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
5016 41601 swimming_water_temperature 2019-08-02T11:04:12.415904+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10230 41601 swimming_water_temperature 2020-06-26T10:45:43.032483+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10325 41601 swimming_water_temperature 2020-06-27T10:46:29.040693+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10397 41601 swimming_water_temperature 2020-06-28T10:21:45.738030+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10474 41601 swimming_water_temperature 2020-06-29T10:01:13.601517+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [observation] (
   [unit] INTEGER,
   [id] INTEGER PRIMARY KEY,
   [property] TEXT,
   [time] TEXT,
   [expiration_time] TEXT,
   [value_fi] TEXT,
   [name_fi] TEXT,
   [value_sv] TEXT,
   [name_sv] TEXT,
   [primary] INTEGER,
   [name_en] TEXT,
   [value] TEXT,
   [quality] TEXT,
   [value_en] TEXT
);