servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

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