observation
4,944 rows where quality = "good" sorted by id descending
This data as json, CSV (advanced)
Suggested facets: name_en
name_sv ✖
- Inga blågröna alger 2,809
- Isad 1,452
- Plogad 526
- Bra 147
- Säsongen igång 10
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 | ||||
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 | ||||
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 | ||||
50853 | 39498 | ice_skating_field_condition | 2021-01-04T10:36:55.339893+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50843 | 40493 | ice_skating_field_condition | 2021-01-04T10:09:38.311784+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
50814 | 40421 | ice_skating_field_condition | 2021-01-04T08:33:23.302497+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50812 | 50522 | ice_skating_field_condition | 2021-01-04T08:29:30.610446+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50811 | 42249 | ice_skating_field_condition | 2021-01-04T08:25:29.165792+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
50801 | 41770 | ice_skating_field_condition | 2021-01-04T07:50:02.902094+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
50800 | 42185 | ice_skating_field_condition | 2021-01-04T07:49:44.789500+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
50799 | 39604 | ice_skating_field_condition | 2021-01-04T07:41:49.161325+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50796 | 39834 | ice_skating_field_condition | 2021-01-04T07:35:17.129029+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
50795 | 53563 | ice_skating_field_condition | 2021-01-04T07:34:39.921956+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
50673 | 53615 | ice_skating_field_condition | 2021-01-03T21:52:01.252674+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50597 | 47849 | ice_skating_field_condition | 2021-01-03T17:51:58.987327+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50583 | 42249 | ice_skating_field_condition | 2021-01-03T17:13:37.230197+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
50554 | 40421 | ice_skating_field_condition | 2021-01-03T15:49:14.887724+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50550 | 53710 | ski_trail_condition | 2021-01-03T15:23:05.174367+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
50535 | 39370 | ice_skating_field_condition | 2021-01-03T14:41:47.515737+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50534 | 39604 | ice_skating_field_condition | 2021-01-03T14:40:40.730513+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50502 | 40493 | ice_skating_field_condition | 2021-01-03T13:20:32.890468+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50499 | 39710 | ice_skating_field_condition | 2021-01-03T13:17:39.975338+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50483 | 40493 | ice_skating_field_condition | 2021-01-03T12:29:17.311470+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50469 | 63148 | ice_skating_field_condition | 2021-01-03T11:51:58.445877+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50467 | 39398 | ice_skating_field_condition | 2021-01-03T11:44:23.405663+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50465 | 39654 | ice_skating_field_condition | 2021-01-03T11:43:33.539915+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50450 | 46144 | ice_skating_field_condition | 2021-01-03T10:55:05.242835+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50446 | 40493 | ice_skating_field_condition | 2021-01-03T10:50:25.859806+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50440 | 42249 | ice_skating_field_condition | 2021-01-03T10:38:17.675431+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
50439 | 42249 | ice_skating_field_condition | 2021-01-03T10:38:05.705272+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50413 | 39780 | ice_skating_field_condition | 2021-01-03T09:02:49.801111+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50406 | 40493 | ice_skating_field_condition | 2021-01-03T08:39:45.203053+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50403 | 39370 | ice_skating_field_condition | 2021-01-03T08:26:28.057241+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50396 | 63148 | ice_skating_field_condition | 2021-01-03T07:57:39.585831+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50395 | 47279 | ice_skating_field_condition | 2021-01-03T07:50:18.786508+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50392 | 53615 | ice_skating_field_condition | 2021-01-03T07:50:00.506457+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50381 | 53710 | ski_trail_condition | 2021-01-03T07:08:36.692071+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
50222 | 40493 | ice_skating_field_condition | 2021-01-02T19:14:01.360460+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50213 | 41770 | ice_skating_field_condition | 2021-01-02T18:56:50.112833+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50211 | 42185 | ice_skating_field_condition | 2021-01-02T18:56:29.417401+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50155 | 40421 | ice_skating_field_condition | 2021-01-02T16:04:32.786529+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50153 | 39370 | ice_skating_field_condition | 2021-01-02T16:00:18.836318+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50121 | 50515 | ice_skating_field_condition | 2021-01-02T14:10:07.838409+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50117 | 39296 | ice_skating_field_condition | 2021-01-02T14:09:21.163492+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50116 | 39385 | ice_skating_field_condition | 2021-01-02T14:08:15.782544+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50115 | 50265 | ice_skating_field_condition | 2021-01-02T14:07:26.392533+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50114 | 39398 | ice_skating_field_condition | 2021-01-02T14:05:21.784611+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50113 | 39401 | ice_skating_field_condition | 2021-01-02T14:04:52.717175+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50112 | 39269 | ice_skating_field_condition | 2021-01-02T14:04:11.634280+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50111 | 39315 | ice_skating_field_condition | 2021-01-02T14:03:31.347039+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50109 | 39710 | ice_skating_field_condition | 2021-01-02T14:02:25.181872+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50108 | 39604 | ice_skating_field_condition | 2021-01-02T14:01:56.584990+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50106 | 39780 | ice_skating_field_condition | 2021-01-02T14:01:04.787142+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50104 | 39498 | ice_skating_field_condition | 2021-01-02T14:00:32.977245+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50100 | 50522 | ice_skating_field_condition | 2021-01-02T13:59:51.226091+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
50069 | 63148 | ice_skating_field_condition | 2021-01-02T12:26:49.327928+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
50024 | 61464 | ice_skating_field_condition | 2021-01-02T10:11:25.208516+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
50016 | 42249 | ice_skating_field_condition | 2021-01-02T10:00:06.511791+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
49988 | 40493 | ice_skating_field_condition | 2021-01-02T08:42:02.133172+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
49984 | 39370 | ice_skating_field_condition | 2021-01-02T08:33:48.816201+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
49975 | 53615 | ice_skating_field_condition | 2021-01-02T08:01:32.908182+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
49974 | 53615 | ice_skating_field_condition | 2021-01-02T08:01:14.870146+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
49973 | 47279 | ice_skating_field_condition | 2021-01-02T08:01:03.648651+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
49972 | 47279 | ice_skating_field_condition | 2021-01-02T08:00:57.376635+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
49965 | 63148 | ice_skating_field_condition | 2021-01-02T07:31:23.626857+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
49957 | 60871 | ski_trail_condition | 2021-01-02T07:07:06.440744+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
49880 | 53710 | ski_trail_condition | 2021-01-02T00:34:59.827964+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
49749 | 39370 | ice_skating_field_condition | 2021-01-01T16:41:06.870108+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
49730 | 40421 | ice_skating_field_condition | 2021-01-01T15:36:40.196064+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
49686 | 53524 | ice_skating_field_condition | 2021-01-01T13:14:28.278871+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
49685 | 53523 | ice_skating_field_condition | 2021-01-01T13:14:20.885097+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
49662 | 53615 | ice_skating_field_condition | 2021-01-01T12:04:55.807273+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
49646 | 42699 | ice_skating_field_condition | 2021-01-01T11:21:23.839080+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
49642 | 47279 | ice_skating_field_condition | 2021-01-01T11:11:37.944182+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
49625 | 63147 | ice_skating_field_condition | 2021-01-01T10:36:55.767287+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
49604 | 39370 | ice_skating_field_condition | 2021-01-01T09:52:36.166153+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
49591 | 41770 | ice_skating_field_condition | 2021-01-01T09:16:51.869280+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
49590 | 42185 | ice_skating_field_condition | 2021-01-01T09:16:41.104564+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
49589 | 42185 | ice_skating_field_condition | 2021-01-01T09:16:32.474175+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
49588 | 42185 | ice_skating_field_condition | 2021-01-01T09:16:25.012566+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
49587 | 41770 | ice_skating_field_condition | 2021-01-01T09:15:56.086948+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
49586 | 41770 | ice_skating_field_condition | 2021-01-01T09:15:50.628938+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
49578 | 42249 | ice_skating_field_condition | 2021-01-01T08:52:12.058302+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
49577 | 42249 | ice_skating_field_condition | 2021-01-01T08:52:09.343198+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
49573 | 40493 | ice_skating_field_condition | 2021-01-01T08:46:45.291733+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
49564 | 42185 | ice_skating_field_condition | 2021-01-01T08:07:02.560166+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good |
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 );