servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
40157 135 swimming_water_temperature 2019-06-06T10:23:15.997900+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40386 140 swimming_water_temperature 2019-06-06T10:43:25.060063+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40150 144 swimming_water_temperature 2019-06-06T10:43:25.600773+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40386 158 swimming_water_temperature 2019-06-06T11:16:25.589048+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40993 170 swimming_water_temperature 2019-06-06T12:51:31.651501+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 187 swimming_water_temperature 2019-06-06T17:51:51.799967+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 189 swimming_water_temperature 2019-06-06T19:43:24.985518+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 192 swimming_water_temperature 2019-06-07T08:30:29.052361+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 195 swimming_water_temperature 2019-06-07T09:40:40.293487+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39527 197 swimming_water_temperature 2019-06-07T09:44:25.167317+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 201 swimming_water_temperature 2019-06-07T09:58:44.666515+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40802 204 swimming_water_temperature 2019-06-07T10:02:44.386293+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41601 207 swimming_water_temperature 2019-06-07T10:14:41.514036+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40157 216 swimming_water_temperature 2019-06-07T10:35:43.267632+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40559 230 swimming_water_temperature 2019-06-07T12:33:44.310597+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 238 swimming_water_temperature 2019-06-07T13:53:24.595690+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39568 247 swimming_water_temperature 2019-06-07T16:12:54.240114+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 265 swimming_water_temperature 2019-06-08T08:17:40.785403+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41791 266 swimming_water_temperature 2019-06-08T10:05:04.461932+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40559 268 swimming_water_temperature 2019-06-08T10:06:22.810174+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40157 271 swimming_water_temperature 2019-06-08T10:08:25.066166+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41601 275 swimming_water_temperature 2019-06-08T10:39:32.888284+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40950 277 swimming_water_temperature 2019-06-08T10:42:23.679616+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40950 279 swimming_water_temperature 2019-06-08T10:42:31.568387+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40950 288 swimming_water_temperature 2019-06-08T13:50:00.248514+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41601 326 swimming_water_temperature 2019-06-09T10:04:55.527909+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40559 334 swimming_water_temperature 2019-06-09T10:15:07.789629+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 336 swimming_water_temperature 2019-06-09T10:15:16.605748+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40950 341 swimming_water_temperature 2019-06-09T10:22:13.251403+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40142 345 swimming_water_temperature 2019-06-09T10:31:49.644740+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40258 348 swimming_water_temperature 2019-06-09T10:45:11.049642+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40150 352 swimming_water_temperature 2019-06-09T12:28:43.832936+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40098 354 swimming_water_temperature 2019-06-09T12:28:44.344657+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 382 swimming_water_temperature 2019-06-10T08:15:53.628150+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 385 swimming_water_temperature 2019-06-10T10:00:34.828200+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 391 swimming_water_temperature 2019-06-10T10:01:21.612696+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41601 395 swimming_water_temperature 2019-06-10T10:13:27.071351+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 402 swimming_water_temperature 2019-06-10T10:34:16.433547+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40150 403 swimming_water_temperature 2019-06-10T10:37:08.378059+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41960 405 swimming_water_temperature 2019-06-10T10:57:42.684782+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 413 swimming_water_temperature 2019-06-10T13:46:34.972562+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 414 swimming_water_temperature 2019-06-10T13:56:59.031717+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 416 swimming_water_temperature 2019-06-10T14:11:28.424217+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40142 418 swimming_water_temperature 2019-06-10T14:52:12.889585+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 426 swimming_water_temperature 2019-06-10T18:30:40.103809+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 453 swimming_water_temperature 2019-06-11T09:16:02.376158+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 454 swimming_water_temperature 2019-06-11T09:16:09.387097+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 462 swimming_water_temperature 2019-06-11T09:52:59.453634+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40142 471 swimming_water_temperature 2019-06-11T10:06:22.076433+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 477 swimming_water_temperature 2019-06-11T10:10:30.491830+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40157 478 swimming_water_temperature 2019-06-11T10:10:55.622586+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 483 swimming_water_temperature 2019-06-11T10:21:09.542309+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41960 486 swimming_water_temperature 2019-06-11T10:26:20.184265+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41601 489 swimming_water_temperature 2019-06-11T10:53:12.365926+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 553 swimming_water_temperature 2019-06-11T13:43:38.386127+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 554 swimming_water_temperature 2019-06-11T13:45:44.348861+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 560 swimming_water_temperature 2019-06-11T14:00:08.545368+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 565 swimming_water_temperature 2019-06-11T17:52:45.689952+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 567 swimming_water_temperature 2019-06-11T17:56:58.976591+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41960 576 swimming_water_temperature 2019-06-12T10:08:21.924216+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 586 swimming_water_temperature 2019-06-12T10:22:49.596387+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 590 swimming_water_temperature 2019-06-12T10:45:40.373126+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41601 603 swimming_water_temperature 2019-06-12T12:38:41.997550+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 605 swimming_water_temperature 2019-06-12T14:00:57.182507+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 607 swimming_water_temperature 2019-06-12T14:02:38.897497+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 612 swimming_water_temperature 2019-06-12T14:28:50.432329+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 620 swimming_water_temperature 2019-06-12T17:49:09.441105+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 622 swimming_water_temperature 2019-06-12T18:06:25.687549+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39713 630 swimming_water_temperature 2019-06-13T07:47:26.539932+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39875 634 swimming_water_temperature 2019-06-13T08:05:31.801333+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39902 636 swimming_water_temperature 2019-06-13T08:21:50.560165+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39606 638 swimming_water_temperature 2019-06-13T08:33:01.657762+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39606 701 swimming_water_temperature 2019-06-14T08:04:15.467615+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39902 703 swimming_water_temperature 2019-06-14T08:14:36.810253+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39875 705 swimming_water_temperature 2019-06-14T08:29:42.049908+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39713 707 swimming_water_temperature 2019-06-14T08:44:33.527372+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 789 swimming_water_temperature 2019-06-15T15:47:49.654002+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 798 swimming_water_temperature 2019-06-15T18:23:35.165620+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 832 swimming_water_temperature 2019-06-16T10:08:45.758606+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 839 swimming_water_temperature 2019-06-16T10:13:35.683029+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 863 swimming_water_temperature 2019-06-16T13:55:07.491625+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 866 swimming_water_temperature 2019-06-16T13:57:23.060048+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 876 swimming_water_temperature 2019-06-16T17:52:59.322927+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 878 swimming_water_temperature 2019-06-16T17:54:44.061310+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39713 886 swimming_water_temperature 2019-06-17T07:41:13.657541+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39875 888 swimming_water_temperature 2019-06-17T08:06:42.362318+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39902 890 swimming_water_temperature 2019-06-17T08:24:35.718582+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39606 892 swimming_water_temperature 2019-06-17T08:37:22.084199+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
53461 896 swimming_water_temperature 2019-06-17T09:16:30.001767+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39823 898 swimming_water_temperature 2019-06-17T09:34:06.737440+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 903 swimming_water_temperature 2019-06-17T10:04:13.439995+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39412 904 swimming_water_temperature 2019-06-17T10:04:44.498895+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40157 913 swimming_water_temperature 2019-06-17T10:42:11.042467+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41601 918 swimming_water_temperature 2019-06-17T10:58:21.481425+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 937 swimming_water_temperature 2019-06-17T14:04:47.239956+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 942 swimming_water_temperature 2019-06-17T15:06:04.487174+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 948 swimming_water_temperature 2019-06-17T17:52:02.320386+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 951 swimming_water_temperature 2019-06-17T17:52:53.460520+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 966 swimming_water_temperature 2019-06-18T08:51:48.978117+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 968 swimming_water_temperature 2019-06-18T08:51:48.978880+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 973 swimming_water_temperature 2019-06-18T09:14:44.346461+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown