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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6851 | 60871 | ski_trail_condition | 2020-01-15T21:21:28.793075+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 | ||||
| 6944 | 57401 | ski_trail_condition | 2020-01-20T07:28:16.861669+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 6968 | 57401 | ski_trail_condition | 2020-01-21T07:42:56.154863+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 | ||||
| 7004 | 57401 | ski_trail_condition | 2020-01-22T11:52:35.516849+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 | ||||
| 7148 | 57401 | ski_trail_condition | 2020-01-30T07:53:16.005259+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 | ||||
| 7214 | 57401 | ski_trail_condition | 2020-02-03T06:17:34.357296+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 | ||||
| 7425 | 40252 | ice_skating_field_condition | 2020-02-08T06:44:07.569203+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7457 | 42249 | ice_skating_field_condition | 2020-02-08T15:16:27.259281+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 | ||||
| 7468 | 42034 | ice_skating_field_condition | 2020-02-08T18:10:04.844933+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 | ||||
| 7471 | 41568 | ice_skating_field_condition | 2020-02-08T18:26:42.258658+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 | ||||
| 7474 | 50354 | ice_skating_field_condition | 2020-02-09T07:02:02.233897+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 | ||||
| 7480 | 40934 | ice_skating_field_condition | 2020-02-09T09:03:04.306886+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7488 | 42825 | ice_skating_field_condition | 2020-02-09T10:39:37.330025+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7498 | 41994 | ice_skating_field_condition | 2020-02-09T13:16:01.654370+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 | ||||
| 7509 | 40059 | ice_skating_field_condition | 2020-02-09T20:44:37.212732+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7514 | 50354 | ice_skating_field_condition | 2020-02-10T07:20:56.678885+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7518 | 42111 | ice_skating_field_condition | 2020-02-10T08:04:14.945553+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7519 | 51451 | ice_skating_field_condition | 2020-02-10T08:04:50.180581+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 | ||||
| 7528 | 40421 | ice_skating_field_condition | 2020-02-10T10:41:49.511748+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 | ||||
| 7530 | 50605 | ice_skating_field_condition | 2020-02-10T11:46:57.854857+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 | ||||
| 7532 | 42241 | ice_skating_field_condition | 2020-02-10T11:52:50.276109+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7533 | 42128 | ice_skating_field_condition | 2020-02-10T11:53:27.994054+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7539 | 42511 | ice_skating_field_condition | 2020-02-10T14:35:09.110896+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7540 | 42920 | ice_skating_field_condition | 2020-02-10T14:36:28.919266+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 | ||||
| 7542 | 40026 | ice_skating_field_condition | 2020-02-10T16:40:56.385667+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 | ||||
| 7550 | 61464 | ice_skating_field_condition | 2020-02-10T20:16:20.584999+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7554 | 61464 | ice_skating_field_condition | 2020-02-11T07:37:36.431449+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7567 | 42076 | ice_skating_field_condition | 2020-02-11T14:53:46.513110+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 | ||||
| 7570 | 39911 | ice_skating_field_condition | 2020-02-11T14:55:43.652887+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 | ||||
| 7583 | 53523 | ice_skating_field_condition | 2020-02-12T07:58:36.734738+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7584 | 53524 | ice_skating_field_condition | 2020-02-12T07:58:42.334287+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7671 | 47279 | ice_skating_field_condition | 2020-02-15T16:05:18.362810+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7673 | 53523 | ice_skating_field_condition | 2020-02-15T16:58:10.155059+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7674 | 53524 | ice_skating_field_condition | 2020-02-15T16:58:18.127596+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7678 | 61464 | ice_skating_field_condition | 2020-02-16T07:58:42.108605+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7679 | 53523 | ice_skating_field_condition | 2020-02-16T08:14:05.972075+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7680 | 53524 | ice_skating_field_condition | 2020-02-16T08:14:15.342173+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 | ||||
| 7701 | 41770 | ice_skating_field_condition | 2020-02-17T07:25:20.559373+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7702 | 42185 | ice_skating_field_condition | 2020-02-17T07:25:28.272144+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7703 | 53523 | ice_skating_field_condition | 2020-02-17T07:38:13.856107+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7704 | 53524 | ice_skating_field_condition | 2020-02-17T07:38:29.423526+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7705 | 57401 | ski_trail_condition | 2020-02-17T08:07:04.921319+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7710 | 53523 | ice_skating_field_condition | 2020-02-17T11:02:52.531067+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7715 | 53523 | ice_skating_field_condition | 2020-02-18T07:42:22.813577+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7716 | 53524 | ice_skating_field_condition | 2020-02-18T07:43:07.778862+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7717 | 42185 | ice_skating_field_condition | 2020-02-18T07:49:11.647081+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7718 | 41770 | ice_skating_field_condition | 2020-02-18T07:49:17.858157+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7722 | 54329 | ski_trail_condition | 2020-02-18T08:59:23.362541+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7765 | 53523 | ice_skating_field_condition | 2020-02-19T14:26:27.440425+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7766 | 53524 | ice_skating_field_condition | 2020-02-19T14:42:41.284687+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7799 | 53523 | ice_skating_field_condition | 2020-02-21T08:46:46.916180+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7800 | 53524 | ice_skating_field_condition | 2020-02-21T08:48:24.353486+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7809 | 61464 | ice_skating_field_condition | 2020-02-22T07:29:15.403732+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7811 | 53524 | ice_skating_field_condition | 2020-02-22T08:04:02.130767+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7812 | 53523 | ice_skating_field_condition | 2020-02-22T08:04:27.427321+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7813 | 47279 | ice_skating_field_condition | 2020-02-22T08:09:46.238559+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 | ||||
| 7823 | 41770 | ice_skating_field_condition | 2020-02-22T13:48:52.545599+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 7824 | 42185 | ice_skating_field_condition | 2020-02-22T13:48:58.557258+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 |
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 );