observation
1,026 rows where quality = "unusable" sorted by id descending
This data as json, CSV (advanced)
Suggested facets: property, name_fi, name_sv, name_en, value
id ▲ | unit | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
51112 | 51027 | ski_trail_condition | 2021-01-04T19:09:22.296673+0200 | Lumenpuute | Snöbrist | 1 | Lack of snow | snowless | unusable | ||||
51031 | 50265 | ice_skating_field_condition | 2021-01-04T15:14:15.618823+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
51030 | 39269 | ice_skating_field_condition | 2021-01-04T15:13:26.045585+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
51023 | 42672 | ice_skating_field_condition | 2021-01-04T15:00:41.465811+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
51020 | 42562 | ice_skating_field_condition | 2021-01-04T14:56:55.478182+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
51019 | 53095 | ice_skating_field_condition | 2021-01-04T14:56:16.662837+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
51018 | 46192 | ice_skating_field_condition | 2021-01-04T14:55:41.835163+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
51017 | 42580 | ice_skating_field_condition | 2021-01-04T14:54:51.799457+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
51016 | 53985 | ski_trail_condition | 2021-01-04T14:54:04.231259+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 | ||||
51014 | 54002 | ski_trail_condition | 2021-01-04T14:53:43.857194+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 | ||||
51012 | 54009 | ski_trail_condition | 2021-01-04T14:53:17.596112+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 | ||||
51010 | 53867 | ski_trail_condition | 2021-01-04T14:53:00.119822+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 | ||||
51008 | 54429 | ski_trail_condition | 2021-01-04T14:52:38.853550+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 | ||||
51006 | 53987 | ski_trail_condition | 2021-01-04T14:52:20.237052+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 | ||||
51004 | 53916 | ski_trail_condition | 2021-01-04T14:52:08.106885+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 | ||||
51002 | 54007 | ski_trail_condition | 2021-01-04T14:51:42.092474+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 | ||||
51000 | 54422 | ski_trail_condition | 2021-01-04T14:51:30.228840+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 | ||||
50998 | 54005 | ski_trail_condition | 2021-01-04T14:51:17.456305+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 | ||||
50996 | 54422 | ski_trail_condition | 2021-01-04T14:51:14.835828+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 | ||||
50993 | 54411 | ski_trail_condition | 2021-01-04T14:49:50.423708+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 | ||||
50991 | 53989 | ski_trail_condition | 2021-01-04T14:49:29.724999+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 | ||||
50989 | 56076 | ski_trail_condition | 2021-01-04T14:49:20.568691+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 | ||||
50987 | 54421 | ski_trail_condition | 2021-01-04T14:48:55.953820+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 | ||||
50985 | 54419 | ski_trail_condition | 2021-01-04T14:48:26.140649+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 | ||||
50983 | 53978 | ski_trail_condition | 2021-01-04T14:47:52.323610+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 | ||||
50981 | 53979 | ski_trail_condition | 2021-01-04T14:47:27.319271+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 | ||||
50979 | 53974 | ski_trail_condition | 2021-01-04T14:47:02.778233+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 | ||||
50977 | 54425 | ski_trail_condition | 2021-01-04T14:46:37.795169+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 | ||||
50975 | 53965 | ski_trail_condition | 2021-01-04T14:46:23.057837+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 | ||||
50973 | 56073 | ski_trail_condition | 2021-01-04T14:45:52.322167+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 | ||||
50971 | 54338 | ski_trail_condition | 2021-01-04T14:45:41.911663+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 | ||||
50969 | 53836 | ski_trail_condition | 2021-01-04T14:43:59.446018+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 | ||||
50967 | 54039 | ski_trail_condition | 2021-01-04T14:43:20.288124+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 | ||||
50965 | 53848 | ski_trail_condition | 2021-01-04T14:43:06.276472+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 | ||||
50960 | 54335 | ski_trail_condition | 2021-01-04T14:34:56.015492+0200 | Lumenpuute | Snöbrist | 1 | Lack of snow | snowless | unusable | ||||
50958 | 57401 | ski_trail_condition | 2021-01-04T14:34:03.949313+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 | ||||
50937 | 39903 | ice_skating_field_condition | 2021-01-04T13:25:02.327344+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50933 | 42069 | ice_skating_field_condition | 2021-01-04T13:11:35.470065+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50928 | 42175 | ice_skating_field_condition | 2021-01-04T13:09:52.023140+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50927 | 42110 | ice_skating_field_condition | 2021-01-04T13:09:23.939446+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50926 | 42110 | ice_skating_field_condition | 2021-01-04T13:09:15.255958+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50925 | 40154 | ice_skating_field_condition | 2021-01-04T13:08:53.663175+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50924 | 40350 | ice_skating_field_condition | 2021-01-04T13:08:27.448711+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50923 | 39969 | ice_skating_field_condition | 2021-01-04T13:07:45.697883+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50922 | 40172 | ice_skating_field_condition | 2021-01-04T13:06:41.859849+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50921 | 41734 | ice_skating_field_condition | 2021-01-04T13:05:55.526403+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50920 | 40010 | ice_skating_field_condition | 2021-01-04T13:04:47.790620+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50903 | 50265 | ice_skating_field_condition | 2021-01-04T12:26:05.520577+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
50902 | 39654 | ice_skating_field_condition | 2021-01-04T12:25:30.385154+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
50901 | 39398 | ice_skating_field_condition | 2021-01-04T12:24:55.518697+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
50900 | 39401 | ice_skating_field_condition | 2021-01-04T12:24:17.076045+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
50899 | 39269 | ice_skating_field_condition | 2021-01-04T12:23:50.719939+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
50898 | 39315 | ice_skating_field_condition | 2021-01-04T12:23:17.118693+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
50897 | 39296 | ice_skating_field_condition | 2021-01-04T12:22:52.718150+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
50896 | 39385 | ice_skating_field_condition | 2021-01-04T12:22:31.801698+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
50895 | 50518 | ice_skating_field_condition | 2021-01-04T12:22:08.022311+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
50894 | 39710 | ice_skating_field_condition | 2021-01-04T12:21:12.583086+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
50893 | 39604 | ice_skating_field_condition | 2021-01-04T12:20:48.019048+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
50890 | 39780 | ice_skating_field_condition | 2021-01-04T12:20:01.032534+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
50889 | 39498 | ice_skating_field_condition | 2021-01-04T12:19:23.273010+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
50888 | 50522 | ice_skating_field_condition | 2021-01-04T12:18:57.422985+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
50887 | 50515 | ice_skating_field_condition | 2021-01-04T12:18:41.931507+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
50836 | 41096 | ice_skating_field_condition | 2021-01-04T09:41:01.358685+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50804 | 50354 | ice_skating_field_condition | 2021-01-04T07:54:04.595592+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50405 | 40421 | ice_skating_field_condition | 2021-01-03T08:33:48.108169+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
50368 | 46144 | ice_skating_field_condition | 2021-01-03T06:15:26.387596+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
49340 | 40421 | ice_skating_field_condition | 2020-12-31T15:00:20.876900+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
49304 | 56438 | ice_skating_field_condition | 2020-12-31T13:27:38.531275+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
49223 | 41608 | ice_skating_field_condition | 2020-12-31T10:17:20.650223+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
48892 | 42699 | ice_skating_field_condition | 2020-12-30T14:07:19.906881+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
48803 | 40421 | ice_skating_field_condition | 2020-12-30T09:39:31.928981+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
48760 | 63147 | ice_skating_field_condition | 2020-12-30T07:02:43.816689+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
48542 | 41770 | ice_skating_field_condition | 2020-12-29T16:26:36.480465+0200 | Suljettu | Stängd | 1 | Closed | closed | 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 );