observation
7,945 rows where primary = 1
This data as json, CSV (advanced)
name_sv ✖
- Inga blågröna alger 2,614
- Lite blågröna alger 1,878
- 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 680 | 52959 | swimming_water_cyanobacteria | 2019-06-13T14:04:24.716882+0300 | 2019-06-14T14:04:24.716882+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 682 | 39693 | swimming_water_cyanobacteria | 2019-06-13T14:06:23.422071+0300 | 2019-06-14T14:06:23.422071+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 686 | 39267 | swimming_water_cyanobacteria | 2019-06-13T15:03:58.499130+0300 | 2019-06-14T15:03:58.499130+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 688 | 39568 | swimming_water_cyanobacteria | 2019-06-13T16:33:43.907634+0300 | 2019-06-14T16:33:43.907634+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 691 | 39693 | swimming_water_cyanobacteria | 2019-06-13T18:02:43.040796+0300 | 2019-06-14T18:02:43.040796+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 693 | 39568 | swimming_water_cyanobacteria | 2019-06-13T18:16:59.277736+0300 | 2019-06-14T18:16:59.277736+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 696 | 39322 | swimming_water_cyanobacteria | 2019-06-13T18:42:37.809008+0300 | 2019-06-14T18:42:37.809008+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 698 | 39823 | swimming_water_cyanobacteria | 2019-06-14T07:39:11.855315+0300 | 2019-06-15T07:39:11.855315+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 700 | 53461 | swimming_water_cyanobacteria | 2019-06-14T07:52:58.907547+0300 | 2019-06-15T07:52:58.907547+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 702 | 39606 | swimming_water_cyanobacteria | 2019-06-14T08:04:22.205335+0300 | 2019-06-15T08:04:22.205335+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 704 | 39902 | swimming_water_cyanobacteria | 2019-06-14T08:14:40.620870+0300 | 2019-06-15T08:14:40.620870+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 706 | 39875 | swimming_water_cyanobacteria | 2019-06-14T08:29:48.158864+0300 | 2019-06-15T08:29:48.158864+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 708 | 39713 | swimming_water_cyanobacteria | 2019-06-14T08:44:33.769724+0300 | 2019-06-15T08:44:33.769724+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 710 | 39322 | swimming_water_cyanobacteria | 2019-06-14T09:44:12.773863+0300 | 2019-06-15T09:44:12.773863+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 712 | 39412 | swimming_water_cyanobacteria | 2019-06-14T09:53:18.309847+0300 | 2019-06-15T09:53:18.309847+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 715 | 40157 | swimming_water_cyanobacteria | 2019-06-14T09:54:34.311727+0300 | 2019-06-15T09:54:34.311727+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 717 | 39322 | swimming_water_cyanobacteria | 2019-06-14T10:00:58.201406+0300 | 2019-06-15T10:00:58.201406+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 719 | 41960 | swimming_water_cyanobacteria | 2019-06-14T10:02:54.075070+0300 | 2019-06-15T10:02:54.075070+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 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 | |||
| 723 | 40802 | swimming_water_cyanobacteria | 2019-06-14T10:09:24.570033+0300 | 2019-06-15T10:09:24.570033+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 725 | 52959 | swimming_water_cyanobacteria | 2019-06-14T10:11:35.804338+0300 | 2019-06-15T10:11:35.804338+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 728 | 39693 | swimming_water_cyanobacteria | 2019-06-14T10:25:27.495194+0300 | 2019-06-15T10:25:27.495194+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 732 | 40559 | swimming_water_cyanobacteria | 2019-06-14T10:29:59.856384+0300 | 2019-06-15T10:29:59.856384+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 735 | 40150 | swimming_water_cyanobacteria | 2019-06-14T10:34:07.496242+0300 | 2019-06-15T10:34:07.496242+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 737 | 41601 | swimming_water_cyanobacteria | 2019-06-14T10:42:22.036517+0300 | 2019-06-15T10:42:22.036517+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 741 | 39693 | swimming_water_cyanobacteria | 2019-06-14T14:07:56.224571+0300 | 2019-06-15T14:07:56.224571+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 744 | 39322 | swimming_water_cyanobacteria | 2019-06-14T14:18:28.067442+0300 | 2019-06-15T14:18:28.067442+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 746 | 39267 | swimming_water_cyanobacteria | 2019-06-14T17:56:44.684015+0300 | 2019-06-15T17:56:44.684015+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 750 | 39693 | swimming_water_cyanobacteria | 2019-06-14T18:02:15.473684+0300 | 2019-06-15T18:02:15.473684+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 754 | 39815 | swimming_water_cyanobacteria | 2019-06-15T10:01:41.993410+0300 | 2019-06-16T10:01:41.993410+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 756 | 41960 | swimming_water_cyanobacteria | 2019-06-15T10:01:44.545282+0300 | 2019-06-16T10:01:44.545282+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 758 | 39322 | swimming_water_cyanobacteria | 2019-06-15T10:03:00.084007+0300 | 2019-06-16T10:03:00.084007+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 760 | 41791 | swimming_water_cyanobacteria | 2019-06-15T10:05:51.819768+0300 | 2019-06-16T10:05:51.819768+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 762 | 40559 | swimming_water_cyanobacteria | 2019-06-15T10:11:27.935990+0300 | 2019-06-16T10:11:27.935990+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 765 | 40150 | swimming_water_cyanobacteria | 2019-06-15T10:16:16.253353+0300 | 2019-06-16T10:16:16.253353+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 767 | 39267 | swimming_water_cyanobacteria | 2019-06-15T10:24:01.520366+0300 | 2019-06-16T10:24:01.520366+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 773 | 40258 | swimming_water_cyanobacteria | 2019-06-15T10:52:30.641758+0300 | 2019-06-16T10:52:30.641758+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 776 | 40157 | swimming_water_cyanobacteria | 2019-06-15T10:55:02.791724+0300 | 2019-06-16T10:55:02.791724+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 778 | 40142 | swimming_water_cyanobacteria | 2019-06-15T12:20:16.464612+0300 | 2019-06-16T12:20:16.464612+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 781 | 40950 | swimming_water_cyanobacteria | 2019-06-15T13:44:11.537883+0300 | 2019-06-16T13:44:11.537883+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 783 | 39815 | swimming_water_cyanobacteria | 2019-06-15T13:49:52.772080+0300 | 2019-06-16T13:49:52.772080+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 786 | 39322 | swimming_water_cyanobacteria | 2019-06-15T13:56:50.232653+0300 | 2019-06-16T13:56:50.232653+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 788 | 39693 | swimming_water_cyanobacteria | 2019-06-15T14:04:53.274329+0300 | 2019-06-16T14:04:53.274329+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 790 | 39267 | swimming_water_cyanobacteria | 2019-06-15T15:47:53.775392+0300 | 2019-06-16T15:47:53.775392+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 792 | 39527 | swimming_water_cyanobacteria | 2019-06-15T15:56:26.559779+0300 | 2019-06-16T15:56:26.559779+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 795 | 39693 | swimming_water_cyanobacteria | 2019-06-15T17:59:28.788313+0300 | 2019-06-16T17:59:28.788313+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 797 | 39322 | swimming_water_cyanobacteria | 2019-06-15T18:21:02.700288+0300 | 2019-06-16T18:21:02.700288+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 800 | 41031 | swimming_water_cyanobacteria | 2019-06-16T08:24:10.222166+0300 | 2019-06-17T08:24:10.222166+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 802 | 41326 | swimming_water_cyanobacteria | 2019-06-16T08:24:19.151081+0300 | 2019-06-17T08:24:19.151081+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 804 | 41907 | swimming_water_cyanobacteria | 2019-06-16T08:24:24.540430+0300 | 2019-06-17T08:24:24.540430+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 806 | 40798 | swimming_water_cyanobacteria | 2019-06-16T08:24:31.219659+0300 | 2019-06-17T08:24:31.219659+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 808 | 39910 | swimming_water_cyanobacteria | 2019-06-16T08:24:51.994758+0300 | 2019-06-17T08:24:51.994758+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 810 | 40921 | swimming_water_cyanobacteria | 2019-06-16T08:25:15.052868+0300 | 2019-06-17T08:25:15.052868+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 814 | 39693 | swimming_water_cyanobacteria | 2019-06-16T08:25:49.431848+0300 | 2019-06-17T08:25:49.431848+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 816 | 40020 | swimming_water_cyanobacteria | 2019-06-16T08:26:10.578011+0300 | 2019-06-17T08:26:10.578011+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 818 | 40993 | swimming_water_cyanobacteria | 2019-06-16T08:26:25.457563+0300 | 2019-06-17T08:26:25.457563+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 820 | 40677 | swimming_water_cyanobacteria | 2019-06-16T08:26:35.516847+0300 | 2019-06-17T08:26:35.516847+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 822 | 52959 | swimming_water_cyanobacteria | 2019-06-16T09:16:17.039314+0300 | 2019-06-17T09:16:17.039314+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 824 | 39815 | swimming_water_cyanobacteria | 2019-06-16T09:48:16.661376+0300 | 2019-06-17T09:48:16.661376+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 833 | 39322 | swimming_water_cyanobacteria | 2019-06-16T10:08:53.647603+0300 | 2019-06-17T10:08:53.647603+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 835 | 41960 | swimming_water_cyanobacteria | 2019-06-16T10:11:37.127515+0300 | 2019-06-17T10:11:37.127515+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 837 | 40150 | swimming_water_cyanobacteria | 2019-06-16T10:12:19.971699+0300 | 2019-06-17T10:12:19.971699+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 838 | 39322 | swimming_water_cyanobacteria | 2019-06-16T10:12:33.333738+0300 | 2019-06-17T10:12:33.333738+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 840 | 39267 | swimming_water_cyanobacteria | 2019-06-16T10:13:39.756849+0300 | 2019-06-17T10:13:39.756849+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 842 | 40950 | swimming_water_cyanobacteria | 2019-06-16T10:14:06.351951+0300 | 2019-06-17T10:14:06.351951+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 844 | 41791 | swimming_water_cyanobacteria | 2019-06-16T10:20:05.332453+0300 | 2019-06-17T10:20:05.332453+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 846 | 40802 | swimming_water_cyanobacteria | 2019-06-16T10:23:41.932085+0300 | 2019-06-17T10:23:41.932085+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 849 | 40157 | swimming_water_cyanobacteria | 2019-06-16T10:25:01.096932+0300 | 2019-06-17T10:25:01.096932+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 851 | 40559 | swimming_water_cyanobacteria | 2019-06-16T10:32:35.162427+0300 | 2019-06-17T10:32:35.162427+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 855 | 41601 | swimming_water_cyanobacteria | 2019-06-16T11:26:45.823624+0300 | 2019-06-17T11:26:45.823624+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 857 | 40258 | swimming_water_cyanobacteria | 2019-06-16T12:13:08.571645+0300 | 2019-06-17T12:13:08.571645+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 861 | 40142 | swimming_water_cyanobacteria | 2019-06-16T13:38:17.003734+0300 | 2019-06-17T13:38:17.003734+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 864 | 39815 | swimming_water_cyanobacteria | 2019-06-16T13:55:10.297721+0300 | 2019-06-17T13:55:10.297721+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 867 | 39267 | swimming_water_cyanobacteria | 2019-06-16T13:57:29.422195+0300 | 2019-06-17T13:57:29.422195+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 875 | 39568 | swimming_water_cyanobacteria | 2019-06-16T14:18:40.192923+0300 | 2019-06-17T14:18:40.192923+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 877 | 39267 | swimming_water_cyanobacteria | 2019-06-16T17:53:02.260278+0300 | 2019-06-17T17:53:02.260278+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 880 | 39815 | swimming_water_cyanobacteria | 2019-06-16T17:54:47.460698+0300 | 2019-06-17T17:54:47.460698+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 882 | 39568 | swimming_water_cyanobacteria | 2019-06-16T18:15:21.339903+0300 | 2019-06-17T18:15:21.339903+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 885 | 39322 | swimming_water_cyanobacteria | 2019-06-16T19:01:24.551603+0300 | 2019-06-17T19:01:24.551603+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 887 | 39713 | swimming_water_cyanobacteria | 2019-06-17T07:41:17.000271+0300 | 2019-06-18T07:41:17.000271+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 889 | 39875 | swimming_water_cyanobacteria | 2019-06-17T08:06:45.742388+0300 | 2019-06-18T08:06:45.742388+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 891 | 39902 | swimming_water_cyanobacteria | 2019-06-17T08:24:43.470303+0300 | 2019-06-18T08:24:43.470303+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 893 | 39606 | swimming_water_cyanobacteria | 2019-06-17T08:37:26.441842+0300 | 2019-06-18T08:37:26.441842+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 895 | 39693 | swimming_water_cyanobacteria | 2019-06-17T09:04:14.096864+0300 | 2019-06-18T09:04:14.096864+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 897 | 53461 | swimming_water_cyanobacteria | 2019-06-17T09:16:33.034954+0300 | 2019-06-18T09:16:33.034954+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 899 | 39823 | swimming_water_cyanobacteria | 2019-06-17T09:34:09.734799+0300 | 2019-06-18T09:34:09.734799+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 901 | 39322 | swimming_water_cyanobacteria | 2019-06-17T09:59:22.763374+0300 | 2019-06-18T09:59:22.763374+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 902 | 39267 | swimming_water_cyanobacteria | 2019-06-17T10:04:00.803311+0300 | 2019-06-18T10:04:00.803311+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 905 | 39412 | swimming_water_cyanobacteria | 2019-06-17T10:05:21.419065+0300 | 2019-06-18T10:05:21.419065+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 908 | 39693 | swimming_water_cyanobacteria | 2019-06-17T10:07:34.428232+0300 | 2019-06-18T10:07:34.428232+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 910 | 40802 | swimming_water_cyanobacteria | 2019-06-17T10:16:55.530860+0300 | 2019-06-18T10:16:55.530860+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 912 | 40150 | swimming_water_cyanobacteria | 2019-06-17T10:31:50.180847+0300 | 2019-06-18T10:31:50.180847+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 914 | 40157 | swimming_water_cyanobacteria | 2019-06-17T10:42:14.993300+0300 | 2019-06-18T10:42:14.993300+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 916 | 40559 | swimming_water_cyanobacteria | 2019-06-17T10:52:19.847758+0300 | 2019-06-18T10:52:19.847758+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 919 | 41601 | swimming_water_cyanobacteria | 2019-06-17T10:58:25.195607+0300 | 2019-06-18T10:58:25.195607+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 921 | 39527 | swimming_water_cyanobacteria | 2019-06-17T11:16:58.025091+0300 | 2019-06-18T11:16:58.025091+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 925 | 40142 | swimming_water_cyanobacteria | 2019-06-17T13:05:46.817394+0300 | 2019-06-18T13:05:46.817394+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 934 | 39267 | swimming_water_cyanobacteria | 2019-06-17T13:59:41.167721+0300 | 2019-06-18T13:59:41.167721+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 936 | 39322 | swimming_water_cyanobacteria | 2019-06-17T14:01:44.234876+0300 | 2019-06-18T14:01:44.234876+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 938 | 39693 | swimming_water_cyanobacteria | 2019-06-17T14:05:16.961280+0300 | 2019-06-18T14:05:16.961280+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory |
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 );