servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
53710 6016 ski_trail_condition 2019-11-08T14:21:00.052967+0200     Hyvä   Bra 1 Good condition good good  
53710 6019 ski_trail_condition 2019-11-09T23:47:01.036909+0200     Hyvä   Bra 1 Good condition good good  
53710 6048 ski_trail_condition 2019-11-16T01:05:56.223240+0200     Hyvä   Bra 1 Good condition good good  
53710 6120 ski_trail_condition 2019-11-25T14:06:25.226345+0200     Hyvä   Bra 1 Good condition good good  
53710 6126 ski_trail_condition 2019-11-26T08:37:51.926400+0200     Hyvä   Bra 1 Good condition good good  
53710 6161 ski_trail_condition 2019-11-27T10:12:39.120372+0200     Hyvä   Bra 1 Good condition good good  
53710 6201 ski_trail_condition 2019-12-01T11:09:04.755950+0200     Hyvä   Bra 1 Good condition good good  
53710 6206 ski_trail_condition 2019-12-02T07:12:42.393218+0200     Hyvä   Bra 1 Good condition good good  
53710 6237 ski_trail_condition 2019-12-04T08:14:21.041850+0200     Hyvä   Bra 1 Good condition good good  
53710 6252 ski_trail_condition 2019-12-05T06:47:02.298313+0200     Hyvä   Bra 1 Good condition good good  
53710 6289 ski_trail_condition 2019-12-07T22:30:27.408710+0200     Hyvä   Bra 1 Good condition good good  
53710 6339 ski_trail_condition 2019-12-11T08:55:58.890711+0200     Hyvä   Bra 1 Good condition good good  
60871 6343 ski_trail_condition 2019-12-11T09:08:19.813530+0200     Hyvä   Bra 1 Good condition good good  
60871 6381 ski_trail_condition 2019-12-13T13:57:33.341521+0200     Hyvä   Bra 1 Good condition good good  
60871 6388 ski_trail_condition 2019-12-14T10:38:45.600268+0200     Hyvä   Bra 1 Good condition good good  
60871 6396 ski_trail_condition 2019-12-15T07:39:59.437880+0200     Hyvä   Bra 1 Good condition good good  
60871 6418 ski_trail_condition 2019-12-16T12:25:51.151374+0200     Hyvä   Bra 1 Good condition good good  
60871 6442 ski_trail_condition 2019-12-19T07:45:54.212502+0200     Hyvä   Bra 1 Good condition good good  
53710 6446 ski_trail_condition 2019-12-19T08:26:13.707965+0200     Hyvä   Bra 1 Good condition good good  
60871 6456 ski_trail_condition 2019-12-20T00:04:26.555249+0200     Hyvä   Bra 1 Good condition good good  
53710 6464 ski_trail_condition 2019-12-20T08:45:19.352442+0200     Hyvä   Bra 1 Good condition good good  
60871 6471 ski_trail_condition 2019-12-21T10:07:09.645066+0200     Hyvä   Bra 1 Good condition good good  
60871 6476 ski_trail_condition 2019-12-21T22:15:08.210428+0200     Hyvä   Bra 1 Good condition good good  
53710 6478 ski_trail_condition 2019-12-22T00:04:11.782017+0200     Hyvä   Bra 1 Good condition good good  
53710 6489 ski_trail_condition 2019-12-23T06:55:35.440364+0200     Hyvä   Bra 1 Good condition good good  
60871 6493 ski_trail_condition 2019-12-23T08:26:52.872679+0200     Hyvä   Bra 1 Good condition good good  
53710 6512 ski_trail_condition 2019-12-25T06:24:02.901542+0200     Hyvä   Bra 1 Good condition good good  
60871 6514 ski_trail_condition 2019-12-25T08:50:10.732707+0200     Hyvä   Bra 1 Good condition good good  
53710 6517 ski_trail_condition 2019-12-26T00:22:59.249937+0200     Hyvä   Bra 1 Good condition good good  
60871 6518 ski_trail_condition 2019-12-26T08:21:27.462970+0200     Hyvä   Bra 1 Good condition good good  
60871 6520 ski_trail_condition 2019-12-26T08:21:36.458645+0200     Hyvä   Bra 1 Good condition good good  
60871 6530 ski_trail_condition 2019-12-27T08:13:48.995474+0200     Hyvä   Bra 1 Good condition good good  
53710 6554 ski_trail_condition 2019-12-28T09:20:04.907795+0200     Hyvä   Bra 1 Good condition good good  
60871 6568 ski_trail_condition 2019-12-29T08:51:39.970376+0200     Hyvä   Bra 1 Good condition good good  
57401 6581 ski_trail_condition 2019-12-29T11:19:37.341758+0200     Hyvä   Bra 1 Good condition good good  
57401 6585 ski_trail_condition 2019-12-30T07:13:10.054466+0200     Hyvä   Bra 1 Good condition good good  
60871 6601 ski_trail_condition 2019-12-31T07:42:35.781015+0200     Hyvä   Bra 1 Good condition good good  
57401 6607 ski_trail_condition 2019-12-31T11:28:09.621779+0200     Hyvä   Bra 1 Good condition good good  
60871 6610 ski_trail_condition 2019-12-31T21:31:32.314416+0200     Hyvä   Bra 1 Good condition good good  
53710 6618 ski_trail_condition 2020-01-02T07:22:42.310049+0200     Hyvä   Bra 1 Good condition good good  
60871 6632 ski_trail_condition 2020-01-02T10:00:45.665837+0200     Hyvä   Bra 1 Good condition good good  
53710 6635 ski_trail_condition 2020-01-03T07:08:30.612702+0200     Hyvä   Bra 1 Good condition good good  
53710 6646 ski_trail_condition 2020-01-03T11:44:12.936348+0200     Hyvä   Bra 1 Good condition good good  
53710 6650 ski_trail_condition 2020-01-03T21:53:02.260982+0200     Hyvä   Bra 1 Good condition good good  
60871 6667 ski_trail_condition 2020-01-05T07:46:19.292266+0200     Hyvä   Bra 1 Good condition good good  
53710 6671 ski_trail_condition 2020-01-05T08:32:29.955758+0200     Hyvä   Bra 1 Good condition good good  
53710 6699 ski_trail_condition 2020-01-07T07:08:38.379249+0200     Hyvä   Bra 1 Good condition good good  
53710 6740 ski_trail_condition 2020-01-10T07:10:53.882427+0200     Hyvä   Bra 1 Good condition good good  
57401 6766 ski_trail_condition 2020-01-11T12:21:06.555406+0200     Hyvä   Bra 1 Good condition good good  
53710 6779 ski_trail_condition 2020-01-12T08:35:32.650176+0200     Hyvä   Bra 1 Good condition good good  
53710 6799 ski_trail_condition 2020-01-13T07:34:01.597104+0200     Hyvä   Bra 1 Good condition good good  
53710 6853 ski_trail_condition 2020-01-16T07:42:51.652733+0200     Hyvä   Bra 1 Good condition good good  
53710 6870 ski_trail_condition 2020-01-17T06:35:55.553872+0200     Hyvä   Bra 1 Good condition good good  
60871 6877 ski_trail_condition 2020-01-17T08:15:49.872372+0200     Hyvä   Bra 1 Good condition good good  
53710 6895 ski_trail_condition 2020-01-18T00:51:56.860643+0200     Hyvä   Bra 1 Good condition good good  
53710 6914 ski_trail_condition 2020-01-19T03:09:43.545641+0200     Hyvä   Bra 1 Good condition good good  
53710 6947 ski_trail_condition 2020-01-20T07:34:37.896855+0200     Hyvä   Bra 1 Good condition good good  
60871 6991 ski_trail_condition 2020-01-21T21:41:41.750505+0200     Hyvä   Bra 1 Good condition good good  
53710 6998 ski_trail_condition 2020-01-22T08:56:38.405788+0200     Hyvä   Bra 1 Good condition good good  
60871 7012 ski_trail_condition 2020-01-23T06:19:06.249894+0200     Hyvä   Bra 1 Good condition good good  
60871 7037 ski_trail_condition 2020-01-24T09:55:53.390561+0200     Hyvä   Bra 1 Good condition good good  
53710 7065 ski_trail_condition 2020-01-25T17:00:27.557055+0200     Hyvä   Bra 1 Good condition good good  
60871 7070 ski_trail_condition 2020-01-25T23:04:35.866730+0200     Hyvä   Bra 1 Good condition good good  
53710 7072 ski_trail_condition 2020-01-26T00:17:23.849306+0200     Hyvä   Bra 1 Good condition good good  
53710 7088 ski_trail_condition 2020-01-27T07:34:59.593960+0200     Hyvä   Bra 1 Good condition good good  
60871 7090 ski_trail_condition 2020-01-27T07:50:48.053429+0200     Hyvä   Bra 1 Good condition good good  
60871 7131 ski_trail_condition 2020-01-29T08:03:32.880807+0200     Hyvä   Bra 1 Good condition good good  
60871 7133 ski_trail_condition 2020-01-29T08:05:06.716643+0200     Hyvä   Bra 1 Good condition good good  
53710 7198 ski_trail_condition 2020-02-02T00:02:33.014238+0200     Hyvä   Bra 1 Good condition good good  
53710 7216 ski_trail_condition 2020-02-03T07:08:32.944135+0200     Hyvä   Bra 1 Good condition good good  
53710 7233 ski_trail_condition 2020-02-04T02:45:55.867748+0200     Hyvä   Bra 1 Good condition good good  
60871 7272 ski_trail_condition 2020-02-05T05:59:59.941450+0200     Hyvä   Bra 1 Good condition good good  
53710 7274 ski_trail_condition 2020-02-05T06:45:12.655449+0200     Hyvä   Bra 1 Good condition good good  
60871 7324 ski_trail_condition 2020-02-06T00:24:34.490282+0200     Hyvä   Bra 1 Good condition good good  
57401 7328 ski_trail_condition 2020-02-06T08:00:16.857249+0200     Hyvä   Bra 1 Good condition good good  
57401 7354 ski_trail_condition 2020-02-06T13:58:35.149930+0200     Hyvä   Bra 1 Good condition good good  
57401 7373 ski_trail_condition 2020-02-07T05:49:26.323084+0200     Hyvä   Bra 1 Good condition good good  
57401 7423 ski_trail_condition 2020-02-07T18:58:45.551149+0200     Hyvä   Bra 1 Good condition good good  
57401 7444 ski_trail_condition 2020-02-08T09:55:15.643443+0200     Hyvä   Bra 1 Good condition good good  
60871 7460 ski_trail_condition 2020-02-08T16:26:09.418862+0200     Hyvä   Bra 1 Good condition good good  
57401 7478 ski_trail_condition 2020-02-09T08:14:29.411644+0200     Hyvä   Bra 1 Good condition good good  
53710 7552 ski_trail_condition 2020-02-11T06:17:52.833501+0200     Hyvä   Bra 1 Good condition good good  
57401 7582 ski_trail_condition 2020-02-12T07:50:36.634179+0200     Hyvä   Bra 1 Good condition good good  
60871 7608 ski_trail_condition 2020-02-13T07:59:42.417578+0200     Hyvä   Bra 1 Good condition good good  
57401 7610 ski_trail_condition 2020-02-13T08:16:01.120662+0200     Hyvä   Bra 1 Good condition good good  
53710 7617 ski_trail_condition 2020-02-13T13:16:02.728670+0200     Hyvä   Bra 1 Good condition good good  
53710 7623 ski_trail_condition 2020-02-14T01:13:13.788951+0200     Hyvä   Bra 1 Good condition good good  
60871 7637 ski_trail_condition 2020-02-14T09:55:48.094355+0200     Hyvä   Bra 1 Good condition good good  
53710 7648 ski_trail_condition 2020-02-15T03:43:44.409406+0200     Hyvä   Bra 1 Good condition good good  
54329 7650 ski_trail_condition 2020-02-15T03:44:25.849912+0200     Hyvä   Bra 1 Good condition good good  
60871 7656 ski_trail_condition 2020-02-15T07:09:46.017331+0200     Hyvä   Bra 1 Good condition good good  
53710 7743 ski_trail_condition 2020-02-19T07:58:28.133899+0200     Hyvä   Bra 1 Good condition good good  
60871 7770 ski_trail_condition 2020-02-19T22:42:28.908174+0200     Hyvä   Bra 1 Good condition good good  
53710 7772 ski_trail_condition 2020-02-20T00:52:20.900814+0200     Hyvä   Bra 1 Good condition good good  
60871 7867 ski_trail_condition 2020-02-25T09:47:38.728329+0200     Hyvä   Bra 1 Good condition good good  
53710 7928 ski_trail_condition 2020-02-28T04:52:34.368224+0200     Hyvä   Bra 1 Good condition good good  
60871 7950 ski_trail_condition 2020-02-29T06:46:19.586173+0200     Hyvä   Bra 1 Good condition good good  
60871 7952 ski_trail_condition 2020-02-29T06:46:24.181772+0200     Hyvä   Bra 1 Good condition good good  
57401 7954 ski_trail_condition 2020-02-29T07:17:20.026242+0200     Hyvä   Bra 1 Good condition good good  
57401 7967 ski_trail_condition 2020-02-29T13:43:59.514229+0200     Hyvä   Bra 1 Good condition good good  
57401 7975 ski_trail_condition 2020-02-29T15:04:04.897212+0200     Hyvä   Bra 1 Good condition good good