servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
39834 6238 ice_skating_field_condition 2019-12-04T08:45:25.897006+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53563 6239 ice_skating_field_condition 2019-12-04T08:45:44.437487+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 6242 ice_skating_field_condition 2019-12-04T09:03:04.364640+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 6243 ice_skating_field_condition 2019-12-04T09:03:19.822177+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 6244 ice_skating_field_condition 2019-12-04T09:29:59.277886+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 6245 ice_skating_field_condition 2019-12-04T09:30:11.621193+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40402 6246 ice_skating_field_condition 2019-12-04T12:43:51.766804+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6247 ice_skating_field_condition 2019-12-04T14:53:29.416610+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53563 6248 ice_skating_field_condition 2019-12-04T14:53:44.696649+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 6255 ice_skating_field_condition 2019-12-05T07:24:18.010882+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40402 6257 ice_skating_field_condition 2019-12-05T10:07:15.036459+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41549 6258 ice_skating_field_condition 2019-12-05T12:13:57.927416+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 6262 ice_skating_field_condition 2019-12-05T13:40:59.557937+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 6263 ice_skating_field_condition 2019-12-05T13:41:19.158236+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6264 ice_skating_field_condition 2019-12-05T14:50:22.152246+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53563 6265 ice_skating_field_condition 2019-12-05T14:50:46.549796+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40402 6266 ice_skating_field_condition 2019-12-06T09:54:15.176953+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
46144 6267 ice_skating_field_condition 2019-12-06T13:30:58.400233+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 6270 ice_skating_field_condition 2019-12-07T08:40:27.709421+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 6271 ice_skating_field_condition 2019-12-07T08:44:57.287150+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 6272 ice_skating_field_condition 2019-12-07T08:45:16.186406+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42699 6282 ice_skating_field_condition 2019-12-07T16:07:17.694802+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
46144 6283 ice_skating_field_condition 2019-12-07T16:07:27.250189+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42852 6284 ice_skating_field_condition 2019-12-07T16:07:47.833127+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42526 6285 ice_skating_field_condition 2019-12-07T16:08:13.818363+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 6290 ice_skating_field_condition 2019-12-08T08:44:54.400892+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6291 ice_skating_field_condition 2019-12-08T08:45:08.545750+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 6294 ice_skating_field_condition 2019-12-08T09:33:33.267564+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 6295 ice_skating_field_condition 2019-12-08T09:33:56.806562+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53563 6296 ice_skating_field_condition 2019-12-08T09:59:01.316770+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6297 ice_skating_field_condition 2019-12-08T09:59:07.693072+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40402 6298 ice_skating_field_condition 2019-12-08T13:46:25.009053+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6299 ice_skating_field_condition 2019-12-08T15:08:15.828425+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53563 6300 ice_skating_field_condition 2019-12-08T15:08:35.642695+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 6302 ice_skating_field_condition 2019-12-09T08:43:35.498157+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40402 6303 ice_skating_field_condition 2019-12-09T08:49:02.787774+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6307 ice_skating_field_condition 2019-12-09T12:21:08.062748+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40402 6313 ice_skating_field_condition 2019-12-10T08:14:47.219049+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40493 6314 ice_skating_field_condition 2019-12-10T08:17:00.479929+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 6316 ice_skating_field_condition 2019-12-10T08:35:03.903911+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40402 6330 ice_skating_field_condition 2019-12-11T07:50:04.950286+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6335 ice_skating_field_condition 2019-12-11T08:50:33.543217+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 6336 ice_skating_field_condition 2019-12-11T08:50:46.998901+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
46144 6341 ice_skating_field_condition 2019-12-11T09:06:33.881352+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53524 6344 ice_skating_field_condition 2019-12-11T12:04:43.364849+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 6361 ice_skating_field_condition 2019-12-12T08:05:31.631899+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 6362 ice_skating_field_condition 2019-12-12T08:05:40.481853+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40402 6363 ice_skating_field_condition 2019-12-12T08:38:08.255814+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 6364 ice_skating_field_condition 2019-12-12T09:23:12.377825+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53524 6366 ice_skating_field_condition 2019-12-12T10:09:07.826603+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53563 6367 ice_skating_field_condition 2019-12-12T11:34:58.971298+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6368 ice_skating_field_condition 2019-12-12T11:35:37.457672+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
46144 6370 ice_skating_field_condition 2019-12-12T14:01:43.782670+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41549 6371 ice_skating_field_condition 2019-12-12T16:34:49.332448+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 6372 ice_skating_field_condition 2019-12-13T08:43:58.184758+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 6373 ice_skating_field_condition 2019-12-13T08:44:06.222435+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
46144 6374 ice_skating_field_condition 2019-12-13T08:58:00.654651+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40402 6375 ice_skating_field_condition 2019-12-13T09:16:55.051453+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 6376 ice_skating_field_condition 2019-12-13T09:18:52.768741+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6377 ice_skating_field_condition 2019-12-13T09:19:14.052428+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53524 6378 ice_skating_field_condition 2019-12-13T09:58:16.014618+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53563 6382 ice_skating_field_condition 2019-12-14T08:01:12.367656+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6383 ice_skating_field_condition 2019-12-14T09:10:00.050636+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53523 6384 ice_skating_field_condition 2019-12-14T10:21:28.220619+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53524 6385 ice_skating_field_condition 2019-12-14T10:21:38.947923+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40493 6386 ice_skating_field_condition 2019-12-14T10:24:05.471248+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41549 6389 ice_skating_field_condition 2019-12-14T11:33:30.492289+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42699 6390 ice_skating_field_condition 2019-12-14T15:25:02.205631+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42526 6391 ice_skating_field_condition 2019-12-14T15:25:16.188973+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42852 6392 ice_skating_field_condition 2019-12-14T15:25:27.644863+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
46144 6393 ice_skating_field_condition 2019-12-14T15:25:34.116156+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40402 6405 ice_skating_field_condition 2019-12-15T16:35:43.228859+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53563 6406 ice_skating_field_condition 2019-12-16T08:03:54.181138+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 6407 ice_skating_field_condition 2019-12-16T08:18:36.314481+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 6408 ice_skating_field_condition 2019-12-16T08:18:44.089211+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41549 6409 ice_skating_field_condition 2019-12-16T08:31:52.812089+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41549 6410 ice_skating_field_condition 2019-12-16T08:32:10.719138+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6411 ice_skating_field_condition 2019-12-16T08:48:27.775922+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 6412 ice_skating_field_condition 2019-12-16T08:58:34.648224+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6413 ice_skating_field_condition 2019-12-16T08:58:59.610183+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40402 6414 ice_skating_field_condition 2019-12-16T09:58:24.536121+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
46144 6419 ice_skating_field_condition 2019-12-16T14:32:54.320027+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53563 6420 ice_skating_field_condition 2019-12-16T14:36:08.335999+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6421 ice_skating_field_condition 2019-12-16T14:36:15.050222+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40402 6424 ice_skating_field_condition 2019-12-17T08:17:27.644282+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
46144 6430 ice_skating_field_condition 2019-12-17T12:47:00.553065+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40493 6431 ice_skating_field_condition 2019-12-17T15:54:42.830521+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40402 6432 ice_skating_field_condition 2019-12-18T08:23:38.560529+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53563 6440 ice_skating_field_condition 2019-12-19T06:55:19.684179+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 6443 ice_skating_field_condition 2019-12-19T08:25:33.128922+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6444 ice_skating_field_condition 2019-12-19T08:25:56.447237+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40402 6447 ice_skating_field_condition 2019-12-19T09:13:11.947752+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6448 ice_skating_field_condition 2019-12-19T09:16:12.258500+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 6451 ice_skating_field_condition 2019-12-19T12:47:45.520932+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 6452 ice_skating_field_condition 2019-12-19T12:48:33.980440+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 6453 ice_skating_field_condition 2019-12-19T18:09:00.192377+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 6454 ice_skating_field_condition 2019-12-19T18:09:30.299945+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 6459 ice_skating_field_condition 2019-12-20T08:39:35.721951+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 6460 ice_skating_field_condition 2019-12-20T08:40:04.716072+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 6461 ice_skating_field_condition 2019-12-20T08:41:31.389143+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6462 ice_skating_field_condition 2019-12-20T08:41:53.719106+0200     Jäädytetty   Isad 1 Ice-covered frozen good