observation
51,120 rows sorted by name_en
This data as json, CSV (advanced)
value ✖
id | unit | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en ▼ | value | quality | value_en |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
475 | 40142 | notice | 2019-06-11T10:06:41.843808+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. | 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. | ||||||||
482 | 40559 | notice | 2019-06-11T10:15:03.549517+0300 | 18 astetta merivesi | 18 astetta merivesi | ||||||||
485 | 39693 | notice | 2019-06-11T10:21:15.737875+0300 | Veden lämpötila 20ºC. | |||||||||
491 | 41601 | notice | 2019-06-11T10:55:33.865293+0300 | Puh. 0504013590 /Sisäpukukopit suljetaan 1730 /Ulkosuihku, - pukukoppi ja bajamaja käytössä kellon ympäri // Indoors changing rooms close at 1730 / Outdoors shower and toilet open all day | |||||||||
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! | ||||||||
501 | 41791 | notice | 2019-06-11T11:59:50.961295+0300 | ||||||||||
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 | |||||||||
629 | 39527 | notice | 2019-06-12T19:06:10.261046+0300 | ||||||||||
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 |
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 );