observation

1,246 rows where name_en = "19-21°C" sorted by unit descending

✎ View and edit SQL

This data as json, CSV (advanced)

name_en ✖

  • 19-21°C · 1,246 ✖
id unit ▲ property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
4157 58015 swimming_water_temperature 2019-07-25T11:55:53.250923+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4234 58015 swimming_water_temperature 2019-07-26T08:57:12.003337+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4831 58015 swimming_water_temperature 2019-07-31T13:29:18.325621+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
10262 58015 swimming_water_temperature 2020-06-26T13:35:47.649082+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4228 53476 swimming_water_temperature 2019-07-26T08:52:20.470167+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9892 53476 swimming_water_temperature 2020-06-23T09:15:13.900569+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
896 53461 swimming_water_temperature 2019-06-17T09:16:30.001767+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1077 53461 swimming_water_temperature 2019-06-19T13:51:27.872640+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1114 53461 swimming_water_temperature 2019-06-20T09:06:24.012568+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1351 53461 swimming_water_temperature 2019-06-24T08:27:14.155427+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1664 53461 swimming_water_temperature 2019-06-27T13:28:44.860992+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1937 53461 swimming_water_temperature 2019-07-01T08:38:33.322806+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
2007 53461 swimming_water_temperature 2019-07-01T13:41:42.969503+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
2025 53461 swimming_water_temperature 2019-07-01T14:21:44.093228+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
2257 53461 swimming_water_temperature 2019-07-05T08:38:55.243198+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3048 53461 swimming_water_temperature 2019-07-15T10:16:19.387655+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3288 53461 swimming_water_temperature 2019-07-18T09:29:43.180045+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3401 53461 swimming_water_temperature 2019-07-19T09:16:00.425061+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3403 53461 swimming_water_temperature 2019-07-19T09:20:46.804019+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3743 53461 swimming_water_temperature 2019-07-22T08:17:42.935395+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3828 53461 swimming_water_temperature 2019-07-23T08:03:29.622112+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3840 53461 swimming_water_temperature 2019-07-23T09:25:24.857863+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4767 53461 swimming_water_temperature 2019-07-31T08:49:56.277932+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4867 53461 swimming_water_temperature 2019-08-01T09:35:33.874113+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4964 53461 swimming_water_temperature 2019-08-02T07:33:12.491544+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9355 53461 swimming_water_temperature 2020-06-15T08:27:03.109226+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9459 53461 swimming_water_temperature 2020-06-16T08:44:01.437568+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9538 53461 swimming_water_temperature 2020-06-17T08:33:38.754697+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9627 53461 swimming_water_temperature 2020-06-18T08:25:41.367618+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9706 53461 swimming_water_temperature 2020-06-19T07:49:06.519770+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
11045 53461 swimming_water_temperature 2020-07-08T09:48:42.243786+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12591 53461 swimming_water_temperature 2020-07-28T13:30:57.220866+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12768 53461 swimming_water_temperature 2020-07-31T08:24:27.910261+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13326 53461 swimming_water_temperature 2020-08-06T11:31:06.279062+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4224 52960 swimming_water_temperature 2019-07-26T08:50:35.950282+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3682 52959 swimming_water_temperature 2019-07-21T14:13:20.532316+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3711 52959 swimming_water_temperature 2019-07-21T20:01:09.435992+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3906 52959 swimming_water_temperature 2019-07-23T10:54:26.303465+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4000 52959 swimming_water_temperature 2019-07-24T10:23:57.743537+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4060 52959 swimming_water_temperature 2019-07-24T14:13:33.319167+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4127 52959 swimming_water_temperature 2019-07-25T10:27:17.901298+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4242 52959 swimming_water_temperature 2019-07-26T09:33:03.050237+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4307 52959 swimming_water_temperature 2019-07-26T11:22:42.214044+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4370 52959 swimming_water_temperature 2019-07-27T08:19:04.832546+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4915 52959 swimming_water_temperature 2019-08-01T12:30:02.952280+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4917 52959 swimming_water_temperature 2019-08-01T12:30:29.826828+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4995 52959 swimming_water_temperature 2019-08-02T10:14:37.536769+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
5028 52959 swimming_water_temperature 2019-08-02T14:19:26.397632+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
5113 52959 swimming_water_temperature 2019-08-03T11:04:25.433994+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
5145 52959 swimming_water_temperature 2019-08-03T17:40:14.262227+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
5707 52959 swimming_water_temperature 2019-08-10T10:17:50.976347+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
5789 52959 swimming_water_temperature 2019-08-11T10:05:22.172062+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9399 52959 swimming_water_temperature 2020-06-15T11:01:59.749327+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9516 52959 swimming_water_temperature 2020-06-16T14:06:53.223999+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9560 52959 swimming_water_temperature 2020-06-17T09:56:40.313665+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9579 52959 swimming_water_temperature 2020-06-17T10:29:21.300049+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9689 52959 swimming_water_temperature 2020-06-18T16:16:31.843829+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9871 52959 swimming_water_temperature 2020-06-22T14:35:23.160435+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9941 52959 swimming_water_temperature 2020-06-23T10:31:12.148748+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
10602 52959 swimming_water_temperature 2020-07-01T10:28:09.379891+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
10640 52959 swimming_water_temperature 2020-07-02T08:19:14.618305+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
10747 52959 swimming_water_temperature 2020-07-03T10:02:34.103373+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
10776 52959 swimming_water_temperature 2020-07-03T14:20:58.532555+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
10842 52959 swimming_water_temperature 2020-07-05T03:02:24.366672+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
11857 52959 swimming_water_temperature 2020-07-19T14:55:54.930826+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
11896 52959 swimming_water_temperature 2020-07-20T10:19:08.862055+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13445 52959 swimming_water_temperature 2020-08-08T10:07:13.024815+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13494 52959 swimming_water_temperature 2020-08-09T10:07:49.977106+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4226 52958 swimming_water_temperature 2019-07-26T08:51:23.852876+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9896 52958 swimming_water_temperature 2020-06-23T09:15:42.977318+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9894 50549 swimming_water_temperature 2020-06-23T09:15:27.585227+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4939 42114 swimming_water_temperature 2019-08-01T13:42:47.138780+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9424 42114 swimming_water_temperature 2020-06-15T13:06:07.354018+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13159 42114 swimming_water_temperature 2020-08-04T11:52:21.824526+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4155 41977 swimming_water_temperature 2019-07-25T11:54:40.331969+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4186 41977 swimming_water_temperature 2019-07-25T15:01:55.271687+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4230 41977 swimming_water_temperature 2019-07-26T08:54:19.056702+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4405 41977 swimming_water_temperature 2019-07-27T10:12:10.409132+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4585 41977 swimming_water_temperature 2019-07-29T08:47:54.425412+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4827 41977 swimming_water_temperature 2019-07-31T13:28:33.221805+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
405 41960 swimming_water_temperature 2019-06-10T10:57:42.684782+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
486 41960 swimming_water_temperature 2019-06-11T10:26:20.184265+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
576 41960 swimming_water_temperature 2019-06-12T10:08:21.924216+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
998 41960 swimming_water_temperature 2019-06-18T12:25:33.925206+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1052 41960 swimming_water_temperature 2019-06-19T10:54:37.660937+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1145 41960 swimming_water_temperature 2019-06-20T10:27:08.938367+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1304 41960 swimming_water_temperature 2019-06-23T10:09:58.917524+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1361 41960 swimming_water_temperature 2019-06-24T10:08:17.002441+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1475 41960 swimming_water_temperature 2019-06-25T10:19:42.935985+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1568 41960 swimming_water_temperature 2019-06-26T13:24:24.493879+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1608 41960 swimming_water_temperature 2019-06-27T10:02:24.688487+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1800 41960 swimming_water_temperature 2019-06-29T10:11:50.028060+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1883 41960 swimming_water_temperature 2019-06-30T10:18:48.141340+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1987 41960 swimming_water_temperature 2019-07-01T10:28:12.205621+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4801 41960 swimming_water_temperature 2019-07-31T11:19:56.351309+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4906 41960 swimming_water_temperature 2019-08-01T11:15:11.331716+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4997 41960 swimming_water_temperature 2019-08-02T10:16:43.935321+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9306 41960 swimming_water_temperature 2020-06-14T10:32:44.185311+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9752 41960 swimming_water_temperature 2020-06-20T09:58:32.351926+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9786 41960 swimming_water_temperature 2020-06-21T10:10:01.124207+0300     19-21°C   19-21°C 0 19-21°C 19-21 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
);