2 rows where name_sv = "Grunden lagd (inget skidspår)"

View and edit SQL

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

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
);