observation
147 rows where name_en = "Good condition" sorted by unit
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 );