observation
16 rows where name_fi = "Lumetus kesken"
This data as json, CSV (advanced)
Suggested facets: unit
| id ▼ | unit | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6009 | 53710 | ski_trail_condition | 2019-11-07T05:43:34.175106+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 6044 | 53710 | ski_trail_condition | 2019-11-15T07:30:50.342752+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 6179 | 53710 | ski_trail_condition | 2019-11-30T11:24:00.805300+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 6328 | 51028 | ski_trail_condition | 2019-12-10T17:34:12.368332+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 6329 | 51028 | ski_trail_condition | 2019-12-11T07:38:18.388923+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 6331 | 60871 | ski_trail_condition | 2019-12-11T07:56:14.603825+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 6543 | 57401 | ski_trail_condition | 2019-12-27T15:36:07.959938+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 6685 | 60871 | ski_trail_condition | 2020-01-05T16:58:55.453285+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 6754 | 57401 | ski_trail_condition | 2020-01-10T18:42:11.515604+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 7236 | 57401 | ski_trail_condition | 2020-02-04T08:00:23.822392+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 7304 | 57401 | ski_trail_condition | 2020-02-05T09:39:50.424854+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 7858 | 57401 | ski_trail_condition | 2020-02-25T08:17:27.313912+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 8221 | 57401 | ski_trail_condition | 2020-03-14T07:03:20.820194+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 8236 | 57401 | ski_trail_condition | 2020-03-14T23:21:39.024036+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 50957 | 57401 | ski_trail_condition | 2021-01-04T14:34:00.447647+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 50958 | 57401 | ski_trail_condition | 2021-01-04T14:34:03.949313+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable |
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 );