observation

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

✎ View and edit SQL

This data as json, CSV (advanced)

name_en ✖

  • 21-23°C · 646 ✖
id unit ▼ property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
4300 39412 swimming_water_temperature 2019-07-26T10:56:08.094820+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4413 39412 swimming_water_temperature 2019-07-27T10:15:02.332175+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4631 39412 swimming_water_temperature 2019-07-29T10:46:59.187102+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9577 39412 swimming_water_temperature 2020-06-17T10:28:21.151366+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9884 39412 swimming_water_temperature 2020-06-23T07:54:37.700324+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10019 39412 swimming_water_temperature 2020-06-24T09:39:49.814809+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10099 39412 swimming_water_temperature 2020-06-25T07:43:05.727315+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10183 39412 swimming_water_temperature 2020-06-26T07:46:47.454136+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10300 39412 swimming_water_temperature 2020-06-27T09:16:18.769180+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11986 39412 swimming_water_temperature 2020-07-21T10:22:05.678182+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12250 39412 swimming_water_temperature 2020-07-24T09:14:39.808927+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12256 39412 swimming_water_temperature 2020-07-24T09:14:40.008918+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13578 39412 swimming_water_temperature 2020-08-10T14:25:39.741558+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3355 39527 swimming_water_temperature 2019-07-18T14:03:46.301143+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3390 39527 swimming_water_temperature 2019-07-18T19:08:04.977085+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3697 39527 swimming_water_temperature 2019-07-21T18:01:48.929281+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3708 39527 swimming_water_temperature 2019-07-21T20:00:55.837595+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3926 39527 swimming_water_temperature 2019-07-23T14:49:50.868225+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4265 39527 swimming_water_temperature 2019-07-26T10:16:37.028681+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4564 39527 swimming_water_temperature 2019-07-28T19:51:13.847593+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4723 39527 swimming_water_temperature 2019-07-30T11:31:17.751708+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4780 39527 swimming_water_temperature 2019-07-31T10:10:35.370634+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9622 39527 swimming_water_temperature 2020-06-17T18:24:43.672521+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9954 39527 swimming_water_temperature 2020-06-23T11:31:26.050980+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10076 39527 swimming_water_temperature 2020-06-24T11:39:37.942758+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10138 39527 swimming_water_temperature 2020-06-25T10:12:17.040505+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10193 39527 swimming_water_temperature 2020-06-26T08:57:46.712559+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10339 39527 swimming_water_temperature 2020-06-27T11:46:03.191157+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10381 39527 swimming_water_temperature 2020-06-28T10:00:49.314468+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10487 39527 swimming_water_temperature 2020-06-29T10:26:47.109554+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3922 39568 swimming_water_temperature 2019-07-23T14:24:24.183616+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4492 39568 swimming_water_temperature 2019-07-28T08:43:41.197665+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4573 39568 swimming_water_temperature 2019-07-28T19:52:16.066842+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
5606 39568 swimming_water_temperature 2019-08-08T17:54:53.539716+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
5677 39568 swimming_water_temperature 2019-08-09T18:32:53.830107+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10041 39568 swimming_water_temperature 2020-06-24T10:04:10.286030+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10228 39568 swimming_water_temperature 2020-06-26T10:36:53.152495+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10341 39568 swimming_water_temperature 2020-06-27T12:40:44.062670+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10495 39568 swimming_water_temperature 2020-06-29T11:12:25.595558+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10516 39568 swimming_water_temperature 2020-06-30T08:13:55.294192+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10574 39568 swimming_water_temperature 2020-07-01T08:47:33.885483+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10575 39568 swimming_water_temperature 2020-07-01T08:47:37.047392+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3678 39583 swimming_water_temperature 2019-07-21T14:02:50.298175+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3972 39583 swimming_water_temperature 2019-07-24T10:05:56.668045+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4058 39583 swimming_water_temperature 2019-07-24T14:13:16.341166+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4072 39583 swimming_water_temperature 2019-07-24T17:53:07.267796+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4114 39583 swimming_water_temperature 2019-07-25T10:17:15.462483+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4178 39583 swimming_water_temperature 2019-07-25T14:05:41.672201+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4193 39583 swimming_water_temperature 2019-07-25T17:38:19.130336+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4256 39583 swimming_water_temperature 2019-07-26T10:05:28.347964+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4699 39583 swimming_water_temperature 2019-07-30T10:13:25.002104+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4733 39583 swimming_water_temperature 2019-07-30T13:57:48.075097+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4744 39583 swimming_water_temperature 2019-07-30T17:38:54.656750+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4838 39583 swimming_water_temperature 2019-07-31T13:59:07.103226+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4948 39583 swimming_water_temperature 2019-08-01T15:42:08.313826+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4953 39583 swimming_water_temperature 2019-08-01T17:47:33.173292+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9270 39583 swimming_water_temperature 2020-06-13T17:44:29.448489+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9342 39583 swimming_water_temperature 2020-06-14T17:48:59.725767+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9446 39583 swimming_water_temperature 2020-06-15T17:44:12.601760+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9495 39583 swimming_water_temperature 2020-06-16T10:15:28.998394+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9532 39583 swimming_water_temperature 2020-06-16T18:33:51.691619+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9609 39583 swimming_water_temperature 2020-06-17T14:37:38.767086+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9672 39583 swimming_water_temperature 2020-06-18T10:25:56.269926+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9687 39583 swimming_water_temperature 2020-06-18T14:13:54.498870+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9873 39583 swimming_water_temperature 2020-06-22T14:56:10.286985+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9939 39583 swimming_water_temperature 2020-06-23T10:28:32.371970+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10514 39583 swimming_water_temperature 2020-06-29T17:54:03.334289+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10534 39583 swimming_water_temperature 2020-06-30T10:10:25.769221+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10564 39583 swimming_water_temperature 2020-06-30T14:16:49.827362+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10569 39583 swimming_water_temperature 2020-06-30T17:52:48.611490+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10892 39583 swimming_water_temperature 2020-07-05T14:08:59.768961+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11782 39583 swimming_water_temperature 2020-07-18T10:18:16.088742+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11803 39583 swimming_water_temperature 2020-07-18T14:05:12.113303+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11812 39583 swimming_water_temperature 2020-07-18T17:55:51.797309+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12031 39583 swimming_water_temperature 2020-07-21T13:58:26.891540+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12042 39583 swimming_water_temperature 2020-07-21T17:47:13.345222+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12043 39583 swimming_water_temperature 2020-07-21T17:49:54.936496+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12120 39583 swimming_water_temperature 2020-07-22T14:20:15.170234+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13469 39583 swimming_water_temperature 2020-08-08T14:05:39.538990+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13474 39583 swimming_water_temperature 2020-08-08T17:47:06.132575+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13520 39583 swimming_water_temperature 2020-08-09T13:56:56.562432+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13527 39583 swimming_water_temperature 2020-08-09T17:41:26.595094+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13857 39583 swimming_water_temperature 2020-08-16T14:17:34.158021+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13867 39583 swimming_water_temperature 2020-08-16T21:54:47.324929+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3899 39606 swimming_water_temperature 2019-07-23T10:37:15.810757+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4083 39606 swimming_water_temperature 2019-07-25T08:31:30.092247+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4220 39606 swimming_water_temperature 2019-07-26T08:34:39.263640+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4366 39606 swimming_water_temperature 2019-07-27T07:42:19.763676+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4581 39606 swimming_water_temperature 2019-07-29T08:21:23.811366+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9810 39606 swimming_water_temperature 2020-06-22T08:54:33.788405+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9898 39606 swimming_water_temperature 2020-06-23T09:29:12.133951+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9910 39606 swimming_water_temperature 2020-06-23T09:58:20.726806+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10011 39606 swimming_water_temperature 2020-06-24T08:27:06.494325+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10054 39606 swimming_water_temperature 2020-06-24T10:26:13.349933+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10105 39606 swimming_water_temperature 2020-06-25T08:32:50.929386+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10189 39606 swimming_water_temperature 2020-06-26T08:40:14.181018+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10292 39606 swimming_water_temperature 2020-06-27T08:08:27.614012+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10360 39606 swimming_water_temperature 2020-06-28T07:57:22.951693+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10457 39606 swimming_water_temperature 2020-06-29T07:58:47.560640+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10543 39606 swimming_water_temperature 2020-06-30T11:10:05.296455+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
);