observation

4,968 rows where primary = 0 sorted by value

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name_fi, name_en, value

primary ✖

  • 0 · 4,968 ✖
id unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value ▼ quality value_en
46 40802 swimming_water_temperature 2019-06-03T14:59:26.683795+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
47 40157 swimming_water_temperature 2019-06-03T14:59:26.889067+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
48 40559 swimming_water_temperature 2019-06-03T14:59:27.096032+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
54 41791 swimming_water_temperature 2019-06-04T17:02:44.678313+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
55 41791 swimming_water_temperature 2019-06-04T17:02:48.561805+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
57 41791 swimming_water_temperature 2019-06-04T17:03:08.170718+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
58 40142 swimming_water_temperature 2019-06-04T17:39:46.130880+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
63 41791 swimming_water_temperature 2019-06-04T17:51:03.957383+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
68 40150 swimming_water_temperature 2019-06-04T17:51:04.763516+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
73 40098 swimming_water_temperature 2019-06-04T17:51:05.596938+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
75 40950 swimming_water_temperature 2019-06-04T17:51:05.913205+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
76 41601 swimming_water_temperature 2019-06-04T17:51:06.065823+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
85 40559 swimming_water_temperature 2019-06-04T17:51:07.434079+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
87 40802 swimming_water_temperature 2019-06-04T17:51:07.737749+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
107 40150 swimming_water_temperature 2019-06-05T10:51:43.333717+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
588 40950 swimming_water_temperature 2019-06-12T10:42:01.652816+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
595 40098 swimming_water_temperature 2019-06-12T10:52:11.718054+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
657 40802 swimming_water_temperature 2019-06-13T10:12:31.407532+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
659 40098 swimming_water_temperature 2019-06-13T10:13:04.081492+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
660 40142 swimming_water_temperature 2019-06-13T10:26:03.251281+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
669 52959 swimming_water_temperature 2019-06-13T10:50:35.464669+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
671 40150 swimming_water_temperature 2019-06-13T11:20:00.617342+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
673 40950 swimming_water_temperature 2019-06-13T11:38:20.179121+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
679 52959 swimming_water_temperature 2019-06-13T14:04:22.286502+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
687 39568 swimming_water_temperature 2019-06-13T16:33:38.469330+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
689 39568 swimming_water_temperature 2019-06-13T16:33:49.353692+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
692 39568 swimming_water_temperature 2019-06-13T18:16:53.623298+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
722 40802 swimming_water_temperature 2019-06-14T10:09:20.447749+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
724 52959 swimming_water_temperature 2019-06-14T10:11:31.222608+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
726 40142 swimming_water_temperature 2019-06-14T10:14:59.703173+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
759 41791 swimming_water_temperature 2019-06-15T10:05:48.674173+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
761 40559 swimming_water_temperature 2019-06-15T10:11:25.092050+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
772 40258 swimming_water_temperature 2019-06-15T10:52:26.343555+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
777 40142 swimming_water_temperature 2019-06-15T12:20:13.303202+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
780 40950 swimming_water_temperature 2019-06-15T13:44:04.703244+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
791 39527 swimming_water_temperature 2019-06-15T15:56:24.279647+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
821 52959 swimming_water_temperature 2019-06-16T09:16:04.688320+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
975 39568 swimming_water_temperature 2019-06-18T09:52:13.128959+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1319 40258 swimming_water_temperature 2019-06-23T11:06:36.449287+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1432 39527 swimming_water_temperature 2019-06-24T14:39:56.078527+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1457 39568 swimming_water_temperature 2019-06-25T09:38:13.506010+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1465 40098 swimming_water_temperature 2019-06-25T10:05:06.757173+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1468 40150 swimming_water_temperature 2019-06-25T10:10:37.855447+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1480 40950 swimming_water_temperature 2019-06-25T10:34:05.368748+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1482 39527 swimming_water_temperature 2019-06-25T10:42:46.178701+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1551 40802 swimming_water_temperature 2019-06-26T10:08:11.937510+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1555 52959 swimming_water_temperature 2019-06-26T10:19:36.854693+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1558 40150 swimming_water_temperature 2019-06-26T10:23:30.433159+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1563 40258 swimming_water_temperature 2019-06-26T10:56:53.793616+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1570 40950 swimming_water_temperature 2019-06-26T13:40:09.834453+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1596 39527 swimming_water_temperature 2019-06-27T09:04:50.295586+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1612 40802 swimming_water_temperature 2019-06-27T10:11:27.560419+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1620 40258 swimming_water_temperature 2019-06-27T10:22:26.786822+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1636 39527 swimming_water_temperature 2019-06-27T13:16:26.703830+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1678 40150 swimming_water_temperature 2019-06-27T14:31:09.475213+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1680 40950 swimming_water_temperature 2019-06-27T14:32:53.572439+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1682 41907 swimming_water_temperature 2019-06-27T14:37:29.026826+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1684 40798 swimming_water_temperature 2019-06-27T14:37:40.436838+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1686 39910 swimming_water_temperature 2019-06-27T14:37:47.284884+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1702 39568 swimming_water_temperature 2019-06-27T14:58:52.599260+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1719 40142 swimming_water_temperature 2019-06-28T09:59:01.316791+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1730 40950 swimming_water_temperature 2019-06-28T10:13:45.934859+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1736 40150 swimming_water_temperature 2019-06-28T10:22:35.582527+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1740 40559 swimming_water_temperature 2019-06-28T10:26:34.842819+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1742 40098 swimming_water_temperature 2019-06-28T10:33:16.026183+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1743 40258 swimming_water_temperature 2019-06-28T10:33:58.367493+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1770 41791 swimming_water_temperature 2019-06-28T15:11:40.565858+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1791 40559 swimming_water_temperature 2019-06-29T10:01:31.755619+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1796 41791 swimming_water_temperature 2019-06-29T10:05:12.004456+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1798 40950 swimming_water_temperature 2019-06-29T10:10:02.068952+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1802 40142 swimming_water_temperature 2019-06-29T10:14:00.117733+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1804 40150 swimming_water_temperature 2019-06-29T10:19:51.146315+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1807 40258 swimming_water_temperature 2019-06-29T10:23:26.253241+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1809 52959 swimming_water_temperature 2019-06-29T10:33:07.564413+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1811 39527 swimming_water_temperature 2019-06-29T10:35:09.132448+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1815 39568 swimming_water_temperature 2019-06-29T10:37:15.570586+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1820 40098 swimming_water_temperature 2019-06-29T10:40:57.376395+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1839 39568 swimming_water_temperature 2019-06-29T14:36:03.257726+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1840 39568 swimming_water_temperature 2019-06-29T14:36:09.937849+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1842 39527 swimming_water_temperature 2019-06-29T14:39:13.572336+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1852 39568 swimming_water_temperature 2019-06-29T18:22:20.289613+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1859 40559 swimming_water_temperature 2019-06-30T09:57:39.161228+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1863 41791 swimming_water_temperature 2019-06-30T10:00:16.086202+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1878 40950 swimming_water_temperature 2019-06-30T10:12:32.679077+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1885 40258 swimming_water_temperature 2019-06-30T10:19:22.074036+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1891 40150 swimming_water_temperature 2019-06-30T10:44:47.856203+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1895 40098 swimming_water_temperature 2019-06-30T11:06:36.999675+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1898 40142 swimming_water_temperature 2019-06-30T12:12:25.712341+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1899 40142 swimming_water_temperature 2019-06-30T12:12:39.210766+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1900 39527 swimming_water_temperature 2019-06-30T12:36:43.333583+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1903 39568 swimming_water_temperature 2019-06-30T13:49:12.486308+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1904 39568 swimming_water_temperature 2019-06-30T13:49:23.543952+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1959 40559 swimming_water_temperature 2019-07-01T10:03:43.940440+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1966 40993 swimming_water_temperature 2019-07-01T10:05:47.770653+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1969 39568 swimming_water_temperature 2019-07-01T10:07:55.633355+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1991 39527 swimming_water_temperature 2019-07-01T10:36:01.507939+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1992 39527 swimming_water_temperature 2019-07-01T10:36:22.100902+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1993 39527 swimming_water_temperature 2019-07-01T10:36:51.678706+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1996 39527 swimming_water_temperature 2019-07-01T10:37:07.201673+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2019 39527 swimming_water_temperature 2019-07-01T14:10:01.247802+0300     alle 15°C   under 15°C 0 below 15°C 0-15 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
);