observation
20 rows where name_fi = "Hyvä" and unit = 57401
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 );