observation

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

✎ View and edit SQL

This data as json, CSV (advanced)

name_fi ✖

  • 19-21°C · 1,146 ✖
id unit ▼ property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
1504 39322 swimming_water_temperature 2019-06-25T14:08:27.238526+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1506 39322 swimming_water_temperature 2019-06-25T14:10:38.668208+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1539 39322 swimming_water_temperature 2019-06-25T18:03:54.393386+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1543 39322 swimming_water_temperature 2019-06-26T09:55:52.946086+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1572 39322 swimming_water_temperature 2019-06-26T13:52:23.640616+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1627 39322 swimming_water_temperature 2019-06-27T10:35:07.174471+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1704 39322 swimming_water_temperature 2019-06-27T16:24:44.235551+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1712 39322 swimming_water_temperature 2019-06-27T18:21:51.894802+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1713 39322 swimming_water_temperature 2019-06-27T18:21:55.205481+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1720 39322 swimming_water_temperature 2019-06-28T10:00:55.800363+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1754 39322 swimming_water_temperature 2019-06-28T12:28:47.072898+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1763 39322 swimming_water_temperature 2019-06-28T14:21:29.139695+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1777 39322 swimming_water_temperature 2019-06-28T17:51:43.603562+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1805 39322 swimming_water_temperature 2019-06-29T10:19:52.417724+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1837 39322 swimming_water_temperature 2019-06-29T14:03:50.101435+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1850 39322 swimming_water_temperature 2019-06-29T18:21:55.418043+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1858 39322 swimming_water_temperature 2019-06-30T09:56:38.006919+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1905 39322 swimming_water_temperature 2019-06-30T14:00:06.736697+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1925 39322 swimming_water_temperature 2019-06-30T17:51:57.575802+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1962 39322 swimming_water_temperature 2019-07-01T10:04:03.836462+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
2011 39322 swimming_water_temperature 2019-07-01T14:00:51.653037+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
2042 39322 swimming_water_temperature 2019-07-01T18:09:18.858747+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
2148 39322 swimming_water_temperature 2019-07-03T17:49:05.366560+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
2481 39322 swimming_water_temperature 2019-07-07T14:23:27.285113+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
2483 39322 swimming_water_temperature 2019-07-07T17:38:32.683395+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
2727 39322 swimming_water_temperature 2019-07-10T17:47:02.480257+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
2996 39322 swimming_water_temperature 2019-07-14T13:56:11.819503+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3020 39322 swimming_water_temperature 2019-07-14T17:58:01.225566+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3078 39322 swimming_water_temperature 2019-07-15T11:25:25.566206+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3101 39322 swimming_water_temperature 2019-07-15T15:04:01.169011+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3110 39322 swimming_water_temperature 2019-07-15T18:04:46.925357+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3300 39322 swimming_water_temperature 2019-07-18T10:08:17.721838+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3472 39322 swimming_water_temperature 2019-07-19T14:00:47.097157+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3522 39322 swimming_water_temperature 2019-07-19T17:55:44.698105+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3556 39322 swimming_water_temperature 2019-07-20T10:27:37.166248+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3609 39322 swimming_water_temperature 2019-07-20T17:48:23.068771+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3638 39322 swimming_water_temperature 2019-07-21T10:18:55.196439+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3674 39322 swimming_water_temperature 2019-07-21T13:59:52.377060+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3804 39322 swimming_water_temperature 2019-07-22T14:11:03.444364+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4731 39322 swimming_water_temperature 2019-07-30T13:57:05.241870+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4752 39322 swimming_water_temperature 2019-07-30T18:32:41.257114+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4799 39322 swimming_water_temperature 2019-07-31T11:00:44.968821+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4858 39322 swimming_water_temperature 2019-07-31T18:04:34.213402+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4962 39322 swimming_water_temperature 2019-08-01T18:04:25.692347+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
4980 39322 swimming_water_temperature 2019-08-02T09:57:34.252873+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
5071 39322 swimming_water_temperature 2019-08-02T18:34:27.051406+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
5126 39322 swimming_water_temperature 2019-08-03T13:22:53.129198+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
5131 39322 swimming_water_temperature 2019-08-03T14:20:57.081224+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
5147 39322 swimming_water_temperature 2019-08-03T17:53:02.569756+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
5294 39322 swimming_water_temperature 2019-08-05T10:41:22.116297+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
5390 39322 swimming_water_temperature 2019-08-06T10:55:23.017761+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
5409 39322 swimming_water_temperature 2019-08-06T14:00:26.540259+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
5434 39322 swimming_water_temperature 2019-08-06T19:02:33.824640+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
5479 39322 swimming_water_temperature 2019-08-07T14:29:26.794653+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
5579 39322 swimming_water_temperature 2019-08-08T14:11:08.354585+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
5614 39322 swimming_water_temperature 2019-08-08T18:53:37.158742+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9027 39322 swimming_water_temperature 2020-06-10T17:52:56.117906+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9119 39322 swimming_water_temperature 2020-06-11T14:42:31.121996+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9208 39322 swimming_water_temperature 2020-06-12T18:04:07.114326+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9249 39322 swimming_water_temperature 2020-06-13T11:15:18.069847+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9258 39322 swimming_water_temperature 2020-06-13T14:15:54.117909+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9317 39322 swimming_water_temperature 2020-06-14T13:46:20.258625+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9370 39322 swimming_water_temperature 2020-06-15T09:54:18.683401+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
9570 39322 swimming_water_temperature 2020-06-17T10:11:10.973520+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
10648 39322 swimming_water_temperature 2020-07-02T10:01:13.252197+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
10693 39322 swimming_water_temperature 2020-07-02T18:28:24.192776+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
10761 39322 swimming_water_temperature 2020-07-03T10:17:13.496001+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
10772 39322 swimming_water_temperature 2020-07-03T13:54:18.672521+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
10784 39322 swimming_water_temperature 2020-07-03T18:12:40.201241+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
10789 39322 swimming_water_temperature 2020-07-04T09:47:36.489138+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
10834 39322 swimming_water_temperature 2020-07-04T14:03:19.995006+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
10859 39322 swimming_water_temperature 2020-07-05T10:02:29.655483+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
10888 39322 swimming_water_temperature 2020-07-05T13:52:18.423417+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
11090 39322 swimming_water_temperature 2020-07-08T14:20:02.687716+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
11149 39322 swimming_water_temperature 2020-07-09T17:54:52.897526+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
11612 39322 swimming_water_temperature 2020-07-15T18:04:55.967946+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
11661 39322 swimming_water_temperature 2020-07-16T13:58:39.947919+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
11708 39322 swimming_water_temperature 2020-07-17T10:16:11.147427+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
11734 39322 swimming_water_temperature 2020-07-17T14:26:42.855391+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
11780 39322 swimming_water_temperature 2020-07-18T10:17:21.214985+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
11815 39322 swimming_water_temperature 2020-07-18T18:04:33.364894+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
11968 39322 swimming_water_temperature 2020-07-21T10:03:51.830672+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12093 39322 swimming_water_temperature 2020-07-22T10:01:26.150074+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12118 39322 swimming_water_temperature 2020-07-22T14:16:05.177974+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12169 39322 swimming_water_temperature 2020-07-23T10:07:50.862088+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12214 39322 swimming_water_temperature 2020-07-23T14:13:18.798922+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12223 39322 swimming_water_temperature 2020-07-23T19:06:12.098228+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12264 39322 swimming_water_temperature 2020-07-24T09:52:44.175615+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12301 39322 swimming_water_temperature 2020-07-24T15:07:28.702029+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12351 39322 swimming_water_temperature 2020-07-25T14:39:45.456624+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12353 39322 swimming_water_temperature 2020-07-25T17:41:24.397246+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12399 39322 swimming_water_temperature 2020-07-26T14:26:25.738452+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12498 39322 swimming_water_temperature 2020-07-27T14:05:39.275126+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12565 39322 swimming_water_temperature 2020-07-28T10:55:34.356385+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12596 39322 swimming_water_temperature 2020-07-28T14:00:07.511005+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12603 39322 swimming_water_temperature 2020-07-28T19:17:20.014316+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12651 39322 swimming_water_temperature 2020-07-29T10:25:29.545996+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12671 39322 swimming_water_temperature 2020-07-29T13:53:22.187422+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12687 39322 swimming_water_temperature 2020-07-29T17:59:21.294612+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12728 39322 swimming_water_temperature 2020-07-30T10:15:37.979977+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
);