observation
7,945 rows where primary = 1 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: property, name_fi, name_sv, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51161 | 47279 | ice_skating_field_condition | 2021-01-04T21:57:34.403708+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51160 | 53615 | ice_skating_field_condition | 2021-01-04T21:56:39.719521+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 51140 | 63148 | ice_skating_field_condition | 2021-01-04T20:39:45.794307+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51136 | 46144 | ice_skating_field_condition | 2021-01-04T20:10:52.483239+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51120 | 40493 | ice_skating_field_condition | 2021-01-04T19:36:32.901669+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51112 | 51027 | ski_trail_condition | 2021-01-04T19:09:22.296673+0200 | Lumenpuute | Snöbrist | 1 | Lack of snow | snowless | unusable | ||||
| 51084 | 42185 | ice_skating_field_condition | 2021-01-04T17:48:00.697438+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51082 | 41770 | ice_skating_field_condition | 2021-01-04T17:47:24.147192+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51072 | 47279 | ice_skating_field_condition | 2021-01-04T17:15:22.662801+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51071 | 53615 | ice_skating_field_condition | 2021-01-04T17:14:29.700935+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 51057 | 46144 | ice_skating_field_condition | 2021-01-04T16:38:22.468391+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51043 | 40493 | ice_skating_field_condition | 2021-01-04T15:49:13.821722+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51040 | 63148 | ice_skating_field_condition | 2021-01-04T15:37:36.236905+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51039 | 63148 | ice_skating_field_condition | 2021-01-04T15:37:14.866885+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51038 | 63148 | ice_skating_field_condition | 2021-01-04T15:37:13.975225+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51035 | 47279 | ice_skating_field_condition | 2021-01-04T15:25:33.491015+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 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 | ||||
| 50935 | 50265 | ice_skating_field_condition | 2021-01-04T13:16:06.429717+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 50934 | 39269 | ice_skating_field_condition | 2021-01-04T13:15:53.672873+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 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 |
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 );