observation
419 rows where name_en = "Closed" sorted by name_sv
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 );