servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
40421 7993 ice_skating_field_condition 2020-03-01T10:11:11.746497+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 8012 ice_skating_field_condition 2020-03-02T09:28:43.259514+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 8039 ice_skating_field_condition 2020-03-03T08:53:52.697861+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 8054 ice_skating_field_condition 2020-03-04T09:51:16.685194+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 8075 ice_skating_field_condition 2020-03-05T09:05:30.628893+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 8089 ice_skating_field_condition 2020-03-06T08:38:31.184543+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 40548 ice_skating_field_condition 2020-12-07T11:06:04.593444+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 40549 ice_skating_field_condition 2020-12-07T11:06:12.551078+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 43767 ice_skating_field_condition 2020-12-17T08:33:11.500465+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 46124 ice_skating_field_condition 2020-12-23T10:03:34.303346+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 48378 ice_skating_field_condition 2020-12-29T08:28:09.444452+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 49194 ice_skating_field_condition 2020-12-31T09:10:58.784530+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 49730 ice_skating_field_condition 2021-01-01T15:36:40.196064+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 50155 ice_skating_field_condition 2021-01-02T16:04:32.786529+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 50554 ice_skating_field_condition 2021-01-03T15:49:14.887724+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 50814 ice_skating_field_condition 2021-01-04T08:33:23.302497+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40438 6234 ice_skating_field_condition 2019-12-04T08:02:53.902024+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40455 7430 ice_skating_field_condition 2020-02-08T07:48:51.324598+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40455 7432 ice_skating_field_condition 2020-02-08T07:49:03.405727+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40493 6401 ice_skating_field_condition 2019-12-15T11:50:06.338212+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40493 46137 ice_skating_field_condition 2020-12-23T10:22:09.159264+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40493 47999 ice_skating_field_condition 2020-12-28T10:18:41.189772+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40493 48372 ice_skating_field_condition 2020-12-29T08:03:39.715570+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40493 48779 ice_skating_field_condition 2020-12-30T08:12:03.252495+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40493 48930 ice_skating_field_condition 2020-12-30T15:53:20.880025+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40493 49164 ice_skating_field_condition 2020-12-31T07:48:33.075406+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40493 49285 ice_skating_field_condition 2020-12-31T12:51:16.450478+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40493 49573 ice_skating_field_condition 2021-01-01T08:46:45.291733+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40493 50222 ice_skating_field_condition 2021-01-02T19:14:01.360460+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40493 50406 ice_skating_field_condition 2021-01-03T08:39:45.203053+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40493 50446 ice_skating_field_condition 2021-01-03T10:50:25.859806+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40493 50483 ice_skating_field_condition 2021-01-03T12:29:17.311470+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40493 50502 ice_skating_field_condition 2021-01-03T13:20:32.890468+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40725 7489 ice_skating_field_condition 2020-02-09T10:54:06.398555+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40934 7454 ice_skating_field_condition 2020-02-08T13:12:26.224648+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40934 7462 ice_skating_field_condition 2020-02-08T17:59:49.123909+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41096 7453 ice_skating_field_condition 2020-02-08T12:39:09.505436+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41549 46127 ice_skating_field_condition 2020-12-23T10:06:12.068045+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41549 47677 ice_skating_field_condition 2020-12-27T14:33:19.562478+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41608 49222 ice_skating_field_condition 2020-12-31T10:17:13.524716+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 6176 ice_skating_field_condition 2019-11-29T20:39:43.931626+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 6287 ice_skating_field_condition 2019-12-07T17:06:34.713219+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 6311 ice_skating_field_condition 2019-12-09T18:48:51.180019+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 6318 ice_skating_field_condition 2019-12-10T09:03:19.546316+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 6532 ice_skating_field_condition 2019-12-27T08:14:38.262025+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 6589 ice_skating_field_condition 2019-12-30T10:56:43.457255+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 6614 ice_skating_field_condition 2020-01-01T12:16:17.186336+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 6628 ice_skating_field_condition 2020-01-02T09:17:13.530853+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 6688 ice_skating_field_condition 2020-01-06T08:23:02.858368+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 6785 ice_skating_field_condition 2020-01-12T09:32:57.615187+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 6887 ice_skating_field_condition 2020-01-17T12:34:38.574441+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 6930 ice_skating_field_condition 2020-01-19T09:47:47.352804+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 7093 ice_skating_field_condition 2020-01-27T08:14:48.474896+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 7139 ice_skating_field_condition 2020-01-29T18:59:18.454413+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 7203 ice_skating_field_condition 2020-02-02T08:11:15.416832+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 7505 ice_skating_field_condition 2020-02-09T18:51:48.941454+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 7506 ice_skating_field_condition 2020-02-09T18:52:31.033722+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 7511 ice_skating_field_condition 2020-02-10T07:18:20.586407+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 7578 ice_skating_field_condition 2020-02-11T17:17:02.201271+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 7585 ice_skating_field_condition 2020-02-12T08:20:44.252055+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 7631 ice_skating_field_condition 2020-02-14T08:58:59.432549+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 7767 ice_skating_field_condition 2020-02-19T17:08:11.520469+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 7785 ice_skating_field_condition 2020-02-20T08:54:28.405653+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 7791 ice_skating_field_condition 2020-02-20T17:39:29.136893+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 7820 ice_skating_field_condition 2020-02-22T11:21:08.642754+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 7989 ice_skating_field_condition 2020-03-01T09:25:24.597533+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 7990 ice_skating_field_condition 2020-03-01T09:25:38.592085+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 8159 ice_skating_field_condition 2020-03-09T13:59:41.607623+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 8160 ice_skating_field_condition 2020-03-09T13:59:48.644568+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 8206 ice_skating_field_condition 2020-03-12T17:19:35.957808+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 8220 ice_skating_field_condition 2020-03-13T17:23:34.094671+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 39606 ice_skating_field_condition 2020-12-04T11:36:33.676699+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 43082 ice_skating_field_condition 2020-12-15T07:59:33.509067+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 43083 ice_skating_field_condition 2020-12-15T07:59:44.548921+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 43499 ice_skating_field_condition 2020-12-16T12:45:57.789307+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 44109 ice_skating_field_condition 2020-12-18T09:07:29.660992+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 44223 ice_skating_field_condition 2020-12-18T16:45:24.192592+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 44308 ice_skating_field_condition 2020-12-18T22:53:52.615015+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 44462 ice_skating_field_condition 2020-12-19T09:19:03.899786+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 46096 ice_skating_field_condition 2020-12-23T08:42:53.077392+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 46129 ice_skating_field_condition 2020-12-23T10:09:47.118072+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 47561 ice_skating_field_condition 2020-12-27T09:12:21.560363+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 47609 ice_skating_field_condition 2020-12-27T11:32:28.007843+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 48402 ice_skating_field_condition 2020-12-29T09:37:35.296207+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 48456 ice_skating_field_condition 2020-12-29T11:55:18.638365+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 48840 ice_skating_field_condition 2020-12-30T11:28:01.036102+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 49201 ice_skating_field_condition 2020-12-31T09:22:55.932893+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 49587 ice_skating_field_condition 2021-01-01T09:15:56.086948+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 50213 ice_skating_field_condition 2021-01-02T18:56:50.112833+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41805 49198 ice_skating_field_condition 2020-12-31T09:22:26.229235+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42185 6168 ice_skating_field_condition 2019-11-28T08:41:58.115490+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42185 6175 ice_skating_field_condition 2019-11-29T20:39:35.724042+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42185 6286 ice_skating_field_condition 2019-12-07T17:06:26.069486+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42185 6312 ice_skating_field_condition 2019-12-09T18:49:14.494178+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42185 6317 ice_skating_field_condition 2019-12-10T09:02:52.503670+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42185 6438 ice_skating_field_condition 2019-12-18T17:53:32.897531+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42185 6531 ice_skating_field_condition 2019-12-27T08:14:28.181535+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42185 6588 ice_skating_field_condition 2019-12-30T10:56:24.869647+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42185 6596 ice_skating_field_condition 2019-12-30T20:20:51.573083+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42185 6613 ice_skating_field_condition 2020-01-01T12:16:08.717657+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42185 6627 ice_skating_field_condition 2020-01-02T09:17:03.259292+0200     Aurattu   Plogad 1 Cleared of snow plowed good