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  
53615 51160 ice_skating_field_condition 2021-01-04T21:56:39.719521+0200     Aurattu   Plogad 1 Cleared of snow plowed 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  
53615 51071 ice_skating_field_condition 2021-01-04T17:14:29.700935+0200     Aurattu   Plogad 1 Cleared of snow plowed 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  
50265 50935 ice_skating_field_condition 2021-01-04T13:16:06.429717+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39269 50934 ice_skating_field_condition 2021-01-04T13:15:53.672873+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39498 50853 ice_skating_field_condition 2021-01-04T10:36:55.339893+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40493 50843 ice_skating_field_condition 2021-01-04T10:09:38.311784+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40421 50814 ice_skating_field_condition 2021-01-04T08:33:23.302497+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50522 50812 ice_skating_field_condition 2021-01-04T08:29:30.610446+0200     Aurattu   Plogad 1 Cleared of snow plowed 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  
39604 50799 ice_skating_field_condition 2021-01-04T07:41:49.161325+0200     Aurattu   Plogad 1 Cleared of snow plowed 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  
53615 50673 ice_skating_field_condition 2021-01-03T21:52:01.252674+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
47849 50597 ice_skating_field_condition 2021-01-03T17:51:58.987327+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42249 50583 ice_skating_field_condition 2021-01-03T17:13:37.230197+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40421 50554 ice_skating_field_condition 2021-01-03T15:49:14.887724+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53710 50550 ski_trail_condition 2021-01-03T15:23:05.174367+0200     Hyvä   Bra 1 Good condition good good  
39370 50535 ice_skating_field_condition 2021-01-03T14:41:47.515737+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39604 50534 ice_skating_field_condition 2021-01-03T14:40:40.730513+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40493 50502 ice_skating_field_condition 2021-01-03T13:20:32.890468+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39710 50499 ice_skating_field_condition 2021-01-03T13:17:39.975338+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40493 50483 ice_skating_field_condition 2021-01-03T12:29:17.311470+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
63148 50469 ice_skating_field_condition 2021-01-03T11:51:58.445877+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39398 50467 ice_skating_field_condition 2021-01-03T11:44:23.405663+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39654 50465 ice_skating_field_condition 2021-01-03T11:43:33.539915+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
46144 50450 ice_skating_field_condition 2021-01-03T10:55:05.242835+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40493 50446 ice_skating_field_condition 2021-01-03T10:50:25.859806+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42249 50440 ice_skating_field_condition 2021-01-03T10:38:17.675431+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
42249 50439 ice_skating_field_condition 2021-01-03T10:38:05.705272+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39780 50413 ice_skating_field_condition 2021-01-03T09:02:49.801111+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40493 50406 ice_skating_field_condition 2021-01-03T08:39:45.203053+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39370 50403 ice_skating_field_condition 2021-01-03T08:26:28.057241+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
63148 50396 ice_skating_field_condition 2021-01-03T07:57:39.585831+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
47279 50395 ice_skating_field_condition 2021-01-03T07:50:18.786508+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53615 50392 ice_skating_field_condition 2021-01-03T07:50:00.506457+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
53710 50381 ski_trail_condition 2021-01-03T07:08:36.692071+0200     Hyvä   Bra 1 Good condition good good  
40493 50222 ice_skating_field_condition 2021-01-02T19:14:01.360460+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
41770 50213 ice_skating_field_condition 2021-01-02T18:56:50.112833+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42185 50211 ice_skating_field_condition 2021-01-02T18:56:29.417401+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 50155 ice_skating_field_condition 2021-01-02T16:04:32.786529+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39370 50153 ice_skating_field_condition 2021-01-02T16:00:18.836318+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50515 50121 ice_skating_field_condition 2021-01-02T14:10:07.838409+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39296 50117 ice_skating_field_condition 2021-01-02T14:09:21.163492+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39385 50116 ice_skating_field_condition 2021-01-02T14:08:15.782544+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50265 50115 ice_skating_field_condition 2021-01-02T14:07:26.392533+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39398 50114 ice_skating_field_condition 2021-01-02T14:05:21.784611+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39401 50113 ice_skating_field_condition 2021-01-02T14:04:52.717175+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39269 50112 ice_skating_field_condition 2021-01-02T14:04:11.634280+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39315 50111 ice_skating_field_condition 2021-01-02T14:03:31.347039+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39710 50109 ice_skating_field_condition 2021-01-02T14:02:25.181872+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39604 50108 ice_skating_field_condition 2021-01-02T14:01:56.584990+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39780 50106 ice_skating_field_condition 2021-01-02T14:01:04.787142+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39498 50104 ice_skating_field_condition 2021-01-02T14:00:32.977245+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50522 50100 ice_skating_field_condition 2021-01-02T13:59:51.226091+0200     Aurattu   Plogad 1 Cleared of snow plowed 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  
60871 49957 ski_trail_condition 2021-01-02T07:07:06.440744+0200     Hyvä   Bra 1 Good condition good good  
53710 49880 ski_trail_condition 2021-01-02T00:34:59.827964+0200     Hyvä   Bra 1 Good condition good good  
39370 49749 ice_skating_field_condition 2021-01-01T16:41:06.870108+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
40421 49730 ice_skating_field_condition 2021-01-01T15:36:40.196064+0200     Aurattu   Plogad 1 Cleared of snow plowed 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  
63147 49625 ice_skating_field_condition 2021-01-01T10:36:55.767287+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39370 49604 ice_skating_field_condition 2021-01-01T09:52:36.166153+0200     Aurattu   Plogad 1 Cleared of snow plowed 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 49589 ice_skating_field_condition 2021-01-01T09:16:32.474175+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
42185 49588 ice_skating_field_condition 2021-01-01T09:16:25.012566+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
41770 49587 ice_skating_field_condition 2021-01-01T09:15:56.086948+0200     Aurattu   Plogad 1 Cleared of snow plowed 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  
42249 49577 ice_skating_field_condition 2021-01-01T08:52:09.343198+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40493 49573 ice_skating_field_condition 2021-01-01T08:46:45.291733+0200     Aurattu   Plogad 1 Cleared of snow plowed 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