51,120 rows sorted by property

View and edit SQL

id unit property ▼ time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
6147 53524 ice_skating_field_condition 2019-11-26T10:38:59.037211+0200     Suljettu   Stängd 1 Closed closed unusable  
6148 53523 ice_skating_field_condition 2019-11-26T10:39:05.599252+0200     Suljettu   Stängd 1 Closed closed unusable  
6149 39370 ice_skating_field_condition 2019-11-26T11:34:35.053176+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6150 46144 ice_skating_field_condition 2019-11-26T13:58:47.902817+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6151 53615 ice_skating_field_condition 2019-11-26T15:42:10.754903+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6152 47279 ice_skating_field_condition 2019-11-26T16:33:25.561030+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6153 46144 ice_skating_field_condition 2019-11-26T19:31:48.784188+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6154 47279 ice_skating_field_condition 2019-11-27T07:16:49.520197+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6155 53615 ice_skating_field_condition 2019-11-27T08:19:13.418414+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6156 53563 ice_skating_field_condition 2019-11-27T08:28:38.201739+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6158 41549 ice_skating_field_condition 2019-11-27T09:03:08.881066+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6159 39834 ice_skating_field_condition 2019-11-27T09:07:01.645931+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6162 53524 ice_skating_field_condition 2019-11-27T12:33:09.121453+0200     Suljettu   Stängd 1 Closed closed unusable  
6163 53523 ice_skating_field_condition 2019-11-27T12:33:16.752238+0200     Suljettu   Stängd 1 Closed closed unusable  
6164 40493 ice_skating_field_condition 2019-11-27T13:51:02.941174+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
6165 47279 ice_skating_field_condition 2019-11-28T07:06:02.774139+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6166 53615 ice_skating_field_condition 2019-11-28T07:26:39.378359+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6167 53563 ice_skating_field_condition 2019-11-28T07:47:06.018019+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6168 42185 ice_skating_field_condition 2019-11-28T08:41:58.115490+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6169 41770 ice_skating_field_condition 2019-11-28T08:42:44.530149+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6170 39834 ice_skating_field_condition 2019-11-28T08:44:58.143862+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6172 42852 ice_skating_field_condition 2019-11-29T08:47:37.827839+0200     Suljettu   Stängd 1 Closed closed unusable  
6173 42526 ice_skating_field_condition 2019-11-29T08:47:51.729878+0200     Suljettu   Stängd 1 Closed closed unusable  
6175 42185 ice_skating_field_condition 2019-11-29T20:39:35.724042+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6176 41770 ice_skating_field_condition 2019-11-29T20:39:43.931626+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6177 47279 ice_skating_field_condition 2019-11-30T08:36:51.686804+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6178 53615 ice_skating_field_condition 2019-11-30T08:37:04.260422+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6182 40725 ice_skating_field_condition 2019-11-30T14:16:26.680528+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6188 39834 ice_skating_field_condition 2019-11-30T15:28:38.046092+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6189 39834 ice_skating_field_condition 2019-11-30T15:28:40.421511+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6190 53563 ice_skating_field_condition 2019-11-30T15:28:50.673211+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6191 42526 ice_skating_field_condition 2019-11-30T16:08:57.940097+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6192 42526 ice_skating_field_condition 2019-11-30T16:08:57.990103+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6193 42526 ice_skating_field_condition 2019-11-30T16:09:03.260912+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6194 42852 ice_skating_field_condition 2019-11-30T16:09:15.245065+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6195 47279 ice_skating_field_condition 2019-12-01T09:29:22.068204+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6196 53615 ice_skating_field_condition 2019-12-01T09:29:44.832465+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6197 42185 ice_skating_field_condition 2019-12-01T09:38:49.859244+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6198 41770 ice_skating_field_condition 2019-12-01T09:39:08.231451+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6202 53563 ice_skating_field_condition 2019-12-01T18:49:03.388511+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6203 39834 ice_skating_field_condition 2019-12-01T18:49:21.145615+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6204 40493 ice_skating_field_condition 2019-12-02T06:36:24.249080+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6207 53524 ice_skating_field_condition 2019-12-02T08:31:28.972795+0200     Suljettu   Stängd 1 Closed closed unusable  
6208 53523 ice_skating_field_condition 2019-12-02T08:31:35.919352+0200     Suljettu   Stängd 1 Closed closed unusable  
6209 53615 ice_skating_field_condition 2019-12-02T08:37:06.492448+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6210 47279 ice_skating_field_condition 2019-12-02T08:38:58.204779+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6211 39370 ice_skating_field_condition 2019-12-02T10:20:56.683189+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6213 42185 ice_skating_field_condition 2019-12-02T12:47:54.665036+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6214 41770 ice_skating_field_condition 2019-12-02T12:48:12.538048+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6215 42526 ice_skating_field_condition 2019-12-02T14:09:55.944068+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6216 47279 ice_skating_field_condition 2019-12-03T07:07:11.332542+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6217 42185 ice_skating_field_condition 2019-12-03T08:35:18.715948+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6218 41770 ice_skating_field_condition 2019-12-03T08:35:19.909809+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6219 42185 ice_skating_field_condition 2019-12-03T08:35:36.289105+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6220 51402 ice_skating_field_condition 2019-12-03T08:51:31.988258+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6221 53615 ice_skating_field_condition 2019-12-03T08:57:36.672279+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6222 51402 ice_skating_field_condition 2019-12-03T09:02:35.675224+0200     Suljettu   Stängd 1 Closed closed unusable  
6223 40402 ice_skating_field_condition 2019-12-03T09:06:01.593874+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6224 50354 ice_skating_field_condition 2019-12-03T11:31:34.403950+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6225 53523 ice_skating_field_condition 2019-12-03T11:47:43.112761+0200     Suljettu   Stängd 1 Closed closed unusable  
6226 53524 ice_skating_field_condition 2019-12-03T11:47:55.237699+0200     Suljettu   Stängd 1 Closed closed unusable  
6227 39834 ice_skating_field_condition 2019-12-03T14:37:30.361057+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6228 53563 ice_skating_field_condition 2019-12-03T16:03:48.863301+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6229 47279 ice_skating_field_condition 2019-12-04T07:08:08.678077+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6230 53615 ice_skating_field_condition 2019-12-04T07:32:47.615172+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6231 40402 ice_skating_field_condition 2019-12-04T07:34:55.655757+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6232 53523 ice_skating_field_condition 2019-12-04T08:01:05.216712+0200     Suljettu   Stängd 1 Closed closed unusable  
6233 53524 ice_skating_field_condition 2019-12-04T08:01:26.024821+0200     Suljettu   Stängd 1 Closed closed unusable  
6234 40438 ice_skating_field_condition 2019-12-04T08:02:53.902024+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6235 50354 ice_skating_field_condition 2019-12-04T08:10:05.936963+0200     Suljettu   Stängd 1 Closed closed unusable  
6238 39834 ice_skating_field_condition 2019-12-04T08:45:25.897006+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6239 53563 ice_skating_field_condition 2019-12-04T08:45:44.437487+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6242 42185 ice_skating_field_condition 2019-12-04T09:03:04.364640+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6243 41770 ice_skating_field_condition 2019-12-04T09:03:19.822177+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6244 42185 ice_skating_field_condition 2019-12-04T09:29:59.277886+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6245 41770 ice_skating_field_condition 2019-12-04T09:30:11.621193+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6246 40402 ice_skating_field_condition 2019-12-04T12:43:51.766804+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6247 39834 ice_skating_field_condition 2019-12-04T14:53:29.416610+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6248 53563 ice_skating_field_condition 2019-12-04T14:53:44.696649+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6249 53523 ice_skating_field_condition 2019-12-05T06:38:12.377001+0200     Suljettu   Stängd 1 Closed closed unusable  
6250 53524 ice_skating_field_condition 2019-12-05T06:38:35.385603+0200     Suljettu   Stängd 1 Closed closed unusable  
6255 47279 ice_skating_field_condition 2019-12-05T07:24:18.010882+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6256 53615 ice_skating_field_condition 2019-12-05T08:18:51.190959+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6257 40402 ice_skating_field_condition 2019-12-05T10:07:15.036459+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6258 41549 ice_skating_field_condition 2019-12-05T12:13:57.927416+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6262 42185 ice_skating_field_condition 2019-12-05T13:40:59.557937+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6263 41770 ice_skating_field_condition 2019-12-05T13:41:19.158236+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6264 39834 ice_skating_field_condition 2019-12-05T14:50:22.152246+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6265 53563 ice_skating_field_condition 2019-12-05T14:50:46.549796+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6266 40402 ice_skating_field_condition 2019-12-06T09:54:15.176953+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6267 46144 ice_skating_field_condition 2019-12-06T13:30:58.400233+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6268 53563 ice_skating_field_condition 2019-12-06T16:18:19.963065+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6269 39834 ice_skating_field_condition 2019-12-06T16:19:13.675861+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6270 47279 ice_skating_field_condition 2019-12-07T08:40:27.709421+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6271 42185 ice_skating_field_condition 2019-12-07T08:44:57.287150+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6272 41770 ice_skating_field_condition 2019-12-07T08:45:16.186406+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6273 53563 ice_skating_field_condition 2019-12-07T08:56:27.759255+0200     Suljettu   Stängd 1 Closed closed unusable  
6274 39834 ice_skating_field_condition 2019-12-07T08:56:37.772720+0200     Suljettu   Stängd 1 Closed closed unusable  
6276 53615 ice_skating_field_condition 2019-12-07T09:45:36.715951+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6277 53615 ice_skating_field_condition 2019-12-07T09:45:43.825119+0200     Aurattu   Plogad 1 Cleared of snow plowed 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
);