2 rows where name_sv = "Säsongen igång", primary = 1 and unit = 41047

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
52 41047 season_status 2019-06-03T15:14:36.432563+0300     Kausi käynnissä   Säsongen igång 1 Season underway started good  
10235 41047 season_status 2020-06-26T11:29:54.733944+0300     Kausi käynnissä   Säsongen igång 1 Season underway started good  

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