observation
526 rows where name_en = "Cleared of snow" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
50112 | 39269 | ice_skating_field_condition | 2021-01-02T14:04:11.634280+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 | ||||
50117 | 39296 | ice_skating_field_condition | 2021-01-02T14:09:21.163492+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 | ||||
38334 | 39370 | ice_skating_field_condition | 2020-11-30T14:25:21.488076+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
38551 | 39370 | ice_skating_field_condition | 2020-12-01T08:05:37.895637+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
39671 | 39370 | ice_skating_field_condition | 2020-12-04T15:47:13.161205+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
39931 | 39370 | ice_skating_field_condition | 2020-12-05T11:04:09.703884+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
40314 | 39370 | ice_skating_field_condition | 2020-12-06T18:07:31.617144+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
42130 | 39370 | ice_skating_field_condition | 2020-12-12T08:04:28.689517+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
43496 | 39370 | ice_skating_field_condition | 2020-12-16T12:38:51.734391+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44187 | 39370 | ice_skating_field_condition | 2020-12-18T14:26:05.072018+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 | ||||
49604 | 39370 | ice_skating_field_condition | 2021-01-01T09:52:36.166153+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 | ||||
50403 | 39370 | ice_skating_field_condition | 2021-01-03T08:26:28.057241+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 | ||||
50116 | 39385 | ice_skating_field_condition | 2021-01-02T14:08:15.782544+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 | ||||
50467 | 39398 | ice_skating_field_condition | 2021-01-03T11:44:23.405663+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 | ||||
50104 | 39498 | ice_skating_field_condition | 2021-01-02T14:00:32.977245+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 | ||||
50108 | 39604 | ice_skating_field_condition | 2021-01-02T14:01:56.584990+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 | ||||
50799 | 39604 | ice_skating_field_condition | 2021-01-04T07:41:49.161325+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 | ||||
50109 | 39710 | ice_skating_field_condition | 2021-01-02T14:02:25.181872+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 | ||||
50106 | 39780 | ice_skating_field_condition | 2021-01-02T14:01:04.787142+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 | ||||
6203 | 39834 | ice_skating_field_condition | 2019-12-01T18:49:21.145615+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 | ||||
6279 | 39834 | ice_skating_field_condition | 2019-12-07T11:34:27.315239+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6593 | 39834 | ice_skating_field_condition | 2019-12-30T14:57:05.376948+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6709 | 39834 | ice_skating_field_condition | 2020-01-07T09:44:56.590761+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6830 | 39834 | ice_skating_field_condition | 2020-01-14T15:00:00.976818+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 | ||||
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 | ||||
7047 | 39834 | ice_skating_field_condition | 2020-01-24T15:20:29.671490+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 | ||||
7113 | 39834 | ice_skating_field_condition | 2020-01-28T08:43:57.570540+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 | ||||
7502 | 39834 | ice_skating_field_condition | 2020-02-09T15:16:42.742454+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7538 | 39834 | ice_skating_field_condition | 2020-02-10T14:34:20.883078+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7572 | 39834 | ice_skating_field_condition | 2020-02-11T15:17:30.079982+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7724 | 39834 | ice_skating_field_condition | 2020-02-18T09:52:56.074918+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7997 | 39834 | ice_skating_field_condition | 2020-03-01T14:58:23.960388+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8019 | 39834 | ice_skating_field_condition | 2020-03-02T14:25:30.446557+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8059 | 39834 | ice_skating_field_condition | 2020-03-04T13:18:17.937104+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8156 | 39834 | ice_skating_field_condition | 2020-03-09T08:24:04.867607+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8191 | 39834 | ice_skating_field_condition | 2020-03-12T08:17:25.348096+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8294 | 39834 | ice_skating_field_condition | 2020-03-17T15:08:29.761463+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
27814 | 39834 | ice_skating_field_condition | 2020-10-26T17:14:03.327211+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
38558 | 39834 | ice_skating_field_condition | 2020-12-01T08:39:32.094168+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
39979 | 39834 | ice_skating_field_condition | 2020-12-05T14:55:41.259871+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44864 | 39834 | ice_skating_field_condition | 2020-12-20T08:30:08.321627+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 | ||||
39593 | 39854 | ice_skating_field_condition | 2020-12-04T10:56:00.622280+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 | ||||
7441 | 40040 | ice_skating_field_condition | 2020-02-08T09:35:23.564237+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6788 | 40402 | ice_skating_field_condition | 2020-01-12T11:10:07.888152+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 | ||||
7098 | 40402 | ice_skating_field_condition | 2020-01-27T08:35:08.491965+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 | ||||
7209 | 40402 | ice_skating_field_condition | 2020-02-02T12:02:42.556980+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7587 | 40402 | ice_skating_field_condition | 2020-02-12T08:29:29.745958+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7707 | 40402 | ice_skating_field_condition | 2020-02-17T09:45:47.538549+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7719 | 40402 | ice_skating_field_condition | 2020-02-18T07:49:48.201976+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7798 | 40402 | ice_skating_field_condition | 2020-02-21T08:45:07.177076+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8008 | 40402 | ice_skating_field_condition | 2020-03-02T09:03:29.643371+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8047 | 40402 | ice_skating_field_condition | 2020-03-04T07:42:23.205940+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6792 | 40421 | ice_skating_field_condition | 2020-01-12T12:56:27.436367+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 | ||||
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 | ||||
7079 | 40421 | ice_skating_field_condition | 2020-01-26T10:01:49.316444+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 | ||||
7116 | 40421 | ice_skating_field_condition | 2020-01-28T10:19:13.343558+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 | ||||
7173 | 40421 | ice_skating_field_condition | 2020-01-31T09:05:31.734764+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 | ||||
7208 | 40421 | ice_skating_field_condition | 2020-02-02T09:28:57.091991+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 | ||||
7445 | 40421 | ice_skating_field_condition | 2020-02-08T09:58:03.764478+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 | ||||
7561 | 40421 | ice_skating_field_condition | 2020-02-11T08:46:40.585207+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7591 | 40421 | ice_skating_field_condition | 2020-02-12T10:50:32.502452+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7664 | 40421 | ice_skating_field_condition | 2020-02-15T10:04:26.130602+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7708 | 40421 | ice_skating_field_condition | 2020-02-17T10:33:02.155728+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7726 | 40421 | ice_skating_field_condition | 2020-02-18T09:55:31.000355+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7756 | 40421 | ice_skating_field_condition | 2020-02-19T09:37:04.995095+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7789 | 40421 | ice_skating_field_condition | 2020-02-20T12:08:29.713031+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7916 | 40421 | ice_skating_field_condition | 2020-02-27T08:45:36.002678+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7934 | 40421 | ice_skating_field_condition | 2020-02-28T08:28:33.630729+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7960 | 40421 | ice_skating_field_condition | 2020-02-29T09:35:52.235339+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 );