51,120 rows sorted by value

View and edit SQL

id unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value ▼ quality value_en
492 41791 notice 2019-06-11T11:57:20.678500+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
493 41791 notice 2019-06-11T11:57:28.431899+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
494 41791 notice 2019-06-11T11:57:35.677279+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
495 41791 notice 2019-06-11T11:57:48.595104+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
496 41791 notice 2019-06-11T11:57:57.081594+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
497 41791 notice 2019-06-11T11:57:57.943975+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
498 41791 notice 2019-06-11T11:59:25.171414+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
499 41791 notice 2019-06-11T11:59:37.948833+0300   Valvonta rannalla klo 10-18.Tervetuloa!               Valvonta rannalla klo 10-18.Tervetuloa!
502 41791 notice 2019-06-11T11:59:56.848537+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
503 41791 notice 2019-06-11T11:59:57.926449+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
504 41791 notice 2019-06-11T11:59:59.679244+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
505 41791 notice 2019-06-11T12:00:00.694819+0300   Valvonta rannalla klo 10-18.Tervetuloa!               Valvonta rannalla klo 10-18.Tervetuloa!
506 41791 notice 2019-06-11T12:00:01.601231+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
507 41791 notice 2019-06-11T12:00:02.398106+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
508 41791 notice 2019-06-11T12:00:02.891922+0300   Valvonta rannalla klo 10-18.Tervetuloa!               Valvonta rannalla klo 10-18.Tervetuloa!
509 41791 notice 2019-06-11T12:00:03.429335+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
510 41791 notice 2019-06-11T12:00:03.645540+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
511 41791 notice 2019-06-11T12:00:03.953372+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
512 41791 notice 2019-06-11T12:00:04.054096+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
513 41791 notice 2019-06-11T12:00:04.208763+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
514 41791 notice 2019-06-11T12:00:04.437045+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
515 41791 notice 2019-06-11T12:00:04.637818+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
516 41791 notice 2019-06-11T12:00:04.776828+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
517 41791 notice 2019-06-11T12:00:05.013389+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
518 41791 notice 2019-06-11T12:00:05.238639+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
519 41791 notice 2019-06-11T12:00:05.455006+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
520 41791 notice 2019-06-11T12:00:49.129587+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
521 41791 notice 2019-06-11T12:00:50.255854+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
522 41791 notice 2019-06-11T12:00:55.296703+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
523 41791 notice 2019-06-11T12:00:57.065950+0300   Valvonta rannalla klo 10-18.Tervetuloa!               Valvonta rannalla klo 10-18.Tervetuloa!
524 41791 notice 2019-06-11T12:00:57.623120+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
525 41791 notice 2019-06-11T12:00:57.914870+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
526 41791 notice 2019-06-11T12:00:58.115939+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
527 41791 notice 2019-06-11T12:00:58.347559+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
528 41791 notice 2019-06-11T12:00:58.561904+0300   Valvonta rannalla klo 10-18.Tervetuloa!               Valvonta rannalla klo 10-18.Tervetuloa!
529 41791 notice 2019-06-11T12:00:58.762054+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
530 41791 notice 2019-06-11T12:00:58.976828+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
531 41791 notice 2019-06-11T12:00:59.155760+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
532 41791 notice 2019-06-11T12:00:59.335303+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
533 41791 notice 2019-06-11T12:00:59.528639+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
534 41791 notice 2019-06-11T12:00:59.726014+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
535 41791 notice 2019-06-11T12:00:59.928523+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
536 41791 notice 2019-06-11T12:01:00.115673+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
537 41791 notice 2019-06-11T12:01:00.339628+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
538 41791 notice 2019-06-11T12:01:00.537380+0300   Valvonta rannalla klo 10-18.Tervetuloa!               Valvonta rannalla klo 10-18.Tervetuloa!
539 41791 notice 2019-06-11T12:01:00.739104+0300   Valvonta rannalla klo 10-18.Tervetuloa!               Valvonta rannalla klo 10-18.Tervetuloa!
540 41791 notice 2019-06-11T12:01:00.948293+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
541 41791 notice 2019-06-11T12:01:01.159730+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
542 41791 notice 2019-06-11T12:01:01.372240+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
543 41791 notice 2019-06-11T12:01:01.591963+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
544 41791 notice 2019-06-11T12:01:01.807979+0300   Valvonta rannalla klo 10-18.Tervetuloa!               Valvonta rannalla klo 10-18.Tervetuloa!
545 41791 notice 2019-06-11T12:01:02.016245+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
546 41791 notice 2019-06-11T12:01:05.497333+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
547 41791 notice 2019-06-11T12:43:46.030684+0300   Valvonta rannalla klo 10-18.Tervetuloa!               Valvonta rannalla klo 10-18.Tervetuloa!
548 41791 notice 2019-06-11T12:43:57.419473+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
551 41791 notice 2019-06-11T12:44:43.609118+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
552 41791 notice 2019-06-11T12:55:07.621609+0300   Valvonta rannalla klo 10-18.Tervetuloa!                
558 39815 notice 2019-06-11T13:55:04.238399+0300   Vesi 22°C                
563 40258 notice 2019-06-11T16:54:41.556321+0300   Valvonta rannalla klo 10-20               Valvonta rannalla klo 10-20
564 40258 notice 2019-06-11T16:54:48.994385+0300   Valvonta rannalla klo 10-20               Valvonta rannalla klo 10-20
571 39815 notice 2019-06-11T18:08:23.283133+0300   Vesi 22°C                
580 39693 notice 2019-06-12T10:11:49.501941+0300   Veden lämpötila 18ºC.               Veden lämpötila 18ºC.
585 40559 notice 2019-06-12T10:20:33.968764+0300   18 astetta merivesi                
594 40142 notice 2019-06-12T10:48:07.814743+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.                
597 40098 notice 2019-06-12T10:52:48.030271+0300   Uimaranta auki. Rannalla valvoja paikalla 3.6.-10.8.2019 saakka klo 10-18. Ranta hyvässä kunnossa.                
600 39815 notice 2019-06-12T11:38:15.940768+0300   Vesi 22°C                
601 39815 notice 2019-06-12T11:38:36.867384+0300   Vesi 19°C                
602 39815 notice 2019-06-12T11:38:39.391386+0300   Vesi 19°C                
611 39693 notice 2019-06-12T14:12:30.669916+0300   Veden lämpötila 19ºC.                
614 39815 notice 2019-06-12T14:29:09.152644+0300   Vesi 20°C                
615 39815 notice 2019-06-12T14:29:16.248553+0300   Vesi 20°C                
616 39815 notice 2019-06-12T14:29:24.895118+0300   Vesi 20°C                
619 39693 notice 2019-06-12T17:47:27.292592+0300   Veden lämpötila 19ºC.                
624 39815 notice 2019-06-12T18:06:30.742176+0300   Vesi 20°C                
625 39815 notice 2019-06-12T18:06:35.065574+0300   Vesi 20°C                
626 39815 notice 2019-06-12T18:06:36.776035+0300   Vesi 20°C                
632 39713 notice 2019-06-13T07:47:45.024184+0300                    
633 39713 notice 2019-06-13T07:48:24.793182+0300   Loistava                
646 40559 notice 2019-06-13T10:02:12.863732+0300   15 astetta merivesi                
649 39693 notice 2019-06-13T10:05:35.385699+0300   Veden lämpötila 17ºC.                
650 39693 notice 2019-06-13T10:05:48.204703+0300   Veden lämpötila 17ºC.                
653 39322 notice 2019-06-13T10:08:30.271759+0300   Valvontaa rannalla klo 8-20 joka päivä 11.8 saakka, tervetuloa!                
666 39815 notice 2019-06-13T10:50:29.819656+0300   Vesi n.17°C                
667 39815 notice 2019-06-13T10:50:33.186718+0300   Vesi n.17°C                
668 39815 notice 2019-06-13T10:50:33.835810+0300   Vesi n.17°C                
683 39693 notice 2019-06-13T14:06:31.000667+0300   Veden lämpötila 16ºC.                
684 39693 notice 2019-06-13T14:06:36.833511+0300   Veden lämpötila 16ºC.                
729 39693 notice 2019-06-14T10:25:30.945301+0300   Veden lämpötila 16ºC.                
730 39693 notice 2019-06-14T10:25:34.593999+0300   Veden lämpötila 16ºC.                
733 40559 notice 2019-06-14T10:30:12.299220+0300   15 astetta merivesi                
738 39815 notice 2019-06-14T13:50:10.000255+0300   Vesi n.17°C                
739 39815 notice 2019-06-14T13:50:17.065930+0300   Vesi n.17°C                
742 39693 notice 2019-06-14T14:07:57.720763+0300   Veden lämpötila 16ºC.                
748 39815 notice 2019-06-14T17:58:23.413294+0300   Vesi n.17°C                
751 39693 notice 2019-06-14T18:02:17.159506+0300   Veden lämpötila 16ºC.                
755 39815 notice 2019-06-15T10:01:43.662229+0300   Vesi n.17°C                
763 40559 notice 2019-06-15T10:11:36.052586+0300   14 astetta merivesi               14 astetta merivesi
770 39693 notice 2019-06-15T10:31:11.344561+0300   Veden lämpötila 16ºC.               Veden lämpötila 16ºC.
771 39693 notice 2019-06-15T10:31:14.677922+0300   Veden lämpötila 16ºC.                
774 40258 notice 2019-06-15T10:52:34.908360+0300   Valvonta rannalla klo 10-20                

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