observation

746 rows where value = "21-23" sorted by value_en

✎ View and edit SQL

This data as json, CSV (advanced)

value ✖

  • 21-23 · 546 ✖
id unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en ▼
4191 40098 swimming_water_temperature 2019-07-25T16:36:39.904295+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  
4198 39815 swimming_water_temperature 2019-07-25T17:44:10.949459+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4201 39267 swimming_water_temperature 2019-07-25T17:48:45.083968+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4213 39823 swimming_water_temperature 2019-07-26T07:44:55.386677+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  
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  
4222 39902 swimming_water_temperature 2019-07-26T08:48:27.165730+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4236 39875 swimming_water_temperature 2019-07-26T09:08:11.794861+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4239 39713 swimming_water_temperature 2019-07-26T09:31:08.126037+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4241 39713 swimming_water_temperature 2019-07-26T09:31:54.948050+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4246 40076 swimming_water_temperature 2019-07-26T09:54:27.401557+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  
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  
4254 39267 swimming_water_temperature 2019-07-26T10:04:13.204558+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  
4259 39322 swimming_water_temperature 2019-07-26T10:09:11.901961+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  
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  
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  
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  
4275 39910 swimming_water_temperature 2019-07-26T10:30:05.586978+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4276 39815 swimming_water_temperature 2019-07-26T10:30:05.878621+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4282 39910 swimming_water_temperature 2019-07-26T10:30:17.930994+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4287 40020 swimming_water_temperature 2019-07-26T10:31:35.933482+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4294 40157 swimming_water_temperature 2019-07-26T10:47:59.743138+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4296 40157 swimming_water_temperature 2019-07-26T10:48:06.441772+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  
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  
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  
4308 40150 swimming_water_temperature 2019-07-26T11:30:54.597089+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4310 40150 swimming_water_temperature 2019-07-26T11:31:03.325412+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4312 40150 swimming_water_temperature 2019-07-26T11:31:06.765259+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4313 40802 swimming_water_temperature 2019-07-26T11:55:33.712019+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4316 39846 swimming_water_temperature 2019-07-26T12:04:08.483658+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4323 40950 swimming_water_temperature 2019-07-26T13:15:10.412111+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4326 41326 swimming_water_temperature 2019-07-26T13:15:26.839048+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4328 40921 swimming_water_temperature 2019-07-26T13:15:42.415794+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4330 40798 swimming_water_temperature 2019-07-26T13:16:09.464683+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4331 39322 swimming_water_temperature 2019-07-26T13:56:57.833553+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4333 39815 swimming_water_temperature 2019-07-26T14:03:44.814533+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4340 39693 swimming_water_temperature 2019-07-26T14:09:47.786119+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  
4355 39693 swimming_water_temperature 2019-07-26T18:02:32.122204+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4359 39815 swimming_water_temperature 2019-07-26T18:12:50.855786+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4362 39823 swimming_water_temperature 2019-07-27T07:07:37.639556+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  
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  
4368 39902 swimming_water_temperature 2019-07-27T08:14:16.909534+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4373 39875 swimming_water_temperature 2019-07-27T08:36:31.902417+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4375 39713 swimming_water_temperature 2019-07-27T08:47:16.285311+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4389 40950 swimming_water_temperature 2019-07-27T09:58:57.129142+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4394 40993 swimming_water_temperature 2019-07-27T10:04:17.568900+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4397 39815 swimming_water_temperature 2019-07-27T10:04:48.233503+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4399 40993 swimming_water_temperature 2019-07-27T10:04:57.860691+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4402 40993 swimming_water_temperature 2019-07-27T10:05:16.994821+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4403 39815 swimming_water_temperature 2019-07-27T10:06:29.548075+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  
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  
4415 40356 swimming_water_temperature 2019-07-27T10:15:34.481900+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  
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  
4438 40157 swimming_water_temperature 2019-07-27T10:39:53.939036+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4447 40098 swimming_water_temperature 2019-07-27T12:17:23.220952+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  
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  
4457 40677 swimming_water_temperature 2019-07-27T14:17:38.469265+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4459 41031 swimming_water_temperature 2019-07-27T14:17:44.985384+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4462 41031 swimming_water_temperature 2019-07-27T14:18:10.159089+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4464 41031 swimming_water_temperature 2019-07-27T14:18:24.816980+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4468 40677 swimming_water_temperature 2019-07-27T14:20:09.462409+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4486 39815 swimming_water_temperature 2019-07-28T08:19:11.166820+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4489 39693 swimming_water_temperature 2019-07-28T08:29:57.344416+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  
4495 39815 swimming_water_temperature 2019-07-28T10:02:26.988343+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4498 40142 swimming_water_temperature 2019-07-28T10:06:05.011529+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  
4505 40559 swimming_water_temperature 2019-07-28T10:14:32.177441+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4508 40142 swimming_water_temperature 2019-07-28T10:15:52.558692+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  
4510 41031 swimming_water_temperature 2019-07-28T10:25:10.205963+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4515 40098 swimming_water_temperature 2019-07-28T10:31:19.300083+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4519 40142 swimming_water_temperature 2019-07-28T13:40:59.879157+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4526 39267 swimming_water_temperature 2019-07-28T14:26:37.323033+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4546 39267 swimming_water_temperature 2019-07-28T17:51:04.366394+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  
4559 39846 swimming_water_temperature 2019-07-28T19:50:51.619826+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4562 39881 swimming_water_temperature 2019-07-28T19:51:05.336282+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  
4567 39897 swimming_water_temperature 2019-07-28T19:51:23.480848+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4570 39784 swimming_water_temperature 2019-07-28T19:51:54.930508+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  
4577 39823 swimming_water_temperature 2019-07-29T07:40:36.177580+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
);