419 rows where quality = "unusable" and value = "closed"

View and edit SQL

Suggested facets: property

id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
5987 42852 ice_skating_field_condition 2019-09-07T18:40:27.198231+0300     Suljettu   Stängd 1 Closed closed unusable  
5989 41976 ice_skating_field_condition 2019-09-11T07:24:08.373689+0300     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  
6014 42185 ice_skating_field_condition 2019-11-07T09:58:40.112027+0200     Suljettu   Stängd 1 Closed closed unusable  
6026 53615 ice_skating_field_condition 2019-11-11T16:09:42.262419+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  
6042 53524 ice_skating_field_condition 2019-11-14T14:00:38.837026+0200     Suljettu   Stängd 1 Closed closed unusable  
6043 53523 ice_skating_field_condition 2019-11-14T14:01:03.454848+0200     Suljettu   Stängd 1 Closed closed unusable  
6052 53563 ice_skating_field_condition 2019-11-17T09:56:26.450995+0200     Suljettu   Stängd 1 Closed closed unusable  
6062 53563 ice_skating_field_condition 2019-11-18T11:54:30.323399+0200     Suljettu   Stängd 1 Closed closed unusable  
6067 53615 ice_skating_field_condition 2019-11-19T14:49:25.099218+0200     Suljettu   Stängd 1 Closed closed unusable  
6074 53524 ice_skating_field_condition 2019-11-22T12:50:21.925939+0200     Suljettu   Stängd 1 Closed closed unusable  
6075 53523 ice_skating_field_condition 2019-11-22T12:50:42.715838+0200     Suljettu   Stängd 1 Closed closed unusable  
6079 53563 ice_skating_field_condition 2019-11-23T08:56:25.190468+0200     Suljettu   Stängd 1 Closed closed unusable  
6084 47279 ice_skating_field_condition 2019-11-23T15:54:15.448380+0200     Suljettu   Stängd 1 Closed closed unusable  
6087 53563 ice_skating_field_condition 2019-11-24T08:54:42.027456+0200     Suljettu   Stängd 1 Closed closed unusable  
6094 53524 ice_skating_field_condition 2019-11-25T06:32:50.409420+0200     Suljettu   Stängd 1 Closed closed unusable  
6095 53523 ice_skating_field_condition 2019-11-25T06:32:57.544183+0200     Suljettu   Stängd 1 Closed closed unusable  
6099 53523 ice_skating_field_condition 2019-11-25T09:05:57.015330+0200     Suljettu   Stängd 1 Closed closed unusable  
6100 53524 ice_skating_field_condition 2019-11-25T09:06:08.220871+0200     Suljettu   Stängd 1 Closed closed unusable  
6111 53563 ice_skating_field_condition 2019-11-25T11:05:54.025272+0200     Suljettu   Stängd 1 Closed closed unusable  
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  
6181 53710 ski_trail_condition 2019-11-30T11:25:11.706636+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  
6332 51028 ski_trail_condition 2019-12-11T07:56:35.444857+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  
6684 51028 ski_trail_condition 2020-01-05T16:58:24.715481+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  
6736 60871 ski_trail_condition 2020-01-09T14:32:15.463464+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  
6752 57401 ski_trail_condition 2020-01-10T15:45:43.284338+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  

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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
);