16 rows where quality = "unusable" and value = 4

View and edit SQL

Suggested facets: unit

id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
10509 39289 swimming_water_cyanobacteria 2020-06-29T16:13:42.739443+0300 2020-06-30T16:13:42.739443+0300   Suljettu muusta syystä   Stängd av andra skäl 1 Closed for other reasons 4 unusable  
11003 39289 swimming_water_cyanobacteria 2020-07-07T10:22:26.230362+0300 2020-07-08T10:22:26.230362+0300   Suljettu muusta syystä   Stängd av andra skäl 1 Closed for other reasons 4 unusable  
11235 39289 swimming_water_cyanobacteria 2020-07-10T14:00:25.303945+0300 2020-07-11T14:00:25.303945+0300   Suljettu muusta syystä   Stängd av andra skäl 1 Closed for other reasons 4 unusable  
11491 39289 swimming_water_cyanobacteria 2020-07-14T11:56:32.224951+0300 2020-07-15T11:56:32.224951+0300   Suljettu muusta syystä   Stängd av andra skäl 1 Closed for other reasons 4 unusable  
12563 52959 swimming_water_cyanobacteria 2020-07-28T10:21:23.742491+0300 2020-07-29T10:21:23.742491+0300   Suljettu muusta syystä   Stängd av andra skäl 1 Closed for other reasons 4 unusable  
13174 39815 swimming_water_cyanobacteria 2020-08-04T16:23:46.225883+0300 2020-08-05T16:23:46.225883+0300   Suljettu muusta syystä   Stängd av andra skäl 1 Closed for other reasons 4 unusable  
13179 39815 swimming_water_cyanobacteria 2020-08-04T19:43:03.053973+0300 2020-08-05T19:43:03.053973+0300   Suljettu muusta syystä   Stängd av andra skäl 1 Closed for other reasons 4 unusable  
13211 39815 swimming_water_cyanobacteria 2020-08-05T09:57:30.692872+0300 2020-08-06T09:57:30.692872+0300   Suljettu muusta syystä   Stängd av andra skäl 1 Closed for other reasons 4 unusable  
13253 39815 swimming_water_cyanobacteria 2020-08-05T13:45:13.790535+0300 2020-08-06T13:45:13.790535+0300   Suljettu muusta syystä   Stängd av andra skäl 1 Closed for other reasons 4 unusable  
13261 39815 swimming_water_cyanobacteria 2020-08-05T17:49:06.308516+0300 2020-08-06T17:49:06.308516+0300   Suljettu muusta syystä   Stängd av andra skäl 1 Closed for other reasons 4 unusable  
13273 39815 swimming_water_cyanobacteria 2020-08-06T08:30:28.755028+0300 2020-08-07T08:30:28.755028+0300   Suljettu muusta syystä   Stängd av andra skäl 1 Closed for other reasons 4 unusable  
13286 39815 swimming_water_cyanobacteria 2020-08-06T09:51:23.655110+0300 2020-08-07T09:51:23.655110+0300   Suljettu muusta syystä   Stängd av andra skäl 1 Closed for other reasons 4 unusable  
13337 39815 swimming_water_cyanobacteria 2020-08-06T14:00:21.173605+0300 2020-08-07T14:00:21.173605+0300   Suljettu muusta syystä   Stängd av andra skäl 1 Closed for other reasons 4 unusable  
13346 39815 swimming_water_cyanobacteria 2020-08-06T19:38:11.067575+0300 2020-08-07T19:38:11.067575+0300   Suljettu muusta syystä   Stängd av andra skäl 1 Closed for other reasons 4 unusable  
13370 39815 swimming_water_cyanobacteria 2020-08-07T09:14:52.727749+0300 2020-08-08T09:14:52.727749+0300   Suljettu muusta syystä   Stängd av andra skäl 1 Closed for other reasons 4 unusable  
13409 39815 swimming_water_cyanobacteria 2020-08-07T13:55:59.849356+0300 2020-08-08T13:55:59.849356+0300   Suljettu muusta syystä   Stängd av andra skäl 1 Closed for other reasons 4 unusable  

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