servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
53615 6068 ice_skating_field_condition 2019-11-19T16:48:00.193786+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53615 6069 ice_skating_field_condition 2019-11-20T08:43:13.642764+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42852 6107 ice_skating_field_condition 2019-11-25T09:43:48.162988+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42526 6108 ice_skating_field_condition 2019-11-25T09:44:25.224077+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
46144 6113 ice_skating_field_condition 2019-11-25T11:11:43.205941+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
46144 6128 ice_skating_field_condition 2019-11-26T08:55:36.648076+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42852 6143 ice_skating_field_condition 2019-11-26T10:34:45.266526+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42526 6144 ice_skating_field_condition 2019-11-26T10:35:05.067897+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
46144 6145 ice_skating_field_condition 2019-11-26T10:35:42.508793+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42699 6146 ice_skating_field_condition 2019-11-26T10:35:57.982288+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
46144 6153 ice_skating_field_condition 2019-11-26T19:31:48.784188+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53615 6166 ice_skating_field_condition 2019-11-28T07:26:39.378359+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  
41770 6176 ice_skating_field_condition 2019-11-29T20:39:43.931626+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42526 6191 ice_skating_field_condition 2019-11-30T16:08:57.940097+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42526 6192 ice_skating_field_condition 2019-11-30T16:08:57.990103+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42852 6194 ice_skating_field_condition 2019-11-30T16:09:15.245065+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 6203 ice_skating_field_condition 2019-12-01T18:49:21.145615+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42526 6215 ice_skating_field_condition 2019-12-02T14:09:55.944068+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  
53615 6256 ice_skating_field_condition 2019-12-05T08:18:51.190959+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53563 6268 ice_skating_field_condition 2019-12-06T16:18:19.963065+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 6269 ice_skating_field_condition 2019-12-06T16:19:13.675861+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53615 6276 ice_skating_field_condition 2019-12-07T09:45:36.715951+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53615 6277 ice_skating_field_condition 2019-12-07T09:45:43.825119+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53563 6278 ice_skating_field_condition 2019-12-07T11:34:18.389811+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 6279 ice_skating_field_condition 2019-12-07T11:34:27.315239+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  
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  
42185 6312 ice_skating_field_condition 2019-12-09T18:49:14.494178+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53615 6315 ice_skating_field_condition 2019-12-10T08:34:49.572512+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  
41770 6318 ice_skating_field_condition 2019-12-10T09:03:19.546316+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42852 6319 ice_skating_field_condition 2019-12-10T10:20:33.982313+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
46144 6323 ice_skating_field_condition 2019-12-10T13:30:29.428737+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53615 6365 ice_skating_field_condition 2019-12-12T09:23:29.595050+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
47279 6394 ice_skating_field_condition 2019-12-14T17:18:59.281156+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53615 6397 ice_skating_field_condition 2019-12-15T09:01:34.898744+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
47279 6398 ice_skating_field_condition 2019-12-15T09:01:59.549022+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53524 6399 ice_skating_field_condition 2019-12-15T10:00:44.447329+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53523 6400 ice_skating_field_condition 2019-12-15T10:00:56.550334+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  
53524 6415 ice_skating_field_condition 2019-12-16T10:04:15.049415+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53523 6416 ice_skating_field_condition 2019-12-16T10:04:49.479697+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
47279 6422 ice_skating_field_condition 2019-12-17T07:25:35.700039+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53615 6423 ice_skating_field_condition 2019-12-17T07:25:47.162629+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
46144 6425 ice_skating_field_condition 2019-12-17T08:42:01.437711+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53523 6426 ice_skating_field_condition 2019-12-17T09:14:54.828452+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53524 6427 ice_skating_field_condition 2019-12-17T09:15:04.284350+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  
47279 6439 ice_skating_field_condition 2019-12-18T20:25:59.692407+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53523 6449 ice_skating_field_condition 2019-12-19T09:44:46.755132+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53524 6450 ice_skating_field_condition 2019-12-19T09:45:02.272158+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53615 6480 ice_skating_field_condition 2019-12-22T08:12:23.768639+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53615 6500 ice_skating_field_condition 2019-12-23T10:40:03.289903+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
47279 6521 ice_skating_field_condition 2019-12-26T09:19:02.929863+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53615 6522 ice_skating_field_condition 2019-12-26T09:19:15.134912+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53524 6523 ice_skating_field_condition 2019-12-26T10:00:37.631415+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53523 6524 ice_skating_field_condition 2019-12-26T10:01:12.053513+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
47279 6527 ice_skating_field_condition 2019-12-27T07:14:41.665707+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53615 6528 ice_skating_field_condition 2019-12-27T07:14:48.857940+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  
41770 6532 ice_skating_field_condition 2019-12-27T08:14:38.262025+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  
41770 6589 ice_skating_field_condition 2019-12-30T10:56:43.457255+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53523 6591 ice_skating_field_condition 2019-12-30T12:18:18.871219+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53524 6592 ice_skating_field_condition 2019-12-30T12:18:31.031445+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 6593 ice_skating_field_condition 2019-12-30T14:57:05.376948+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53563 6594 ice_skating_field_condition 2019-12-30T14:57:24.377111+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53563 6595 ice_skating_field_condition 2019-12-30T19:27:41.657738+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  
41770 6614 ice_skating_field_condition 2020-01-01T12:16:17.186336+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  
41770 6628 ice_skating_field_condition 2020-01-02T09:17:13.530853+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53523 6640 ice_skating_field_condition 2020-01-03T09:14:41.614767+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53524 6641 ice_skating_field_condition 2020-01-03T09:14:46.378735+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53524 6642 ice_skating_field_condition 2020-01-03T09:14:50.453486+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53615 6656 ice_skating_field_condition 2020-01-04T08:25:22.197372+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  
42185 6693 ice_skating_field_condition 2020-01-06T12:25:49.584450+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53563 6706 ice_skating_field_condition 2020-01-07T07:53:35.498007+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53523 6707 ice_skating_field_condition 2020-01-07T08:55:56.160294+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53524 6708 ice_skating_field_condition 2020-01-07T08:56:02.190243+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 6709 ice_skating_field_condition 2020-01-07T09:44:56.590761+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
47279 6713 ice_skating_field_condition 2020-01-08T07:08:51.887080+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53615 6714 ice_skating_field_condition 2020-01-08T07:09:30.837837+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53523 6718 ice_skating_field_condition 2020-01-08T08:29:01.310647+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53524 6719 ice_skating_field_condition 2020-01-08T08:29:08.133111+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
46144 6768 ice_skating_field_condition 2020-01-11T15:54:33.698929+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42185 6784 ice_skating_field_condition 2020-01-12T09:32:49.063627+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  
40402 6788 ice_skating_field_condition 2020-01-12T11:10:07.888152+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
46144 6789 ice_skating_field_condition 2020-01-12T11:24:00.937355+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
46144 6790 ice_skating_field_condition 2020-01-12T11:24:20.908524+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 6792 ice_skating_field_condition 2020-01-12T12:56:27.436367+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
46144 6794 ice_skating_field_condition 2020-01-12T16:04:51.645585+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 6830 ice_skating_field_condition 2020-01-14T15:00:00.976818+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53563 6831 ice_skating_field_condition 2020-01-14T15:00:22.360874+0200     Aurattu   Plogad 1 Cleared of snow plowed good