observation

17 rows where name_en = "Plenty of cyanobacteria" and unit = 39568

✎ View and edit SQL

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
2543 39568 swimming_water_cyanobacteria 2019-07-08T13:52:22.765700+0300 2019-07-09T13:52:22.765700+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3076 39568 swimming_water_cyanobacteria 2019-07-15T11:17:07.449470+0300 2019-07-16T11:17:07.449470+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3328 39568 swimming_water_cyanobacteria 2019-07-18T10:33:42.682304+0300 2019-07-19T10:33:42.682304+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3613 39568 swimming_water_cyanobacteria 2019-07-21T08:42:23.736159+0300 2019-07-22T08:42:23.736159+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3703 39568 swimming_water_cyanobacteria 2019-07-21T19:59:13.334056+0300 2019-07-22T19:59:13.334056+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3730 39568 swimming_water_cyanobacteria 2019-07-22T08:16:08.894946+0300 2019-07-23T08:16:08.894946+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3732 39568 swimming_water_cyanobacteria 2019-07-22T08:16:18.899205+0300 2019-07-23T08:16:18.899205+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3807 39568 swimming_water_cyanobacteria 2019-07-22T14:23:09.247433+0300 2019-07-23T14:23:09.247433+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3825 39568 swimming_water_cyanobacteria 2019-07-22T19:13:11.853299+0300 2019-07-23T19:13:11.853299+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3866 39568 swimming_water_cyanobacteria 2019-07-23T10:13:07.974389+0300 2019-07-24T10:13:07.974389+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
4493 39568 swimming_water_cyanobacteria 2019-07-28T08:44:55.677123+0300 2019-07-29T08:44:55.677123+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
4572 39568 swimming_water_cyanobacteria 2019-07-28T19:52:15.726425+0300 2019-07-29T19:52:15.726425+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
5728 39568 swimming_water_cyanobacteria 2019-08-10T11:20:09.329098+0300 2019-08-11T11:20:09.329098+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
9592 39568 swimming_water_cyanobacteria 2020-06-17T11:08:43.389887+0300 2020-06-18T11:08:43.389887+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
9640 39568 swimming_water_cyanobacteria 2020-06-18T09:35:17.086184+0300 2020-06-19T09:35:17.086184+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
13372 39568 swimming_water_cyanobacteria 2020-08-07T09:25:50.150616+0300 2020-08-08T09:25:50.150616+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
13433 39568 swimming_water_cyanobacteria 2020-08-08T09:43:17.684005+0300 2020-08-09T09:43:17.684005+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 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
);