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  
51027 51112 ski_trail_condition 2021-01-04T19:09:22.296673+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
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 51031 ice_skating_field_condition 2021-01-04T15:14:15.618823+0200     Suljettu   Stängd 1 Closed closed unusable  
39269 51030 ice_skating_field_condition 2021-01-04T15:13:26.045585+0200     Suljettu   Stängd 1 Closed closed unusable  
42672 51023 ice_skating_field_condition 2021-01-04T15:00:41.465811+0200     Suljettu   Stängd 1 Closed closed unusable  
42562 51020 ice_skating_field_condition 2021-01-04T14:56:55.478182+0200     Suljettu   Stängd 1 Closed closed unusable  
53095 51019 ice_skating_field_condition 2021-01-04T14:56:16.662837+0200     Suljettu   Stängd 1 Closed closed unusable  
46192 51018 ice_skating_field_condition 2021-01-04T14:55:41.835163+0200     Suljettu   Stängd 1 Closed closed unusable  
42580 51017 ice_skating_field_condition 2021-01-04T14:54:51.799457+0200     Suljettu   Stängd 1 Closed closed unusable  
53985 51016 ski_trail_condition 2021-01-04T14:54:04.231259+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53919 51015 ski_trail_condition 2021-01-04T14:53:51.142907+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54002 51014 ski_trail_condition 2021-01-04T14:53:43.857194+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54011 51013 ski_trail_condition 2021-01-04T14:53:31.623027+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54009 51012 ski_trail_condition 2021-01-04T14:53:17.596112+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54013 51011 ski_trail_condition 2021-01-04T14:53:08.057325+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53867 51010 ski_trail_condition 2021-01-04T14:53:00.119822+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53984 51009 ski_trail_condition 2021-01-04T14:52:51.476691+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54429 51008 ski_trail_condition 2021-01-04T14:52:38.853550+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
56077 51007 ski_trail_condition 2021-01-04T14:52:30.628271+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53987 51006 ski_trail_condition 2021-01-04T14:52:20.237052+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53916 51005 ski_trail_condition 2021-01-04T14:52:08.546026+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53916 51004 ski_trail_condition 2021-01-04T14:52:08.106885+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54004 51003 ski_trail_condition 2021-01-04T14:51:52.886263+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54007 51002 ski_trail_condition 2021-01-04T14:51:42.092474+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54007 51001 ski_trail_condition 2021-01-04T14:51:30.349763+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54422 51000 ski_trail_condition 2021-01-04T14:51:30.228840+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54007 50999 ski_trail_condition 2021-01-04T14:51:29.569064+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54005 50998 ski_trail_condition 2021-01-04T14:51:17.456305+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54010 50997 ski_trail_condition 2021-01-04T14:51:15.716497+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54422 50996 ski_trail_condition 2021-01-04T14:51:14.835828+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53994 50995 ski_trail_condition 2021-01-04T14:50:18.997488+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54411 50993 ski_trail_condition 2021-01-04T14:49:50.423708+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53989 50992 ski_trail_condition 2021-01-04T14:49:32.745566+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53989 50991 ski_trail_condition 2021-01-04T14:49:29.724999+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
56076 50990 ski_trail_condition 2021-01-04T14:49:24.388646+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
56076 50989 ski_trail_condition 2021-01-04T14:49:20.568691+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53850 50988 ski_trail_condition 2021-01-04T14:49:05.672860+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54421 50987 ski_trail_condition 2021-01-04T14:48:55.953820+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54423 50986 ski_trail_condition 2021-01-04T14:48:40.455129+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54419 50985 ski_trail_condition 2021-01-04T14:48:26.140649+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54424 50984 ski_trail_condition 2021-01-04T14:48:06.703494+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53978 50983 ski_trail_condition 2021-01-04T14:47:52.323610+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54430 50982 ski_trail_condition 2021-01-04T14:47:41.171183+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53979 50981 ski_trail_condition 2021-01-04T14:47:27.319271+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53975 50980 ski_trail_condition 2021-01-04T14:47:09.055552+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53974 50979 ski_trail_condition 2021-01-04T14:47:02.778233+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53974 50978 ski_trail_condition 2021-01-04T14:46:53.284804+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54425 50977 ski_trail_condition 2021-01-04T14:46:37.795169+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53965 50976 ski_trail_condition 2021-01-04T14:46:31.646547+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53965 50975 ski_trail_condition 2021-01-04T14:46:23.057837+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
56073 50974 ski_trail_condition 2021-01-04T14:46:09.214924+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
56073 50973 ski_trail_condition 2021-01-04T14:45:52.322167+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54048 50972 ski_trail_condition 2021-01-04T14:45:44.327526+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54338 50971 ski_trail_condition 2021-01-04T14:45:41.911663+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54038 50970 ski_trail_condition 2021-01-04T14:45:19.517881+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53836 50969 ski_trail_condition 2021-01-04T14:43:59.446018+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54339 50968 ski_trail_condition 2021-01-04T14:43:57.629744+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54039 50967 ski_trail_condition 2021-01-04T14:43:20.288124+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54047 50966 ski_trail_condition 2021-01-04T14:43:16.810816+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
53848 50965 ski_trail_condition 2021-01-04T14:43:06.276472+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
51027 50961 ski_trail_condition 2021-01-04T14:36:44.599207+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
54335 50960 ski_trail_condition 2021-01-04T14:34:56.015492+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
57401 50958 ski_trail_condition 2021-01-04T14:34:03.949313+0200     Lumetus kesken   Snöproduktionen oavslutad 1 Snowmaking unfinished snowmaking unusable  
57401 50957 ski_trail_condition 2021-01-04T14:34:00.447647+0200     Lumetus kesken   Snöproduktionen oavslutad 1 Snowmaking unfinished snowmaking unusable  
39903 50937 ice_skating_field_condition 2021-01-04T13:25:02.327344+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
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  
42069 50933 ice_skating_field_condition 2021-01-04T13:11:35.470065+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42175 50928 ice_skating_field_condition 2021-01-04T13:09:52.023140+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42110 50927 ice_skating_field_condition 2021-01-04T13:09:23.939446+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42110 50926 ice_skating_field_condition 2021-01-04T13:09:15.255958+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
40154 50925 ice_skating_field_condition 2021-01-04T13:08:53.663175+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
40350 50924 ice_skating_field_condition 2021-01-04T13:08:27.448711+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
39969 50923 ice_skating_field_condition 2021-01-04T13:07:45.697883+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
40172 50922 ice_skating_field_condition 2021-01-04T13:06:41.859849+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
41734 50921 ice_skating_field_condition 2021-01-04T13:05:55.526403+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
40010 50920 ice_skating_field_condition 2021-01-04T13:04:47.790620+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
50265 50903 ice_skating_field_condition 2021-01-04T12:26:05.520577+0200     Suljettu   Stängd 1 Closed closed unusable  
39654 50902 ice_skating_field_condition 2021-01-04T12:25:30.385154+0200     Suljettu   Stängd 1 Closed closed unusable  
39398 50901 ice_skating_field_condition 2021-01-04T12:24:55.518697+0200     Suljettu   Stängd 1 Closed closed unusable  
39401 50900 ice_skating_field_condition 2021-01-04T12:24:17.076045+0200     Suljettu   Stängd 1 Closed closed unusable  
39269 50899 ice_skating_field_condition 2021-01-04T12:23:50.719939+0200     Suljettu   Stängd 1 Closed closed unusable  
39315 50898 ice_skating_field_condition 2021-01-04T12:23:17.118693+0200     Suljettu   Stängd 1 Closed closed unusable  
39296 50897 ice_skating_field_condition 2021-01-04T12:22:52.718150+0200     Suljettu   Stängd 1 Closed closed unusable  
39385 50896 ice_skating_field_condition 2021-01-04T12:22:31.801698+0200     Suljettu   Stängd 1 Closed closed unusable  
50518 50895 ice_skating_field_condition 2021-01-04T12:22:08.022311+0200     Suljettu   Stängd 1 Closed closed unusable  
39710 50894 ice_skating_field_condition 2021-01-04T12:21:12.583086+0200     Suljettu   Stängd 1 Closed closed unusable