observation

4,968 rows where primary = 0

✎ View and edit SQL

This data as json, CSV (advanced)

primary ✖

  • 0 · 4,768 ✖
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  

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