observation

818 rows where name_en = "15-17°C" sorted by unit

✎ View and edit SQL

This data as json, CSV (advanced)

name_en ✖

  • 15-17°C · 818 ✖
id unit ▼ property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
9017 39267 swimming_water_temperature 2020-06-10T15:00:34.668854+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8977 39289 swimming_water_temperature 2020-06-10T10:03:16.609252+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  
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  
2851 39322 swimming_water_temperature 2019-07-12T10:54:39.693633+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8620 39322 swimming_water_temperature 2020-06-04T13:31:14.148673+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8628 39322 swimming_water_temperature 2020-06-04T15:04:16.462957+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8641 39322 swimming_water_temperature 2020-06-04T19:25:53.526395+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8643 39322 swimming_water_temperature 2020-06-05T08:30:24.311934+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8700 39322 swimming_water_temperature 2020-06-05T14:21:19.419564+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8770 39322 swimming_water_temperature 2020-06-06T18:13:49.822326+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8791 39322 swimming_water_temperature 2020-06-07T10:09:30.879139+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8815 39322 swimming_water_temperature 2020-06-07T13:53:20.990444+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8824 39322 swimming_water_temperature 2020-06-07T14:40:34.451203+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8830 39322 swimming_water_temperature 2020-06-07T17:51:53.973956+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8860 39322 swimming_water_temperature 2020-06-08T10:05:19.046407+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8890 39322 swimming_water_temperature 2020-06-08T13:59:39.039336+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8897 39322 swimming_water_temperature 2020-06-08T17:51:47.771732+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8922 39322 swimming_water_temperature 2020-06-09T10:09:30.223236+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8938 39322 swimming_water_temperature 2020-06-09T13:54:35.966002+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8942 39322 swimming_water_temperature 2020-06-09T14:56:14.249413+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8950 39322 swimming_water_temperature 2020-06-09T18:00:41.765446+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
9015 39322 swimming_water_temperature 2020-06-10T14:44:12.913061+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
9091 39322 swimming_water_temperature 2020-06-11T10:08:00.576112+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  
6005 39412 swimming_water_temperature 2019-09-13T10:18:10.894639+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
17564 39412 swimming_water_temperature 2020-09-07T10:11:53.300729+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
17566 39412 swimming_water_temperature 2020-09-07T10:11:59.368806+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  
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  
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  
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  
1401 39527 swimming_water_temperature 2019-06-24T10:42:44.270153+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
3183 39527 swimming_water_temperature 2019-07-17T08:11:28.305350+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8988 39527 swimming_water_temperature 2020-06-10T10:06:27.573220+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
9033 39527 swimming_water_temperature 2020-06-11T08:05:32.768200+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
9214 39527 swimming_water_temperature 2020-06-13T09:38:51.100049+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
9263 39527 swimming_water_temperature 2020-06-13T15:11:43.842346+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
9304 39527 swimming_water_temperature 2020-06-14T10:32:16.868750+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
9366 39527 swimming_water_temperature 2020-06-15T09:39:48.496684+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
10844 39527 swimming_water_temperature 2020-07-05T08:07:30.392823+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11033 39527 swimming_water_temperature 2020-07-08T06:55:26.499101+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11130 39527 swimming_water_temperature 2020-07-09T11:02:12.761723+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11249 39527 swimming_water_temperature 2020-07-11T08:12:49.233779+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11398 39527 swimming_water_temperature 2020-07-13T12:54:09.522205+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11430 39527 swimming_water_temperature 2020-07-14T09:13:26.610192+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11518 39527 swimming_water_temperature 2020-07-15T09:25:55.391464+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11648 39527 swimming_water_temperature 2020-07-16T11:06:51.354607+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12628 39527 swimming_water_temperature 2020-07-29T09:27:50.576197+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12976 39527 swimming_water_temperature 2020-08-02T12:12:06.122823+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13077 39527 swimming_water_temperature 2020-08-03T13:16:38.970822+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13154 39527 swimming_water_temperature 2020-08-04T11:40:16.904766+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13182 39527 swimming_water_temperature 2020-08-05T08:31:50.713597+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13334 39527 swimming_water_temperature 2020-08-06T13:57:00.591590+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13347 39527 swimming_water_temperature 2020-08-07T08:16:54.244037+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13427 39527 swimming_water_temperature 2020-08-08T08:20:32.645453+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13564 39527 swimming_water_temperature 2020-08-10T11:50:03.034109+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13814 39527 swimming_water_temperature 2020-08-15T15:32:40.700477+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  
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  
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  
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  
1450 39568 swimming_water_temperature 2019-06-24T18:49:31.382489+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1451 39568 swimming_water_temperature 2019-06-24T19:39:35.053265+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1530 39568 swimming_water_temperature 2019-06-25T15:34:41.046014+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1638 39568 swimming_water_temperature 2019-06-27T13:16:52.191071+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
2950 39568 swimming_water_temperature 2019-07-14T09:47:46.827941+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
3024 39568 swimming_water_temperature 2019-07-15T08:31:58.967274+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
3077 39568 swimming_water_temperature 2019-07-15T11:17:23.058273+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
3166 39568 swimming_water_temperature 2019-07-16T16:17:32.007967+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
3212 39568 swimming_water_temperature 2019-07-17T10:10:39.884979+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8739 39568 swimming_water_temperature 2020-06-06T12:22:02.022553+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8804 39568 swimming_water_temperature 2020-06-07T10:51:17.302109+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8851 39568 swimming_water_temperature 2020-06-08T09:59:44.659716+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8956 39568 swimming_water_temperature 2020-06-10T08:07:43.843765+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
9149 39568 swimming_water_temperature 2020-06-12T09:10:49.602184+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
9247 39568 swimming_water_temperature 2020-06-13T11:06:23.990869+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
9354 39568 swimming_water_temperature 2020-06-15T08:08:33.230367+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
9394 39568 swimming_water_temperature 2020-06-15T10:49:36.497532+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11080 39568 swimming_water_temperature 2020-07-08T11:40:10.123945+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11128 39568 swimming_water_temperature 2020-07-09T10:32:14.113865+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11161 39568 swimming_water_temperature 2020-07-10T08:38:44.960078+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11323 39568 swimming_water_temperature 2020-07-12T12:54:33.276774+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11350 39568 swimming_water_temperature 2020-07-13T09:37:55.590085+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11427 39568 swimming_water_temperature 2020-07-14T08:07:34.011991+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11584 39568 swimming_water_temperature 2020-07-15T11:20:36.129007+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11685 39568 swimming_water_temperature 2020-07-17T08:32:27.517351+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12414 39568 swimming_water_temperature 2020-07-27T08:16:42.917557+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12522 39568 swimming_water_temperature 2020-07-28T08:27:39.869581+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12680 39568 swimming_water_temperature 2020-07-29T15:40:33.047969+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12843 39568 swimming_water_temperature 2020-08-01T08:12:56.363232+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12905 39568 swimming_water_temperature 2020-08-02T08:56:06.183510+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13039 39568 swimming_water_temperature 2020-08-03T10:20:09.545292+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13152 39568 swimming_water_temperature 2020-08-04T11:39:39.565683+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13368 39568 swimming_water_temperature 2020-08-07T09:09:59.152804+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13685 39568 swimming_water_temperature 2020-08-13T08:25:17.526176+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1750 39583 swimming_water_temperature 2019-06-28T12:08:02.517964+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1760 39583 swimming_water_temperature 2019-06-28T14:20:18.204630+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
);