servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
47279 51161 ice_skating_field_condition 2021-01-04T21:57:34.403708+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
63148 51140 ice_skating_field_condition 2021-01-04T20:39:45.794307+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
46144 51136 ice_skating_field_condition 2021-01-04T20:10:52.483239+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40493 51120 ice_skating_field_condition 2021-01-04T19:36:32.901669+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 51084 ice_skating_field_condition 2021-01-04T17:48:00.697438+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 51082 ice_skating_field_condition 2021-01-04T17:47:24.147192+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 51072 ice_skating_field_condition 2021-01-04T17:15:22.662801+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
46144 51057 ice_skating_field_condition 2021-01-04T16:38:22.468391+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40493 51043 ice_skating_field_condition 2021-01-04T15:49:13.821722+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
63148 51040 ice_skating_field_condition 2021-01-04T15:37:36.236905+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
63148 51039 ice_skating_field_condition 2021-01-04T15:37:14.866885+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
63148 51038 ice_skating_field_condition 2021-01-04T15:37:13.975225+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 51035 ice_skating_field_condition 2021-01-04T15:25:33.491015+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40493 50843 ice_skating_field_condition 2021-01-04T10:09:38.311784+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42249 50811 ice_skating_field_condition 2021-01-04T08:25:29.165792+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 50801 ice_skating_field_condition 2021-01-04T07:50:02.902094+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 50800 ice_skating_field_condition 2021-01-04T07:49:44.789500+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 50796 ice_skating_field_condition 2021-01-04T07:35:17.129029+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53563 50795 ice_skating_field_condition 2021-01-04T07:34:39.921956+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42249 50583 ice_skating_field_condition 2021-01-03T17:13:37.230197+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42249 50440 ice_skating_field_condition 2021-01-03T10:38:17.675431+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
63148 50069 ice_skating_field_condition 2021-01-02T12:26:49.327928+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
61464 50024 ice_skating_field_condition 2021-01-02T10:11:25.208516+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42249 50016 ice_skating_field_condition 2021-01-02T10:00:06.511791+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40493 49988 ice_skating_field_condition 2021-01-02T08:42:02.133172+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  
53615 49975 ice_skating_field_condition 2021-01-02T08:01:32.908182+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 49974 ice_skating_field_condition 2021-01-02T08:01:14.870146+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 49973 ice_skating_field_condition 2021-01-02T08:01:03.648651+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 49972 ice_skating_field_condition 2021-01-02T08:00:57.376635+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
63148 49965 ice_skating_field_condition 2021-01-02T07:31:23.626857+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  
53524 49686 ice_skating_field_condition 2021-01-01T13:14:28.278871+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53523 49685 ice_skating_field_condition 2021-01-01T13:14:20.885097+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 49662 ice_skating_field_condition 2021-01-01T12:04:55.807273+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42699 49646 ice_skating_field_condition 2021-01-01T11:21:23.839080+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 49642 ice_skating_field_condition 2021-01-01T11:11:37.944182+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 49591 ice_skating_field_condition 2021-01-01T09:16:51.869280+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 49590 ice_skating_field_condition 2021-01-01T09:16:41.104564+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 49588 ice_skating_field_condition 2021-01-01T09:16:25.012566+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 49586 ice_skating_field_condition 2021-01-01T09:15:50.628938+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42249 49578 ice_skating_field_condition 2021-01-01T08:52:12.058302+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 49564 ice_skating_field_condition 2021-01-01T08:07:02.560166+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 49563 ice_skating_field_condition 2021-01-01T08:06:51.803136+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42699 49306 ice_skating_field_condition 2020-12-31T13:28:05.364012+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42249 49303 ice_skating_field_condition 2020-12-31T13:23:33.339578+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
63147 49293 ice_skating_field_condition 2020-12-31T13:05:58.488641+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42249 49225 ice_skating_field_condition 2020-12-31T10:19:25.060836+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 49200 ice_skating_field_condition 2020-12-31T09:22:35.354288+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
56438 49182 ice_skating_field_condition 2020-12-31T08:49:56.781697+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 49173 ice_skating_field_condition 2020-12-31T08:03:00.941936+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53563 49172 ice_skating_field_condition 2020-12-31T08:02:53.016291+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 49170 ice_skating_field_condition 2020-12-31T07:51:11.674593+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 49169 ice_skating_field_condition 2020-12-31T07:50:45.999203+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
63148 49006 ice_skating_field_condition 2020-12-30T19:51:57.515619+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42249 48819 ice_skating_field_condition 2020-12-30T10:30:00.158498+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
63147 48791 ice_skating_field_condition 2020-12-30T09:00:56.488265+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
63148 48614 ice_skating_field_condition 2020-12-29T20:05:48.432741+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
63148 48528 ice_skating_field_condition 2020-12-29T15:33:45.799060+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
63147 48498 ice_skating_field_condition 2020-12-29T13:50:15.103664+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
63148 48209 ice_skating_field_condition 2020-12-28T20:05:05.126818+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42699 48156 ice_skating_field_condition 2020-12-28T17:32:55.018385+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41549 48147 ice_skating_field_condition 2020-12-28T17:10:04.173174+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
63148 48140 ice_skating_field_condition 2020-12-28T16:54:32.951047+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42249 48055 ice_skating_field_condition 2020-12-28T12:44:53.340211+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
50568 48052 ice_skating_field_condition 2020-12-28T12:39:50.414792+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53523 47976 ice_skating_field_condition 2020-12-28T09:03:49.595661+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53524 47975 ice_skating_field_condition 2020-12-28T09:03:41.386099+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
61464 47966 ice_skating_field_condition 2020-12-28T08:47:13.960410+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 47956 ice_skating_field_condition 2020-12-28T08:04:22.323970+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42185 47954 ice_skating_field_condition 2020-12-28T08:03:54.737126+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 47951 ice_skating_field_condition 2020-12-28T07:55:04.763089+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 47935 ice_skating_field_condition 2020-12-28T06:46:11.282127+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41549 47762 ice_skating_field_condition 2020-12-27T19:01:33.319103+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42249 47687 ice_skating_field_condition 2020-12-27T15:06:55.346360+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42699 47608 ice_skating_field_condition 2020-12-27T11:32:11.924227+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
63147 47601 ice_skating_field_condition 2020-12-27T11:03:13.295377+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 47569 ice_skating_field_condition 2020-12-27T09:49:13.465033+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53563 47568 ice_skating_field_condition 2020-12-27T09:49:01.161933+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40493 47452 ice_skating_field_condition 2020-12-27T01:06:48.073587+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  
41549 47257 ice_skating_field_condition 2020-12-26T13:51:22.797258+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40493 47187 ice_skating_field_condition 2020-12-26T10:18:05.487475+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53524 47175 ice_skating_field_condition 2020-12-26T09:56:14.612908+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53523 47174 ice_skating_field_condition 2020-12-26T09:55:48.091003+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
50568 47170 ice_skating_field_condition 2020-12-26T09:48:02.280500+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42699 47167 ice_skating_field_condition 2020-12-26T09:34:57.534255+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  
61464 47158 ice_skating_field_condition 2020-12-26T09:06:21.896770+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
63147 47151 ice_skating_field_condition 2020-12-26T08:48:23.506351+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
39834 47150 ice_skating_field_condition 2020-12-26T08:44:14.655036+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53563 47149 ice_skating_field_condition 2020-12-26T08:44:04.440598+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42249 47143 ice_skating_field_condition 2020-12-26T08:29:40.366588+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
53615 47135 ice_skating_field_condition 2020-12-26T07:52:39.699160+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
63148 47130 ice_skating_field_condition 2020-12-26T07:39:46.253264+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
47279 47123 ice_skating_field_condition 2020-12-26T06:52:25.583019+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41549 46988 ice_skating_field_condition 2020-12-25T20:38:43.175834+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 46924 ice_skating_field_condition 2020-12-25T17:23:06.259648+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40493 46890 ice_skating_field_condition 2020-12-25T15:25:04.466055+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  
47279 46831 ice_skating_field_condition 2020-12-25T12:30:08.238270+0200     Jäädytetty   Isad 1 Ice-covered frozen good