servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
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  
39267 979 swimming_water_temperature 2019-06-18T10:04:57.735750+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 980 swimming_water_temperature 2019-06-18T10:05:00.762138+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 985 swimming_water_temperature 2019-06-18T10:08:58.163846+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41601 987 swimming_water_temperature 2019-06-18T10:09:02.391852+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41960 998 swimming_water_temperature 2019-06-18T12:25:33.925206+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 1002 swimming_water_temperature 2019-06-18T13:57:25.844224+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 1004 swimming_water_temperature 2019-06-18T14:02:58.538067+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 1008 swimming_water_temperature 2019-06-18T14:03:26.589887+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 1011 swimming_water_temperature 2019-06-18T14:08:15.633290+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 1017 swimming_water_temperature 2019-06-18T17:41:59.020786+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 1022 swimming_water_temperature 2019-06-18T18:03:27.116163+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 1026 swimming_water_temperature 2019-06-18T18:28:36.975793+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 1027 swimming_water_temperature 2019-06-18T18:34:37.210909+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 1029 swimming_water_temperature 2019-06-19T08:53:16.300412+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 1034 swimming_water_temperature 2019-06-19T09:57:26.877364+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 1037 swimming_water_temperature 2019-06-19T10:00:23.206036+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 1040 swimming_water_temperature 2019-06-19T10:10:03.476058+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41960 1052 swimming_water_temperature 2019-06-19T10:54:37.660937+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
53461 1077 swimming_water_temperature 2019-06-19T13:51:27.872640+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39902 1078 swimming_water_temperature 2019-06-19T13:51:31.888677+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39875 1079 swimming_water_temperature 2019-06-19T13:51:36.544111+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39823 1080 swimming_water_temperature 2019-06-19T13:51:40.877643+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39606 1081 swimming_water_temperature 2019-06-19T13:51:45.586754+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39412 1082 swimming_water_temperature 2019-06-19T13:52:05.552107+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 1083 swimming_water_temperature 2019-06-19T13:56:43.298178+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 1085 swimming_water_temperature 2019-06-19T13:56:50.743850+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 1086 swimming_water_temperature 2019-06-19T14:02:42.761295+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 1089 swimming_water_temperature 2019-06-19T14:03:19.520056+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 1095 swimming_water_temperature 2019-06-19T17:34:57.302155+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 1097 swimming_water_temperature 2019-06-19T17:53:32.524886+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 1101 swimming_water_temperature 2019-06-19T18:11:56.001979+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 1108 swimming_water_temperature 2019-06-19T18:14:20.981814+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39412 1110 swimming_water_temperature 2019-06-20T08:17:31.288276+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39823 1112 swimming_water_temperature 2019-06-20T09:06:02.130469+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
53461 1114 swimming_water_temperature 2019-06-20T09:06:24.012568+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 1116 swimming_water_temperature 2019-06-20T09:28:01.506713+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39875 1119 swimming_water_temperature 2019-06-20T09:55:35.742758+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39713 1121 swimming_water_temperature 2019-06-20T10:02:04.748221+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 1132 swimming_water_temperature 2019-06-20T10:08:55.582249+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40098 1134 swimming_water_temperature 2019-06-20T10:11:06.108590+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 1140 swimming_water_temperature 2019-06-20T10:20:03.741205+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40142 1141 swimming_water_temperature 2019-06-20T10:21:34.903362+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41960 1145 swimming_water_temperature 2019-06-20T10:27:08.938367+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41601 1147 swimming_water_temperature 2019-06-20T10:32:53.639607+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 1155 swimming_water_temperature 2019-06-20T11:10:35.672801+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40921 1167 swimming_water_temperature 2019-06-20T13:51:35.632755+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41326 1169 swimming_water_temperature 2019-06-20T13:51:49.039025+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40677 1173 swimming_water_temperature 2019-06-20T13:52:59.988979+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40993 1177 swimming_water_temperature 2019-06-20T13:54:46.207449+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 1179 swimming_water_temperature 2019-06-20T13:58:33.371598+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39693 1182 swimming_water_temperature 2019-06-20T14:00:53.666634+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 1185 swimming_water_temperature 2019-06-20T14:07:46.017198+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39583 1188 swimming_water_temperature 2019-06-20T14:19:21.794125+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39846 1191 swimming_water_temperature 2019-06-20T14:20:08.098425+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 1194 swimming_water_temperature 2019-06-20T17:48:34.570676+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 1201 swimming_water_temperature 2019-06-20T18:02:19.222924+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39527 1203 swimming_water_temperature 2019-06-20T18:08:41.351778+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40142 1204 swimming_water_temperature 2019-06-21T10:02:45.520295+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41601 1277 swimming_water_temperature 2019-06-21T17:01:36.871912+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40386 1290 swimming_water_temperature 2019-06-22T11:48:02.391028+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41601 1298 swimming_water_temperature 2019-06-22T14:36:58.192142+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40142 1300 swimming_water_temperature 2019-06-22T16:26:46.567295+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41960 1304 swimming_water_temperature 2019-06-23T10:09:58.917524+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41601 1310 swimming_water_temperature 2019-06-23T10:19:49.828890+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40098 1314 swimming_water_temperature 2019-06-23T10:42:30.032492+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40142 1322 swimming_water_temperature 2019-06-23T12:16:26.148406+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39713 1342 swimming_water_temperature 2019-06-24T07:33:14.638974+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39875 1344 swimming_water_temperature 2019-06-24T07:45:22.657856+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39902 1346 swimming_water_temperature 2019-06-24T08:07:07.943922+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39606 1348 swimming_water_temperature 2019-06-24T08:13:48.284584+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39606 1349 swimming_water_temperature 2019-06-24T08:13:51.069412+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
53461 1351 swimming_water_temperature 2019-06-24T08:27:14.155427+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39823 1353 swimming_water_temperature 2019-06-24T08:48:01.340865+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39412 1355 swimming_water_temperature 2019-06-24T09:15:58.463154+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41960 1361 swimming_water_temperature 2019-06-24T10:08:17.002441+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41326 1372 swimming_water_temperature 2019-06-24T10:19:57.049806+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41031 1374 swimming_water_temperature 2019-06-24T10:20:26.766826+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40921 1376 swimming_water_temperature 2019-06-24T10:20:33.206691+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40677 1378 swimming_water_temperature 2019-06-24T10:20:42.111151+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40020 1382 swimming_water_temperature 2019-06-24T10:21:08.695418+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40993 1384 swimming_water_temperature 2019-06-24T10:21:17.892138+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41601 1386 swimming_water_temperature 2019-06-24T10:23:21.271018+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 1388 swimming_water_temperature 2019-06-24T10:28:26.877686+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 1392 swimming_water_temperature 2019-06-24T10:32:17.606737+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39583 1403 swimming_water_temperature 2019-06-24T10:55:51.663438+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40142 1413 swimming_water_temperature 2019-06-24T12:12:14.050950+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 1419 swimming_water_temperature 2019-06-24T13:56:35.519199+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39583 1421 swimming_water_temperature 2019-06-24T14:01:10.970245+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 1424 swimming_water_temperature 2019-06-24T14:04:30.533467+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39583 1436 swimming_water_temperature 2019-06-24T17:43:24.944374+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39815 1445 swimming_water_temperature 2019-06-24T17:49:41.407724+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 1459 swimming_water_temperature 2019-06-25T09:57:50.869978+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39267 1470 swimming_water_temperature 2019-06-25T10:16:26.334389+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41960 1475 swimming_water_temperature 2019-06-25T10:19:42.935985+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39583 1477 swimming_water_temperature 2019-06-25T10:21:56.858506+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40386 1492 swimming_water_temperature 2019-06-25T12:06:11.586989+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
40142 1494 swimming_water_temperature 2019-06-25T13:17:30.922629+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 1504 swimming_water_temperature 2019-06-25T14:08:27.238526+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
39322 1506 swimming_water_temperature 2019-06-25T14:10:38.668208+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
41031 1514 swimming_water_temperature 2019-06-25T15:03:07.159319+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown