observation
16 rows where quality = "unusable" and value = "snowmaking"
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 );