observation
16 rows where quality = "unusable" and value = 4
This data as json, CSV (advanced)
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
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 );