observation

4,944 rows where quality = "good" sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: property, name_fi, name_sv, name_en, value

quality ✖

  • good · 4,944 ✖
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  

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