observation

13 rows where name_sv = "över 23°C" and unit = 40386

✎ 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
3921 40386 swimming_water_temperature 2019-07-23T14:19:00.682961+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4134 40386 swimming_water_temperature 2019-07-25T10:32:31.324151+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4263 40386 swimming_water_temperature 2019-07-26T10:11:50.996205+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4384 40386 swimming_water_temperature 2019-07-27T09:56:30.238288+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4613 40386 swimming_water_temperature 2019-07-29T10:07:48.223180+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4695 40386 swimming_water_temperature 2019-07-30T10:10:41.020619+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
9948 40386 swimming_water_temperature 2020-06-23T10:57:21.533592+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10133 40386 swimming_water_temperature 2020-06-25T10:03:30.461510+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10211 40386 swimming_water_temperature 2020-06-26T10:10:18.485002+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10312 40386 swimming_water_temperature 2020-06-27T10:14:18.411395+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10395 40386 swimming_water_temperature 2020-06-28T10:20:40.121635+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10476 40386 swimming_water_temperature 2020-06-29T10:07:18.208533+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10531 40386 swimming_water_temperature 2020-06-30T10:07:02.952836+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
);