observation

4 rows where quality = "unusable" and value = "event"

✎ View and edit SQL

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
6840 60871 ski_trail_condition 2020-01-15T10:42:17.359293+0200     Kilpailut/harjoitukset   Tävlingar/träningar 1 Closed due to training or a competition event unusable  
7062 53710 ski_trail_condition 2020-01-25T11:33:50.585367+0200     Kilpailut/harjoitukset   Tävlingar/träningar 1 Closed due to training or a competition event unusable  
7451 60871 ski_trail_condition 2020-02-08T11:11:04.440142+0200     Kilpailut/harjoitukset   Tävlingar/träningar 1 Closed due to training or a competition event unusable  
7962 53710 ski_trail_condition 2020-02-29T10:25:09.640327+0200     Kilpailut/harjoitukset   Tävlingar/träningar 1 Closed due to training or a competition event 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
);