observation
92 rows where name_sv = "Hyfsad"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6063 | 53710 | ski_trail_condition | 2019-11-18T15:29:15.961698+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6321 | 53710 | ski_trail_condition | 2019-12-10T11:54:29.446483+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6324 | 53710 | ski_trail_condition | 2019-12-10T13:53:03.961596+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6548 | 60871 | ski_trail_condition | 2019-12-28T06:39:35.545330+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6612 | 57401 | ski_trail_condition | 2020-01-01T07:44:18.918301+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6616 | 57401 | ski_trail_condition | 2020-01-02T07:13:32.980528+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6634 | 57401 | ski_trail_condition | 2020-01-03T06:51:07.389426+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6652 | 57401 | ski_trail_condition | 2020-01-03T22:18:01.255784+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6654 | 60871 | ski_trail_condition | 2020-01-04T07:42:49.854593+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6680 | 57401 | ski_trail_condition | 2020-01-05T09:21:07.649472+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6687 | 57401 | ski_trail_condition | 2020-01-06T06:07:14.197337+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6702 | 57401 | ski_trail_condition | 2020-01-07T07:38:14.369933+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6721 | 57401 | ski_trail_condition | 2020-01-08T09:04:22.736449+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6777 | 57401 | ski_trail_condition | 2020-01-12T08:19:17.928143+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6806 | 57401 | ski_trail_condition | 2020-01-13T08:52:44.529606+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6812 | 57401 | ski_trail_condition | 2020-01-13T13:43:32.263283+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6819 | 57401 | ski_trail_condition | 2020-01-14T08:01:43.100199+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6829 | 57401 | ski_trail_condition | 2020-01-14T13:13:58.104888+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6856 | 57401 | ski_trail_condition | 2020-01-16T07:55:35.906710+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6861 | 57401 | ski_trail_condition | 2020-01-16T10:45:40.686359+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6875 | 57401 | ski_trail_condition | 2020-01-17T07:46:21.549817+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6889 | 57401 | ski_trail_condition | 2020-01-17T13:29:49.942021+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6897 | 57401 | ski_trail_condition | 2020-01-18T07:25:32.604944+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6901 | 60871 | ski_trail_condition | 2020-01-18T07:57:33.829939+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6917 | 60871 | ski_trail_condition | 2020-01-19T07:47:33.094254+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7034 | 57401 | ski_trail_condition | 2020-01-24T09:53:57.359809+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7044 | 57401 | ski_trail_condition | 2020-01-24T13:46:09.733827+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7051 | 57401 | ski_trail_condition | 2020-01-25T06:53:50.789786+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7068 | 57401 | ski_trail_condition | 2020-01-25T20:40:57.050343+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7097 | 57401 | ski_trail_condition | 2020-01-27T08:18:31.264213+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7103 | 57401 | ski_trail_condition | 2020-01-27T12:39:03.568980+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7115 | 60871 | ski_trail_condition | 2020-01-28T09:57:20.669282+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7121 | 51086 | ski_trail_condition | 2020-01-28T14:00:21.099020+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7154 | 60871 | ski_trail_condition | 2020-01-30T08:52:29.583774+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7169 | 60871 | ski_trail_condition | 2020-01-31T08:00:26.192021+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7182 | 60871 | ski_trail_condition | 2020-01-31T22:24:26.862505+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7200 | 60871 | ski_trail_condition | 2020-02-02T06:54:03.673970+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7223 | 60871 | ski_trail_condition | 2020-02-03T08:38:45.078520+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7309 | 57401 | ski_trail_condition | 2020-02-05T10:38:46.614074+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7315 | 57401 | ski_trail_condition | 2020-02-05T14:17:02.699575+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7427 | 57401 | ski_trail_condition | 2020-02-08T06:44:59.727346+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7456 | 57401 | ski_trail_condition | 2020-02-08T13:16:51.022202+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7492 | 57401 | ski_trail_condition | 2020-02-09T11:09:37.721240+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7522 | 60871 | ski_trail_condition | 2020-02-10T08:36:42.291038+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7566 | 57401 | ski_trail_condition | 2020-02-11T13:44:17.099742+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7619 | 57401 | ski_trail_condition | 2020-02-13T13:23:18.835539+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7634 | 57401 | ski_trail_condition | 2020-02-14T09:26:42.848904+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7642 | 57401 | ski_trail_condition | 2020-02-14T13:44:15.553657+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7654 | 57401 | ski_trail_condition | 2020-02-15T06:45:32.218884+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7746 | 60871 | ski_trail_condition | 2020-02-19T08:09:24.405837+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7850 | 60871 | ski_trail_condition | 2020-02-24T22:14:31.815186+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7872 | 51086 | ski_trail_condition | 2020-02-25T12:03:44.898028+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7945 | 57401 | ski_trail_condition | 2020-02-28T15:31:54.435420+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 7992 | 57401 | ski_trail_condition | 2020-03-01T09:36:09.384585+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8015 | 60871 | ski_trail_condition | 2020-03-02T10:26:49.134372+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8017 | 57401 | ski_trail_condition | 2020-03-02T12:56:01.941416+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8053 | 57401 | ski_trail_condition | 2020-03-04T09:19:56.446391+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8072 | 57401 | ski_trail_condition | 2020-03-05T08:38:49.705571+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8079 | 57401 | ski_trail_condition | 2020-03-05T13:52:03.963809+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8084 | 57401 | ski_trail_condition | 2020-03-06T08:08:53.044979+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8103 | 57401 | ski_trail_condition | 2020-03-06T12:41:40.542658+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8132 | 57401 | ski_trail_condition | 2020-03-08T08:23:49.721343+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8139 | 57401 | ski_trail_condition | 2020-03-08T10:38:22.987654+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8148 | 57401 | ski_trail_condition | 2020-03-09T07:05:19.199434+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8167 | 57401 | ski_trail_condition | 2020-03-10T07:08:25.482086+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8182 | 60871 | ski_trail_condition | 2020-03-10T13:37:33.621502+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8195 | 57401 | ski_trail_condition | 2020-03-12T08:49:57.146671+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8203 | 60871 | ski_trail_condition | 2020-03-12T12:41:52.934489+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8213 | 60871 | ski_trail_condition | 2020-03-13T08:30:55.333394+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8230 | 57401 | ski_trail_condition | 2020-03-14T11:15:26.033939+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8243 | 57401 | ski_trail_condition | 2020-03-15T09:23:58.613945+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8262 | 57401 | ski_trail_condition | 2020-03-16T09:27:58.359621+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8266 | 57401 | ski_trail_condition | 2020-03-16T12:44:48.974622+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8280 | 60871 | ski_trail_condition | 2020-03-17T07:42:43.043355+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8286 | 57401 | ski_trail_condition | 2020-03-17T09:26:03.990867+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8288 | 57401 | ski_trail_condition | 2020-03-17T11:55:16.286272+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8292 | 57401 | ski_trail_condition | 2020-03-17T13:28:13.865996+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8298 | 57401 | ski_trail_condition | 2020-03-18T08:15:55.392234+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8307 | 57401 | ski_trail_condition | 2020-03-19T08:00:34.196525+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8316 | 57401 | ski_trail_condition | 2020-03-20T06:26:03.690872+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8325 | 57401 | ski_trail_condition | 2020-03-21T08:22:42.718269+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8329 | 57401 | ski_trail_condition | 2020-03-21T11:40:11.499262+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8337 | 57401 | ski_trail_condition | 2020-03-22T08:19:37.199729+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8341 | 57401 | ski_trail_condition | 2020-03-22T10:44:49.506667+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8343 | 60871 | ski_trail_condition | 2020-03-22T21:11:42.745322+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 8348 | 53710 | ski_trail_condition | 2020-03-23T10:11:04.714511+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 43236 | 57401 | ski_trail_condition | 2020-12-15T18:15:22.964565+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 43779 | 57401 | ski_trail_condition | 2020-12-17T09:08:00.553888+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 43850 | 57401 | ski_trail_condition | 2020-12-17T13:50:28.864271+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 44192 | 57401 | ski_trail_condition | 2020-12-18T14:31:26.232730+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 44444 | 57401 | ski_trail_condition | 2020-12-19T08:35:31.727189+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 45683 | 60871 | ski_trail_condition | 2020-12-22T07:42:29.221769+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory |
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 );