observation
1,881 rows where name_en = "Some 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5864 | 39267 | swimming_water_cyanobacteria | 2019-08-13T13:15:09.867444+0300 | 2019-08-14T13:15:09.867444+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 9018 | 39267 | swimming_water_cyanobacteria | 2020-06-10T15:00:41.346075+0300 | 2020-06-11T15:00:41.346075+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 9546 | 39267 | swimming_water_cyanobacteria | 2020-06-17T08:55:14.110789+0300 | 2020-06-18T08:55:14.110789+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 9903 | 39267 | swimming_water_cyanobacteria | 2020-06-23T09:47:48.412424+0300 | 2020-06-24T09:47:48.412424+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 10984 | 39267 | swimming_water_cyanobacteria | 2020-07-07T10:15:46.533076+0300 | 2020-07-08T10:15:46.533076+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 11212 | 39267 | swimming_water_cyanobacteria | 2020-07-10T13:53:47.960100+0300 | 2020-07-11T13:53:47.960100+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 11471 | 39267 | swimming_water_cyanobacteria | 2020-07-14T11:36:23.886845+0300 | 2020-07-15T11:36:23.886845+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 11476 | 39267 | swimming_water_cyanobacteria | 2020-07-14T11:53:40.538476+0300 | 2020-07-15T11:53:40.538476+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 11921 | 39267 | swimming_water_cyanobacteria | 2020-07-20T13:02:32.227694+0300 | 2020-07-21T13:02:32.227694+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12013 | 39267 | swimming_water_cyanobacteria | 2020-07-21T13:22:33.319277+0300 | 2020-07-22T13:22:33.319277+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12177 | 39267 | swimming_water_cyanobacteria | 2020-07-23T10:45:18.410944+0300 | 2020-07-24T10:45:18.410944+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12439 | 39267 | swimming_water_cyanobacteria | 2020-07-27T09:01:35.765373+0300 | 2020-07-28T09:01:35.765373+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12537 | 39267 | swimming_water_cyanobacteria | 2020-07-28T09:50:33.145582+0300 | 2020-07-29T09:50:33.145582+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12624 | 39267 | swimming_water_cyanobacteria | 2020-07-29T09:07:29.012877+0300 | 2020-07-30T09:07:29.012877+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12700 | 39267 | swimming_water_cyanobacteria | 2020-07-30T08:45:05.285060+0300 | 2020-07-31T08:45:05.285060+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12912 | 39267 | swimming_water_cyanobacteria | 2020-08-02T09:32:04.916957+0300 | 2020-08-03T09:32:04.916957+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13006 | 39267 | swimming_water_cyanobacteria | 2020-08-03T08:54:47.384097+0300 | 2020-08-04T08:54:47.384097+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13102 | 39267 | swimming_water_cyanobacteria | 2020-08-04T07:55:42.342787+0300 | 2020-08-05T07:55:42.342787+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13274 | 39267 | swimming_water_cyanobacteria | 2020-08-06T08:30:34.713181+0300 | 2020-08-07T08:30:34.713181+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 717 | 39322 | swimming_water_cyanobacteria | 2019-06-14T10:00:58.201406+0300 | 2019-06-15T10:00:58.201406+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 744 | 39322 | swimming_water_cyanobacteria | 2019-06-14T14:18:28.067442+0300 | 2019-06-15T14:18:28.067442+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 758 | 39322 | swimming_water_cyanobacteria | 2019-06-15T10:03:00.084007+0300 | 2019-06-16T10:03:00.084007+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 786 | 39322 | swimming_water_cyanobacteria | 2019-06-15T13:56:50.232653+0300 | 2019-06-16T13:56:50.232653+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 797 | 39322 | swimming_water_cyanobacteria | 2019-06-15T18:21:02.700288+0300 | 2019-06-16T18:21:02.700288+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 838 | 39322 | swimming_water_cyanobacteria | 2019-06-16T10:12:33.333738+0300 | 2019-06-17T10:12:33.333738+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 885 | 39322 | swimming_water_cyanobacteria | 2019-06-16T19:01:24.551603+0300 | 2019-06-17T19:01:24.551603+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 901 | 39322 | swimming_water_cyanobacteria | 2019-06-17T09:59:22.763374+0300 | 2019-06-18T09:59:22.763374+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 936 | 39322 | swimming_water_cyanobacteria | 2019-06-17T14:01:44.234876+0300 | 2019-06-18T14:01:44.234876+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 983 | 39322 | swimming_water_cyanobacteria | 2019-06-18T10:07:47.333863+0300 | 2019-06-19T10:07:47.333863+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1006 | 39322 | swimming_water_cyanobacteria | 2019-06-18T14:03:14.340740+0300 | 2019-06-19T14:03:14.340740+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1038 | 39322 | swimming_water_cyanobacteria | 2019-06-19T10:00:26.305094+0300 | 2019-06-20T10:00:26.305094+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1084 | 39322 | swimming_water_cyanobacteria | 2019-06-19T13:56:46.993234+0300 | 2019-06-20T13:56:46.993234+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1098 | 39322 | swimming_water_cyanobacteria | 2019-06-19T17:53:36.466152+0300 | 2019-06-20T17:53:36.466152+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1181 | 39322 | swimming_water_cyanobacteria | 2019-06-20T13:58:41.832594+0300 | 2019-06-21T13:58:41.832594+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1202 | 39322 | swimming_water_cyanobacteria | 2019-06-20T18:02:21.445164+0300 | 2019-06-21T18:02:21.445164+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1397 | 39322 | swimming_water_cyanobacteria | 2019-06-24T10:33:36.584280+0300 | 2019-06-25T10:33:36.584280+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1425 | 39322 | swimming_water_cyanobacteria | 2019-06-24T14:04:44.674751+0300 | 2019-06-25T14:04:44.674751+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1449 | 39322 | swimming_water_cyanobacteria | 2019-06-24T17:52:10.527939+0300 | 2019-06-25T17:52:10.527939+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1460 | 39322 | swimming_water_cyanobacteria | 2019-06-25T09:58:01.979120+0300 | 2019-06-26T09:58:01.979120+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1505 | 39322 | swimming_water_cyanobacteria | 2019-06-25T14:08:33.887406+0300 | 2019-06-26T14:08:33.887406+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1507 | 39322 | swimming_water_cyanobacteria | 2019-06-25T14:10:42.476694+0300 | 2019-06-26T14:10:42.476694+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1540 | 39322 | swimming_water_cyanobacteria | 2019-06-25T18:03:56.606592+0300 | 2019-06-26T18:03:56.606592+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1544 | 39322 | swimming_water_cyanobacteria | 2019-06-26T09:55:55.767975+0300 | 2019-06-27T09:55:55.767975+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1573 | 39322 | swimming_water_cyanobacteria | 2019-06-26T13:52:26.906961+0300 | 2019-06-27T13:52:26.906961+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1628 | 39322 | swimming_water_cyanobacteria | 2019-06-27T10:35:09.795856+0300 | 2019-06-28T10:35:09.795856+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1705 | 39322 | swimming_water_cyanobacteria | 2019-06-27T16:24:47.173505+0300 | 2019-06-28T16:24:47.173505+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1721 | 39322 | swimming_water_cyanobacteria | 2019-06-28T10:00:59.474031+0300 | 2019-06-29T10:00:59.474031+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1764 | 39322 | swimming_water_cyanobacteria | 2019-06-28T14:21:32.390873+0300 | 2019-06-29T14:21:32.390873+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1778 | 39322 | swimming_water_cyanobacteria | 2019-06-28T17:51:59.414157+0300 | 2019-06-29T17:51:59.414157+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1806 | 39322 | swimming_water_cyanobacteria | 2019-06-29T10:19:54.272740+0300 | 2019-06-30T10:19:54.272740+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1838 | 39322 | swimming_water_cyanobacteria | 2019-06-29T14:03:54.226123+0300 | 2019-06-30T14:03:54.226123+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1851 | 39322 | swimming_water_cyanobacteria | 2019-06-29T18:21:58.029858+0300 | 2019-06-30T18:21:58.029858+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1857 | 39322 | swimming_water_cyanobacteria | 2019-06-30T09:56:23.210698+0300 | 2019-07-01T09:56:23.210698+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1906 | 39322 | swimming_water_cyanobacteria | 2019-06-30T14:00:14.623297+0300 | 2019-07-01T14:00:14.623297+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 1926 | 39322 | swimming_water_cyanobacteria | 2019-06-30T17:52:02.455156+0300 | 2019-07-01T17:52:02.455156+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2141 | 39322 | swimming_water_cyanobacteria | 2019-07-03T14:07:26.672705+0300 | 2019-07-04T14:07:26.672705+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2149 | 39322 | swimming_water_cyanobacteria | 2019-07-03T17:49:17.748178+0300 | 2019-07-04T17:49:17.748178+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2169 | 39322 | swimming_water_cyanobacteria | 2019-07-04T09:59:17.027506+0300 | 2019-07-05T09:59:17.027506+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2240 | 39322 | swimming_water_cyanobacteria | 2019-07-04T14:32:02.920270+0300 | 2019-07-05T14:32:02.920270+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 3100 | 39322 | swimming_water_cyanobacteria | 2019-07-15T15:03:55.233636+0300 | 2019-07-16T15:03:55.233636+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3111 | 39322 | swimming_water_cyanobacteria | 2019-07-15T18:04:50.129862+0300 | 2019-07-16T18:04:50.129862+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3138 | 39322 | swimming_water_cyanobacteria | 2019-07-16T10:10:35.623583+0300 | 2019-07-17T10:10:35.623583+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3165 | 39322 | swimming_water_cyanobacteria | 2019-07-16T15:32:04.883100+0300 | 2019-07-17T15:32:04.883100+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3180 | 39322 | swimming_water_cyanobacteria | 2019-07-16T18:33:50.098926+0300 | 2019-07-17T18:33:50.098926+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3230 | 39322 | swimming_water_cyanobacteria | 2019-07-17T11:01:57.841503+0300 | 2019-07-18T11:01:57.841503+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3245 | 39322 | swimming_water_cyanobacteria | 2019-07-17T13:55:21.981307+0300 | 2019-07-18T13:55:21.981307+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3265 | 39322 | swimming_water_cyanobacteria | 2019-07-17T17:57:53.899676+0300 | 2019-07-18T17:57:53.899676+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3301 | 39322 | swimming_water_cyanobacteria | 2019-07-18T10:08:20.707711+0300 | 2019-07-19T10:08:20.707711+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3351 | 39322 | swimming_water_cyanobacteria | 2019-07-18T13:52:32.791240+0300 | 2019-07-19T13:52:32.791240+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3389 | 39322 | swimming_water_cyanobacteria | 2019-07-18T17:59:19.104205+0300 | 2019-07-19T17:59:19.104205+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 );