observation

1,261 rows where name_fi = "17-19°C" sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

name_fi ✖

  • 17-19°C · 1,261 ✖
id ▲ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
14484 39583 swimming_water_temperature 2020-08-28T08:43:07.548111+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13974 53461 swimming_water_temperature 2020-08-21T11:23:03.184224+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13972 39713 swimming_water_temperature 2020-08-21T11:09:51.348003+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13970 39823 swimming_water_temperature 2020-08-21T11:09:22.320503+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13969 39875 swimming_water_temperature 2020-08-21T10:12:16.211484+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13967 39875 swimming_water_temperature 2020-08-21T10:12:09.731511+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13965 39902 swimming_water_temperature 2020-08-21T09:45:02.019102+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13963 39606 swimming_water_temperature 2020-08-21T09:31:55.941932+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13888 52959 swimming_water_temperature 2020-08-17T12:37:07.381585+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13884 39693 swimming_water_temperature 2020-08-17T12:36:09.329837+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13882 39568 swimming_water_temperature 2020-08-17T12:35:54.164611+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13880 39527 swimming_water_temperature 2020-08-17T12:35:38.285569+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13876 53461 swimming_water_temperature 2020-08-17T11:10:45.274995+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13874 39606 swimming_water_temperature 2020-08-17T10:09:47.344109+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13873 39902 swimming_water_temperature 2020-08-17T09:47:18.772678+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13871 39875 swimming_water_temperature 2020-08-17T09:26:42.758776+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13851 52959 swimming_water_temperature 2020-08-16T12:18:21.427698+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13849 39693 swimming_water_temperature 2020-08-16T11:40:55.631651+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13824 39568 swimming_water_temperature 2020-08-16T10:08:07.980630+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13800 39815 swimming_water_temperature 2020-08-15T11:37:14.309248+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13798 52959 swimming_water_temperature 2020-08-15T10:55:15.573262+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13775 39568 swimming_water_temperature 2020-08-15T08:32:06.194728+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13774 39815 swimming_water_temperature 2020-08-14T18:46:59.477704+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13772 39693 swimming_water_temperature 2020-08-14T18:42:33.748153+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13765 39815 swimming_water_temperature 2020-08-14T14:20:40.988035+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13760 39693 swimming_water_temperature 2020-08-14T12:33:22.192086+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13755 39583 swimming_water_temperature 2020-08-14T10:07:32.848389+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13752 39815 swimming_water_temperature 2020-08-14T09:52:40.512337+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13733 39815 swimming_water_temperature 2020-08-13T19:02:44.722945+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13729 39693 swimming_water_temperature 2020-08-13T18:30:14.317739+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13727 39815 swimming_water_temperature 2020-08-13T15:01:22.268718+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13723 39815 swimming_water_temperature 2020-08-13T14:00:51.236478+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13717 39583 swimming_water_temperature 2020-08-13T12:05:18.215525+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13714 39815 swimming_water_temperature 2020-08-13T10:36:22.421956+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13682 39815 swimming_water_temperature 2020-08-13T08:19:45.536904+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13681 39815 swimming_water_temperature 2020-08-12T18:55:01.191676+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13676 39583 swimming_water_temperature 2020-08-12T17:47:11.639366+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13673 39815 swimming_water_temperature 2020-08-12T14:10:12.180913+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13670 39815 swimming_water_temperature 2020-08-12T14:09:06.160694+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13666 39583 swimming_water_temperature 2020-08-12T14:07:51.962436+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13663 39693 swimming_water_temperature 2020-08-12T14:06:20.816129+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13661 39693 swimming_water_temperature 2020-08-12T14:02:47.519936+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13640 39583 swimming_water_temperature 2020-08-12T10:12:53.678697+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13632 39693 swimming_water_temperature 2020-08-11T18:11:24.202010+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13630 39693 swimming_water_temperature 2020-08-11T17:53:29.036539+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13623 39693 swimming_water_temperature 2020-08-11T14:01:30.649371+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13621 39527 swimming_water_temperature 2020-08-11T13:44:34.401530+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13614 39693 swimming_water_temperature 2020-08-11T10:07:24.910075+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13593 39815 swimming_water_temperature 2020-08-11T08:39:44.619852+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13590 39693 swimming_water_temperature 2020-08-11T08:33:41.770519+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13587 39693 swimming_water_temperature 2020-08-10T18:00:25.435987+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13586 39815 swimming_water_temperature 2020-08-10T17:55:33.488830+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13575 50549 swimming_water_temperature 2020-08-10T14:23:27.481034+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13572 39815 swimming_water_temperature 2020-08-10T14:08:58.999911+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13539 39568 swimming_water_temperature 2020-08-10T10:40:29.021569+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13537 52959 swimming_water_temperature 2020-08-10T10:16:56.202218+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13518 40802 swimming_water_temperature 2020-08-09T13:45:51.067802+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13512 40258 swimming_water_temperature 2020-08-09T11:37:28.691880+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13510 40150 swimming_water_temperature 2020-08-09T11:10:20.973354+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13504 40098 swimming_water_temperature 2020-08-09T10:51:50.562189+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13500 40950 swimming_water_temperature 2020-08-09T10:44:13.073823+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13488 39568 swimming_water_temperature 2020-08-09T09:58:17.948224+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13464 40142 swimming_water_temperature 2020-08-08T12:50:07.298808+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13462 40802 swimming_water_temperature 2020-08-08T11:36:03.449967+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13458 40950 swimming_water_temperature 2020-08-08T10:31:46.048601+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13457 40098 swimming_water_temperature 2020-08-08T10:26:01.500890+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13440 41960 swimming_water_temperature 2020-08-08T10:00:06.689992+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13434 40993 swimming_water_temperature 2020-08-08T09:44:14.962843+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13432 39568 swimming_water_temperature 2020-08-08T09:43:11.794719+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13423 39693 swimming_water_temperature 2020-08-07T17:59:33.458444+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13414 39693 swimming_water_temperature 2020-08-07T14:13:52.191394+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13411 39815 swimming_water_temperature 2020-08-07T13:56:15.926245+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13405 39693 swimming_water_temperature 2020-08-07T11:24:44.655135+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13401 40098 swimming_water_temperature 2020-08-07T10:41:19.464953+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13395 39583 swimming_water_temperature 2020-08-07T10:14:56.062344+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13385 40386 swimming_water_temperature 2020-08-07T10:01:16.005486+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13375 41791 swimming_water_temperature 2020-08-07T09:53:25.628027+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13374 40993 swimming_water_temperature 2020-08-07T09:53:16.286895+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13371 39815 swimming_water_temperature 2020-08-07T09:15:04.487870+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13345 39815 swimming_water_temperature 2020-08-06T19:38:07.444804+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13342 39693 swimming_water_temperature 2020-08-06T18:18:06.432934+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13340 40098 swimming_water_temperature 2020-08-06T16:34:17.758248+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13336 39815 swimming_water_temperature 2020-08-06T14:00:15.988778+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13332 39693 swimming_water_temperature 2020-08-06T13:51:33.439677+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13327 39606 swimming_water_temperature 2020-08-06T11:31:27.189736+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13322 39693 swimming_water_temperature 2020-08-06T10:55:27.118653+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13318 41601 swimming_water_temperature 2020-08-06T10:52:14.381734+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13296 40386 swimming_water_temperature 2020-08-06T10:06:24.455378+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13294 41791 swimming_water_temperature 2020-08-06T09:54:22.389532+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13290 40142 swimming_water_temperature 2020-08-06T09:52:49.561522+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13287 39815 swimming_water_temperature 2020-08-06T09:51:27.147297+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13265 39693 swimming_water_temperature 2020-08-05T19:46:42.951293+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13260 39815 swimming_water_temperature 2020-08-05T17:49:01.104269+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13258 39568 swimming_water_temperature 2020-08-05T15:37:19.361286+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13256 39693 swimming_water_temperature 2020-08-05T15:07:35.059394+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13250 40802 swimming_water_temperature 2020-08-05T13:33:52.953849+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13249 39667 swimming_water_temperature 2020-08-05T13:22:11.169551+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13248 39784 swimming_water_temperature 2020-08-05T13:21:51.304060+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13247 39846 swimming_water_temperature 2020-08-05T13:21:21.475167+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13246 39897 swimming_water_temperature 2020-08-05T13:20:11.837297+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  

Next page

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