observation
526 rows where value = "plowed" sorted by unit
This data as json, CSV (advanced)
| id | unit ▼ | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7993 | 40421 | ice_skating_field_condition | 2020-03-01T10:11:11.746497+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 8012 | 40421 | ice_skating_field_condition | 2020-03-02T09:28:43.259514+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 8039 | 40421 | ice_skating_field_condition | 2020-03-03T08:53:52.697861+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 8054 | 40421 | ice_skating_field_condition | 2020-03-04T09:51:16.685194+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 8075 | 40421 | ice_skating_field_condition | 2020-03-05T09:05:30.628893+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 8089 | 40421 | ice_skating_field_condition | 2020-03-06T08:38:31.184543+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 40548 | 40421 | ice_skating_field_condition | 2020-12-07T11:06:04.593444+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 40549 | 40421 | ice_skating_field_condition | 2020-12-07T11:06:12.551078+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 43767 | 40421 | ice_skating_field_condition | 2020-12-17T08:33:11.500465+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 46124 | 40421 | ice_skating_field_condition | 2020-12-23T10:03:34.303346+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 48378 | 40421 | ice_skating_field_condition | 2020-12-29T08:28:09.444452+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 49194 | 40421 | ice_skating_field_condition | 2020-12-31T09:10:58.784530+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 49730 | 40421 | ice_skating_field_condition | 2021-01-01T15:36:40.196064+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 | ||||
| 50554 | 40421 | ice_skating_field_condition | 2021-01-03T15:49:14.887724+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 50814 | 40421 | ice_skating_field_condition | 2021-01-04T08:33:23.302497+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6234 | 40438 | ice_skating_field_condition | 2019-12-04T08:02:53.902024+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 7430 | 40455 | ice_skating_field_condition | 2020-02-08T07:48:51.324598+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 7432 | 40455 | ice_skating_field_condition | 2020-02-08T07:49:03.405727+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6401 | 40493 | ice_skating_field_condition | 2019-12-15T11:50:06.338212+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 46137 | 40493 | ice_skating_field_condition | 2020-12-23T10:22:09.159264+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 47999 | 40493 | ice_skating_field_condition | 2020-12-28T10:18:41.189772+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 48372 | 40493 | ice_skating_field_condition | 2020-12-29T08:03:39.715570+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 48779 | 40493 | ice_skating_field_condition | 2020-12-30T08:12:03.252495+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 48930 | 40493 | ice_skating_field_condition | 2020-12-30T15:53:20.880025+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 49164 | 40493 | ice_skating_field_condition | 2020-12-31T07:48:33.075406+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 49285 | 40493 | ice_skating_field_condition | 2020-12-31T12:51:16.450478+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 | ||||
| 50222 | 40493 | ice_skating_field_condition | 2021-01-02T19:14:01.360460+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 | ||||
| 50446 | 40493 | ice_skating_field_condition | 2021-01-03T10:50:25.859806+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 | ||||
| 50502 | 40493 | ice_skating_field_condition | 2021-01-03T13:20:32.890468+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 7489 | 40725 | ice_skating_field_condition | 2020-02-09T10:54:06.398555+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 7454 | 40934 | ice_skating_field_condition | 2020-02-08T13:12:26.224648+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 7462 | 40934 | ice_skating_field_condition | 2020-02-08T17:59:49.123909+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 7453 | 41096 | ice_skating_field_condition | 2020-02-08T12:39:09.505436+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 46127 | 41549 | ice_skating_field_condition | 2020-12-23T10:06:12.068045+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 47677 | 41549 | ice_skating_field_condition | 2020-12-27T14:33:19.562478+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 49222 | 41608 | ice_skating_field_condition | 2020-12-31T10:17:13.524716+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 | ||||
| 6287 | 41770 | ice_skating_field_condition | 2019-12-07T17:06:34.713219+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6311 | 41770 | ice_skating_field_condition | 2019-12-09T18:48:51.180019+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6318 | 41770 | ice_skating_field_condition | 2019-12-10T09:03:19.546316+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6532 | 41770 | ice_skating_field_condition | 2019-12-27T08:14:38.262025+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6589 | 41770 | ice_skating_field_condition | 2019-12-30T10:56:43.457255+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6614 | 41770 | ice_skating_field_condition | 2020-01-01T12:16:17.186336+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6628 | 41770 | ice_skating_field_condition | 2020-01-02T09:17:13.530853+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6688 | 41770 | ice_skating_field_condition | 2020-01-06T08:23:02.858368+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6785 | 41770 | ice_skating_field_condition | 2020-01-12T09:32:57.615187+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6887 | 41770 | ice_skating_field_condition | 2020-01-17T12:34:38.574441+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6930 | 41770 | ice_skating_field_condition | 2020-01-19T09:47:47.352804+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 7093 | 41770 | ice_skating_field_condition | 2020-01-27T08:14:48.474896+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 7139 | 41770 | ice_skating_field_condition | 2020-01-29T18:59:18.454413+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 7203 | 41770 | ice_skating_field_condition | 2020-02-02T08:11:15.416832+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 7505 | 41770 | ice_skating_field_condition | 2020-02-09T18:51:48.941454+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 7506 | 41770 | ice_skating_field_condition | 2020-02-09T18:52:31.033722+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 7511 | 41770 | ice_skating_field_condition | 2020-02-10T07:18:20.586407+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 7578 | 41770 | ice_skating_field_condition | 2020-02-11T17:17:02.201271+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 7585 | 41770 | ice_skating_field_condition | 2020-02-12T08:20:44.252055+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 7631 | 41770 | ice_skating_field_condition | 2020-02-14T08:58:59.432549+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 7767 | 41770 | ice_skating_field_condition | 2020-02-19T17:08:11.520469+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 7785 | 41770 | ice_skating_field_condition | 2020-02-20T08:54:28.405653+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 7791 | 41770 | ice_skating_field_condition | 2020-02-20T17:39:29.136893+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 7820 | 41770 | ice_skating_field_condition | 2020-02-22T11:21:08.642754+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 7989 | 41770 | ice_skating_field_condition | 2020-03-01T09:25:24.597533+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 7990 | 41770 | ice_skating_field_condition | 2020-03-01T09:25:38.592085+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 8159 | 41770 | ice_skating_field_condition | 2020-03-09T13:59:41.607623+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 8160 | 41770 | ice_skating_field_condition | 2020-03-09T13:59:48.644568+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 8206 | 41770 | ice_skating_field_condition | 2020-03-12T17:19:35.957808+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 8220 | 41770 | ice_skating_field_condition | 2020-03-13T17:23:34.094671+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 39606 | 41770 | ice_skating_field_condition | 2020-12-04T11:36:33.676699+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 43082 | 41770 | ice_skating_field_condition | 2020-12-15T07:59:33.509067+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 43083 | 41770 | ice_skating_field_condition | 2020-12-15T07:59:44.548921+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 43499 | 41770 | ice_skating_field_condition | 2020-12-16T12:45:57.789307+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 44109 | 41770 | ice_skating_field_condition | 2020-12-18T09:07:29.660992+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 44223 | 41770 | ice_skating_field_condition | 2020-12-18T16:45:24.192592+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 44308 | 41770 | ice_skating_field_condition | 2020-12-18T22:53:52.615015+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 44462 | 41770 | ice_skating_field_condition | 2020-12-19T09:19:03.899786+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 46096 | 41770 | ice_skating_field_condition | 2020-12-23T08:42:53.077392+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 46129 | 41770 | ice_skating_field_condition | 2020-12-23T10:09:47.118072+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 47561 | 41770 | ice_skating_field_condition | 2020-12-27T09:12:21.560363+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 47609 | 41770 | ice_skating_field_condition | 2020-12-27T11:32:28.007843+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 48402 | 41770 | ice_skating_field_condition | 2020-12-29T09:37:35.296207+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 48456 | 41770 | ice_skating_field_condition | 2020-12-29T11:55:18.638365+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 48840 | 41770 | ice_skating_field_condition | 2020-12-30T11:28:01.036102+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 49201 | 41770 | ice_skating_field_condition | 2020-12-31T09:22:55.932893+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 49587 | 41770 | ice_skating_field_condition | 2021-01-01T09:15:56.086948+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 | ||||
| 49198 | 41805 | ice_skating_field_condition | 2020-12-31T09:22:26.229235+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6168 | 42185 | ice_skating_field_condition | 2019-11-28T08:41:58.115490+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6175 | 42185 | ice_skating_field_condition | 2019-11-29T20:39:35.724042+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6286 | 42185 | ice_skating_field_condition | 2019-12-07T17:06:26.069486+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6312 | 42185 | ice_skating_field_condition | 2019-12-09T18:49:14.494178+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6317 | 42185 | ice_skating_field_condition | 2019-12-10T09:02:52.503670+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6438 | 42185 | ice_skating_field_condition | 2019-12-18T17:53:32.897531+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6531 | 42185 | ice_skating_field_condition | 2019-12-27T08:14:28.181535+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6588 | 42185 | ice_skating_field_condition | 2019-12-30T10:56:24.869647+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6596 | 42185 | ice_skating_field_condition | 2019-12-30T20:20:51.573083+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6613 | 42185 | ice_skating_field_condition | 2020-01-01T12:16:08.717657+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | 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 );