observation
7,945 rows where primary = 1
This data as json, CSV (advanced)
name_sv ✖
- Inga blågröna alger 2,712
- Lite blågröna alger 1,880
- Isad 1,452
- Plogad 526
- Stängd 419
- Rikligt med blågröna alger 281
- Bra 147
- Isningen har inletts 117
- Mycket rikligt med blågröna alger 94
- Hyfsad 92
- Snöbrist 54
- Svag 20
- Snöproduktionen oavslutad 16
- Stängd av andra skäl 16
- Säsongen igång 8
- Säsongen är över 5
- Tävlingar/träningar 4
- Grunden lagd (inget skidspår) 2
| id ▼ | unit | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 349 | 40258 | swimming_water_cyanobacteria | 2019-06-09T10:45:17.109611+0300 | 2019-06-10T10:45:17.109611+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 353 | 40150 | swimming_water_cyanobacteria | 2019-06-09T12:28:44.046330+0300 | 2019-06-10T12:28:44.046330+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 355 | 40098 | swimming_water_cyanobacteria | 2019-06-09T12:28:44.546780+0300 | 2019-06-10T12:28:44.546780+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 357 | 39815 | swimming_water_cyanobacteria | 2019-06-09T13:56:42.913548+0300 | 2019-06-10T13:56:42.913548+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 367 | 39322 | swimming_water_cyanobacteria | 2019-06-09T14:07:48.854694+0300 | 2019-06-10T14:07:48.854694+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 370 | 39693 | swimming_water_cyanobacteria | 2019-06-09T14:14:29.120574+0300 | 2019-06-10T14:14:29.120574+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 373 | 39693 | swimming_water_cyanobacteria | 2019-06-09T17:53:48.981656+0300 | 2019-06-10T17:53:48.981656+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 375 | 39267 | swimming_water_cyanobacteria | 2019-06-09T17:54:15.065650+0300 | 2019-06-10T17:54:15.065650+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 383 | 39693 | swimming_water_cyanobacteria | 2019-06-10T08:15:56.422459+0300 | 2019-06-11T08:15:56.422459+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 386 | 39815 | swimming_water_cyanobacteria | 2019-06-10T10:00:37.594878+0300 | 2019-06-11T10:00:37.594878+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 390 | 41791 | swimming_water_cyanobacteria | 2019-06-10T10:01:21.412341+0300 | 2019-06-11T10:01:21.412341+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 392 | 39322 | swimming_water_cyanobacteria | 2019-06-10T10:01:32.789022+0300 | 2019-06-11T10:01:32.789022+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 394 | 40098 | swimming_water_cyanobacteria | 2019-06-10T10:08:31.654594+0300 | 2019-06-11T10:08:31.654594+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 396 | 41601 | swimming_water_cyanobacteria | 2019-06-10T10:13:31.326147+0300 | 2019-06-11T10:13:31.326147+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 398 | 40559 | swimming_water_cyanobacteria | 2019-06-10T10:18:11.463679+0300 | 2019-06-11T10:18:11.463679+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 401 | 40950 | swimming_water_cyanobacteria | 2019-06-10T10:29:44.114543+0300 | 2019-06-11T10:29:44.114543+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 404 | 40150 | swimming_water_cyanobacteria | 2019-06-10T10:37:20.987688+0300 | 2019-06-11T10:37:20.987688+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 406 | 41960 | swimming_water_cyanobacteria | 2019-06-10T10:58:00.377675+0300 | 2019-06-11T10:58:00.377675+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 407 | 39322 | swimming_water_cyanobacteria | 2019-06-10T13:40:35.075811+0300 | 2019-06-11T13:40:35.075811+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 411 | 39815 | swimming_water_cyanobacteria | 2019-06-10T13:46:23.888435+0300 | 2019-06-11T13:46:23.888435+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 417 | 39693 | swimming_water_cyanobacteria | 2019-06-10T14:11:32.609062+0300 | 2019-06-11T14:11:32.609062+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 419 | 40142 | swimming_water_cyanobacteria | 2019-06-10T14:52:41.206758+0300 | 2019-06-11T14:52:41.206758+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 422 | 40157 | swimming_water_cyanobacteria | 2019-06-10T14:54:29.068159+0300 | 2019-06-11T14:54:29.068159+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 425 | 39322 | swimming_water_cyanobacteria | 2019-06-10T17:51:08.455237+0300 | 2019-06-11T17:51:08.455237+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 427 | 39693 | swimming_water_cyanobacteria | 2019-06-10T18:30:43.704157+0300 | 2019-06-11T18:30:43.704157+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 430 | 41031 | swimming_water_cyanobacteria | 2019-06-11T07:35:42.220978+0300 | 2019-06-12T07:35:42.220978+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 432 | 41326 | swimming_water_cyanobacteria | 2019-06-11T07:35:56.656586+0300 | 2019-06-12T07:35:56.656586+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 434 | 41907 | swimming_water_cyanobacteria | 2019-06-11T07:36:05.845510+0300 | 2019-06-12T07:36:05.845510+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 436 | 40921 | swimming_water_cyanobacteria | 2019-06-11T07:36:23.152748+0300 | 2019-06-12T07:36:23.152748+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 439 | 40798 | swimming_water_cyanobacteria | 2019-06-11T07:36:41.929412+0300 | 2019-06-12T07:36:41.929412+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 441 | 40677 | swimming_water_cyanobacteria | 2019-06-11T07:36:54.529471+0300 | 2019-06-12T07:36:54.529471+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 443 | 40020 | swimming_water_cyanobacteria | 2019-06-11T07:37:01.114405+0300 | 2019-06-12T07:37:01.114405+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 445 | 39910 | swimming_water_cyanobacteria | 2019-06-11T07:37:08.591196+0300 | 2019-06-12T07:37:08.591196+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 447 | 40993 | swimming_water_cyanobacteria | 2019-06-11T07:37:46.831194+0300 | 2019-06-12T07:37:46.831194+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 449 | 40356 | swimming_water_cyanobacteria | 2019-06-11T07:38:17.423789+0300 | 2019-06-12T07:38:17.423789+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 452 | 40386 | swimming_water_cyanobacteria | 2019-06-11T07:38:51.782632+0300 | 2019-06-12T07:38:51.782632+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 455 | 39693 | swimming_water_cyanobacteria | 2019-06-11T09:16:16.519724+0300 | 2019-06-12T09:16:16.519724+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 461 | 39322 | swimming_water_cyanobacteria | 2019-06-11T09:50:57.103281+0300 | 2019-06-12T09:50:57.103281+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 463 | 39815 | swimming_water_cyanobacteria | 2019-06-11T09:53:01.371030+0300 | 2019-06-12T09:53:01.371030+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 466 | 40950 | swimming_water_cyanobacteria | 2019-06-11T10:03:18.853097+0300 | 2019-06-12T10:03:18.853097+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 468 | 41791 | swimming_water_cyanobacteria | 2019-06-11T10:05:14.243595+0300 | 2019-06-12T10:05:14.243595+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 470 | 40802 | swimming_water_cyanobacteria | 2019-06-11T10:05:23.903992+0300 | 2019-06-12T10:05:23.903992+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 472 | 40142 | swimming_water_cyanobacteria | 2019-06-11T10:06:26.307959+0300 | 2019-06-12T10:06:26.307959+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 476 | 39267 | swimming_water_cyanobacteria | 2019-06-11T10:10:11.349976+0300 | 2019-06-12T10:10:11.349976+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 479 | 40157 | swimming_water_cyanobacteria | 2019-06-11T10:10:58.231946+0300 | 2019-06-12T10:10:58.231946+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 481 | 40559 | swimming_water_cyanobacteria | 2019-06-11T10:14:53.978415+0300 | 2019-06-12T10:14:53.978415+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 484 | 39693 | swimming_water_cyanobacteria | 2019-06-11T10:21:13.353548+0300 | 2019-06-12T10:21:13.353548+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 487 | 41960 | swimming_water_cyanobacteria | 2019-06-11T10:26:22.358050+0300 | 2019-06-12T10:26:22.358050+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 490 | 41601 | swimming_water_cyanobacteria | 2019-06-11T10:53:15.152961+0300 | 2019-06-12T10:53:15.152961+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 500 | 41791 | swimming_water_cyanobacteria | 2019-06-11T11:59:42.856179+0300 | 2019-06-12T11:59:42.856179+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 550 | 41791 | swimming_water_cyanobacteria | 2019-06-11T12:44:10.021123+0300 | 2019-06-12T12:44:10.021123+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 555 | 39322 | swimming_water_cyanobacteria | 2019-06-11T13:45:46.922981+0300 | 2019-06-12T13:45:46.922981+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 557 | 39815 | swimming_water_cyanobacteria | 2019-06-11T13:54:55.773598+0300 | 2019-06-12T13:54:55.773598+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 559 | 39267 | swimming_water_cyanobacteria | 2019-06-11T14:00:01.071450+0300 | 2019-06-12T14:00:01.071450+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 562 | 40258 | swimming_water_cyanobacteria | 2019-06-11T16:54:12.388740+0300 | 2019-06-12T16:54:12.388740+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 566 | 39322 | swimming_water_cyanobacteria | 2019-06-11T17:52:48.301558+0300 | 2019-06-12T17:52:48.301558+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 568 | 39267 | swimming_water_cyanobacteria | 2019-06-11T17:57:02.168113+0300 | 2019-06-12T17:57:02.168113+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 570 | 39815 | swimming_water_cyanobacteria | 2019-06-11T18:08:21.431872+0300 | 2019-06-12T18:08:21.431872+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 573 | 39322 | swimming_water_cyanobacteria | 2019-06-12T10:04:15.093719+0300 | 2019-06-13T10:04:15.093719+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 575 | 40802 | swimming_water_cyanobacteria | 2019-06-12T10:06:32.496663+0300 | 2019-06-13T10:06:32.496663+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 577 | 41960 | swimming_water_cyanobacteria | 2019-06-12T10:08:24.015560+0300 | 2019-06-13T10:08:24.015560+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 579 | 39693 | swimming_water_cyanobacteria | 2019-06-12T10:11:37.359100+0300 | 2019-06-13T10:11:37.359100+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 582 | 40157 | swimming_water_cyanobacteria | 2019-06-12T10:12:32.121792+0300 | 2019-06-13T10:12:32.121792+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 584 | 40559 | swimming_water_cyanobacteria | 2019-06-12T10:20:30.910174+0300 | 2019-06-13T10:20:30.910174+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 589 | 40950 | swimming_water_cyanobacteria | 2019-06-12T10:42:01.871360+0300 | 2019-06-13T10:42:01.871360+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 591 | 39267 | swimming_water_cyanobacteria | 2019-06-12T10:45:42.523400+0300 | 2019-06-13T10:45:42.523400+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 593 | 40142 | swimming_water_cyanobacteria | 2019-06-12T10:48:04.357717+0300 | 2019-06-13T10:48:04.357717+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 596 | 40098 | swimming_water_cyanobacteria | 2019-06-12T10:52:27.404247+0300 | 2019-06-13T10:52:27.404247+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 599 | 39815 | swimming_water_cyanobacteria | 2019-06-12T11:38:13.717303+0300 | 2019-06-13T11:38:13.717303+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 604 | 41601 | swimming_water_cyanobacteria | 2019-06-12T12:38:43.950684+0300 | 2019-06-13T12:38:43.950684+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 606 | 39322 | swimming_water_cyanobacteria | 2019-06-12T14:01:03.590432+0300 | 2019-06-13T14:01:03.590432+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 608 | 39267 | swimming_water_cyanobacteria | 2019-06-12T14:02:40.781786+0300 | 2019-06-13T14:02:40.781786+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 610 | 39693 | swimming_water_cyanobacteria | 2019-06-12T14:12:19.625168+0300 | 2019-06-13T14:12:19.625168+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 613 | 39815 | swimming_water_cyanobacteria | 2019-06-12T14:28:56.682025+0300 | 2019-06-13T14:28:56.682025+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 618 | 39693 | swimming_water_cyanobacteria | 2019-06-12T17:47:24.638151+0300 | 2019-06-13T17:47:24.638151+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 621 | 39322 | swimming_water_cyanobacteria | 2019-06-12T17:49:11.759700+0300 | 2019-06-13T17:49:11.759700+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 623 | 39815 | swimming_water_cyanobacteria | 2019-06-12T18:06:28.230122+0300 | 2019-06-13T18:06:28.230122+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 628 | 39527 | swimming_water_cyanobacteria | 2019-06-12T19:05:56.364310+0300 | 2019-06-13T19:05:56.364310+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 631 | 39713 | swimming_water_cyanobacteria | 2019-06-13T07:47:31.268741+0300 | 2019-06-14T07:47:31.268741+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 635 | 39875 | swimming_water_cyanobacteria | 2019-06-13T08:05:36.869605+0300 | 2019-06-14T08:05:36.869605+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 637 | 39902 | swimming_water_cyanobacteria | 2019-06-13T08:21:56.972791+0300 | 2019-06-14T08:21:56.972791+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 639 | 39606 | swimming_water_cyanobacteria | 2019-06-13T08:33:05.309793+0300 | 2019-06-14T08:33:05.309793+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 641 | 53461 | swimming_water_cyanobacteria | 2019-06-13T09:33:43.191169+0300 | 2019-06-14T09:33:43.191169+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 643 | 39823 | swimming_water_cyanobacteria | 2019-06-13T09:47:43.757012+0300 | 2019-06-14T09:47:43.757012+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 645 | 40559 | swimming_water_cyanobacteria | 2019-06-13T10:01:59.965195+0300 | 2019-06-14T10:01:59.965195+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 648 | 40157 | swimming_water_cyanobacteria | 2019-06-13T10:03:35.039828+0300 | 2019-06-14T10:03:35.039828+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 652 | 39322 | swimming_water_cyanobacteria | 2019-06-13T10:08:24.438606+0300 | 2019-06-14T10:08:24.438606+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 656 | 41601 | swimming_water_cyanobacteria | 2019-06-13T10:09:21.718986+0300 | 2019-06-14T10:09:21.718986+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 658 | 40802 | swimming_water_cyanobacteria | 2019-06-13T10:12:32.746326+0300 | 2019-06-14T10:12:32.746326+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 661 | 40142 | swimming_water_cyanobacteria | 2019-06-13T10:26:07.891348+0300 | 2019-06-14T10:26:07.891348+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 663 | 41960 | swimming_water_cyanobacteria | 2019-06-13T10:30:05.838495+0300 | 2019-06-14T10:30:05.838495+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 665 | 39815 | swimming_water_cyanobacteria | 2019-06-13T10:50:07.350226+0300 | 2019-06-14T10:50:07.350226+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 670 | 52959 | swimming_water_cyanobacteria | 2019-06-13T10:50:38.943623+0300 | 2019-06-14T10:50:38.943623+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 672 | 40150 | swimming_water_cyanobacteria | 2019-06-13T11:20:04.091525+0300 | 2019-06-14T11:20:04.091525+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 674 | 40950 | swimming_water_cyanobacteria | 2019-06-13T11:38:22.437978+0300 | 2019-06-14T11:38:22.437978+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 676 | 39412 | swimming_water_cyanobacteria | 2019-06-13T12:30:11.239602+0300 | 2019-06-14T12:30:11.239602+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 678 | 39368 | swimming_water_cyanobacteria | 2019-06-13T12:55:23.748073+0300 | 2019-06-14T12:55:23.748073+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 );