observation
526 rows where name_en = "Cleared of snow"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6831 | 53563 | ice_skating_field_condition | 2020-01-14T15:00:22.360874+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6832 | 42699 | ice_skating_field_condition | 2020-01-14T16:16:59.222264+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6859 | 40421 | ice_skating_field_condition | 2020-01-16T09:45:01.903463+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6864 | 40402 | ice_skating_field_condition | 2020-01-16T14:21:36.304981+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6866 | 39834 | ice_skating_field_condition | 2020-01-16T15:10:26.385509+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6867 | 53563 | ice_skating_field_condition | 2020-01-16T15:10:41.394712+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6868 | 53563 | ice_skating_field_condition | 2020-01-16T18:17:16.461445+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6886 | 42185 | ice_skating_field_condition | 2020-01-17T12:34:29.999132+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 | ||||
6891 | 39834 | ice_skating_field_condition | 2020-01-17T14:48:15.891076+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6912 | 39834 | ice_skating_field_condition | 2020-01-18T14:44:34.605732+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6913 | 53563 | ice_skating_field_condition | 2020-01-18T14:45:02.785453+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6919 | 42185 | ice_skating_field_condition | 2020-01-19T08:23:19.984872+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6922 | 53524 | ice_skating_field_condition | 2020-01-19T08:32:16.848348+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6924 | 53524 | ice_skating_field_condition | 2020-01-19T08:34:55.538700+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6925 | 47279 | ice_skating_field_condition | 2020-01-19T08:39:52.892792+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6926 | 53615 | ice_skating_field_condition | 2020-01-19T08:40:18.552544+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 | ||||
6956 | 40421 | ice_skating_field_condition | 2020-01-20T11:28:15.809542+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6966 | 40421 | ice_skating_field_condition | 2020-01-21T06:57:12.566365+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6976 | 40421 | ice_skating_field_condition | 2020-01-21T09:45:15.092308+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6986 | 42699 | ice_skating_field_condition | 2020-01-21T15:54:49.664977+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7040 | 42699 | ice_skating_field_condition | 2020-01-24T10:19:38.985332+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7046 | 53563 | ice_skating_field_condition | 2020-01-24T15:20:15.302312+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7047 | 39834 | ice_skating_field_condition | 2020-01-24T15:20:29.671490+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7079 | 40421 | ice_skating_field_condition | 2020-01-26T10:01:49.316444+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7086 | 53563 | ice_skating_field_condition | 2020-01-27T07:17:57.867407+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7091 | 42699 | ice_skating_field_condition | 2020-01-27T08:05:42.604439+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7092 | 42185 | ice_skating_field_condition | 2020-01-27T08:14:02.276283+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 | ||||
7094 | 53523 | ice_skating_field_condition | 2020-01-27T08:17:50.365336+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7095 | 53524 | ice_skating_field_condition | 2020-01-27T08:18:08.731590+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7098 | 40402 | ice_skating_field_condition | 2020-01-27T08:35:08.491965+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7100 | 39834 | ice_skating_field_condition | 2020-01-27T09:01:51.922726+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7101 | 40421 | ice_skating_field_condition | 2020-01-27T09:04:09.156021+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7107 | 42699 | ice_skating_field_condition | 2020-01-27T19:11:27.496931+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7108 | 53523 | ice_skating_field_condition | 2020-01-28T07:30:39.697321+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7109 | 53524 | ice_skating_field_condition | 2020-01-28T07:30:52.438593+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7110 | 53615 | ice_skating_field_condition | 2020-01-28T07:55:56.079334+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7111 | 47279 | ice_skating_field_condition | 2020-01-28T07:56:12.610146+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7113 | 39834 | ice_skating_field_condition | 2020-01-28T08:43:57.570540+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7116 | 40421 | ice_skating_field_condition | 2020-01-28T10:19:13.343558+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7118 | 53563 | ice_skating_field_condition | 2020-01-28T11:52:21.507001+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7120 | 42185 | ice_skating_field_condition | 2020-01-28T13:56:50.876268+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7125 | 42699 | ice_skating_field_condition | 2020-01-28T17:59:57.417582+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7129 | 53615 | ice_skating_field_condition | 2020-01-29T07:51:15.654848+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7135 | 53523 | ice_skating_field_condition | 2020-01-29T08:39:39.504112+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7136 | 53524 | ice_skating_field_condition | 2020-01-29T08:39:46.141636+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7137 | 42699 | ice_skating_field_condition | 2020-01-29T09:32:20.443385+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 | ||||
7141 | 42185 | ice_skating_field_condition | 2020-01-29T19:00:09.592568+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7142 | 53563 | ice_skating_field_condition | 2020-01-30T07:24:30.199056+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7145 | 40402 | ice_skating_field_condition | 2020-01-30T07:47:06.528957+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7147 | 47279 | ice_skating_field_condition | 2020-01-30T07:49:56.837903+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7150 | 53615 | ice_skating_field_condition | 2020-01-30T08:35:26.062231+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7151 | 39834 | ice_skating_field_condition | 2020-01-30T08:44:27.590486+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7152 | 42699 | ice_skating_field_condition | 2020-01-30T08:46:08.120846+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7155 | 42185 | ice_skating_field_condition | 2020-01-30T08:57:50.495046+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7157 | 40421 | ice_skating_field_condition | 2020-01-30T09:10:52.174189+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7158 | 53523 | ice_skating_field_condition | 2020-01-30T11:51:00.512077+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7159 | 53524 | ice_skating_field_condition | 2020-01-30T11:51:08.375969+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7170 | 42185 | ice_skating_field_condition | 2020-01-31T08:28:01.138106+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7172 | 53524 | ice_skating_field_condition | 2020-01-31T08:31:31.831100+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7173 | 40421 | ice_skating_field_condition | 2020-01-31T09:05:31.734764+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7174 | 53523 | ice_skating_field_condition | 2020-01-31T09:27:12.638102+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7180 | 42699 | ice_skating_field_condition | 2020-01-31T12:28:57.132094+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7185 | 46144 | ice_skating_field_condition | 2020-02-01T09:10:54.364537+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7188 | 40421 | ice_skating_field_condition | 2020-02-01T09:44:47.686837+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7202 | 42185 | ice_skating_field_condition | 2020-02-02T08:11:05.410374+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 | ||||
7205 | 46144 | ice_skating_field_condition | 2020-02-02T08:59:10.545204+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7208 | 40421 | ice_skating_field_condition | 2020-02-02T09:28:57.091991+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7209 | 40402 | ice_skating_field_condition | 2020-02-02T12:02:42.556980+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7210 | 46144 | ice_skating_field_condition | 2020-02-02T12:42:28.417402+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7213 | 46144 | ice_skating_field_condition | 2020-02-02T16:09:39.459985+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7228 | 40421 | ice_skating_field_condition | 2020-02-03T09:42:18.557760+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7240 | 40421 | ice_skating_field_condition | 2020-02-04T09:31:03.710741+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7338 | 40421 | ice_skating_field_condition | 2020-02-06T09:09:35.309980+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7428 | 40013 | ice_skating_field_condition | 2020-02-08T07:06:18.408892+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 | ||||
7431 | 50354 | ice_skating_field_condition | 2020-02-08T07:48:56.825987+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 | ||||
7433 | 53615 | ice_skating_field_condition | 2020-02-08T07:49:16.291676+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7434 | 42249 | ice_skating_field_condition | 2020-02-08T08:20:45.432821+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7439 | 61464 | ice_skating_field_condition | 2020-02-08T09:21:27.512535+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7440 | 42241 | ice_skating_field_condition | 2020-02-08T09:34:55.637011+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7441 | 40040 | ice_skating_field_condition | 2020-02-08T09:35:23.564237+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7442 | 42699 | ice_skating_field_condition | 2020-02-08T09:45:11.320090+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7445 | 40421 | ice_skating_field_condition | 2020-02-08T09:58:03.764478+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 | ||||
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 | ||||
7476 | 53615 | ice_skating_field_condition | 2020-02-09T07:18:07.597018+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7483 | 40421 | ice_skating_field_condition | 2020-02-09T09:20:19.901251+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7484 | 53523 | ice_skating_field_condition | 2020-02-09T09:38:57.442638+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7485 | 53524 | ice_skating_field_condition | 2020-02-09T09:39:03.720968+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 | ||||
7496 | 42699 | ice_skating_field_condition | 2020-02-09T12:02:03.244009+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7502 | 39834 | ice_skating_field_condition | 2020-02-09T15:16:42.742454+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7503 | 53563 | ice_skating_field_condition | 2020-02-09T15:17:05.537614+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 );