servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
53563 6831 ice_skating_field_condition 2020-01-14T15:00:22.360874+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42699 6832 ice_skating_field_condition 2020-01-14T16:16:59.222264+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 6859 ice_skating_field_condition 2020-01-16T09:45:01.903463+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40402 6864 ice_skating_field_condition 2020-01-16T14:21:36.304981+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 6866 ice_skating_field_condition 2020-01-16T15:10:26.385509+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53563 6867 ice_skating_field_condition 2020-01-16T15:10:41.394712+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53563 6868 ice_skating_field_condition 2020-01-16T18:17:16.461445+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42185 6886 ice_skating_field_condition 2020-01-17T12:34:29.999132+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  
39834 6891 ice_skating_field_condition 2020-01-17T14:48:15.891076+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 6912 ice_skating_field_condition 2020-01-18T14:44:34.605732+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53563 6913 ice_skating_field_condition 2020-01-18T14:45:02.785453+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42185 6919 ice_skating_field_condition 2020-01-19T08:23:19.984872+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53524 6922 ice_skating_field_condition 2020-01-19T08:32:16.848348+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53524 6924 ice_skating_field_condition 2020-01-19T08:34:55.538700+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
47279 6925 ice_skating_field_condition 2020-01-19T08:39:52.892792+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53615 6926 ice_skating_field_condition 2020-01-19T08:40:18.552544+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  
40421 6956 ice_skating_field_condition 2020-01-20T11:28:15.809542+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 6966 ice_skating_field_condition 2020-01-21T06:57:12.566365+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 6976 ice_skating_field_condition 2020-01-21T09:45:15.092308+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42699 6986 ice_skating_field_condition 2020-01-21T15:54:49.664977+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42699 7040 ice_skating_field_condition 2020-01-24T10:19:38.985332+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53563 7046 ice_skating_field_condition 2020-01-24T15:20:15.302312+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 7047 ice_skating_field_condition 2020-01-24T15:20:29.671490+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7079 ice_skating_field_condition 2020-01-26T10:01:49.316444+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53563 7086 ice_skating_field_condition 2020-01-27T07:17:57.867407+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42699 7091 ice_skating_field_condition 2020-01-27T08:05:42.604439+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42185 7092 ice_skating_field_condition 2020-01-27T08:14:02.276283+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  
53523 7094 ice_skating_field_condition 2020-01-27T08:17:50.365336+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53524 7095 ice_skating_field_condition 2020-01-27T08:18:08.731590+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40402 7098 ice_skating_field_condition 2020-01-27T08:35:08.491965+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 7100 ice_skating_field_condition 2020-01-27T09:01:51.922726+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7101 ice_skating_field_condition 2020-01-27T09:04:09.156021+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42699 7107 ice_skating_field_condition 2020-01-27T19:11:27.496931+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53523 7108 ice_skating_field_condition 2020-01-28T07:30:39.697321+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53524 7109 ice_skating_field_condition 2020-01-28T07:30:52.438593+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53615 7110 ice_skating_field_condition 2020-01-28T07:55:56.079334+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
47279 7111 ice_skating_field_condition 2020-01-28T07:56:12.610146+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 7113 ice_skating_field_condition 2020-01-28T08:43:57.570540+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7116 ice_skating_field_condition 2020-01-28T10:19:13.343558+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53563 7118 ice_skating_field_condition 2020-01-28T11:52:21.507001+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42185 7120 ice_skating_field_condition 2020-01-28T13:56:50.876268+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42699 7125 ice_skating_field_condition 2020-01-28T17:59:57.417582+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53615 7129 ice_skating_field_condition 2020-01-29T07:51:15.654848+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53523 7135 ice_skating_field_condition 2020-01-29T08:39:39.504112+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53524 7136 ice_skating_field_condition 2020-01-29T08:39:46.141636+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42699 7137 ice_skating_field_condition 2020-01-29T09:32:20.443385+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  
42185 7141 ice_skating_field_condition 2020-01-29T19:00:09.592568+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53563 7142 ice_skating_field_condition 2020-01-30T07:24:30.199056+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40402 7145 ice_skating_field_condition 2020-01-30T07:47:06.528957+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
47279 7147 ice_skating_field_condition 2020-01-30T07:49:56.837903+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53615 7150 ice_skating_field_condition 2020-01-30T08:35:26.062231+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 7151 ice_skating_field_condition 2020-01-30T08:44:27.590486+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42699 7152 ice_skating_field_condition 2020-01-30T08:46:08.120846+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42185 7155 ice_skating_field_condition 2020-01-30T08:57:50.495046+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7157 ice_skating_field_condition 2020-01-30T09:10:52.174189+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53523 7158 ice_skating_field_condition 2020-01-30T11:51:00.512077+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53524 7159 ice_skating_field_condition 2020-01-30T11:51:08.375969+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42185 7170 ice_skating_field_condition 2020-01-31T08:28:01.138106+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53524 7172 ice_skating_field_condition 2020-01-31T08:31:31.831100+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7173 ice_skating_field_condition 2020-01-31T09:05:31.734764+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53523 7174 ice_skating_field_condition 2020-01-31T09:27:12.638102+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42699 7180 ice_skating_field_condition 2020-01-31T12:28:57.132094+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
46144 7185 ice_skating_field_condition 2020-02-01T09:10:54.364537+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7188 ice_skating_field_condition 2020-02-01T09:44:47.686837+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42185 7202 ice_skating_field_condition 2020-02-02T08:11:05.410374+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  
46144 7205 ice_skating_field_condition 2020-02-02T08:59:10.545204+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7208 ice_skating_field_condition 2020-02-02T09:28:57.091991+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40402 7209 ice_skating_field_condition 2020-02-02T12:02:42.556980+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
46144 7210 ice_skating_field_condition 2020-02-02T12:42:28.417402+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
46144 7213 ice_skating_field_condition 2020-02-02T16:09:39.459985+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7228 ice_skating_field_condition 2020-02-03T09:42:18.557760+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7240 ice_skating_field_condition 2020-02-04T09:31:03.710741+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7338 ice_skating_field_condition 2020-02-06T09:09:35.309980+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40013 7428 ice_skating_field_condition 2020-02-08T07:06:18.408892+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  
50354 7431 ice_skating_field_condition 2020-02-08T07:48:56.825987+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  
53615 7433 ice_skating_field_condition 2020-02-08T07:49:16.291676+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42249 7434 ice_skating_field_condition 2020-02-08T08:20:45.432821+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
61464 7439 ice_skating_field_condition 2020-02-08T09:21:27.512535+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42241 7440 ice_skating_field_condition 2020-02-08T09:34:55.637011+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40040 7441 ice_skating_field_condition 2020-02-08T09:35:23.564237+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42699 7442 ice_skating_field_condition 2020-02-08T09:45:11.320090+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7445 ice_skating_field_condition 2020-02-08T09:58:03.764478+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  
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  
53615 7476 ice_skating_field_condition 2020-02-09T07:18:07.597018+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7483 ice_skating_field_condition 2020-02-09T09:20:19.901251+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53523 7484 ice_skating_field_condition 2020-02-09T09:38:57.442638+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53524 7485 ice_skating_field_condition 2020-02-09T09:39:03.720968+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  
42699 7496 ice_skating_field_condition 2020-02-09T12:02:03.244009+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 7502 ice_skating_field_condition 2020-02-09T15:16:42.742454+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53563 7503 ice_skating_field_condition 2020-02-09T15:17:05.537614+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