observation
419 rows where name_sv = "Stängd" 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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
6743 | 41994 | ice_skating_field_condition | 2020-01-10T08:30:06.247681+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 | ||||
6858 | 53523 | ice_skating_field_condition | 2020-01-16T08:09:20.082547+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6863 | 47279 | ice_skating_field_condition | 2020-01-16T13:52:38.421614+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6865 | 53524 | ice_skating_field_condition | 2020-01-16T15:08:15.261424+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6881 | 53523 | ice_skating_field_condition | 2020-01-17T09:13:00.754676+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6899 | 50354 | ice_skating_field_condition | 2020-01-18T07:51:14.309712+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6918 | 41770 | ice_skating_field_condition | 2020-01-19T08:22:55.706889+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6921 | 53523 | ice_skating_field_condition | 2020-01-19T08:31:10.128243+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6935 | 41657 | ice_skating_field_condition | 2020-01-19T13:34:29.227140+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6971 | 53523 | ice_skating_field_condition | 2020-01-21T09:08:36.185373+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6972 | 53524 | ice_skating_field_condition | 2020-01-21T09:08:44.924513+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
7021 | 40934 | ice_skating_field_condition | 2020-01-23T15:07:39.964446+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
7104 | 41770 | ice_skating_field_condition | 2020-01-27T14:19:12.423830+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
7119 | 41770 | ice_skating_field_condition | 2020-01-28T13:56:36.796520+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
7140 | 41770 | ice_skating_field_condition | 2020-01-29T18:59:51.397113+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
7156 | 41770 | ice_skating_field_condition | 2020-01-30T08:58:13.900949+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
7160 | 53523 | ice_skating_field_condition | 2020-01-30T14:21:30.384386+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
7162 | 40421 | ice_skating_field_condition | 2020-01-30T16:14:18.685081+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
7163 | 40421 | ice_skating_field_condition | 2020-01-30T16:14:33.202367+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
7196 | 41770 | ice_skating_field_condition | 2020-02-01T12:45:31.872249+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
7247 | 51402 | ice_skating_field_condition | 2020-02-04T10:55:36.173488+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
7268 | 40201 | ice_skating_field_condition | 2020-02-04T21:12:54.628677+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
7270 | 40934 | ice_skating_field_condition | 2020-02-04T21:36:43.132410+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
7277 | 61464 | ice_skating_field_condition | 2020-02-05T07:51:41.382102+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
7302 | 42593 | ice_skating_field_condition | 2020-02-05T09:34:51.084462+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
7416 | 42413 | ice_skating_field_condition | 2020-02-07T13:53:20.364195+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
7417 | 42641 | ice_skating_field_condition | 2020-02-07T13:53:46.748597+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 );