observation
20 rows where name_sv = "Stängd" and property = "ski_trail_condition"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6181 | 53710 | ski_trail_condition | 2019-11-30T11:25:11.706636+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 6332 | 51028 | ski_trail_condition | 2019-12-11T07:56:35.444857+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 6684 | 51028 | ski_trail_condition | 2020-01-05T16:58:24.715481+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 6736 | 60871 | ski_trail_condition | 2020-01-09T14:32:15.463464+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 6752 | 57401 | ski_trail_condition | 2020-01-10T15:45:43.284338+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 6851 | 60871 | ski_trail_condition | 2020-01-15T21:21:28.793075+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 6944 | 57401 | ski_trail_condition | 2020-01-20T07:28:16.861669+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 6968 | 57401 | ski_trail_condition | 2020-01-21T07:42:56.154863+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7004 | 57401 | ski_trail_condition | 2020-01-22T11:52:35.516849+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7148 | 57401 | ski_trail_condition | 2020-01-30T07:53:16.005259+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7214 | 57401 | ski_trail_condition | 2020-02-03T06:17:34.357296+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7705 | 57401 | ski_trail_condition | 2020-02-17T08:07:04.921319+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7722 | 54329 | ski_trail_condition | 2020-02-18T08:59:23.362541+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7840 | 57401 | ski_trail_condition | 2020-02-24T16:18:08.691121+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8345 | 57401 | ski_trail_condition | 2020-03-23T06:57:22.601868+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8350 | 53710 | ski_trail_condition | 2020-03-23T10:30:24.232670+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8356 | 60871 | ski_trail_condition | 2020-03-25T07:49:14.730651+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 43473 | 51086 | ski_trail_condition | 2020-12-16T10:52:39.287075+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 44841 | 51028 | ski_trail_condition | 2020-12-20T07:17:07.408618+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 46081 | 57401 | ski_trail_condition | 2020-12-23T07:47:10.744808+0200 | Suljettu | Stängd | 1 | Closed | closed | 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 );