observation
2 rows where name_sv = "Grunden lagd (inget skidspår)"
This data as json, CSV (advanced)
| id ▼ | unit | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 43351 | 57401 | ski_trail_condition | 2020-12-16T02:58:58.706463+0200 | Latu pohjattu (ei latu-uraa) | Grunden lagd (inget skidspår) | 1 | Foundation laid (no skiing trail) | groomed | satisfactory | ||||
| 44128 | 57401 | ski_trail_condition | 2020-12-18T10:10:18.986324+0200 | Latu pohjattu (ei latu-uraa) | Grunden lagd (inget skidspår) | 1 | Foundation laid (no skiing trail) | groomed | satisfactory |
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 );