servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
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  
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  
39604 50893 ice_skating_field_condition 2021-01-04T12:20:48.019048+0200     Suljettu   Stängd 1 Closed closed unusable  
39780 50890 ice_skating_field_condition 2021-01-04T12:20:01.032534+0200     Suljettu   Stängd 1 Closed closed unusable  
39498 50889 ice_skating_field_condition 2021-01-04T12:19:23.273010+0200     Suljettu   Stängd 1 Closed closed unusable  
50522 50888 ice_skating_field_condition 2021-01-04T12:18:57.422985+0200     Suljettu   Stängd 1 Closed closed unusable  
50515 50887 ice_skating_field_condition 2021-01-04T12:18:41.931507+0200     Suljettu   Stängd 1 Closed closed unusable  
40421 50405 ice_skating_field_condition 2021-01-03T08:33:48.108169+0200     Suljettu   Stängd 1 Closed closed unusable  
46144 50368 ice_skating_field_condition 2021-01-03T06:15:26.387596+0200     Suljettu   Stängd 1 Closed closed unusable  
40421 49340 ice_skating_field_condition 2020-12-31T15:00:20.876900+0200     Suljettu   Stängd 1 Closed closed unusable  
56438 49304 ice_skating_field_condition 2020-12-31T13:27:38.531275+0200     Suljettu   Stängd 1 Closed closed unusable  
41608 49223 ice_skating_field_condition 2020-12-31T10:17:20.650223+0200     Suljettu   Stängd 1 Closed closed unusable  
42699 48892 ice_skating_field_condition 2020-12-30T14:07:19.906881+0200     Suljettu   Stängd 1 Closed closed unusable  
40421 48803 ice_skating_field_condition 2020-12-30T09:39:31.928981+0200     Suljettu   Stängd 1 Closed closed unusable  
63147 48760 ice_skating_field_condition 2020-12-30T07:02:43.816689+0200     Suljettu   Stängd 1 Closed closed unusable  
41770 48542 ice_skating_field_condition 2020-12-29T16:26:36.480465+0200     Suljettu   Stängd 1 Closed closed unusable  
39663 47600 ice_skating_field_condition 2020-12-27T11:03:03.622133+0200     Suljettu   Stängd 1 Closed closed unusable  
39370 46750 ice_skating_field_condition 2020-12-25T08:43:16.014984+0200     Suljettu   Stängd 1 Closed closed unusable  
57401 46081 ski_trail_condition 2020-12-23T07:47:10.744808+0200     Suljettu   Stängd 1 Closed closed unusable  
39370 45735 ice_skating_field_condition 2020-12-22T10:28:31.320271+0200     Suljettu   Stängd 1 Closed closed unusable  
42593 45697 ice_skating_field_condition 2020-12-22T08:34:20.671854+0200     Suljettu   Stängd 1 Closed closed unusable  
40421 45693 ice_skating_field_condition 2020-12-22T08:20:09.453221+0200     Suljettu   Stängd 1 Closed closed unusable  
41770 45671 ice_skating_field_condition 2020-12-22T07:01:46.360594+0200     Suljettu   Stängd 1 Closed closed unusable  
42185 45670 ice_skating_field_condition 2020-12-22T07:01:39.999355+0200     Suljettu   Stängd 1 Closed closed unusable  
40421 45289 ice_skating_field_condition 2020-12-21T07:59:14.102317+0200     Suljettu   Stängd 1 Closed closed unusable  
39370 45286 ice_skating_field_condition 2020-12-21T07:56:51.682321+0200     Suljettu   Stängd 1 Closed closed unusable  
39370 45281 ice_skating_field_condition 2020-12-21T07:56:31.538028+0200     Suljettu   Stängd 1 Closed closed unusable  
40421 44879 ice_skating_field_condition 2020-12-20T09:02:35.987640+0200     Suljettu   Stängd 1 Closed closed unusable  
51028 44841 ski_trail_condition 2020-12-20T07:17:07.408618+0200     Suljettu   Stängd 1 Closed closed unusable  
42185 44280 ice_skating_field_condition 2020-12-18T20:44:36.946950+0200     Suljettu   Stängd 1 Closed closed unusable  
47279 44233 ice_skating_field_condition 2020-12-18T17:29:26.222019+0200     Suljettu   Stängd 1 Closed closed unusable  
42185 44224 ice_skating_field_condition 2020-12-18T16:48:54.388195+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 44169 ice_skating_field_condition 2020-12-18T13:03:43.709602+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 44168 ice_skating_field_condition 2020-12-18T13:03:36.546079+0200     Suljettu   Stängd 1 Closed closed unusable  
39370 44100 ice_skating_field_condition 2020-12-18T08:58:36.074466+0200     Suljettu   Stängd 1 Closed closed unusable  
40421 44080 ice_skating_field_condition 2020-12-18T07:35:22.652160+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 43811 ice_skating_field_condition 2020-12-17T11:05:41.345700+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 43810 ice_skating_field_condition 2020-12-17T11:05:34.097029+0200     Suljettu   Stängd 1 Closed closed unusable  
39911 43526 ice_skating_field_condition 2020-12-16T14:34:44.291696+0200     Suljettu   Stängd 1 Closed closed unusable  
50568 43482 ice_skating_field_condition 2020-12-16T11:35:07.513995+0200     Suljettu   Stängd 1 Closed closed unusable  
51086 43473 ski_trail_condition 2020-12-16T10:52:39.287075+0200     Suljettu   Stängd 1 Closed closed unusable  
40421 43435 ice_skating_field_condition 2020-12-16T08:21:45.058198+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 43410 ice_skating_field_condition 2020-12-16T07:04:46.581198+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 43409 ice_skating_field_condition 2020-12-16T07:04:23.744681+0200     Suljettu   Stängd 1 Closed closed unusable  
50568 43407 ice_skating_field_condition 2020-12-16T07:03:26.776627+0200     Suljettu   Stängd 1 Closed closed unusable  
63147 43173 ice_skating_field_condition 2020-12-15T13:39:28.597898+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 43154 ice_skating_field_condition 2020-12-15T11:54:28.443100+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 43151 ice_skating_field_condition 2020-12-15T11:53:22.506073+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 42812 ice_skating_field_condition 2020-12-14T11:13:27.218926+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 42811 ice_skating_field_condition 2020-12-14T11:13:18.527909+0200     Suljettu   Stängd 1 Closed closed unusable  
40421 41865 ice_skating_field_condition 2020-12-11T12:35:50.820994+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 41569 ice_skating_field_condition 2020-12-10T13:58:46.098667+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 41568 ice_skating_field_condition 2020-12-10T13:58:39.733399+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 41312 ice_skating_field_condition 2020-12-09T18:35:54.995204+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 41311 ice_skating_field_condition 2020-12-09T18:35:44.355057+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 40878 ice_skating_field_condition 2020-12-08T11:33:37.155943+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 40877 ice_skating_field_condition 2020-12-08T11:33:30.750333+0200     Suljettu   Stängd 1 Closed closed unusable  
42413 40844 ice_skating_field_condition 2020-12-08T09:22:19.212174+0200     Suljettu   Stängd 1 Closed closed unusable  
42518 40822 ice_skating_field_condition 2020-12-08T08:02:25.564177+0200     Suljettu   Stängd 1 Closed closed unusable  
42338 40821 ice_skating_field_condition 2020-12-08T08:02:05.961500+0200     Suljettu   Stängd 1 Closed closed unusable  
42549 40820 ice_skating_field_condition 2020-12-08T08:01:35.812045+0200     Suljettu   Stängd 1 Closed closed unusable  
42581 40819 ice_skating_field_condition 2020-12-08T08:01:19.329374+0200     Suljettu   Stängd 1 Closed closed unusable  
42669 40818 ice_skating_field_condition 2020-12-08T08:00:54.601780+0200     Suljettu   Stängd 1 Closed closed unusable  
42806 40817 ice_skating_field_condition 2020-12-08T08:00:31.518057+0200     Suljettu   Stängd 1 Closed closed unusable  
42565 40816 ice_skating_field_condition 2020-12-08T08:00:05.743631+0200     Suljettu   Stängd 1 Closed closed unusable  
42750 40813 ice_skating_field_condition 2020-12-08T07:59:35.719281+0200     Suljettu   Stängd 1 Closed closed unusable  
42701 40812 ice_skating_field_condition 2020-12-08T07:59:11.211613+0200     Suljettu   Stängd 1 Closed closed unusable  
46175 40810 ice_skating_field_condition 2020-12-08T07:58:51.659571+0200     Suljettu   Stängd 1 Closed closed unusable  
42319 40808 ice_skating_field_condition 2020-12-08T07:57:58.504142+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 40485 ice_skating_field_condition 2020-12-07T07:06:59.219130+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 40484 ice_skating_field_condition 2020-12-07T07:06:48.924359+0200     Suljettu   Stängd 1 Closed closed unusable  
39854 40483 ice_skating_field_condition 2020-12-07T07:00:19.591803+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 39933 ice_skating_field_condition 2020-12-05T11:05:09.401977+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 39932 ice_skating_field_condition 2020-12-05T11:04:50.564084+0200     Suljettu   Stängd 1 Closed closed unusable  
41181 39919 ice_skating_field_condition 2020-12-05T10:25:46.456941+0200     Suljettu   Stängd 1 Closed closed unusable  
53093 39636 ice_skating_field_condition 2020-12-04T12:32:13.051409+0200     Suljettu   Stängd 1 Closed closed unusable  
42743 39635 ice_skating_field_condition 2020-12-04T12:31:16.815056+0200     Suljettu   Stängd 1 Closed closed unusable  
42489 39634 ice_skating_field_condition 2020-12-04T12:30:29.510736+0200     Suljettu   Stängd 1 Closed closed unusable  
42902 39630 ice_skating_field_condition 2020-12-04T12:29:31.089998+0200     Suljettu   Stängd 1 Closed closed unusable  
42847 39629 ice_skating_field_condition 2020-12-04T12:28:36.237673+0200     Suljettu   Stängd 1 Closed closed unusable  
53089 39628 ice_skating_field_condition 2020-12-04T12:27:46.479078+0200     Suljettu   Stängd 1 Closed closed unusable  
42913 39627 ice_skating_field_condition 2020-12-04T12:27:19.755050+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 39198 ice_skating_field_condition 2020-12-03T06:39:41.443838+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 39197 ice_skating_field_condition 2020-12-03T06:39:21.054634+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 38591 ice_skating_field_condition 2020-12-01T10:51:03.309259+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 38590 ice_skating_field_condition 2020-12-01T10:50:56.301354+0200     Suljettu   Stängd 1 Closed closed unusable