observation
818 rows where name_sv = "15-17°C"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 );