observation

1,026 rows where quality = "unusable" sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: property, name_fi, name_sv, name_en

quality ✖

  • unusable · 1,026 ✖
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  

Next page

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