observation
220 rows where name_sv = "Iståndsatt" sorted by name_fi
This data as json, CSV (advanced)
id | unit | property | time | expiration_time | value_fi | name_fi ▼ | value_sv | name_sv | primary | name_en | value | quality | value_en |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7323 | 60871 | ski_trail_maintenance | 2020-02-06T00:24:34.490282+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7327 | 57401 | ski_trail_maintenance | 2020-02-06T08:00:16.857249+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7353 | 57401 | ski_trail_maintenance | 2020-02-06T13:58:35.149930+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7372 | 57401 | ski_trail_maintenance | 2020-02-07T05:49:26.323084+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7422 | 57401 | ski_trail_maintenance | 2020-02-07T18:58:45.551149+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7426 | 57401 | ski_trail_maintenance | 2020-02-08T06:44:59.727346+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7443 | 57401 | ski_trail_maintenance | 2020-02-08T09:55:15.643443+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7450 | 60871 | ski_trail_maintenance | 2020-02-08T11:11:04.440142+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7455 | 57401 | ski_trail_maintenance | 2020-02-08T13:16:51.022202+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7459 | 60871 | ski_trail_maintenance | 2020-02-08T16:26:09.418862+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7477 | 57401 | ski_trail_maintenance | 2020-02-09T08:14:29.411644+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7491 | 57401 | ski_trail_maintenance | 2020-02-09T11:09:37.721240+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7521 | 60871 | ski_trail_maintenance | 2020-02-10T08:36:42.291038+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7551 | 53710 | ski_trail_maintenance | 2020-02-11T06:17:52.833501+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7565 | 57401 | ski_trail_maintenance | 2020-02-11T13:44:17.099742+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7581 | 57401 | ski_trail_maintenance | 2020-02-12T07:50:36.634179+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7607 | 60871 | ski_trail_maintenance | 2020-02-13T07:59:42.417578+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7609 | 57401 | ski_trail_maintenance | 2020-02-13T08:16:01.120662+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7616 | 53710 | ski_trail_maintenance | 2020-02-13T13:16:02.728670+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7618 | 57401 | ski_trail_maintenance | 2020-02-13T13:23:18.835539+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7633 | 57401 | ski_trail_maintenance | 2020-02-14T09:26:42.848904+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7636 | 60871 | ski_trail_maintenance | 2020-02-14T09:55:48.094355+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7641 | 57401 | ski_trail_maintenance | 2020-02-14T13:44:15.553657+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7647 | 53710 | ski_trail_maintenance | 2020-02-15T03:43:44.409406+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7649 | 54329 | ski_trail_maintenance | 2020-02-15T03:44:25.849912+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7653 | 57401 | ski_trail_maintenance | 2020-02-15T06:45:32.218884+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7655 | 60871 | ski_trail_maintenance | 2020-02-15T07:09:46.017331+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7742 | 53710 | ski_trail_maintenance | 2020-02-19T07:58:28.133899+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7745 | 60871 | ski_trail_maintenance | 2020-02-19T08:09:24.405837+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7769 | 60871 | ski_trail_maintenance | 2020-02-19T22:42:28.908174+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7771 | 53710 | ski_trail_maintenance | 2020-02-20T00:52:20.900814+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7849 | 60871 | ski_trail_maintenance | 2020-02-24T22:14:31.815186+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7866 | 60871 | ski_trail_maintenance | 2020-02-25T09:47:38.728329+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7871 | 51086 | ski_trail_maintenance | 2020-02-25T12:03:44.898028+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7927 | 53710 | ski_trail_maintenance | 2020-02-28T04:52:34.368224+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7944 | 57401 | ski_trail_maintenance | 2020-02-28T15:31:54.435420+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7951 | 60871 | ski_trail_maintenance | 2020-02-29T06:46:24.181772+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7953 | 57401 | ski_trail_maintenance | 2020-02-29T07:17:20.026242+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7966 | 57401 | ski_trail_maintenance | 2020-02-29T13:43:59.514229+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7974 | 57401 | ski_trail_maintenance | 2020-02-29T15:04:04.897212+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7984 | 60871 | ski_trail_maintenance | 2020-03-01T07:53:48.833028+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
7991 | 57401 | ski_trail_maintenance | 2020-03-01T09:36:09.384585+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8006 | 53710 | ski_trail_maintenance | 2020-03-02T07:54:35.921101+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8009 | 57401 | ski_trail_maintenance | 2020-03-02T09:19:20.582421+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8014 | 60871 | ski_trail_maintenance | 2020-03-02T10:26:49.134372+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8016 | 57401 | ski_trail_maintenance | 2020-03-02T12:56:01.941416+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8029 | 60871 | ski_trail_maintenance | 2020-03-02T22:36:06.751040+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8034 | 57401 | ski_trail_maintenance | 2020-03-03T07:47:51.051472+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8040 | 57401 | ski_trail_maintenance | 2020-03-03T09:10:10.738725+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8042 | 57401 | ski_trail_maintenance | 2020-03-03T12:24:11.435003+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8052 | 57401 | ski_trail_maintenance | 2020-03-04T09:19:56.446391+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8071 | 57401 | ski_trail_maintenance | 2020-03-05T08:38:49.705571+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8078 | 57401 | ski_trail_maintenance | 2020-03-05T13:52:03.963809+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8083 | 57401 | ski_trail_maintenance | 2020-03-06T08:08:53.044979+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8102 | 57401 | ski_trail_maintenance | 2020-03-06T12:41:40.542658+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8104 | 60871 | ski_trail_maintenance | 2020-03-06T13:38:25.245857+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8111 | 57401 | ski_trail_maintenance | 2020-03-07T00:40:29.937266+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8124 | 53710 | ski_trail_maintenance | 2020-03-07T16:13:54.098929+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8128 | 60871 | ski_trail_maintenance | 2020-03-08T07:49:30.428948+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8131 | 57401 | ski_trail_maintenance | 2020-03-08T08:23:49.721343+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8138 | 57401 | ski_trail_maintenance | 2020-03-08T10:38:22.987654+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8147 | 57401 | ski_trail_maintenance | 2020-03-09T07:05:19.199434+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8166 | 57401 | ski_trail_maintenance | 2020-03-10T07:08:25.482086+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8181 | 60871 | ski_trail_maintenance | 2020-03-10T13:37:33.621502+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8194 | 57401 | ski_trail_maintenance | 2020-03-12T08:49:57.146671+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8202 | 60871 | ski_trail_maintenance | 2020-03-12T12:41:52.934489+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8212 | 60871 | ski_trail_maintenance | 2020-03-13T08:30:55.333394+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8229 | 57401 | ski_trail_maintenance | 2020-03-14T11:15:26.033939+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8238 | 53710 | ski_trail_maintenance | 2020-03-15T02:03:02.603783+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8242 | 57401 | ski_trail_maintenance | 2020-03-15T09:23:58.613945+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8261 | 57401 | ski_trail_maintenance | 2020-03-16T09:27:58.359621+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8265 | 57401 | ski_trail_maintenance | 2020-03-16T12:44:48.974622+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8270 | 53710 | ski_trail_maintenance | 2020-03-16T15:04:03.490018+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8279 | 60871 | ski_trail_maintenance | 2020-03-17T07:42:43.043355+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8281 | 53710 | ski_trail_maintenance | 2020-03-17T08:46:21.661452+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8285 | 57401 | ski_trail_maintenance | 2020-03-17T09:26:03.990867+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8287 | 57401 | ski_trail_maintenance | 2020-03-17T11:55:16.286272+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8291 | 57401 | ski_trail_maintenance | 2020-03-17T13:28:13.865996+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8295 | 53710 | ski_trail_maintenance | 2020-03-18T07:51:46.366764+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8297 | 57401 | ski_trail_maintenance | 2020-03-18T08:15:55.392234+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8306 | 57401 | ski_trail_maintenance | 2020-03-19T08:00:34.196525+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8315 | 57401 | ski_trail_maintenance | 2020-03-20T06:26:03.690872+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8324 | 57401 | ski_trail_maintenance | 2020-03-21T08:22:42.718269+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8328 | 57401 | ski_trail_maintenance | 2020-03-21T11:40:11.499262+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8332 | 53710 | ski_trail_maintenance | 2020-03-22T01:20:40.714734+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8336 | 57401 | ski_trail_maintenance | 2020-03-22T08:19:37.199729+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8340 | 57401 | ski_trail_maintenance | 2020-03-22T10:44:49.506667+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
8342 | 60871 | ski_trail_maintenance | 2020-03-22T21:11:42.745322+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
41917 | 53710 | ski_trail_maintenance | 2020-12-11T16:09:15.450515+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
42518 | 53710 | ski_trail_maintenance | 2020-12-13T12:42:55.526175+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
42722 | 53710 | ski_trail_maintenance | 2020-12-14T04:43:27.140083+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
42724 | 53710 | ski_trail_maintenance | 2020-12-14T04:43:32.329164+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
42873 | 53710 | ski_trail_maintenance | 2020-12-14T15:40:19.068128+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
43235 | 57401 | ski_trail_maintenance | 2020-12-15T18:15:22.964565+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
43350 | 57401 | ski_trail_maintenance | 2020-12-16T02:58:58.706463+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
43414 | 53710 | ski_trail_maintenance | 2020-12-16T07:11:33.976982+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
43744 | 53710 | ski_trail_maintenance | 2020-12-17T07:03:20.878325+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
43778 | 57401 | ski_trail_maintenance | 2020-12-17T09:08:00.553888+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
43849 | 57401 | ski_trail_maintenance | 2020-12-17T13:50:28.864271+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
44066 | 53710 | ski_trail_maintenance | 2020-12-18T06:41:50.663424+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [observation] ( [unit] INTEGER, [id] INTEGER PRIMARY KEY, [property] TEXT, [time] TEXT, [expiration_time] TEXT, [value_fi] TEXT, [name_fi] TEXT, [value_sv] TEXT, [name_sv] TEXT, [primary] INTEGER, [name_en] TEXT, [value] TEXT, [quality] TEXT, [value_en] TEXT );