observation

7,945 rows where primary = 1 sorted by unit

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: property, name_fi, name_sv, name_en, value, quality

primary ✖

  • 1 · 7,945 ✖
id unit ▼ property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
952 39267 swimming_water_cyanobacteria 2019-06-17T17:52:56.665844+0300 2019-06-18T17:52:56.665844+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
981 39267 swimming_water_cyanobacteria 2019-06-18T10:05:04.684092+0300 2019-06-19T10:05:04.684092+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1003 39267 swimming_water_cyanobacteria 2019-06-18T13:57:29.809081+0300 2019-06-19T13:57:29.809081+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1016 39267 swimming_water_cyanobacteria 2019-06-18T17:41:54.059959+0300 2019-06-19T17:41:54.059959+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1041 39267 swimming_water_cyanobacteria 2019-06-19T10:10:09.189838+0300 2019-06-20T10:10:09.189838+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1090 39267 swimming_water_cyanobacteria 2019-06-19T14:03:23.722331+0300 2019-06-20T14:03:23.722331+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1096 39267 swimming_water_cyanobacteria 2019-06-19T17:35:00.848562+0300 2019-06-20T17:35:00.848562+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1156 39267 swimming_water_cyanobacteria 2019-06-20T11:10:42.343577+0300 2019-06-21T11:10:42.343577+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1186 39267 swimming_water_cyanobacteria 2019-06-20T14:07:52.466674+0300 2019-06-21T14:07:52.466674+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1195 39267 swimming_water_cyanobacteria 2019-06-20T17:48:38.752324+0300 2019-06-21T17:48:38.752324+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1360 39267 swimming_water_cyanobacteria 2019-06-24T10:07:58.914113+0300 2019-06-25T10:07:58.914113+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1427 39267 swimming_water_cyanobacteria 2019-06-24T14:13:55.769110+0300 2019-06-25T14:13:55.769110+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1444 39267 swimming_water_cyanobacteria 2019-06-24T17:46:14.434426+0300 2019-06-25T17:46:14.434426+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1474 39267 swimming_water_cyanobacteria 2019-06-25T10:16:50.559655+0300 2019-06-26T10:16:50.559655+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1500 39267 swimming_water_cyanobacteria 2019-06-25T13:56:40.296869+0300 2019-06-26T13:56:40.296869+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
1538 39267 swimming_water_cyanobacteria 2019-06-25T17:45:28.044838+0300 2019-06-26T17:45:28.044838+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
1557 39267 swimming_water_cyanobacteria 2019-06-26T10:21:56.337607+0300 2019-06-27T10:21:56.337607+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
1579 39267 swimming_water_cyanobacteria 2019-06-26T14:05:07.395076+0300 2019-06-27T14:05:07.395076+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1590 39267 swimming_water_cyanobacteria 2019-06-26T18:01:32.930330+0300 2019-06-27T18:01:32.930330+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1615 39267 swimming_water_cyanobacteria 2019-06-27T10:12:28.446126+0300 2019-06-28T10:12:28.446126+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1629 39267 swimming_water_cyanobacteria 2019-06-27T10:37:00.225862+0300 2019-06-28T10:37:00.225862+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1701 39267 swimming_water_cyanobacteria 2019-06-27T14:45:15.617184+0300 2019-06-28T14:45:15.617184+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1707 39267 swimming_water_cyanobacteria 2019-06-27T17:48:31.873013+0300 2019-06-28T17:48:31.873013+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1723 39267 swimming_water_cyanobacteria 2019-06-28T10:03:13.874257+0300 2019-06-29T10:03:13.874257+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1757 39267 swimming_water_cyanobacteria 2019-06-28T14:01:32.873491+0300 2019-06-29T14:01:32.873491+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1776 39267 swimming_water_cyanobacteria 2019-06-28T17:42:49.663827+0300 2019-06-29T17:42:49.663827+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1790 39267 swimming_water_cyanobacteria 2019-06-29T09:59:32.992284+0300 2019-06-30T09:59:32.992284+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1834 39267 swimming_water_cyanobacteria 2019-06-29T13:56:10.814640+0300 2019-06-30T13:56:10.814640+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1847 39267 swimming_water_cyanobacteria 2019-06-29T17:48:50.016329+0300 2019-06-30T17:48:50.016329+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1877 39267 swimming_water_cyanobacteria 2019-06-30T10:12:26.595205+0300 2019-07-01T10:12:26.595205+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1908 39267 swimming_water_cyanobacteria 2019-06-30T14:03:13.873297+0300 2019-07-01T14:03:13.873297+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1924 39267 swimming_water_cyanobacteria 2019-06-30T17:38:59.481516+0300 2019-07-01T17:38:59.481516+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1954 39267 swimming_water_cyanobacteria 2019-07-01T09:59:39.080433+0300 2019-07-02T09:59:39.080433+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2010 39267 swimming_water_cyanobacteria 2019-07-01T13:51:48.992729+0300 2019-07-02T13:51:48.992729+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2037 39267 swimming_water_cyanobacteria 2019-07-01T17:49:59.217861+0300 2019-07-02T17:49:59.217861+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2115 39267 swimming_water_cyanobacteria 2019-07-03T10:15:50.706358+0300 2019-07-04T10:15:50.706358+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2143 39267 swimming_water_cyanobacteria 2019-07-03T14:13:04.257612+0300 2019-07-04T14:13:04.257612+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2190 39267 swimming_water_cyanobacteria 2019-07-04T10:10:15.014333+0300 2019-07-05T10:10:15.014333+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2234 39267 swimming_water_cyanobacteria 2019-07-04T14:12:16.814909+0300 2019-07-05T14:12:16.814909+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2245 39267 swimming_water_cyanobacteria 2019-07-04T17:45:33.968651+0300 2019-07-05T17:45:33.968651+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2318 39267 swimming_water_cyanobacteria 2019-07-05T12:33:19.308854+0300 2019-07-06T12:33:19.308854+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2327 39267 swimming_water_cyanobacteria 2019-07-05T14:05:15.534562+0300 2019-07-06T14:05:15.534562+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2340 39267 swimming_water_cyanobacteria 2019-07-05T18:00:10.779753+0300 2019-07-06T18:00:10.779753+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2375 39267 swimming_water_cyanobacteria 2019-07-06T10:17:52.405252+0300 2019-07-07T10:17:52.405252+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2401 39267 swimming_water_cyanobacteria 2019-07-06T14:04:07.409313+0300 2019-07-07T14:04:07.409313+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2412 39267 swimming_water_cyanobacteria 2019-07-06T17:48:28.825465+0300 2019-07-07T17:48:28.825465+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2430 39267 swimming_water_cyanobacteria 2019-07-07T10:03:18.702191+0300 2019-07-08T10:03:18.702191+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2472 39267 swimming_water_cyanobacteria 2019-07-07T13:54:31.207894+0300 2019-07-08T13:54:31.207894+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2489 39267 swimming_water_cyanobacteria 2019-07-07T17:53:55.571998+0300 2019-07-08T17:53:55.571998+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2508 39267 swimming_water_cyanobacteria 2019-07-08T10:01:28.571989+0300 2019-07-09T10:01:28.571989+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2545 39267 swimming_water_cyanobacteria 2019-07-08T13:53:53.200144+0300 2019-07-09T13:53:53.200144+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2566 39267 swimming_water_cyanobacteria 2019-07-08T17:37:16.075515+0300 2019-07-09T17:37:16.075515+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2604 39267 swimming_water_cyanobacteria 2019-07-09T10:50:33.661335+0300 2019-07-10T10:50:33.661335+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2621 39267 swimming_water_cyanobacteria 2019-07-09T16:00:54.993722+0300 2019-07-10T16:00:54.993722+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2623 39267 swimming_water_cyanobacteria 2019-07-09T17:48:16.860886+0300 2019-07-10T17:48:16.860886+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2660 39267 swimming_water_cyanobacteria 2019-07-10T10:00:53.096823+0300 2019-07-11T10:00:53.096823+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2717 39267 swimming_water_cyanobacteria 2019-07-10T14:49:59.596844+0300 2019-07-11T14:49:59.596844+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2726 39267 swimming_water_cyanobacteria 2019-07-10T17:46:26.116613+0300 2019-07-11T17:46:26.116613+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2802 39267 swimming_water_cyanobacteria 2019-07-11T15:15:41.153681+0300 2019-07-12T15:15:41.153681+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2803 39267 swimming_water_cyanobacteria 2019-07-11T15:15:43.693659+0300 2019-07-12T15:15:43.693659+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2810 39267 swimming_water_cyanobacteria 2019-07-11T17:57:50.323784+0300 2019-07-12T17:57:50.323784+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2828 39267 swimming_water_cyanobacteria 2019-07-12T10:04:30.878488+0300 2019-07-13T10:04:30.878488+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2858 39267 swimming_water_cyanobacteria 2019-07-12T14:01:16.595045+0300 2019-07-13T14:01:16.595045+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2874 39267 swimming_water_cyanobacteria 2019-07-12T17:47:59.735519+0300 2019-07-13T17:47:59.735519+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2888 39267 swimming_water_cyanobacteria 2019-07-13T10:03:16.125405+0300 2019-07-14T10:03:16.125405+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2933 39267 swimming_water_cyanobacteria 2019-07-13T14:39:08.561550+0300 2019-07-14T14:39:08.561550+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2940 39267 swimming_water_cyanobacteria 2019-07-13T17:45:44.945271+0300 2019-07-14T17:45:44.945271+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2976 39267 swimming_water_cyanobacteria 2019-07-14T10:15:00.625315+0300 2019-07-15T10:15:00.625315+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3005 39267 swimming_water_cyanobacteria 2019-07-14T14:53:53.347520+0300 2019-07-15T14:53:53.347520+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3016 39267 swimming_water_cyanobacteria 2019-07-14T17:52:36.351142+0300 2019-07-15T17:52:36.351142+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3038 39267 swimming_water_cyanobacteria 2019-07-15T10:04:23.444120+0300 2019-07-16T10:04:23.444120+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3099 39267 swimming_water_cyanobacteria 2019-07-15T14:28:31.862333+0300 2019-07-16T14:28:31.862333+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3106 39267 swimming_water_cyanobacteria 2019-07-15T17:44:12.716109+0300 2019-07-16T17:44:12.716109+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3119 39267 swimming_water_cyanobacteria 2019-07-16T09:59:50.396099+0300 2019-07-17T09:59:50.396099+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3163 39267 swimming_water_cyanobacteria 2019-07-16T15:10:01.452514+0300 2019-07-17T15:10:01.452514+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3201 39267 swimming_water_cyanobacteria 2019-07-17T10:05:57.343600+0300 2019-07-18T10:05:57.343600+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3247 39267 swimming_water_cyanobacteria 2019-07-17T14:02:55.800300+0300 2019-07-18T14:02:55.800300+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3263 39267 swimming_water_cyanobacteria 2019-07-17T17:50:39.340483+0300 2019-07-18T17:50:39.340483+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3293 39267 swimming_water_cyanobacteria 2019-07-18T09:59:50.826852+0300 2019-07-19T09:59:50.826852+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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
);