observation

818 rows where name_fi = "15-17°C" sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

name_fi ✖

  • 15-17°C · 818 ✖
id ▲ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
17566 39412 swimming_water_temperature 2020-09-07T10:11:59.368806+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
17564 39412 swimming_water_temperature 2020-09-07T10:11:53.300729+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
17555 39713 swimming_water_temperature 2020-09-07T09:46:16.798143+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
17552 39875 swimming_water_temperature 2020-09-07T09:30:46.246035+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
17544 39902 swimming_water_temperature 2020-09-07T09:15:08.607089+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
17537 39606 swimming_water_temperature 2020-09-07T08:53:06.714842+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
17535 39823 swimming_water_temperature 2020-09-07T08:52:52.469770+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
17525 53461 swimming_water_temperature 2020-09-07T08:19:43.434408+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13814 39527 swimming_water_temperature 2020-08-15T15:32:40.700477+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13693 40157 swimming_water_temperature 2020-08-13T08:46:29.418678+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13692 40802 swimming_water_temperature 2020-08-13T08:46:12.362334+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13691 40150 swimming_water_temperature 2020-08-13T08:45:59.248379+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13690 40950 swimming_water_temperature 2020-08-13T08:45:48.437164+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13689 40150 swimming_water_temperature 2020-08-13T08:45:33.647611+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13687 40258 swimming_water_temperature 2020-08-13T08:45:01.247218+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13685 39568 swimming_water_temperature 2020-08-13T08:25:17.526176+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13636 39693 swimming_water_temperature 2020-08-12T10:11:40.978726+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13617 52959 swimming_water_temperature 2020-08-11T11:41:10.043713+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13576 52958 swimming_water_temperature 2020-08-10T14:24:02.628875+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13574 52960 swimming_water_temperature 2020-08-10T14:23:06.552866+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13564 39527 swimming_water_temperature 2020-08-10T11:50:03.034109+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13451 40142 swimming_water_temperature 2020-08-08T10:13:47.588691+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13427 39527 swimming_water_temperature 2020-08-08T08:20:32.645453+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13407 40802 swimming_water_temperature 2020-08-07T11:29:28.149381+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13389 40950 swimming_water_temperature 2020-08-07T10:04:54.197220+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13387 40559 swimming_water_temperature 2020-08-07T10:02:52.436954+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13379 40142 swimming_water_temperature 2020-08-07T09:57:10.134647+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13368 39568 swimming_water_temperature 2020-08-07T09:09:59.152804+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13347 39527 swimming_water_temperature 2020-08-07T08:16:54.244037+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13334 39527 swimming_water_temperature 2020-08-06T13:57:00.591590+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13324 41960 swimming_water_temperature 2020-08-06T11:28:19.312061+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13316 52959 swimming_water_temperature 2020-08-06T10:49:56.819072+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13314 40950 swimming_water_temperature 2020-08-06T10:41:57.735131+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13306 40559 swimming_water_temperature 2020-08-06T10:31:44.153057+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13303 40802 swimming_water_temperature 2020-08-06T10:20:28.505623+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13241 52959 swimming_water_temperature 2020-08-05T10:59:23.037033+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13236 40950 swimming_water_temperature 2020-08-05T10:28:01.499553+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13235 40559 swimming_water_temperature 2020-08-05T10:22:49.987025+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13201 41960 swimming_water_temperature 2020-08-05T09:46:08.682813+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13200 40142 swimming_water_temperature 2020-08-05T09:45:51.229018+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13182 39527 swimming_water_temperature 2020-08-05T08:31:50.713597+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13163 40993 swimming_water_temperature 2020-08-04T12:52:14.202686+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13154 39527 swimming_water_temperature 2020-08-04T11:40:16.904766+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13152 39568 swimming_water_temperature 2020-08-04T11:39:39.565683+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13143 40150 swimming_water_temperature 2020-08-04T10:25:11.133773+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13140 41960 swimming_water_temperature 2020-08-04T10:11:13.011460+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13135 40559 swimming_water_temperature 2020-08-04T10:10:15.641190+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13125 40142 swimming_water_temperature 2020-08-04T10:01:36.300829+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13123 52959 swimming_water_temperature 2020-08-04T10:01:16.538338+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13084 52959 swimming_water_temperature 2020-08-03T14:47:31.337596+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13077 39527 swimming_water_temperature 2020-08-03T13:16:38.970822+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13067 58015 swimming_water_temperature 2020-08-03T12:48:25.661952+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13065 41326 swimming_water_temperature 2020-08-03T12:48:11.251911+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13061 40921 swimming_water_temperature 2020-08-03T12:47:32.867206+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13052 40258 swimming_water_temperature 2020-08-03T12:45:18.563505+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13044 40559 swimming_water_temperature 2020-08-03T10:30:38.347648+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13039 39568 swimming_water_temperature 2020-08-03T10:20:09.545292+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13033 40150 swimming_water_temperature 2020-08-03T10:10:03.807761+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13031 52959 swimming_water_temperature 2020-08-03T10:09:35.618314+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13023 40142 swimming_water_temperature 2020-08-03T09:52:49.394789+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13021 41960 swimming_water_temperature 2020-08-03T09:52:46.102854+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12976 39527 swimming_water_temperature 2020-08-02T12:12:06.122823+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12973 40993 swimming_water_temperature 2020-08-02T11:27:57.936856+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12961 40142 swimming_water_temperature 2020-08-02T10:29:46.529914+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12954 40150 swimming_water_temperature 2020-08-02T10:16:37.563164+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12951 40950 swimming_water_temperature 2020-08-02T10:14:34.883088+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12948 52959 swimming_water_temperature 2020-08-02T10:13:03.584117+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12942 40559 swimming_water_temperature 2020-08-02T10:07:19.015941+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12940 40258 swimming_water_temperature 2020-08-02T10:03:38.594891+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12934 41960 swimming_water_temperature 2020-08-02T10:03:12.007838+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12905 39568 swimming_water_temperature 2020-08-02T08:56:06.183510+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12877 40098 swimming_water_temperature 2020-08-01T11:07:27.105428+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12875 41791 swimming_water_temperature 2020-08-01T11:02:18.683490+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12872 40559 swimming_water_temperature 2020-08-01T10:27:22.308552+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12871 40559 swimming_water_temperature 2020-08-01T10:27:16.640135+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12861 40150 swimming_water_temperature 2020-08-01T10:10:11.104871+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12854 40950 swimming_water_temperature 2020-08-01T10:08:31.546630+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12851 41960 swimming_water_temperature 2020-08-01T10:05:58.711175+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12847 40142 swimming_water_temperature 2020-08-01T10:03:50.548206+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12843 39568 swimming_water_temperature 2020-08-01T08:12:56.363232+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12810 40142 swimming_water_temperature 2020-07-31T11:12:51.981105+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12809 40802 swimming_water_temperature 2020-07-31T11:12:49.436541+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12807 40150 swimming_water_temperature 2020-07-31T10:50:39.411351+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12803 40950 swimming_water_temperature 2020-07-31T10:17:30.209690+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12801 52959 swimming_water_temperature 2020-07-31T10:14:00.802888+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12732 40098 swimming_water_temperature 2020-07-30T10:38:31.206121+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12723 40950 swimming_water_temperature 2020-07-30T10:09:49.744838+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12717 40142 swimming_water_temperature 2020-07-30T10:07:00.152468+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12709 41791 swimming_water_temperature 2020-07-30T09:50:48.485280+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12708 41960 swimming_water_temperature 2020-07-30T09:49:59.924937+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12680 39568 swimming_water_temperature 2020-07-29T15:40:33.047969+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12678 52959 swimming_water_temperature 2020-07-29T14:10:53.695590+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12665 40802 swimming_water_temperature 2020-07-29T10:57:23.944794+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12657 40098 swimming_water_temperature 2020-07-29T10:27:55.504922+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12639 52959 swimming_water_temperature 2020-07-29T10:06:03.066559+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12631 40142 swimming_water_temperature 2020-07-29T09:56:33.918639+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12629 41791 swimming_water_temperature 2020-07-29T09:44:54.653744+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12628 39527 swimming_water_temperature 2020-07-29T09:27:50.576197+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12576 40559 swimming_water_temperature 2020-07-28T11:21:36.199950+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
12569 40098 swimming_water_temperature 2020-07-28T11:06:06.408530+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
);