observation
1,261 rows where name_en = "17-19°C" and primary = 0 sorted by id descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );