servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
39267 4338 swimming_water_temperature 2019-07-26T14:08:48.575391+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39267 4346 swimming_water_temperature 2019-07-26T17:32:52.575018+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39267 4477 swimming_water_temperature 2019-07-27T17:44:10.582720+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39267 4547 swimming_water_temperature 2019-07-28T17:51:24.318070+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39267 4604 swimming_water_temperature 2019-07-29T10:01:43.611270+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39267 4669 swimming_water_temperature 2019-07-29T16:29:33.675718+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39267 4678 swimming_water_temperature 2019-07-29T17:45:23.075920+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 4063 swimming_water_temperature 2019-07-24T14:18:36.028851+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 4070 swimming_water_temperature 2019-07-24T17:49:13.043673+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 4161 swimming_water_temperature 2019-07-25T12:45:29.700086+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 4180 swimming_water_temperature 2019-07-25T14:06:58.048721+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 4203 swimming_water_temperature 2019-07-25T17:56:30.488448+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 4353 swimming_water_temperature 2019-07-26T18:01:04.396061+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 4392 swimming_water_temperature 2019-07-27T10:00:45.420185+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 4479 swimming_water_temperature 2019-07-27T17:45:55.150610+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 4555 swimming_water_temperature 2019-07-28T18:06:08.842456+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 4615 swimming_water_temperature 2019-07-29T10:11:15.826929+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 4663 swimming_water_temperature 2019-07-29T14:23:16.678223+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 4677 swimming_water_temperature 2019-07-29T17:45:22.217619+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 9607 swimming_water_temperature 2020-06-17T14:19:18.096819+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 9682 swimming_water_temperature 2020-06-18T14:00:17.799570+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 9866 swimming_water_temperature 2020-06-22T14:03:39.396058+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 9882 swimming_water_temperature 2020-06-22T18:01:46.615473+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 9928 swimming_water_temperature 2020-06-23T10:10:44.019821+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 9989 swimming_water_temperature 2020-06-23T14:11:02.617590+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 10005 swimming_water_temperature 2020-06-23T18:36:53.231384+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39322 10038 swimming_water_temperature 2020-06-24T10:02:52.592545+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  
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  
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  
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  
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  
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  
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  
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  
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  
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 10393 swimming_water_temperature 2020-06-28T10:19:46.641853+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  
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  
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 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 11861 swimming_water_temperature 2020-07-19T18:09:35.905875+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  
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  
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  
39583 4335 swimming_water_temperature 2019-07-26T14:08:04.824195+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39583 4350 swimming_water_temperature 2019-07-26T17:46:30.519006+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39583 4541 swimming_water_temperature 2019-07-28T17:20:37.309044+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39583 4542 swimming_water_temperature 2019-07-28T17:20:48.495620+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39583 4657 swimming_water_temperature 2019-07-29T13:34:55.577984+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39583 4673 swimming_water_temperature 2019-07-29T17:27:26.194311+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39583 4674 swimming_water_temperature 2019-07-29T17:27:37.996541+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39583 9987 swimming_water_temperature 2020-06-23T14:04:03.025272+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39583 9995 swimming_water_temperature 2020-06-23T17:40:44.919744+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39583 10049 swimming_water_temperature 2020-06-24T10:18:50.290180+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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
39693 4382 swimming_water_temperature 2019-07-27T09:38:57.454049+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39693 4430 swimming_water_temperature 2019-07-27T10:23:15.234079+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39693 4432 swimming_water_temperature 2019-07-27T10:23:33.196850+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39693 4481 swimming_water_temperature 2019-07-27T17:56:24.705394+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39693 4531 swimming_water_temperature 2019-07-28T14:35:09.808986+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39693 4532 swimming_water_temperature 2019-07-28T14:45:56.711015+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39693 4552 swimming_water_temperature 2019-07-28T18:01:57.460940+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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
39815 4474 swimming_water_temperature 2019-07-27T17:41:54.574327+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 4485 swimming_water_temperature 2019-07-27T20:33:09.382850+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 4520 swimming_water_temperature 2019-07-28T13:58:05.603518+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 4550 swimming_water_temperature 2019-07-28T17:57:03.719199+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 5897 swimming_water_temperature 2019-08-19T16:08:38.740058+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 9621 swimming_water_temperature 2020-06-17T17:58:54.496045+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 9693 swimming_water_temperature 2020-06-18T17:52:52.852145+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
39815 9879 swimming_water_temperature 2020-06-22T17:59:57.791073+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
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