observation
2,809 rows where name_fi = "Ei sinilevää" and primary = 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49 | 40258 | swimming_water_cyanobacteria | 2019-06-03T14:59:27.292015+0300 | 2019-06-04T14:59:27.292015+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 51 | 40559 | swimming_water_cyanobacteria | 2019-06-03T14:59:27.708116+0300 | 2019-06-04T14:59:27.708116+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 56 | 41791 | swimming_water_cyanobacteria | 2019-06-04T17:03:03.123733+0300 | 2019-06-05T17:03:03.123733+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 59 | 40142 | swimming_water_cyanobacteria | 2019-06-04T17:39:49.666969+0300 | 2019-06-05T17:39:49.666969+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 62 | 41791 | swimming_water_cyanobacteria | 2019-06-04T17:51:03.796603+0300 | 2019-06-05T17:51:03.796603+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 64 | 40386 | swimming_water_cyanobacteria | 2019-06-04T17:51:04.110115+0300 | 2019-06-05T17:51:04.110115+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 67 | 40150 | swimming_water_cyanobacteria | 2019-06-04T17:51:04.585805+0300 | 2019-06-05T17:51:04.585805+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 69 | 40157 | swimming_water_cyanobacteria | 2019-06-04T17:51:04.920372+0300 | 2019-06-05T17:51:04.920372+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 72 | 40098 | swimming_water_cyanobacteria | 2019-06-04T17:51:05.444684+0300 | 2019-06-05T17:51:05.444684+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 74 | 40950 | swimming_water_cyanobacteria | 2019-06-04T17:51:05.757482+0300 | 2019-06-05T17:51:05.757482+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 77 | 41960 | swimming_water_cyanobacteria | 2019-06-04T17:51:06.219639+0300 | 2019-06-05T17:51:06.219639+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 80 | 41601 | swimming_water_cyanobacteria | 2019-06-04T17:51:06.664807+0300 | 2019-06-05T17:51:06.664807+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 84 | 40559 | swimming_water_cyanobacteria | 2019-06-04T17:51:07.286358+0300 | 2019-06-05T17:51:07.286358+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 86 | 40802 | swimming_water_cyanobacteria | 2019-06-04T17:51:07.586619+0300 | 2019-06-05T17:51:07.586619+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 89 | 41791 | swimming_water_cyanobacteria | 2019-06-05T10:02:52.808718+0300 | 2019-06-06T10:02:52.808718+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 90 | 41791 | swimming_water_cyanobacteria | 2019-06-05T10:03:02.641703+0300 | 2019-06-06T10:03:02.641703+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 98 | 41791 | swimming_water_cyanobacteria | 2019-06-05T10:07:02.833010+0300 | 2019-06-06T10:07:02.833010+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 104 | 41960 | swimming_water_cyanobacteria | 2019-06-05T10:38:14.837379+0300 | 2019-06-06T10:38:14.837379+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 106 | 40098 | swimming_water_cyanobacteria | 2019-06-05T10:51:43.131677+0300 | 2019-06-06T10:51:43.131677+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 108 | 40150 | swimming_water_cyanobacteria | 2019-06-05T10:51:43.541822+0300 | 2019-06-06T10:51:43.541822+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 116 | 40157 | swimming_water_cyanobacteria | 2019-06-05T11:00:56.804773+0300 | 2019-06-06T11:00:56.804773+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 119 | 41791 | swimming_water_cyanobacteria | 2019-06-05T11:12:17.870205+0300 | 2019-06-06T11:12:17.870205+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 123 | 40559 | swimming_water_cyanobacteria | 2019-06-05T15:36:17.702169+0300 | 2019-06-06T15:36:17.702169+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 126 | 40142 | swimming_water_cyanobacteria | 2019-06-05T18:40:26.384202+0300 | 2019-06-06T18:40:26.384202+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 129 | 41960 | swimming_water_cyanobacteria | 2019-06-06T10:01:31.169277+0300 | 2019-06-07T10:01:31.169277+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 131 | 39693 | swimming_water_cyanobacteria | 2019-06-06T10:04:02.159654+0300 | 2019-06-07T10:04:02.159654+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 134 | 40142 | swimming_water_cyanobacteria | 2019-06-06T10:18:13.961504+0300 | 2019-06-07T10:18:13.961504+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 136 | 40157 | swimming_water_cyanobacteria | 2019-06-06T10:23:20.148570+0300 | 2019-06-07T10:23:20.148570+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 138 | 40559 | swimming_water_cyanobacteria | 2019-06-06T10:27:24.292296+0300 | 2019-06-07T10:27:24.292296+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 141 | 40386 | swimming_water_cyanobacteria | 2019-06-06T10:43:25.188800+0300 | 2019-06-07T10:43:25.188800+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 143 | 39568 | swimming_water_cyanobacteria | 2019-06-06T10:43:25.473784+0300 | 2019-06-07T10:43:25.473784+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 151 | 41601 | swimming_water_cyanobacteria | 2019-06-06T11:02:35.952682+0300 | 2019-06-07T11:02:35.952682+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 154 | 40258 | swimming_water_cyanobacteria | 2019-06-06T11:12:15.839226+0300 | 2019-06-07T11:12:15.839226+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 159 | 40386 | swimming_water_cyanobacteria | 2019-06-06T11:16:25.743543+0300 | 2019-06-07T11:16:25.743543+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 161 | 40098 | swimming_water_cyanobacteria | 2019-06-06T11:16:26.025466+0300 | 2019-06-07T11:16:26.025466+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 163 | 39815 | swimming_water_cyanobacteria | 2019-06-06T11:16:26.291071+0300 | 2019-06-07T11:16:26.291071+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 166 | 39267 | swimming_water_cyanobacteria | 2019-06-06T11:41:52.590712+0300 | 2019-06-07T11:41:52.590712+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 168 | 40993 | swimming_water_cyanobacteria | 2019-06-06T12:51:31.368644+0300 | 2019-06-07T12:51:31.368644+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 174 | 39693 | swimming_water_cyanobacteria | 2019-06-06T13:43:56.339090+0300 | 2019-06-07T13:43:56.339090+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 181 | 39267 | swimming_water_cyanobacteria | 2019-06-06T14:10:39.762394+0300 | 2019-06-07T14:10:39.762394+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 185 | 39815 | swimming_water_cyanobacteria | 2019-06-06T15:18:32.085266+0300 | 2019-06-07T15:18:32.085266+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 188 | 39693 | swimming_water_cyanobacteria | 2019-06-06T17:51:56.490257+0300 | 2019-06-07T17:51:56.490257+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 190 | 39815 | swimming_water_cyanobacteria | 2019-06-06T19:43:29.756550+0300 | 2019-06-07T19:43:29.756550+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 193 | 39815 | swimming_water_cyanobacteria | 2019-06-07T08:30:31.141466+0300 | 2019-06-08T08:30:31.141466+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 196 | 39693 | swimming_water_cyanobacteria | 2019-06-07T09:40:44.456354+0300 | 2019-06-08T09:40:44.456354+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 198 | 39527 | swimming_water_cyanobacteria | 2019-06-07T09:44:25.383206+0300 | 2019-06-08T09:44:25.383206+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 202 | 39815 | swimming_water_cyanobacteria | 2019-06-07T09:58:46.944319+0300 | 2019-06-08T09:58:46.944319+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 205 | 40802 | swimming_water_cyanobacteria | 2019-06-07T10:02:46.586267+0300 | 2019-06-08T10:02:46.586267+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 208 | 41601 | swimming_water_cyanobacteria | 2019-06-07T10:14:43.966094+0300 | 2019-06-08T10:14:43.966094+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 215 | 40150 | swimming_water_cyanobacteria | 2019-06-07T10:35:31.010497+0300 | 2019-06-08T10:35:31.010497+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 217 | 40157 | swimming_water_cyanobacteria | 2019-06-07T10:35:47.192802+0300 | 2019-06-08T10:35:47.192802+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 219 | 40142 | swimming_water_cyanobacteria | 2019-06-07T11:22:19.144470+0300 | 2019-06-08T11:22:19.144470+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 223 | 39322 | swimming_water_cyanobacteria | 2019-06-07T11:23:46.934289+0300 | 2019-06-08T11:23:46.934289+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 225 | 39322 | swimming_water_cyanobacteria | 2019-06-07T11:35:37.275884+0300 | 2019-06-08T11:35:37.275884+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 227 | 39322 | swimming_water_cyanobacteria | 2019-06-07T11:35:37.729851+0300 | 2019-06-08T11:35:37.729851+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 229 | 39322 | swimming_water_cyanobacteria | 2019-06-07T11:35:38.182549+0300 | 2019-06-08T11:35:38.182549+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 231 | 40559 | swimming_water_cyanobacteria | 2019-06-07T12:33:46.546318+0300 | 2019-06-08T12:33:46.546318+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 236 | 41791 | swimming_water_cyanobacteria | 2019-06-07T13:45:35.883926+0300 | 2019-06-08T13:45:35.883926+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 237 | 39693 | swimming_water_cyanobacteria | 2019-06-07T13:53:20.573133+0300 | 2019-06-08T13:53:20.573133+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 241 | 39815 | swimming_water_cyanobacteria | 2019-06-07T14:12:36.283058+0300 | 2019-06-08T14:12:36.283058+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 246 | 39322 | swimming_water_cyanobacteria | 2019-06-07T15:17:51.371667+0300 | 2019-06-08T15:17:51.371667+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 248 | 39568 | swimming_water_cyanobacteria | 2019-06-07T16:12:57.200876+0300 | 2019-06-08T16:12:57.200876+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 252 | 39583 | swimming_water_cyanobacteria | 2019-06-07T16:16:06.378059+0300 | 2019-06-08T16:16:06.378059+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 256 | 39815 | swimming_water_cyanobacteria | 2019-06-07T18:22:42.163638+0300 | 2019-06-08T18:22:42.163638+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 259 | 39322 | swimming_water_cyanobacteria | 2019-06-07T19:42:43.393878+0300 | 2019-06-08T19:42:43.393878+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 264 | 39693 | swimming_water_cyanobacteria | 2019-06-08T08:17:34.950319+0300 | 2019-06-09T08:17:34.950319+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 267 | 41791 | swimming_water_cyanobacteria | 2019-06-08T10:05:12.370805+0300 | 2019-06-09T10:05:12.370805+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 270 | 40559 | swimming_water_cyanobacteria | 2019-06-08T10:06:35.326766+0300 | 2019-06-09T10:06:35.326766+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 272 | 40157 | swimming_water_cyanobacteria | 2019-06-08T10:08:29.379228+0300 | 2019-06-09T10:08:29.379228+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 274 | 39815 | swimming_water_cyanobacteria | 2019-06-08T10:19:19.630268+0300 | 2019-06-09T10:19:19.630268+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 276 | 41601 | swimming_water_cyanobacteria | 2019-06-08T10:39:35.893100+0300 | 2019-06-09T10:39:35.893100+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 278 | 40950 | swimming_water_cyanobacteria | 2019-06-08T10:42:27.900203+0300 | 2019-06-09T10:42:27.900203+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 283 | 40142 | swimming_water_cyanobacteria | 2019-06-08T10:56:32.085681+0300 | 2019-06-09T10:56:32.085681+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 286 | 39568 | swimming_water_cyanobacteria | 2019-06-08T11:04:09.535241+0300 | 2019-06-09T11:04:09.535241+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 290 | 39693 | swimming_water_cyanobacteria | 2019-06-08T14:07:54.007108+0300 | 2019-06-09T14:07:54.007108+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 294 | 39815 | swimming_water_cyanobacteria | 2019-06-08T14:37:26.875102+0300 | 2019-06-09T14:37:26.875102+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 297 | 39267 | swimming_water_cyanobacteria | 2019-06-08T17:01:12.529283+0300 | 2019-06-09T17:01:12.529283+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 299 | 39815 | swimming_water_cyanobacteria | 2019-06-08T17:52:12.127172+0300 | 2019-06-09T17:52:12.127172+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 302 | 39267 | swimming_water_cyanobacteria | 2019-06-08T17:58:58.552883+0300 | 2019-06-09T17:58:58.552883+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 304 | 39693 | swimming_water_cyanobacteria | 2019-06-08T17:59:31.611858+0300 | 2019-06-09T17:59:31.611858+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 307 | 39322 | swimming_water_cyanobacteria | 2019-06-08T23:41:39.898126+0300 | 2019-06-09T23:41:39.898126+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 308 | 52959 | swimming_water_cyanobacteria | 2019-06-08T23:42:58.130605+0300 | 2019-06-09T23:42:58.130605+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 309 | 39527 | swimming_water_cyanobacteria | 2019-06-08T23:43:20.801648+0300 | 2019-06-09T23:43:20.801648+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 311 | 40921 | swimming_water_cyanobacteria | 2019-06-09T08:58:46.214216+0300 | 2019-06-10T08:58:46.214216+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 313 | 41326 | swimming_water_cyanobacteria | 2019-06-09T08:59:03.247621+0300 | 2019-06-10T08:59:03.247621+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 315 | 40020 | swimming_water_cyanobacteria | 2019-06-09T08:59:14.907268+0300 | 2019-06-10T08:59:14.907268+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 317 | 40677 | swimming_water_cyanobacteria | 2019-06-09T08:59:51.845599+0300 | 2019-06-10T08:59:51.845599+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 319 | 41907 | swimming_water_cyanobacteria | 2019-06-09T09:01:01.776393+0300 | 2019-06-10T09:01:01.776393+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 321 | 39910 | swimming_water_cyanobacteria | 2019-06-09T09:01:11.390362+0300 | 2019-06-10T09:01:11.390362+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 323 | 40798 | swimming_water_cyanobacteria | 2019-06-09T09:01:22.807277+0300 | 2019-06-10T09:01:22.807277+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 325 | 41791 | swimming_water_cyanobacteria | 2019-06-09T09:56:13.442634+0300 | 2019-06-10T09:56:13.442634+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 327 | 41601 | swimming_water_cyanobacteria | 2019-06-09T10:04:57.642821+0300 | 2019-06-10T10:04:57.642821+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 329 | 39693 | swimming_water_cyanobacteria | 2019-06-09T10:08:00.843698+0300 | 2019-06-10T10:08:00.843698+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 332 | 39815 | swimming_water_cyanobacteria | 2019-06-09T10:13:47.623117+0300 | 2019-06-10T10:13:47.623117+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 337 | 40559 | swimming_water_cyanobacteria | 2019-06-09T10:15:18.357109+0300 | 2019-06-10T10:15:18.357109+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 338 | 39322 | swimming_water_cyanobacteria | 2019-06-09T10:15:22.169332+0300 | 2019-06-10T10:15:22.169332+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 340 | 39267 | swimming_water_cyanobacteria | 2019-06-09T10:21:47.250145+0300 | 2019-06-10T10:21:47.250145+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 342 | 40950 | swimming_water_cyanobacteria | 2019-06-09T10:22:30.603308+0300 | 2019-06-10T10:22:30.603308+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 344 | 40157 | swimming_water_cyanobacteria | 2019-06-09T10:23:09.627366+0300 | 2019-06-10T10:23:09.627366+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 346 | 40142 | swimming_water_cyanobacteria | 2019-06-09T10:31:52.689274+0300 | 2019-06-10T10:31:52.689274+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 );