observation
526 rows where name_sv = "Plogad"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6068 | 53615 | ice_skating_field_condition | 2019-11-19T16:48:00.193786+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6069 | 53615 | ice_skating_field_condition | 2019-11-20T08:43:13.642764+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6107 | 42852 | ice_skating_field_condition | 2019-11-25T09:43:48.162988+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6108 | 42526 | ice_skating_field_condition | 2019-11-25T09:44:25.224077+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6113 | 46144 | ice_skating_field_condition | 2019-11-25T11:11:43.205941+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6128 | 46144 | ice_skating_field_condition | 2019-11-26T08:55:36.648076+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6143 | 42852 | ice_skating_field_condition | 2019-11-26T10:34:45.266526+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6144 | 42526 | ice_skating_field_condition | 2019-11-26T10:35:05.067897+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6145 | 46144 | ice_skating_field_condition | 2019-11-26T10:35:42.508793+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6146 | 42699 | ice_skating_field_condition | 2019-11-26T10:35:57.982288+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6153 | 46144 | ice_skating_field_condition | 2019-11-26T19:31:48.784188+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6166 | 53615 | ice_skating_field_condition | 2019-11-28T07:26:39.378359+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6168 | 42185 | ice_skating_field_condition | 2019-11-28T08:41:58.115490+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 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 | ||||
| 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 | ||||
| 6194 | 42852 | ice_skating_field_condition | 2019-11-30T16:09:15.245065+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 | ||||
| 6215 | 42526 | ice_skating_field_condition | 2019-12-02T14:09:55.944068+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6234 | 40438 | ice_skating_field_condition | 2019-12-04T08:02:53.902024+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6256 | 53615 | ice_skating_field_condition | 2019-12-05T08:18:51.190959+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 6315 | 53615 | ice_skating_field_condition | 2019-12-10T08:34:49.572512+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | 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 | ||||
| 6365 | 53615 | ice_skating_field_condition | 2019-12-12T09:23:29.595050+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | 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 | ||||
| 6415 | 53524 | ice_skating_field_condition | 2019-12-16T10:04:15.049415+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6416 | 53523 | ice_skating_field_condition | 2019-12-16T10:04:49.479697+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6422 | 47279 | ice_skating_field_condition | 2019-12-17T07:25:35.700039+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6423 | 53615 | ice_skating_field_condition | 2019-12-17T07:25:47.162629+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6425 | 46144 | ice_skating_field_condition | 2019-12-17T08:42:01.437711+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6426 | 53523 | ice_skating_field_condition | 2019-12-17T09:14:54.828452+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6427 | 53524 | ice_skating_field_condition | 2019-12-17T09:15:04.284350+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6438 | 42185 | ice_skating_field_condition | 2019-12-18T17:53:32.897531+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6439 | 47279 | ice_skating_field_condition | 2019-12-18T20:25:59.692407+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6449 | 53523 | ice_skating_field_condition | 2019-12-19T09:44:46.755132+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6450 | 53524 | ice_skating_field_condition | 2019-12-19T09:45:02.272158+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6480 | 53615 | ice_skating_field_condition | 2019-12-22T08:12:23.768639+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6500 | 53615 | ice_skating_field_condition | 2019-12-23T10:40:03.289903+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6521 | 47279 | ice_skating_field_condition | 2019-12-26T09:19:02.929863+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6522 | 53615 | ice_skating_field_condition | 2019-12-26T09:19:15.134912+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6523 | 53524 | ice_skating_field_condition | 2019-12-26T10:00:37.631415+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6524 | 53523 | ice_skating_field_condition | 2019-12-26T10:01:12.053513+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6527 | 47279 | ice_skating_field_condition | 2019-12-27T07:14:41.665707+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6528 | 53615 | ice_skating_field_condition | 2019-12-27T07:14:48.857940+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6531 | 42185 | ice_skating_field_condition | 2019-12-27T08:14:28.181535+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6532 | 41770 | ice_skating_field_condition | 2019-12-27T08:14:38.262025+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6588 | 42185 | ice_skating_field_condition | 2019-12-30T10:56:24.869647+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6589 | 41770 | ice_skating_field_condition | 2019-12-30T10:56:43.457255+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6591 | 53523 | ice_skating_field_condition | 2019-12-30T12:18:18.871219+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6592 | 53524 | ice_skating_field_condition | 2019-12-30T12:18:31.031445+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 | ||||
| 6594 | 53563 | ice_skating_field_condition | 2019-12-30T14:57:24.377111+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6595 | 53563 | ice_skating_field_condition | 2019-12-30T19:27:41.657738+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6596 | 42185 | ice_skating_field_condition | 2019-12-30T20:20:51.573083+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6613 | 42185 | ice_skating_field_condition | 2020-01-01T12:16:08.717657+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6614 | 41770 | ice_skating_field_condition | 2020-01-01T12:16:17.186336+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6627 | 42185 | ice_skating_field_condition | 2020-01-02T09:17:03.259292+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6628 | 41770 | ice_skating_field_condition | 2020-01-02T09:17:13.530853+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6640 | 53523 | ice_skating_field_condition | 2020-01-03T09:14:41.614767+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6641 | 53524 | ice_skating_field_condition | 2020-01-03T09:14:46.378735+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6642 | 53524 | ice_skating_field_condition | 2020-01-03T09:14:50.453486+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6656 | 53615 | ice_skating_field_condition | 2020-01-04T08:25:22.197372+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6688 | 41770 | ice_skating_field_condition | 2020-01-06T08:23:02.858368+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6693 | 42185 | ice_skating_field_condition | 2020-01-06T12:25:49.584450+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6706 | 53563 | ice_skating_field_condition | 2020-01-07T07:53:35.498007+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6707 | 53523 | ice_skating_field_condition | 2020-01-07T08:55:56.160294+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6708 | 53524 | ice_skating_field_condition | 2020-01-07T08:56:02.190243+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 | ||||
| 6713 | 47279 | ice_skating_field_condition | 2020-01-08T07:08:51.887080+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6714 | 53615 | ice_skating_field_condition | 2020-01-08T07:09:30.837837+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6718 | 53523 | ice_skating_field_condition | 2020-01-08T08:29:01.310647+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6719 | 53524 | ice_skating_field_condition | 2020-01-08T08:29:08.133111+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6768 | 46144 | ice_skating_field_condition | 2020-01-11T15:54:33.698929+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6784 | 42185 | ice_skating_field_condition | 2020-01-12T09:32:49.063627+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6785 | 41770 | ice_skating_field_condition | 2020-01-12T09:32:57.615187+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 | ||||
| 6789 | 46144 | ice_skating_field_condition | 2020-01-12T11:24:00.937355+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6790 | 46144 | ice_skating_field_condition | 2020-01-12T11:24:20.908524+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 | ||||
| 6794 | 46144 | ice_skating_field_condition | 2020-01-12T16:04:51.645585+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 |
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 );