observation

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

✎ 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
2754 58015 swimming_water_temperature 2019-07-11T08:47:47.778010+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
3506 58015 swimming_water_temperature 2019-07-19T16:33:11.927602+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11567 58015 swimming_water_temperature 2020-07-15T10:26:30.947714+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12069 58015 swimming_water_temperature 2020-07-22T08:28:49.685912+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13067 58015 swimming_water_temperature 2020-08-03T12:48:25.661952+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
3231 53476 swimming_water_temperature 2019-07-17T13:17:41.373843+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
3374 53476 swimming_water_temperature 2019-07-18T15:11:14.309022+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  
6001 53461 swimming_water_temperature 2019-09-13T09:37:37.719421+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8959 53461 swimming_water_temperature 2020-06-10T09:14:08.656783+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8960 53461 swimming_water_temperature 2020-06-10T09:14:24.072303+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
17525 53461 swimming_water_temperature 2020-09-07T08:19:43.434408+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
2130 52960 swimming_water_temperature 2019-07-03T12:23:19.327479+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
3233 52960 swimming_water_temperature 2019-07-17T13:18:24.663246+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
3370 52960 swimming_water_temperature 2019-07-18T15:08:51.923642+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11588 52960 swimming_water_temperature 2020-07-15T11:59:31.682119+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11935 52960 swimming_water_temperature 2020-07-20T13:10:04.278535+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12207 52960 swimming_water_temperature 2020-07-23T10:59:22.455553+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13574 52960 swimming_water_temperature 2020-08-10T14:23:06.552866+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  
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  
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  
1428 52959 swimming_water_temperature 2019-06-24T14:20:58.938333+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1434 52959 swimming_water_temperature 2019-06-24T16:18:19.614660+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1508 52959 swimming_water_temperature 2019-06-25T14:38:58.013518+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
1650 52959 swimming_water_temperature 2019-06-27T13:23:19.401753+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
2930 52959 swimming_water_temperature 2019-07-13T14:23:35.571222+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
3006 52959 swimming_water_temperature 2019-07-14T15:07:02.227967+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
3151 52959 swimming_water_temperature 2019-07-16T10:42:59.302026+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
3448 52959 swimming_water_temperature 2019-07-19T10:45:27.496328+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8885 52959 swimming_water_temperature 2020-06-08T10:33:57.963894+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
9003 52959 swimming_water_temperature 2020-06-10T10:34:21.364729+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
9108 52959 swimming_water_temperature 2020-06-11T11:06:46.748518+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11078 52959 swimming_water_temperature 2020-07-08T11:39:57.798640+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11129 52959 swimming_water_temperature 2020-07-09T10:32:58.978531+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11132 52959 swimming_water_temperature 2020-07-09T11:03:42.357178+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11157 52959 swimming_water_temperature 2020-07-09T22:59:56.407926+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11182 52959 swimming_water_temperature 2020-07-10T10:09:43.555675+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11189 52959 swimming_water_temperature 2020-07-10T10:23:51.913135+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11676 52959 swimming_water_temperature 2020-07-16T18:24:40.471562+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12561 52959 swimming_water_temperature 2020-07-28T10:20:21.711318+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12639 52959 swimming_water_temperature 2020-07-29T10:06:03.066559+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12678 52959 swimming_water_temperature 2020-07-29T14:10:53.695590+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12801 52959 swimming_water_temperature 2020-07-31T10:14:00.802888+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12948 52959 swimming_water_temperature 2020-08-02T10:13:03.584117+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13031 52959 swimming_water_temperature 2020-08-03T10:09:35.618314+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13084 52959 swimming_water_temperature 2020-08-03T14:47:31.337596+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13123 52959 swimming_water_temperature 2020-08-04T10:01:16.538338+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13241 52959 swimming_water_temperature 2020-08-05T10:59:23.037033+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13316 52959 swimming_water_temperature 2020-08-06T10:49:56.819072+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13617 52959 swimming_water_temperature 2020-08-11T11:41:10.043713+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
3235 52958 swimming_water_temperature 2019-07-17T13:18:48.777660+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
3372 52958 swimming_water_temperature 2019-07-18T15:09:35.833301+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11937 52958 swimming_water_temperature 2020-07-20T13:10:45.982138+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13576 52958 swimming_water_temperature 2020-08-10T14:24:02.628875+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
2129 50549 swimming_water_temperature 2019-07-03T12:22:22.698416+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
3365 50549 swimming_water_temperature 2019-07-18T15:06:04.221885+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11586 50549 swimming_water_temperature 2020-07-15T11:58:40.351772+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11936 50549 swimming_water_temperature 2020-07-20T13:10:22.597045+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
9019 42114 swimming_water_temperature 2020-06-10T15:03:22.047115+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  
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  
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  
2363 41960 swimming_water_temperature 2019-07-06T10:12:53.794756+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
2469 41960 swimming_water_temperature 2019-07-07T13:25:45.694241+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
2512 41960 swimming_water_temperature 2019-07-08T10:05:02.407510+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
2593 41960 swimming_water_temperature 2019-07-09T10:21:47.217398+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
2688 41960 swimming_water_temperature 2019-07-10T10:39:03.408266+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
2825 41960 swimming_water_temperature 2019-07-12T10:04:08.763370+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
2906 41960 swimming_water_temperature 2019-07-13T11:04:20.865824+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
2917 41960 swimming_water_temperature 2019-07-13T13:39:59.920708+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8548 41960 swimming_water_temperature 2020-06-03T10:43:44.640971+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8616 41960 swimming_water_temperature 2020-06-04T10:48:13.159236+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8797 41960 swimming_water_temperature 2020-06-07T10:28:35.474136+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8862 41960 swimming_water_temperature 2020-06-08T10:07:56.138039+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8925 41960 swimming_water_temperature 2020-06-09T10:24:55.283693+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
8991 41960 swimming_water_temperature 2020-06-10T10:11:05.419950+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
9401 41960 swimming_water_temperature 2020-06-15T11:20:55.763721+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
10596 41960 swimming_water_temperature 2020-07-01T10:13:12.008799+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
10650 41960 swimming_water_temperature 2020-07-02T10:02:32.318480+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11018 41960 swimming_water_temperature 2020-07-07T14:02:56.525782+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11196 41960 swimming_water_temperature 2020-07-10T11:21:22.502693+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11272 41960 swimming_water_temperature 2020-07-11T10:14:33.335103+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11525 41960 swimming_water_temperature 2020-07-15T09:56:54.967016+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11624 41960 swimming_water_temperature 2020-07-16T09:59:53.334733+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11690 41960 swimming_water_temperature 2020-07-17T09:56:36.938804+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12115 41960 swimming_water_temperature 2020-07-22T12:28:37.321338+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12197 41960 swimming_water_temperature 2020-07-23T10:50:57.824319+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12271 41960 swimming_water_temperature 2020-07-24T09:58:04.419064+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12365 41960 swimming_water_temperature 2020-07-26T09:50:54.363055+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12452 41960 swimming_water_temperature 2020-07-27T09:53:03.895394+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12708 41960 swimming_water_temperature 2020-07-30T09:49:59.924937+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12851 41960 swimming_water_temperature 2020-08-01T10:05:58.711175+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12934 41960 swimming_water_temperature 2020-08-02T10:03:12.007838+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13021 41960 swimming_water_temperature 2020-08-03T09:52:46.102854+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13140 41960 swimming_water_temperature 2020-08-04T10:11:13.011460+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13201 41960 swimming_water_temperature 2020-08-05T09:46:08.682813+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13324 41960 swimming_water_temperature 2020-08-06T11:28:19.312061+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  

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