observation
526 rows where value = "plowed" sorted by id descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
51160 | 53615 | ice_skating_field_condition | 2021-01-04T21:56:39.719521+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
51071 | 53615 | ice_skating_field_condition | 2021-01-04T17:14:29.700935+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | 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 | ||||
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 | ||||
50799 | 39604 | ice_skating_field_condition | 2021-01-04T07:41:49.161325+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | 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 | ||||
50554 | 40421 | ice_skating_field_condition | 2021-01-03T15:49:14.887724+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | 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 | ||||
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 | ||||
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 | ||||
49730 | 40421 | ice_skating_field_condition | 2021-01-01T15:36:40.196064+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | 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 | ||||
49589 | 42185 | ice_skating_field_condition | 2021-01-01T09:16:32.474175+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 | ||||
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 | ||||
49285 | 40493 | ice_skating_field_condition | 2020-12-31T12:51:16.450478+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 | ||||
49201 | 41770 | ice_skating_field_condition | 2020-12-31T09:22:55.932893+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 | ||||
49194 | 40421 | ice_skating_field_condition | 2020-12-31T09:10:58.784530+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
49186 | 53524 | ice_skating_field_condition | 2020-12-31T08:52:51.572167+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
49185 | 53523 | ice_skating_field_condition | 2020-12-31T08:52:43.946843+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
49165 | 47279 | ice_skating_field_condition | 2020-12-31T07:50:03.914149+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 | ||||
48930 | 40493 | ice_skating_field_condition | 2020-12-30T15:53:20.880025+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
48919 | 63148 | ice_skating_field_condition | 2020-12-30T15:16:47.071706+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 | ||||
48838 | 53524 | ice_skating_field_condition | 2020-12-30T11:21:19.932760+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 | ||||
48776 | 53615 | ice_skating_field_condition | 2020-12-30T08:05:00.704748+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
48773 | 47279 | ice_skating_field_condition | 2020-12-30T07:58:25.365271+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
48515 | 53563 | ice_skating_field_condition | 2020-12-29T14:46:59.542005+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 | ||||
48455 | 42185 | ice_skating_field_condition | 2020-12-29T11:55:09.008375+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
48417 | 53523 | ice_skating_field_condition | 2020-12-29T10:12:12.877985+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
48416 | 53524 | ice_skating_field_condition | 2020-12-29T10:11:23.579513+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 | ||||
48401 | 42185 | ice_skating_field_condition | 2020-12-29T09:37:25.636501+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
48400 | 42249 | ice_skating_field_condition | 2020-12-29T09:33:38.249660+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
48394 | 63147 | ice_skating_field_condition | 2020-12-29T09:14:09.348215+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
48381 | 47279 | ice_skating_field_condition | 2020-12-29T08:35:22.744251+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
48380 | 53615 | ice_skating_field_condition | 2020-12-29T08:32:35.225643+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 | ||||
48375 | 39834 | ice_skating_field_condition | 2020-12-29T08:18:29.729323+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 | ||||
48364 | 53563 | ice_skating_field_condition | 2020-12-29T07:31:06.433442+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 | ||||
47677 | 41549 | ice_skating_field_condition | 2020-12-27T14:33:19.562478+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
47667 | 53615 | ice_skating_field_condition | 2020-12-27T14:04:39.046378+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
47666 | 47279 | ice_skating_field_condition | 2020-12-27T14:04:31.289524+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
47633 | 53523 | ice_skating_field_condition | 2020-12-27T12:34:06.412066+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
47632 | 53524 | ice_skating_field_condition | 2020-12-27T12:33:55.824520+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 | ||||
47588 | 42185 | ice_skating_field_condition | 2020-12-27T10:47:00.324313+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 | ||||
47554 | 42185 | ice_skating_field_condition | 2020-12-27T08:57:12.750237+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
47547 | 50568 | ice_skating_field_condition | 2020-12-27T08:35:26.776227+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
46925 | 42185 | ice_skating_field_condition | 2020-12-25T17:23:16.756314+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
46761 | 39370 | ice_skating_field_condition | 2020-12-25T09:20:55.461705+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 | ||||
46129 | 41770 | ice_skating_field_condition | 2020-12-23T10:09:47.118072+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 |
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 );