observation
2,809 rows where name_en = "No cyanobacteria" sorted by unit
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 166 | 39267 | swimming_water_cyanobacteria | 2019-06-06T11:41:52.590712+0300 | 2019-06-07T11:41:52.590712+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 181 | 39267 | swimming_water_cyanobacteria | 2019-06-06T14:10:39.762394+0300 | 2019-06-07T14:10:39.762394+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 297 | 39267 | swimming_water_cyanobacteria | 2019-06-08T17:01:12.529283+0300 | 2019-06-09T17:01:12.529283+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 302 | 39267 | swimming_water_cyanobacteria | 2019-06-08T17:58:58.552883+0300 | 2019-06-09T17:58:58.552883+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 340 | 39267 | swimming_water_cyanobacteria | 2019-06-09T10:21:47.250145+0300 | 2019-06-10T10:21:47.250145+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 375 | 39267 | swimming_water_cyanobacteria | 2019-06-09T17:54:15.065650+0300 | 2019-06-10T17:54:15.065650+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 476 | 39267 | swimming_water_cyanobacteria | 2019-06-11T10:10:11.349976+0300 | 2019-06-12T10:10:11.349976+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 591 | 39267 | swimming_water_cyanobacteria | 2019-06-12T10:45:42.523400+0300 | 2019-06-13T10:45:42.523400+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 608 | 39267 | swimming_water_cyanobacteria | 2019-06-12T14:02:40.781786+0300 | 2019-06-13T14:02:40.781786+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 686 | 39267 | swimming_water_cyanobacteria | 2019-06-13T15:03:58.499130+0300 | 2019-06-14T15:03:58.499130+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13355 | 39267 | swimming_water_cyanobacteria | 2020-08-07T09:01:30.604509+0300 | 2020-08-08T09:01:30.604509+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13542 | 39267 | swimming_water_cyanobacteria | 2020-08-10T10:45:49.935972+0300 | 2020-08-11T10:45:49.935972+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13599 | 39267 | swimming_water_cyanobacteria | 2020-08-11T09:48:48.687193+0300 | 2020-08-12T09:48:48.687193+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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 8978 | 39289 | swimming_water_cyanobacteria | 2020-06-10T10:03:19.811846+0300 | 2020-06-11T10:03:19.811846+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 223 | 39322 | swimming_water_cyanobacteria | 2019-06-07T11:23:46.934289+0300 | 2019-06-08T11:23:46.934289+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 225 | 39322 | swimming_water_cyanobacteria | 2019-06-07T11:35:37.275884+0300 | 2019-06-08T11:35:37.275884+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 227 | 39322 | swimming_water_cyanobacteria | 2019-06-07T11:35:37.729851+0300 | 2019-06-08T11:35:37.729851+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 229 | 39322 | swimming_water_cyanobacteria | 2019-06-07T11:35:38.182549+0300 | 2019-06-08T11:35:38.182549+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 246 | 39322 | swimming_water_cyanobacteria | 2019-06-07T15:17:51.371667+0300 | 2019-06-08T15:17:51.371667+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 259 | 39322 | swimming_water_cyanobacteria | 2019-06-07T19:42:43.393878+0300 | 2019-06-08T19:42:43.393878+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 307 | 39322 | swimming_water_cyanobacteria | 2019-06-08T23:41:39.898126+0300 | 2019-06-09T23:41:39.898126+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 338 | 39322 | swimming_water_cyanobacteria | 2019-06-09T10:15:22.169332+0300 | 2019-06-10T10:15:22.169332+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 367 | 39322 | swimming_water_cyanobacteria | 2019-06-09T14:07:48.854694+0300 | 2019-06-10T14:07:48.854694+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 392 | 39322 | swimming_water_cyanobacteria | 2019-06-10T10:01:32.789022+0300 | 2019-06-11T10:01:32.789022+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 407 | 39322 | swimming_water_cyanobacteria | 2019-06-10T13:40:35.075811+0300 | 2019-06-11T13:40:35.075811+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 425 | 39322 | swimming_water_cyanobacteria | 2019-06-10T17:51:08.455237+0300 | 2019-06-11T17:51:08.455237+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 461 | 39322 | swimming_water_cyanobacteria | 2019-06-11T09:50:57.103281+0300 | 2019-06-12T09:50:57.103281+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 555 | 39322 | swimming_water_cyanobacteria | 2019-06-11T13:45:46.922981+0300 | 2019-06-12T13:45:46.922981+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 566 | 39322 | swimming_water_cyanobacteria | 2019-06-11T17:52:48.301558+0300 | 2019-06-12T17:52:48.301558+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 573 | 39322 | swimming_water_cyanobacteria | 2019-06-12T10:04:15.093719+0300 | 2019-06-13T10:04:15.093719+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 606 | 39322 | swimming_water_cyanobacteria | 2019-06-12T14:01:03.590432+0300 | 2019-06-13T14:01:03.590432+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 621 | 39322 | swimming_water_cyanobacteria | 2019-06-12T17:49:11.759700+0300 | 2019-06-13T17:49:11.759700+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 652 | 39322 | swimming_water_cyanobacteria | 2019-06-13T10:08:24.438606+0300 | 2019-06-14T10:08:24.438606+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 696 | 39322 | swimming_water_cyanobacteria | 2019-06-13T18:42:37.809008+0300 | 2019-06-14T18:42:37.809008+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 710 | 39322 | swimming_water_cyanobacteria | 2019-06-14T09:44:12.773863+0300 | 2019-06-15T09:44:12.773863+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 833 | 39322 | swimming_water_cyanobacteria | 2019-06-16T10:08:53.647603+0300 | 2019-06-17T10:08:53.647603+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 2043 | 39322 | swimming_water_cyanobacteria | 2019-07-01T18:09:21.935312+0300 | 2019-07-02T18:09:21.935312+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 2097 | 39322 | swimming_water_cyanobacteria | 2019-07-03T09:51:33.108914+0300 | 2019-07-04T09:51:33.108914+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 8621 | 39322 | swimming_water_cyanobacteria | 2020-06-04T13:31:19.565447+0300 | 2020-06-05T13:31:19.565447+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 8629 | 39322 | swimming_water_cyanobacteria | 2020-06-04T15:04:26.455349+0300 | 2020-06-05T15:04:26.455349+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 8642 | 39322 | swimming_water_cyanobacteria | 2020-06-04T19:26:00.900564+0300 | 2020-06-05T19:26:00.900564+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 8644 | 39322 | swimming_water_cyanobacteria | 2020-06-05T08:30:31.940629+0300 | 2020-06-06T08:30:31.940629+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 8701 | 39322 | swimming_water_cyanobacteria | 2020-06-05T14:21:21.577935+0300 | 2020-06-06T14:21:21.577935+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 8771 | 39322 | swimming_water_cyanobacteria | 2020-06-06T18:14:05.010617+0300 | 2020-06-07T18:14:05.010617+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 8792 | 39322 | swimming_water_cyanobacteria | 2020-06-07T10:09:35.389842+0300 | 2020-06-08T10:09:35.389842+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 8816 | 39322 | swimming_water_cyanobacteria | 2020-06-07T13:53:23.711738+0300 | 2020-06-08T13:53:23.711738+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 8825 | 39322 | swimming_water_cyanobacteria | 2020-06-07T14:40:36.392081+0300 | 2020-06-08T14:40:36.392081+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 8831 | 39322 | swimming_water_cyanobacteria | 2020-06-07T17:51:55.192106+0300 | 2020-06-08T17:51:55.192106+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 8861 | 39322 | swimming_water_cyanobacteria | 2020-06-08T10:05:25.541820+0300 | 2020-06-09T10:05:25.541820+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 8891 | 39322 | swimming_water_cyanobacteria | 2020-06-08T13:59:41.861684+0300 | 2020-06-09T13:59:41.861684+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 8898 | 39322 | swimming_water_cyanobacteria | 2020-06-08T17:51:54.558749+0300 | 2020-06-09T17:51:54.558749+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 8923 | 39322 | swimming_water_cyanobacteria | 2020-06-09T10:09:36.162775+0300 | 2020-06-10T10:09:36.162775+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 8939 | 39322 | swimming_water_cyanobacteria | 2020-06-09T13:58:21.098675+0300 | 2020-06-10T13:58:21.098675+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 8943 | 39322 | swimming_water_cyanobacteria | 2020-06-09T14:56:16.422279+0300 | 2020-06-10T14:56:16.422279+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 8951 | 39322 | swimming_water_cyanobacteria | 2020-06-09T18:00:51.021183+0300 | 2020-06-10T18:00:51.021183+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9016 | 39322 | swimming_water_cyanobacteria | 2020-06-10T14:44:25.179799+0300 | 2020-06-11T14:44:25.179799+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9028 | 39322 | swimming_water_cyanobacteria | 2020-06-10T17:53:00.155785+0300 | 2020-06-11T17:53:00.155785+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9092 | 39322 | swimming_water_cyanobacteria | 2020-06-11T10:08:02.997986+0300 | 2020-06-12T10:08:02.997986+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9120 | 39322 | swimming_water_cyanobacteria | 2020-06-11T14:42:34.386552+0300 | 2020-06-12T14:42:34.386552+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9132 | 39322 | swimming_water_cyanobacteria | 2020-06-11T18:00:02.458284+0300 | 2020-06-12T18:00:02.458284+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9189 | 39322 | swimming_water_cyanobacteria | 2020-06-12T11:24:38.307195+0300 | 2020-06-13T11:24:38.307195+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9209 | 39322 | swimming_water_cyanobacteria | 2020-06-12T18:04:10.099605+0300 | 2020-06-13T18:04:10.099605+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9250 | 39322 | swimming_water_cyanobacteria | 2020-06-13T11:15:24.569304+0300 | 2020-06-14T11:15:24.569304+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9259 | 39322 | swimming_water_cyanobacteria | 2020-06-13T14:15:58.221285+0300 | 2020-06-14T14:15:58.221285+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9291 | 39322 | swimming_water_cyanobacteria | 2020-06-14T10:13:51.779788+0300 | 2020-06-15T10:13:51.779788+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9318 | 39322 | swimming_water_cyanobacteria | 2020-06-14T13:46:32.134787+0300 | 2020-06-15T13:46:32.134787+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9371 | 39322 | swimming_water_cyanobacteria | 2020-06-15T09:54:22.298060+0300 | 2020-06-16T09:54:22.298060+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9434 | 39322 | swimming_water_cyanobacteria | 2020-06-15T14:22:09.130688+0300 | 2020-06-16T14:22:09.130688+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9450 | 39322 | swimming_water_cyanobacteria | 2020-06-15T17:58:38.978253+0300 | 2020-06-16T17:58:38.978253+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9452 | 39322 | swimming_water_cyanobacteria | 2020-06-15T18:00:14.727657+0300 | 2020-06-16T18:00:14.727657+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9515 | 39322 | swimming_water_cyanobacteria | 2020-06-16T13:57:06.392827+0300 | 2020-06-17T13:57:06.392827+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9531 | 39322 | swimming_water_cyanobacteria | 2020-06-16T18:13:24.918634+0300 | 2020-06-17T18:13:24.918634+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9571 | 39322 | swimming_water_cyanobacteria | 2020-06-17T10:11:27.141434+0300 | 2020-06-18T10:11:27.141434+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9608 | 39322 | swimming_water_cyanobacteria | 2020-06-17T14:19:22.937205+0300 | 2020-06-18T14:19:22.937205+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9620 | 39322 | swimming_water_cyanobacteria | 2020-06-17T17:58:41.358364+0300 | 2020-06-18T17:58:41.358364+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9638 | 39322 | swimming_water_cyanobacteria | 2020-06-18T09:34:19.146127+0300 | 2020-06-19T09:34:19.146127+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9683 | 39322 | swimming_water_cyanobacteria | 2020-06-18T14:00:21.579476+0300 | 2020-06-19T14:00:21.579476+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9695 | 39322 | swimming_water_cyanobacteria | 2020-06-18T18:05:39.431509+0300 | 2020-06-19T18:05:39.431509+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9697 | 39322 | swimming_water_cyanobacteria | 2020-06-18T18:16:56.781501+0300 | 2020-06-19T18:16:56.781501+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9822 | 39322 | swimming_water_cyanobacteria | 2020-06-22T09:46:30.354376+0300 | 2020-06-23T09:46:30.354376+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9865 | 39322 | swimming_water_cyanobacteria | 2020-06-22T14:03:35.174189+0300 | 2020-06-23T14:03:35.174189+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9883 | 39322 | swimming_water_cyanobacteria | 2020-06-22T18:01:49.226631+0300 | 2020-06-23T18:01:49.226631+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9891 | 39322 | swimming_water_cyanobacteria | 2020-06-23T09:14:49.376914+0300 | 2020-06-24T09:14:49.376914+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9929 | 39322 | swimming_water_cyanobacteria | 2020-06-23T10:10:46.775990+0300 | 2020-06-24T10:10:46.775990+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 9990 | 39322 | swimming_water_cyanobacteria | 2020-06-23T14:11:07.649365+0300 | 2020-06-24T14:11:07.649365+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 10006 | 39322 | swimming_water_cyanobacteria | 2020-06-23T18:36:55.274246+0300 | 2020-06-24T18:36:55.274246+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 10039 | 39322 | swimming_water_cyanobacteria | 2020-06-24T10:02:54.936726+0300 | 2020-06-25T10:02:54.936726+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 10086 | 39322 | swimming_water_cyanobacteria | 2020-06-24T13:58:09.622144+0300 | 2020-06-25T13:58:09.622144+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 10097 | 39322 | swimming_water_cyanobacteria | 2020-06-24T18:12:37.146743+0300 | 2020-06-25T18:12:37.146743+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 10125 | 39322 | swimming_water_cyanobacteria | 2020-06-25T09:59:23.395827+0300 | 2020-06-26T09:59:23.395827+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 10167 | 39322 | swimming_water_cyanobacteria | 2020-06-25T14:14:56.356339+0300 | 2020-06-26T14:14:56.356339+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 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 | |||
| 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 |
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 );