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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6278 | 53563 | ice_skating_field_condition | 2019-12-07T11:34:18.389811+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 | ||||
6280 | 53523 | ice_skating_field_condition | 2019-12-07T14:27:15.170743+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6281 | 53524 | ice_skating_field_condition | 2019-12-07T14:27:31.100488+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6282 | 42699 | ice_skating_field_condition | 2019-12-07T16:07:17.694802+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6283 | 46144 | ice_skating_field_condition | 2019-12-07T16:07:27.250189+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6284 | 42852 | ice_skating_field_condition | 2019-12-07T16:07:47.833127+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6285 | 42526 | ice_skating_field_condition | 2019-12-07T16:08:13.818363+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6286 | 42185 | ice_skating_field_condition | 2019-12-07T17:06:26.069486+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 | ||||
6290 | 47279 | ice_skating_field_condition | 2019-12-08T08:44:54.400892+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6291 | 53615 | ice_skating_field_condition | 2019-12-08T08:45:08.545750+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6292 | 53524 | ice_skating_field_condition | 2019-12-08T08:53:38.583271+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6293 | 53523 | ice_skating_field_condition | 2019-12-08T08:53:52.087653+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6294 | 42185 | ice_skating_field_condition | 2019-12-08T09:33:33.267564+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6295 | 41770 | ice_skating_field_condition | 2019-12-08T09:33:56.806562+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6296 | 53563 | ice_skating_field_condition | 2019-12-08T09:59:01.316770+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6297 | 39834 | ice_skating_field_condition | 2019-12-08T09:59:07.693072+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6298 | 40402 | ice_skating_field_condition | 2019-12-08T13:46:25.009053+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6299 | 39834 | ice_skating_field_condition | 2019-12-08T15:08:15.828425+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6300 | 53563 | ice_skating_field_condition | 2019-12-08T15:08:35.642695+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6302 | 47279 | ice_skating_field_condition | 2019-12-09T08:43:35.498157+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6303 | 40402 | ice_skating_field_condition | 2019-12-09T08:49:02.787774+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6304 | 40934 | ice_skating_field_condition | 2019-12-09T09:22:06.404096+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6305 | 51402 | ice_skating_field_condition | 2019-12-09T09:22:50.992009+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6306 | 40249 | ice_skating_field_condition | 2019-12-09T11:06:42.641530+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6307 | 53615 | ice_skating_field_condition | 2019-12-09T12:21:08.062748+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6308 | 53524 | ice_skating_field_condition | 2019-12-09T14:13:52.222823+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6309 | 53523 | ice_skating_field_condition | 2019-12-09T14:14:02.931866+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6310 | 51402 | ice_skating_field_condition | 2019-12-09T14:23:37.051134+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6311 | 41770 | ice_skating_field_condition | 2019-12-09T18:48:51.180019+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 | ||||
6313 | 40402 | ice_skating_field_condition | 2019-12-10T08:14:47.219049+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6314 | 40493 | ice_skating_field_condition | 2019-12-10T08:17:00.479929+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6315 | 53615 | ice_skating_field_condition | 2019-12-10T08:34:49.572512+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6316 | 47279 | ice_skating_field_condition | 2019-12-10T08:35:03.903911+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6317 | 42185 | ice_skating_field_condition | 2019-12-10T09:02:52.503670+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 | ||||
6319 | 42852 | ice_skating_field_condition | 2019-12-10T10:20:33.982313+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6323 | 46144 | ice_skating_field_condition | 2019-12-10T13:30:29.428737+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6326 | 53524 | ice_skating_field_condition | 2019-12-10T14:46:37.732093+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6327 | 53523 | ice_skating_field_condition | 2019-12-10T14:46:46.080887+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6330 | 40402 | ice_skating_field_condition | 2019-12-11T07:50:04.950286+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6333 | 53524 | ice_skating_field_condition | 2019-12-11T07:58:04.246462+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6334 | 53523 | ice_skating_field_condition | 2019-12-11T07:58:10.481447+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6335 | 53615 | ice_skating_field_condition | 2019-12-11T08:50:33.543217+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6336 | 47279 | ice_skating_field_condition | 2019-12-11T08:50:46.998901+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6337 | 40438 | ice_skating_field_condition | 2019-12-11T08:54:38.154469+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6341 | 46144 | ice_skating_field_condition | 2019-12-11T09:06:33.881352+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6344 | 53524 | ice_skating_field_condition | 2019-12-11T12:04:43.364849+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6345 | 53523 | ice_skating_field_condition | 2019-12-11T12:05:05.243005+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6361 | 42185 | ice_skating_field_condition | 2019-12-12T08:05:31.631899+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6362 | 41770 | ice_skating_field_condition | 2019-12-12T08:05:40.481853+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6363 | 40402 | ice_skating_field_condition | 2019-12-12T08:38:08.255814+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6364 | 47279 | ice_skating_field_condition | 2019-12-12T09:23:12.377825+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6365 | 53615 | ice_skating_field_condition | 2019-12-12T09:23:29.595050+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6366 | 53524 | ice_skating_field_condition | 2019-12-12T10:09:07.826603+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6367 | 53563 | ice_skating_field_condition | 2019-12-12T11:34:58.971298+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6368 | 39834 | ice_skating_field_condition | 2019-12-12T11:35:37.457672+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6369 | 53523 | ice_skating_field_condition | 2019-12-12T12:38:52.227236+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6370 | 46144 | ice_skating_field_condition | 2019-12-12T14:01:43.782670+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6371 | 41549 | ice_skating_field_condition | 2019-12-12T16:34:49.332448+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6372 | 42185 | ice_skating_field_condition | 2019-12-13T08:43:58.184758+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6373 | 41770 | ice_skating_field_condition | 2019-12-13T08:44:06.222435+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6374 | 46144 | ice_skating_field_condition | 2019-12-13T08:58:00.654651+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6375 | 40402 | ice_skating_field_condition | 2019-12-13T09:16:55.051453+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6376 | 47279 | ice_skating_field_condition | 2019-12-13T09:18:52.768741+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6377 | 53615 | ice_skating_field_condition | 2019-12-13T09:19:14.052428+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6378 | 53524 | ice_skating_field_condition | 2019-12-13T09:58:16.014618+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6379 | 53523 | ice_skating_field_condition | 2019-12-13T09:58:36.979536+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6382 | 53563 | ice_skating_field_condition | 2019-12-14T08:01:12.367656+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6383 | 39834 | ice_skating_field_condition | 2019-12-14T09:10:00.050636+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6384 | 53523 | ice_skating_field_condition | 2019-12-14T10:21:28.220619+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6385 | 53524 | ice_skating_field_condition | 2019-12-14T10:21:38.947923+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6386 | 40493 | ice_skating_field_condition | 2019-12-14T10:24:05.471248+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6389 | 41549 | ice_skating_field_condition | 2019-12-14T11:33:30.492289+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6390 | 42699 | ice_skating_field_condition | 2019-12-14T15:25:02.205631+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6391 | 42526 | ice_skating_field_condition | 2019-12-14T15:25:16.188973+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6392 | 42852 | ice_skating_field_condition | 2019-12-14T15:25:27.644863+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6393 | 46144 | ice_skating_field_condition | 2019-12-14T15:25:34.116156+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6394 | 47279 | ice_skating_field_condition | 2019-12-14T17:18:59.281156+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6397 | 53615 | ice_skating_field_condition | 2019-12-15T09:01:34.898744+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6398 | 47279 | ice_skating_field_condition | 2019-12-15T09:01:59.549022+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6399 | 53524 | ice_skating_field_condition | 2019-12-15T10:00:44.447329+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6400 | 53523 | ice_skating_field_condition | 2019-12-15T10:00:56.550334+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 | ||||
6402 | 53523 | ice_skating_field_condition | 2019-12-15T14:34:43.949587+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6403 | 53523 | ice_skating_field_condition | 2019-12-15T14:35:01.261754+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6404 | 53524 | ice_skating_field_condition | 2019-12-15T16:18:41.012142+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6405 | 40402 | ice_skating_field_condition | 2019-12-15T16:35:43.228859+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6406 | 53563 | ice_skating_field_condition | 2019-12-16T08:03:54.181138+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6407 | 42185 | ice_skating_field_condition | 2019-12-16T08:18:36.314481+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6408 | 41770 | ice_skating_field_condition | 2019-12-16T08:18:44.089211+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6409 | 41549 | ice_skating_field_condition | 2019-12-16T08:31:52.812089+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6410 | 41549 | ice_skating_field_condition | 2019-12-16T08:32:10.719138+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6411 | 39834 | ice_skating_field_condition | 2019-12-16T08:48:27.775922+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6412 | 47279 | ice_skating_field_condition | 2019-12-16T08:58:34.648224+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6413 | 53615 | ice_skating_field_condition | 2019-12-16T08:58:59.610183+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6414 | 40402 | ice_skating_field_condition | 2019-12-16T09:58:24.536121+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6415 | 53524 | ice_skating_field_condition | 2019-12-16T10:04:15.049415+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 );