observation

4 rows where name_sv = "Mycket rikligt med blågröna alger" and unit = 39568

✎ View and edit SQL

This data as json, CSV (advanced)

unit ✖

  • 39568 · 4 ✖

primary ✖

  • 1 4

name_sv ✖

  • Mycket rikligt med blågröna alger · 4 ✖
id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
3660 39568 swimming_water_cyanobacteria 2019-07-21T11:06:31.177030+0300 2019-07-22T11:06:31.177030+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
3673 39568 swimming_water_cyanobacteria 2019-07-21T13:58:13.445019+0300 2019-07-22T13:58:13.445019+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
3923 39568 swimming_water_cyanobacteria 2019-07-23T14:24:35.279389+0300 2019-07-24T14:24:35.279389+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
8852 39568 swimming_water_cyanobacteria 2020-06-08T09:59:57.643835+0300 2020-06-09T09:59:57.643835+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 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
);