observation

54 rows where name_sv = "Snöbrist"

✎ View and edit SQL

This data as json, CSV (advanced)

primary ✖

  • 1 54

name_sv ✖

  • Snöbrist · 54 ✖
id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
50960 54335 ski_trail_condition 2021-01-04T14:34:56.015492+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50961 51027 ski_trail_condition 2021-01-04T14:36:44.599207+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50965 53848 ski_trail_condition 2021-01-04T14:43:06.276472+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50966 54047 ski_trail_condition 2021-01-04T14:43:16.810816+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50967 54039 ski_trail_condition 2021-01-04T14:43:20.288124+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50968 54339 ski_trail_condition 2021-01-04T14:43:57.629744+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50969 53836 ski_trail_condition 2021-01-04T14:43:59.446018+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50970 54038 ski_trail_condition 2021-01-04T14:45:19.517881+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50971 54338 ski_trail_condition 2021-01-04T14:45:41.911663+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50972 54048 ski_trail_condition 2021-01-04T14:45:44.327526+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50973 56073 ski_trail_condition 2021-01-04T14:45:52.322167+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50974 56073 ski_trail_condition 2021-01-04T14:46:09.214924+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50975 53965 ski_trail_condition 2021-01-04T14:46:23.057837+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50976 53965 ski_trail_condition 2021-01-04T14:46:31.646547+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50977 54425 ski_trail_condition 2021-01-04T14:46:37.795169+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50978 53974 ski_trail_condition 2021-01-04T14:46:53.284804+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50979 53974 ski_trail_condition 2021-01-04T14:47:02.778233+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50980 53975 ski_trail_condition 2021-01-04T14:47:09.055552+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50981 53979 ski_trail_condition 2021-01-04T14:47:27.319271+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50982 54430 ski_trail_condition 2021-01-04T14:47:41.171183+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50983 53978 ski_trail_condition 2021-01-04T14:47:52.323610+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50984 54424 ski_trail_condition 2021-01-04T14:48:06.703494+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50985 54419 ski_trail_condition 2021-01-04T14:48:26.140649+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50986 54423 ski_trail_condition 2021-01-04T14:48:40.455129+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50987 54421 ski_trail_condition 2021-01-04T14:48:55.953820+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50988 53850 ski_trail_condition 2021-01-04T14:49:05.672860+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50989 56076 ski_trail_condition 2021-01-04T14:49:20.568691+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50990 56076 ski_trail_condition 2021-01-04T14:49:24.388646+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50991 53989 ski_trail_condition 2021-01-04T14:49:29.724999+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50992 53989 ski_trail_condition 2021-01-04T14:49:32.745566+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50993 54411 ski_trail_condition 2021-01-04T14:49:50.423708+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50995 53994 ski_trail_condition 2021-01-04T14:50:18.997488+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50996 54422 ski_trail_condition 2021-01-04T14:51:14.835828+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50997 54010 ski_trail_condition 2021-01-04T14:51:15.716497+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50998 54005 ski_trail_condition 2021-01-04T14:51:17.456305+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
50999 54007 ski_trail_condition 2021-01-04T14:51:29.569064+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
51000 54422 ski_trail_condition 2021-01-04T14:51:30.228840+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
51001 54007 ski_trail_condition 2021-01-04T14:51:30.349763+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
51002 54007 ski_trail_condition 2021-01-04T14:51:42.092474+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
51003 54004 ski_trail_condition 2021-01-04T14:51:52.886263+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
51004 53916 ski_trail_condition 2021-01-04T14:52:08.106885+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
51005 53916 ski_trail_condition 2021-01-04T14:52:08.546026+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
51006 53987 ski_trail_condition 2021-01-04T14:52:20.237052+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
51007 56077 ski_trail_condition 2021-01-04T14:52:30.628271+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
51008 54429 ski_trail_condition 2021-01-04T14:52:38.853550+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
51009 53984 ski_trail_condition 2021-01-04T14:52:51.476691+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
51010 53867 ski_trail_condition 2021-01-04T14:53:00.119822+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
51011 54013 ski_trail_condition 2021-01-04T14:53:08.057325+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
51012 54009 ski_trail_condition 2021-01-04T14:53:17.596112+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
51013 54011 ski_trail_condition 2021-01-04T14:53:31.623027+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
51014 54002 ski_trail_condition 2021-01-04T14:53:43.857194+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
51015 53919 ski_trail_condition 2021-01-04T14:53:51.142907+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
51016 53985 ski_trail_condition 2021-01-04T14:54:04.231259+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  
51112 51027 ski_trail_condition 2021-01-04T19:09:22.296673+0200     Lumenpuute   Snöbrist 1 Lack of snow snowless unusable  

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