observation
51,120 rows sorted by property
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 );