observation
1,026 rows where quality = "unusable" sorted by unit
This data as json, CSV (advanced)
Suggested facets: property, name_fi, name_sv, name_en, value
id | unit ▼ | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
721 | 39267 | swimming_water_cyanobacteria | 2019-06-14T10:05:35.446913+0300 | 2019-06-15T10:05:35.446913+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1474 | 39267 | swimming_water_cyanobacteria | 2019-06-25T10:16:50.559655+0300 | 2019-06-26T10:16:50.559655+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1500 | 39267 | swimming_water_cyanobacteria | 2019-06-25T13:56:40.296869+0300 | 2019-06-26T13:56:40.296869+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
1538 | 39267 | swimming_water_cyanobacteria | 2019-06-25T17:45:28.044838+0300 | 2019-06-26T17:45:28.044838+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
1557 | 39267 | swimming_water_cyanobacteria | 2019-06-26T10:21:56.337607+0300 | 2019-06-27T10:21:56.337607+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
1579 | 39267 | swimming_water_cyanobacteria | 2019-06-26T14:05:07.395076+0300 | 2019-06-27T14:05:07.395076+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1590 | 39267 | swimming_water_cyanobacteria | 2019-06-26T18:01:32.930330+0300 | 2019-06-27T18:01:32.930330+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1615 | 39267 | swimming_water_cyanobacteria | 2019-06-27T10:12:28.446126+0300 | 2019-06-28T10:12:28.446126+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1723 | 39267 | swimming_water_cyanobacteria | 2019-06-28T10:03:13.874257+0300 | 2019-06-29T10:03:13.874257+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1757 | 39267 | swimming_water_cyanobacteria | 2019-06-28T14:01:32.873491+0300 | 2019-06-29T14:01:32.873491+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1776 | 39267 | swimming_water_cyanobacteria | 2019-06-28T17:42:49.663827+0300 | 2019-06-29T17:42:49.663827+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1790 | 39267 | swimming_water_cyanobacteria | 2019-06-29T09:59:32.992284+0300 | 2019-06-30T09:59:32.992284+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1834 | 39267 | swimming_water_cyanobacteria | 2019-06-29T13:56:10.814640+0300 | 2019-06-30T13:56:10.814640+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1847 | 39267 | swimming_water_cyanobacteria | 2019-06-29T17:48:50.016329+0300 | 2019-06-30T17:48:50.016329+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1877 | 39267 | swimming_water_cyanobacteria | 2019-06-30T10:12:26.595205+0300 | 2019-07-01T10:12:26.595205+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1908 | 39267 | swimming_water_cyanobacteria | 2019-06-30T14:03:13.873297+0300 | 2019-07-01T14:03:13.873297+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1924 | 39267 | swimming_water_cyanobacteria | 2019-06-30T17:38:59.481516+0300 | 2019-07-01T17:38:59.481516+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1954 | 39267 | swimming_water_cyanobacteria | 2019-07-01T09:59:39.080433+0300 | 2019-07-02T09:59:39.080433+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2010 | 39267 | swimming_water_cyanobacteria | 2019-07-01T13:51:48.992729+0300 | 2019-07-02T13:51:48.992729+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2037 | 39267 | swimming_water_cyanobacteria | 2019-07-01T17:49:59.217861+0300 | 2019-07-02T17:49:59.217861+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2115 | 39267 | swimming_water_cyanobacteria | 2019-07-03T10:15:50.706358+0300 | 2019-07-04T10:15:50.706358+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2143 | 39267 | swimming_water_cyanobacteria | 2019-07-03T14:13:04.257612+0300 | 2019-07-04T14:13:04.257612+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2190 | 39267 | swimming_water_cyanobacteria | 2019-07-04T10:10:15.014333+0300 | 2019-07-05T10:10:15.014333+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2234 | 39267 | swimming_water_cyanobacteria | 2019-07-04T14:12:16.814909+0300 | 2019-07-05T14:12:16.814909+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2245 | 39267 | swimming_water_cyanobacteria | 2019-07-04T17:45:33.968651+0300 | 2019-07-05T17:45:33.968651+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2318 | 39267 | swimming_water_cyanobacteria | 2019-07-05T12:33:19.308854+0300 | 2019-07-06T12:33:19.308854+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2327 | 39267 | swimming_water_cyanobacteria | 2019-07-05T14:05:15.534562+0300 | 2019-07-06T14:05:15.534562+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2340 | 39267 | swimming_water_cyanobacteria | 2019-07-05T18:00:10.779753+0300 | 2019-07-06T18:00:10.779753+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2375 | 39267 | swimming_water_cyanobacteria | 2019-07-06T10:17:52.405252+0300 | 2019-07-07T10:17:52.405252+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2401 | 39267 | swimming_water_cyanobacteria | 2019-07-06T14:04:07.409313+0300 | 2019-07-07T14:04:07.409313+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2412 | 39267 | swimming_water_cyanobacteria | 2019-07-06T17:48:28.825465+0300 | 2019-07-07T17:48:28.825465+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2430 | 39267 | swimming_water_cyanobacteria | 2019-07-07T10:03:18.702191+0300 | 2019-07-08T10:03:18.702191+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2472 | 39267 | swimming_water_cyanobacteria | 2019-07-07T13:54:31.207894+0300 | 2019-07-08T13:54:31.207894+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2489 | 39267 | swimming_water_cyanobacteria | 2019-07-07T17:53:55.571998+0300 | 2019-07-08T17:53:55.571998+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2508 | 39267 | swimming_water_cyanobacteria | 2019-07-08T10:01:28.571989+0300 | 2019-07-09T10:01:28.571989+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2545 | 39267 | swimming_water_cyanobacteria | 2019-07-08T13:53:53.200144+0300 | 2019-07-09T13:53:53.200144+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2566 | 39267 | swimming_water_cyanobacteria | 2019-07-08T17:37:16.075515+0300 | 2019-07-09T17:37:16.075515+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2604 | 39267 | swimming_water_cyanobacteria | 2019-07-09T10:50:33.661335+0300 | 2019-07-10T10:50:33.661335+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2621 | 39267 | swimming_water_cyanobacteria | 2019-07-09T16:00:54.993722+0300 | 2019-07-10T16:00:54.993722+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2623 | 39267 | swimming_water_cyanobacteria | 2019-07-09T17:48:16.860886+0300 | 2019-07-10T17:48:16.860886+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2660 | 39267 | swimming_water_cyanobacteria | 2019-07-10T10:00:53.096823+0300 | 2019-07-11T10:00:53.096823+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2717 | 39267 | swimming_water_cyanobacteria | 2019-07-10T14:49:59.596844+0300 | 2019-07-11T14:49:59.596844+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2726 | 39267 | swimming_water_cyanobacteria | 2019-07-10T17:46:26.116613+0300 | 2019-07-11T17:46:26.116613+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2802 | 39267 | swimming_water_cyanobacteria | 2019-07-11T15:15:41.153681+0300 | 2019-07-12T15:15:41.153681+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2803 | 39267 | swimming_water_cyanobacteria | 2019-07-11T15:15:43.693659+0300 | 2019-07-12T15:15:43.693659+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2810 | 39267 | swimming_water_cyanobacteria | 2019-07-11T17:57:50.323784+0300 | 2019-07-12T17:57:50.323784+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2828 | 39267 | swimming_water_cyanobacteria | 2019-07-12T10:04:30.878488+0300 | 2019-07-13T10:04:30.878488+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2858 | 39267 | swimming_water_cyanobacteria | 2019-07-12T14:01:16.595045+0300 | 2019-07-13T14:01:16.595045+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2874 | 39267 | swimming_water_cyanobacteria | 2019-07-12T17:47:59.735519+0300 | 2019-07-13T17:47:59.735519+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2888 | 39267 | swimming_water_cyanobacteria | 2019-07-13T10:03:16.125405+0300 | 2019-07-14T10:03:16.125405+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2933 | 39267 | swimming_water_cyanobacteria | 2019-07-13T14:39:08.561550+0300 | 2019-07-14T14:39:08.561550+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2940 | 39267 | swimming_water_cyanobacteria | 2019-07-13T17:45:44.945271+0300 | 2019-07-14T17:45:44.945271+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2976 | 39267 | swimming_water_cyanobacteria | 2019-07-14T10:15:00.625315+0300 | 2019-07-15T10:15:00.625315+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3005 | 39267 | swimming_water_cyanobacteria | 2019-07-14T14:53:53.347520+0300 | 2019-07-15T14:53:53.347520+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3016 | 39267 | swimming_water_cyanobacteria | 2019-07-14T17:52:36.351142+0300 | 2019-07-15T17:52:36.351142+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3038 | 39267 | swimming_water_cyanobacteria | 2019-07-15T10:04:23.444120+0300 | 2019-07-16T10:04:23.444120+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3099 | 39267 | swimming_water_cyanobacteria | 2019-07-15T14:28:31.862333+0300 | 2019-07-16T14:28:31.862333+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3106 | 39267 | swimming_water_cyanobacteria | 2019-07-15T17:44:12.716109+0300 | 2019-07-16T17:44:12.716109+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3119 | 39267 | swimming_water_cyanobacteria | 2019-07-16T09:59:50.396099+0300 | 2019-07-17T09:59:50.396099+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3163 | 39267 | swimming_water_cyanobacteria | 2019-07-16T15:10:01.452514+0300 | 2019-07-17T15:10:01.452514+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3201 | 39267 | swimming_water_cyanobacteria | 2019-07-17T10:05:57.343600+0300 | 2019-07-18T10:05:57.343600+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3247 | 39267 | swimming_water_cyanobacteria | 2019-07-17T14:02:55.800300+0300 | 2019-07-18T14:02:55.800300+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3263 | 39267 | swimming_water_cyanobacteria | 2019-07-17T17:50:39.340483+0300 | 2019-07-18T17:50:39.340483+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3293 | 39267 | swimming_water_cyanobacteria | 2019-07-18T09:59:50.826852+0300 | 2019-07-19T09:59:50.826852+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3357 | 39267 | swimming_water_cyanobacteria | 2019-07-18T14:12:18.732739+0300 | 2019-07-19T14:12:18.732739+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
3386 | 39267 | swimming_water_cyanobacteria | 2019-07-18T17:52:23.015217+0300 | 2019-07-19T17:52:23.015217+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
3432 | 39267 | swimming_water_cyanobacteria | 2019-07-19T10:13:11.926419+0300 | 2019-07-20T10:13:11.926419+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
3470 | 39267 | swimming_water_cyanobacteria | 2019-07-19T13:53:36.819492+0300 | 2019-07-20T13:53:36.819492+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3519 | 39267 | swimming_water_cyanobacteria | 2019-07-19T17:43:27.178015+0300 | 2019-07-20T17:43:27.178015+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
3538 | 39267 | swimming_water_cyanobacteria | 2019-07-20T09:57:57.706804+0300 | 2019-07-21T09:57:57.706804+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
3588 | 39267 | swimming_water_cyanobacteria | 2019-07-20T14:01:40.424177+0300 | 2019-07-21T14:01:40.424177+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
3604 | 39267 | swimming_water_cyanobacteria | 2019-07-20T17:45:29.995612+0300 | 2019-07-21T17:45:29.995612+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
3657 | 39267 | swimming_water_cyanobacteria | 2019-07-21T10:40:05.044381+0300 | 2019-07-22T10:40:05.044381+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
3685 | 39267 | swimming_water_cyanobacteria | 2019-07-21T14:16:11.695215+0300 | 2019-07-22T14:16:11.695215+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
3693 | 39267 | swimming_water_cyanobacteria | 2019-07-21T17:48:03.581398+0300 | 2019-07-22T17:48:03.581398+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
3788 | 39267 | swimming_water_cyanobacteria | 2019-07-22T10:30:32.509663+0300 | 2019-07-23T10:30:32.509663+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
3803 | 39267 | swimming_water_cyanobacteria | 2019-07-22T14:08:04.367743+0300 | 2019-07-23T14:08:04.367743+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
3814 | 39267 | swimming_water_cyanobacteria | 2019-07-22T17:42:46.894045+0300 | 2019-07-23T17:42:46.894045+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
3892 | 39267 | swimming_water_cyanobacteria | 2019-07-23T10:28:51.269186+0300 | 2019-07-24T10:28:51.269186+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
3932 | 39267 | swimming_water_cyanobacteria | 2019-07-23T17:39:41.338508+0300 | 2019-07-24T17:39:41.338508+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3962 | 39267 | swimming_water_cyanobacteria | 2019-07-24T10:01:11.837366+0300 | 2019-07-25T10:01:11.837366+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
4069 | 39267 | swimming_water_cyanobacteria | 2019-07-24T17:48:06.183927+0300 | 2019-07-25T17:48:06.183927+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
4113 | 39267 | swimming_water_cyanobacteria | 2019-07-25T10:16:00.668792+0300 | 2019-07-26T10:16:00.668792+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
4177 | 39267 | swimming_water_cyanobacteria | 2019-07-25T14:04:48.980385+0300 | 2019-07-26T14:04:48.980385+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
4202 | 39267 | swimming_water_cyanobacteria | 2019-07-25T17:48:48.714107+0300 | 2019-07-26T17:48:48.714107+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
4255 | 39267 | swimming_water_cyanobacteria | 2019-07-26T10:04:16.345992+0300 | 2019-07-27T10:04:16.345992+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
4339 | 39267 | swimming_water_cyanobacteria | 2019-07-26T14:08:51.830789+0300 | 2019-07-27T14:08:51.830789+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
4347 | 39267 | swimming_water_cyanobacteria | 2019-07-26T17:32:58.213239+0300 | 2019-07-27T17:32:58.213239+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
4478 | 39267 | swimming_water_cyanobacteria | 2019-07-27T17:44:13.370271+0300 | 2019-07-28T17:44:13.370271+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
4527 | 39267 | swimming_water_cyanobacteria | 2019-07-28T14:26:42.693130+0300 | 2019-07-29T14:26:42.693130+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
4528 | 39267 | swimming_water_cyanobacteria | 2019-07-28T14:26:48.426702+0300 | 2019-07-29T14:26:48.426702+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
4545 | 39267 | swimming_water_cyanobacteria | 2019-07-28T17:51:04.347677+0300 | 2019-07-29T17:51:04.347677+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
4548 | 39267 | swimming_water_cyanobacteria | 2019-07-28T17:51:29.366868+0300 | 2019-07-29T17:51:29.366868+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
4605 | 39267 | swimming_water_cyanobacteria | 2019-07-29T10:01:46.931835+0300 | 2019-07-30T10:01:46.931835+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
4670 | 39267 | swimming_water_cyanobacteria | 2019-07-29T16:29:39.539074+0300 | 2019-07-30T16:29:39.539074+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
4679 | 39267 | swimming_water_cyanobacteria | 2019-07-29T17:45:26.230935+0300 | 2019-07-30T17:45:26.230935+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
4694 | 39267 | swimming_water_cyanobacteria | 2019-07-30T10:02:15.097382+0300 | 2019-07-31T10:02:15.097382+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
4743 | 39267 | swimming_water_cyanobacteria | 2019-07-30T15:03:18.832264+0300 | 2019-07-31T15:03:18.832264+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
4749 | 39267 | swimming_water_cyanobacteria | 2019-07-30T17:56:22.798647+0300 | 2019-07-31T17:56:22.798647+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
4792 | 39267 | swimming_water_cyanobacteria | 2019-07-31T10:34:59.167817+0300 | 2019-08-01T10:34:59.167817+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable |
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 );