servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
39267 5864 swimming_water_cyanobacteria 2019-08-13T13:15:09.867444+0300 2019-08-14T13:15:09.867444+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 9018 swimming_water_cyanobacteria 2020-06-10T15:00:41.346075+0300 2020-06-11T15:00:41.346075+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 9546 swimming_water_cyanobacteria 2020-06-17T08:55:14.110789+0300 2020-06-18T08:55:14.110789+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 9903 swimming_water_cyanobacteria 2020-06-23T09:47:48.412424+0300 2020-06-24T09:47:48.412424+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 10984 swimming_water_cyanobacteria 2020-07-07T10:15:46.533076+0300 2020-07-08T10:15:46.533076+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 11212 swimming_water_cyanobacteria 2020-07-10T13:53:47.960100+0300 2020-07-11T13:53:47.960100+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 11471 swimming_water_cyanobacteria 2020-07-14T11:36:23.886845+0300 2020-07-15T11:36:23.886845+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 11476 swimming_water_cyanobacteria 2020-07-14T11:53:40.538476+0300 2020-07-15T11:53:40.538476+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 11921 swimming_water_cyanobacteria 2020-07-20T13:02:32.227694+0300 2020-07-21T13:02:32.227694+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 12013 swimming_water_cyanobacteria 2020-07-21T13:22:33.319277+0300 2020-07-22T13:22:33.319277+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 12177 swimming_water_cyanobacteria 2020-07-23T10:45:18.410944+0300 2020-07-24T10:45:18.410944+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 12439 swimming_water_cyanobacteria 2020-07-27T09:01:35.765373+0300 2020-07-28T09:01:35.765373+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 12537 swimming_water_cyanobacteria 2020-07-28T09:50:33.145582+0300 2020-07-29T09:50:33.145582+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 12624 swimming_water_cyanobacteria 2020-07-29T09:07:29.012877+0300 2020-07-30T09:07:29.012877+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 12700 swimming_water_cyanobacteria 2020-07-30T08:45:05.285060+0300 2020-07-31T08:45:05.285060+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 12912 swimming_water_cyanobacteria 2020-08-02T09:32:04.916957+0300 2020-08-03T09:32:04.916957+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 13006 swimming_water_cyanobacteria 2020-08-03T08:54:47.384097+0300 2020-08-04T08:54:47.384097+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 13102 swimming_water_cyanobacteria 2020-08-04T07:55:42.342787+0300 2020-08-05T07:55:42.342787+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39267 13274 swimming_water_cyanobacteria 2020-08-06T08:30:34.713181+0300 2020-08-07T08:30:34.713181+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 717 swimming_water_cyanobacteria 2019-06-14T10:00:58.201406+0300 2019-06-15T10:00:58.201406+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 744 swimming_water_cyanobacteria 2019-06-14T14:18:28.067442+0300 2019-06-15T14:18:28.067442+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 758 swimming_water_cyanobacteria 2019-06-15T10:03:00.084007+0300 2019-06-16T10:03:00.084007+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 786 swimming_water_cyanobacteria 2019-06-15T13:56:50.232653+0300 2019-06-16T13:56:50.232653+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 797 swimming_water_cyanobacteria 2019-06-15T18:21:02.700288+0300 2019-06-16T18:21:02.700288+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 838 swimming_water_cyanobacteria 2019-06-16T10:12:33.333738+0300 2019-06-17T10:12:33.333738+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 885 swimming_water_cyanobacteria 2019-06-16T19:01:24.551603+0300 2019-06-17T19:01:24.551603+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 901 swimming_water_cyanobacteria 2019-06-17T09:59:22.763374+0300 2019-06-18T09:59:22.763374+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 936 swimming_water_cyanobacteria 2019-06-17T14:01:44.234876+0300 2019-06-18T14:01:44.234876+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 983 swimming_water_cyanobacteria 2019-06-18T10:07:47.333863+0300 2019-06-19T10:07:47.333863+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1006 swimming_water_cyanobacteria 2019-06-18T14:03:14.340740+0300 2019-06-19T14:03:14.340740+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1038 swimming_water_cyanobacteria 2019-06-19T10:00:26.305094+0300 2019-06-20T10:00:26.305094+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1084 swimming_water_cyanobacteria 2019-06-19T13:56:46.993234+0300 2019-06-20T13:56:46.993234+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1098 swimming_water_cyanobacteria 2019-06-19T17:53:36.466152+0300 2019-06-20T17:53:36.466152+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1181 swimming_water_cyanobacteria 2019-06-20T13:58:41.832594+0300 2019-06-21T13:58:41.832594+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1202 swimming_water_cyanobacteria 2019-06-20T18:02:21.445164+0300 2019-06-21T18:02:21.445164+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1397 swimming_water_cyanobacteria 2019-06-24T10:33:36.584280+0300 2019-06-25T10:33:36.584280+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1425 swimming_water_cyanobacteria 2019-06-24T14:04:44.674751+0300 2019-06-25T14:04:44.674751+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1449 swimming_water_cyanobacteria 2019-06-24T17:52:10.527939+0300 2019-06-25T17:52:10.527939+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1460 swimming_water_cyanobacteria 2019-06-25T09:58:01.979120+0300 2019-06-26T09:58:01.979120+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1505 swimming_water_cyanobacteria 2019-06-25T14:08:33.887406+0300 2019-06-26T14:08:33.887406+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1507 swimming_water_cyanobacteria 2019-06-25T14:10:42.476694+0300 2019-06-26T14:10:42.476694+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1540 swimming_water_cyanobacteria 2019-06-25T18:03:56.606592+0300 2019-06-26T18:03:56.606592+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1544 swimming_water_cyanobacteria 2019-06-26T09:55:55.767975+0300 2019-06-27T09:55:55.767975+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1573 swimming_water_cyanobacteria 2019-06-26T13:52:26.906961+0300 2019-06-27T13:52:26.906961+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1628 swimming_water_cyanobacteria 2019-06-27T10:35:09.795856+0300 2019-06-28T10:35:09.795856+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1705 swimming_water_cyanobacteria 2019-06-27T16:24:47.173505+0300 2019-06-28T16:24:47.173505+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1721 swimming_water_cyanobacteria 2019-06-28T10:00:59.474031+0300 2019-06-29T10:00:59.474031+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1764 swimming_water_cyanobacteria 2019-06-28T14:21:32.390873+0300 2019-06-29T14:21:32.390873+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1778 swimming_water_cyanobacteria 2019-06-28T17:51:59.414157+0300 2019-06-29T17:51:59.414157+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1806 swimming_water_cyanobacteria 2019-06-29T10:19:54.272740+0300 2019-06-30T10:19:54.272740+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1838 swimming_water_cyanobacteria 2019-06-29T14:03:54.226123+0300 2019-06-30T14:03:54.226123+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1851 swimming_water_cyanobacteria 2019-06-29T18:21:58.029858+0300 2019-06-30T18:21:58.029858+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1857 swimming_water_cyanobacteria 2019-06-30T09:56:23.210698+0300 2019-07-01T09:56:23.210698+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1906 swimming_water_cyanobacteria 2019-06-30T14:00:14.623297+0300 2019-07-01T14:00:14.623297+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 1926 swimming_water_cyanobacteria 2019-06-30T17:52:02.455156+0300 2019-07-01T17:52:02.455156+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2141 swimming_water_cyanobacteria 2019-07-03T14:07:26.672705+0300 2019-07-04T14:07:26.672705+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2149 swimming_water_cyanobacteria 2019-07-03T17:49:17.748178+0300 2019-07-04T17:49:17.748178+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2169 swimming_water_cyanobacteria 2019-07-04T09:59:17.027506+0300 2019-07-05T09:59:17.027506+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2240 swimming_water_cyanobacteria 2019-07-04T14:32:02.920270+0300 2019-07-05T14:32:02.920270+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2247 swimming_water_cyanobacteria 2019-07-04T17:49:06.083747+0300 2019-07-05T17:49:06.083747+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2280 swimming_water_cyanobacteria 2019-07-05T09:59:54.785241+0300 2019-07-06T09:59:54.785241+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2325 swimming_water_cyanobacteria 2019-07-05T13:58:31.221259+0300 2019-07-06T13:58:31.221259+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2343 swimming_water_cyanobacteria 2019-07-05T18:08:56.956459+0300 2019-07-06T18:08:56.956459+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2353 swimming_water_cyanobacteria 2019-07-06T09:50:27.821439+0300 2019-07-07T09:50:27.821439+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2416 swimming_water_cyanobacteria 2019-07-06T17:57:58.042917+0300 2019-07-07T17:57:58.042917+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2436 swimming_water_cyanobacteria 2019-07-07T10:11:54.535726+0300 2019-07-08T10:11:54.535726+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2482 swimming_water_cyanobacteria 2019-07-07T14:23:37.047967+0300 2019-07-08T14:23:37.047967+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2484 swimming_water_cyanobacteria 2019-07-07T17:38:41.029874+0300 2019-07-08T17:38:41.029874+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2520 swimming_water_cyanobacteria 2019-07-08T10:07:10.209892+0300 2019-07-09T10:07:10.209892+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2557 swimming_water_cyanobacteria 2019-07-08T14:27:33.415891+0300 2019-07-09T14:27:33.415891+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2571 swimming_water_cyanobacteria 2019-07-08T18:10:39.895060+0300 2019-07-09T18:10:39.895060+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2589 swimming_water_cyanobacteria 2019-07-09T10:10:30.204916+0300 2019-07-10T10:10:30.204916+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2613 swimming_water_cyanobacteria 2019-07-09T13:54:11.801709+0300 2019-07-10T13:54:11.801709+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2630 swimming_water_cyanobacteria 2019-07-09T19:53:48.770335+0300 2019-07-10T19:53:48.770335+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2687 swimming_water_cyanobacteria 2019-07-10T10:35:59.332060+0300 2019-07-11T10:35:59.332060+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2713 swimming_water_cyanobacteria 2019-07-10T14:05:09.756723+0300 2019-07-11T14:05:09.756723+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2728 swimming_water_cyanobacteria 2019-07-10T17:47:10.867307+0300 2019-07-11T17:47:10.867307+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2760 swimming_water_cyanobacteria 2019-07-11T10:00:35.103499+0300 2019-07-12T10:00:35.103499+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2808 swimming_water_cyanobacteria 2019-07-11T17:55:43.151100+0300 2019-07-12T17:55:43.151100+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2814 swimming_water_cyanobacteria 2019-07-11T18:05:28.362791+0300 2019-07-12T18:05:28.362791+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2852 swimming_water_cyanobacteria 2019-07-12T10:54:41.689066+0300 2019-07-13T10:54:41.689066+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2866 swimming_water_cyanobacteria 2019-07-12T14:15:35.313011+0300 2019-07-13T14:15:35.313011+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2903 swimming_water_cyanobacteria 2019-07-13T10:38:24.164022+0300 2019-07-14T10:38:24.164022+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2923 swimming_water_cyanobacteria 2019-07-13T13:48:37.166113+0300 2019-07-14T13:48:37.166113+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2942 swimming_water_cyanobacteria 2019-07-13T17:47:45.774983+0300 2019-07-14T17:47:45.774983+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2953 swimming_water_cyanobacteria 2019-07-14T09:48:30.600004+0300 2019-07-15T09:48:30.600004+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 2997 swimming_water_cyanobacteria 2019-07-14T13:56:17.053988+0300 2019-07-15T13:56:17.053988+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 3021 swimming_water_cyanobacteria 2019-07-14T17:58:18.174559+0300 2019-07-15T17:58:18.174559+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 3079 swimming_water_cyanobacteria 2019-07-15T11:25:30.110406+0300 2019-07-16T11:25:30.110406+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 3100 swimming_water_cyanobacteria 2019-07-15T15:03:55.233636+0300 2019-07-16T15:03:55.233636+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 3111 swimming_water_cyanobacteria 2019-07-15T18:04:50.129862+0300 2019-07-16T18:04:50.129862+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 3138 swimming_water_cyanobacteria 2019-07-16T10:10:35.623583+0300 2019-07-17T10:10:35.623583+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 3165 swimming_water_cyanobacteria 2019-07-16T15:32:04.883100+0300 2019-07-17T15:32:04.883100+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 3180 swimming_water_cyanobacteria 2019-07-16T18:33:50.098926+0300 2019-07-17T18:33:50.098926+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 3230 swimming_water_cyanobacteria 2019-07-17T11:01:57.841503+0300 2019-07-18T11:01:57.841503+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 3245 swimming_water_cyanobacteria 2019-07-17T13:55:21.981307+0300 2019-07-18T13:55:21.981307+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 3265 swimming_water_cyanobacteria 2019-07-17T17:57:53.899676+0300 2019-07-18T17:57:53.899676+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 3301 swimming_water_cyanobacteria 2019-07-18T10:08:20.707711+0300 2019-07-19T10:08:20.707711+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 3351 swimming_water_cyanobacteria 2019-07-18T13:52:32.791240+0300 2019-07-19T13:52:32.791240+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 3389 swimming_water_cyanobacteria 2019-07-18T17:59:19.104205+0300 2019-07-19T17:59:19.104205+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
39322 3417 swimming_water_cyanobacteria 2019-07-19T10:01:51.394711+0300 2019-07-20T10:01:51.394711+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory