observation

12 rows where name_sv = "Rikligt med blågröna alger" and unit = 40142

✎ View and edit SQL

This data as json, CSV (advanced)

unit ✖

  • 40142 · 12 ✖

primary ✖

  • 1 12

name_sv ✖

  • Rikligt med blågröna alger · 12 ✖
id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
3635 40142 swimming_water_cyanobacteria 2019-07-21T10:14:38.593823+0300 2019-07-22T10:14:38.593823+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3863 40142 swimming_water_cyanobacteria 2019-07-23T10:10:55.759535+0300 2019-07-24T10:10:55.759535+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3874 40142 swimming_water_cyanobacteria 2019-07-23T10:15:46.013259+0300 2019-07-24T10:15:46.013259+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3971 40142 swimming_water_cyanobacteria 2019-07-24T10:05:28.100468+0300 2019-07-25T10:05:28.100468+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
4503 40142 swimming_water_cyanobacteria 2019-07-28T10:07:57.917329+0300 2019-07-29T10:07:57.917329+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
4507 40142 swimming_water_cyanobacteria 2019-07-28T10:15:52.545486+0300 2019-07-29T10:15:52.545486+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
10036 40142 swimming_water_cyanobacteria 2020-06-24T10:02:47.066598+0300 2020-06-25T10:02:47.066598+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
13209 40142 swimming_water_cyanobacteria 2020-08-05T09:50:45.324900+0300 2020-08-06T09:50:45.324900+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
13289 40142 swimming_water_cyanobacteria 2020-08-06T09:52:45.996810+0300 2020-08-07T09:52:45.996810+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
13380 40142 swimming_water_cyanobacteria 2020-08-07T09:57:20.324432+0300 2020-08-08T09:57:20.324432+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
13452 40142 swimming_water_cyanobacteria 2020-08-08T10:13:52.400163+0300 2020-08-09T10:13:52.400163+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
13507 40142 swimming_water_cyanobacteria 2020-08-09T10:57:03.161826+0300 2020-08-10T10:57:03.161826+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
);