servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
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  
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 12034 swimming_water_temperature 2020-07-21T14:37:14.601685+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 11861 swimming_water_temperature 2020-07-19T18:09:35.905875+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 11810 swimming_water_temperature 2020-07-18T17:44:37.477328+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  
39322 10512 swimming_water_temperature 2020-06-29T17:51:58.962965+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 10505 swimming_water_temperature 2020-06-29T14:04:31.971744+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 10498 swimming_water_temperature 2020-06-29T11:16:05.524715+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39583 10490 swimming_water_temperature 2020-06-29T10:35:38.730708+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  
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  
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  
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  
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  
39693 10455 swimming_water_temperature 2020-06-28T18:14:56.991933+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39693 10454 swimming_water_temperature 2020-06-28T18:14:37.195346+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39583 10452 swimming_water_temperature 2020-06-28T17:42:36.153938+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  
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  
39693 10424 swimming_water_temperature 2020-06-28T14:48:00.687629+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 10422 swimming_water_temperature 2020-06-28T14:13:00.933100+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39583 10420 swimming_water_temperature 2020-06-28T14:04:47.285385+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  
39527 10411 swimming_water_temperature 2020-06-28T12:49:52.473929+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  
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  
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  
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  
39322 10393 swimming_water_temperature 2020-06-28T10:19:46.641853+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39583 10391 swimming_water_temperature 2020-06-28T10:15:42.177052+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  
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  
39693 10375 swimming_water_temperature 2020-06-28T09:47:00.711127+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  
39412 10371 swimming_water_temperature 2020-06-28T09:17:49.501789+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  
39693 10358 swimming_water_temperature 2020-06-27T18:08:38.876359+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39583 10356 swimming_water_temperature 2020-06-27T17:44:58.754837+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  
39583 10352 swimming_water_temperature 2020-06-27T14:14:20.446472+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 10350 swimming_water_temperature 2020-06-27T14:10:26.078149+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 10349 swimming_water_temperature 2020-06-27T14:10:15.808817+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39693 10347 swimming_water_temperature 2020-06-27T13:54:53.618726+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  
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  
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  
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  
39322 10323 swimming_water_temperature 2020-06-27T10:39:02.328595+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  
39583 10314 swimming_water_temperature 2020-06-27T10:15:35.353006+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  
39693 10308 swimming_water_temperature 2020-06-27T10:08:11.278637+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  
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  
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  
39693 10282 swimming_water_temperature 2020-06-26T18:02:43.768481+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39583 10279 swimming_water_temperature 2020-06-26T17:47:05.296119+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  
39583 10274 swimming_water_temperature 2020-06-26T14:25:47.452954+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39693 10272 swimming_water_temperature 2020-06-26T14:21:48.433310+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 10270 swimming_water_temperature 2020-06-26T14:16:15.957267+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  
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  
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  
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  
39322 10223 swimming_water_temperature 2020-06-26T10:24:09.487236+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39693 10220 swimming_water_temperature 2020-06-26T10:23:44.683113+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39583 10217 swimming_water_temperature 2020-06-26T10:21:42.346187+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  
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  
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  
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  
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  
39693 10182 swimming_water_temperature 2020-06-25T18:14:31.169484+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 10179 swimming_water_temperature 2020-06-25T18:01:40.262239+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  
39583 10173 swimming_water_temperature 2020-06-25T17:41:09.153987+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  
39693 10168 swimming_water_temperature 2020-06-25T14:42:11.310041+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 10166 swimming_water_temperature 2020-06-25T14:14:51.498763+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39583 10163 swimming_water_temperature 2020-06-25T13:57:37.920197+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  
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  
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  
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  
39583 10142 swimming_water_temperature 2020-06-25T10:15:45.758026+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  
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  
39322 10124 swimming_water_temperature 2020-06-25T09:59:19.912704+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39693 10121 swimming_water_temperature 2020-06-25T09:58:39.408969+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  
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  
39568 10098 swimming_water_temperature 2020-06-24T18:44:59.432352+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 10096 swimming_water_temperature 2020-06-24T18:12:32.504006+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  
39583 10091 swimming_water_temperature 2020-06-24T17:44:09.829835+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39693 10089 swimming_water_temperature 2020-06-24T14:33:09.771137+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39583 10087 swimming_water_temperature 2020-06-24T14:00:08.447304+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 10085 swimming_water_temperature 2020-06-24T13:58:06.001512+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown