servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
39267 296 swimming_water_temperature 2019-06-08T17:01:07.633245+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 301 swimming_water_temperature 2019-06-08T17:58:54.777603+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 339 swimming_water_temperature 2019-06-09T10:21:42.793020+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 374 swimming_water_temperature 2019-06-09T17:54:11.286114+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 933 swimming_water_temperature 2019-06-17T13:59:33.608988+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 1359 swimming_water_temperature 2019-06-24T10:07:46.646036+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 1426 swimming_water_temperature 2019-06-24T14:13:53.042983+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 1443 swimming_water_temperature 2019-06-24T17:46:11.049406+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 1499 swimming_water_temperature 2019-06-25T13:56:36.662049+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 1537 swimming_water_temperature 2019-06-25T17:45:23.883233+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 1556 swimming_water_temperature 2019-06-26T10:21:48.404757+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 1578 swimming_water_temperature 2019-06-26T14:04:59.960700+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 1589 swimming_water_temperature 2019-06-26T18:01:29.156373+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 1755 swimming_water_temperature 2019-06-28T12:30:03.099858+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 3656 swimming_water_temperature 2019-07-21T10:40:00.785107+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 3684 swimming_water_temperature 2019-07-21T14:16:04.111380+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 3787 swimming_water_temperature 2019-07-22T10:30:29.201404+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 3802 swimming_water_temperature 2019-07-22T14:07:58.998499+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 3813 swimming_water_temperature 2019-07-22T17:42:43.626233+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 3891 swimming_water_temperature 2019-07-23T10:28:44.044986+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 3931 swimming_water_temperature 2019-07-23T17:39:38.202978+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 3960 swimming_water_temperature 2019-07-24T10:00:56.694968+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 4068 swimming_water_temperature 2019-07-24T17:48:03.304207+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 4112 swimming_water_temperature 2019-07-25T10:15:52.017826+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 4176 swimming_water_temperature 2019-07-25T14:04:46.430645+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 4201 swimming_water_temperature 2019-07-25T17:48:45.083968+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 4254 swimming_water_temperature 2019-07-26T10:04:13.204558+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 4526 swimming_water_temperature 2019-07-28T14:26:37.323033+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 4546 swimming_water_temperature 2019-07-28T17:51:04.366394+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 4693 swimming_water_temperature 2019-07-30T10:02:12.366747+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 4742 swimming_water_temperature 2019-07-30T15:03:15.597544+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 4748 swimming_water_temperature 2019-07-30T17:56:11.499554+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 4889 swimming_water_temperature 2019-08-01T10:21:41.840771+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 4891 swimming_water_temperature 2019-08-01T10:22:31.076396+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 9545 swimming_water_temperature 2020-06-17T08:55:10.220727+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 9902 swimming_water_temperature 2020-06-23T09:47:45.753569+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39267 13886 swimming_water_temperature 2020-08-17T12:36:24.340709+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 222 swimming_water_temperature 2019-06-07T11:23:40.887777+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 224 swimming_water_temperature 2019-06-07T11:35:37.055471+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 226 swimming_water_temperature 2019-06-07T11:35:37.494252+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 228 swimming_water_temperature 2019-06-07T11:35:37.963596+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 244 swimming_water_temperature 2019-06-07T15:15:49.773357+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 245 swimming_water_temperature 2019-06-07T15:17:51.123747+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 1180 swimming_water_temperature 2019-06-20T13:58:38.404204+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 1448 swimming_water_temperature 2019-06-24T17:52:07.245628+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 3388 swimming_water_temperature 2019-07-18T17:59:16.367615+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 3589 swimming_water_temperature 2019-07-20T14:02:13.169518+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 3676 swimming_water_temperature 2019-07-21T14:01:53.621932+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 3700 swimming_water_temperature 2019-07-21T18:17:28.032777+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 3768 swimming_water_temperature 2019-07-22T10:04:21.673127+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 3822 swimming_water_temperature 2019-07-22T18:20:20.549804+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 3853 swimming_water_temperature 2019-07-23T10:04:59.367446+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 3924 swimming_water_temperature 2019-07-23T14:30:21.199704+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 3937 swimming_water_temperature 2019-07-23T18:08:28.237910+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 3955 swimming_water_temperature 2019-07-24T09:58:46.245526+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 4160 swimming_water_temperature 2019-07-25T12:40:00.256076+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 4259 swimming_water_temperature 2019-07-26T10:09:11.901961+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 4331 swimming_water_temperature 2019-07-26T13:56:57.833553+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 9433 swimming_water_temperature 2020-06-15T14:22:06.501545+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 9449 swimming_water_temperature 2020-06-15T17:58:36.660246+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 9451 swimming_water_temperature 2020-06-15T18:00:09.879986+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 9514 swimming_water_temperature 2020-06-16T13:57:00.836013+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 9530 swimming_water_temperature 2020-06-16T18:13:22.405195+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 9619 swimming_water_temperature 2020-06-17T17:58:39.289578+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 9637 swimming_water_temperature 2020-06-18T09:34:16.800503+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 9694 swimming_water_temperature 2020-06-18T18:05:33.552939+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 9696 swimming_water_temperature 2020-06-18T18:16:54.025644+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 9821 swimming_water_temperature 2020-06-22T09:46:24.984534+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 9890 swimming_water_temperature 2020-06-23T09:14:45.440058+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 10284 swimming_water_temperature 2020-06-26T19:10:44.738510+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 10527 swimming_water_temperature 2020-06-30T10:01:33.203172+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 10562 swimming_water_temperature 2020-06-30T14:13:26.137857+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 10605 swimming_water_temperature 2020-07-01T10:55:06.129346+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 10619 swimming_water_temperature 2020-07-01T13:51:22.286098+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 10686 swimming_water_temperature 2020-07-02T14:10:32.034085+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 10887 swimming_water_temperature 2020-07-05T13:52:09.847845+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 11669 swimming_water_temperature 2020-07-16T17:43:52.451862+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 11748 swimming_water_temperature 2020-07-17T18:36:51.833212+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 11808 swimming_water_temperature 2020-07-18T14:22:15.370296+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 11903 swimming_water_temperature 2020-07-20T10:32:54.044403+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 11944 swimming_water_temperature 2020-07-20T13:48:08.903081+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 11957 swimming_water_temperature 2020-07-20T18:25:08.056848+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 12036 swimming_water_temperature 2020-07-21T14:45:24.210012+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 12048 swimming_water_temperature 2020-07-21T18:03:19.242010+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 12138 swimming_water_temperature 2020-07-22T18:49:41.083565+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 12516 swimming_water_temperature 2020-07-27T17:58:20.423133+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 13467 swimming_water_temperature 2020-08-08T14:05:25.658428+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 13496 swimming_water_temperature 2020-08-09T10:11:30.826163+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 13522 swimming_water_temperature 2020-08-09T13:57:03.168042+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 13571 swimming_water_temperature 2020-08-10T14:05:09.050466+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 13679 swimming_water_temperature 2020-08-12T18:41:06.969147+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 13810 swimming_water_temperature 2020-08-15T14:00:22.620339+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39322 13878 swimming_water_temperature 2020-08-17T12:35:21.055110+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39368 3919 swimming_water_temperature 2019-07-23T13:45:48.253194+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39368 9588 swimming_water_temperature 2020-06-17T11:01:36.486371+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39368 11984 swimming_water_temperature 2020-07-21T10:20:29.344918+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39368 13577 swimming_water_temperature 2020-08-10T14:25:22.663454+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39412 3915 swimming_water_temperature 2019-07-23T13:30:21.949031+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39412 4035 swimming_water_temperature 2019-07-24T12:21:30.083616+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39412 4145 swimming_water_temperature 2019-07-25T10:55:55.890977+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39412 4300 swimming_water_temperature 2019-07-26T10:56:08.094820+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown