observation
2,809 rows where name_fi = "Ei sinilevää" sorted by id descending
This data as json, CSV (advanced)
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 13879 | 39322 | swimming_water_cyanobacteria | 2020-08-17T12:35:23.572138+0300 | 2020-08-18T12:35:23.572138+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13875 | 39606 | swimming_water_cyanobacteria | 2020-08-17T10:09:49.649092+0300 | 2020-08-18T10:09:49.649092+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13872 | 39875 | swimming_water_cyanobacteria | 2020-08-17T09:26:44.610473+0300 | 2020-08-18T09:26:44.610473+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13870 | 39713 | swimming_water_cyanobacteria | 2020-08-17T09:11:33.860500+0300 | 2020-08-18T09:11:33.860500+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13852 | 52959 | swimming_water_cyanobacteria | 2020-08-16T12:18:23.639606+0300 | 2020-08-17T12:18:23.639606+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13839 | 39875 | swimming_water_cyanobacteria | 2020-08-16T10:24:55.208394+0300 | 2020-08-17T10:24:55.208394+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13838 | 39412 | swimming_water_cyanobacteria | 2020-08-16T10:24:49.206737+0300 | 2020-08-17T10:24:49.206737+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13835 | 39606 | swimming_water_cyanobacteria | 2020-08-16T10:24:31.532290+0300 | 2020-08-17T10:24:31.532290+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13834 | 39902 | swimming_water_cyanobacteria | 2020-08-16T10:24:26.953373+0300 | 2020-08-17T10:24:26.953373+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13833 | 39713 | swimming_water_cyanobacteria | 2020-08-16T10:24:22.365942+0300 | 2020-08-17T10:24:22.365942+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13832 | 39823 | swimming_water_cyanobacteria | 2020-08-16T10:24:16.040068+0300 | 2020-08-17T10:24:16.040068+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13831 | 39267 | swimming_water_cyanobacteria | 2020-08-16T10:24:09.270120+0300 | 2020-08-17T10:24:09.270120+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13830 | 39368 | swimming_water_cyanobacteria | 2020-08-16T10:24:02.311683+0300 | 2020-08-17T10:24:02.311683+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13795 | 39875 | swimming_water_cyanobacteria | 2020-08-15T10:29:49.426902+0300 | 2020-08-16T10:29:49.426902+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13794 | 39412 | swimming_water_cyanobacteria | 2020-08-15T10:29:49.412505+0300 | 2020-08-16T10:29:49.412505+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13787 | 39606 | swimming_water_cyanobacteria | 2020-08-15T10:28:38.220468+0300 | 2020-08-16T10:28:38.220468+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13786 | 39902 | swimming_water_cyanobacteria | 2020-08-15T10:28:30.398330+0300 | 2020-08-16T10:28:30.398330+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13785 | 39902 | swimming_water_cyanobacteria | 2020-08-15T10:28:29.556688+0300 | 2020-08-16T10:28:29.556688+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13784 | 39368 | swimming_water_cyanobacteria | 2020-08-15T10:28:18.646777+0300 | 2020-08-16T10:28:18.646777+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13783 | 39823 | swimming_water_cyanobacteria | 2020-08-15T10:28:18.568956+0300 | 2020-08-16T10:28:18.568956+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13781 | 39713 | swimming_water_cyanobacteria | 2020-08-15T10:28:18.563332+0300 | 2020-08-16T10:28:18.563332+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13780 | 39267 | swimming_water_cyanobacteria | 2020-08-15T10:28:18.560527+0300 | 2020-08-16T10:28:18.560527+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13747 | 39875 | swimming_water_cyanobacteria | 2020-08-14T09:07:07.877688+0300 | 2020-08-15T09:07:07.877688+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13746 | 39412 | swimming_water_cyanobacteria | 2020-08-14T09:06:45.779181+0300 | 2020-08-15T09:06:45.779181+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13743 | 39606 | swimming_water_cyanobacteria | 2020-08-14T09:05:46.561359+0300 | 2020-08-15T09:05:46.561359+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13742 | 39902 | swimming_water_cyanobacteria | 2020-08-14T09:05:38.558703+0300 | 2020-08-15T09:05:38.558703+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13741 | 39713 | swimming_water_cyanobacteria | 2020-08-14T09:05:32.860024+0300 | 2020-08-15T09:05:32.860024+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13740 | 39823 | swimming_water_cyanobacteria | 2020-08-14T09:05:25.326327+0300 | 2020-08-15T09:05:25.326327+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13739 | 39267 | swimming_water_cyanobacteria | 2020-08-14T09:05:18.949087+0300 | 2020-08-15T09:05:18.949087+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13738 | 39368 | swimming_water_cyanobacteria | 2020-08-14T09:05:12.872333+0300 | 2020-08-15T09:05:12.872333+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13707 | 39875 | swimming_water_cyanobacteria | 2020-08-13T09:40:32.852752+0300 | 2020-08-14T09:40:32.852752+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13706 | 39412 | swimming_water_cyanobacteria | 2020-08-13T09:40:25.903571+0300 | 2020-08-14T09:40:25.903571+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13703 | 39606 | swimming_water_cyanobacteria | 2020-08-13T09:39:25.579306+0300 | 2020-08-14T09:39:25.579306+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13702 | 39902 | swimming_water_cyanobacteria | 2020-08-13T09:39:18.960970+0300 | 2020-08-14T09:39:18.960970+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13701 | 39713 | swimming_water_cyanobacteria | 2020-08-13T09:39:12.321610+0300 | 2020-08-14T09:39:12.321610+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13700 | 39823 | swimming_water_cyanobacteria | 2020-08-13T09:39:04.399797+0300 | 2020-08-14T09:39:04.399797+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13699 | 39267 | swimming_water_cyanobacteria | 2020-08-13T09:38:57.257624+0300 | 2020-08-14T09:38:57.257624+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13698 | 39368 | swimming_water_cyanobacteria | 2020-08-13T09:38:49.371728+0300 | 2020-08-14T09:38:49.371728+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13688 | 40258 | swimming_water_cyanobacteria | 2020-08-13T08:45:13.522288+0300 | 2020-08-14T08:45:13.522288+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13686 | 39568 | swimming_water_cyanobacteria | 2020-08-13T08:25:21.736126+0300 | 2020-08-14T08:25:21.736126+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13654 | 39875 | swimming_water_cyanobacteria | 2020-08-12T10:48:18.130477+0300 | 2020-08-13T10:48:18.130477+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13653 | 39412 | swimming_water_cyanobacteria | 2020-08-12T10:48:11.136636+0300 | 2020-08-13T10:48:11.136636+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13650 | 39606 | swimming_water_cyanobacteria | 2020-08-12T10:47:44.856339+0300 | 2020-08-13T10:47:44.856339+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13649 | 39902 | swimming_water_cyanobacteria | 2020-08-12T10:47:38.499541+0300 | 2020-08-13T10:47:38.499541+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13648 | 39713 | swimming_water_cyanobacteria | 2020-08-12T10:47:31.960704+0300 | 2020-08-13T10:47:31.960704+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13647 | 39823 | swimming_water_cyanobacteria | 2020-08-12T10:47:25.459969+0300 | 2020-08-13T10:47:25.459969+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13646 | 39267 | swimming_water_cyanobacteria | 2020-08-12T10:47:18.051060+0300 | 2020-08-13T10:47:18.051060+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13645 | 39368 | swimming_water_cyanobacteria | 2020-08-12T10:47:11.019785+0300 | 2020-08-13T10:47:11.019785+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13618 | 52959 | swimming_water_cyanobacteria | 2020-08-11T11:41:11.894626+0300 | 2020-08-12T11:41:11.894626+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13607 | 39875 | swimming_water_cyanobacteria | 2020-08-11T09:49:45.063085+0300 | 2020-08-12T09:49:45.063085+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13606 | 39412 | swimming_water_cyanobacteria | 2020-08-11T09:49:37.739345+0300 | 2020-08-12T09:49:37.739345+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13603 | 39606 | swimming_water_cyanobacteria | 2020-08-11T09:49:18.021674+0300 | 2020-08-12T09:49:18.021674+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13602 | 39902 | swimming_water_cyanobacteria | 2020-08-11T09:49:11.395722+0300 | 2020-08-12T09:49:11.395722+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13601 | 39713 | swimming_water_cyanobacteria | 2020-08-11T09:49:05.985900+0300 | 2020-08-12T09:49:05.985900+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13600 | 39823 | swimming_water_cyanobacteria | 2020-08-11T09:48:59.361378+0300 | 2020-08-12T09:48:59.361378+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 );