observation
20 rows where name_sv = "Svag" and quality = "unusable"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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
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 );