observation

51,120 rows

✎ View and edit SQL

This data as json, CSV (advanced)

value ✖

id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
10169 39693 swimming_water_cyanobacteria 2020-06-25T14:42:14.689968+0300 2020-06-26T14:42:14.689968+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
10170 50549 swimming_water_temperature 2020-06-25T15:52:31.200307+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10171 50549 swimming_water_cyanobacteria 2020-06-25T15:52:45.024865+0300 2020-06-26T15:52:45.024865+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
10172 50549 notice 2020-06-25T15:53:53.951492+0300   Uiminen ei ole suositeltavaa bakteeripitoisuuden vuoksi.                
10173 39583 swimming_water_temperature 2020-06-25T17:41:09.153987+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10174 39583 swimming_water_cyanobacteria 2020-06-25T17:41:17.123820+0300 2020-06-26T17:41:17.123820+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
10175 39583 notice 2020-06-25T17:41:19.553325+0300   Valvontaa rannalla klo 10-18 joka päivä 16.8 saakka, tervetuloa.                
10176 39583 notice 2020-06-25T17:41:21.265985+0300   Valvontaa rannalla klo 10-18 joka päivä 16.8 saakka, tervetuloa.                
10177 39815 swimming_water_temperature 2020-06-25T17:47:30.990529+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10178 39815 swimming_water_cyanobacteria 2020-06-25T17:47:41.742066+0300 2020-06-26T17:47:41.742066+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
10179 39322 swimming_water_temperature 2020-06-25T18:01:40.262239+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10180 39322 swimming_water_cyanobacteria 2020-06-25T18:01:42.923454+0300 2020-06-26T18:01:42.923454+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
10181 39693 swimming_water_cyanobacteria 2020-06-25T18:14:26.035870+0300 2020-06-26T18:14:26.035870+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
10182 39693 swimming_water_temperature 2020-06-25T18:14:31.169484+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10183 39412 swimming_water_temperature 2020-06-26T07:46:47.454136+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10184 39412 swimming_water_cyanobacteria 2020-06-26T07:46:50.479049+0300 2020-06-27T07:46:50.479049+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
10185 39823 swimming_water_temperature 2020-06-26T08:13:26.816401+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10186 39823 swimming_water_cyanobacteria 2020-06-26T08:13:30.171717+0300 2020-06-27T08:13:30.171717+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
10187 53461 swimming_water_temperature 2020-06-26T08:27:37.049054+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10188 53461 swimming_water_cyanobacteria 2020-06-26T08:27:39.905332+0300 2020-06-27T08:27:39.905332+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
10189 39606 swimming_water_temperature 2020-06-26T08:40:14.181018+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10190 39606 swimming_water_cyanobacteria 2020-06-26T08:40:16.712836+0300 2020-06-27T08:40:16.712836+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
10191 39902 swimming_water_temperature 2020-06-26T08:50:42.770143+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10192 39902 swimming_water_cyanobacteria 2020-06-26T08:50:45.646340+0300 2020-06-27T08:50:45.646340+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
10193 39527 swimming_water_temperature 2020-06-26T08:57:46.712559+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10194 39527 swimming_water_cyanobacteria 2020-06-26T08:57:49.994877+0300 2020-06-27T08:57:49.994877+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
10195 39875 swimming_water_temperature 2020-06-26T09:04:02.470190+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10196 40157 swimming_water_temperature 2020-06-26T09:53:55.214804+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10197 40157 notice 2020-06-26T09:54:01.973693+0300   Valvonta rannalla joka päivä klo 10-18 11.8.2020 asti. Tervetuloa ☀                
10198 40157 swimming_water_cyanobacteria 2020-06-26T09:54:29.255548+0300 2020-06-27T09:54:29.255548+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
10199 40142 swimming_water_cyanobacteria 2020-06-26T09:55:17.425870+0300 2020-06-27T09:55:17.425870+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
10200 40142 swimming_water_temperature 2020-06-26T09:56:48.346620+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10201 40559 swimming_water_cyanobacteria 2020-06-26T09:57:09.284564+0300 2020-06-27T09:57:09.284564+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
10202 40559 swimming_water_temperature 2020-06-26T09:57:13.108413+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10203 41791 swimming_water_temperature 2020-06-26T10:03:48.535123+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10204 41791 swimming_water_cyanobacteria 2020-06-26T10:03:52.738492+0300 2020-06-27T10:03:52.738492+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
10205 41960 swimming_water_temperature 2020-06-26T10:04:07.699509+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10206 41960 swimming_water_cyanobacteria 2020-06-26T10:04:10.134926+0300 2020-06-27T10:04:10.134926+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
10207 40258 swimming_water_temperature 2020-06-26T10:05:26.533280+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
10208 39815 swimming_water_temperature 2020-06-26T10:05:31.710623+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10209 39815 swimming_water_cyanobacteria 2020-06-26T10:05:37.244499+0300 2020-06-27T10:05:37.244499+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
10210 40258 swimming_water_cyanobacteria 2020-06-26T10:06:36.812052+0300 2020-06-27T10:06:36.812052+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
10211 40386 swimming_water_temperature 2020-06-26T10:10:18.485002+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10212 40386 swimming_water_cyanobacteria 2020-06-26T10:10:21.230296+0300 2020-06-27T10:10:21.230296+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
10213 39875 swimming_water_temperature 2020-06-26T10:17:48.918616+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10214 39875 swimming_water_cyanobacteria 2020-06-26T10:17:52.493962+0300 2020-06-27T10:17:52.493962+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
10215 39713 swimming_water_temperature 2020-06-26T10:18:02.987936+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10216 39713 swimming_water_cyanobacteria 2020-06-26T10:18:08.745911+0300 2020-06-27T10:18:08.745911+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
10217 39583 swimming_water_temperature 2020-06-26T10:21:42.346187+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10218 39583 swimming_water_cyanobacteria 2020-06-26T10:21:44.793260+0300 2020-06-27T10:21:44.793260+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
10219 39583 notice 2020-06-26T10:21:49.492728+0300   Valvontaa rannalla klo 10-18 joka päivä 16.8 saakka, tervetuloa.                
10220 39693 swimming_water_temperature 2020-06-26T10:23:44.683113+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10221 39693 swimming_water_cyanobacteria 2020-06-26T10:23:48.202464+0300 2020-06-27T10:23:48.202464+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
10222 39693 notice 2020-06-26T10:23:51.685498+0300   Valvontaa rannalla klo 8-20 joka päivä 16.8 saakka, tervetuloa.                
10223 39322 swimming_water_temperature 2020-06-26T10:24:09.487236+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10224 39322 swimming_water_cyanobacteria 2020-06-26T10:24:20.153206+0300 2020-06-27T10:24:20.153206+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
10225 40150 swimming_water_temperature 2020-06-26T10:27:47.047074+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10226 40150 swimming_water_cyanobacteria 2020-06-26T10:27:51.787570+0300 2020-06-27T10:27:51.787570+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
10227 40150 notice 2020-06-26T10:27:54.067191+0300   Valvonta rannalla joka päivä 10-18.                
10228 39568 swimming_water_temperature 2020-06-26T10:36:53.152495+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10229 39568 swimming_water_cyanobacteria 2020-06-26T10:36:56.301764+0300 2020-06-27T10:36:56.301764+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
10230 41601 swimming_water_temperature 2020-06-26T10:45:43.032483+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10231 41601 swimming_water_cyanobacteria 2020-06-26T10:49:12.965639+0300 2020-06-27T10:49:12.965639+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
10232 41601 swimming_water_cyanobacteria 2020-06-26T11:03:33.261842+0300 2020-06-27T11:03:33.261842+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
10233 40802 swimming_water_temperature 2020-06-26T11:06:13.345122+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10234 40802 swimming_water_cyanobacteria 2020-06-26T11:06:17.299228+0300 2020-06-27T11:06:17.299228+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
10235 41047 season_status 2020-06-26T11:29:54.733944+0300     Kausi käynnissä   Säsongen igång 1 Season underway started good  
10236 40823 season_status 2020-06-26T11:30:20.418561+0300     Kausi käynnissä   Säsongen igång 1 Season underway started good  
10237 40950 swimming_water_temperature 2020-06-26T11:48:53.535793+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10238 40950 swimming_water_cyanobacteria 2020-06-26T11:48:57.938539+0300 2020-06-27T11:48:57.938539+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
10239 52959 swimming_water_temperature 2020-06-26T12:16:47.575496+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10240 52959 swimming_water_cyanobacteria 2020-06-26T12:17:02.819121+0300 2020-06-27T12:17:02.819121+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
10241 52959 notice 2020-06-26T12:17:07.447274+0300   Huom! Sinilevää havaittu!Valvontaa rannalla joka päivä klo 10-18 aina 16.8. saakka, tervetuloa!                
10242 41907 swimming_water_cyanobacteria 2020-06-26T13:32:52.097894+0300 2020-06-27T13:32:52.097894+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
10243 41907 swimming_water_temperature 2020-06-26T13:32:54.541118+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10244 39910 swimming_water_temperature 2020-06-26T13:33:10.784146+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10245 39910 swimming_water_cyanobacteria 2020-06-26T13:33:13.135380+0300 2020-06-27T13:33:13.135380+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
10246 41031 swimming_water_cyanobacteria 2020-06-26T13:33:36.882011+0300 2020-06-27T13:33:36.882011+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
10247 41031 swimming_water_temperature 2020-06-26T13:33:38.711101+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10248 40921 swimming_water_temperature 2020-06-26T13:33:56.792485+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10249 40921 swimming_water_cyanobacteria 2020-06-26T13:33:59.077580+0300 2020-06-27T13:33:59.077580+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
10250 40020 swimming_water_cyanobacteria 2020-06-26T13:34:04.339032+0300 2020-06-27T13:34:04.339032+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
10251 40020 swimming_water_temperature 2020-06-26T13:34:06.411741+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10252 40020 swimming_water_temperature 2020-06-26T13:34:28.554066+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10253 40798 swimming_water_temperature 2020-06-26T13:34:36.424574+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10254 40798 swimming_water_cyanobacteria 2020-06-26T13:34:39.865210+0300 2020-06-27T13:34:39.865210+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
10255 40993 swimming_water_cyanobacteria 2020-06-26T13:35:05.245785+0300 2020-06-27T13:35:05.245785+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
10256 40993 swimming_water_temperature 2020-06-26T13:35:07.324515+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10257 41326 swimming_water_cyanobacteria 2020-06-26T13:35:12.096677+0300 2020-06-27T13:35:12.096677+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
10258 41326 swimming_water_temperature 2020-06-26T13:35:13.578851+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10259 40356 swimming_water_cyanobacteria 2020-06-26T13:35:25.514133+0300 2020-06-27T13:35:25.514133+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
10260 40356 swimming_water_temperature 2020-06-26T13:35:34.878324+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10261 58015 swimming_water_cyanobacteria 2020-06-26T13:35:42.577587+0300 2020-06-27T13:35:42.577587+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
10262 58015 swimming_water_temperature 2020-06-26T13:35:47.649082+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
10263 39815 swimming_water_temperature 2020-06-26T13:53:15.779518+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10264 39815 swimming_water_cyanobacteria 2020-06-26T13:53:24.256660+0300 2020-06-27T13:53:24.256660+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
10265 40098 swimming_water_temperature 2020-06-26T13:54:36.093109+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10266 40098 swimming_water_cyanobacteria 2020-06-26T13:54:40.021003+0300 2020-06-27T13:54:40.021003+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
10267 40098 swimming_water_temperature 2020-06-26T14:02:57.206713+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10268 40098 swimming_water_cyanobacteria 2020-06-26T14:03:04.959792+0300 2020-06-27T14:03:04.959792+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  

Next page

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
);