servicemap

Custom SQL query returning 80 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
39815 9983 swimming_water_temperature 2020-06-23T14:03:21.225739+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 9999 swimming_water_temperature 2020-06-23T17:44:41.466315+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 10032 swimming_water_temperature 2020-06-24T09:58:05.801997+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 10094 swimming_water_temperature 2020-06-24T17:56:55.522819+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 10137 swimming_water_temperature 2020-06-25T10:09:33.856396+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 10157 swimming_water_temperature 2020-06-25T13:47:59.453891+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 10177 swimming_water_temperature 2020-06-25T17:47:30.990529+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 10208 swimming_water_temperature 2020-06-26T10:05:31.710623+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 10263 swimming_water_temperature 2020-06-26T13:53:15.779518+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 10277 swimming_water_temperature 2020-06-26T17:33:58.755629+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 10315 swimming_water_temperature 2020-06-27T10:15:40.965867+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 10343 swimming_water_temperature 2020-06-27T13:54:05.459550+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 10354 swimming_water_temperature 2020-06-27T17:44:03.018759+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 10373 swimming_water_temperature 2020-06-28T09:45:28.542941+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 10416 swimming_water_temperature 2020-06-28T13:46:35.002089+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 10450 swimming_water_temperature 2020-06-28T17:34:25.641034+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 10468 swimming_water_temperature 2020-06-29T09:33:46.664255+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 11810 swimming_water_temperature 2020-07-18T17:44:37.477328+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 11859 swimming_water_temperature 2020-07-19T18:00:48.913708+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 12034 swimming_water_temperature 2020-07-21T14:37:14.601685+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 12046 swimming_water_temperature 2020-07-21T17:54:29.112075+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 13529 swimming_water_temperature 2020-08-09T17:51:53.321131+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39846 4569 swimming_water_temperature 2019-07-28T19:51:48.363528+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39881 4593 swimming_water_temperature 2019-07-29T09:02:08.108373+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39902 10365 swimming_water_temperature 2020-06-28T08:10:22.365351+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40020 10252 swimming_water_temperature 2020-06-26T13:34:28.554066+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40020 10427 swimming_water_temperature 2020-06-28T16:38:40.241914+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40142 2313 swimming_water_temperature 2019-07-05T12:05:28.533577+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40142 10200 swimming_water_temperature 2020-06-26T09:56:48.346620+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40142 10332 swimming_water_temperature 2020-06-27T11:30:10.225909+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40142 10408 swimming_water_temperature 2020-06-28T11:06:05.513140+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40150 10056 swimming_water_temperature 2020-06-24T10:29:58.644436+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40150 10149 swimming_water_temperature 2020-06-25T10:40:59.740282+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40150 10160 swimming_water_temperature 2020-06-25T13:56:22.084914+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40157 9731 swimming_water_temperature 2020-06-19T10:05:14.406938+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40157 10023 swimming_water_temperature 2020-06-24T09:51:18.809470+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40157 10113 swimming_water_temperature 2020-06-25T09:52:17.687290+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40157 10196 swimming_water_temperature 2020-06-26T09:53:55.214804+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40157 10306 swimming_water_temperature 2020-06-27T10:00:30.762267+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40157 10385 swimming_water_temperature 2020-06-28T10:06:38.523736+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40157 10473 swimming_water_temperature 2020-06-29T09:56:52.252559+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40386 3921 swimming_water_temperature 2019-07-23T14:19:00.682961+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40386 4134 swimming_water_temperature 2019-07-25T10:32:31.324151+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40386 4263 swimming_water_temperature 2019-07-26T10:11:50.996205+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40386 4384 swimming_water_temperature 2019-07-27T09:56:30.238288+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40386 4613 swimming_water_temperature 2019-07-29T10:07:48.223180+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40386 4695 swimming_water_temperature 2019-07-30T10:10:41.020619+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40386 9948 swimming_water_temperature 2020-06-23T10:57:21.533592+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40386 10133 swimming_water_temperature 2020-06-25T10:03:30.461510+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40386 10211 swimming_water_temperature 2020-06-26T10:10:18.485002+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40386 10312 swimming_water_temperature 2020-06-27T10:14:18.411395+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40386 10395 swimming_water_temperature 2020-06-28T10:20:40.121635+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40386 10476 swimming_water_temperature 2020-06-29T10:07:18.208533+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40386 10531 swimming_water_temperature 2020-06-30T10:07:02.952836+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40559 10304 swimming_water_temperature 2020-06-27T09:58:47.210297+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40798 4523 swimming_water_temperature 2019-07-28T14:03:56.769490+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40798 4525 swimming_water_temperature 2019-07-28T14:04:38.193748+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40802 4441 swimming_water_temperature 2019-07-27T11:17:20.656154+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40802 4445 swimming_water_temperature 2019-07-27T11:18:06.473872+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40802 4504 swimming_water_temperature 2019-07-28T10:14:32.159414+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40802 9959 swimming_water_temperature 2020-06-23T12:33:55.573832+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40802 10043 swimming_water_temperature 2020-06-24T10:07:59.303282+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40802 10145 swimming_water_temperature 2020-06-25T10:28:26.644148+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40993 10403 swimming_water_temperature 2020-06-28T10:46:39.854154+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
40993 10480 swimming_water_temperature 2020-06-29T10:11:01.952659+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
41601 5016 swimming_water_temperature 2019-08-02T11:04:12.415904+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
41601 10230 swimming_water_temperature 2020-06-26T10:45:43.032483+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
41601 10325 swimming_water_temperature 2020-06-27T10:46:29.040693+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
41601 10397 swimming_water_temperature 2020-06-28T10:21:45.738030+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
41601 10474 swimming_water_temperature 2020-06-29T10:01:13.601517+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
41791 4517 swimming_water_temperature 2019-07-28T12:05:36.618319+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
41791 10119 swimming_water_temperature 2020-06-25T09:55:48.016223+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
41791 10203 swimming_water_temperature 2020-06-26T10:03:48.535123+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
41791 10302 swimming_water_temperature 2020-06-27T09:40:46.163841+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
41791 10387 swimming_water_temperature 2020-06-28T10:10:00.933659+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
42114 9944 swimming_water_temperature 2020-06-23T10:39:26.530085+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
50549 10170 swimming_water_temperature 2020-06-25T15:52:31.200307+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
52959 3796 swimming_water_temperature 2019-07-22T11:57:18.259840+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
52959 10239 swimming_water_temperature 2020-06-26T12:16:47.575496+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
52959 10336 swimming_water_temperature 2020-06-27T11:37:39.656172+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown