observation

746 rows where value = "21-23" sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

value ✖

  • 21-23 · 646 ✖

primary ✖

  • 0 646
id ▲ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
10705 39902 swimming_water_temperature 2020-07-03T08:38:17.502436+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10703 39875 swimming_water_temperature 2020-07-03T08:21:34.998730+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  
10690 39693 swimming_water_temperature 2020-07-02T17:53:34.755708+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10686 39322 swimming_water_temperature 2020-07-02T14:10:32.034085+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10678 40386 swimming_water_temperature 2020-07-02T11:54:01.497387+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10659 40386 swimming_water_temperature 2020-07-02T10:06:20.562918+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10632 39693 swimming_water_temperature 2020-07-01T19:55:29.518148+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10630 39815 swimming_water_temperature 2020-07-01T19:00:21.835224+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10621 39693 swimming_water_temperature 2020-07-01T14:13:18.387852+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10619 39322 swimming_water_temperature 2020-07-01T13:51:22.286098+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10617 39815 swimming_water_temperature 2020-07-01T13:47:15.887658+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  
10605 39322 swimming_water_temperature 2020-07-01T10:55:06.129346+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10594 40386 swimming_water_temperature 2020-07-01T10:08:02.272562+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  
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  
10572 39693 swimming_water_temperature 2020-06-30T18:50:31.351636+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  
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  
10562 39322 swimming_water_temperature 2020-06-30T14:13:26.137857+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10559 39693 swimming_water_temperature 2020-06-30T13:53:29.808002+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10553 39713 swimming_water_temperature 2020-06-30T11:10:48.316687+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10551 39875 swimming_water_temperature 2020-06-30T11:10:39.938903+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10549 39902 swimming_water_temperature 2020-06-30T11:10:31.044288+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10547 39823 swimming_water_temperature 2020-06-30T11:10:21.715393+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  
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  
10539 40157 swimming_water_temperature 2020-06-30T10:25:43.341091+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  
10532 40386 swimming_water_temperature 2020-06-30T10:07:10.401226+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  
10527 39322 swimming_water_temperature 2020-06-30T10:01:33.203172+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10525 40559 swimming_water_temperature 2020-06-30T09:50:39.381604+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10523 39693 swimming_water_temperature 2020-06-30T09:50:29.987823+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  
10518 40993 swimming_water_temperature 2020-06-30T09:35:40.457051+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  
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  
10510 39693 swimming_water_temperature 2020-06-29T17:47:09.056673+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10507 39693 swimming_water_temperature 2020-06-29T14:09:54.345253+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10503 40142 swimming_water_temperature 2020-06-29T13:16:23.706715+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  
10497 40802 swimming_water_temperature 2020-06-29T11:13:31.645664+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  
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  
10485 40559 swimming_water_temperature 2020-06-29T10:15:59.299413+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10482 39693 swimming_water_temperature 2020-06-29T10:11:49.638786+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  
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  
10465 40076 swimming_water_temperature 2020-06-29T09:32:03.583674+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10463 39902 swimming_water_temperature 2020-06-29T09:19:50.475240+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10461 39875 swimming_water_temperature 2020-06-29T09:00:09.033618+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10459 39713 swimming_water_temperature 2020-06-29T08:34:02.621508+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  
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  
10445 40098 swimming_water_temperature 2020-06-28T16:41:34.627150+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10443 40677 swimming_water_temperature 2020-06-28T16:41:21.521919+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10441 40356 swimming_water_temperature 2020-06-28T16:41:04.630090+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10439 41326 swimming_water_temperature 2020-06-28T16:40:47.539106+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10437 40798 swimming_water_temperature 2020-06-28T16:40:32.129164+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10435 40921 swimming_water_temperature 2020-06-28T16:40:15.512944+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10433 41031 swimming_water_temperature 2020-06-28T16:39:33.187683+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10431 39910 swimming_water_temperature 2020-06-28T16:39:10.788339+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  
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  
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  
10405 40950 swimming_water_temperature 2020-06-28T10:52:22.675089+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10401 40802 swimming_water_temperature 2020-06-28T10:24:29.806948+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10389 40150 swimming_water_temperature 2020-06-28T10:15:33.903799+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  
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  
10379 40559 swimming_water_temperature 2020-06-28T09:59:07.479081+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10369 39875 swimming_water_temperature 2020-06-28T08:41:31.495483+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10367 39713 swimming_water_temperature 2020-06-28T08:41:23.053578+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10363 39823 swimming_water_temperature 2020-06-28T07:58:01.328363+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  
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  
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  
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  
10330 40802 swimming_water_temperature 2020-06-27T11:29:49.434715+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10321 40098 swimming_water_temperature 2020-06-27T10:21:47.429408+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10319 40150 swimming_water_temperature 2020-06-27T10:18:57.139117+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10310 40950 swimming_water_temperature 2020-06-27T10:13:05.043298+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  
10298 39713 swimming_water_temperature 2020-06-27T08:40:46.514670+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10296 39875 swimming_water_temperature 2020-06-27T08:40:37.038802+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10294 39902 swimming_water_temperature 2020-06-27T08:08:39.689228+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  
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  
10288 39823 swimming_water_temperature 2020-06-27T08:08:01.533705+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10284 39322 swimming_water_temperature 2020-06-26T19:10:44.738510+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10267 40098 swimming_water_temperature 2020-06-26T14:02:57.206713+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10265 40098 swimming_water_temperature 2020-06-26T13:54:36.093109+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10260 40356 swimming_water_temperature 2020-06-26T13:35:34.878324+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10258 41326 swimming_water_temperature 2020-06-26T13:35:13.578851+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10256 40993 swimming_water_temperature 2020-06-26T13:35:07.324515+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10253 40798 swimming_water_temperature 2020-06-26T13:34:36.424574+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10251 40020 swimming_water_temperature 2020-06-26T13:34:06.411741+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10248 40921 swimming_water_temperature 2020-06-26T13:33:56.792485+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
);