observation
54 rows where name_sv = "Snöbrist"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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
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 );