servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
53524 6008 ice_skating_field_condition 2019-11-05T20:08:15.996395+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42185 6013 ice_skating_field_condition 2019-11-07T09:58:30.402180+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42185 6029 ice_skating_field_condition 2019-11-12T09:21:40.830633+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
41770 6040 ice_skating_field_condition 2019-11-14T08:17:50.132865+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42185 6058 ice_skating_field_condition 2019-11-18T07:28:32.000508+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
41770 6059 ice_skating_field_condition 2019-11-18T07:28:46.375521+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42185 6081 ice_skating_field_condition 2019-11-23T13:08:07.889101+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
41770 6083 ice_skating_field_condition 2019-11-23T13:08:25.935238+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
41549 6089 ice_skating_field_condition 2019-11-24T11:22:09.494605+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
41657 6090 ice_skating_field_condition 2019-11-25T06:07:43.288923+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42185 6096 ice_skating_field_condition 2019-11-25T07:20:28.019854+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
41770 6097 ice_skating_field_condition 2019-11-25T07:20:35.373233+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
46144 6114 ice_skating_field_condition 2019-11-25T11:11:52.386098+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
40493 6164 ice_skating_field_condition 2019-11-27T13:51:02.941174+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
53524 7143 ice_skating_field_condition 2020-01-30T07:45:29.146931+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
53523 7144 ice_skating_field_condition 2020-01-30T07:45:37.598516+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42185 7187 ice_skating_field_condition 2020-02-01T09:22:51.005398+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
41398 7242 ice_skating_field_condition 2020-02-04T10:53:14.730366+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
41617 7243 ice_skating_field_condition 2020-02-04T10:54:20.474941+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
40455 7244 ice_skating_field_condition 2020-02-04T10:54:48.555474+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
41568 7245 ice_skating_field_condition 2020-02-04T10:55:15.062496+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
51402 7246 ice_skating_field_condition 2020-02-04T10:55:30.282898+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
40934 7248 ice_skating_field_condition 2020-02-04T10:56:06.551146+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
40218 7249 ice_skating_field_condition 2020-02-04T11:03:46.260342+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
40059 7250 ice_skating_field_condition 2020-02-04T11:04:18.935802+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
40013 7251 ice_skating_field_condition 2020-02-04T11:27:47.301730+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
41096 7254 ice_skating_field_condition 2020-02-04T12:04:59.924082+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
41994 7255 ice_skating_field_condition 2020-02-04T12:12:19.682878+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42034 7256 ice_skating_field_condition 2020-02-04T12:18:31.895282+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42241 7260 ice_skating_field_condition 2020-02-04T13:16:44.949309+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
40040 7261 ice_skating_field_condition 2020-02-04T13:17:21.053348+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
40970 7264 ice_skating_field_condition 2020-02-04T16:30:41.256899+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
50605 7265 ice_skating_field_condition 2020-02-04T16:40:15.288413+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
40934 7269 ice_skating_field_condition 2020-02-04T21:36:35.646880+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
40013 7279 ice_skating_field_condition 2020-02-05T08:00:10.153763+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
40934 7286 ice_skating_field_condition 2020-02-05T09:00:52.861594+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42553 7292 ice_skating_field_condition 2020-02-05T09:02:19.291968+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
53090 7293 ice_skating_field_condition 2020-02-05T09:03:13.384035+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42511 7294 ice_skating_field_condition 2020-02-05T09:04:16.782755+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42419 7296 ice_skating_field_condition 2020-02-05T09:04:32.531500+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42644 7298 ice_skating_field_condition 2020-02-05T09:04:47.626440+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42542 7303 ice_skating_field_condition 2020-02-05T09:36:14.810340+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
40252 7311 ice_skating_field_condition 2020-02-05T11:09:05.440881+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
50605 7312 ice_skating_field_condition 2020-02-05T11:22:28.110402+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
50354 7339 ice_skating_field_condition 2020-02-06T09:28:54.516377+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
41494 7342 ice_skating_field_condition 2020-02-06T10:50:26.951821+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
39911 7348 ice_skating_field_condition 2020-02-06T10:58:17.561990+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
58433 7355 ice_skating_field_condition 2020-02-06T14:09:17.565827+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42669 7356 ice_skating_field_condition 2020-02-06T14:10:06.079147+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42338 7357 ice_skating_field_condition 2020-02-06T14:10:21.991242+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42034 7366 ice_skating_field_condition 2020-02-06T15:54:02.160489+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42111 7370 ice_skating_field_condition 2020-02-06T19:13:37.755649+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
51451 7371 ice_skating_field_condition 2020-02-06T19:14:13.278272+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42185 7381 ice_skating_field_condition 2020-02-07T07:58:42.062650+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42319 7399 ice_skating_field_condition 2020-02-07T12:31:33.115775+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42701 7400 ice_skating_field_condition 2020-02-07T12:32:19.221895+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42750 7401 ice_skating_field_condition 2020-02-07T12:32:43.946401+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42565 7402 ice_skating_field_condition 2020-02-07T12:33:03.016864+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42806 7403 ice_skating_field_condition 2020-02-07T12:33:20.540063+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42581 7404 ice_skating_field_condition 2020-02-07T12:33:35.287872+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42549 7405 ice_skating_field_condition 2020-02-07T12:33:52.126998+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42518 7406 ice_skating_field_condition 2020-02-07T12:34:32.039229+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42913 7407 ice_skating_field_condition 2020-02-07T13:46:16.871643+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42593 7408 ice_skating_field_condition 2020-02-07T13:47:42.779105+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42847 7409 ice_skating_field_condition 2020-02-07T13:48:23.345643+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42902 7410 ice_skating_field_condition 2020-02-07T13:49:35.344137+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42489 7411 ice_skating_field_condition 2020-02-07T13:50:10.947975+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42743 7412 ice_skating_field_condition 2020-02-07T13:50:43.440505+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42562 7413 ice_skating_field_condition 2020-02-07T13:51:51.165205+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
53093 7414 ice_skating_field_condition 2020-02-07T13:52:22.413590+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
53089 7415 ice_skating_field_condition 2020-02-07T13:52:53.581201+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
46175 7418 ice_skating_field_condition 2020-02-07T13:54:08.942542+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
46175 7419 ice_skating_field_condition 2020-02-07T14:00:55.148783+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
41148 7573 ice_skating_field_condition 2020-02-11T15:23:37.163140+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
61464 7751 ice_skating_field_condition 2020-02-19T08:51:25.578320+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
61464 7776 ice_skating_field_condition 2020-02-20T07:42:54.364140+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
40970 7864 ice_skating_field_condition 2020-02-25T09:20:54.321661+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
50354 7888 ice_skating_field_condition 2020-02-26T08:00:01.859542+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
50518 8278 ice_skating_field_condition 2020-03-16T20:43:15.370264+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
41148 13892 ice_skating_field_condition 2020-08-17T13:38:31.778812+0300     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
53615 32228 ice_skating_field_condition 2020-11-10T10:52:34.650072+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42699 32540 ice_skating_field_condition 2020-11-11T12:04:51.433799+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
63148 32807 ice_skating_field_condition 2020-11-12T09:39:36.019096+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
46144 33222 ice_skating_field_condition 2020-11-13T18:23:40.315989+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42699 33223 ice_skating_field_condition 2020-11-13T18:26:52.312319+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
47279 33994 ice_skating_field_condition 2020-11-16T07:08:38.096537+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
41770 35640 ice_skating_field_condition 2020-11-21T17:09:25.124052+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
40493 35811 ice_skating_field_condition 2020-11-22T10:01:32.264991+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42185 36451 ice_skating_field_condition 2020-11-24T11:32:35.095539+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42249 37282 ice_skating_field_condition 2020-11-27T07:29:56.677804+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
40725 37523 ice_skating_field_condition 2020-11-28T01:26:55.177956+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
61464 37598 ice_skating_field_condition 2020-11-28T06:56:20.132436+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
61464 37601 ice_skating_field_condition 2020-11-28T06:57:08.798139+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
61464 38608 ice_skating_field_condition 2020-12-01T11:52:05.163363+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
40493 39218 ice_skating_field_condition 2020-12-03T07:39:42.076577+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
39716 39911 ice_skating_field_condition 2020-12-05T09:40:00.319235+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
41549 39948 ice_skating_field_condition 2020-12-05T12:22:42.055717+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
40421 39950 ice_skating_field_condition 2020-12-05T12:27:40.638392+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42185 40809 ice_skating_field_condition 2020-12-08T07:58:48.786119+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
42185 41150 ice_skating_field_condition 2020-12-09T08:05:46.416732+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
61464 41272 ice_skating_field_condition 2020-12-09T16:03:00.652834+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable