observation
419 rows where name_en = "Closed" sorted by unit
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 50899 | 39269 | ice_skating_field_condition | 2021-01-04T12:23:50.719939+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 51030 | 39269 | ice_skating_field_condition | 2021-01-04T15:13:26.045585+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50897 | 39296 | ice_skating_field_condition | 2021-01-04T12:22:52.718150+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 35594 | 39315 | ice_skating_field_condition | 2020-11-21T13:21:05.342364+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50898 | 39315 | ice_skating_field_condition | 2021-01-04T12:23:17.118693+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8276 | 39370 | ice_skating_field_condition | 2020-03-16T20:42:16.171030+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 44100 | 39370 | ice_skating_field_condition | 2020-12-18T08:58:36.074466+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 45281 | 39370 | ice_skating_field_condition | 2020-12-21T07:56:31.538028+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 45286 | 39370 | ice_skating_field_condition | 2020-12-21T07:56:51.682321+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 45735 | 39370 | ice_skating_field_condition | 2020-12-22T10:28:31.320271+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 46750 | 39370 | ice_skating_field_condition | 2020-12-25T08:43:16.014984+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50896 | 39385 | ice_skating_field_condition | 2021-01-04T12:22:31.801698+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50901 | 39398 | ice_skating_field_condition | 2021-01-04T12:24:55.518697+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50900 | 39401 | ice_skating_field_condition | 2021-01-04T12:24:17.076045+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50889 | 39498 | ice_skating_field_condition | 2021-01-04T12:19:23.273010+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50893 | 39604 | ice_skating_field_condition | 2021-01-04T12:20:48.019048+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50902 | 39654 | ice_skating_field_condition | 2021-01-04T12:25:30.385154+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 47600 | 39663 | ice_skating_field_condition | 2020-12-27T11:03:03.622133+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 35809 | 39675 | ice_skating_field_condition | 2020-11-22T09:59:48.877310+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50894 | 39710 | ice_skating_field_condition | 2021-01-04T12:21:12.583086+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50890 | 39780 | ice_skating_field_condition | 2021-01-04T12:20:01.032534+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 | ||||
| 8274 | 39834 | ice_skating_field_condition | 2020-03-16T20:40:52.980568+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8347 | 39834 | ice_skating_field_condition | 2020-03-23T07:56:29.038648+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 28002 | 39834 | ice_skating_field_condition | 2020-10-27T07:54:05.643745+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34934 | 39834 | ice_skating_field_condition | 2020-11-19T08:08:58.141971+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 36079 | 39834 | ice_skating_field_condition | 2020-11-23T07:33:05.611519+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 40483 | 39854 | ice_skating_field_condition | 2020-12-07T07:00:19.591803+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7570 | 39911 | ice_skating_field_condition | 2020-02-11T14:55:43.652887+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 43526 | 39911 | ice_skating_field_condition | 2020-12-16T14:34:44.291696+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7472 | 40013 | ice_skating_field_condition | 2020-02-09T06:44:58.861667+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7542 | 40026 | ice_skating_field_condition | 2020-02-10T16:40:56.385667+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7458 | 40040 | ice_skating_field_condition | 2020-02-08T16:26:05.952896+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7509 | 40059 | ice_skating_field_condition | 2020-02-09T20:44:37.212732+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 | ||||
| 6626 | 40218 | ice_skating_field_condition | 2020-01-02T09:02:38.314077+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7499 | 40218 | ice_skating_field_condition | 2020-02-09T13:16:31.790813+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 36786 | 40224 | ice_skating_field_condition | 2020-11-25T13:56:01.060911+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 | ||||
| 7425 | 40252 | ice_skating_field_condition | 2020-02-08T06:44:07.569203+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 | ||||
| 7527 | 40402 | ice_skating_field_condition | 2020-02-10T10:26:03.712300+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7822 | 40402 | ice_skating_field_condition | 2020-02-22T11:23:22.408975+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8162 | 40402 | ice_skating_field_condition | 2020-03-09T15:00:22.960874+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8165 | 40402 | ice_skating_field_condition | 2020-03-09T15:01:00.091728+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 | ||||
| 6843 | 40421 | ice_skating_field_condition | 2020-01-15T13:08:08.867515+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 | ||||
| 7528 | 40421 | ice_skating_field_condition | 2020-02-10T10:41:49.511748+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7695 | 40421 | ice_skating_field_condition | 2020-02-16T16:05:00.082781+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8178 | 40421 | ice_skating_field_condition | 2020-03-10T10:52:02.277831+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8185 | 40421 | ice_skating_field_condition | 2020-03-10T17:07:12.255322+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 41865 | 40421 | ice_skating_field_condition | 2020-12-11T12:35:50.820994+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 43435 | 40421 | ice_skating_field_condition | 2020-12-16T08:21:45.058198+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 44080 | 40421 | ice_skating_field_condition | 2020-12-18T07:35:22.652160+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 44879 | 40421 | ice_skating_field_condition | 2020-12-20T09:02:35.987640+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 45289 | 40421 | ice_skating_field_condition | 2020-12-21T07:59:14.102317+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 45693 | 40421 | ice_skating_field_condition | 2020-12-22T08:20:09.453221+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 48803 | 40421 | ice_skating_field_condition | 2020-12-30T09:39:31.928981+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 49340 | 40421 | ice_skating_field_condition | 2020-12-31T15:00:20.876900+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50405 | 40421 | ice_skating_field_condition | 2021-01-03T08:33:48.108169+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 | ||||
| 7475 | 40455 | ice_skating_field_condition | 2020-02-09T07:05:06.325443+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7580 | 40493 | ice_skating_field_condition | 2020-02-12T07:21:42.458448+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7825 | 40493 | ice_skating_field_condition | 2020-02-22T15:06:38.671792+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7878 | 40493 | ice_skating_field_condition | 2020-02-25T15:19:00.435231+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7919 | 40493 | ice_skating_field_condition | 2020-02-27T13:43:15.747876+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7941 | 40493 | ice_skating_field_condition | 2020-02-28T12:43:27.410967+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8101 | 40493 | ice_skating_field_condition | 2020-03-06T12:12:37.795286+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8140 | 40493 | ice_skating_field_condition | 2020-03-08T12:20:47.491096+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 35812 | 40493 | ice_skating_field_condition | 2020-11-22T10:03:54.125961+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8263 | 40550 | ice_skating_field_condition | 2020-03-16T11:14:43.669450+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34431 | 40550 | ice_skating_field_condition | 2020-11-17T16:05:06.503586+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8351 | 40725 | ice_skating_field_condition | 2020-03-23T13:17:17.696674+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 36785 | 40744 | ice_skating_field_condition | 2020-11-25T13:55:11.220194+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7469 | 40814 | ice_skating_field_condition | 2020-02-08T18:10:41.279521+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 | ||||
| 6429 | 40934 | ice_skating_field_condition | 2019-12-17T10:09:15.139266+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 | ||||
| 7270 | 40934 | ice_skating_field_condition | 2020-02-04T21:36:43.132410+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7480 | 40934 | ice_skating_field_condition | 2020-02-09T09:03:04.306886+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7862 | 40934 | ice_skating_field_condition | 2020-02-25T09:00:14.283720+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7531 | 40970 | ice_skating_field_condition | 2020-02-10T11:47:32.575793+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7899 | 40970 | ice_skating_field_condition | 2020-02-26T13:36:31.202819+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7972 | 40970 | ice_skating_field_condition | 2020-02-29T15:00:36.462423+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7529 | 41096 | ice_skating_field_condition | 2020-02-10T10:45:41.521804+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 | ||||
| 39919 | 41181 | ice_skating_field_condition | 2020-12-05T10:25:46.456941+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7541 | 41398 | ice_skating_field_condition | 2020-02-10T16:40:32.214934+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7568 | 41494 | ice_skating_field_condition | 2020-02-11T14:54:02.901830+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7569 | 41527 | ice_skating_field_condition | 2020-02-11T14:54:32.505840+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8201 | 41549 | ice_skating_field_condition | 2020-03-12T11:10:51.330922+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7471 | 41568 | ice_skating_field_condition | 2020-02-08T18:26:42.258658+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 49223 | 41608 | ice_skating_field_condition | 2020-12-31T10:17:20.650223+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7543 | 41617 | ice_skating_field_condition | 2020-02-10T16:41:39.413935+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 | ||||
| 37525 | 41657 | ice_skating_field_condition | 2020-11-28T01:29:26.671925+0200 | 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 | ||||
| 6030 | 41770 | ice_skating_field_condition | 2019-11-12T09:21:57.649587+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 );