observation
7,945 rows where primary = 1 sorted by expiration_time descending
This data as json, CSV (advanced)
Suggested facets: property, name_fi, name_sv, name_en, value, quality
| id | unit | property | time | expiration_time ▲ | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24083 | 39322 | swimming_water_cyanobacteria | 2020-10-14T11:05:04.452420+0300 | 2020-10-15T11:05:04.452420+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 17567 | 39412 | swimming_water_cyanobacteria | 2020-09-07T10:12:02.567444+0300 | 2020-09-08T10:12:02.567444+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 17565 | 39412 | swimming_water_cyanobacteria | 2020-09-07T10:11:53.308992+0300 | 2020-09-08T10:11:53.308992+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 17556 | 39713 | swimming_water_cyanobacteria | 2020-09-07T09:46:18.908478+0300 | 2020-09-08T09:46:18.908478+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 17553 | 39875 | swimming_water_cyanobacteria | 2020-09-07T09:30:48.940252+0300 | 2020-09-08T09:30:48.940252+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 17545 | 39902 | swimming_water_cyanobacteria | 2020-09-07T09:15:09.187418+0300 | 2020-09-08T09:15:09.187418+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 17538 | 39606 | swimming_water_cyanobacteria | 2020-09-07T08:53:08.898598+0300 | 2020-09-08T08:53:08.898598+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 17536 | 39823 | swimming_water_cyanobacteria | 2020-09-07T08:52:55.180001+0300 | 2020-09-08T08:52:55.180001+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 17526 | 53461 | swimming_water_cyanobacteria | 2020-09-07T08:19:44.744213+0300 | 2020-09-08T08:19:44.744213+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13993 | 39881 | swimming_water_cyanobacteria | 2020-08-21T12:18:18.982033+0300 | 2020-08-22T12:18:18.982033+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13992 | 39897 | swimming_water_cyanobacteria | 2020-08-21T12:17:31.980342+0300 | 2020-08-22T12:17:31.980342+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13991 | 39784 | swimming_water_cyanobacteria | 2020-08-21T12:17:21.112943+0300 | 2020-08-22T12:17:21.112943+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13990 | 39667 | swimming_water_cyanobacteria | 2020-08-21T12:17:06.549829+0300 | 2020-08-22T12:17:06.549829+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13989 | 52958 | swimming_water_cyanobacteria | 2020-08-21T12:13:41.923916+0300 | 2020-08-22T12:13:41.923916+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13988 | 39368 | swimming_water_cyanobacteria | 2020-08-21T12:13:28.309970+0300 | 2020-08-22T12:13:28.309970+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13987 | 52960 | swimming_water_cyanobacteria | 2020-08-21T12:12:56.350705+0300 | 2020-08-22T12:12:56.350705+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13986 | 39412 | swimming_water_cyanobacteria | 2020-08-21T12:12:06.759620+0300 | 2020-08-22T12:12:06.759620+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13985 | 53476 | swimming_water_cyanobacteria | 2020-08-21T12:11:33.842542+0300 | 2020-08-22T12:11:33.842542+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13984 | 50549 | swimming_water_cyanobacteria | 2020-08-21T12:11:29.760187+0300 | 2020-08-22T12:11:29.760187+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13983 | 39693 | swimming_water_cyanobacteria | 2020-08-21T12:11:20.987580+0300 | 2020-08-22T12:11:20.987580+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13982 | 39527 | swimming_water_cyanobacteria | 2020-08-21T12:11:05.534505+0300 | 2020-08-22T12:11:05.534505+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13981 | 39568 | swimming_water_cyanobacteria | 2020-08-21T12:10:52.004680+0300 | 2020-08-22T12:10:52.004680+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13980 | 52959 | swimming_water_cyanobacteria | 2020-08-21T12:10:39.348899+0300 | 2020-08-22T12:10:39.348899+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13979 | 39322 | swimming_water_cyanobacteria | 2020-08-21T12:10:24.017426+0300 | 2020-08-22T12:10:24.017426+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13978 | 39267 | swimming_water_cyanobacteria | 2020-08-21T12:10:09.650343+0300 | 2020-08-22T12:10:09.650343+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
| 13977 | 39815 | swimming_water_cyanobacteria | 2020-08-21T12:09:55.339690+0300 | 2020-08-22T12:09:55.339690+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13976 | 39583 | swimming_water_cyanobacteria | 2020-08-21T12:09:39.512634+0300 | 2020-08-22T12:09:39.512634+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13975 | 53461 | swimming_water_cyanobacteria | 2020-08-21T11:23:03.616510+0300 | 2020-08-22T11:23:03.616510+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13973 | 39713 | swimming_water_cyanobacteria | 2020-08-21T11:09:53.228772+0300 | 2020-08-22T11:09:53.228772+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13971 | 39823 | swimming_water_cyanobacteria | 2020-08-21T11:09:25.520384+0300 | 2020-08-22T11:09:25.520384+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13968 | 39875 | swimming_water_cyanobacteria | 2020-08-21T10:12:13.999978+0300 | 2020-08-22T10:12:13.999978+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13966 | 39902 | swimming_water_cyanobacteria | 2020-08-21T09:45:03.612343+0300 | 2020-08-22T09:45:03.612343+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13964 | 39606 | swimming_water_cyanobacteria | 2020-08-21T09:31:57.793297+0300 | 2020-08-22T09:31:57.793297+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13962 | 39815 | swimming_water_cyanobacteria | 2020-08-20T10:11:05.166717+0300 | 2020-08-21T10:11:05.166717+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13961 | 39784 | swimming_water_cyanobacteria | 2020-08-20T09:54:10.693030+0300 | 2020-08-21T09:54:10.693030+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13960 | 39846 | swimming_water_cyanobacteria | 2020-08-20T09:54:10.636732+0300 | 2020-08-21T09:54:10.636732+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13959 | 39897 | swimming_water_cyanobacteria | 2020-08-20T09:54:10.621305+0300 | 2020-08-21T09:54:10.621305+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13958 | 39902 | swimming_water_cyanobacteria | 2020-08-20T09:53:47.890042+0300 | 2020-08-21T09:53:47.890042+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13957 | 52958 | swimming_water_cyanobacteria | 2020-08-20T09:53:47.887461+0300 | 2020-08-21T09:53:47.887461+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13956 | 39713 | swimming_water_cyanobacteria | 2020-08-20T09:53:47.882830+0300 | 2020-08-21T09:53:47.882830+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13955 | 52960 | swimming_water_cyanobacteria | 2020-08-20T09:53:47.870384+0300 | 2020-08-21T09:53:47.870384+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13954 | 39881 | swimming_water_cyanobacteria | 2020-08-20T09:53:47.863065+0300 | 2020-08-21T09:53:47.863065+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13953 | 39875 | swimming_water_cyanobacteria | 2020-08-20T09:53:47.854435+0300 | 2020-08-21T09:53:47.854435+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13952 | 39667 | swimming_water_cyanobacteria | 2020-08-20T09:53:47.849829+0300 | 2020-08-21T09:53:47.849829+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13951 | 39412 | swimming_water_cyanobacteria | 2020-08-20T09:53:47.814864+0300 | 2020-08-21T09:53:47.814864+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13950 | 39823 | swimming_water_cyanobacteria | 2020-08-20T09:53:47.771871+0300 | 2020-08-21T09:53:47.771871+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13948 | 53476 | swimming_water_cyanobacteria | 2020-08-20T09:53:47.757475+0300 | 2020-08-21T09:53:47.757475+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13949 | 50549 | swimming_water_cyanobacteria | 2020-08-20T09:53:47.757440+0300 | 2020-08-21T09:53:47.757440+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13946 | 39606 | swimming_water_cyanobacteria | 2020-08-20T09:53:47.625299+0300 | 2020-08-21T09:53:47.625299+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13947 | 39368 | swimming_water_cyanobacteria | 2020-08-20T09:53:47.624874+0300 | 2020-08-21T09:53:47.624874+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13945 | 39267 | swimming_water_cyanobacteria | 2020-08-20T09:47:37.985942+0300 | 2020-08-21T09:47:37.985942+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
| 13944 | 39322 | swimming_water_cyanobacteria | 2020-08-20T09:47:15.956968+0300 | 2020-08-21T09:47:15.956968+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13943 | 52959 | swimming_water_cyanobacteria | 2020-08-20T09:47:01.014783+0300 | 2020-08-21T09:47:01.014783+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13942 | 39568 | swimming_water_cyanobacteria | 2020-08-20T09:46:44.697350+0300 | 2020-08-21T09:46:44.697350+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13941 | 39527 | swimming_water_cyanobacteria | 2020-08-20T09:46:31.558725+0300 | 2020-08-21T09:46:31.558725+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13940 | 39693 | swimming_water_cyanobacteria | 2020-08-20T09:46:16.140155+0300 | 2020-08-21T09:46:16.140155+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13939 | 39897 | swimming_water_cyanobacteria | 2020-08-19T10:53:23.442162+0300 | 2020-08-20T10:53:23.442162+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13938 | 39784 | swimming_water_cyanobacteria | 2020-08-19T10:53:17.428427+0300 | 2020-08-20T10:53:17.428427+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13937 | 39846 | swimming_water_cyanobacteria | 2020-08-19T10:53:10.645172+0300 | 2020-08-20T10:53:10.645172+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13936 | 52960 | swimming_water_cyanobacteria | 2020-08-19T10:53:05.363247+0300 | 2020-08-20T10:53:05.363247+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13935 | 39875 | swimming_water_cyanobacteria | 2020-08-19T10:52:59.197485+0300 | 2020-08-20T10:52:59.197485+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13934 | 39412 | swimming_water_cyanobacteria | 2020-08-19T10:52:53.319467+0300 | 2020-08-20T10:52:53.319467+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13933 | 52958 | swimming_water_cyanobacteria | 2020-08-19T10:52:47.612448+0300 | 2020-08-20T10:52:47.612448+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13932 | 39606 | swimming_water_cyanobacteria | 2020-08-19T10:52:39.669040+0300 | 2020-08-20T10:52:39.669040+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13931 | 39902 | swimming_water_cyanobacteria | 2020-08-19T10:52:34.653600+0300 | 2020-08-20T10:52:34.653600+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13930 | 39713 | swimming_water_cyanobacteria | 2020-08-19T10:52:28.225105+0300 | 2020-08-20T10:52:28.225105+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13929 | 39823 | swimming_water_cyanobacteria | 2020-08-19T10:52:16.307105+0300 | 2020-08-20T10:52:16.307105+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13928 | 39267 | swimming_water_cyanobacteria | 2020-08-19T10:52:10.652922+0300 | 2020-08-20T10:52:10.652922+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13927 | 39693 | swimming_water_cyanobacteria | 2020-08-19T10:52:04.879342+0300 | 2020-08-20T10:52:04.879342+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13926 | 39815 | swimming_water_cyanobacteria | 2020-08-19T10:51:57.659689+0300 | 2020-08-20T10:51:57.659689+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13925 | 39368 | swimming_water_cyanobacteria | 2020-08-19T10:51:51.884683+0300 | 2020-08-20T10:51:51.884683+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13924 | 39667 | swimming_water_cyanobacteria | 2020-08-19T10:51:44.477880+0300 | 2020-08-20T10:51:44.477880+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13923 | 39881 | swimming_water_cyanobacteria | 2020-08-19T10:51:40.064921+0300 | 2020-08-20T10:51:40.064921+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13922 | 53476 | swimming_water_cyanobacteria | 2020-08-19T10:51:33.581016+0300 | 2020-08-20T10:51:33.581016+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13921 | 50549 | swimming_water_cyanobacteria | 2020-08-19T10:51:28.247715+0300 | 2020-08-20T10:51:28.247715+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13920 | 39568 | swimming_water_cyanobacteria | 2020-08-19T10:51:23.372648+0300 | 2020-08-20T10:51:23.372648+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13919 | 39583 | swimming_water_cyanobacteria | 2020-08-19T10:51:18.920226+0300 | 2020-08-20T10:51:18.920226+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13918 | 39897 | swimming_water_cyanobacteria | 2020-08-18T11:58:22.216325+0300 | 2020-08-19T11:58:22.216325+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13917 | 39846 | swimming_water_cyanobacteria | 2020-08-18T11:58:07.234129+0300 | 2020-08-19T11:58:07.234129+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13916 | 39784 | swimming_water_cyanobacteria | 2020-08-18T11:57:44.208652+0300 | 2020-08-19T11:57:44.208652+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13915 | 39875 | swimming_water_cyanobacteria | 2020-08-18T11:57:03.562167+0300 | 2020-08-19T11:57:03.562167+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13914 | 52960 | swimming_water_cyanobacteria | 2020-08-18T11:56:37.525709+0300 | 2020-08-19T11:56:37.525709+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13913 | 52958 | swimming_water_cyanobacteria | 2020-08-18T11:56:23.459933+0300 | 2020-08-19T11:56:23.459933+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13912 | 39412 | swimming_water_cyanobacteria | 2020-08-18T11:55:56.202217+0300 | 2020-08-19T11:55:56.202217+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13911 | 39322 | swimming_water_cyanobacteria | 2020-08-18T11:55:14.020940+0300 | 2020-08-19T11:55:14.020940+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13910 | 39606 | swimming_water_cyanobacteria | 2020-08-18T11:54:57.052805+0300 | 2020-08-19T11:54:57.052805+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13909 | 39902 | swimming_water_cyanobacteria | 2020-08-18T11:54:51.557120+0300 | 2020-08-19T11:54:51.557120+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13908 | 39713 | swimming_water_cyanobacteria | 2020-08-18T11:54:46.388748+0300 | 2020-08-19T11:54:46.388748+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13907 | 39823 | swimming_water_cyanobacteria | 2020-08-18T11:54:40.206204+0300 | 2020-08-19T11:54:40.206204+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13906 | 39267 | swimming_water_cyanobacteria | 2020-08-18T11:54:33.209405+0300 | 2020-08-19T11:54:33.209405+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 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 | |||
| 13904 | 39815 | swimming_water_cyanobacteria | 2020-08-18T11:54:11.407768+0300 | 2020-08-19T11:54:11.407768+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13903 | 39368 | swimming_water_cyanobacteria | 2020-08-18T11:54:05.645525+0300 | 2020-08-19T11:54:05.645525+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13902 | 39667 | swimming_water_cyanobacteria | 2020-08-18T11:53:59.724072+0300 | 2020-08-19T11:53:59.724072+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13901 | 39881 | swimming_water_cyanobacteria | 2020-08-18T11:53:54.532940+0300 | 2020-08-19T11:53:54.532940+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13900 | 39568 | swimming_water_cyanobacteria | 2020-08-18T11:53:47.218234+0300 | 2020-08-19T11:53:47.218234+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13899 | 39583 | swimming_water_cyanobacteria | 2020-08-18T11:53:37.337706+0300 | 2020-08-19T11:53:37.337706+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13898 | 53476 | swimming_water_cyanobacteria | 2020-08-18T11:53:32.445171+0300 | 2020-08-19T11:53:32.445171+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13897 | 50549 | swimming_water_cyanobacteria | 2020-08-18T11:53:27.981865+0300 | 2020-08-19T11:53:27.981865+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13891 | 42114 | swimming_water_cyanobacteria | 2020-08-17T13:04:45.235271+0300 | 2020-08-18T13:04:45.235271+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );