observation
4,968 rows where primary = 0
This data as json, CSV (advanced)
name_sv ✖
- 17-19°C 1,212
- 19-21°C 1,187
- 15-17°C 770
- 21-23°C 717
- under 15°C 482
- Iståndsatt 220
- över 23°C 180
id ▼ | unit | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
574 | 40802 | swimming_water_temperature | 2019-06-12T10:06:27.423087+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
576 | 41960 | swimming_water_temperature | 2019-06-12T10:08:21.924216+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
578 | 39693 | swimming_water_temperature | 2019-06-12T10:11:33.149222+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
581 | 40157 | swimming_water_temperature | 2019-06-12T10:12:21.834732+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
583 | 40559 | swimming_water_temperature | 2019-06-12T10:20:27.188308+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
586 | 39267 | swimming_water_temperature | 2019-06-12T10:22:49.596387+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
587 | 41791 | swimming_water_temperature | 2019-06-12T10:33:08.928678+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
588 | 40950 | swimming_water_temperature | 2019-06-12T10:42:01.652816+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
590 | 39267 | swimming_water_temperature | 2019-06-12T10:45:40.373126+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
592 | 40142 | swimming_water_temperature | 2019-06-12T10:47:52.504313+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
595 | 40098 | swimming_water_temperature | 2019-06-12T10:52:11.718054+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
598 | 39815 | swimming_water_temperature | 2019-06-12T11:37:58.845010+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
603 | 41601 | swimming_water_temperature | 2019-06-12T12:38:41.997550+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
605 | 39322 | swimming_water_temperature | 2019-06-12T14:00:57.182507+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
607 | 39267 | swimming_water_temperature | 2019-06-12T14:02:38.897497+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
609 | 39693 | swimming_water_temperature | 2019-06-12T14:12:17.628770+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
612 | 39815 | swimming_water_temperature | 2019-06-12T14:28:50.432329+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
617 | 39693 | swimming_water_temperature | 2019-06-12T17:47:21.157315+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
620 | 39322 | swimming_water_temperature | 2019-06-12T17:49:09.441105+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
622 | 39815 | swimming_water_temperature | 2019-06-12T18:06:25.687549+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
627 | 39527 | swimming_water_temperature | 2019-06-12T19:05:49.774401+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
630 | 39713 | swimming_water_temperature | 2019-06-13T07:47:26.539932+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
634 | 39875 | swimming_water_temperature | 2019-06-13T08:05:31.801333+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
636 | 39902 | swimming_water_temperature | 2019-06-13T08:21:50.560165+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
638 | 39606 | swimming_water_temperature | 2019-06-13T08:33:01.657762+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
640 | 53461 | swimming_water_temperature | 2019-06-13T09:33:38.441460+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
642 | 39823 | swimming_water_temperature | 2019-06-13T09:47:39.492915+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
644 | 40559 | swimming_water_temperature | 2019-06-13T10:01:57.197184+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
647 | 40157 | swimming_water_temperature | 2019-06-13T10:03:22.370237+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
651 | 39322 | swimming_water_temperature | 2019-06-13T10:08:10.286362+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
654 | 39267 | swimming_water_temperature | 2019-06-13T10:08:49.115932+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
655 | 41601 | swimming_water_temperature | 2019-06-13T10:09:17.217746+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
657 | 40802 | swimming_water_temperature | 2019-06-13T10:12:31.407532+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
659 | 40098 | swimming_water_temperature | 2019-06-13T10:13:04.081492+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
660 | 40142 | swimming_water_temperature | 2019-06-13T10:26:03.251281+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
662 | 41960 | swimming_water_temperature | 2019-06-13T10:30:03.327329+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
664 | 39815 | swimming_water_temperature | 2019-06-13T10:49:54.633216+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
669 | 52959 | swimming_water_temperature | 2019-06-13T10:50:35.464669+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
671 | 40150 | swimming_water_temperature | 2019-06-13T11:20:00.617342+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
673 | 40950 | swimming_water_temperature | 2019-06-13T11:38:20.179121+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
675 | 39412 | swimming_water_temperature | 2019-06-13T12:30:07.178308+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
677 | 39368 | swimming_water_temperature | 2019-06-13T12:55:20.315406+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
679 | 52959 | swimming_water_temperature | 2019-06-13T14:04:22.286502+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
681 | 39693 | swimming_water_temperature | 2019-06-13T14:06:17.781360+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
685 | 39267 | swimming_water_temperature | 2019-06-13T15:03:53.067568+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
687 | 39568 | swimming_water_temperature | 2019-06-13T16:33:38.469330+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
689 | 39568 | swimming_water_temperature | 2019-06-13T16:33:49.353692+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
690 | 39693 | swimming_water_temperature | 2019-06-13T18:02:41.375121+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
692 | 39568 | swimming_water_temperature | 2019-06-13T18:16:53.623298+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
694 | 39815 | swimming_water_temperature | 2019-06-13T18:17:06.571420+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
695 | 39322 | swimming_water_temperature | 2019-06-13T18:42:33.276787+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
697 | 39823 | swimming_water_temperature | 2019-06-14T07:39:06.304126+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
699 | 53461 | swimming_water_temperature | 2019-06-14T07:52:56.389759+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
701 | 39606 | swimming_water_temperature | 2019-06-14T08:04:15.467615+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
703 | 39902 | swimming_water_temperature | 2019-06-14T08:14:36.810253+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
705 | 39875 | swimming_water_temperature | 2019-06-14T08:29:42.049908+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
707 | 39713 | swimming_water_temperature | 2019-06-14T08:44:33.527372+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
709 | 39322 | swimming_water_temperature | 2019-06-14T09:44:09.977393+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
711 | 39412 | swimming_water_temperature | 2019-06-14T09:53:14.083768+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
713 | 39815 | swimming_water_temperature | 2019-06-14T09:53:37.381412+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
714 | 40157 | swimming_water_temperature | 2019-06-14T09:54:28.256267+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
716 | 39322 | swimming_water_temperature | 2019-06-14T10:00:50.300444+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
718 | 41960 | swimming_water_temperature | 2019-06-14T10:02:51.919296+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
720 | 39267 | swimming_water_temperature | 2019-06-14T10:04:47.457711+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
722 | 40802 | swimming_water_temperature | 2019-06-14T10:09:20.447749+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
724 | 52959 | swimming_water_temperature | 2019-06-14T10:11:31.222608+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
726 | 40142 | swimming_water_temperature | 2019-06-14T10:14:59.703173+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
727 | 39693 | swimming_water_temperature | 2019-06-14T10:25:23.633557+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
731 | 40559 | swimming_water_temperature | 2019-06-14T10:29:57.547045+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
734 | 40150 | swimming_water_temperature | 2019-06-14T10:34:07.294329+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
736 | 41601 | swimming_water_temperature | 2019-06-14T10:42:16.250645+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
740 | 39693 | swimming_water_temperature | 2019-06-14T14:07:54.019329+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
743 | 39322 | swimming_water_temperature | 2019-06-14T14:18:25.495876+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
745 | 39267 | swimming_water_temperature | 2019-06-14T17:56:22.115728+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
747 | 39815 | swimming_water_temperature | 2019-06-14T17:58:16.937142+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
749 | 39693 | swimming_water_temperature | 2019-06-14T18:02:13.703810+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
752 | 39815 | swimming_water_temperature | 2019-06-15T10:01:39.849686+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
753 | 41960 | swimming_water_temperature | 2019-06-15T10:01:41.210720+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
757 | 39322 | swimming_water_temperature | 2019-06-15T10:02:51.692215+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
759 | 41791 | swimming_water_temperature | 2019-06-15T10:05:48.674173+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
761 | 40559 | swimming_water_temperature | 2019-06-15T10:11:25.092050+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
764 | 40150 | swimming_water_temperature | 2019-06-15T10:16:13.454535+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
766 | 39267 | swimming_water_temperature | 2019-06-15T10:23:55.291543+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
768 | 39897 | swimming_water_temperature | 2019-06-15T10:30:45.688174+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
769 | 39693 | swimming_water_temperature | 2019-06-15T10:31:01.723046+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
772 | 40258 | swimming_water_temperature | 2019-06-15T10:52:26.343555+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
775 | 40157 | swimming_water_temperature | 2019-06-15T10:54:59.045008+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
777 | 40142 | swimming_water_temperature | 2019-06-15T12:20:13.303202+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
780 | 40950 | swimming_water_temperature | 2019-06-15T13:44:04.703244+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
782 | 39815 | swimming_water_temperature | 2019-06-15T13:49:51.228836+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
785 | 39322 | swimming_water_temperature | 2019-06-15T13:56:34.538850+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
787 | 39693 | swimming_water_temperature | 2019-06-15T14:04:45.743477+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
789 | 39267 | swimming_water_temperature | 2019-06-15T15:47:49.654002+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
791 | 39527 | swimming_water_temperature | 2019-06-15T15:56:24.279647+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
794 | 39693 | swimming_water_temperature | 2019-06-15T17:59:24.200487+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
796 | 39322 | swimming_water_temperature | 2019-06-15T18:21:00.124038+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
798 | 39322 | swimming_water_temperature | 2019-06-15T18:23:35.165620+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
799 | 41031 | swimming_water_temperature | 2019-06-16T08:24:08.024679+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
801 | 41326 | swimming_water_temperature | 2019-06-16T08:24:17.094527+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
803 | 41907 | swimming_water_temperature | 2019-06-16T08:24:22.855167+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown |
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 );