observation
1,881 rows where value = 1
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2247 | 39322 | swimming_water_cyanobacteria | 2019-07-04T17:49:06.083747+0300 | 2019-07-05T17:49:06.083747+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2280 | 39322 | swimming_water_cyanobacteria | 2019-07-05T09:59:54.785241+0300 | 2019-07-06T09:59:54.785241+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2325 | 39322 | swimming_water_cyanobacteria | 2019-07-05T13:58:31.221259+0300 | 2019-07-06T13:58:31.221259+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2343 | 39322 | swimming_water_cyanobacteria | 2019-07-05T18:08:56.956459+0300 | 2019-07-06T18:08:56.956459+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2353 | 39322 | swimming_water_cyanobacteria | 2019-07-06T09:50:27.821439+0300 | 2019-07-07T09:50:27.821439+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2384 | 39693 | swimming_water_cyanobacteria | 2019-07-06T10:43:06.961168+0300 | 2019-07-07T10:43:06.961168+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2396 | 39693 | swimming_water_cyanobacteria | 2019-07-06T13:51:42.198771+0300 | 2019-07-07T13:51:42.198771+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2416 | 39322 | swimming_water_cyanobacteria | 2019-07-06T17:57:58.042917+0300 | 2019-07-07T17:57:58.042917+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2433 | 39583 | swimming_water_cyanobacteria | 2019-07-07T10:09:33.762587+0300 | 2019-07-08T10:09:33.762587+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2436 | 39322 | swimming_water_cyanobacteria | 2019-07-07T10:11:54.535726+0300 | 2019-07-08T10:11:54.535726+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2438 | 40386 | swimming_water_cyanobacteria | 2019-07-07T10:12:22.999601+0300 | 2019-07-08T10:12:22.999601+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2442 | 39815 | swimming_water_cyanobacteria | 2019-07-07T10:13:08.203457+0300 | 2019-07-08T10:13:08.203457+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2459 | 40142 | swimming_water_cyanobacteria | 2019-07-07T10:51:02.708468+0300 | 2019-07-08T10:51:02.708468+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2466 | 41601 | swimming_water_cyanobacteria | 2019-07-07T11:16:35.186047+0300 | 2019-07-08T11:16:35.186047+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2482 | 39322 | swimming_water_cyanobacteria | 2019-07-07T14:23:37.047967+0300 | 2019-07-08T14:23:37.047967+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2484 | 39322 | swimming_water_cyanobacteria | 2019-07-07T17:38:41.029874+0300 | 2019-07-08T17:38:41.029874+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2493 | 39815 | swimming_water_cyanobacteria | 2019-07-07T18:27:35.105793+0300 | 2019-07-08T18:27:35.105793+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2510 | 39815 | swimming_water_cyanobacteria | 2019-07-08T10:03:45.824722+0300 | 2019-07-09T10:03:45.824722+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2517 | 40386 | swimming_water_cyanobacteria | 2019-07-08T10:06:03.522102+0300 | 2019-07-09T10:06:03.522102+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2520 | 39322 | swimming_water_cyanobacteria | 2019-07-08T10:07:10.209892+0300 | 2019-07-09T10:07:10.209892+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2522 | 39583 | swimming_water_cyanobacteria | 2019-07-08T10:11:00.229872+0300 | 2019-07-09T10:11:00.229872+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2530 | 40098 | swimming_water_cyanobacteria | 2019-07-08T10:37:42.808934+0300 | 2019-07-09T10:37:42.808934+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2536 | 41601 | swimming_water_cyanobacteria | 2019-07-08T10:43:50.837346+0300 | 2019-07-09T10:43:50.837346+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2547 | 39527 | swimming_water_cyanobacteria | 2019-07-08T13:59:20.926898+0300 | 2019-07-09T13:59:20.926898+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2550 | 39815 | swimming_water_cyanobacteria | 2019-07-08T13:59:41.281687+0300 | 2019-07-09T13:59:41.281687+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2554 | 39583 | swimming_water_cyanobacteria | 2019-07-08T14:08:17.632755+0300 | 2019-07-09T14:08:17.632755+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2557 | 39322 | swimming_water_cyanobacteria | 2019-07-08T14:27:33.415891+0300 | 2019-07-09T14:27:33.415891+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2563 | 39583 | swimming_water_cyanobacteria | 2019-07-08T17:35:06.585027+0300 | 2019-07-09T17:35:06.585027+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2568 | 39815 | swimming_water_cyanobacteria | 2019-07-08T17:56:44.620364+0300 | 2019-07-09T17:56:44.620364+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2571 | 39322 | swimming_water_cyanobacteria | 2019-07-08T18:10:39.895060+0300 | 2019-07-09T18:10:39.895060+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2589 | 39322 | swimming_water_cyanobacteria | 2019-07-09T10:10:30.204916+0300 | 2019-07-10T10:10:30.204916+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2599 | 39815 | swimming_water_cyanobacteria | 2019-07-09T10:38:08.861511+0300 | 2019-07-10T10:38:08.861511+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2606 | 41601 | swimming_water_cyanobacteria | 2019-07-09T10:52:49.222381+0300 | 2019-07-10T10:52:49.222381+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2609 | 39568 | swimming_water_cyanobacteria | 2019-07-09T11:15:53.480698+0300 | 2019-07-10T11:15:53.480698+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2613 | 39322 | swimming_water_cyanobacteria | 2019-07-09T13:54:11.801709+0300 | 2019-07-10T13:54:11.801709+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2615 | 39815 | swimming_water_cyanobacteria | 2019-07-09T13:56:10.543955+0300 | 2019-07-10T13:56:10.543955+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2630 | 39322 | swimming_water_cyanobacteria | 2019-07-09T19:53:48.770335+0300 | 2019-07-10T19:53:48.770335+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2662 | 39527 | swimming_water_cyanobacteria | 2019-07-10T10:01:17.518970+0300 | 2019-07-11T10:01:17.518970+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2666 | 41601 | swimming_water_cyanobacteria | 2019-07-10T10:10:20.518154+0300 | 2019-07-11T10:10:20.518154+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2671 | 39583 | swimming_water_cyanobacteria | 2019-07-10T10:13:59.287717+0300 | 2019-07-11T10:13:59.287717+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2677 | 41601 | swimming_water_cyanobacteria | 2019-07-10T10:15:12.078780+0300 | 2019-07-11T10:15:12.078780+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2687 | 39322 | swimming_water_cyanobacteria | 2019-07-10T10:35:59.332060+0300 | 2019-07-11T10:35:59.332060+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2713 | 39322 | swimming_water_cyanobacteria | 2019-07-10T14:05:09.756723+0300 | 2019-07-11T14:05:09.756723+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2728 | 39322 | swimming_water_cyanobacteria | 2019-07-10T17:47:10.867307+0300 | 2019-07-11T17:47:10.867307+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2733 | 39568 | swimming_water_cyanobacteria | 2019-07-10T18:39:01.516424+0300 | 2019-07-11T18:39:01.516424+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2760 | 39322 | swimming_water_cyanobacteria | 2019-07-11T10:00:35.103499+0300 | 2019-07-12T10:00:35.103499+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2768 | 41601 | swimming_water_cyanobacteria | 2019-07-11T10:06:49.651209+0300 | 2019-07-12T10:06:49.651209+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2788 | 39568 | swimming_water_cyanobacteria | 2019-07-11T10:32:18.845388+0300 | 2019-07-12T10:32:18.845388+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2808 | 39322 | swimming_water_cyanobacteria | 2019-07-11T17:55:43.151100+0300 | 2019-07-12T17:55:43.151100+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2812 | 39568 | swimming_water_cyanobacteria | 2019-07-11T18:02:34.529361+0300 | 2019-07-12T18:02:34.529361+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2814 | 39322 | swimming_water_cyanobacteria | 2019-07-11T18:05:28.362791+0300 | 2019-07-12T18:05:28.362791+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2820 | 39693 | swimming_water_cyanobacteria | 2019-07-12T08:50:52.415153+0300 | 2019-07-13T08:50:52.415153+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2836 | 40142 | swimming_water_cyanobacteria | 2019-07-12T10:07:58.948754+0300 | 2019-07-13T10:07:58.948754+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2845 | 39583 | swimming_water_cyanobacteria | 2019-07-12T10:18:25.074449+0300 | 2019-07-13T10:18:25.074449+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2850 | 52959 | swimming_water_cyanobacteria | 2019-07-12T10:35:36.442768+0300 | 2019-07-13T10:35:36.442768+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2852 | 39322 | swimming_water_cyanobacteria | 2019-07-12T10:54:41.689066+0300 | 2019-07-13T10:54:41.689066+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2860 | 39693 | swimming_water_cyanobacteria | 2019-07-12T14:05:53.181607+0300 | 2019-07-13T14:05:53.181607+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2862 | 39583 | swimming_water_cyanobacteria | 2019-07-12T14:10:26.234102+0300 | 2019-07-13T14:10:26.234102+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2866 | 39322 | swimming_water_cyanobacteria | 2019-07-12T14:15:35.313011+0300 | 2019-07-13T14:15:35.313011+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2872 | 39527 | swimming_water_cyanobacteria | 2019-07-12T15:37:42.017035+0300 | 2019-07-13T15:37:42.017035+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2880 | 39693 | swimming_water_cyanobacteria | 2019-07-13T08:27:50.905470+0300 | 2019-07-14T08:27:50.905470+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2883 | 39527 | swimming_water_cyanobacteria | 2019-07-13T09:18:05.798631+0300 | 2019-07-14T09:18:05.798631+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2884 | 39693 | swimming_water_cyanobacteria | 2019-07-13T09:48:39.449859+0300 | 2019-07-14T09:48:39.449859+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2893 | 40142 | swimming_water_cyanobacteria | 2019-07-13T10:11:40.127586+0300 | 2019-07-14T10:11:40.127586+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2901 | 39568 | swimming_water_cyanobacteria | 2019-07-13T10:26:48.653404+0300 | 2019-07-14T10:26:48.653404+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2903 | 39322 | swimming_water_cyanobacteria | 2019-07-13T10:38:24.164022+0300 | 2019-07-14T10:38:24.164022+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2913 | 39583 | swimming_water_cyanobacteria | 2019-07-13T12:09:22.878069+0300 | 2019-07-14T12:09:22.878069+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2919 | 39583 | swimming_water_cyanobacteria | 2019-07-13T13:43:15.263507+0300 | 2019-07-14T13:43:15.263507+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2923 | 39322 | swimming_water_cyanobacteria | 2019-07-13T13:48:37.166113+0300 | 2019-07-14T13:48:37.166113+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2927 | 39693 | swimming_water_cyanobacteria | 2019-07-13T14:16:38.243255+0300 | 2019-07-14T14:16:38.243255+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2935 | 39568 | swimming_water_cyanobacteria | 2019-07-13T14:59:29.663234+0300 | 2019-07-14T14:59:29.663234+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2937 | 39583 | swimming_water_cyanobacteria | 2019-07-13T17:43:59.036516+0300 | 2019-07-14T17:43:59.036516+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2942 | 39322 | swimming_water_cyanobacteria | 2019-07-13T17:47:45.774983+0300 | 2019-07-14T17:47:45.774983+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2943 | 39693 | swimming_water_cyanobacteria | 2019-07-13T17:57:36.240675+0300 | 2019-07-14T17:57:36.240675+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2951 | 39568 | swimming_water_cyanobacteria | 2019-07-14T09:47:50.524645+0300 | 2019-07-15T09:47:50.524645+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2953 | 39322 | swimming_water_cyanobacteria | 2019-07-14T09:48:30.600004+0300 | 2019-07-15T09:48:30.600004+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2960 | 39693 | swimming_water_cyanobacteria | 2019-07-14T10:03:11.672693+0300 | 2019-07-15T10:03:11.672693+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2963 | 39583 | swimming_water_cyanobacteria | 2019-07-14T10:04:56.027840+0300 | 2019-07-15T10:04:56.027840+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2974 | 39568 | swimming_water_cyanobacteria | 2019-07-14T10:13:43.776200+0300 | 2019-07-15T10:13:43.776200+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2986 | 40142 | swimming_water_cyanobacteria | 2019-07-14T12:30:58.204151+0300 | 2019-07-15T12:30:58.204151+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2988 | 39693 | swimming_water_cyanobacteria | 2019-07-14T13:47:59.750543+0300 | 2019-07-15T13:47:59.750543+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2997 | 39322 | swimming_water_cyanobacteria | 2019-07-14T13:56:17.053988+0300 | 2019-07-15T13:56:17.053988+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3002 | 39583 | swimming_water_cyanobacteria | 2019-07-14T14:04:29.698381+0300 | 2019-07-15T14:04:29.698381+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3007 | 52959 | swimming_water_cyanobacteria | 2019-07-14T15:07:04.764863+0300 | 2019-07-15T15:07:04.764863+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3010 | 39583 | swimming_water_cyanobacteria | 2019-07-14T17:34:13.801655+0300 | 2019-07-15T17:34:13.801655+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3013 | 39693 | swimming_water_cyanobacteria | 2019-07-14T17:37:47.474172+0300 | 2019-07-15T17:37:47.474172+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3021 | 39322 | swimming_water_cyanobacteria | 2019-07-14T17:58:18.174559+0300 | 2019-07-15T17:58:18.174559+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3023 | 39568 | swimming_water_cyanobacteria | 2019-07-14T19:35:23.291217+0300 | 2019-07-15T19:35:23.291217+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3025 | 39568 | swimming_water_cyanobacteria | 2019-07-15T08:32:13.133901+0300 | 2019-07-16T08:32:13.133901+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3027 | 39693 | swimming_water_cyanobacteria | 2019-07-15T09:32:31.403186+0300 | 2019-07-16T09:32:31.403186+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3029 | 39815 | swimming_water_cyanobacteria | 2019-07-15T09:48:22.415527+0300 | 2019-07-16T09:48:22.415527+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3045 | 41791 | swimming_water_cyanobacteria | 2019-07-15T10:09:08.774311+0300 | 2019-07-16T10:09:08.774311+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3047 | 39527 | swimming_water_cyanobacteria | 2019-07-15T10:10:08.944991+0300 | 2019-07-16T10:10:08.944991+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3059 | 40559 | swimming_water_cyanobacteria | 2019-07-15T10:16:54.375212+0300 | 2019-07-16T10:16:54.375212+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3064 | 41601 | swimming_water_cyanobacteria | 2019-07-15T10:22:56.309272+0300 | 2019-07-16T10:22:56.309272+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3066 | 40386 | swimming_water_cyanobacteria | 2019-07-15T10:27:57.491685+0300 | 2019-07-16T10:27:57.491685+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3079 | 39322 | swimming_water_cyanobacteria | 2019-07-15T11:25:30.110406+0300 | 2019-07-16T11:25:30.110406+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3083 | 39606 | swimming_water_cyanobacteria | 2019-07-15T11:31:44.643711+0300 | 2019-07-16T11:31:44.643711+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3086 | 39693 | swimming_water_cyanobacteria | 2019-07-15T13:57:46.235020+0300 | 2019-07-16T13:57:46.235020+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3091 | 39815 | swimming_water_cyanobacteria | 2019-07-15T14:06:45.104969+0300 | 2019-07-16T14:06:45.104969+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory |
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 );