observation
51,120 rows
This data as json, CSV (advanced)
name_fi ✖
- Ei sinilevää 2,525
- Vähän sinilevää 1,856
- Jäädytetty 1,452
- 17-19°C 1,159
- 19-21°C 1,146
- 15-17°C 720
- 21-23°C 715
- Aurattu 526
- alle 15°C 460
- Suljettu 419
- Runsaasti sinilevää 280
- Kunnostettu 220
- yli 23°C 180
- Hyvä 147
- Jäädytys aloitettu 117
- Erittäin runsaasti sinilevää 94
- Tyydyttävä 92
- Lumenpuute 54
- Heikko 20
- Lumetus kesken 16
- Suljettu muusta syystä 16
- Kausi käynnissä 8
- Kausi päättynyt 5
- Kilpailut/harjoitukset 4
- Latu pohjattu (ei latu-uraa) 2
| id ▼ | unit | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 969 | 39815 | notice | 2019-06-18T08:51:48.978623+0300 | Vesi 20°C | |||||||||
| 970 | 39815 | swimming_water_cyanobacteria | 2019-06-18T08:51:54.309581+0300 | 2019-06-19T08:51:54.309581+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 971 | 39815 | notice | 2019-06-18T08:51:59.668578+0300 | Vesi 20°C | |||||||||
| 972 | 39693 | notice | 2019-06-18T08:57:30.915798+0300 | Veden lämpötila 19ºC. | |||||||||
| 973 | 39693 | swimming_water_temperature | 2019-06-18T09:14:44.346461+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 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 | |||
| 975 | 39568 | swimming_water_temperature | 2019-06-18T09:52:13.128959+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
| 976 | 39568 | swimming_water_cyanobacteria | 2019-06-18T09:52:16.388390+0300 | 2019-06-19T09:52:16.388390+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 977 | 41791 | swimming_water_temperature | 2019-06-18T10:04:21.004713+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 978 | 41791 | swimming_water_cyanobacteria | 2019-06-18T10:04:25.212457+0300 | 2019-06-19T10:04:25.212457+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 979 | 39267 | swimming_water_temperature | 2019-06-18T10:04:57.735750+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 980 | 39267 | swimming_water_temperature | 2019-06-18T10:05:00.762138+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 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 | |||
| 982 | 39322 | swimming_water_temperature | 2019-06-18T10:07:13.667769+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 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 | |||
| 984 | 39815 | notice | 2019-06-18T10:08:41.067516+0300 | Vesi 20°C | |||||||||
| 985 | 39815 | swimming_water_temperature | 2019-06-18T10:08:58.163846+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 986 | 39815 | swimming_water_cyanobacteria | 2019-06-18T10:09:02.282535+0300 | 2019-06-19T10:09:02.282535+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 987 | 41601 | swimming_water_temperature | 2019-06-18T10:09:02.391852+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 988 | 41601 | swimming_water_cyanobacteria | 2019-06-18T10:09:06.083741+0300 | 2019-06-19T10:09:06.083741+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 989 | 40150 | swimming_water_temperature | 2019-06-18T10:32:11.695220+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 990 | 40150 | swimming_water_cyanobacteria | 2019-06-18T10:32:15.083719+0300 | 2019-06-19T10:32:15.083719+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 991 | 40142 | swimming_water_temperature | 2019-06-18T10:40:33.387440+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 992 | 40142 | swimming_water_cyanobacteria | 2019-06-18T10:40:37.102727+0300 | 2019-06-19T10:40:37.102727+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 993 | 40142 | notice | 2019-06-18T10:40:42.572692+0300 | Rantavalvojat paikalla 3.6.-11.8.2019 klo 10-20, joka päivä. Yleiset tilat menevät kiinni noin kello 19:45. Ranta hyvässä kunnossa. | |||||||||
| 994 | 40802 | swimming_water_temperature | 2019-06-18T11:03:43.722426+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 995 | 40802 | swimming_water_cyanobacteria | 2019-06-18T11:03:45.500073+0300 | 2019-06-19T11:03:45.500073+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 996 | 52959 | swimming_water_temperature | 2019-06-18T11:39:35.170786+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 997 | 52959 | swimming_water_cyanobacteria | 2019-06-18T11:39:37.507316+0300 | 2019-06-19T11:39:37.507316+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 998 | 41960 | swimming_water_temperature | 2019-06-18T12:25:33.925206+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 999 | 41960 | swimming_water_cyanobacteria | 2019-06-18T12:25:56.239477+0300 | 2019-06-19T12:25:56.239477+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 1000 | 40950 | swimming_water_temperature | 2019-06-18T13:31:03.564720+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 1001 | 40950 | swimming_water_cyanobacteria | 2019-06-18T13:31:07.169507+0300 | 2019-06-19T13:31:07.169507+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 1002 | 39267 | swimming_water_temperature | 2019-06-18T13:57:25.844224+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 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 | |||
| 1004 | 39693 | swimming_water_temperature | 2019-06-18T14:02:58.538067+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 1005 | 39693 | swimming_water_cyanobacteria | 2019-06-18T14:03:05.905784+0300 | 2019-06-19T14:03:05.905784+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 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 | |||
| 1007 | 39693 | notice | 2019-06-18T14:03:16.992496+0300 | Veden lämpötila 20ºC. | |||||||||
| 1008 | 39322 | swimming_water_temperature | 2019-06-18T14:03:26.589887+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 1009 | 39568 | swimming_water_temperature | 2019-06-18T14:07:06.253777+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 1010 | 39568 | swimming_water_cyanobacteria | 2019-06-18T14:07:10.516760+0300 | 2019-06-19T14:07:10.516760+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 1011 | 39815 | swimming_water_temperature | 2019-06-18T14:08:15.633290+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 1012 | 39815 | swimming_water_cyanobacteria | 2019-06-18T14:08:18.878372+0300 | 2019-06-19T14:08:18.878372+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 1013 | 39815 | notice | 2019-06-18T14:08:24.338172+0300 | Vesi 20°C | |||||||||
| 1014 | 52959 | swimming_water_cyanobacteria | 2019-06-18T15:38:32.603902+0300 | 2019-06-19T15:38:32.603902+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 1015 | 52959 | swimming_water_temperature | 2019-06-18T15:39:09.272717+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 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 | |||
| 1017 | 39267 | swimming_water_temperature | 2019-06-18T17:41:59.020786+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 1018 | 52959 | swimming_water_temperature | 2019-06-18T17:43:59.085560+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 1019 | 52959 | swimming_water_cyanobacteria | 2019-06-18T17:44:02.197575+0300 | 2019-06-19T17:44:02.197575+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 1020 | 39693 | notice | 2019-06-18T18:03:09.448616+0300 | Veden lämpötila 21ºC. | |||||||||
| 1021 | 39693 | swimming_water_temperature | 2019-06-18T18:03:19.989986+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 1022 | 39693 | swimming_water_temperature | 2019-06-18T18:03:27.116163+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 1023 | 39568 | swimming_water_temperature | 2019-06-18T18:05:17.763908+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 1024 | 39568 | swimming_water_cyanobacteria | 2019-06-18T18:05:22.049371+0300 | 2019-06-19T18:05:22.049371+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 1025 | 39568 | swimming_water_cyanobacteria | 2019-06-18T18:05:25.716923+0300 | 2019-06-19T18:05:25.716923+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 1026 | 39322 | swimming_water_temperature | 2019-06-18T18:28:36.975793+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 1027 | 39815 | swimming_water_temperature | 2019-06-18T18:34:37.210909+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 1028 | 39815 | swimming_water_cyanobacteria | 2019-06-18T18:34:41.235797+0300 | 2019-06-19T18:34:41.235797+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 1029 | 39693 | swimming_water_temperature | 2019-06-19T08:53:16.300412+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 1030 | 39693 | swimming_water_cyanobacteria | 2019-06-19T08:53:22.212154+0300 | 2019-06-20T08:53:22.212154+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 1031 | 39693 | notice | 2019-06-19T08:53:31.496255+0300 | Veden lämpötila 19ºC. | |||||||||
| 1032 | 39568 | swimming_water_temperature | 2019-06-19T09:49:50.906020+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 1033 | 39568 | swimming_water_cyanobacteria | 2019-06-19T09:49:53.731663+0300 | 2019-06-20T09:49:53.731663+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 1034 | 39815 | swimming_water_temperature | 2019-06-19T09:57:26.877364+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 1035 | 39815 | notice | 2019-06-19T09:57:34.595135+0300 | Vesi 20°C | |||||||||
| 1036 | 39815 | notice | 2019-06-19T09:57:39.657542+0300 | Vesi 20°C | |||||||||
| 1037 | 39322 | swimming_water_temperature | 2019-06-19T10:00:23.206036+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 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 | |||
| 1039 | 40098 | swimming_water_temperature | 2019-06-19T10:09:49.577820+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 1040 | 39267 | swimming_water_temperature | 2019-06-19T10:10:03.476058+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 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 | |||
| 1042 | 40142 | swimming_water_temperature | 2019-06-19T10:24:14.606228+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 1043 | 40142 | swimming_water_cyanobacteria | 2019-06-19T10:24:18.150858+0300 | 2019-06-20T10:24:18.150858+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 1044 | 40142 | notice | 2019-06-19T10:24:20.600435+0300 | Rantavalvojat paikalla 3.6.-11.8.2019 klo 10-20, joka päivä. Yleiset tilat menevät kiinni noin kello 19:45. Ranta hyvässä kunnossa. | |||||||||
| 1045 | 40142 | notice | 2019-06-19T10:24:25.460679+0300 | Rantavalvojat paikalla 3.6.-11.8.2019 klo 10-20, joka päivä. Yleiset tilat menevät kiinni noin kello 19:45. Ranta hyvässä kunnossa. | |||||||||
| 1046 | 39527 | swimming_water_temperature | 2019-06-19T10:24:54.041705+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 1047 | 39527 | swimming_water_cyanobacteria | 2019-06-19T10:24:57.015560+0300 | 2019-06-20T10:24:57.015560+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 1048 | 40802 | swimming_water_temperature | 2019-06-19T10:43:49.796571+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 1049 | 40802 | swimming_water_cyanobacteria | 2019-06-19T10:43:52.213605+0300 | 2019-06-20T10:43:52.213605+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 1050 | 52959 | swimming_water_temperature | 2019-06-19T10:52:59.683937+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 1051 | 52959 | swimming_water_cyanobacteria | 2019-06-19T10:53:06.687661+0300 | 2019-06-20T10:53:06.687661+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 1052 | 41960 | swimming_water_temperature | 2019-06-19T10:54:37.660937+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 1053 | 41960 | swimming_water_cyanobacteria | 2019-06-19T10:54:43.540994+0300 | 2019-06-20T10:54:43.540994+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 1054 | 39902 | swimming_water_temperature | 2019-06-19T10:58:55.489579+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 1055 | 39902 | swimming_water_cyanobacteria | 2019-06-19T10:58:58.619658+0300 | 2019-06-20T10:58:58.619658+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 1056 | 39875 | swimming_water_temperature | 2019-06-19T10:59:21.634110+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 1057 | 39875 | swimming_water_cyanobacteria | 2019-06-19T10:59:23.692407+0300 | 2019-06-20T10:59:23.692407+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 1058 | 40150 | swimming_water_temperature | 2019-06-19T11:00:17.137531+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 1059 | 40150 | swimming_water_cyanobacteria | 2019-06-19T11:00:20.694649+0300 | 2019-06-20T11:00:20.694649+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 1060 | 40950 | swimming_water_temperature | 2019-06-19T11:22:33.245881+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 1061 | 40950 | swimming_water_cyanobacteria | 2019-06-19T11:22:36.748735+0300 | 2019-06-20T11:22:36.748735+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 1062 | 40386 | swimming_water_temperature | 2019-06-19T12:02:14.444189+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 1063 | 40386 | swimming_water_cyanobacteria | 2019-06-19T12:02:20.009638+0300 | 2019-06-20T12:02:20.009638+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 1064 | 40559 | swimming_water_temperature | 2019-06-19T12:15:44.263082+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 1065 | 40559 | swimming_water_cyanobacteria | 2019-06-19T12:15:47.547832+0300 | 2019-06-20T12:15:47.547832+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 1066 | 40559 | notice | 2019-06-19T12:16:08.049330+0300 | 17 astetta merivesi. | |||||||||
| 1067 | 39823 | swimming_water_temperature | 2019-06-19T12:41:47.568465+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 1068 | 39823 | swimming_water_cyanobacteria | 2019-06-19T12:41:49.727456+0300 | 2019-06-20T12:41:49.727456+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 );