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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 13598 | 39368 | swimming_water_cyanobacteria | 2020-08-11T09:48:42.021266+0300 | 2020-08-12T09:48:42.021266+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13556 | 39412 | swimming_water_cyanobacteria | 2020-08-10T10:54:42.820883+0300 | 2020-08-11T10:54:42.820883+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13554 | 39368 | swimming_water_cyanobacteria | 2020-08-10T10:54:15.513166+0300 | 2020-08-11T10:54:15.513166+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13547 | 39606 | swimming_water_cyanobacteria | 2020-08-10T10:47:13.406075+0300 | 2020-08-11T10:47:13.406075+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13546 | 39902 | swimming_water_cyanobacteria | 2020-08-10T10:46:49.111629+0300 | 2020-08-11T10:46:49.111629+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13545 | 39713 | swimming_water_cyanobacteria | 2020-08-10T10:46:42.861728+0300 | 2020-08-11T10:46:42.861728+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13544 | 39875 | swimming_water_cyanobacteria | 2020-08-10T10:46:27.620187+0300 | 2020-08-11T10:46:27.620187+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 | |||
| 13541 | 39823 | swimming_water_cyanobacteria | 2020-08-10T10:45:43.361648+0300 | 2020-08-11T10:45:43.361648+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13540 | 39568 | swimming_water_cyanobacteria | 2020-08-10T10:42:02.236000+0300 | 2020-08-11T10:42:02.236000+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13538 | 52959 | swimming_water_cyanobacteria | 2020-08-10T10:18:11.498702+0300 | 2020-08-11T10:18:11.498702+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13519 | 40802 | swimming_water_cyanobacteria | 2020-08-09T13:45:55.336823+0300 | 2020-08-10T13:45:55.336823+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13515 | 40993 | swimming_water_cyanobacteria | 2020-08-09T11:55:06.395030+0300 | 2020-08-10T11:55:06.395030+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13501 | 40950 | swimming_water_cyanobacteria | 2020-08-09T10:44:16.543380+0300 | 2020-08-10T10:44:16.543380+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13493 | 40386 | swimming_water_cyanobacteria | 2020-08-09T10:07:33.555992+0300 | 2020-08-10T10:07:33.555992+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13491 | 41791 | swimming_water_cyanobacteria | 2020-08-09T10:06:35.172809+0300 | 2020-08-10T10:06:35.172809+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13463 | 40802 | swimming_water_cyanobacteria | 2020-08-08T11:36:12.328874+0300 | 2020-08-09T11:36:12.328874+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13455 | 41791 | swimming_water_cyanobacteria | 2020-08-08T10:18:22.098731+0300 | 2020-08-09T10:18:22.098731+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13446 | 52959 | swimming_water_cyanobacteria | 2020-08-08T10:07:15.033982+0300 | 2020-08-09T10:07:15.033982+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13444 | 40386 | swimming_water_cyanobacteria | 2020-08-08T10:01:34.799462+0300 | 2020-08-09T10:01:34.799462+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13408 | 40802 | swimming_water_cyanobacteria | 2020-08-07T11:29:31.593172+0300 | 2020-08-08T11:29:31.593172+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13390 | 40950 | swimming_water_cyanobacteria | 2020-08-07T10:05:02.707088+0300 | 2020-08-08T10:05:02.707088+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13388 | 40559 | swimming_water_cyanobacteria | 2020-08-07T10:02:58.217200+0300 | 2020-08-08T10:02:58.217200+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13386 | 40386 | swimming_water_cyanobacteria | 2020-08-07T10:01:20.588982+0300 | 2020-08-08T10:01:20.588982+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13382 | 39322 | swimming_water_cyanobacteria | 2020-08-07T09:58:02.209356+0300 | 2020-08-08T09:58:02.209356+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13377 | 41791 | swimming_water_cyanobacteria | 2020-08-07T09:53:27.803924+0300 | 2020-08-08T09:53:27.803924+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13364 | 39875 | swimming_water_cyanobacteria | 2020-08-07T09:02:42.252361+0300 | 2020-08-08T09:02:42.252361+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13363 | 39412 | swimming_water_cyanobacteria | 2020-08-07T09:02:42.250871+0300 | 2020-08-08T09:02:42.250871+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13359 | 39606 | swimming_water_cyanobacteria | 2020-08-07T09:01:32.706198+0300 | 2020-08-08T09:01:32.706198+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13358 | 39713 | swimming_water_cyanobacteria | 2020-08-07T09:01:30.690801+0300 | 2020-08-08T09:01:30.690801+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13357 | 39902 | swimming_water_cyanobacteria | 2020-08-07T09:01:30.611564+0300 | 2020-08-08T09:01:30.611564+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13356 | 39823 | swimming_water_cyanobacteria | 2020-08-07T09:01:30.609749+0300 | 2020-08-08T09:01:30.609749+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 | |||
| 13354 | 39368 | swimming_water_cyanobacteria | 2020-08-07T09:00:57.844521+0300 | 2020-08-08T09:00:57.844521+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13348 | 39527 | swimming_water_cyanobacteria | 2020-08-07T08:16:56.074643+0300 | 2020-08-08T08:16:56.074643+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13339 | 39322 | swimming_water_cyanobacteria | 2020-08-06T14:34:59.050028+0300 | 2020-08-07T14:34:59.050028+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13335 | 39527 | swimming_water_cyanobacteria | 2020-08-06T13:57:02.266784+0300 | 2020-08-07T13:57:02.266784+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13331 | 39875 | swimming_water_cyanobacteria | 2020-08-06T11:32:52.680901+0300 | 2020-08-07T11:32:52.680901+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13317 | 52959 | swimming_water_cyanobacteria | 2020-08-06T10:50:00.009917+0300 | 2020-08-07T10:50:00.009917+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13312 | 40150 | swimming_water_cyanobacteria | 2020-08-06T10:38:08.752182+0300 | 2020-08-07T10:38:08.752182+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13308 | 40258 | swimming_water_cyanobacteria | 2020-08-06T10:35:00.011721+0300 | 2020-08-07T10:35:00.011721+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13305 | 40559 | swimming_water_cyanobacteria | 2020-08-06T10:31:39.113211+0300 | 2020-08-07T10:31:39.113211+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13304 | 40802 | swimming_water_cyanobacteria | 2020-08-06T10:20:32.344118+0300 | 2020-08-07T10:20:32.344118+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13302 | 39322 | swimming_water_cyanobacteria | 2020-08-06T10:11:27.826344+0300 | 2020-08-07T10:11:27.826344+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13299 | 40157 | swimming_water_cyanobacteria | 2020-08-06T10:06:40.236476+0300 | 2020-08-07T10:06:40.236476+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13298 | 40386 | swimming_water_cyanobacteria | 2020-08-06T10:06:32.920797+0300 | 2020-08-07T10:06:32.920797+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13295 | 41791 | swimming_water_cyanobacteria | 2020-08-06T09:54:25.274335+0300 | 2020-08-07T09:54:25.274335+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13291 | 52959 | swimming_water_cyanobacteria | 2020-08-06T09:52:52.687593+0300 | 2020-08-07T09:52:52.687593+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13281 | 39412 | swimming_water_cyanobacteria | 2020-08-06T08:34:13.454580+0300 | 2020-08-07T08:34:13.454580+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13278 | 39606 | swimming_water_cyanobacteria | 2020-08-06T08:31:02.298448+0300 | 2020-08-07T08:31:02.298448+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13277 | 39902 | swimming_water_cyanobacteria | 2020-08-06T08:30:55.296460+0300 | 2020-08-07T08:30:55.296460+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13276 | 39713 | swimming_water_cyanobacteria | 2020-08-06T08:30:48.582268+0300 | 2020-08-07T08:30:48.582268+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13275 | 39823 | swimming_water_cyanobacteria | 2020-08-06T08:30:40.743169+0300 | 2020-08-07T08:30:40.743169+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13272 | 39368 | swimming_water_cyanobacteria | 2020-08-06T08:30:19.769168+0300 | 2020-08-07T08:30:19.769168+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13264 | 39322 | swimming_water_cyanobacteria | 2020-08-05T18:06:19.141554+0300 | 2020-08-06T18:06:19.141554+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13259 | 39568 | swimming_water_cyanobacteria | 2020-08-05T15:37:29.453582+0300 | 2020-08-06T15:37:29.453582+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13255 | 39322 | swimming_water_cyanobacteria | 2020-08-05T14:26:27.529011+0300 | 2020-08-06T14:26:27.529011+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13251 | 40802 | swimming_water_cyanobacteria | 2020-08-05T13:33:56.266262+0300 | 2020-08-06T13:33:56.266262+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13244 | 40559 | swimming_water_cyanobacteria | 2020-08-05T13:13:46.031308+0300 | 2020-08-06T13:13:46.031308+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13239 | 40150 | swimming_water_cyanobacteria | 2020-08-05T10:29:31.686167+0300 | 2020-08-06T10:29:31.686167+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13224 | 40157 | swimming_water_cyanobacteria | 2020-08-05T10:11:47.670016+0300 | 2020-08-06T10:11:47.670016+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13218 | 40386 | swimming_water_cyanobacteria | 2020-08-05T10:02:24.518129+0300 | 2020-08-06T10:02:24.518129+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13216 | 41791 | swimming_water_cyanobacteria | 2020-08-05T10:02:12.127283+0300 | 2020-08-06T10:02:12.127283+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13214 | 39322 | swimming_water_cyanobacteria | 2020-08-05T10:01:36.083776+0300 | 2020-08-06T10:01:36.083776+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13205 | 40258 | swimming_water_cyanobacteria | 2020-08-05T09:50:02.676755+0300 | 2020-08-06T09:50:02.676755+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13203 | 40142 | swimming_water_cyanobacteria | 2020-08-05T09:46:21.326488+0300 | 2020-08-06T09:46:21.326488+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13202 | 41960 | swimming_water_cyanobacteria | 2020-08-05T09:46:11.197830+0300 | 2020-08-06T09:46:11.197830+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13195 | 39875 | swimming_water_cyanobacteria | 2020-08-05T08:49:51.436829+0300 | 2020-08-06T08:49:51.436829+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13194 | 39412 | swimming_water_cyanobacteria | 2020-08-05T08:49:44.876086+0300 | 2020-08-06T08:49:44.876086+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13191 | 39606 | swimming_water_cyanobacteria | 2020-08-05T08:49:22.272634+0300 | 2020-08-06T08:49:22.272634+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13190 | 39902 | swimming_water_cyanobacteria | 2020-08-05T08:49:16.277037+0300 | 2020-08-06T08:49:16.277037+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13189 | 39713 | swimming_water_cyanobacteria | 2020-08-05T08:49:09.754318+0300 | 2020-08-06T08:49:09.754318+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13188 | 39823 | swimming_water_cyanobacteria | 2020-08-05T08:49:01.756059+0300 | 2020-08-06T08:49:01.756059+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13187 | 39368 | swimming_water_cyanobacteria | 2020-08-05T08:48:54.491655+0300 | 2020-08-06T08:48:54.491655+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13177 | 39322 | swimming_water_cyanobacteria | 2020-08-04T18:02:50.860292+0300 | 2020-08-05T18:02:50.860292+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13168 | 39322 | swimming_water_cyanobacteria | 2020-08-04T13:57:11.522479+0300 | 2020-08-05T13:57:11.522479+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13164 | 40993 | swimming_water_cyanobacteria | 2020-08-04T12:52:16.330117+0300 | 2020-08-05T12:52:16.330117+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13160 | 42114 | swimming_water_cyanobacteria | 2020-08-04T11:52:29.764074+0300 | 2020-08-05T11:52:29.764074+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13151 | 39322 | swimming_water_cyanobacteria | 2020-08-04T10:51:25.424756+0300 | 2020-08-05T10:51:25.424756+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13146 | 40950 | swimming_water_cyanobacteria | 2020-08-04T10:40:00.947542+0300 | 2020-08-05T10:40:00.947542+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13144 | 40150 | swimming_water_cyanobacteria | 2020-08-04T10:25:13.761706+0300 | 2020-08-05T10:25:13.761706+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13141 | 41960 | swimming_water_cyanobacteria | 2020-08-04T10:11:15.850343+0300 | 2020-08-05T10:11:15.850343+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13139 | 40258 | swimming_water_cyanobacteria | 2020-08-04T10:10:35.457905+0300 | 2020-08-05T10:10:35.457905+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13133 | 40386 | swimming_water_cyanobacteria | 2020-08-04T10:03:59.180866+0300 | 2020-08-05T10:03:59.180866+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13126 | 40142 | swimming_water_cyanobacteria | 2020-08-04T10:01:46.306551+0300 | 2020-08-05T10:01:46.306551+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13124 | 52959 | swimming_water_cyanobacteria | 2020-08-04T10:01:18.395096+0300 | 2020-08-05T10:01:18.395096+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13122 | 41791 | swimming_water_cyanobacteria | 2020-08-04T09:50:46.557442+0300 | 2020-08-05T09:50:46.557442+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13120 | 40157 | swimming_water_cyanobacteria | 2020-08-04T09:45:16.107382+0300 | 2020-08-05T09:45:16.107382+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13110 | 39875 | swimming_water_cyanobacteria | 2020-08-04T07:56:53.858778+0300 | 2020-08-05T07:56:53.858778+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13109 | 39412 | swimming_water_cyanobacteria | 2020-08-04T07:56:47.179765+0300 | 2020-08-05T07:56:47.179765+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13106 | 39606 | swimming_water_cyanobacteria | 2020-08-04T07:56:17.477683+0300 | 2020-08-05T07:56:17.477683+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13105 | 39902 | swimming_water_cyanobacteria | 2020-08-04T07:56:11.124577+0300 | 2020-08-05T07:56:11.124577+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13104 | 39713 | swimming_water_cyanobacteria | 2020-08-04T07:56:04.866927+0300 | 2020-08-05T07:56:04.866927+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13103 | 39823 | swimming_water_cyanobacteria | 2020-08-04T07:55:55.180195+0300 | 2020-08-05T07:55:55.180195+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13101 | 39368 | swimming_water_cyanobacteria | 2020-08-04T07:55:36.385224+0300 | 2020-08-05T07:55:36.385224+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13093 | 39322 | swimming_water_cyanobacteria | 2020-08-03T18:52:15.562786+0300 | 2020-08-04T18:52:15.562786+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13089 | 39322 | swimming_water_cyanobacteria | 2020-08-03T15:59:05.148652+0300 | 2020-08-04T15:59:05.148652+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13087 | 40802 | swimming_water_cyanobacteria | 2020-08-03T14:49:10.246108+0300 | 2020-08-04T14:49:10.246108+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 13075 | 40677 | swimming_water_cyanobacteria | 2020-08-03T12:50:13.752907+0300 | 2020-08-04T12:50:13.752907+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 );