observation

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

✎ View and edit SQL

This data as json, CSV (advanced)

name_fi ✖

  • 15-17°C · 793 ✖
id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
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  
1000 40950 swimming_water_temperature 2019-06-18T13:31:03.564720+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1009 39568 swimming_water_temperature 2019-06-18T14:07:06.253777+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1015 52959 swimming_water_temperature 2019-06-18T15:39:09.272717+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1018 52959 swimming_water_temperature 2019-06-18T17:43:59.085560+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1023 39568 swimming_water_temperature 2019-06-18T18:05:17.763908+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1032 39568 swimming_water_temperature 2019-06-19T09:49:50.906020+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1046 39527 swimming_water_temperature 2019-06-19T10:24:54.041705+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1048 40802 swimming_water_temperature 2019-06-19T10:43:49.796571+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1050 52959 swimming_water_temperature 2019-06-19T10:52:59.683937+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1054 39902 swimming_water_temperature 2019-06-19T10:58:55.489579+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1056 39875 swimming_water_temperature 2019-06-19T10:59:21.634110+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1060 40950 swimming_water_temperature 2019-06-19T11:22:33.245881+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1064 40559 swimming_water_temperature 2019-06-19T12:15:44.263082+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1067 39823 swimming_water_temperature 2019-06-19T12:41:47.568465+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1070 53461 swimming_water_temperature 2019-06-19T13:09:50.536410+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1073 39606 swimming_water_temperature 2019-06-19T13:48:50.963802+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1075 39412 swimming_water_temperature 2019-06-19T13:51:02.392224+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1151 40150 swimming_water_temperature 2019-06-20T10:46:41.164819+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1153 40258 swimming_water_temperature 2019-06-20T10:58:31.386420+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1157 39527 swimming_water_temperature 2019-06-20T11:13:39.685236+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1242 40258 swimming_water_temperature 2019-06-21T12:10:42.990869+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1263 40150 swimming_water_temperature 2019-06-21T12:54:55.978481+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1292 40150 swimming_water_temperature 2019-06-22T12:17:17.840012+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1294 40258 swimming_water_temperature 2019-06-22T12:27:00.776515+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1317 40950 swimming_water_temperature 2019-06-23T10:55:25.298137+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
);