servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
39315 35593 ice_skating_field_condition 2020-11-21T13:20:57.681976+0200     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  
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  
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  
39370 6060 ice_skating_field_condition 2019-11-18T10:20:37.379298+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  
39370 6149 ice_skating_field_condition 2019-11-26T11:34:35.053176+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  
39370 6501 ice_skating_field_condition 2019-12-23T11:31:10.081674+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 8099 ice_skating_field_condition 2020-03-06T12:02:09.316656+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 36452 ice_skating_field_condition 2020-11-24T11:38:16.866746+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 39243 ice_skating_field_condition 2020-12-03T08:56:55.015031+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 40854 ice_skating_field_condition 2020-12-08T10:02:17.482732+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 41310 ice_skating_field_condition 2020-12-09T18:33:02.480111+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 42235 ice_skating_field_condition 2020-12-12T15:34:38.692585+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 42466 ice_skating_field_condition 2020-12-13T08:54:40.315526+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 43827 ice_skating_field_condition 2020-12-17T12:11:54.753247+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 43830 ice_skating_field_condition 2020-12-17T12:12:18.898587+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 46208 ice_skating_field_condition 2020-12-23T14:07:44.142464+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 46214 ice_skating_field_condition 2020-12-23T14:09:34.712720+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 46853 ice_skating_field_condition 2020-12-25T13:22:20.390199+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 47162 ice_skating_field_condition 2020-12-26T09:15:19.527523+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 47332 ice_skating_field_condition 2020-12-26T17:32:33.126686+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 49749 ice_skating_field_condition 2021-01-01T16:41:06.870108+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39370 49984 ice_skating_field_condition 2021-01-02T08:33:48.816201+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39663 46784 ice_skating_field_condition 2020-12-25T10:11:39.089664+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39675 35786 ice_skating_field_condition 2020-11-22T08:29:26.252257+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  
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  
39834 6073 ice_skating_field_condition 2019-11-22T08:40:47.737391+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  
39834 6086 ice_skating_field_condition 2019-11-24T08:54:04.462734+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  
39834 6159 ice_skating_field_condition 2019-11-27T09:07:01.645931+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  
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  
39834 6227 ice_skating_field_condition 2019-12-03T14:37:30.361057+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  
39834 6247 ice_skating_field_condition 2019-12-04T14:53:29.416610+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  
39834 6297 ice_skating_field_condition 2019-12-08T09:59:07.693072+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  
39834 6368 ice_skating_field_condition 2019-12-12T11:35:37.457672+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  
39834 6411 ice_skating_field_condition 2019-12-16T08:48:27.775922+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  
39834 6448 ice_skating_field_condition 2019-12-19T09:16:12.258500+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6504 ice_skating_field_condition 2019-12-23T15:16:07.085490+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6541 ice_skating_field_condition 2019-12-27T11:32:14.787149+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6542 ice_skating_field_condition 2019-12-27T15:00:57.610950+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6556 ice_skating_field_condition 2019-12-28T09:25:48.151251+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6559 ice_skating_field_condition 2019-12-28T15:12:16.270449+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6578 ice_skating_field_condition 2019-12-29T10:46:02.284147+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6582 ice_skating_field_condition 2019-12-29T14:56:55.092507+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6604 ice_skating_field_condition 2019-12-31T08:47:56.168864+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6624 ice_skating_field_condition 2020-01-02T08:33:24.148580+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6658 ice_skating_field_condition 2020-01-04T08:51:58.779423+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6675 ice_skating_field_condition 2020-01-05T08:46:03.623845+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6727 ice_skating_field_condition 2020-01-09T09:44:38.639017+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6771 ice_skating_field_condition 2020-01-11T16:02:50.446604+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6893 ice_skating_field_condition 2020-01-17T15:24:42.889765+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6910 ice_skating_field_condition 2020-01-18T11:39:28.771945+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6939 ice_skating_field_condition 2020-01-19T14:16:38.721196+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6954 ice_skating_field_condition 2020-01-20T10:21:39.519308+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6955 ice_skating_field_condition 2020-01-20T10:21:43.888929+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6962 ice_skating_field_condition 2020-01-20T14:26:36.260095+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6979 ice_skating_field_condition 2020-01-21T11:11:20.029150+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 6985 ice_skating_field_condition 2020-01-21T14:59:22.284842+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7002 ice_skating_field_condition 2020-01-22T11:48:17.358387+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7009 ice_skating_field_condition 2020-01-22T16:48:48.074959+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7019 ice_skating_field_condition 2020-01-23T09:46:10.050272+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7023 ice_skating_field_condition 2020-01-23T16:37:08.039424+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7028 ice_skating_field_condition 2020-01-24T08:40:44.543729+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7056 ice_skating_field_condition 2020-01-25T08:53:33.479936+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7064 ice_skating_field_condition 2020-01-25T16:03:48.041010+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7076 ice_skating_field_condition 2020-01-26T09:06:15.434897+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7084 ice_skating_field_condition 2020-01-26T14:43:20.023098+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7106 ice_skating_field_condition 2020-01-27T16:14:07.004565+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7177 ice_skating_field_condition 2020-01-31T10:21:05.553240+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7193 ice_skating_field_condition 2020-02-01T11:46:15.767729+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7212 ice_skating_field_condition 2020-02-02T14:23:36.871642+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7226 ice_skating_field_condition 2020-02-03T09:17:33.621370+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7262 ice_skating_field_condition 2020-02-04T14:30:57.120387+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7285 ice_skating_field_condition 2020-02-05T08:43:31.868580+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7310 ice_skating_field_condition 2020-02-05T10:38:48.724560+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7316 ice_skating_field_condition 2020-02-05T14:33:09.393375+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7363 ice_skating_field_condition 2020-02-06T14:47:43.580262+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7482 ice_skating_field_condition 2020-02-09T09:12:15.519454+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7564 ice_skating_field_condition 2020-02-11T11:43:48.953172+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7589 ice_skating_field_condition 2020-02-12T08:36:52.843696+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7600 ice_skating_field_condition 2020-02-12T15:40:51.111922+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 7622 ice_skating_field_condition 2020-02-13T15:16:52.211855+0200     Jäädytetty   Isad 1 Ice-covered frozen good