servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
42852 5987 ice_skating_field_condition 2019-09-07T18:40:27.198231+0300     Suljettu   Stängd 1 Closed closed unusable  
41976 5989 ice_skating_field_condition 2019-09-11T07:24:08.373689+0300     Suljettu   Stängd 1 Closed closed unusable  
41770 6011 ice_skating_field_condition 2019-11-07T09:56:49.171260+0200     Suljettu   Stängd 1 Closed closed unusable  
42185 6014 ice_skating_field_condition 2019-11-07T09:58:40.112027+0200     Suljettu   Stängd 1 Closed closed unusable  
53615 6026 ice_skating_field_condition 2019-11-11T16:09:42.262419+0200     Suljettu   Stängd 1 Closed closed unusable  
41770 6030 ice_skating_field_condition 2019-11-12T09:21:57.649587+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 6042 ice_skating_field_condition 2019-11-14T14:00:38.837026+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6043 ice_skating_field_condition 2019-11-14T14:01:03.454848+0200     Suljettu   Stängd 1 Closed closed unusable  
53563 6052 ice_skating_field_condition 2019-11-17T09:56:26.450995+0200     Suljettu   Stängd 1 Closed closed unusable  
53563 6062 ice_skating_field_condition 2019-11-18T11:54:30.323399+0200     Suljettu   Stängd 1 Closed closed unusable  
53615 6067 ice_skating_field_condition 2019-11-19T14:49:25.099218+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 6074 ice_skating_field_condition 2019-11-22T12:50:21.925939+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6075 ice_skating_field_condition 2019-11-22T12:50:42.715838+0200     Suljettu   Stängd 1 Closed closed unusable  
53563 6079 ice_skating_field_condition 2019-11-23T08:56:25.190468+0200     Suljettu   Stängd 1 Closed closed unusable  
47279 6084 ice_skating_field_condition 2019-11-23T15:54:15.448380+0200     Suljettu   Stängd 1 Closed closed unusable  
53563 6087 ice_skating_field_condition 2019-11-24T08:54:42.027456+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 6094 ice_skating_field_condition 2019-11-25T06:32:50.409420+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6095 ice_skating_field_condition 2019-11-25T06:32:57.544183+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6099 ice_skating_field_condition 2019-11-25T09:05:57.015330+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 6100 ice_skating_field_condition 2019-11-25T09:06:08.220871+0200     Suljettu   Stängd 1 Closed closed unusable  
53563 6111 ice_skating_field_condition 2019-11-25T11:05:54.025272+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 6147 ice_skating_field_condition 2019-11-26T10:38:59.037211+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6148 ice_skating_field_condition 2019-11-26T10:39:05.599252+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 6162 ice_skating_field_condition 2019-11-27T12:33:09.121453+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6163 ice_skating_field_condition 2019-11-27T12:33:16.752238+0200     Suljettu   Stängd 1 Closed closed unusable  
42852 6172 ice_skating_field_condition 2019-11-29T08:47:37.827839+0200     Suljettu   Stängd 1 Closed closed unusable  
42526 6173 ice_skating_field_condition 2019-11-29T08:47:51.729878+0200     Suljettu   Stängd 1 Closed closed unusable  
53710 6181 ski_trail_condition 2019-11-30T11:25:11.706636+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 6207 ice_skating_field_condition 2019-12-02T08:31:28.972795+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6208 ice_skating_field_condition 2019-12-02T08:31:35.919352+0200     Suljettu   Stängd 1 Closed closed unusable  
51402 6222 ice_skating_field_condition 2019-12-03T09:02:35.675224+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6225 ice_skating_field_condition 2019-12-03T11:47:43.112761+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 6226 ice_skating_field_condition 2019-12-03T11:47:55.237699+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6232 ice_skating_field_condition 2019-12-04T08:01:05.216712+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 6233 ice_skating_field_condition 2019-12-04T08:01:26.024821+0200     Suljettu   Stängd 1 Closed closed unusable  
50354 6235 ice_skating_field_condition 2019-12-04T08:10:05.936963+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6249 ice_skating_field_condition 2019-12-05T06:38:12.377001+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 6250 ice_skating_field_condition 2019-12-05T06:38:35.385603+0200     Suljettu   Stängd 1 Closed closed unusable  
53563 6273 ice_skating_field_condition 2019-12-07T08:56:27.759255+0200     Suljettu   Stängd 1 Closed closed unusable  
39834 6274 ice_skating_field_condition 2019-12-07T08:56:37.772720+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6280 ice_skating_field_condition 2019-12-07T14:27:15.170743+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 6281 ice_skating_field_condition 2019-12-07T14:27:31.100488+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 6292 ice_skating_field_condition 2019-12-08T08:53:38.583271+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6293 ice_skating_field_condition 2019-12-08T08:53:52.087653+0200     Suljettu   Stängd 1 Closed closed unusable  
40934 6304 ice_skating_field_condition 2019-12-09T09:22:06.404096+0200     Suljettu   Stängd 1 Closed closed unusable  
51402 6305 ice_skating_field_condition 2019-12-09T09:22:50.992009+0200     Suljettu   Stängd 1 Closed closed unusable  
40249 6306 ice_skating_field_condition 2019-12-09T11:06:42.641530+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 6308 ice_skating_field_condition 2019-12-09T14:13:52.222823+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6309 ice_skating_field_condition 2019-12-09T14:14:02.931866+0200     Suljettu   Stängd 1 Closed closed unusable  
51402 6310 ice_skating_field_condition 2019-12-09T14:23:37.051134+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 6326 ice_skating_field_condition 2019-12-10T14:46:37.732093+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6327 ice_skating_field_condition 2019-12-10T14:46:46.080887+0200     Suljettu   Stängd 1 Closed closed unusable  
51028 6332 ski_trail_condition 2019-12-11T07:56:35.444857+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 6333 ice_skating_field_condition 2019-12-11T07:58:04.246462+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6334 ice_skating_field_condition 2019-12-11T07:58:10.481447+0200     Suljettu   Stängd 1 Closed closed unusable  
40438 6337 ice_skating_field_condition 2019-12-11T08:54:38.154469+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6345 ice_skating_field_condition 2019-12-11T12:05:05.243005+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6369 ice_skating_field_condition 2019-12-12T12:38:52.227236+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6379 ice_skating_field_condition 2019-12-13T09:58:36.979536+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6402 ice_skating_field_condition 2019-12-15T14:34:43.949587+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6403 ice_skating_field_condition 2019-12-15T14:35:01.261754+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 6404 ice_skating_field_condition 2019-12-15T16:18:41.012142+0200     Suljettu   Stängd 1 Closed closed unusable  
51402 6428 ice_skating_field_condition 2019-12-17T10:09:05.340392+0200     Suljettu   Stängd 1 Closed closed unusable  
40934 6429 ice_skating_field_condition 2019-12-17T10:09:15.139266+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6433 ice_skating_field_condition 2019-12-18T09:08:31.263728+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 6434 ice_skating_field_condition 2019-12-18T09:08:37.065378+0200     Suljettu   Stängd 1 Closed closed unusable  
47279 6435 ice_skating_field_condition 2019-12-18T13:44:10.038252+0200     Suljettu   Stängd 1 Closed closed unusable  
53615 6436 ice_skating_field_condition 2019-12-18T13:44:23.387196+0200     Suljettu   Stängd 1 Closed closed unusable  
41770 6437 ice_skating_field_condition 2019-12-18T17:53:16.258774+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6457 ice_skating_field_condition 2019-12-20T07:19:47.911358+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 6458 ice_skating_field_condition 2019-12-20T07:19:54.409710+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6466 ice_skating_field_condition 2019-12-21T09:09:23.854236+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 6467 ice_skating_field_condition 2019-12-21T09:09:29.280854+0200     Suljettu   Stängd 1 Closed closed unusable  
42185 6502 ice_skating_field_condition 2019-12-23T14:56:49.172676+0200     Suljettu   Stängd 1 Closed closed unusable  
42249 6533 ice_skating_field_condition 2019-12-27T09:38:54.890364+0200     Suljettu   Stängd 1 Closed closed unusable  
41181 6535 ice_skating_field_condition 2019-12-27T09:40:42.504124+0200     Suljettu   Stängd 1 Closed closed unusable  
40218 6626 ice_skating_field_condition 2020-01-02T09:02:38.314077+0200     Suljettu   Stängd 1 Closed closed unusable  
51028 6684 ski_trail_condition 2020-01-05T16:58:24.715481+0200     Suljettu   Stängd 1 Closed closed unusable  
41770 6712 ice_skating_field_condition 2020-01-07T14:32:01.462290+0200     Suljettu   Stängd 1 Closed closed unusable  
51402 6722 ice_skating_field_condition 2020-01-08T09:25:52.257888+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6728 ice_skating_field_condition 2020-01-09T10:56:59.330110+0200     Suljettu   Stängd 1 Closed closed unusable  
60871 6736 ski_trail_condition 2020-01-09T14:32:15.463464+0200     Suljettu   Stängd 1 Closed closed unusable  
41994 6743 ice_skating_field_condition 2020-01-10T08:30:06.247681+0200     Suljettu   Stängd 1 Closed closed unusable  
57401 6752 ski_trail_condition 2020-01-10T15:45:43.284338+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6774 ice_skating_field_condition 2020-01-12T07:58:21.536555+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 6775 ice_skating_field_condition 2020-01-12T07:58:35.821949+0200     Suljettu   Stängd 1 Closed closed unusable  
40421 6783 ice_skating_field_condition 2020-01-12T08:41:48.165452+0200     Suljettu   Stängd 1 Closed closed unusable  
47279 6786 ice_skating_field_condition 2020-01-12T09:57:30.529638+0200     Suljettu   Stängd 1 Closed closed unusable  
42917 6793 ice_skating_field_condition 2020-01-12T15:39:34.377127+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6821 ice_skating_field_condition 2020-01-14T08:13:22.496263+0200     Suljettu   Stängd 1 Closed closed unusable  
47279 6834 ice_skating_field_condition 2020-01-15T08:04:43.649739+0200     Suljettu   Stängd 1 Closed closed unusable  
53615 6835 ice_skating_field_condition 2020-01-15T08:04:53.543565+0200     Suljettu   Stängd 1 Closed closed unusable  
41770 6836 ice_skating_field_condition 2020-01-15T08:26:56.757972+0200     Suljettu   Stängd 1 Closed closed unusable  
53524 6837 ice_skating_field_condition 2020-01-15T08:27:11.173318+0200     Suljettu   Stängd 1 Closed closed unusable  
53523 6838 ice_skating_field_condition 2020-01-15T08:27:17.784813+0200     Suljettu   Stängd 1 Closed closed unusable  
42185 6842 ice_skating_field_condition 2020-01-15T11:00:03.437514+0200     Suljettu   Stängd 1 Closed closed unusable  
40421 6843 ice_skating_field_condition 2020-01-15T13:08:08.867515+0200     Suljettu   Stängd 1 Closed closed unusable  
50568 6845 ice_skating_field_condition 2020-01-15T14:05:23.332074+0200     Suljettu   Stängd 1 Closed closed unusable  
40402 6849 ice_skating_field_condition 2020-01-15T14:16:27.379631+0200     Suljettu   Stängd 1 Closed closed unusable  
56438 6850 ice_skating_field_condition 2020-01-15T14:22:38.720102+0200     Suljettu   Stängd 1 Closed closed unusable  
60871 6851 ski_trail_condition 2020-01-15T21:21:28.793075+0200     Suljettu   Stängd 1 Closed closed unusable