servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
41976 5988 ice_skating_field_condition 2019-09-10T08:18:25.228210+0300     Jäädytetty   Isad 1 Ice-covered frozen good  
40201 6007 ice_skating_field_condition 2019-10-10T14:35:54.667908+0300     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 6020 ice_skating_field_condition 2019-11-11T12:38:51.856733+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6023 ice_skating_field_condition 2019-11-11T13:39:10.373117+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6028 ice_skating_field_condition 2019-11-12T08:49:09.303828+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 6031 ice_skating_field_condition 2019-11-12T09:38:30.127423+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 6033 ice_skating_field_condition 2019-11-12T11:48:27.342025+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40550 6035 ice_skating_field_condition 2019-11-12T12:50:31.638369+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
43205 6038 ice_skating_field_condition 2019-11-12T12:51:28.037292+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 6041 ice_skating_field_condition 2019-11-14T11:00:02.037902+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 6045 ice_skating_field_condition 2019-11-15T12:41:12.060308+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6046 ice_skating_field_condition 2019-11-15T12:54:16.670431+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6049 ice_skating_field_condition 2019-11-16T08:28:44.086080+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6050 ice_skating_field_condition 2019-11-16T08:28:52.938038+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6051 ice_skating_field_condition 2019-11-16T18:17:06.273807+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6053 ice_skating_field_condition 2019-11-17T09:57:49.502114+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6054 ice_skating_field_condition 2019-11-17T09:57:57.917092+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6055 ice_skating_field_condition 2019-11-17T09:58:02.152657+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6056 ice_skating_field_condition 2019-11-17T15:22:29.773006+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 6057 ice_skating_field_condition 2019-11-18T07:28:12.175017+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 6060 ice_skating_field_condition 2019-11-18T10:20:37.379298+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6061 ice_skating_field_condition 2019-11-18T11:53:23.349645+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6066 ice_skating_field_condition 2019-11-18T16:08:20.353856+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6070 ice_skating_field_condition 2019-11-20T11:23:04.032825+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6071 ice_skating_field_condition 2019-11-21T19:18:45.657208+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6072 ice_skating_field_condition 2019-11-22T08:20:16.830362+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6073 ice_skating_field_condition 2019-11-22T08:40:47.737391+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6076 ice_skating_field_condition 2019-11-22T17:41:09.041273+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6077 ice_skating_field_condition 2019-11-23T07:45:38.397211+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6078 ice_skating_field_condition 2019-11-23T08:55:38.247230+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6085 ice_skating_field_condition 2019-11-24T08:12:59.550914+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6086 ice_skating_field_condition 2019-11-24T08:54:04.462734+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6098 ice_skating_field_condition 2019-11-25T08:32:40.460336+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 6101 ice_skating_field_condition 2019-11-25T09:14:44.118270+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 6103 ice_skating_field_condition 2019-11-25T09:17:31.674678+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42852 6105 ice_skating_field_condition 2019-11-25T09:41:04.381497+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42526 6106 ice_skating_field_condition 2019-11-25T09:41:27.657675+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 6109 ice_skating_field_condition 2019-11-25T10:51:26.977518+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6110 ice_skating_field_condition 2019-11-25T11:05:20.242286+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
46144 6112 ice_skating_field_condition 2019-11-25T11:11:37.430631+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
46144 6115 ice_skating_field_condition 2019-11-25T11:11:58.166068+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42699 6116 ice_skating_field_condition 2019-11-25T11:12:48.089288+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41549 6117 ice_skating_field_condition 2019-11-25T11:18:14.826235+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41549 6118 ice_skating_field_condition 2019-11-25T11:37:37.566506+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6123 ice_skating_field_condition 2019-11-25T15:42:25.590641+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6124 ice_skating_field_condition 2019-11-26T07:58:51.213053+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
46144 6129 ice_skating_field_condition 2019-11-26T08:55:41.408252+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42699 6130 ice_skating_field_condition 2019-11-26T08:55:56.260054+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 6131 ice_skating_field_condition 2019-11-26T09:14:49.768523+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41549 6132 ice_skating_field_condition 2019-11-26T09:31:56.863994+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41549 6133 ice_skating_field_condition 2019-11-26T09:41:15.637472+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 6134 ice_skating_field_condition 2019-11-26T09:56:17.218914+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 6135 ice_skating_field_condition 2019-11-26T09:56:22.650732+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53563 6139 ice_skating_field_condition 2019-11-26T10:25:55.899082+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42852 6141 ice_skating_field_condition 2019-11-26T10:32:34.491592+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42526 6142 ice_skating_field_condition 2019-11-26T10:32:46.033216+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 6149 ice_skating_field_condition 2019-11-26T11:34:35.053176+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
46144 6150 ice_skating_field_condition 2019-11-26T13:58:47.902817+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6151 ice_skating_field_condition 2019-11-26T15:42:10.754903+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 6152 ice_skating_field_condition 2019-11-26T16:33:25.561030+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 6154 ice_skating_field_condition 2019-11-27T07:16:49.520197+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6155 ice_skating_field_condition 2019-11-27T08:19:13.418414+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53563 6156 ice_skating_field_condition 2019-11-27T08:28:38.201739+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41549 6158 ice_skating_field_condition 2019-11-27T09:03:08.881066+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6159 ice_skating_field_condition 2019-11-27T09:07:01.645931+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 6165 ice_skating_field_condition 2019-11-28T07:06:02.774139+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53563 6167 ice_skating_field_condition 2019-11-28T07:47:06.018019+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 6169 ice_skating_field_condition 2019-11-28T08:42:44.530149+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6170 ice_skating_field_condition 2019-11-28T08:44:58.143862+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 6177 ice_skating_field_condition 2019-11-30T08:36:51.686804+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6178 ice_skating_field_condition 2019-11-30T08:37:04.260422+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40725 6182 ice_skating_field_condition 2019-11-30T14:16:26.680528+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6188 ice_skating_field_condition 2019-11-30T15:28:38.046092+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6189 ice_skating_field_condition 2019-11-30T15:28:40.421511+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53563 6190 ice_skating_field_condition 2019-11-30T15:28:50.673211+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42526 6193 ice_skating_field_condition 2019-11-30T16:09:03.260912+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 6195 ice_skating_field_condition 2019-12-01T09:29:22.068204+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6196 ice_skating_field_condition 2019-12-01T09:29:44.832465+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 6197 ice_skating_field_condition 2019-12-01T09:38:49.859244+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 6198 ice_skating_field_condition 2019-12-01T09:39:08.231451+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53563 6202 ice_skating_field_condition 2019-12-01T18:49:03.388511+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40493 6204 ice_skating_field_condition 2019-12-02T06:36:24.249080+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6209 ice_skating_field_condition 2019-12-02T08:37:06.492448+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 6210 ice_skating_field_condition 2019-12-02T08:38:58.204779+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 6211 ice_skating_field_condition 2019-12-02T10:20:56.683189+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 6213 ice_skating_field_condition 2019-12-02T12:47:54.665036+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 6214 ice_skating_field_condition 2019-12-02T12:48:12.538048+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 6216 ice_skating_field_condition 2019-12-03T07:07:11.332542+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 6217 ice_skating_field_condition 2019-12-03T08:35:18.715948+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 6218 ice_skating_field_condition 2019-12-03T08:35:19.909809+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 6219 ice_skating_field_condition 2019-12-03T08:35:36.289105+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
51402 6220 ice_skating_field_condition 2019-12-03T08:51:31.988258+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6221 ice_skating_field_condition 2019-12-03T08:57:36.672279+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40402 6223 ice_skating_field_condition 2019-12-03T09:06:01.593874+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
50354 6224 ice_skating_field_condition 2019-12-03T11:31:34.403950+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6227 ice_skating_field_condition 2019-12-03T14:37:30.361057+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53563 6228 ice_skating_field_condition 2019-12-03T16:03:48.863301+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 6229 ice_skating_field_condition 2019-12-04T07:08:08.678077+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 6230 ice_skating_field_condition 2019-12-04T07:32:47.615172+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40402 6231 ice_skating_field_condition 2019-12-04T07:34:55.655757+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6238 ice_skating_field_condition 2019-12-04T08:45:25.897006+0200     Jäädytetty   Isad 1 Ice-covered frozen good