observation

818 rows where value = "15-17" sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

value ✖

  • 15-17 · 718 ✖

primary ✖

  • 0 718
id ▲ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
12567 40802 swimming_water_temperature 2020-07-28T11:04:03.824367+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12561 52959 swimming_water_temperature 2020-07-28T10:20:21.711318+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12553 41791 swimming_water_temperature 2020-07-28T10:13:44.086841+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12522 39568 swimming_water_temperature 2020-07-28T08:27:39.869581+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12480 40802 swimming_water_temperature 2020-07-27T10:21:17.359394+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12468 40559 swimming_water_temperature 2020-07-27T10:05:40.476039+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12452 41960 swimming_water_temperature 2020-07-27T09:53:03.895394+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12414 39568 swimming_water_temperature 2020-07-27T08:16:42.917557+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12394 39693 swimming_water_temperature 2020-07-26T11:37:04.183338+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12370 40386 swimming_water_temperature 2020-07-26T10:00:03.346341+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12365 41960 swimming_water_temperature 2020-07-26T09:50:54.363055+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12363 40559 swimming_water_temperature 2020-07-26T09:48:50.704822+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12349 39815 swimming_water_temperature 2020-07-25T14:04:27.876430+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12347 40802 swimming_water_temperature 2020-07-25T14:04:09.111629+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12345 39693 swimming_water_temperature 2020-07-25T13:50:53.810496+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12343 40098 swimming_water_temperature 2020-07-25T10:39:46.360176+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12337 39815 swimming_water_temperature 2020-07-25T10:31:45.595709+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12323 40386 swimming_water_temperature 2020-07-25T10:04:34.749295+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12319 40559 swimming_water_temperature 2020-07-25T10:00:48.356955+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12313 39693 swimming_water_temperature 2020-07-25T09:42:20.069549+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12303 40802 swimming_water_temperature 2020-07-24T16:07:05.465045+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12296 39693 swimming_water_temperature 2020-07-24T13:52:17.802047+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12292 39815 swimming_water_temperature 2020-07-24T13:17:52.525566+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12284 39693 swimming_water_temperature 2020-07-24T10:25:39.601205+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12278 40098 swimming_water_temperature 2020-07-24T10:14:11.200718+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12271 41960 swimming_water_temperature 2020-07-24T09:58:04.419064+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12268 40559 swimming_water_temperature 2020-07-24T09:57:38.981030+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12262 40386 swimming_water_temperature 2020-07-24T09:51:22.907788+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12260 41791 swimming_water_temperature 2020-07-24T09:42:58.864559+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12225 39815 swimming_water_temperature 2020-07-23T19:49:23.074451+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12216 39815 swimming_water_temperature 2020-07-23T14:16:55.017100+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12210 40993 swimming_water_temperature 2020-07-23T13:37:27.216179+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12207 52960 swimming_water_temperature 2020-07-23T10:59:22.455553+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12197 41960 swimming_water_temperature 2020-07-23T10:50:57.824319+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12174 39693 swimming_water_temperature 2020-07-23T10:31:43.622500+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12153 40386 swimming_water_temperature 2020-07-23T09:51:04.905846+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12150 39815 swimming_water_temperature 2020-07-23T09:19:19.943554+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12143 39693 swimming_water_temperature 2020-07-23T08:20:23.852443+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12125 40802 swimming_water_temperature 2020-07-22T16:22:21.867822+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12115 41960 swimming_water_temperature 2020-07-22T12:28:37.321338+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12110 40950 swimming_water_temperature 2020-07-22T10:29:54.881565+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12095 40559 swimming_water_temperature 2020-07-22T10:01:51.977591+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12073 40677 swimming_water_temperature 2020-07-22T08:29:13.102192+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12069 58015 swimming_water_temperature 2020-07-22T08:28:49.685912+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11937 52958 swimming_water_temperature 2020-07-20T13:10:45.982138+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11936 50549 swimming_water_temperature 2020-07-20T13:10:22.597045+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11935 52960 swimming_water_temperature 2020-07-20T13:10:04.278535+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11785 40150 swimming_water_temperature 2020-07-18T10:25:32.720555+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11719 40950 swimming_water_temperature 2020-07-17T10:41:36.806541+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11713 40150 swimming_water_temperature 2020-07-17T10:20:38.455261+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11705 40258 swimming_water_temperature 2020-07-17T10:15:16.480741+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11690 41960 swimming_water_temperature 2020-07-17T09:56:36.938804+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11685 39568 swimming_water_temperature 2020-07-17T08:32:27.517351+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11676 52959 swimming_water_temperature 2020-07-16T18:24:40.471562+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11648 39527 swimming_water_temperature 2020-07-16T11:06:51.354607+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11642 40150 swimming_water_temperature 2020-07-16T10:28:09.460394+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11633 40950 swimming_water_temperature 2020-07-16T10:08:26.349625+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11624 41960 swimming_water_temperature 2020-07-16T09:59:53.334733+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11619 40258 swimming_water_temperature 2020-07-16T09:50:58.631675+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11588 52960 swimming_water_temperature 2020-07-15T11:59:31.682119+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11586 50549 swimming_water_temperature 2020-07-15T11:58:40.351772+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11584 39568 swimming_water_temperature 2020-07-15T11:20:36.129007+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11567 58015 swimming_water_temperature 2020-07-15T10:26:30.947714+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11561 41326 swimming_water_temperature 2020-07-15T10:23:49.258106+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11556 40798 swimming_water_temperature 2020-07-15T10:22:50.456200+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11551 40802 swimming_water_temperature 2020-07-15T10:21:41.952157+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11544 40921 swimming_water_temperature 2020-07-15T10:11:19.330725+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11543 40150 swimming_water_temperature 2020-07-15T10:11:16.943196+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11539 39910 swimming_water_temperature 2020-07-15T10:10:13.878215+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11538 41907 swimming_water_temperature 2020-07-15T10:10:07.934672+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11525 41960 swimming_water_temperature 2020-07-15T09:56:54.967016+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11520 40258 swimming_water_temperature 2020-07-15T09:45:38.200972+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11518 39527 swimming_water_temperature 2020-07-15T09:25:55.391464+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11468 40258 swimming_water_temperature 2020-07-14T10:46:42.617891+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11458 40150 swimming_water_temperature 2020-07-14T10:11:27.867155+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11443 40142 swimming_water_temperature 2020-07-14T09:58:10.404676+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11430 39527 swimming_water_temperature 2020-07-14T09:13:26.610192+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11427 39568 swimming_water_temperature 2020-07-14T08:07:34.011991+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11398 39527 swimming_water_temperature 2020-07-13T12:54:09.522205+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11390 40802 swimming_water_temperature 2020-07-13T10:50:37.616148+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11382 40258 swimming_water_temperature 2020-07-13T10:29:28.095143+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11380 40150 swimming_water_temperature 2020-07-13T10:17:31.283123+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11350 39568 swimming_water_temperature 2020-07-13T09:37:55.590085+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11323 39568 swimming_water_temperature 2020-07-12T12:54:33.276774+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11321 40802 swimming_water_temperature 2020-07-12T11:15:26.156673+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11318 40258 swimming_water_temperature 2020-07-12T10:44:49.080845+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11310 40150 swimming_water_temperature 2020-07-12T10:08:18.032320+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11302 40098 swimming_water_temperature 2020-07-12T10:02:35.702738+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11277 40258 swimming_water_temperature 2020-07-11T11:02:54.667136+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11272 41960 swimming_water_temperature 2020-07-11T10:14:33.335103+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11265 40150 swimming_water_temperature 2020-07-11T10:07:52.470639+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11261 40950 swimming_water_temperature 2020-07-11T10:04:14.646725+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11256 40098 swimming_water_temperature 2020-07-11T09:57:31.952886+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11249 39527 swimming_water_temperature 2020-07-11T08:12:49.233779+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11202 40258 swimming_water_temperature 2020-07-10T12:28:46.155991+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11199 40802 swimming_water_temperature 2020-07-10T12:18:40.027509+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11196 41960 swimming_water_temperature 2020-07-10T11:21:22.502693+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11193 40098 swimming_water_temperature 2020-07-10T11:10:55.431688+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11189 52959 swimming_water_temperature 2020-07-10T10:23:51.913135+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
11184 40950 swimming_water_temperature 2020-07-10T10:13:23.733706+0300     15-17°C   15-17°C 0 15-17°C 15-17 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
);