1,975 rows where quality = "satisfactory"

View and edit SQL

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

quality

  • satisfactory · 1,975
id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
97 41791 swimming_water_cyanobacteria 2019-06-05T10:06:58.392343+0300 2019-06-06T10:06:58.392343+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
974 39693 swimming_water_cyanobacteria 2019-06-18T09:14:44.385231+0300 2019-06-19T09:14:44.385231+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  
983 39322 swimming_water_cyanobacteria 2019-06-18T10:07:47.333863+0300 2019-06-19T10:07:47.333863+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  
1006 39322 swimming_water_cyanobacteria 2019-06-18T14:03:14.340740+0300 2019-06-19T14:03:14.340740+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  
1038 39322 swimming_water_cyanobacteria 2019-06-19T10:00:26.305094+0300 2019-06-20T10:00:26.305094+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  
1084 39322 swimming_water_cyanobacteria 2019-06-19T13:56:46.993234+0300 2019-06-20T13:56:46.993234+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  
1098 39322 swimming_water_cyanobacteria 2019-06-19T17:53:36.466152+0300 2019-06-20T17:53:36.466152+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1117 39693 swimming_water_cyanobacteria 2019-06-20T09:28:15.529503+0300 2019-06-21T09:28:15.529503+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1131 39815 swimming_water_cyanobacteria 2019-06-20T10:08:47.704164+0300 2019-06-21T10:08:47.704164+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1139 40950 swimming_water_cyanobacteria 2019-06-20T10:14:39.114186+0300 2019-06-21T10:14:39.114186+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1146 41960 swimming_water_cyanobacteria 2019-06-20T10:30:52.644142+0300 2019-06-21T10:30:52.644142+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  
1181 39322 swimming_water_cyanobacteria 2019-06-20T13:58:41.832594+0300 2019-06-21T13:58:41.832594+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1183 39693 swimming_water_cyanobacteria 2019-06-20T14:00:56.878850+0300 2019-06-21T14:00:56.878850+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  
1189 39583 swimming_water_cyanobacteria 2019-06-20T14:19:27.575905+0300 2019-06-21T14:19:27.575905+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1190 39846 swimming_water_cyanobacteria 2019-06-20T14:19:57.730331+0300 2019-06-21T14:19:57.730331+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  
1202 39322 swimming_water_cyanobacteria 2019-06-20T18:02:21.445164+0300 2019-06-21T18:02:21.445164+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1356 39412 swimming_water_cyanobacteria 2019-06-24T09:16:02.186464+0300 2019-06-25T09:16:02.186464+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  
1397 39322 swimming_water_cyanobacteria 2019-06-24T10:33:36.584280+0300 2019-06-25T10:33:36.584280+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1425 39322 swimming_water_cyanobacteria 2019-06-24T14:04:44.674751+0300 2019-06-25T14:04:44.674751+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  
1449 39322 swimming_water_cyanobacteria 2019-06-24T17:52:10.527939+0300 2019-06-25T17:52:10.527939+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1460 39322 swimming_water_cyanobacteria 2019-06-25T09:58:01.979120+0300 2019-06-26T09:58:01.979120+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1478 39583 swimming_water_cyanobacteria 2019-06-25T10:21:59.737263+0300 2019-06-26T10:21:59.737263+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1505 39322 swimming_water_cyanobacteria 2019-06-25T14:08:33.887406+0300 2019-06-26T14:08:33.887406+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1507 39322 swimming_water_cyanobacteria 2019-06-25T14:10:42.476694+0300 2019-06-26T14:10:42.476694+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1540 39322 swimming_water_cyanobacteria 2019-06-25T18:03:56.606592+0300 2019-06-26T18:03:56.606592+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1544 39322 swimming_water_cyanobacteria 2019-06-26T09:55:55.767975+0300 2019-06-27T09:55:55.767975+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1573 39322 swimming_water_cyanobacteria 2019-06-26T13:52:26.906961+0300 2019-06-27T13:52:26.906961+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1611 40386 swimming_water_cyanobacteria 2019-06-27T10:10:06.804037+0300 2019-06-28T10:10:06.804037+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1626 41601 swimming_water_cyanobacteria 2019-06-27T10:28:17.661833+0300 2019-06-28T10:28:17.661833+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1628 39322 swimming_water_cyanobacteria 2019-06-27T10:35:09.795856+0300 2019-06-28T10:35:09.795856+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
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  
1635 39583 swimming_water_cyanobacteria 2019-06-27T13:15:35.420984+0300 2019-06-28T13:15:35.420984+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1663 39412 swimming_water_cyanobacteria 2019-06-27T13:28:30.202989+0300 2019-06-28T13:28:30.202989+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1674 39583 swimming_water_cyanobacteria 2019-06-27T14:05:18.368274+0300 2019-06-28T14:05:18.368274+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  
1705 39322 swimming_water_cyanobacteria 2019-06-27T16:24:47.173505+0300 2019-06-28T16:24:47.173505+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  
1721 39322 swimming_water_cyanobacteria 2019-06-28T10:00:59.474031+0300 2019-06-29T10:00:59.474031+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1732 40386 swimming_water_cyanobacteria 2019-06-28T10:21:15.991821+0300 2019-06-29T10:21:15.991821+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1749 41601 swimming_water_cyanobacteria 2019-06-28T11:30:07.378078+0300 2019-06-29T11:30:07.378078+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1751 39583 swimming_water_cyanobacteria 2019-06-28T12:08:08.786683+0300 2019-06-29T12:08:08.786683+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1761 39583 swimming_water_cyanobacteria 2019-06-28T14:20:22.293684+0300 2019-06-29T14:20:22.293684+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1764 39322 swimming_water_cyanobacteria 2019-06-28T14:21:32.390873+0300 2019-06-29T14:21:32.390873+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1778 39322 swimming_water_cyanobacteria 2019-06-28T17:51:59.414157+0300 2019-06-29T17:51:59.414157+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1781 39583 swimming_water_cyanobacteria 2019-06-28T17:57:40.958705+0300 2019-06-29T17:57:40.958705+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1806 39322 swimming_water_cyanobacteria 2019-06-29T10:19:54.272740+0300 2019-06-30T10:19:54.272740+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1819 39583 swimming_water_cyanobacteria 2019-06-29T10:37:54.320646+0300 2019-06-30T10:37:54.320646+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1838 39322 swimming_water_cyanobacteria 2019-06-29T14:03:54.226123+0300 2019-06-30T14:03:54.226123+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1844 39583 swimming_water_cyanobacteria 2019-06-29T17:45:34.829653+0300 2019-06-30T17:45:34.829653+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1851 39322 swimming_water_cyanobacteria 2019-06-29T18:21:58.029858+0300 2019-06-30T18:21:58.029858+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1857 39322 swimming_water_cyanobacteria 2019-06-30T09:56:23.210698+0300 2019-07-01T09:56:23.210698+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1906 39322 swimming_water_cyanobacteria 2019-06-30T14:00:14.623297+0300 2019-07-01T14:00:14.623297+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1926 39322 swimming_water_cyanobacteria 2019-06-30T17:52:02.455156+0300 2019-07-01T17:52:02.455156+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1986 40157 swimming_water_cyanobacteria 2019-07-01T10:26:06.682965+0300 2019-07-02T10:26:06.682965+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
2026 53461 swimming_water_cyanobacteria 2019-07-01T14:21:50.011953+0300 2019-07-02T14:21:50.011953+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
2109 40950 swimming_water_cyanobacteria 2019-07-03T10:05:42.313257+0300 2019-07-04T10:05:42.313257+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
2141 39322 swimming_water_cyanobacteria 2019-07-03T14:07:26.672705+0300 2019-07-04T14:07:26.672705+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
2149 39322 swimming_water_cyanobacteria 2019-07-03T17:49:17.748178+0300 2019-07-04T17:49:17.748178+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
2169 39322 swimming_water_cyanobacteria 2019-07-04T09:59:17.027506+0300 2019-07-05T09:59:17.027506+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
2196 39527 swimming_water_cyanobacteria 2019-07-04T11:46:38.339957+0300 2019-07-05T11:46:38.339957+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
2223 39527 swimming_water_cyanobacteria 2019-07-04T13:56:34.472065+0300 2019-07-05T13:56:34.472065+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
2236 39583 swimming_water_cyanobacteria 2019-07-04T14:23:32.201446+0300 2019-07-05T14:23:32.201446+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
2240 39322 swimming_water_cyanobacteria 2019-07-04T14:32:02.920270+0300 2019-07-05T14:32:02.920270+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
2243 39583 swimming_water_cyanobacteria 2019-07-04T17:36:14.460713+0300 2019-07-05T17:36:14.460713+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  

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