observation

10 rows where unit = 39693 and value = 2

✎ View and edit SQL

This data as json, CSV (advanced)

value ✖

unit ✖

  • 39693 · 10 ✖
id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
3661 39693 swimming_water_cyanobacteria 2019-07-21T11:30:23.806478+0300 2019-07-22T11:30:23.806478+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3667 39693 swimming_water_cyanobacteria 2019-07-21T13:44:56.048505+0300 2019-07-22T13:44:56.048505+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3690 39693 swimming_water_cyanobacteria 2019-07-21T17:30:20.842783+0300 2019-07-22T17:30:20.842783+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3757 39693 swimming_water_cyanobacteria 2019-07-22T09:35:17.056241+0300 2019-07-23T09:35:17.056241+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3818 39693 swimming_water_cyanobacteria 2019-07-22T18:07:27.941291+0300 2019-07-23T18:07:27.941291+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3910 39693 swimming_water_cyanobacteria 2019-07-23T11:11:45.473255+0300 2019-07-24T11:11:45.473255+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
13637 39693 swimming_water_cyanobacteria 2020-08-12T10:11:46.049455+0300 2020-08-13T10:11:46.049455+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
13662 39693 swimming_water_cyanobacteria 2020-08-12T14:02:47.587146+0300 2020-08-13T14:02:47.587146+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
13669 39693 swimming_water_cyanobacteria 2020-08-12T14:08:48.941251+0300 2020-08-13T14:08:48.941251+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
13905 39693 swimming_water_cyanobacteria 2020-08-18T11:54:28.199001+0300 2020-08-19T11:54:28.199001+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
);