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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4194 | 39583 | swimming_water_cyanobacteria | 2019-07-25T17:38:27.123804+0300 | 2019-07-26T17:38:27.123804+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
4216 | 53461 | swimming_water_cyanobacteria | 2019-07-26T08:01:26.428941+0300 | 2019-07-27T08:01:26.428941+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4225 | 52960 | swimming_water_cyanobacteria | 2019-07-26T08:50:56.951419+0300 | 2019-07-27T08:50:56.951419+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4227 | 52958 | swimming_water_cyanobacteria | 2019-07-26T08:51:39.406443+0300 | 2019-07-27T08:51:39.406443+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4229 | 53476 | swimming_water_cyanobacteria | 2019-07-26T08:52:28.437426+0300 | 2019-07-27T08:52:28.437426+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
4257 | 39583 | swimming_water_cyanobacteria | 2019-07-26T10:05:37.564341+0300 | 2019-07-27T10:05:37.564341+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4262 | 41960 | swimming_water_cyanobacteria | 2019-07-26T10:09:34.448982+0300 | 2019-07-27T10:09:34.448982+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
4267 | 41791 | swimming_water_cyanobacteria | 2019-07-26T10:26:44.464104+0300 | 2019-07-27T10:26:44.464104+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4269 | 40559 | swimming_water_cyanobacteria | 2019-07-26T10:27:08.336755+0300 | 2019-07-27T10:27:08.336755+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4299 | 41960 | swimming_water_cyanobacteria | 2019-07-26T10:51:29.897146+0300 | 2019-07-27T10:51:29.897146+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4317 | 39846 | swimming_water_cyanobacteria | 2019-07-26T12:04:11.588030+0300 | 2019-07-27T12:04:11.588030+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4325 | 41326 | swimming_water_cyanobacteria | 2019-07-26T13:15:23.264150+0300 | 2019-07-27T13:15:23.264150+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4327 | 40921 | swimming_water_cyanobacteria | 2019-07-26T13:15:37.964716+0300 | 2019-07-27T13:15:37.964716+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4336 | 39583 | swimming_water_cyanobacteria | 2019-07-26T14:08:08.045470+0300 | 2019-07-27T14:08:08.045470+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
4351 | 39583 | swimming_water_cyanobacteria | 2019-07-26T17:47:06.879973+0300 | 2019-07-27T17:47:06.879973+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4365 | 53461 | swimming_water_cyanobacteria | 2019-07-27T07:22:27.949598+0300 | 2019-07-28T07:22:27.949598+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4385 | 40386 | swimming_water_cyanobacteria | 2019-07-27T09:56:30.418877+0300 | 2019-07-28T09:56:30.418877+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4386 | 40386 | swimming_water_cyanobacteria | 2019-07-27T09:56:31.767109+0300 | 2019-07-28T09:56:31.767109+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4417 | 41791 | swimming_water_cyanobacteria | 2019-07-27T10:16:41.909247+0300 | 2019-07-28T10:16:41.909247+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4418 | 41791 | swimming_water_cyanobacteria | 2019-07-27T10:17:09.704534+0300 | 2019-07-28T10:17:09.704534+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4419 | 41601 | swimming_water_cyanobacteria | 2019-07-27T10:19:54.237331+0300 | 2019-07-28T10:19:54.237331+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4420 | 41601 | swimming_water_cyanobacteria | 2019-07-27T10:19:54.248622+0300 | 2019-07-28T10:19:54.248622+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4421 | 41601 | swimming_water_cyanobacteria | 2019-07-27T10:19:54.334073+0300 | 2019-07-28T10:19:54.334073+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4425 | 41601 | swimming_water_cyanobacteria | 2019-07-27T10:20:20.097666+0300 | 2019-07-28T10:20:20.097666+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4426 | 41791 | swimming_water_cyanobacteria | 2019-07-27T10:20:20.755763+0300 | 2019-07-28T10:20:20.755763+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4427 | 41601 | swimming_water_cyanobacteria | 2019-07-27T10:21:52.834077+0300 | 2019-07-28T10:21:52.834077+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4433 | 41601 | swimming_water_cyanobacteria | 2019-07-27T10:23:55.060897+0300 | 2019-07-28T10:23:55.060897+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4442 | 40802 | swimming_water_cyanobacteria | 2019-07-27T11:17:30.716946+0300 | 2019-07-28T11:17:30.716946+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4443 | 40802 | swimming_water_cyanobacteria | 2019-07-27T11:17:52.053161+0300 | 2019-07-28T11:17:52.053161+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4444 | 40802 | swimming_water_cyanobacteria | 2019-07-27T11:18:06.458000+0300 | 2019-07-28T11:18:06.458000+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
4493 | 39568 | swimming_water_cyanobacteria | 2019-07-28T08:44:55.677123+0300 | 2019-07-29T08:44:55.677123+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4503 | 40142 | swimming_water_cyanobacteria | 2019-07-28T10:07:57.917329+0300 | 2019-07-29T10:07:57.917329+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4507 | 40142 | swimming_water_cyanobacteria | 2019-07-28T10:15:52.545486+0300 | 2019-07-29T10:15:52.545486+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
4539 | 39583 | swimming_water_cyanobacteria | 2019-07-28T17:20:37.282823+0300 | 2019-07-29T17:20:37.282823+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4543 | 39583 | swimming_water_cyanobacteria | 2019-07-28T17:20:54.972671+0300 | 2019-07-29T17:20:54.972671+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
4572 | 39568 | swimming_water_cyanobacteria | 2019-07-28T19:52:15.726425+0300 | 2019-07-29T19:52:15.726425+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4574 | 52959 | swimming_water_cyanobacteria | 2019-07-28T19:52:55.733956+0300 | 2019-07-29T19:52:55.733956+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4580 | 53461 | swimming_water_cyanobacteria | 2019-07-29T07:55:32.235291+0300 | 2019-07-30T07:55:32.235291+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
4648 | 40258 | swimming_water_cyanobacteria | 2019-07-29T12:42:15.118188+0300 | 2019-07-30T12:42:15.118188+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4659 | 39583 | swimming_water_cyanobacteria | 2019-07-29T13:35:02.968634+0300 | 2019-07-30T13:35:02.968634+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
4745 | 39583 | swimming_water_cyanobacteria | 2019-07-30T17:39:33.226807+0300 | 2019-07-31T17:39:33.226807+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
4768 | 53461 | swimming_water_cyanobacteria | 2019-07-31T08:49:58.944314+0300 | 2019-08-01T08:49:58.944314+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | 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 | |||
4846 | 39267 | swimming_water_cyanobacteria | 2019-07-31T14:19:25.689029+0300 | 2019-08-01T14:19:25.689029+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
4857 | 39267 | swimming_water_cyanobacteria | 2019-07-31T17:56:15.225833+0300 | 2019-08-01T17:56:15.225833+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
4868 | 53461 | swimming_water_cyanobacteria | 2019-08-01T09:35:35.368553+0300 | 2019-08-02T09:35:35.368553+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4890 | 39267 | swimming_water_cyanobacteria | 2019-08-01T10:22:24.167017+0300 | 2019-08-02T10:22:24.167017+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
4965 | 53461 | swimming_water_cyanobacteria | 2019-08-02T07:33:21.816524+0300 | 2019-08-03T07:33:21.816524+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4994 | 39267 | swimming_water_cyanobacteria | 2019-08-02T10:12:09.118282+0300 | 2019-08-03T10:12:09.118282+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
5017 | 41601 | swimming_water_cyanobacteria | 2019-08-02T11:04:12.417535+0300 | 2019-08-03T11:04:12.417535+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5027 | 39267 | swimming_water_cyanobacteria | 2019-08-02T14:15:02.918142+0300 | 2019-08-03T14:15:02.918142+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
5065 | 39267 | swimming_water_cyanobacteria | 2019-08-02T17:52:26.040204+0300 | 2019-08-03T17:52:26.040204+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
5084 | 39267 | swimming_water_cyanobacteria | 2019-08-03T10:01:31.397425+0300 | 2019-08-04T10:01:31.397425+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
5089 | 40386 | swimming_water_cyanobacteria | 2019-08-03T10:15:20.333899+0300 | 2019-08-04T10:15:20.333899+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5137 | 39267 | swimming_water_cyanobacteria | 2019-08-03T14:26:02.401814+0300 | 2019-08-04T14:26:02.401814+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
5150 | 39267 | swimming_water_cyanobacteria | 2019-08-03T17:55:47.489964+0300 | 2019-08-04T17:55:47.489964+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
5163 | 39267 | swimming_water_cyanobacteria | 2019-08-04T09:54:29.957081+0300 | 2019-08-05T09:54:29.957081+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
5216 | 39267 | swimming_water_cyanobacteria | 2019-08-04T14:20:08.263418+0300 | 2019-08-05T14:20:08.263418+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
5226 | 39267 | swimming_water_cyanobacteria | 2019-08-04T17:48:56.152174+0300 | 2019-08-05T17:48:56.152174+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
5260 | 53461 | swimming_water_cyanobacteria | 2019-08-05T09:37:50.776569+0300 | 2019-08-06T09:37:50.776569+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5280 | 39267 | swimming_water_cyanobacteria | 2019-08-05T10:14:26.484268+0300 | 2019-08-06T10:14:26.484268+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
5353 | 39267 | swimming_water_cyanobacteria | 2019-08-05T15:57:15.513520+0300 | 2019-08-06T15:57:15.513520+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
5355 | 39267 | swimming_water_cyanobacteria | 2019-08-05T17:44:00.415978+0300 | 2019-08-06T17:44:00.415978+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
5374 | 40386 | swimming_water_cyanobacteria | 2019-08-06T10:18:03.975858+0300 | 2019-08-07T10:18:03.975858+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5380 | 52960 | swimming_water_cyanobacteria | 2019-08-06T10:34:25.861764+0300 | 2019-08-07T10:34:25.861764+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5383 | 50549 | swimming_water_cyanobacteria | 2019-08-06T10:34:48.032360+0300 | 2019-08-07T10:34:48.032360+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5385 | 53476 | swimming_water_cyanobacteria | 2019-08-06T10:34:59.694304+0300 | 2019-08-07T10:34:59.694304+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5402 | 53461 | swimming_water_cyanobacteria | 2019-08-06T12:30:21.253625+0300 | 2019-08-07T12:30:21.253625+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5421 | 39267 | swimming_water_cyanobacteria | 2019-08-06T15:39:43.324908+0300 | 2019-08-07T15:39:43.324908+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
5423 | 39267 | swimming_water_cyanobacteria | 2019-08-06T17:46:00.870926+0300 | 2019-08-07T17:46:00.870926+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
5454 | 39267 | swimming_water_cyanobacteria | 2019-08-07T10:13:34.209570+0300 | 2019-08-08T10:13:34.209570+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
5475 | 39267 | swimming_water_cyanobacteria | 2019-08-07T14:19:47.903939+0300 | 2019-08-08T14:19:47.903939+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
5486 | 53461 | swimming_water_cyanobacteria | 2019-08-07T14:38:52.935154+0300 | 2019-08-08T14:38:52.935154+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5506 | 39267 | swimming_water_cyanobacteria | 2019-08-07T17:51:26.601724+0300 | 2019-08-08T17:51:26.601724+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
5512 | 53461 | swimming_water_cyanobacteria | 2019-08-08T09:18:45.023231+0300 | 2019-08-09T09:18:45.023231+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5536 | 40559 | swimming_water_cyanobacteria | 2019-08-08T10:22:04.270255+0300 | 2019-08-09T10:22:04.270255+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5565 | 39267 | swimming_water_cyanobacteria | 2019-08-08T11:41:04.849289+0300 | 2019-08-09T11:41:04.849289+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
5594 | 39267 | swimming_water_cyanobacteria | 2019-08-08T15:05:50.758261+0300 | 2019-08-09T15:05:50.758261+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
5643 | 39267 | swimming_water_cyanobacteria | 2019-08-09T10:25:30.763778+0300 | 2019-08-10T10:25:30.763778+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
5688 | 39527 | swimming_water_cyanobacteria | 2019-08-10T08:48:46.736851+0300 | 2019-08-11T08:48:46.736851+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5692 | 40386 | swimming_water_cyanobacteria | 2019-08-10T10:03:13.918218+0300 | 2019-08-11T10:03:13.918218+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5698 | 39267 | swimming_water_cyanobacteria | 2019-08-10T10:07:54.393813+0300 | 2019-08-11T10:07:54.393813+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
5712 | 40258 | swimming_water_cyanobacteria | 2019-08-10T10:30:07.110518+0300 | 2019-08-11T10:30:07.110518+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5726 | 40802 | swimming_water_cyanobacteria | 2019-08-10T11:10:48.470721+0300 | 2019-08-11T11:10:48.470721+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5728 | 39568 | swimming_water_cyanobacteria | 2019-08-10T11:20:09.329098+0300 | 2019-08-11T11:20:09.329098+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 );