observation

746 rows where name_en = "21-23°C" sorted by unit descending

✎ View and edit SQL

This data as json, CSV (advanced)

name_en ✖

  • 21-23°C · 746 ✖
id unit ▲ property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
10447 58015 swimming_water_temperature 2020-06-28T16:41:53.165268+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3871 53461 swimming_water_temperature 2019-07-23T10:15:20.508506+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4039 53461 swimming_water_temperature 2019-07-24T13:39:12.456069+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4081 53461 swimming_water_temperature 2019-07-25T08:10:25.773596+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4215 53461 swimming_water_temperature 2019-07-26T08:01:22.316393+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4364 53461 swimming_water_temperature 2019-07-27T07:22:24.141544+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4579 53461 swimming_water_temperature 2019-07-29T07:55:24.224658+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9808 53461 swimming_water_temperature 2020-06-22T08:36:23.259507+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9888 53461 swimming_water_temperature 2020-06-23T08:42:58.067309+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10009 53461 swimming_water_temperature 2020-06-24T08:05:22.756591+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10103 53461 swimming_water_temperature 2020-06-25T08:20:37.163291+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10187 53461 swimming_water_temperature 2020-06-26T08:27:37.049054+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10290 53461 swimming_water_temperature 2020-06-27T08:08:14.189660+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10362 53461 swimming_water_temperature 2020-06-28T07:57:37.774467+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10383 53461 swimming_water_temperature 2020-06-28T10:05:14.480029+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10470 53461 swimming_water_temperature 2020-06-29T09:37:05.599857+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10545 53461 swimming_water_temperature 2020-06-30T11:10:14.158833+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10697 53461 swimming_water_temperature 2020-07-03T07:27:08.614422+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11915 53461 swimming_water_temperature 2020-07-20T12:04:22.704733+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12200 53461 swimming_water_temperature 2020-07-23T10:55:44.880271+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4305 52959 swimming_water_temperature 2019-07-26T11:22:05.281449+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4348 52959 swimming_water_temperature 2019-07-26T17:45:49.460973+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4448 52959 swimming_water_temperature 2019-07-27T13:48:01.037982+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4557 52959 swimming_water_temperature 2019-07-28T19:50:44.738451+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4625 52959 swimming_water_temperature 2019-07-29T10:36:55.295198+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4707 52959 swimming_water_temperature 2019-07-30T10:35:25.867089+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
5737 52959 swimming_water_temperature 2019-08-10T14:09:32.783499+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9942 52959 swimming_water_temperature 2020-06-23T10:31:23.369209+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10071 52959 swimming_water_temperature 2020-06-24T11:01:43.973158+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10073 52959 swimming_water_temperature 2020-06-24T11:29:05.234935+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10147 52959 swimming_water_temperature 2020-06-25T10:28:40.866954+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10409 52959 swimming_water_temperature 2020-06-28T12:04:01.503956+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10501 52959 swimming_water_temperature 2020-06-29T12:01:01.416528+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
1654 42114 swimming_water_temperature 2019-06-27T13:26:07.474639+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3240 42114 swimming_water_temperature 2019-07-17T13:26:42.588957+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3367 42114 swimming_water_temperature 2019-07-18T15:07:52.241058+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4041 42114 swimming_water_temperature 2019-07-24T13:39:38.862633+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13890 42114 swimming_water_temperature 2020-08-17T13:04:42.675993+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4407 41977 swimming_water_temperature 2019-07-27T10:12:27.226856+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4409 41977 swimming_water_temperature 2019-07-27T10:12:45.469556+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4410 41977 swimming_water_temperature 2019-07-27T10:13:02.007387+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
1213 41960 swimming_water_temperature 2019-06-21T10:21:27.941227+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
1286 41960 swimming_water_temperature 2019-06-22T10:25:01.968389+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3621 41960 swimming_water_temperature 2019-07-21T10:01:53.368195+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3776 41960 swimming_water_temperature 2019-07-22T10:08:20.466247+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3844 41960 swimming_water_temperature 2019-07-23T09:57:23.475427+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3967 41960 swimming_water_temperature 2019-07-24T10:03:01.210742+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4096 41960 swimming_water_temperature 2019-07-25T10:02:02.082335+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4261 41960 swimming_water_temperature 2019-07-26T10:09:33.443905+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4298 41960 swimming_water_temperature 2019-07-26T10:51:29.885249+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4500 41960 swimming_water_temperature 2019-07-28T10:07:18.469371+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4501 41960 swimming_water_temperature 2019-07-28T10:07:20.617062+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4502 41960 swimming_water_temperature 2019-07-28T10:07:20.629605+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4627 41960 swimming_water_temperature 2019-07-29T10:37:09.060581+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4629 41960 swimming_water_temperature 2019-07-29T10:37:24.014433+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4729 41960 swimming_water_temperature 2019-07-30T11:40:11.166208+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10026 41960 swimming_water_temperature 2020-06-24T09:54:12.809629+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10117 41960 swimming_water_temperature 2020-06-25T09:53:34.563945+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10205 41960 swimming_water_temperature 2020-06-26T10:04:07.699509+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10413 41960 swimming_water_temperature 2020-06-28T13:08:30.206345+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4273 41907 swimming_water_temperature 2019-07-26T10:29:33.102082+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4452 41907 swimming_water_temperature 2019-07-27T14:17:09.521052+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4650 41907 swimming_water_temperature 2019-07-29T12:53:07.420881+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4817 41907 swimming_water_temperature 2019-07-31T11:41:26.385040+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9962 41907 swimming_water_temperature 2020-06-23T13:01:38.642405+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10243 41907 swimming_water_temperature 2020-06-26T13:32:54.541118+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10429 41907 swimming_water_temperature 2020-06-28T16:38:59.716436+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3856 41791 swimming_water_temperature 2019-07-23T10:07:05.270162+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4101 41791 swimming_water_temperature 2019-07-25T10:06:19.660935+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4252 41791 swimming_water_temperature 2019-07-26T10:03:37.516996+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4272 41791 swimming_water_temperature 2019-07-26T10:29:00.092786+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4416 41791 swimming_water_temperature 2019-07-27T10:16:38.470698+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4509 41791 swimming_water_temperature 2019-07-28T10:25:08.346374+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4619 41791 swimming_water_temperature 2019-07-29T10:13:22.261120+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9737 41791 swimming_water_temperature 2020-06-19T10:10:22.283068+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9757 41791 swimming_water_temperature 2020-06-20T10:10:40.607097+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9904 41791 swimming_water_temperature 2020-06-23T09:53:20.073809+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10028 41791 swimming_water_temperature 2020-06-24T09:55:12.461895+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10478 41791 swimming_water_temperature 2020-06-29T10:09:41.987752+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10529 41791 swimming_water_temperature 2020-06-30T10:02:19.978696+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11885 41791 swimming_water_temperature 2020-07-20T10:04:58.087991+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11965 41791 swimming_water_temperature 2020-07-21T09:57:49.329143+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4104 41601 swimming_water_temperature 2019-07-25T10:07:50.592926+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4250 41601 swimming_water_temperature 2019-07-26T10:02:46.960890+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4422 41601 swimming_water_temperature 2019-07-27T10:19:54.344127+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4423 41601 swimming_water_temperature 2019-07-27T10:19:54.354025+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4424 41601 swimming_water_temperature 2019-07-27T10:19:59.493240+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4428 41601 swimming_water_temperature 2019-07-27T10:22:02.534452+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4611 41601 swimming_water_temperature 2019-07-29T10:06:41.614778+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9850 41601 swimming_water_temperature 2020-06-22T10:11:36.403697+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9955 41601 swimming_water_temperature 2020-06-23T12:09:48.600406+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10067 41601 swimming_water_temperature 2020-06-24T10:46:05.362028+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10155 41601 swimming_water_temperature 2020-06-25T12:42:52.364817+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10520 41601 swimming_water_temperature 2020-06-30T09:49:01.115075+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10610 41601 swimming_water_temperature 2020-07-01T11:03:00.077802+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11638 41601 swimming_water_temperature 2020-07-16T10:13:16.477856+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11653 41601 swimming_water_temperature 2020-07-16T11:13:20.921799+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11688 41601 swimming_water_temperature 2020-07-17T09:51:01.680434+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11723 41601 swimming_water_temperature 2020-07-17T10:48:55.915160+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11789 41601 swimming_water_temperature 2020-07-18T10:42:00.263623+0300     21-23°C   21-23°C 0 21-23°C 21-23 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
);