observation

7 rows where unit = 40157 and value = "23-100"

✎ View and edit SQL

This data as json, CSV (advanced)

value ✖

  • 23-100 · 7 ✖

unit ✖

  • 40157 · 7 ✖
id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
9731 40157 swimming_water_temperature 2020-06-19T10:05:14.406938+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10023 40157 swimming_water_temperature 2020-06-24T09:51:18.809470+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10113 40157 swimming_water_temperature 2020-06-25T09:52:17.687290+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10196 40157 swimming_water_temperature 2020-06-26T09:53:55.214804+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10306 40157 swimming_water_temperature 2020-06-27T10:00:30.762267+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10385 40157 swimming_water_temperature 2020-06-28T10:06:38.523736+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10473 40157 swimming_water_temperature 2020-06-29T09:56:52.252559+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
);