16 rows where quality = "unusable" and value = "snowmaking"

View and edit SQL

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

CSV options:

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
);