observation
51,120 rows sorted by value descending
This data as json, CSV (advanced)
Suggested facets: name_fi, name_sv, primary, name_en, value, quality
| 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 | ||||
| 53 | 50401 | season_status | 2019-06-03T15:14:54.977849+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good | ||||
| 1406 | 40823 | season_status | 2019-06-24T11:00:36.870285+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good | ||||
| 9107 | 62213 | season_status | 2020-06-11T10:38:11.281508+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good | ||||
| 9118 | 62213 | season_status | 2020-06-11T14:35:59.683244+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good | ||||
| 9853 | 62213 | season_status | 2020-06-22T10:24:04.934477+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 | ||||
| 10236 | 40823 | season_status | 2020-06-26T11:30:20.418561+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good | ||||
| 10997 | 48917 | season_status | 2020-07-07T10:21:01.054366+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good | ||||
| 13894 | 62213 | season_status | 2020-08-18T08:22:23.635629+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good | ||||
| 6009 | 53710 | ski_trail_condition | 2019-11-07T05:43:34.175106+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 6044 | 53710 | ski_trail_condition | 2019-11-15T07:30:50.342752+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 6179 | 53710 | ski_trail_condition | 2019-11-30T11:24:00.805300+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 6328 | 51028 | ski_trail_condition | 2019-12-10T17:34:12.368332+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 6329 | 51028 | ski_trail_condition | 2019-12-11T07:38:18.388923+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 6331 | 60871 | ski_trail_condition | 2019-12-11T07:56:14.603825+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 6543 | 57401 | ski_trail_condition | 2019-12-27T15:36:07.959938+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 6685 | 60871 | ski_trail_condition | 2020-01-05T16:58:55.453285+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 6754 | 57401 | ski_trail_condition | 2020-01-10T18:42:11.515604+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 7236 | 57401 | ski_trail_condition | 2020-02-04T08:00:23.822392+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 7304 | 57401 | ski_trail_condition | 2020-02-05T09:39:50.424854+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 7858 | 57401 | ski_trail_condition | 2020-02-25T08:17:27.313912+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 8221 | 57401 | ski_trail_condition | 2020-03-14T07:03:20.820194+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 8236 | 57401 | ski_trail_condition | 2020-03-14T23:21:39.024036+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 50957 | 57401 | ski_trail_condition | 2021-01-04T14:34:00.447647+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 50958 | 57401 | ski_trail_condition | 2021-01-04T14:34:03.949313+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 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 | ||||
| 6063 | 53710 | ski_trail_condition | 2019-11-18T15:29:15.961698+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6321 | 53710 | ski_trail_condition | 2019-12-10T11:54:29.446483+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6324 | 53710 | ski_trail_condition | 2019-12-10T13:53:03.961596+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6548 | 60871 | ski_trail_condition | 2019-12-28T06:39:35.545330+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6612 | 57401 | ski_trail_condition | 2020-01-01T07:44:18.918301+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6616 | 57401 | ski_trail_condition | 2020-01-02T07:13:32.980528+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6634 | 57401 | ski_trail_condition | 2020-01-03T06:51:07.389426+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6652 | 57401 | ski_trail_condition | 2020-01-03T22:18:01.255784+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6654 | 60871 | ski_trail_condition | 2020-01-04T07:42:49.854593+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6680 | 57401 | ski_trail_condition | 2020-01-05T09:21:07.649472+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6687 | 57401 | ski_trail_condition | 2020-01-06T06:07:14.197337+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6702 | 57401 | ski_trail_condition | 2020-01-07T07:38:14.369933+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6721 | 57401 | ski_trail_condition | 2020-01-08T09:04:22.736449+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6777 | 57401 | ski_trail_condition | 2020-01-12T08:19:17.928143+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6806 | 57401 | ski_trail_condition | 2020-01-13T08:52:44.529606+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6812 | 57401 | ski_trail_condition | 2020-01-13T13:43:32.263283+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6819 | 57401 | ski_trail_condition | 2020-01-14T08:01:43.100199+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6829 | 57401 | ski_trail_condition | 2020-01-14T13:13:58.104888+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6856 | 57401 | ski_trail_condition | 2020-01-16T07:55:35.906710+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 6861 | 57401 | ski_trail_condition | 2020-01-16T10:45:40.686359+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory |
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 );