20 rows where name_fi = "Hyvä" and unit = 57401

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
6581 57401 ski_trail_condition 2019-12-29T11:19:37.341758+0200     Hyvä   Bra 1 Good condition good good  
6585 57401 ski_trail_condition 2019-12-30T07:13:10.054466+0200     Hyvä   Bra 1 Good condition good good  
6607 57401 ski_trail_condition 2019-12-31T11:28:09.621779+0200     Hyvä   Bra 1 Good condition good good  
6766 57401 ski_trail_condition 2020-01-11T12:21:06.555406+0200     Hyvä   Bra 1 Good condition good good  
7328 57401 ski_trail_condition 2020-02-06T08:00:16.857249+0200     Hyvä   Bra 1 Good condition good good  
7354 57401 ski_trail_condition 2020-02-06T13:58:35.149930+0200     Hyvä   Bra 1 Good condition good good  
7373 57401 ski_trail_condition 2020-02-07T05:49:26.323084+0200     Hyvä   Bra 1 Good condition good good  
7423 57401 ski_trail_condition 2020-02-07T18:58:45.551149+0200     Hyvä   Bra 1 Good condition good good  
7444 57401 ski_trail_condition 2020-02-08T09:55:15.643443+0200     Hyvä   Bra 1 Good condition good good  
7478 57401 ski_trail_condition 2020-02-09T08:14:29.411644+0200     Hyvä   Bra 1 Good condition good good  
7582 57401 ski_trail_condition 2020-02-12T07:50:36.634179+0200     Hyvä   Bra 1 Good condition good good  
7610 57401 ski_trail_condition 2020-02-13T08:16:01.120662+0200     Hyvä   Bra 1 Good condition good good  
7954 57401 ski_trail_condition 2020-02-29T07:17:20.026242+0200     Hyvä   Bra 1 Good condition good good  
7967 57401 ski_trail_condition 2020-02-29T13:43:59.514229+0200     Hyvä   Bra 1 Good condition good good  
7975 57401 ski_trail_condition 2020-02-29T15:04:04.897212+0200     Hyvä   Bra 1 Good condition good good  
8010 57401 ski_trail_condition 2020-03-02T09:19:20.582421+0200     Hyvä   Bra 1 Good condition good good  
8035 57401 ski_trail_condition 2020-03-03T07:47:51.051472+0200     Hyvä   Bra 1 Good condition good good  
8041 57401 ski_trail_condition 2020-03-03T09:10:10.738725+0200     Hyvä   Bra 1 Good condition good good  
8043 57401 ski_trail_condition 2020-03-03T12:24:11.435003+0200     Hyvä   Bra 1 Good condition good good  
8112 57401 ski_trail_condition 2020-03-07T00:40:29.937266+0200     Hyvä   Bra 1 Good condition good 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
);