observation
419 rows where quality = "unusable" and value = "closed"
This data as json, CSV (advanced)
Suggested facets: property
id ▼ | unit | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5987 | 42852 | ice_skating_field_condition | 2019-09-07T18:40:27.198231+0300 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
5989 | 41976 | ice_skating_field_condition | 2019-09-11T07:24:08.373689+0300 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6011 | 41770 | ice_skating_field_condition | 2019-11-07T09:56:49.171260+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6014 | 42185 | ice_skating_field_condition | 2019-11-07T09:58:40.112027+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6026 | 53615 | ice_skating_field_condition | 2019-11-11T16:09:42.262419+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6030 | 41770 | ice_skating_field_condition | 2019-11-12T09:21:57.649587+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6042 | 53524 | ice_skating_field_condition | 2019-11-14T14:00:38.837026+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6043 | 53523 | ice_skating_field_condition | 2019-11-14T14:01:03.454848+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6052 | 53563 | ice_skating_field_condition | 2019-11-17T09:56:26.450995+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6062 | 53563 | ice_skating_field_condition | 2019-11-18T11:54:30.323399+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6067 | 53615 | ice_skating_field_condition | 2019-11-19T14:49:25.099218+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6074 | 53524 | ice_skating_field_condition | 2019-11-22T12:50:21.925939+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6075 | 53523 | ice_skating_field_condition | 2019-11-22T12:50:42.715838+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6079 | 53563 | ice_skating_field_condition | 2019-11-23T08:56:25.190468+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6084 | 47279 | ice_skating_field_condition | 2019-11-23T15:54:15.448380+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6087 | 53563 | ice_skating_field_condition | 2019-11-24T08:54:42.027456+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6094 | 53524 | ice_skating_field_condition | 2019-11-25T06:32:50.409420+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6095 | 53523 | ice_skating_field_condition | 2019-11-25T06:32:57.544183+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6099 | 53523 | ice_skating_field_condition | 2019-11-25T09:05:57.015330+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6100 | 53524 | ice_skating_field_condition | 2019-11-25T09:06:08.220871+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6111 | 53563 | ice_skating_field_condition | 2019-11-25T11:05:54.025272+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
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 | ||||
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 | ||||
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 | ||||
6181 | 53710 | ski_trail_condition | 2019-11-30T11:25:11.706636+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
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 | ||||
6222 | 51402 | ice_skating_field_condition | 2019-12-03T09:02:35.675224+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
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 | ||||
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 | ||||
6235 | 50354 | ice_skating_field_condition | 2019-12-04T08:10:05.936963+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
6332 | 51028 | ski_trail_condition | 2019-12-11T07:56:35.444857+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
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 | ||||
6337 | 40438 | ice_skating_field_condition | 2019-12-11T08:54:38.154469+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6345 | 53523 | ice_skating_field_condition | 2019-12-11T12:05:05.243005+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6369 | 53523 | ice_skating_field_condition | 2019-12-12T12:38:52.227236+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6379 | 53523 | ice_skating_field_condition | 2019-12-13T09:58:36.979536+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
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 | ||||
6428 | 51402 | ice_skating_field_condition | 2019-12-17T10:09:05.340392+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6429 | 40934 | ice_skating_field_condition | 2019-12-17T10:09:15.139266+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6433 | 53523 | ice_skating_field_condition | 2019-12-18T09:08:31.263728+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6434 | 53524 | ice_skating_field_condition | 2019-12-18T09:08:37.065378+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6435 | 47279 | ice_skating_field_condition | 2019-12-18T13:44:10.038252+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6436 | 53615 | ice_skating_field_condition | 2019-12-18T13:44:23.387196+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6437 | 41770 | ice_skating_field_condition | 2019-12-18T17:53:16.258774+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6457 | 53523 | ice_skating_field_condition | 2019-12-20T07:19:47.911358+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6458 | 53524 | ice_skating_field_condition | 2019-12-20T07:19:54.409710+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6466 | 53523 | ice_skating_field_condition | 2019-12-21T09:09:23.854236+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6467 | 53524 | ice_skating_field_condition | 2019-12-21T09:09:29.280854+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6502 | 42185 | ice_skating_field_condition | 2019-12-23T14:56:49.172676+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6533 | 42249 | ice_skating_field_condition | 2019-12-27T09:38:54.890364+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6535 | 41181 | ice_skating_field_condition | 2019-12-27T09:40:42.504124+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6626 | 40218 | ice_skating_field_condition | 2020-01-02T09:02:38.314077+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6684 | 51028 | ski_trail_condition | 2020-01-05T16:58:24.715481+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6712 | 41770 | ice_skating_field_condition | 2020-01-07T14:32:01.462290+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6722 | 51402 | ice_skating_field_condition | 2020-01-08T09:25:52.257888+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6728 | 53523 | ice_skating_field_condition | 2020-01-09T10:56:59.330110+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6736 | 60871 | ski_trail_condition | 2020-01-09T14:32:15.463464+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6743 | 41994 | ice_skating_field_condition | 2020-01-10T08:30:06.247681+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6752 | 57401 | ski_trail_condition | 2020-01-10T15:45:43.284338+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6774 | 53523 | ice_skating_field_condition | 2020-01-12T07:58:21.536555+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6775 | 53524 | ice_skating_field_condition | 2020-01-12T07:58:35.821949+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6783 | 40421 | ice_skating_field_condition | 2020-01-12T08:41:48.165452+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6786 | 47279 | ice_skating_field_condition | 2020-01-12T09:57:30.529638+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6793 | 42917 | ice_skating_field_condition | 2020-01-12T15:39:34.377127+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6821 | 53523 | ice_skating_field_condition | 2020-01-14T08:13:22.496263+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6834 | 47279 | ice_skating_field_condition | 2020-01-15T08:04:43.649739+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6835 | 53615 | ice_skating_field_condition | 2020-01-15T08:04:53.543565+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6836 | 41770 | ice_skating_field_condition | 2020-01-15T08:26:56.757972+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6837 | 53524 | ice_skating_field_condition | 2020-01-15T08:27:11.173318+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6838 | 53523 | ice_skating_field_condition | 2020-01-15T08:27:17.784813+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6842 | 42185 | ice_skating_field_condition | 2020-01-15T11:00:03.437514+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6843 | 40421 | ice_skating_field_condition | 2020-01-15T13:08:08.867515+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6845 | 50568 | ice_skating_field_condition | 2020-01-15T14:05:23.332074+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6849 | 40402 | ice_skating_field_condition | 2020-01-15T14:16:27.379631+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6850 | 56438 | ice_skating_field_condition | 2020-01-15T14:22:38.720102+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable |
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 );