observation

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

✎ View and edit SQL

This data as json, CSV (advanced)

name_fi ✖

  • 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
13869 39713 swimming_water_temperature 2020-08-17T09:11:31.771240+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13861 39693 swimming_water_temperature 2020-08-16T18:01:54.056600+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13859 39322 swimming_water_temperature 2020-08-16T14:53:18.650321+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13853 39693 swimming_water_temperature 2020-08-16T13:57:59.214444+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13846 39815 swimming_water_temperature 2020-08-16T11:15:22.949399+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13844 39322 swimming_water_temperature 2020-08-16T10:31:46.597902+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13822 39815 swimming_water_temperature 2020-08-15T18:42:43.077057+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13819 39693 swimming_water_temperature 2020-08-15T18:18:42.858743+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13816 39583 swimming_water_temperature 2020-08-15T17:46:12.005510+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13813 39693 swimming_water_temperature 2020-08-15T14:13:08.899502+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13807 39583 swimming_water_temperature 2020-08-15T13:51:22.654067+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13805 39815 swimming_water_temperature 2020-08-15T13:48:39.493764+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13803 39693 swimming_water_temperature 2020-08-15T12:55:04.548964+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13796 39322 swimming_water_temperature 2020-08-15T10:35:22.380884+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13769 39583 swimming_water_temperature 2020-08-14T17:53:07.050472+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13762 39583 swimming_water_temperature 2020-08-14T13:46:11.499356+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13758 39322 swimming_water_temperature 2020-08-14T11:27:10.378148+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13731 39322 swimming_water_temperature 2020-08-13T18:58:39.993882+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13726 39322 swimming_water_temperature 2020-08-13T14:31:00.540025+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13712 39322 swimming_water_temperature 2020-08-13T10:02:57.398810+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13659 39322 swimming_water_temperature 2020-08-12T13:56:54.987149+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13634 39322 swimming_water_temperature 2020-08-12T09:56:50.857383+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13627 39583 swimming_water_temperature 2020-08-11T15:05:28.234604+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13625 39322 swimming_water_temperature 2020-08-11T14:16:12.084130+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13619 39322 swimming_water_temperature 2020-08-11T11:56:45.959411+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13584 39322 swimming_water_temperature 2020-08-10T17:53:09.403632+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13582 39583 swimming_water_temperature 2020-08-10T17:43:58.418065+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13579 39693 swimming_water_temperature 2020-08-10T15:15:52.633703+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13568 39583 swimming_water_temperature 2020-08-10T13:57:19.332274+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13566 39815 swimming_water_temperature 2020-08-10T12:18:37.890647+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13561 39322 swimming_water_temperature 2020-08-10T11:14:46.745764+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13548 39693 swimming_water_temperature 2020-08-10T10:49:02.383881+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13534 39583 swimming_water_temperature 2020-08-10T10:07:41.921718+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13532 39322 swimming_water_temperature 2020-08-09T17:56:46.753506+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13516 39527 swimming_water_temperature 2020-08-09T12:31:26.082193+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13514 40993 swimming_water_temperature 2020-08-09T11:55:05.710341+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13506 40142 swimming_water_temperature 2020-08-09T10:56:53.131921+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13499 39583 swimming_water_temperature 2020-08-09T10:33:13.420224+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  
13492 40386 swimming_water_temperature 2020-08-09T10:07:27.309910+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13490 41791 swimming_water_temperature 2020-08-09T10:06:33.402783+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13484 40559 swimming_water_temperature 2020-08-09T09:55:05.986446+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13465 39693 swimming_water_temperature 2020-08-08T13:48:48.980868+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13460 39322 swimming_water_temperature 2020-08-08T10:57:49.243369+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13454 41791 swimming_water_temperature 2020-08-08T10:18:18.366469+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13449 39583 swimming_water_temperature 2020-08-08T10:10:40.247901+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13448 40559 swimming_water_temperature 2020-08-08T10:08:27.505133+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  
13443 40386 swimming_water_temperature 2020-08-08T10:01:30.356401+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13441 41601 swimming_water_temperature 2020-08-08T10:01:02.259139+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13438 39693 swimming_water_temperature 2020-08-08T09:57:39.713017+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13430 40157 swimming_water_temperature 2020-08-08T09:43:01.930763+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13429 39815 swimming_water_temperature 2020-08-08T08:57:04.548492+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13420 39583 swimming_water_temperature 2020-08-07T17:49:07.229286+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13416 39583 swimming_water_temperature 2020-08-07T14:24:12.114735+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13412 39322 swimming_water_temperature 2020-08-07T14:09:14.175007+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13397 40157 swimming_water_temperature 2020-08-07T10:17:20.879683+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13381 39322 swimming_water_temperature 2020-08-07T09:58:00.010398+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13378 41601 swimming_water_temperature 2020-08-07T09:53:35.132268+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13338 39322 swimming_water_temperature 2020-08-06T14:34:56.477750+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13330 39875 swimming_water_temperature 2020-08-06T11:32:45.650998+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13329 39713 swimming_water_temperature 2020-08-06T11:32:19.805419+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13328 39902 swimming_water_temperature 2020-08-06T11:31:54.565005+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  
13325 39823 swimming_water_temperature 2020-08-06T11:30:37.929084+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13301 39322 swimming_water_temperature 2020-08-06T10:11:24.674750+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13297 40157 swimming_water_temperature 2020-08-06T10:06:32.227589+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13263 39322 swimming_water_temperature 2020-08-05T18:06:16.490942+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13254 39322 swimming_water_temperature 2020-08-05T14:26:25.159779+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13213 39322 swimming_water_temperature 2020-08-05T10:01:33.720037+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13178 39815 swimming_water_temperature 2020-08-04T19:42:53.419578+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13176 39322 swimming_water_temperature 2020-08-04T18:02:48.664452+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13173 39815 swimming_water_temperature 2020-08-04T16:23:35.615560+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13169 39815 swimming_water_temperature 2020-08-04T14:35:44.821110+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13167 39322 swimming_water_temperature 2020-08-04T13:57:07.841177+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  
13150 39322 swimming_water_temperature 2020-08-04T10:51:23.271701+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13129 39815 swimming_water_temperature 2020-08-04T10:03:15.625077+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13127 41601 swimming_water_temperature 2020-08-04T10:02:53.225265+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13116 39815 swimming_water_temperature 2020-08-04T08:14:56.549889+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13094 39815 swimming_water_temperature 2020-08-03T19:31:14.020156+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13092 39322 swimming_water_temperature 2020-08-03T18:52:13.396800+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13088 39322 swimming_water_temperature 2020-08-03T15:58:59.809208+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13081 39815 swimming_water_temperature 2020-08-03T14:00:47.754037+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13045 39322 swimming_water_temperature 2020-08-03T10:55:37.996990+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13037 41601 swimming_water_temperature 2020-08-03T10:17:09.924368+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12999 39322 swimming_water_temperature 2020-08-02T18:41:18.112632+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12994 39815 swimming_water_temperature 2020-08-02T17:52:56.751433+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12983 39322 swimming_water_temperature 2020-08-02T13:56:07.559856+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12978 39815 swimming_water_temperature 2020-08-02T13:42:37.353473+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12971 39322 swimming_water_temperature 2020-08-02T11:02:10.688988+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12930 41601 swimming_water_temperature 2020-08-02T09:57:19.326585+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12902 39815 swimming_water_temperature 2020-08-01T18:29:04.577455+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12900 39322 swimming_water_temperature 2020-08-01T17:59:45.485486+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12890 39322 swimming_water_temperature 2020-08-01T13:58:48.434752+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12888 39322 swimming_water_temperature 2020-08-01T13:57:58.994786+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12883 39322 swimming_water_temperature 2020-08-01T13:56:45.231183+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12865 41601 swimming_water_temperature 2020-08-01T10:12:49.374788+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12839 39322 swimming_water_temperature 2020-07-31T18:05:38.380826+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
12822 39322 swimming_water_temperature 2020-07-31T13:52:46.910095+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
);