observation

4,748 rows where primary = 0 and property = "swimming_water_temperature" sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name_fi, name_sv, value

property ✖

  • swimming_water_temperature · 4,748 ✖

primary ✖

  • 0 · 4,748 ✖
id ▲ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
24082 39322 swimming_water_temperature 2020-10-14T11:05:00.666183+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
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  
14484 39583 swimming_water_temperature 2020-08-28T08:43:07.548111+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13974 53461 swimming_water_temperature 2020-08-21T11:23:03.184224+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13972 39713 swimming_water_temperature 2020-08-21T11:09:51.348003+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13970 39823 swimming_water_temperature 2020-08-21T11:09:22.320503+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13969 39875 swimming_water_temperature 2020-08-21T10:12:16.211484+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13967 39875 swimming_water_temperature 2020-08-21T10:12:09.731511+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13965 39902 swimming_water_temperature 2020-08-21T09:45:02.019102+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13963 39606 swimming_water_temperature 2020-08-21T09:31:55.941932+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13890 42114 swimming_water_temperature 2020-08-17T13:04:42.675993+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13888 52959 swimming_water_temperature 2020-08-17T12:37:07.381585+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13886 39267 swimming_water_temperature 2020-08-17T12:36:24.340709+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13884 39693 swimming_water_temperature 2020-08-17T12:36:09.329837+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13882 39568 swimming_water_temperature 2020-08-17T12:35:54.164611+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13880 39527 swimming_water_temperature 2020-08-17T12:35:38.285569+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13878 39322 swimming_water_temperature 2020-08-17T12:35:21.055110+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13876 53461 swimming_water_temperature 2020-08-17T11:10:45.274995+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13874 39606 swimming_water_temperature 2020-08-17T10:09:47.344109+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13873 39902 swimming_water_temperature 2020-08-17T09:47:18.772678+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13871 39875 swimming_water_temperature 2020-08-17T09:26:42.758776+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13869 39713 swimming_water_temperature 2020-08-17T09:11:31.771240+0300     19-21°C   19-21°C 0 19-21°C 19-21 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  
13864 39815 swimming_water_temperature 2020-08-16T18:10:46.405573+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13861 39693 swimming_water_temperature 2020-08-16T18:01:54.056600+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13859 39322 swimming_water_temperature 2020-08-16T14:53:18.650321+0300     19-21°C   19-21°C 0 19-21°C 19-21 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  
13855 39815 swimming_water_temperature 2020-08-16T14:11:53.022410+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13853 39693 swimming_water_temperature 2020-08-16T13:57:59.214444+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13851 52959 swimming_water_temperature 2020-08-16T12:18:21.427698+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13849 39693 swimming_water_temperature 2020-08-16T11:40:55.631651+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13846 39815 swimming_water_temperature 2020-08-16T11:15:22.949399+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13844 39322 swimming_water_temperature 2020-08-16T10:31:46.597902+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13824 39568 swimming_water_temperature 2020-08-16T10:08:07.980630+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13822 39815 swimming_water_temperature 2020-08-15T18:42:43.077057+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13819 39693 swimming_water_temperature 2020-08-15T18:18:42.858743+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13816 39583 swimming_water_temperature 2020-08-15T17:46:12.005510+0300     19-21°C   19-21°C 0 19-21°C 19-21 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  
13813 39693 swimming_water_temperature 2020-08-15T14:13:08.899502+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13810 39322 swimming_water_temperature 2020-08-15T14:00:22.620339+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13807 39583 swimming_water_temperature 2020-08-15T13:51:22.654067+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13805 39815 swimming_water_temperature 2020-08-15T13:48:39.493764+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13803 39693 swimming_water_temperature 2020-08-15T12:55:04.548964+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13800 39815 swimming_water_temperature 2020-08-15T11:37:14.309248+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13798 52959 swimming_water_temperature 2020-08-15T10:55:15.573262+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13796 39322 swimming_water_temperature 2020-08-15T10:35:22.380884+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13775 39568 swimming_water_temperature 2020-08-15T08:32:06.194728+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13774 39815 swimming_water_temperature 2020-08-14T18:46:59.477704+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13772 39693 swimming_water_temperature 2020-08-14T18:42:33.748153+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13769 39583 swimming_water_temperature 2020-08-14T17:53:07.050472+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13765 39815 swimming_water_temperature 2020-08-14T14:20:40.988035+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13762 39583 swimming_water_temperature 2020-08-14T13:46:11.499356+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13760 39693 swimming_water_temperature 2020-08-14T12:33:22.192086+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13758 39322 swimming_water_temperature 2020-08-14T11:27:10.378148+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13755 39583 swimming_water_temperature 2020-08-14T10:07:32.848389+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13752 39815 swimming_water_temperature 2020-08-14T09:52:40.512337+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13733 39815 swimming_water_temperature 2020-08-13T19:02:44.722945+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13731 39322 swimming_water_temperature 2020-08-13T18:58:39.993882+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13729 39693 swimming_water_temperature 2020-08-13T18:30:14.317739+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13727 39815 swimming_water_temperature 2020-08-13T15:01:22.268718+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13726 39322 swimming_water_temperature 2020-08-13T14:31:00.540025+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13723 39815 swimming_water_temperature 2020-08-13T14:00:51.236478+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13717 39583 swimming_water_temperature 2020-08-13T12:05:18.215525+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13714 39815 swimming_water_temperature 2020-08-13T10:36:22.421956+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13712 39322 swimming_water_temperature 2020-08-13T10:02:57.398810+0300     19-21°C   19-21°C 0 19-21°C 19-21 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  
13682 39815 swimming_water_temperature 2020-08-13T08:19:45.536904+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13681 39815 swimming_water_temperature 2020-08-12T18:55:01.191676+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13679 39322 swimming_water_temperature 2020-08-12T18:41:06.969147+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13676 39583 swimming_water_temperature 2020-08-12T17:47:11.639366+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13673 39815 swimming_water_temperature 2020-08-12T14:10:12.180913+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13670 39815 swimming_water_temperature 2020-08-12T14:09:06.160694+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13666 39583 swimming_water_temperature 2020-08-12T14:07:51.962436+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13663 39693 swimming_water_temperature 2020-08-12T14:06:20.816129+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13661 39693 swimming_water_temperature 2020-08-12T14:02:47.519936+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13659 39322 swimming_water_temperature 2020-08-12T13:56:54.987149+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13640 39583 swimming_water_temperature 2020-08-12T10:12:53.678697+0300     17-19°C   17-19°C 0 17-19°C 17-19 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  
13634 39322 swimming_water_temperature 2020-08-12T09:56:50.857383+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13632 39693 swimming_water_temperature 2020-08-11T18:11:24.202010+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13630 39693 swimming_water_temperature 2020-08-11T17:53:29.036539+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13627 39583 swimming_water_temperature 2020-08-11T15:05:28.234604+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13625 39322 swimming_water_temperature 2020-08-11T14:16:12.084130+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13623 39693 swimming_water_temperature 2020-08-11T14:01:30.649371+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13621 39527 swimming_water_temperature 2020-08-11T13:44:34.401530+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13619 39322 swimming_water_temperature 2020-08-11T11:56:45.959411+0300     19-21°C   19-21°C 0 19-21°C 19-21 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  

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
);