observation

20 rows where name_en = "Poor condition"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

name_en ✖

  • Poor condition · 20 ✖
id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
6301 51028 ski_trail_condition 2019-12-09T08:10:46.657526+0200     Heikko   Svag 1 Poor condition poor unusable  
6643 60871 ski_trail_condition 2020-01-03T10:13:16.015496+0200     Heikko   Svag 1 Poor condition poor unusable  
6724 57401 ski_trail_condition 2020-01-09T06:59:51.924056+0200     Heikko   Svag 1 Poor condition poor unusable  
6839 57401 ski_trail_condition 2020-01-15T09:13:20.629690+0200     Heikko   Svag 1 Poor condition poor unusable  
6915 57401 ski_trail_condition 2020-01-19T07:02:49.458039+0200     Heikko   Svag 1 Poor condition poor unusable  
6948 60871 ski_trail_condition 2020-01-20T08:14:14.650798+0200     Heikko   Svag 1 Poor condition poor unusable  
6959 57401 ski_trail_condition 2020-01-20T11:59:09.700925+0200     Heikko   Svag 1 Poor condition poor unusable  
7117 57401 ski_trail_condition 2020-01-28T10:25:01.307008+0200     Heikko   Svag 1 Poor condition poor unusable  
7138 57401 ski_trail_condition 2020-01-29T11:44:11.609621+0200     Heikko   Svag 1 Poor condition poor unusable  
7526 57401 ski_trail_condition 2020-02-10T08:45:17.247106+0200     Heikko   Svag 1 Poor condition poor unusable  
7676 57401 ski_trail_condition 2020-02-16T06:46:56.885993+0200     Heikko   Svag 1 Poor condition poor unusable  
7755 57401 ski_trail_condition 2020-02-19T09:35:54.069427+0200     Heikko   Svag 1 Poor condition poor unusable  
7810 60871 ski_trail_condition 2020-02-22T08:02:23.192386+0200     Heikko   Svag 1 Poor condition poor unusable  
7851 60871 ski_trail_condition 2020-02-24T22:16:11.787201+0200     Heikko   Svag 1 Poor condition poor unusable  
8058 57401 ski_trail_condition 2020-03-04T13:04:03.888766+0200     Heikko   Svag 1 Poor condition poor unusable  
8188 57401 ski_trail_condition 2020-03-11T06:55:26.962186+0200     Heikko   Svag 1 Poor condition poor unusable  
8214 57401 ski_trail_condition 2020-03-13T10:28:53.621246+0200     Heikko   Svag 1 Poor condition poor unusable  
8344 60871 ski_trail_condition 2020-03-22T21:11:47.691567+0200     Heikko   Svag 1 Poor condition poor unusable  
45257 57401 ski_trail_condition 2020-12-21T06:30:28.549857+0200     Heikko   Svag 1 Poor condition poor unusable  
45660 57401 ski_trail_condition 2020-12-22T06:21:16.259314+0200     Heikko   Svag 1 Poor condition poor 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
);