servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
39269 50112 ice_skating_field_condition 2021-01-02T14:04:11.634280+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  
39296 50117 ice_skating_field_condition 2021-01-02T14:09:21.163492+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  
39370 38334 ice_skating_field_condition 2020-11-30T14:25:21.488076+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39370 38551 ice_skating_field_condition 2020-12-01T08:05:37.895637+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39370 39671 ice_skating_field_condition 2020-12-04T15:47:13.161205+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39370 39931 ice_skating_field_condition 2020-12-05T11:04:09.703884+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39370 40314 ice_skating_field_condition 2020-12-06T18:07:31.617144+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39370 42130 ice_skating_field_condition 2020-12-12T08:04:28.689517+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39370 43496 ice_skating_field_condition 2020-12-16T12:38:51.734391+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39370 44187 ice_skating_field_condition 2020-12-18T14:26:05.072018+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39370 46761 ice_skating_field_condition 2020-12-25T09:20:55.461705+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  
39370 50153 ice_skating_field_condition 2021-01-02T16:00:18.836318+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  
39370 50535 ice_skating_field_condition 2021-01-03T14:41:47.515737+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  
39398 50114 ice_skating_field_condition 2021-01-02T14:05:21.784611+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  
39401 50113 ice_skating_field_condition 2021-01-02T14:04:52.717175+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  
39498 50853 ice_skating_field_condition 2021-01-04T10:36:55.339893+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  
39604 50534 ice_skating_field_condition 2021-01-03T14:40:40.730513+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39604 50799 ice_skating_field_condition 2021-01-04T07:41:49.161325+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  
39710 50109 ice_skating_field_condition 2021-01-02T14:02:25.181872+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  
39780 50106 ice_skating_field_condition 2021-01-02T14:01:04.787142+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  
39834 6203 ice_skating_field_condition 2019-12-01T18:49:21.145615+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 6269 ice_skating_field_condition 2019-12-06T16:19:13.675861+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 6279 ice_skating_field_condition 2019-12-07T11:34:27.315239+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 6593 ice_skating_field_condition 2019-12-30T14:57:05.376948+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 6709 ice_skating_field_condition 2020-01-07T09:44:56.590761+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 6830 ice_skating_field_condition 2020-01-14T15:00:00.976818+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 6866 ice_skating_field_condition 2020-01-16T15:10:26.385509+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 6891 ice_skating_field_condition 2020-01-17T14:48:15.891076+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 6912 ice_skating_field_condition 2020-01-18T14:44:34.605732+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 7047 ice_skating_field_condition 2020-01-24T15:20:29.671490+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 7100 ice_skating_field_condition 2020-01-27T09:01:51.922726+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 7113 ice_skating_field_condition 2020-01-28T08:43:57.570540+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 7151 ice_skating_field_condition 2020-01-30T08:44:27.590486+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 7502 ice_skating_field_condition 2020-02-09T15:16:42.742454+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 7538 ice_skating_field_condition 2020-02-10T14:34:20.883078+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 7572 ice_skating_field_condition 2020-02-11T15:17:30.079982+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 7724 ice_skating_field_condition 2020-02-18T09:52:56.074918+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 7997 ice_skating_field_condition 2020-03-01T14:58:23.960388+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 8019 ice_skating_field_condition 2020-03-02T14:25:30.446557+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 8059 ice_skating_field_condition 2020-03-04T13:18:17.937104+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 8156 ice_skating_field_condition 2020-03-09T08:24:04.867607+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 8191 ice_skating_field_condition 2020-03-12T08:17:25.348096+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 8294 ice_skating_field_condition 2020-03-17T15:08:29.761463+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 27814 ice_skating_field_condition 2020-10-26T17:14:03.327211+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 38558 ice_skating_field_condition 2020-12-01T08:39:32.094168+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 39979 ice_skating_field_condition 2020-12-05T14:55:41.259871+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 44864 ice_skating_field_condition 2020-12-20T08:30:08.321627+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39834 48375 ice_skating_field_condition 2020-12-29T08:18:29.729323+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
39854 39593 ice_skating_field_condition 2020-12-04T10:56:00.622280+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40013 7428 ice_skating_field_condition 2020-02-08T07:06:18.408892+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40040 7441 ice_skating_field_condition 2020-02-08T09:35:23.564237+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40402 6788 ice_skating_field_condition 2020-01-12T11:10:07.888152+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40402 6864 ice_skating_field_condition 2020-01-16T14:21:36.304981+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40402 7098 ice_skating_field_condition 2020-01-27T08:35:08.491965+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40402 7145 ice_skating_field_condition 2020-01-30T07:47:06.528957+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40402 7209 ice_skating_field_condition 2020-02-02T12:02:42.556980+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40402 7587 ice_skating_field_condition 2020-02-12T08:29:29.745958+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40402 7707 ice_skating_field_condition 2020-02-17T09:45:47.538549+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40402 7719 ice_skating_field_condition 2020-02-18T07:49:48.201976+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40402 7798 ice_skating_field_condition 2020-02-21T08:45:07.177076+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40402 8008 ice_skating_field_condition 2020-03-02T09:03:29.643371+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40402 8047 ice_skating_field_condition 2020-03-04T07:42:23.205940+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 6792 ice_skating_field_condition 2020-01-12T12:56:27.436367+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 6859 ice_skating_field_condition 2020-01-16T09:45:01.903463+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 6956 ice_skating_field_condition 2020-01-20T11:28:15.809542+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 6966 ice_skating_field_condition 2020-01-21T06:57:12.566365+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 6976 ice_skating_field_condition 2020-01-21T09:45:15.092308+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7079 ice_skating_field_condition 2020-01-26T10:01:49.316444+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7101 ice_skating_field_condition 2020-01-27T09:04:09.156021+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7116 ice_skating_field_condition 2020-01-28T10:19:13.343558+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7157 ice_skating_field_condition 2020-01-30T09:10:52.174189+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7173 ice_skating_field_condition 2020-01-31T09:05:31.734764+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7188 ice_skating_field_condition 2020-02-01T09:44:47.686837+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7208 ice_skating_field_condition 2020-02-02T09:28:57.091991+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7228 ice_skating_field_condition 2020-02-03T09:42:18.557760+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7240 ice_skating_field_condition 2020-02-04T09:31:03.710741+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7338 ice_skating_field_condition 2020-02-06T09:09:35.309980+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7445 ice_skating_field_condition 2020-02-08T09:58:03.764478+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7483 ice_skating_field_condition 2020-02-09T09:20:19.901251+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7561 ice_skating_field_condition 2020-02-11T08:46:40.585207+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7591 ice_skating_field_condition 2020-02-12T10:50:32.502452+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7664 ice_skating_field_condition 2020-02-15T10:04:26.130602+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7708 ice_skating_field_condition 2020-02-17T10:33:02.155728+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7726 ice_skating_field_condition 2020-02-18T09:55:31.000355+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7756 ice_skating_field_condition 2020-02-19T09:37:04.995095+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7789 ice_skating_field_condition 2020-02-20T12:08:29.713031+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7916 ice_skating_field_condition 2020-02-27T08:45:36.002678+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7934 ice_skating_field_condition 2020-02-28T08:28:33.630729+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7960 ice_skating_field_condition 2020-02-29T09:35:52.235339+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
40421 7993 ice_skating_field_condition 2020-03-01T10:11:11.746497+0200     Aurattu   Plogad 1 Cleared of snow plowed good