servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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 10091 swimming_water_temperature 2020-06-24T17:44:09.829835+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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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 10160 swimming_water_temperature 2020-06-25T13:56:22.084914+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  
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  
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  
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