observation

5 rows where name_sv = "Rikligt med blågröna alger" and unit = 53476

✎ View and edit SQL

This data as json, CSV (advanced)

unit ✖

  • 53476 · 5 ✖

primary ✖

  • 1 5

name_sv ✖

  • Rikligt med blågröna alger · 5 ✖
id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
3232 53476 swimming_water_cyanobacteria 2019-07-17T13:17:49.315487+0300 2019-07-18T13:17:49.315487+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3375 53476 swimming_water_cyanobacteria 2019-07-18T15:11:15.775281+0300 2019-07-19T15:11:15.775281+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
4129 53476 swimming_water_cyanobacteria 2019-07-25T10:27:30.793844+0300 2019-07-26T10:27:30.793844+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
4229 53476 swimming_water_cyanobacteria 2019-07-26T08:52:28.437426+0300 2019-07-27T08:52:28.437426+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
5385 53476 swimming_water_cyanobacteria 2019-08-06T10:34:59.694304+0300 2019-08-07T10:34:59.694304+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
);