observation
51,120 rows sorted by expiration_time descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 );