observation
7,945 rows where primary = 1
This data as json, CSV (advanced)
name_sv ✖
- Inga blågröna alger 2,536
- Lite blågröna alger 1,857
- Isad 1,452
- Plogad 526
- Stängd 419
- Rikligt med blågröna alger 280
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
941 | 40950 | swimming_water_cyanobacteria | 2019-06-17T15:02:38.139510+0300 | 2019-06-18T15:02:38.139510+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
943 | 39815 | swimming_water_cyanobacteria | 2019-06-17T15:06:05.169957+0300 | 2019-06-18T15:06:05.169957+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
947 | 39568 | swimming_water_cyanobacteria | 2019-06-17T17:05:24.741147+0300 | 2019-06-18T17:05:24.741147+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
949 | 39693 | swimming_water_cyanobacteria | 2019-06-17T17:52:06.230768+0300 | 2019-06-18T17:52:06.230768+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
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 | |||
954 | 39815 | swimming_water_cyanobacteria | 2019-06-17T18:12:35.428225+0300 | 2019-06-18T18:12:35.428225+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
957 | 41907 | swimming_water_cyanobacteria | 2019-06-18T08:41:26.993898+0300 | 2019-06-19T08:41:26.993898+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
959 | 40798 | swimming_water_cyanobacteria | 2019-06-18T08:41:35.744206+0300 | 2019-06-19T08:41:35.744206+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
961 | 39910 | swimming_water_cyanobacteria | 2019-06-18T08:41:43.573696+0300 | 2019-06-19T08:41:43.573696+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
963 | 41031 | swimming_water_cyanobacteria | 2019-06-18T08:47:43.293645+0300 | 2019-06-19T08:47:43.293645+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
965 | 40098 | swimming_water_cyanobacteria | 2019-06-18T08:48:18.197341+0300 | 2019-06-19T08:48:18.197341+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
967 | 39815 | swimming_water_cyanobacteria | 2019-06-18T08:51:48.980139+0300 | 2019-06-19T08:51:48.980139+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
1071 | 53461 | swimming_water_cyanobacteria | 2019-06-19T13:09:53.658604+0300 | 2019-06-20T13:09:53.658604+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1072 | 40258 | swimming_water_cyanobacteria | 2019-06-19T13:19:46.704143+0300 | 2019-06-20T13:19:46.704143+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1074 | 39606 | swimming_water_cyanobacteria | 2019-06-19T13:49:06.075447+0300 | 2019-06-20T13:49:06.075447+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1076 | 39412 | swimming_water_cyanobacteria | 2019-06-19T13:51:05.044452+0300 | 2019-06-20T13:51:05.044452+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
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 | |||
1087 | 39693 | swimming_water_cyanobacteria | 2019-06-19T14:02:45.684189+0300 | 2019-06-20T14:02:45.684189+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
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 | |||
1094 | 52959 | swimming_water_cyanobacteria | 2019-06-19T14:38:21.746014+0300 | 2019-06-20T14:38:21.746014+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
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 | |||
1100 | 52959 | swimming_water_cyanobacteria | 2019-06-19T17:57:50.689777+0300 | 2019-06-20T17:57:50.689777+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1104 | 39693 | swimming_water_cyanobacteria | 2019-06-19T18:12:20.621623+0300 | 2019-06-20T18:12:20.621623+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1109 | 39815 | swimming_water_cyanobacteria | 2019-06-19T18:14:23.728415+0300 | 2019-06-20T18:14:23.728415+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1111 | 39412 | swimming_water_cyanobacteria | 2019-06-20T08:17:35.590717+0300 | 2019-06-21T08:17:35.590717+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1113 | 39823 | swimming_water_cyanobacteria | 2019-06-20T09:06:03.886310+0300 | 2019-06-21T09:06:03.886310+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1115 | 53461 | swimming_water_cyanobacteria | 2019-06-20T09:06:27.133139+0300 | 2019-06-21T09:06:27.133139+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
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 | |||
1120 | 39875 | swimming_water_cyanobacteria | 2019-06-20T09:55:40.043817+0300 | 2019-06-21T09:55:40.043817+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1122 | 39713 | swimming_water_cyanobacteria | 2019-06-20T10:02:06.437572+0300 | 2019-06-21T10:02:06.437572+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1125 | 41791 | swimming_water_cyanobacteria | 2019-06-20T10:03:55.979332+0300 | 2019-06-21T10:03:55.979332+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1126 | 40802 | swimming_water_cyanobacteria | 2019-06-20T10:03:57.750507+0300 | 2019-06-21T10:03:57.750507+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1128 | 40559 | swimming_water_cyanobacteria | 2019-06-20T10:07:05.912727+0300 | 2019-06-21T10:07:05.912727+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
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 | |||
1135 | 40098 | swimming_water_cyanobacteria | 2019-06-20T10:11:06.292960+0300 | 2019-06-21T10:11:06.292960+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
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 | |||
1142 | 40142 | swimming_water_cyanobacteria | 2019-06-20T10:21:40.164227+0300 | 2019-06-21T10:21:40.164227+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
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 | |||
1148 | 41601 | swimming_water_cyanobacteria | 2019-06-20T10:32:58.306075+0300 | 2019-06-21T10:32:58.306075+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1150 | 40157 | swimming_water_cyanobacteria | 2019-06-20T10:34:09.766639+0300 | 2019-06-21T10:34:09.766639+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1152 | 40150 | swimming_water_cyanobacteria | 2019-06-20T10:46:44.190811+0300 | 2019-06-21T10:46:44.190811+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1154 | 40258 | swimming_water_cyanobacteria | 2019-06-20T10:58:36.615176+0300 | 2019-06-21T10:58:36.615176+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
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 | |||
1158 | 39527 | swimming_water_cyanobacteria | 2019-06-20T11:13:42.531165+0300 | 2019-06-21T11:13:42.531165+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1160 | 40386 | swimming_water_cyanobacteria | 2019-06-20T11:55:16.635482+0300 | 2019-06-21T11:55:16.635482+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1162 | 40798 | swimming_water_cyanobacteria | 2019-06-20T13:49:32.080716+0300 | 2019-06-21T13:49:32.080716+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1164 | 41907 | swimming_water_cyanobacteria | 2019-06-20T13:49:40.935967+0300 | 2019-06-21T13:49:40.935967+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1166 | 39910 | swimming_water_cyanobacteria | 2019-06-20T13:51:02.704562+0300 | 2019-06-21T13:51:02.704562+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1168 | 40921 | swimming_water_cyanobacteria | 2019-06-20T13:51:41.704421+0300 | 2019-06-21T13:51:41.704421+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1170 | 41326 | swimming_water_cyanobacteria | 2019-06-20T13:51:51.638997+0300 | 2019-06-21T13:51:51.638997+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1172 | 41031 | swimming_water_cyanobacteria | 2019-06-20T13:52:30.955386+0300 | 2019-06-21T13:52:30.955386+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1174 | 40677 | swimming_water_cyanobacteria | 2019-06-20T13:53:02.363802+0300 | 2019-06-21T13:53:02.363802+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1176 | 40020 | swimming_water_cyanobacteria | 2019-06-20T13:53:36.165731+0300 | 2019-06-21T13:53:36.165731+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
1178 | 40993 | swimming_water_cyanobacteria | 2019-06-20T13:54:48.093145+0300 | 2019-06-21T13:54:48.093145+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
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 |
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 );