observation

8 rows where name_sv = "Rikligt med blågröna alger" and unit = 41960

✎ View and edit SQL

This data as json, CSV (advanced)

unit ✖

  • 41960 · 8 ✖

primary ✖

  • 1 8

name_sv ✖

  • Rikligt med blågröna alger · 8 ✖
id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
2921 41960 swimming_water_cyanobacteria 2019-07-13T13:44:47.553639+0300 2019-07-14T13:44:47.553639+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2970 41960 swimming_water_cyanobacteria 2019-07-14T10:07:42.028632+0300 2019-07-15T10:07:42.028632+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3037 41960 swimming_water_cyanobacteria 2019-07-15T10:01:08.707444+0300 2019-07-16T10:01:08.707444+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3777 41960 swimming_water_cyanobacteria 2019-07-22T10:08:24.492906+0300 2019-07-23T10:08:24.492906+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3846 41960 swimming_water_cyanobacteria 2019-07-23T09:57:26.301117+0300 2019-07-24T09:57:26.301117+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
4097 41960 swimming_water_cyanobacteria 2019-07-25T10:02:08.741469+0300 2019-07-26T10:02:08.741469+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
4098 41960 swimming_water_cyanobacteria 2019-07-25T10:02:09.822372+0300 2019-07-26T10:02:09.822372+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
4299 41960 swimming_water_cyanobacteria 2019-07-26T10:51:29.897146+0300 2019-07-27T10:51:29.897146+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
);