servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
40386 186 swimming_water_temperature 2019-06-06T15:18:32.220657+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  
39815 240 swimming_water_temperature 2019-06-07T14:12:33.987424+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  
39815 255 swimming_water_temperature 2019-06-07T18:22:39.344024+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39815 273 swimming_water_temperature 2019-06-08T10:19:17.389316+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39693 289 swimming_water_temperature 2019-06-08T14:07:46.413233+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39815 293 swimming_water_temperature 2019-06-08T14:37:24.368764+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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  
39815 298 swimming_water_temperature 2019-06-08T17:52:09.671494+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  
39693 303 swimming_water_temperature 2019-06-08T17:59:20.966316+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39693 328 swimming_water_temperature 2019-06-09T10:07:57.806433+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39815 331 swimming_water_temperature 2019-06-09T10:13:45.481338+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  
40157 343 swimming_water_temperature 2019-06-09T10:23:07.028385+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39815 356 swimming_water_temperature 2019-06-09T13:56:38.214778+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39693 368 swimming_water_temperature 2019-06-09T14:14:24.082178+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39693 371 swimming_water_temperature 2019-06-09T17:53:47.088974+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  
39815 376 swimming_water_temperature 2019-06-09T18:17:47.234884+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39815 377 swimming_water_temperature 2019-06-09T18:17:50.236158+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40157 421 swimming_water_temperature 2019-06-10T14:54:25.564905+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39815 556 swimming_water_temperature 2019-06-11T13:54:53.119475+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39815 569 swimming_water_temperature 2019-06-11T18:08:16.960792+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  
39815 955 swimming_water_temperature 2019-06-17T18:12:39.756077+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39693 1021 swimming_water_temperature 2019-06-18T18:03:19.989986+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40157 1149 swimming_water_temperature 2019-06-20T10:34:05.660362+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40386 1159 swimming_water_temperature 2019-06-20T11:55:03.407989+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40020 1175 swimming_water_temperature 2019-06-20T13:53:33.559372+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  
39693 1196 swimming_water_temperature 2019-06-20T17:52:08.569967+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
41960 1213 swimming_water_temperature 2019-06-21T10:21:27.941227+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40098 1215 swimming_water_temperature 2019-06-21T10:39:30.075078+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40098 1218 swimming_water_temperature 2019-06-21T10:49:43.652418+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40098 1221 swimming_water_temperature 2019-06-21T11:00:22.943417+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40098 1224 swimming_water_temperature 2019-06-21T11:10:30.203638+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40098 1227 swimming_water_temperature 2019-06-21T11:20:34.160699+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40098 1230 swimming_water_temperature 2019-06-21T11:30:59.357383+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40098 1233 swimming_water_temperature 2019-06-21T11:41:04.004198+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40098 1236 swimming_water_temperature 2019-06-21T11:51:29.773215+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40098 1239 swimming_water_temperature 2019-06-21T12:02:09.788529+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40098 1246 swimming_water_temperature 2019-06-21T12:12:30.062866+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40098 1249 swimming_water_temperature 2019-06-21T12:22:30.685200+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40098 1252 swimming_water_temperature 2019-06-21T12:32:51.784133+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40098 1255 swimming_water_temperature 2019-06-21T12:43:08.379143+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40386 1258 swimming_water_temperature 2019-06-21T12:43:15.900250+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40098 1260 swimming_water_temperature 2019-06-21T12:53:16.427932+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40098 1265 swimming_water_temperature 2019-06-21T13:03:30.139046+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40098 1268 swimming_water_temperature 2019-06-21T13:13:39.989004+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40098 1271 swimming_water_temperature 2019-06-21T13:23:56.147844+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40098 1274 swimming_water_temperature 2019-06-21T13:34:03.665572+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
41960 1286 swimming_water_temperature 2019-06-22T10:25:01.968389+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40157 1288 swimming_water_temperature 2019-06-22T10:45:18.357118+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  
40157 1407 swimming_water_temperature 2019-06-24T11:00:39.332428+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40386 1411 swimming_water_temperature 2019-06-24T11:34:27.530206+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  
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  
40157 1463 swimming_water_temperature 2019-06-25T10:03:28.070848+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  
39902 1652 swimming_water_temperature 2019-06-27T13:25:03.307097+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
42114 1654 swimming_water_temperature 2019-06-27T13:26:07.474639+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39713 1668 swimming_water_temperature 2019-06-27T13:29:50.665202+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  
40157 1985 swimming_water_temperature 2019-07-01T10:26:03.076128+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
41104 3143 swimming_water_temperature 2019-07-16T10:19:00.301592+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
41104 3237 swimming_water_temperature 2019-07-17T13:25:28.802783+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
42114 3240 swimming_water_temperature 2019-07-17T13:26:42.588957+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40150 3253 swimming_water_temperature 2019-07-17T14:12:22.075778+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40386 3345 swimming_water_temperature 2019-07-18T13:21:08.520188+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39527 3355 swimming_water_temperature 2019-07-18T14:03:46.301143+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
42114 3367 swimming_water_temperature 2019-07-18T15:07:52.241058+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  
39527 3390 swimming_water_temperature 2019-07-18T19:08:04.977085+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  
41960 3621 swimming_water_temperature 2019-07-21T10:01:53.368195+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40386 3631 swimming_water_temperature 2019-07-21T10:10:23.747266+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  
39815 3670 swimming_water_temperature 2019-07-21T13:48:43.069745+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  
39583 3678 swimming_water_temperature 2019-07-21T14:02:50.298175+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  
39693 3689 swimming_water_temperature 2019-07-21T17:30:09.209683+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39815 3694 swimming_water_temperature 2019-07-21T17:50:15.421592+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
39527 3697 swimming_water_temperature 2019-07-21T18:01:48.929281+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  
39527 3708 swimming_water_temperature 2019-07-21T20:00:55.837595+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
41326 3724 swimming_water_temperature 2019-07-22T08:11:12.103976+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
41326 3725 swimming_water_temperature 2019-07-22T08:11:49.023979+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
40020 3727 swimming_water_temperature 2019-07-22T08:15:38.866993+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown