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
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  
310 40921 swimming_water_temperature 2019-06-09T08:58:41.314672+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
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  
312 41326 swimming_water_temperature 2019-06-09T08:59:01.215687+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
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  
314 40020 swimming_water_temperature 2019-06-09T08:59:13.060529+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
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  
316 40677 swimming_water_temperature 2019-06-09T08:59:50.077804+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
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  
318 41907 swimming_water_temperature 2019-06-09T09:00:59.552292+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
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  
320 39910 swimming_water_temperature 2019-06-09T09:01:09.742957+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
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  
322 40798 swimming_water_temperature 2019-06-09T09:01:21.102140+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
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  
324 41791 swimming_water_temperature 2019-06-09T09:56:10.160415+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
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  
326 41601 swimming_water_temperature 2019-06-09T10:04:55.527909+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
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  
328 39693 swimming_water_temperature 2019-06-09T10:07:57.806433+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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  
331 39815 swimming_water_temperature 2019-06-09T10:13:45.481338+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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  
334 40559 swimming_water_temperature 2019-06-09T10:15:07.789629+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
335 40559 notice 2019-06-09T10:15:15.581523+0300                    
336 39322 swimming_water_temperature 2019-06-09T10:15:16.605748+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
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  
339 39267 swimming_water_temperature 2019-06-09T10:21:42.793020+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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  
341 40950 swimming_water_temperature 2019-06-09T10:22:13.251403+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
342 40950 swimming_water_cyanobacteria 2019-06-09T10:22:30.603308+0300 2019-06-10T10:22:30.603308+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
343 40157 swimming_water_temperature 2019-06-09T10:23:07.028385+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
344 40157 swimming_water_cyanobacteria 2019-06-09T10:23:09.627366+0300 2019-06-10T10:23:09.627366+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
345 40142 swimming_water_temperature 2019-06-09T10:31:49.644740+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
346 40142 swimming_water_cyanobacteria 2019-06-09T10:31:52.689274+0300 2019-06-10T10:31:52.689274+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
348 40258 swimming_water_temperature 2019-06-09T10:45:11.049642+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
349 40258 swimming_water_cyanobacteria 2019-06-09T10:45:17.109611+0300 2019-06-10T10:45:17.109611+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
352 40150 swimming_water_temperature 2019-06-09T12:28:43.832936+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
353 40150 swimming_water_cyanobacteria 2019-06-09T12:28:44.046330+0300 2019-06-10T12:28:44.046330+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
354 40098 swimming_water_temperature 2019-06-09T12:28:44.344657+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
355 40098 swimming_water_cyanobacteria 2019-06-09T12:28:44.546780+0300 2019-06-10T12:28:44.546780+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
356 39815 swimming_water_temperature 2019-06-09T13:56:38.214778+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
357 39815 swimming_water_cyanobacteria 2019-06-09T13:56:42.913548+0300 2019-06-10T13:56:42.913548+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
366 39322 swimming_water_temperature 2019-06-09T14:07:43.671307+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
367 39322 swimming_water_cyanobacteria 2019-06-09T14:07:48.854694+0300 2019-06-10T14:07:48.854694+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
368 39693 swimming_water_temperature 2019-06-09T14:14:24.082178+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
370 39693 swimming_water_cyanobacteria 2019-06-09T14:14:29.120574+0300 2019-06-10T14:14:29.120574+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
371 39693 swimming_water_temperature 2019-06-09T17:53:47.088974+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
373 39693 swimming_water_cyanobacteria 2019-06-09T17:53:48.981656+0300 2019-06-10T17:53:48.981656+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
374 39267 swimming_water_temperature 2019-06-09T17:54:11.286114+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
375 39267 swimming_water_cyanobacteria 2019-06-09T17:54:15.065650+0300 2019-06-10T17:54:15.065650+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
376 39815 swimming_water_temperature 2019-06-09T18:17:47.234884+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
377 39815 swimming_water_temperature 2019-06-09T18:17:50.236158+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
381 39322 swimming_water_temperature 2019-06-09T18:44:40.198426+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
382 39693 swimming_water_temperature 2019-06-10T08:15:53.628150+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
383 39693 swimming_water_cyanobacteria 2019-06-10T08:15:56.422459+0300 2019-06-11T08:15:56.422459+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
385 39815 swimming_water_temperature 2019-06-10T10:00:34.828200+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
386 39815 swimming_water_cyanobacteria 2019-06-10T10:00:37.594878+0300 2019-06-11T10:00:37.594878+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
389 41791 swimming_water_temperature 2019-06-10T10:01:18.592635+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
390 41791 swimming_water_cyanobacteria 2019-06-10T10:01:21.412341+0300 2019-06-11T10:01:21.412341+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
391 39322 swimming_water_temperature 2019-06-10T10:01:21.612696+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
392 39322 swimming_water_cyanobacteria 2019-06-10T10:01:32.789022+0300 2019-06-11T10:01:32.789022+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
393 40098 swimming_water_temperature 2019-06-10T10:07:48.757221+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
394 40098 swimming_water_cyanobacteria 2019-06-10T10:08:31.654594+0300 2019-06-11T10:08:31.654594+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
395 41601 swimming_water_temperature 2019-06-10T10:13:27.071351+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
396 41601 swimming_water_cyanobacteria 2019-06-10T10:13:31.326147+0300 2019-06-11T10:13:31.326147+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
397 40559 swimming_water_temperature 2019-06-10T10:18:09.001672+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
398 40559 swimming_water_cyanobacteria 2019-06-10T10:18:11.463679+0300 2019-06-11T10:18:11.463679+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
400 40950 swimming_water_temperature 2019-06-10T10:29:40.224791+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
401 40950 swimming_water_cyanobacteria 2019-06-10T10:29:44.114543+0300 2019-06-11T10:29:44.114543+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
402 39267 swimming_water_temperature 2019-06-10T10:34:16.433547+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
403 40150 swimming_water_temperature 2019-06-10T10:37:08.378059+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
404 40150 swimming_water_cyanobacteria 2019-06-10T10:37:20.987688+0300 2019-06-11T10:37:20.987688+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
405 41960 swimming_water_temperature 2019-06-10T10:57:42.684782+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
406 41960 swimming_water_cyanobacteria 2019-06-10T10:58:00.377675+0300 2019-06-11T10:58:00.377675+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
407 39322 swimming_water_cyanobacteria 2019-06-10T13:40:35.075811+0300 2019-06-11T13:40:35.075811+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
408 39322 swimming_water_temperature 2019-06-10T13:40:51.100444+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
410 39322 swimming_water_temperature 2019-06-10T13:45:12.831410+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
411 39815 swimming_water_cyanobacteria 2019-06-10T13:46:23.888435+0300 2019-06-11T13:46:23.888435+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
413 39815 swimming_water_temperature 2019-06-10T13:46:34.972562+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
414 39267 swimming_water_temperature 2019-06-10T13:56:59.031717+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
416 39693 swimming_water_temperature 2019-06-10T14:11:28.424217+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
417 39693 swimming_water_cyanobacteria 2019-06-10T14:11:32.609062+0300 2019-06-11T14:11:32.609062+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
418 40142 swimming_water_temperature 2019-06-10T14:52:12.889585+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
419 40142 swimming_water_cyanobacteria 2019-06-10T14:52:41.206758+0300 2019-06-11T14:52:41.206758+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
421 40157 swimming_water_temperature 2019-06-10T14:54:25.564905+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
422 40157 swimming_water_cyanobacteria 2019-06-10T14:54:29.068159+0300 2019-06-11T14:54:29.068159+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
423 40258 swimming_water_temperature 2019-06-10T15:03:59.731489+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
424 39322 swimming_water_temperature 2019-06-10T17:50:52.926026+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
425 39322 swimming_water_cyanobacteria 2019-06-10T17:51:08.455237+0300 2019-06-11T17:51:08.455237+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
426 39693 swimming_water_temperature 2019-06-10T18:30:40.103809+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
427 39693 swimming_water_cyanobacteria 2019-06-10T18:30:43.704157+0300 2019-06-11T18:30:43.704157+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
429 41031 swimming_water_temperature 2019-06-11T07:35:39.937460+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
430 41031 swimming_water_cyanobacteria 2019-06-11T07:35:42.220978+0300 2019-06-12T07:35:42.220978+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
431 41326 swimming_water_temperature 2019-06-11T07:35:54.816735+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
432 41326 swimming_water_cyanobacteria 2019-06-11T07:35:56.656586+0300 2019-06-12T07:35:56.656586+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
433 41907 swimming_water_temperature 2019-06-11T07:36:03.716690+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
434 41907 swimming_water_cyanobacteria 2019-06-11T07:36:05.845510+0300 2019-06-12T07:36:05.845510+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
435 40921 swimming_water_temperature 2019-06-11T07:36:19.863504+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  

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