observation
419 rows where name_sv = "Stängd"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7826 | 53563 | ice_skating_field_condition | 2020-02-22T17:01:06.969604+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7830 | 42593 | ice_skating_field_condition | 2020-02-23T07:54:02.426492+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7831 | 53090 | ice_skating_field_condition | 2020-02-23T07:54:08.897207+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7832 | 42644 | ice_skating_field_condition | 2020-02-23T07:54:16.459540+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7833 | 42553 | ice_skating_field_condition | 2020-02-23T07:54:26.108383+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7834 | 42542 | ice_skating_field_condition | 2020-02-23T07:54:33.855200+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7835 | 42419 | ice_skating_field_condition | 2020-02-23T07:54:43.150709+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7840 | 57401 | ski_trail_condition | 2020-02-24T16:18:08.691121+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7845 | 58433 | ice_skating_field_condition | 2020-02-24T18:35:29.460655+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 | ||||
| 7878 | 40493 | ice_skating_field_condition | 2020-02-25T15:19:00.435231+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 | ||||
| 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 | ||||
| 7972 | 40970 | ice_skating_field_condition | 2020-02-29T15:00:36.462423+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8002 | 61464 | ice_skating_field_condition | 2020-03-01T18:41:16.245570+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8003 | 61464 | ice_skating_field_condition | 2020-03-02T07:35:45.738734+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8020 | 53523 | ice_skating_field_condition | 2020-03-02T14:37:42.334675+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8021 | 53524 | ice_skating_field_condition | 2020-03-02T14:37:47.825728+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8057 | 50354 | ice_skating_field_condition | 2020-03-04T12:04:10.647704+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8060 | 61464 | ice_skating_field_condition | 2020-03-04T15:08:14.828629+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 | ||||
| 8110 | 61464 | ice_skating_field_condition | 2020-03-06T17:14:50.319009+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 | ||||
| 8151 | 61464 | ice_skating_field_condition | 2020-03-09T07:54:29.008951+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 | ||||
| 8168 | 61464 | ice_skating_field_condition | 2020-03-10T07:59:45.499112+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8169 | 61464 | ice_skating_field_condition | 2020-03-10T07:59:54.255286+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8171 | 43205 | ice_skating_field_condition | 2020-03-10T08:14:50.586311+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8177 | 42699 | ice_skating_field_condition | 2020-03-10T08:55:23.461797+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 | ||||
| 8179 | 41770 | ice_skating_field_condition | 2020-03-10T12:30:26.009418+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8180 | 42185 | ice_skating_field_condition | 2020-03-10T12:30:35.757221+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8183 | 53524 | ice_skating_field_condition | 2020-03-10T14:48:18.394968+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8184 | 53523 | ice_skating_field_condition | 2020-03-10T14:48:22.902809+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 | ||||
| 8201 | 41549 | ice_skating_field_condition | 2020-03-12T11:10:51.330922+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8204 | 53523 | ice_skating_field_condition | 2020-03-12T14:13:22.706403+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8205 | 53524 | ice_skating_field_condition | 2020-03-12T14:13:28.598400+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8208 | 46144 | ice_skating_field_condition | 2020-03-13T00:24:59.764754+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8209 | 42852 | ice_skating_field_condition | 2020-03-13T00:25:09.519806+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8210 | 42852 | ice_skating_field_condition | 2020-03-13T00:25:27.027741+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8211 | 42526 | ice_skating_field_condition | 2020-03-13T00:25:37.663687+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8248 | 53563 | ice_skating_field_condition | 2020-03-15T16:09:54.990079+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8249 | 46144 | ice_skating_field_condition | 2020-03-15T18:03:10.660681+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8250 | 42852 | ice_skating_field_condition | 2020-03-15T18:03:19.960490+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8251 | 42526 | ice_skating_field_condition | 2020-03-15T18:03:25.353122+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8252 | 42699 | ice_skating_field_condition | 2020-03-15T18:03:45.945732+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8259 | 53523 | ice_skating_field_condition | 2020-03-16T07:22:24.563026+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8260 | 53524 | ice_skating_field_condition | 2020-03-16T07:22:37.692239+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 | ||||
| 8274 | 39834 | ice_skating_field_condition | 2020-03-16T20:40:52.980568+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8275 | 53563 | ice_skating_field_condition | 2020-03-16T20:41:11.151092+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 | ||||
| 8277 | 47279 | ice_skating_field_condition | 2020-03-16T20:42:55.401835+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8299 | 42185 | ice_skating_field_condition | 2020-03-18T14:19:21.563988+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8302 | 41770 | ice_skating_field_condition | 2020-03-18T14:20:21.397877+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8305 | 41770 | ice_skating_field_condition | 2020-03-18T14:21:04.534989+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8308 | 53523 | ice_skating_field_condition | 2020-03-19T14:39:43.937007+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8309 | 53524 | ice_skating_field_condition | 2020-03-19T14:40:23.316417+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8321 | 47279 | ice_skating_field_condition | 2020-03-20T08:34:19.953997+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8330 | 53523 | ice_skating_field_condition | 2020-03-21T14:42:21.194885+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8331 | 53524 | ice_skating_field_condition | 2020-03-21T14:42:29.588941+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8334 | 53524 | ice_skating_field_condition | 2020-03-22T07:01:21.182531+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8335 | 53523 | ice_skating_field_condition | 2020-03-22T07:01:28.542964+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8345 | 57401 | ski_trail_condition | 2020-03-23T06:57:22.601868+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8346 | 53563 | ice_skating_field_condition | 2020-03-23T07:56:22.582450+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 | ||||
| 8350 | 53710 | ski_trail_condition | 2020-03-23T10:30:24.232670+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 | ||||
| 8353 | 53615 | ice_skating_field_condition | 2020-03-24T10:54:05.487564+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8356 | 60871 | ski_trail_condition | 2020-03-25T07:49:14.730651+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 27694 | 53524 | ice_skating_field_condition | 2020-10-26T09:06:07.413936+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 27695 | 53523 | ice_skating_field_condition | 2020-10-26T09:06:24.730850+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 | ||||
| 30096 | 53523 | ice_skating_field_condition | 2020-11-03T08:05:13.146477+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 30097 | 53524 | ice_skating_field_condition | 2020-11-03T08:05:37.245801+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 32205 | 53524 | ice_skating_field_condition | 2020-11-10T09:28:45.118590+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 32206 | 53523 | ice_skating_field_condition | 2020-11-10T09:28:52.236093+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 33148 | 53524 | ice_skating_field_condition | 2020-11-13T12:33:54.122995+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 33149 | 53523 | ice_skating_field_condition | 2020-11-13T12:34:01.776074+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 33744 | 56438 | ice_skating_field_condition | 2020-11-15T11:34:03.347612+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34054 | 53524 | ice_skating_field_condition | 2020-11-16T11:37:32.532454+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34055 | 53523 | ice_skating_field_condition | 2020-11-16T11:37:39.677144+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34377 | 53524 | ice_skating_field_condition | 2020-11-17T12:11:29.220392+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34378 | 53523 | ice_skating_field_condition | 2020-11-17T12:11:36.795328+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 | ||||
| 34671 | 42699 | ice_skating_field_condition | 2020-11-18T10:43:48.038297+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34789 | 53615 | ice_skating_field_condition | 2020-11-18T20:01:43.429391+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34914 | 53615 | ice_skating_field_condition | 2020-11-19T06:25:36.478708+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34927 | 42699 | ice_skating_field_condition | 2020-11-19T07:22:40.046370+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 | ||||
| 34939 | 53524 | ice_skating_field_condition | 2020-11-19T08:10:41.768596+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34940 | 53523 | ice_skating_field_condition | 2020-11-19T08:10:50.171226+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34961 | 46144 | ice_skating_field_condition | 2020-11-19T10:44:38.537134+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34966 | 42852 | ice_skating_field_condition | 2020-11-19T11:14:40.715222+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34967 | 42526 | ice_skating_field_condition | 2020-11-19T11:14:53.612228+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 35252 | 46144 | ice_skating_field_condition | 2020-11-20T11:59:05.787206+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 |
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 );