observation
1,026 rows where quality = "unusable"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
3402 | 53461 | swimming_water_cyanobacteria | 2019-07-19T09:16:03.327541+0300 | 2019-07-20T09:16:03.327541+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3404 | 53461 | swimming_water_cyanobacteria | 2019-07-19T09:20:50.307893+0300 | 2019-07-20T09:20:50.307893+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3420 | 39583 | swimming_water_cyanobacteria | 2019-07-19T10:03:22.509012+0300 | 2019-07-20T10:03:22.509012+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
3465 | 39583 | swimming_water_cyanobacteria | 2019-07-19T13:52:04.766390+0300 | 2019-07-20T13:52:04.766390+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3467 | 39583 | swimming_water_cyanobacteria | 2019-07-19T13:53:23.293224+0300 | 2019-07-20T13:53:23.293224+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
3480 | 39527 | swimming_water_cyanobacteria | 2019-07-19T14:41:12.269014+0300 | 2019-07-20T14:41:12.269014+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3516 | 39583 | swimming_water_cyanobacteria | 2019-07-19T17:25:04.824242+0300 | 2019-07-20T17:25:04.824242+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 | |||
3533 | 39527 | swimming_water_cyanobacteria | 2019-07-20T08:47:39.978851+0300 | 2019-07-21T08:47:39.978851+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
3547 | 40386 | swimming_water_cyanobacteria | 2019-07-20T10:08:39.529031+0300 | 2019-07-21T10:08:39.529031+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3576 | 39583 | swimming_water_cyanobacteria | 2019-07-20T11:58:18.430441+0300 | 2019-07-21T11:58:18.430441+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3585 | 39583 | swimming_water_cyanobacteria | 2019-07-20T13:55:53.809412+0300 | 2019-07-21T13:55:53.809412+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
3602 | 39583 | swimming_water_cyanobacteria | 2019-07-20T17:44:28.572520+0300 | 2019-07-21T17:44:28.572520+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
3613 | 39568 | swimming_water_cyanobacteria | 2019-07-21T08:42:23.736159+0300 | 2019-07-22T08:42:23.736159+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3617 | 41960 | swimming_water_cyanobacteria | 2019-07-21T09:56:07.401933+0300 | 2019-07-22T09:56:07.401933+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
3624 | 40559 | swimming_water_cyanobacteria | 2019-07-21T10:02:11.169775+0300 | 2019-07-22T10:02:11.169775+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3626 | 41601 | swimming_water_cyanobacteria | 2019-07-21T10:03:13.812596+0300 | 2019-07-22T10:03:13.812596+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3628 | 40802 | swimming_water_cyanobacteria | 2019-07-21T10:03:33.026251+0300 | 2019-07-22T10:03:33.026251+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3632 | 40386 | swimming_water_cyanobacteria | 2019-07-21T10:10:30.874198+0300 | 2019-07-22T10:10:30.874198+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3635 | 40142 | swimming_water_cyanobacteria | 2019-07-21T10:14:38.593823+0300 | 2019-07-22T10:14:38.593823+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3641 | 39583 | swimming_water_cyanobacteria | 2019-07-21T10:20:12.716068+0300 | 2019-07-22T10:20:12.716068+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
3660 | 39568 | swimming_water_cyanobacteria | 2019-07-21T11:06:31.177030+0300 | 2019-07-22T11:06:31.177030+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
3661 | 39693 | swimming_water_cyanobacteria | 2019-07-21T11:30:23.806478+0300 | 2019-07-22T11:30:23.806478+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3663 | 39846 | swimming_water_cyanobacteria | 2019-07-21T13:44:07.454605+0300 | 2019-07-22T13:44:07.454605+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3667 | 39693 | swimming_water_cyanobacteria | 2019-07-21T13:44:56.048505+0300 | 2019-07-22T13:44:56.048505+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3673 | 39568 | swimming_water_cyanobacteria | 2019-07-21T13:58:13.445019+0300 | 2019-07-22T13:58:13.445019+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
3679 | 39583 | swimming_water_cyanobacteria | 2019-07-21T14:02:54.010760+0300 | 2019-07-22T14:02:54.010760+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
3688 | 40098 | swimming_water_cyanobacteria | 2019-07-21T16:10:08.369647+0300 | 2019-07-22T16:10:08.369647+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3690 | 39693 | swimming_water_cyanobacteria | 2019-07-21T17:30:20.842783+0300 | 2019-07-22T17:30:20.842783+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
3699 | 39527 | swimming_water_cyanobacteria | 2019-07-21T18:14:40.535020+0300 | 2019-07-22T18:14:40.535020+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3703 | 39568 | swimming_water_cyanobacteria | 2019-07-21T19:59:13.334056+0300 | 2019-07-22T19:59:13.334056+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3709 | 39527 | swimming_water_cyanobacteria | 2019-07-21T20:00:58.917224+0300 | 2019-07-22T20:00:58.917224+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3726 | 41326 | swimming_water_cyanobacteria | 2019-07-22T08:11:56.421547+0300 | 2019-07-23T08:11:56.421547+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3730 | 39568 | swimming_water_cyanobacteria | 2019-07-22T08:16:08.894946+0300 | 2019-07-23T08:16:08.894946+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3732 | 39568 | swimming_water_cyanobacteria | 2019-07-22T08:16:18.899205+0300 | 2019-07-23T08:16:18.899205+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3734 | 40921 | swimming_water_cyanobacteria | 2019-07-22T08:16:30.286356+0300 | 2019-07-23T08:16:30.286356+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3739 | 40798 | swimming_water_cyanobacteria | 2019-07-22T08:17:09.444473+0300 | 2019-07-23T08:17:09.444473+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3752 | 39527 | swimming_water_cyanobacteria | 2019-07-22T09:30:27.536267+0300 | 2019-07-23T09:30:27.536267+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3757 | 39693 | swimming_water_cyanobacteria | 2019-07-22T09:35:17.056241+0300 | 2019-07-23T09:35:17.056241+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3764 | 40559 | swimming_water_cyanobacteria | 2019-07-22T10:02:48.084565+0300 | 2019-07-23T10:02:48.084565+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3777 | 41960 | swimming_water_cyanobacteria | 2019-07-22T10:08:24.492906+0300 | 2019-07-23T10:08:24.492906+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3783 | 39583 | swimming_water_cyanobacteria | 2019-07-22T10:21:28.514540+0300 | 2019-07-23T10:21:28.514540+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
3797 | 52959 | swimming_water_cyanobacteria | 2019-07-22T11:57:35.791785+0300 | 2019-07-23T11:57:35.791785+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
3807 | 39568 | swimming_water_cyanobacteria | 2019-07-22T14:23:09.247433+0300 | 2019-07-23T14:23:09.247433+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3809 | 39583 | swimming_water_cyanobacteria | 2019-07-22T14:42:48.954718+0300 | 2019-07-23T14:42:48.954718+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
3818 | 39693 | swimming_water_cyanobacteria | 2019-07-22T18:07:27.941291+0300 | 2019-07-23T18:07:27.941291+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3825 | 39568 | swimming_water_cyanobacteria | 2019-07-22T19:13:11.853299+0300 | 2019-07-23T19:13:11.853299+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3841 | 53461 | swimming_water_cyanobacteria | 2019-07-23T09:25:30.942641+0300 | 2019-07-24T09:25:30.942641+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3843 | 39527 | swimming_water_cyanobacteria | 2019-07-23T09:50:36.047398+0300 | 2019-07-24T09:50:36.047398+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3846 | 41960 | swimming_water_cyanobacteria | 2019-07-23T09:57:26.301117+0300 | 2019-07-24T09:57:26.301117+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3847 | 40802 | swimming_water_cyanobacteria | 2019-07-23T09:57:30.687984+0300 | 2019-07-24T09:57:30.687984+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3852 | 40386 | swimming_water_cyanobacteria | 2019-07-23T10:03:21.674988+0300 | 2019-07-24T10:03:21.674988+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3858 | 40559 | swimming_water_cyanobacteria | 2019-07-23T10:08:51.899025+0300 | 2019-07-24T10:08:51.899025+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3863 | 40142 | swimming_water_cyanobacteria | 2019-07-23T10:10:55.759535+0300 | 2019-07-24T10:10:55.759535+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3865 | 39784 | swimming_water_cyanobacteria | 2019-07-23T10:12:55.672677+0300 | 2019-07-24T10:12:55.672677+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3866 | 39568 | swimming_water_cyanobacteria | 2019-07-23T10:13:07.974389+0300 | 2019-07-24T10:13:07.974389+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3872 | 53461 | swimming_water_cyanobacteria | 2019-07-23T10:15:30.437569+0300 | 2019-07-24T10:15:30.437569+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3874 | 40142 | swimming_water_cyanobacteria | 2019-07-23T10:15:46.013259+0300 | 2019-07-24T10:15:46.013259+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3880 | 39784 | swimming_water_cyanobacteria | 2019-07-23T10:19:05.602621+0300 | 2019-07-24T10:19:05.602621+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3883 | 39846 | swimming_water_cyanobacteria | 2019-07-23T10:20:11.242086+0300 | 2019-07-24T10:20:11.242086+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
3907 | 52959 | swimming_water_cyanobacteria | 2019-07-23T10:54:34.560294+0300 | 2019-07-24T10:54:34.560294+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3909 | 39846 | swimming_water_cyanobacteria | 2019-07-23T11:03:30.070182+0300 | 2019-07-24T11:03:30.070182+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3910 | 39693 | swimming_water_cyanobacteria | 2019-07-23T11:11:45.473255+0300 | 2019-07-24T11:11:45.473255+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3923 | 39568 | swimming_water_cyanobacteria | 2019-07-23T14:24:35.279389+0300 | 2019-07-24T14:24:35.279389+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 | |||
3943 | 39583 | swimming_water_cyanobacteria | 2019-07-23T18:25:47.362054+0300 | 2019-07-24T18:25:47.362054+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 | |||
3971 | 40142 | swimming_water_cyanobacteria | 2019-07-24T10:05:28.100468+0300 | 2019-07-25T10:05:28.100468+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3976 | 39583 | swimming_water_cyanobacteria | 2019-07-24T10:06:20.670761+0300 | 2019-07-25T10:06:20.670761+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4040 | 53461 | swimming_water_cyanobacteria | 2019-07-24T13:39:16.995329+0300 | 2019-07-25T13:39:16.995329+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4062 | 39583 | swimming_water_cyanobacteria | 2019-07-24T14:13:41.588137+0300 | 2019-07-25T14:13:41.588137+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
4074 | 39583 | swimming_water_cyanobacteria | 2019-07-24T17:53:21.455796+0300 | 2019-07-25T17:53:21.455796+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4082 | 53461 | swimming_water_cyanobacteria | 2019-07-25T08:10:30.353947+0300 | 2019-07-26T08:10:30.353947+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4097 | 41960 | swimming_water_cyanobacteria | 2019-07-25T10:02:08.741469+0300 | 2019-07-26T10:02:08.741469+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4098 | 41960 | swimming_water_cyanobacteria | 2019-07-25T10:02:09.822372+0300 | 2019-07-26T10:02:09.822372+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
4115 | 39583 | swimming_water_cyanobacteria | 2019-07-25T10:17:25.395219+0300 | 2019-07-26T10:17:25.395219+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4129 | 53476 | swimming_water_cyanobacteria | 2019-07-25T10:27:30.793844+0300 | 2019-07-26T10:27:30.793844+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4130 | 52958 | swimming_water_cyanobacteria | 2019-07-25T10:27:46.063962+0300 | 2019-07-26T10:27:46.063962+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4139 | 52960 | swimming_water_cyanobacteria | 2019-07-25T10:39:44.607308+0300 | 2019-07-26T10:39:44.607308+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4140 | 52960 | swimming_water_cyanobacteria | 2019-07-25T10:39:59.605662+0300 | 2019-07-26T10:39:59.605662+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4141 | 50549 | swimming_water_cyanobacteria | 2019-07-25T10:40:19.679161+0300 | 2019-07-26T10:40:19.679161+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4142 | 50549 | swimming_water_cyanobacteria | 2019-07-25T10:40:31.256465+0300 | 2019-07-26T10:40:31.256465+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4169 | 39846 | swimming_water_cyanobacteria | 2019-07-25T13:50:03.465083+0300 | 2019-07-26T13:50:03.465083+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
4188 | 40356 | swimming_water_cyanobacteria | 2019-07-25T15:06:08.956360+0300 | 2019-07-26T15:06:08.956360+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 );