observation
20 rows where unit = 57401 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6581 | 57401 | ski_trail_condition | 2019-12-29T11:19:37.341758+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6585 | 57401 | ski_trail_condition | 2019-12-30T07:13:10.054466+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6607 | 57401 | ski_trail_condition | 2019-12-31T11:28:09.621779+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6766 | 57401 | ski_trail_condition | 2020-01-11T12:21:06.555406+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7328 | 57401 | ski_trail_condition | 2020-02-06T08:00:16.857249+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7354 | 57401 | ski_trail_condition | 2020-02-06T13:58:35.149930+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7373 | 57401 | ski_trail_condition | 2020-02-07T05:49:26.323084+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7423 | 57401 | ski_trail_condition | 2020-02-07T18:58:45.551149+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7444 | 57401 | ski_trail_condition | 2020-02-08T09:55:15.643443+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7478 | 57401 | ski_trail_condition | 2020-02-09T08:14:29.411644+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7582 | 57401 | ski_trail_condition | 2020-02-12T07:50:36.634179+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7610 | 57401 | ski_trail_condition | 2020-02-13T08:16:01.120662+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7954 | 57401 | ski_trail_condition | 2020-02-29T07:17:20.026242+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7967 | 57401 | ski_trail_condition | 2020-02-29T13:43:59.514229+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7975 | 57401 | ski_trail_condition | 2020-02-29T15:04:04.897212+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
8010 | 57401 | ski_trail_condition | 2020-03-02T09:19:20.582421+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
8035 | 57401 | ski_trail_condition | 2020-03-03T07:47:51.051472+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
8041 | 57401 | ski_trail_condition | 2020-03-03T09:10:10.738725+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
8043 | 57401 | ski_trail_condition | 2020-03-03T12:24:11.435003+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
8112 | 57401 | ski_trail_condition | 2020-03-07T00:40:29.937266+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 );