observation

51,120 rows sorted by value_fi

✎ View and edit SQL

This data as json, CSV (advanced)

id unit property time expiration_time value_fi ▼ name_fi value_sv name_sv primary name_en value quality value_en
169 40993 swimming_water_temperature 2019-06-06T12:51:31.517274+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
170 40993 swimming_water_temperature 2019-06-06T12:51:31.651501+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
173 39267 swimming_water_temperature 2019-06-06T12:51:32.063938+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
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  
180 39267 swimming_water_temperature 2019-06-06T14:10:39.608279+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
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  
182 40950 swimming_water_temperature 2019-06-06T14:10:39.914760+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
184 39815 swimming_water_temperature 2019-06-06T15:18:31.932506+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
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  
186 40386 swimming_water_temperature 2019-06-06T15:18:32.220657+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
187 39693 swimming_water_temperature 2019-06-06T17:51:51.799967+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
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  
189 39815 swimming_water_temperature 2019-06-06T19:43:24.985518+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
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  
192 39815 swimming_water_temperature 2019-06-07T08:30:29.052361+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
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  
195 39693 swimming_water_temperature 2019-06-07T09:40:40.293487+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
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  
197 39527 swimming_water_temperature 2019-06-07T09:44:25.167317+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
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  
201 39815 swimming_water_temperature 2019-06-07T09:58:44.666515+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
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  
204 40802 swimming_water_temperature 2019-06-07T10:02:44.386293+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
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  
206 40950 swimming_water_temperature 2019-06-07T10:09:54.471137+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
207 41601 swimming_water_temperature 2019-06-07T10:14:41.514036+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
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  
211 41791 swimming_water_temperature 2019-06-07T10:24:59.111664+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
212 41791 swimming_water_temperature 2019-06-07T10:25:44.452775+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
213 41791 swimming_water_temperature 2019-06-07T10:26:07.112503+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
214 40150 swimming_water_temperature 2019-06-07T10:35:30.790678+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
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  
216 40157 swimming_water_temperature 2019-06-07T10:35:43.267632+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
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  
218 40142 swimming_water_temperature 2019-06-07T11:22:11.956190+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
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  
222 39322 swimming_water_temperature 2019-06-07T11:23:40.887777+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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  
224 39322 swimming_water_temperature 2019-06-07T11:35:37.055471+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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  
226 39322 swimming_water_temperature 2019-06-07T11:35:37.494252+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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  
228 39322 swimming_water_temperature 2019-06-07T11:35:37.963596+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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  
230 40559 swimming_water_temperature 2019-06-07T12:33:44.310597+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
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  
232 41791 swimming_water_temperature 2019-06-07T13:42:22.858744+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
235 41791 swimming_water_temperature 2019-06-07T13:45:23.030764+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
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  
238 39693 swimming_water_temperature 2019-06-07T13:53:24.595690+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
240 39815 swimming_water_temperature 2019-06-07T14:12:33.987424+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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  
244 39322 swimming_water_temperature 2019-06-07T15:15:49.773357+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
245 39322 swimming_water_temperature 2019-06-07T15:17:51.123747+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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  
247 39568 swimming_water_temperature 2019-06-07T16:12:54.240114+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
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  
253 39583 swimming_water_temperature 2019-06-07T16:16:17.022761+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
255 39815 swimming_water_temperature 2019-06-07T18:22:39.344024+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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  
258 39322 swimming_water_temperature 2019-06-07T19:42:40.358960+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
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  
265 39693 swimming_water_temperature 2019-06-08T08:17:40.785403+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
266 41791 swimming_water_temperature 2019-06-08T10:05:04.461932+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
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  
268 40559 swimming_water_temperature 2019-06-08T10:06:22.810174+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
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  
271 40157 swimming_water_temperature 2019-06-08T10:08:25.066166+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
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  
273 39815 swimming_water_temperature 2019-06-08T10:19:17.389316+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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  
275 41601 swimming_water_temperature 2019-06-08T10:39:32.888284+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
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  
277 40950 swimming_water_temperature 2019-06-08T10:42:23.679616+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
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  
279 40950 swimming_water_temperature 2019-06-08T10:42:31.568387+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
280 40950 swimming_water_temperature 2019-06-08T10:42:39.967382+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
282 40142 swimming_water_temperature 2019-06-08T10:56:28.697399+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
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  
285 39568 swimming_water_temperature 2019-06-08T11:04:03.917676+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
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  
287 39568 swimming_water_temperature 2019-06-08T11:04:17.424698+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
288 40950 swimming_water_temperature 2019-06-08T13:50:00.248514+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
289 39693 swimming_water_temperature 2019-06-08T14:07:46.413233+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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  
293 39815 swimming_water_temperature 2019-06-08T14:37:24.368764+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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  
296 39267 swimming_water_temperature 2019-06-08T17:01:07.633245+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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  
298 39815 swimming_water_temperature 2019-06-08T17:52:09.671494+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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  
301 39267 swimming_water_temperature 2019-06-08T17:58:54.777603+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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  
303 39693 swimming_water_temperature 2019-06-08T17:59:20.966316+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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  

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