7,945 rows where primary = 1

View and edit SQL

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
49 40258 swimming_water_cyanobacteria 2019-06-03T14:59:27.292015+0300 2019-06-04T14:59:27.292015+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
51 40559 swimming_water_cyanobacteria 2019-06-03T14:59:27.708116+0300 2019-06-04T14:59:27.708116+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
52 41047 season_status 2019-06-03T15:14:36.432563+0300     Kausi käynnissä   Säsongen igång 1 Season underway started good  
53 50401 season_status 2019-06-03T15:14:54.977849+0300     Kausi käynnissä   Säsongen igång 1 Season underway started good  
56 41791 swimming_water_cyanobacteria 2019-06-04T17:03:03.123733+0300 2019-06-05T17:03:03.123733+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
59 40142 swimming_water_cyanobacteria 2019-06-04T17:39:49.666969+0300 2019-06-05T17:39:49.666969+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
62 41791 swimming_water_cyanobacteria 2019-06-04T17:51:03.796603+0300 2019-06-05T17:51:03.796603+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
64 40386 swimming_water_cyanobacteria 2019-06-04T17:51:04.110115+0300 2019-06-05T17:51:04.110115+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
67 40150 swimming_water_cyanobacteria 2019-06-04T17:51:04.585805+0300 2019-06-05T17:51:04.585805+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
69 40157 swimming_water_cyanobacteria 2019-06-04T17:51:04.920372+0300 2019-06-05T17:51:04.920372+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
72 40098 swimming_water_cyanobacteria 2019-06-04T17:51:05.444684+0300 2019-06-05T17:51:05.444684+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
74 40950 swimming_water_cyanobacteria 2019-06-04T17:51:05.757482+0300 2019-06-05T17:51:05.757482+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
77 41960 swimming_water_cyanobacteria 2019-06-04T17:51:06.219639+0300 2019-06-05T17:51:06.219639+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
80 41601 swimming_water_cyanobacteria 2019-06-04T17:51:06.664807+0300 2019-06-05T17:51:06.664807+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
84 40559 swimming_water_cyanobacteria 2019-06-04T17:51:07.286358+0300 2019-06-05T17:51:07.286358+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
86 40802 swimming_water_cyanobacteria 2019-06-04T17:51:07.586619+0300 2019-06-05T17:51:07.586619+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
89 41791 swimming_water_cyanobacteria 2019-06-05T10:02:52.808718+0300 2019-06-06T10:02:52.808718+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
90 41791 swimming_water_cyanobacteria 2019-06-05T10:03:02.641703+0300 2019-06-06T10:03:02.641703+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
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  
98 41791 swimming_water_cyanobacteria 2019-06-05T10:07:02.833010+0300 2019-06-06T10:07:02.833010+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
104 41960 swimming_water_cyanobacteria 2019-06-05T10:38:14.837379+0300 2019-06-06T10:38:14.837379+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
106 40098 swimming_water_cyanobacteria 2019-06-05T10:51:43.131677+0300 2019-06-06T10:51:43.131677+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
108 40150 swimming_water_cyanobacteria 2019-06-05T10:51:43.541822+0300 2019-06-06T10:51:43.541822+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
116 40157 swimming_water_cyanobacteria 2019-06-05T11:00:56.804773+0300 2019-06-06T11:00:56.804773+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
119 41791 swimming_water_cyanobacteria 2019-06-05T11:12:17.870205+0300 2019-06-06T11:12:17.870205+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
123 40559 swimming_water_cyanobacteria 2019-06-05T15:36:17.702169+0300 2019-06-06T15:36:17.702169+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
126 40142 swimming_water_cyanobacteria 2019-06-05T18:40:26.384202+0300 2019-06-06T18:40:26.384202+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
129 41960 swimming_water_cyanobacteria 2019-06-06T10:01:31.169277+0300 2019-06-07T10:01:31.169277+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
131 39693 swimming_water_cyanobacteria 2019-06-06T10:04:02.159654+0300 2019-06-07T10:04:02.159654+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
134 40142 swimming_water_cyanobacteria 2019-06-06T10:18:13.961504+0300 2019-06-07T10:18:13.961504+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
136 40157 swimming_water_cyanobacteria 2019-06-06T10:23:20.148570+0300 2019-06-07T10:23:20.148570+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
138 40559 swimming_water_cyanobacteria 2019-06-06T10:27:24.292296+0300 2019-06-07T10:27:24.292296+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
141 40386 swimming_water_cyanobacteria 2019-06-06T10:43:25.188800+0300 2019-06-07T10:43:25.188800+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
143 39568 swimming_water_cyanobacteria 2019-06-06T10:43:25.473784+0300 2019-06-07T10:43:25.473784+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
151 41601 swimming_water_cyanobacteria 2019-06-06T11:02:35.952682+0300 2019-06-07T11:02:35.952682+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
154 40258 swimming_water_cyanobacteria 2019-06-06T11:12:15.839226+0300 2019-06-07T11:12:15.839226+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
159 40386 swimming_water_cyanobacteria 2019-06-06T11:16:25.743543+0300 2019-06-07T11:16:25.743543+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
161 40098 swimming_water_cyanobacteria 2019-06-06T11:16:26.025466+0300 2019-06-07T11:16:26.025466+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
163 39815 swimming_water_cyanobacteria 2019-06-06T11:16:26.291071+0300 2019-06-07T11:16:26.291071+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
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  
168 40993 swimming_water_cyanobacteria 2019-06-06T12:51:31.368644+0300 2019-06-07T12:51:31.368644+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
174 39693 swimming_water_cyanobacteria 2019-06-06T13:43:56.339090+0300 2019-06-07T13:43:56.339090+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  
185 39815 swimming_water_cyanobacteria 2019-06-06T15:18:32.085266+0300 2019-06-07T15:18:32.085266+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
188 39693 swimming_water_cyanobacteria 2019-06-06T17:51:56.490257+0300 2019-06-07T17:51:56.490257+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
190 39815 swimming_water_cyanobacteria 2019-06-06T19:43:29.756550+0300 2019-06-07T19:43:29.756550+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
193 39815 swimming_water_cyanobacteria 2019-06-07T08:30:31.141466+0300 2019-06-08T08:30:31.141466+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
196 39693 swimming_water_cyanobacteria 2019-06-07T09:40:44.456354+0300 2019-06-08T09:40:44.456354+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
198 39527 swimming_water_cyanobacteria 2019-06-07T09:44:25.383206+0300 2019-06-08T09:44:25.383206+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
202 39815 swimming_water_cyanobacteria 2019-06-07T09:58:46.944319+0300 2019-06-08T09:58:46.944319+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
205 40802 swimming_water_cyanobacteria 2019-06-07T10:02:46.586267+0300 2019-06-08T10:02:46.586267+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
208 41601 swimming_water_cyanobacteria 2019-06-07T10:14:43.966094+0300 2019-06-08T10:14:43.966094+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
215 40150 swimming_water_cyanobacteria 2019-06-07T10:35:31.010497+0300 2019-06-08T10:35:31.010497+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
217 40157 swimming_water_cyanobacteria 2019-06-07T10:35:47.192802+0300 2019-06-08T10:35:47.192802+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
219 40142 swimming_water_cyanobacteria 2019-06-07T11:22:19.144470+0300 2019-06-08T11:22:19.144470+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
223 39322 swimming_water_cyanobacteria 2019-06-07T11:23:46.934289+0300 2019-06-08T11:23:46.934289+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
225 39322 swimming_water_cyanobacteria 2019-06-07T11:35:37.275884+0300 2019-06-08T11:35:37.275884+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
227 39322 swimming_water_cyanobacteria 2019-06-07T11:35:37.729851+0300 2019-06-08T11:35:37.729851+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
229 39322 swimming_water_cyanobacteria 2019-06-07T11:35:38.182549+0300 2019-06-08T11:35:38.182549+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
231 40559 swimming_water_cyanobacteria 2019-06-07T12:33:46.546318+0300 2019-06-08T12:33:46.546318+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
236 41791 swimming_water_cyanobacteria 2019-06-07T13:45:35.883926+0300 2019-06-08T13:45:35.883926+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
237 39693 swimming_water_cyanobacteria 2019-06-07T13:53:20.573133+0300 2019-06-08T13:53:20.573133+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
241 39815 swimming_water_cyanobacteria 2019-06-07T14:12:36.283058+0300 2019-06-08T14:12:36.283058+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
246 39322 swimming_water_cyanobacteria 2019-06-07T15:17:51.371667+0300 2019-06-08T15:17:51.371667+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
248 39568 swimming_water_cyanobacteria 2019-06-07T16:12:57.200876+0300 2019-06-08T16:12:57.200876+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
252 39583 swimming_water_cyanobacteria 2019-06-07T16:16:06.378059+0300 2019-06-08T16:16:06.378059+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
256 39815 swimming_water_cyanobacteria 2019-06-07T18:22:42.163638+0300 2019-06-08T18:22:42.163638+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
259 39322 swimming_water_cyanobacteria 2019-06-07T19:42:43.393878+0300 2019-06-08T19:42:43.393878+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
264 39693 swimming_water_cyanobacteria 2019-06-08T08:17:34.950319+0300 2019-06-09T08:17:34.950319+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
267 41791 swimming_water_cyanobacteria 2019-06-08T10:05:12.370805+0300 2019-06-09T10:05:12.370805+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
270 40559 swimming_water_cyanobacteria 2019-06-08T10:06:35.326766+0300 2019-06-09T10:06:35.326766+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
272 40157 swimming_water_cyanobacteria 2019-06-08T10:08:29.379228+0300 2019-06-09T10:08:29.379228+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
274 39815 swimming_water_cyanobacteria 2019-06-08T10:19:19.630268+0300 2019-06-09T10:19:19.630268+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
276 41601 swimming_water_cyanobacteria 2019-06-08T10:39:35.893100+0300 2019-06-09T10:39:35.893100+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
278 40950 swimming_water_cyanobacteria 2019-06-08T10:42:27.900203+0300 2019-06-09T10:42:27.900203+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
283 40142 swimming_water_cyanobacteria 2019-06-08T10:56:32.085681+0300 2019-06-09T10:56:32.085681+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
286 39568 swimming_water_cyanobacteria 2019-06-08T11:04:09.535241+0300 2019-06-09T11:04:09.535241+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
290 39693 swimming_water_cyanobacteria 2019-06-08T14:07:54.007108+0300 2019-06-09T14:07:54.007108+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
294 39815 swimming_water_cyanobacteria 2019-06-08T14:37:26.875102+0300 2019-06-09T14:37:26.875102+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  
299 39815 swimming_water_cyanobacteria 2019-06-08T17:52:12.127172+0300 2019-06-09T17:52:12.127172+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  
304 39693 swimming_water_cyanobacteria 2019-06-08T17:59:31.611858+0300 2019-06-09T17:59:31.611858+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
307 39322 swimming_water_cyanobacteria 2019-06-08T23:41:39.898126+0300 2019-06-09T23:41:39.898126+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
308 52959 swimming_water_cyanobacteria 2019-06-08T23:42:58.130605+0300 2019-06-09T23:42:58.130605+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
309 39527 swimming_water_cyanobacteria 2019-06-08T23:43:20.801648+0300 2019-06-09T23:43:20.801648+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
311 40921 swimming_water_cyanobacteria 2019-06-09T08:58:46.214216+0300 2019-06-10T08:58:46.214216+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
313 41326 swimming_water_cyanobacteria 2019-06-09T08:59:03.247621+0300 2019-06-10T08:59:03.247621+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
315 40020 swimming_water_cyanobacteria 2019-06-09T08:59:14.907268+0300 2019-06-10T08:59:14.907268+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
317 40677 swimming_water_cyanobacteria 2019-06-09T08:59:51.845599+0300 2019-06-10T08:59:51.845599+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
319 41907 swimming_water_cyanobacteria 2019-06-09T09:01:01.776393+0300 2019-06-10T09:01:01.776393+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
321 39910 swimming_water_cyanobacteria 2019-06-09T09:01:11.390362+0300 2019-06-10T09:01:11.390362+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
323 40798 swimming_water_cyanobacteria 2019-06-09T09:01:22.807277+0300 2019-06-10T09:01:22.807277+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
325 41791 swimming_water_cyanobacteria 2019-06-09T09:56:13.442634+0300 2019-06-10T09:56:13.442634+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
327 41601 swimming_water_cyanobacteria 2019-06-09T10:04:57.642821+0300 2019-06-10T10:04:57.642821+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
329 39693 swimming_water_cyanobacteria 2019-06-09T10:08:00.843698+0300 2019-06-10T10:08:00.843698+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
332 39815 swimming_water_cyanobacteria 2019-06-09T10:13:47.623117+0300 2019-06-10T10:13:47.623117+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
337 40559 swimming_water_cyanobacteria 2019-06-09T10:15:18.357109+0300 2019-06-10T10:15:18.357109+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
338 39322 swimming_water_cyanobacteria 2019-06-09T10:15:22.169332+0300 2019-06-10T10:15:22.169332+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  

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