observation

818 rows where name_sv = "15-17°C"

✎ 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
50 40258 swimming_water_temperature 2019-06-03T14:59:27.503232+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
65 40386 swimming_water_temperature 2019-06-04T17:51:04.266278+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
70 40157 swimming_water_temperature 2019-06-04T17:51:05.085267+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
79 41960 swimming_water_temperature 2019-06-04T17:51:06.514230+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
88 41791 swimming_water_temperature 2019-06-05T10:02:48.653427+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
91 41791 swimming_water_temperature 2019-06-05T10:03:11.627900+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
93 41791 swimming_water_temperature 2019-06-05T10:03:29.593551+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
94 41791 swimming_water_temperature 2019-06-05T10:05:42.075508+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
95 41791 swimming_water_temperature 2019-06-05T10:05:51.578180+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
96 41791 swimming_water_temperature 2019-06-05T10:06:52.817594+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
99 41791 swimming_water_temperature 2019-06-05T10:07:07.929682+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
100 41791 swimming_water_temperature 2019-06-05T10:10:24.986235+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
101 41791 swimming_water_temperature 2019-06-05T10:12:19.549239+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
102 41791 swimming_water_temperature 2019-06-05T10:22:24.463276+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
103 41960 swimming_water_temperature 2019-06-05T10:38:12.282812+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
114 41791 swimming_water_temperature 2019-06-05T10:58:48.364030+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
115 40157 swimming_water_temperature 2019-06-05T11:00:53.385560+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
117 41791 swimming_water_temperature 2019-06-05T11:10:49.786995+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
118 41791 swimming_water_temperature 2019-06-05T11:12:13.132939+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
120 41791 swimming_water_temperature 2019-06-05T11:12:34.375472+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
122 40559 swimming_water_temperature 2019-06-05T15:36:12.236080+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
127 40142 swimming_water_temperature 2019-06-05T18:40:57.305007+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
128 41960 swimming_water_temperature 2019-06-06T10:01:22.538355+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
133 40142 swimming_water_temperature 2019-06-06T10:18:07.863798+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
142 39568 swimming_water_temperature 2019-06-06T10:43:25.340222+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
146 40950 swimming_water_temperature 2019-06-06T10:43:25.862374+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
149 40950 swimming_water_temperature 2019-06-06T10:43:26.250756+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
150 41601 swimming_water_temperature 2019-06-06T11:02:33.045041+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
437 40798 swimming_water_temperature 2019-06-11T07:36:30.314633+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
438 40798 swimming_water_temperature 2019-06-11T07:36:37.529518+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
440 40677 swimming_water_temperature 2019-06-11T07:36:52.756253+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
442 40020 swimming_water_temperature 2019-06-11T07:36:59.454932+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
444 39910 swimming_water_temperature 2019-06-11T07:37:06.926794+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
448 40356 swimming_water_temperature 2019-06-11T07:38:15.879350+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
450 40386 swimming_water_temperature 2019-06-11T07:38:45.000109+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
469 40802 swimming_water_temperature 2019-06-11T10:05:21.394543+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
805 40798 swimming_water_temperature 2019-06-16T08:24:29.349014+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
807 39910 swimming_water_temperature 2019-06-16T08:24:50.037289+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
813 39693 swimming_water_temperature 2019-06-16T08:25:44.831783+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
815 40020 swimming_water_temperature 2019-06-16T08:26:08.636211+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
817 40993 swimming_water_temperature 2019-06-16T08:26:23.930829+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
819 40677 swimming_water_temperature 2019-06-16T08:26:33.976465+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
836 40150 swimming_water_temperature 2019-06-16T10:12:17.550830+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
841 40950 swimming_water_temperature 2019-06-16T10:14:01.953509+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
843 41791 swimming_water_temperature 2019-06-16T10:20:02.401592+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
847 39693 swimming_water_temperature 2019-06-16T10:24:25.497786+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
850 40559 swimming_water_temperature 2019-06-16T10:32:32.979167+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
856 40258 swimming_water_temperature 2019-06-16T12:13:03.661920+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
859 40142 swimming_water_temperature 2019-06-16T12:38:41.204100+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
860 40142 swimming_water_temperature 2019-06-16T13:38:14.864282+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
894 39568 swimming_water_temperature 2019-06-17T08:51:03.097139+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
909 40802 swimming_water_temperature 2019-06-17T10:16:50.605572+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
915 40559 swimming_water_temperature 2019-06-17T10:52:17.310522+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
920 39527 swimming_water_temperature 2019-06-17T11:16:55.579731+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
923 40142 swimming_water_temperature 2019-06-17T13:05:30.983059+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
924 40142 swimming_water_temperature 2019-06-17T13:05:41.252238+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
940 40950 swimming_water_temperature 2019-06-17T15:02:36.006791+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
956 41907 swimming_water_temperature 2019-06-18T08:41:25.194106+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
958 40798 swimming_water_temperature 2019-06-18T08:41:33.977426+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
960 39910 swimming_water_temperature 2019-06-18T08:41:41.889759+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
964 40098 swimming_water_temperature 2019-06-18T08:48:16.650619+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
994 40802 swimming_water_temperature 2019-06-18T11:03:43.722426+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
996 52959 swimming_water_temperature 2019-06-18T11:39:35.170786+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
);