observation
51 rows where unit = 60871 and value = "good"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6343 | 60871 | ski_trail_condition | 2019-12-11T09:08:19.813530+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6381 | 60871 | ski_trail_condition | 2019-12-13T13:57:33.341521+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6388 | 60871 | ski_trail_condition | 2019-12-14T10:38:45.600268+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6396 | 60871 | ski_trail_condition | 2019-12-15T07:39:59.437880+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6418 | 60871 | ski_trail_condition | 2019-12-16T12:25:51.151374+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6442 | 60871 | ski_trail_condition | 2019-12-19T07:45:54.212502+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6456 | 60871 | ski_trail_condition | 2019-12-20T00:04:26.555249+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6471 | 60871 | ski_trail_condition | 2019-12-21T10:07:09.645066+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6476 | 60871 | ski_trail_condition | 2019-12-21T22:15:08.210428+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6493 | 60871 | ski_trail_condition | 2019-12-23T08:26:52.872679+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6514 | 60871 | ski_trail_condition | 2019-12-25T08:50:10.732707+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6518 | 60871 | ski_trail_condition | 2019-12-26T08:21:27.462970+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6520 | 60871 | ski_trail_condition | 2019-12-26T08:21:36.458645+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6530 | 60871 | ski_trail_condition | 2019-12-27T08:13:48.995474+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6568 | 60871 | ski_trail_condition | 2019-12-29T08:51:39.970376+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6601 | 60871 | ski_trail_condition | 2019-12-31T07:42:35.781015+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6610 | 60871 | ski_trail_condition | 2019-12-31T21:31:32.314416+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6632 | 60871 | ski_trail_condition | 2020-01-02T10:00:45.665837+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6667 | 60871 | ski_trail_condition | 2020-01-05T07:46:19.292266+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6877 | 60871 | ski_trail_condition | 2020-01-17T08:15:49.872372+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6991 | 60871 | ski_trail_condition | 2020-01-21T21:41:41.750505+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7012 | 60871 | ski_trail_condition | 2020-01-23T06:19:06.249894+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7037 | 60871 | ski_trail_condition | 2020-01-24T09:55:53.390561+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7070 | 60871 | ski_trail_condition | 2020-01-25T23:04:35.866730+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7090 | 60871 | ski_trail_condition | 2020-01-27T07:50:48.053429+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7131 | 60871 | ski_trail_condition | 2020-01-29T08:03:32.880807+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7133 | 60871 | ski_trail_condition | 2020-01-29T08:05:06.716643+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7272 | 60871 | ski_trail_condition | 2020-02-05T05:59:59.941450+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7324 | 60871 | ski_trail_condition | 2020-02-06T00:24:34.490282+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7460 | 60871 | ski_trail_condition | 2020-02-08T16:26:09.418862+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7608 | 60871 | ski_trail_condition | 2020-02-13T07:59:42.417578+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7637 | 60871 | ski_trail_condition | 2020-02-14T09:55:48.094355+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7656 | 60871 | ski_trail_condition | 2020-02-15T07:09:46.017331+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7770 | 60871 | ski_trail_condition | 2020-02-19T22:42:28.908174+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7867 | 60871 | ski_trail_condition | 2020-02-25T09:47:38.728329+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7950 | 60871 | ski_trail_condition | 2020-02-29T06:46:19.586173+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7952 | 60871 | ski_trail_condition | 2020-02-29T06:46:24.181772+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7985 | 60871 | ski_trail_condition | 2020-03-01T07:53:48.833028+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
8030 | 60871 | ski_trail_condition | 2020-03-02T22:36:06.751040+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
8105 | 60871 | ski_trail_condition | 2020-03-06T13:38:25.245857+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
8127 | 60871 | ski_trail_condition | 2020-03-08T07:49:17.629415+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
8129 | 60871 | ski_trail_condition | 2020-03-08T07:49:30.428948+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
42185 | 60871 | ski_trail_condition | 2020-12-12T11:41:02.503575+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
44840 | 60871 | ski_trail_condition | 2020-12-20T07:15:44.615047+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
47456 | 60871 | ski_trail_condition | 2020-12-27T01:11:22.949464+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
48004 | 60871 | ski_trail_condition | 2020-12-28T10:27:27.097583+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
48430 | 60871 | ski_trail_condition | 2020-12-29T10:48:25.489601+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
48768 | 60871 | ski_trail_condition | 2020-12-30T07:39:48.552666+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
49160 | 60871 | ski_trail_condition | 2020-12-31T07:26:26.000942+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
49555 | 60871 | ski_trail_condition | 2021-01-01T07:21:11.560439+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
49957 | 60871 | ski_trail_condition | 2021-01-02T07:07:06.440744+0200 | Hyvä | Bra | 1 | Good condition | good | good |
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 );