observation

497 rows where name_fi = "alle 15°C" sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

name_fi ✖

  • alle 15°C · 497 ✖
id ▲ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
24082 39322 swimming_water_temperature 2020-10-14T11:05:00.666183+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
13436 40258 swimming_water_temperature 2020-08-08T09:55:35.945642+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
13391 40150 swimming_water_temperature 2020-08-07T10:07:37.960100+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
13383 40258 swimming_water_temperature 2020-08-07T09:59:38.066374+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
13311 40150 swimming_water_temperature 2020-08-06T10:38:05.990688+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
13307 40258 swimming_water_temperature 2020-08-06T10:34:53.428759+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
13238 40150 swimming_water_temperature 2020-08-05T10:29:28.995748+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
13204 40258 swimming_water_temperature 2020-08-05T09:49:54.462443+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
13145 40950 swimming_water_temperature 2020-08-04T10:39:58.411213+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
13138 40258 swimming_water_temperature 2020-08-04T10:10:25.455296+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
13028 40950 swimming_water_temperature 2020-08-03T10:05:00.626281+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12880 40258 swimming_water_temperature 2020-08-01T11:53:15.490628+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12836 40950 swimming_water_temperature 2020-07-31T15:56:26.300164+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12833 40258 swimming_water_temperature 2020-07-31T15:38:41.546188+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12721 40150 swimming_water_temperature 2020-07-30T10:08:47.465058+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12667 40150 swimming_water_temperature 2020-07-29T12:22:15.155990+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12654 40258 swimming_water_temperature 2020-07-29T10:27:44.861896+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12637 40950 swimming_water_temperature 2020-07-29T10:00:36.968322+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12607 39527 swimming_water_temperature 2020-07-29T08:18:14.666008+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12555 40950 swimming_water_temperature 2020-07-28T10:14:28.059640+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12548 40150 swimming_water_temperature 2020-07-28T10:06:55.029458+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12543 40258 swimming_water_temperature 2020-07-28T09:55:47.988941+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12520 39527 swimming_water_temperature 2020-07-28T08:13:31.183734+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12477 40150 swimming_water_temperature 2020-07-27T10:14:50.914921+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12470 40950 swimming_water_temperature 2020-07-27T10:07:18.896436+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12453 40258 swimming_water_temperature 2020-07-27T09:54:33.679569+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12397 39568 swimming_water_temperature 2020-07-26T13:52:09.139325+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12384 40950 swimming_water_temperature 2020-07-26T10:17:15.003847+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12381 40802 swimming_water_temperature 2020-07-26T10:12:52.387329+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12377 39527 swimming_water_temperature 2020-07-26T10:08:03.937303+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12374 40150 swimming_water_temperature 2020-07-26T10:03:26.082448+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12361 39568 swimming_water_temperature 2020-07-26T09:15:09.797332+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12341 41470 swimming_water_temperature 2020-07-25T10:38:53.185775+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12334 52959 swimming_water_temperature 2020-07-25T10:16:05.943571+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12332 40950 swimming_water_temperature 2020-07-25T10:13:04.503262+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12327 40150 swimming_water_temperature 2020-07-25T10:07:12.795100+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12311 40258 swimming_water_temperature 2020-07-25T09:37:06.003997+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12309 39527 swimming_water_temperature 2020-07-25T09:09:41.896741+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12290 52959 swimming_water_temperature 2020-07-24T11:46:24.627599+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12288 40150 swimming_water_temperature 2020-07-24T11:04:52.932452+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12276 40950 swimming_water_temperature 2020-07-24T10:10:27.779181+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12266 40258 swimming_water_temperature 2020-07-24T09:55:14.986891+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12230 39568 swimming_water_temperature 2020-07-24T08:26:07.613327+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12227 39527 swimming_water_temperature 2020-07-24T07:56:18.925684+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12171 40950 swimming_water_temperature 2020-07-23T10:11:34.974694+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12162 40559 swimming_water_temperature 2020-07-23T09:59:21.709960+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12159 40258 swimming_water_temperature 2020-07-23T09:59:12.376200+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12152 52959 swimming_water_temperature 2020-07-23T09:24:34.979564+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12148 39568 swimming_water_temperature 2020-07-23T09:02:05.133213+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12146 39527 swimming_water_temperature 2020-07-23T08:40:28.331757+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12108 40150 swimming_water_temperature 2020-07-22T10:27:17.272403+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
12085 40258 swimming_water_temperature 2020-07-22T09:50:17.482295+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11623 40258 swimming_water_temperature 2020-07-16T09:55:40.437874+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11604 39527 swimming_water_temperature 2020-07-15T15:43:25.351708+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11602 52959 swimming_water_temperature 2020-07-15T15:43:04.683917+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11590 52958 swimming_water_temperature 2020-07-15T11:59:56.825402+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11548 40950 swimming_water_temperature 2020-07-15T10:15:59.697752+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11515 39527 swimming_water_temperature 2020-07-14T22:54:47.249613+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11504 52959 swimming_water_temperature 2020-07-14T16:19:00.271428+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11460 40150 swimming_water_temperature 2020-07-14T10:11:40.998155+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11455 40950 swimming_water_temperature 2020-07-14T10:10:00.766169+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11448 41960 swimming_water_temperature 2020-07-14T09:58:52.861796+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11375 41960 swimming_water_temperature 2020-07-13T10:07:25.583162+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11372 40950 swimming_water_temperature 2020-07-13T10:06:53.019262+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11330 39568 swimming_water_temperature 2020-07-12T14:06:13.325033+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11328 39527 swimming_water_temperature 2020-07-12T14:06:02.422587+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11326 52959 swimming_water_temperature 2020-07-12T14:05:48.899069+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11314 40950 swimming_water_temperature 2020-07-12T10:14:32.995007+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11293 41960 swimming_water_temperature 2020-07-12T09:53:44.221833+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11275 40802 swimming_water_temperature 2020-07-11T10:23:17.493815+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11248 39568 swimming_water_temperature 2020-07-10T23:54:23.312656+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11246 52959 swimming_water_temperature 2020-07-10T23:54:07.006257+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11205 39568 swimming_water_temperature 2020-07-10T12:56:56.750866+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11201 40802 swimming_water_temperature 2020-07-10T12:22:19.917875+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11160 39527 swimming_water_temperature 2020-07-10T08:09:36.055647+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
11076 40802 swimming_water_temperature 2020-07-08T11:30:53.761726+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
9162 40993 swimming_water_temperature 2020-06-12T10:01:32.478351+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
9087 58015 swimming_water_temperature 2020-06-11T10:04:27.738654+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
9061 40258 swimming_water_temperature 2020-06-11T10:00:10.501231+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
9054 40559 swimming_water_temperature 2020-06-11T09:54:03.877372+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
9048 40993 swimming_water_temperature 2020-06-11T09:45:46.700792+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8985 40258 swimming_water_temperature 2020-06-10T10:04:51.542902+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8975 39693 swimming_water_temperature 2020-06-10T09:53:51.612783+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8971 40993 swimming_water_temperature 2020-06-10T09:52:56.247097+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8946 52959 swimming_water_temperature 2020-06-09T16:49:25.839554+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8944 40993 swimming_water_temperature 2020-06-09T15:38:57.523798+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8936 39693 swimming_water_temperature 2020-06-09T12:57:02.789630+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8924 40258 swimming_water_temperature 2020-06-09T10:19:38.267967+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8920 40950 swimming_water_temperature 2020-06-09T10:06:44.950998+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8918 40142 swimming_water_temperature 2020-06-09T10:06:07.037605+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8914 40559 swimming_water_temperature 2020-06-09T09:59:35.269207+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8910 39815 swimming_water_temperature 2020-06-09T09:55:58.789091+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8905 39693 swimming_water_temperature 2020-06-09T08:27:46.582297+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8903 39527 swimming_water_temperature 2020-06-09T08:13:44.613876+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8888 39527 swimming_water_temperature 2020-06-08T13:37:44.271269+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8882 40950 swimming_water_temperature 2020-06-08T10:30:53.653729+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8880 40142 swimming_water_temperature 2020-06-08T10:23:40.429353+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8871 40993 swimming_water_temperature 2020-06-08T10:19:50.456002+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8865 52959 swimming_water_temperature 2020-06-08T10:09:07.633769+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8857 40258 swimming_water_temperature 2020-06-08T10:04:28.413118+0300     alle 15°C   under 15°C 0 below 15°C 0-15 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
);