servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
39322 24082 swimming_water_temperature 2020-10-14T11:05:00.666183+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40258 13436 swimming_water_temperature 2020-08-08T09:55:35.945642+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40150 13391 swimming_water_temperature 2020-08-07T10:07:37.960100+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40258 13383 swimming_water_temperature 2020-08-07T09:59:38.066374+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40150 13311 swimming_water_temperature 2020-08-06T10:38:05.990688+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40258 13307 swimming_water_temperature 2020-08-06T10:34:53.428759+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40150 13238 swimming_water_temperature 2020-08-05T10:29:28.995748+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40258 13204 swimming_water_temperature 2020-08-05T09:49:54.462443+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40950 13145 swimming_water_temperature 2020-08-04T10:39:58.411213+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40258 13138 swimming_water_temperature 2020-08-04T10:10:25.455296+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40950 13028 swimming_water_temperature 2020-08-03T10:05:00.626281+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40258 12880 swimming_water_temperature 2020-08-01T11:53:15.490628+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40950 12836 swimming_water_temperature 2020-07-31T15:56:26.300164+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40258 12833 swimming_water_temperature 2020-07-31T15:38:41.546188+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40150 12721 swimming_water_temperature 2020-07-30T10:08:47.465058+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40150 12667 swimming_water_temperature 2020-07-29T12:22:15.155990+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40258 12654 swimming_water_temperature 2020-07-29T10:27:44.861896+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40950 12637 swimming_water_temperature 2020-07-29T10:00:36.968322+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 12607 swimming_water_temperature 2020-07-29T08:18:14.666008+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40950 12555 swimming_water_temperature 2020-07-28T10:14:28.059640+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40150 12548 swimming_water_temperature 2020-07-28T10:06:55.029458+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40258 12543 swimming_water_temperature 2020-07-28T09:55:47.988941+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 12520 swimming_water_temperature 2020-07-28T08:13:31.183734+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40150 12477 swimming_water_temperature 2020-07-27T10:14:50.914921+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40950 12470 swimming_water_temperature 2020-07-27T10:07:18.896436+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40258 12453 swimming_water_temperature 2020-07-27T09:54:33.679569+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 12397 swimming_water_temperature 2020-07-26T13:52:09.139325+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40950 12384 swimming_water_temperature 2020-07-26T10:17:15.003847+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40802 12381 swimming_water_temperature 2020-07-26T10:12:52.387329+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 12377 swimming_water_temperature 2020-07-26T10:08:03.937303+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40150 12374 swimming_water_temperature 2020-07-26T10:03:26.082448+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 12361 swimming_water_temperature 2020-07-26T09:15:09.797332+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
41470 12341 swimming_water_temperature 2020-07-25T10:38:53.185775+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
52959 12334 swimming_water_temperature 2020-07-25T10:16:05.943571+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40950 12332 swimming_water_temperature 2020-07-25T10:13:04.503262+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40150 12327 swimming_water_temperature 2020-07-25T10:07:12.795100+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40258 12311 swimming_water_temperature 2020-07-25T09:37:06.003997+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 12309 swimming_water_temperature 2020-07-25T09:09:41.896741+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
52959 12290 swimming_water_temperature 2020-07-24T11:46:24.627599+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40150 12288 swimming_water_temperature 2020-07-24T11:04:52.932452+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40950 12276 swimming_water_temperature 2020-07-24T10:10:27.779181+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40258 12266 swimming_water_temperature 2020-07-24T09:55:14.986891+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 12230 swimming_water_temperature 2020-07-24T08:26:07.613327+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 12227 swimming_water_temperature 2020-07-24T07:56:18.925684+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40950 12171 swimming_water_temperature 2020-07-23T10:11:34.974694+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40559 12162 swimming_water_temperature 2020-07-23T09:59:21.709960+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40258 12159 swimming_water_temperature 2020-07-23T09:59:12.376200+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
52959 12152 swimming_water_temperature 2020-07-23T09:24:34.979564+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 12148 swimming_water_temperature 2020-07-23T09:02:05.133213+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 12146 swimming_water_temperature 2020-07-23T08:40:28.331757+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40150 12108 swimming_water_temperature 2020-07-22T10:27:17.272403+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40258 12085 swimming_water_temperature 2020-07-22T09:50:17.482295+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40258 11623 swimming_water_temperature 2020-07-16T09:55:40.437874+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 11604 swimming_water_temperature 2020-07-15T15:43:25.351708+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
52959 11602 swimming_water_temperature 2020-07-15T15:43:04.683917+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
52958 11590 swimming_water_temperature 2020-07-15T11:59:56.825402+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40950 11548 swimming_water_temperature 2020-07-15T10:15:59.697752+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 11515 swimming_water_temperature 2020-07-14T22:54:47.249613+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
52959 11504 swimming_water_temperature 2020-07-14T16:19:00.271428+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40150 11460 swimming_water_temperature 2020-07-14T10:11:40.998155+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40950 11455 swimming_water_temperature 2020-07-14T10:10:00.766169+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
41960 11448 swimming_water_temperature 2020-07-14T09:58:52.861796+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
41960 11375 swimming_water_temperature 2020-07-13T10:07:25.583162+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40950 11372 swimming_water_temperature 2020-07-13T10:06:53.019262+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 11330 swimming_water_temperature 2020-07-12T14:06:13.325033+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 11328 swimming_water_temperature 2020-07-12T14:06:02.422587+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
52959 11326 swimming_water_temperature 2020-07-12T14:05:48.899069+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40950 11314 swimming_water_temperature 2020-07-12T10:14:32.995007+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
41960 11293 swimming_water_temperature 2020-07-12T09:53:44.221833+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40802 11275 swimming_water_temperature 2020-07-11T10:23:17.493815+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 11248 swimming_water_temperature 2020-07-10T23:54:23.312656+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
52959 11246 swimming_water_temperature 2020-07-10T23:54:07.006257+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39568 11205 swimming_water_temperature 2020-07-10T12:56:56.750866+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40802 11201 swimming_water_temperature 2020-07-10T12:22:19.917875+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 11160 swimming_water_temperature 2020-07-10T08:09:36.055647+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40802 11076 swimming_water_temperature 2020-07-08T11:30:53.761726+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40993 9162 swimming_water_temperature 2020-06-12T10:01:32.478351+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
58015 9087 swimming_water_temperature 2020-06-11T10:04:27.738654+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40258 9061 swimming_water_temperature 2020-06-11T10:00:10.501231+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40559 9054 swimming_water_temperature 2020-06-11T09:54:03.877372+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40993 9048 swimming_water_temperature 2020-06-11T09:45:46.700792+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40258 8985 swimming_water_temperature 2020-06-10T10:04:51.542902+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39693 8975 swimming_water_temperature 2020-06-10T09:53:51.612783+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40993 8971 swimming_water_temperature 2020-06-10T09:52:56.247097+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
52959 8946 swimming_water_temperature 2020-06-09T16:49:25.839554+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40993 8944 swimming_water_temperature 2020-06-09T15:38:57.523798+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39693 8936 swimming_water_temperature 2020-06-09T12:57:02.789630+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40258 8924 swimming_water_temperature 2020-06-09T10:19:38.267967+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40950 8920 swimming_water_temperature 2020-06-09T10:06:44.950998+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40142 8918 swimming_water_temperature 2020-06-09T10:06:07.037605+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40559 8914 swimming_water_temperature 2020-06-09T09:59:35.269207+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39815 8910 swimming_water_temperature 2020-06-09T09:55:58.789091+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39693 8905 swimming_water_temperature 2020-06-09T08:27:46.582297+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 8903 swimming_water_temperature 2020-06-09T08:13:44.613876+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 8888 swimming_water_temperature 2020-06-08T13:37:44.271269+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40950 8882 swimming_water_temperature 2020-06-08T10:30:53.653729+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40142 8880 swimming_water_temperature 2020-06-08T10:23:40.429353+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40993 8871 swimming_water_temperature 2020-06-08T10:19:50.456002+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
52959 8865 swimming_water_temperature 2020-06-08T10:09:07.633769+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
40258 8857 swimming_water_temperature 2020-06-08T10:04:28.413118+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
39527 8843 swimming_water_temperature 2020-06-08T08:43:51.423919+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown