observation

746 rows where value = "21-23"

✎ View and edit SQL

This data as json, CSV (advanced)

value ✖

  • 21-23 · 646 ✖
id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
3727 40020 swimming_water_temperature 2019-07-22T08:15:38.866993+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3733 40921 swimming_water_temperature 2019-07-22T08:16:24.279440+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3735 39823 swimming_water_temperature 2019-07-22T08:16:40.107990+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3736 39910 swimming_water_temperature 2019-07-22T08:16:42.547882+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3738 40798 swimming_water_temperature 2019-07-22T08:17:02.714892+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3742 40993 swimming_water_temperature 2019-07-22T08:17:35.492919+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3754 39902 swimming_water_temperature 2019-07-22T09:34:57.155273+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3768 39322 swimming_water_temperature 2019-07-22T10:04:21.673127+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3772 40098 swimming_water_temperature 2019-07-22T10:08:01.858151+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3776 41960 swimming_water_temperature 2019-07-22T10:08:20.466247+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3779 40157 swimming_water_temperature 2019-07-22T10:09:06.198105+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3780 40386 swimming_water_temperature 2019-07-22T10:12:55.367129+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3787 39267 swimming_water_temperature 2019-07-22T10:30:29.201404+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3790 40802 swimming_water_temperature 2019-07-22T10:32:32.624333+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3802 39267 swimming_water_temperature 2019-07-22T14:07:58.998499+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3813 39267 swimming_water_temperature 2019-07-22T17:42:43.626233+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3815 39815 swimming_water_temperature 2019-07-22T18:01:58.683573+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3819 39693 swimming_water_temperature 2019-07-22T18:07:32.680206+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3822 39322 swimming_water_temperature 2019-07-22T18:20:20.549804+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3844 41960 swimming_water_temperature 2019-07-23T09:57:23.475427+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3845 40802 swimming_water_temperature 2019-07-23T09:57:26.088591+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3851 40386 swimming_water_temperature 2019-07-23T10:02:53.617630+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3853 39322 swimming_water_temperature 2019-07-23T10:04:59.367446+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3856 41791 swimming_water_temperature 2019-07-23T10:07:05.270162+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3861 40142 swimming_water_temperature 2019-07-23T10:10:47.790739+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3869 39823 swimming_water_temperature 2019-07-23T10:14:56.112431+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3871 53461 swimming_water_temperature 2019-07-23T10:15:20.508506+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3873 40142 swimming_water_temperature 2019-07-23T10:15:39.824730+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3891 39267 swimming_water_temperature 2019-07-23T10:28:44.044986+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3894 40098 swimming_water_temperature 2019-07-23T10:32:38.256934+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3897 40157 swimming_water_temperature 2019-07-23T10:35:05.797938+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3899 39606 swimming_water_temperature 2019-07-23T10:37:15.810757+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3913 39902 swimming_water_temperature 2019-07-23T13:29:44.254069+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3915 39412 swimming_water_temperature 2019-07-23T13:30:21.949031+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3917 39875 swimming_water_temperature 2019-07-23T13:30:51.355982+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3919 39368 swimming_water_temperature 2019-07-23T13:45:48.253194+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3922 39568 swimming_water_temperature 2019-07-23T14:24:24.183616+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3924 39322 swimming_water_temperature 2019-07-23T14:30:21.199704+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3926 39527 swimming_water_temperature 2019-07-23T14:49:50.868225+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3931 39267 swimming_water_temperature 2019-07-23T17:39:38.202978+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3933 39693 swimming_water_temperature 2019-07-23T17:52:31.062728+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3937 39322 swimming_water_temperature 2019-07-23T18:08:28.237910+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3940 39815 swimming_water_temperature 2019-07-23T18:12:28.270739+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3945 39823 swimming_water_temperature 2019-07-23T18:33:35.474151+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3951 40802 swimming_water_temperature 2019-07-24T09:43:07.364054+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3955 39322 swimming_water_temperature 2019-07-24T09:58:46.245526+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3960 39267 swimming_water_temperature 2019-07-24T10:00:56.694968+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3967 41960 swimming_water_temperature 2019-07-24T10:03:01.210742+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3969 40386 swimming_water_temperature 2019-07-24T10:04:52.163889+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3972 39583 swimming_water_temperature 2019-07-24T10:05:56.668045+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3973 40142 swimming_water_temperature 2019-07-24T10:06:00.268395+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3977 40098 swimming_water_temperature 2019-07-24T10:06:30.218952+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3993 40157 swimming_water_temperature 2019-07-24T10:21:00.198042+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4015 39846 swimming_water_temperature 2019-07-24T11:09:21.716218+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4017 39881 swimming_water_temperature 2019-07-24T11:09:36.386177+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4019 39667 swimming_water_temperature 2019-07-24T11:09:52.605406+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4035 39412 swimming_water_temperature 2019-07-24T12:21:30.083616+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4039 53461 swimming_water_temperature 2019-07-24T13:39:12.456069+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4041 42114 swimming_water_temperature 2019-07-24T13:39:38.862633+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4045 39815 swimming_water_temperature 2019-07-24T13:52:36.138697+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4048 40798 swimming_water_temperature 2019-07-24T13:57:52.966373+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4051 40677 swimming_water_temperature 2019-07-24T13:58:16.721591+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4053 40020 swimming_water_temperature 2019-07-24T14:02:34.038140+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4055 40921 swimming_water_temperature 2019-07-24T14:03:29.608072+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4057 41326 swimming_water_temperature 2019-07-24T14:03:39.399941+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4058 39583 swimming_water_temperature 2019-07-24T14:13:16.341166+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4065 39815 swimming_water_temperature 2019-07-24T17:45:54.075943+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4068 39267 swimming_water_temperature 2019-07-24T17:48:03.304207+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4072 39583 swimming_water_temperature 2019-07-24T17:53:07.267796+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4077 39823 swimming_water_temperature 2019-07-25T07:51:43.048027+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4079 40076 swimming_water_temperature 2019-07-25T07:58:18.721904+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4081 53461 swimming_water_temperature 2019-07-25T08:10:25.773596+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4083 39606 swimming_water_temperature 2019-07-25T08:31:30.092247+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4085 39902 swimming_water_temperature 2019-07-25T09:00:47.078139+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4087 39875 swimming_water_temperature 2019-07-25T09:18:45.454083+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4092 39713 swimming_water_temperature 2019-07-25T09:39:45.401945+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4096 41960 swimming_water_temperature 2019-07-25T10:02:02.082335+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4099 40157 swimming_water_temperature 2019-07-25T10:03:54.749354+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4101 41791 swimming_water_temperature 2019-07-25T10:06:19.660935+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4103 40098 swimming_water_temperature 2019-07-25T10:07:38.159099+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4104 41601 swimming_water_temperature 2019-07-25T10:07:50.592926+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4106 40142 swimming_water_temperature 2019-07-25T10:08:13.026036+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4112 39267 swimming_water_temperature 2019-07-25T10:15:52.017826+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4114 39583 swimming_water_temperature 2019-07-25T10:17:15.462483+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4121 39815 swimming_water_temperature 2019-07-25T10:24:37.172999+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4125 39815 swimming_water_temperature 2019-07-25T10:24:50.605719+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4132 40150 swimming_water_temperature 2019-07-25T10:30:18.076161+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4138 40098 swimming_water_temperature 2019-07-25T10:38:02.295753+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4143 40802 swimming_water_temperature 2019-07-25T10:52:23.442060+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4145 39412 swimming_water_temperature 2019-07-25T10:55:55.890977+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4160 39322 swimming_water_temperature 2019-07-25T12:40:00.256076+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4164 39846 swimming_water_temperature 2019-07-25T13:49:44.753583+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4165 39881 swimming_water_temperature 2019-07-25T13:49:47.454386+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4167 39897 swimming_water_temperature 2019-07-25T13:49:54.851485+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4170 39784 swimming_water_temperature 2019-07-25T13:50:11.424036+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4173 39815 swimming_water_temperature 2019-07-25T13:55:20.699652+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4176 39267 swimming_water_temperature 2019-07-25T14:04:46.430645+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4178 39583 swimming_water_temperature 2019-07-25T14:05:41.672201+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4183 39693 swimming_water_temperature 2019-07-25T14:12:17.180466+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4190 40098 swimming_water_temperature 2019-07-25T16:36:39.713202+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
);