observation

746 rows where value = "21-23" sorted by unit

✎ View and edit SQL

This data as json, CSV (advanced)

value ✖

  • 21-23 · 746 ✖
id unit ▼ property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
296 39267 swimming_water_temperature 2019-06-08T17:01:07.633245+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
301 39267 swimming_water_temperature 2019-06-08T17:58:54.777603+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
339 39267 swimming_water_temperature 2019-06-09T10:21:42.793020+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
374 39267 swimming_water_temperature 2019-06-09T17:54:11.286114+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
933 39267 swimming_water_temperature 2019-06-17T13:59:33.608988+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
1359 39267 swimming_water_temperature 2019-06-24T10:07:46.646036+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
1426 39267 swimming_water_temperature 2019-06-24T14:13:53.042983+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
1443 39267 swimming_water_temperature 2019-06-24T17:46:11.049406+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
1499 39267 swimming_water_temperature 2019-06-25T13:56:36.662049+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
1537 39267 swimming_water_temperature 2019-06-25T17:45:23.883233+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
1556 39267 swimming_water_temperature 2019-06-26T10:21:48.404757+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
1578 39267 swimming_water_temperature 2019-06-26T14:04:59.960700+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
1589 39267 swimming_water_temperature 2019-06-26T18:01:29.156373+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
1755 39267 swimming_water_temperature 2019-06-28T12:30:03.099858+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3656 39267 swimming_water_temperature 2019-07-21T10:40:00.785107+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3684 39267 swimming_water_temperature 2019-07-21T14:16:04.111380+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  
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  
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  
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  
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  
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  
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  
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  
4201 39267 swimming_water_temperature 2019-07-25T17:48:45.083968+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4254 39267 swimming_water_temperature 2019-07-26T10:04:13.204558+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4526 39267 swimming_water_temperature 2019-07-28T14:26:37.323033+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4546 39267 swimming_water_temperature 2019-07-28T17:51:04.366394+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4693 39267 swimming_water_temperature 2019-07-30T10:02:12.366747+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4742 39267 swimming_water_temperature 2019-07-30T15:03:15.597544+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4748 39267 swimming_water_temperature 2019-07-30T17:56:11.499554+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4889 39267 swimming_water_temperature 2019-08-01T10:21:41.840771+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4891 39267 swimming_water_temperature 2019-08-01T10:22:31.076396+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9545 39267 swimming_water_temperature 2020-06-17T08:55:10.220727+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9902 39267 swimming_water_temperature 2020-06-23T09:47:45.753569+0300     21-23°C   21-23°C 0 21-23°C 21-23 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  
222 39322 swimming_water_temperature 2019-06-07T11:23:40.887777+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
224 39322 swimming_water_temperature 2019-06-07T11:35:37.055471+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
226 39322 swimming_water_temperature 2019-06-07T11:35:37.494252+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
228 39322 swimming_water_temperature 2019-06-07T11:35:37.963596+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
244 39322 swimming_water_temperature 2019-06-07T15:15:49.773357+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
245 39322 swimming_water_temperature 2019-06-07T15:17:51.123747+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
1180 39322 swimming_water_temperature 2019-06-20T13:58:38.404204+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
1448 39322 swimming_water_temperature 2019-06-24T17:52:07.245628+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3388 39322 swimming_water_temperature 2019-07-18T17:59:16.367615+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3589 39322 swimming_water_temperature 2019-07-20T14:02:13.169518+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3676 39322 swimming_water_temperature 2019-07-21T14:01:53.621932+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3700 39322 swimming_water_temperature 2019-07-21T18:17:28.032777+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  
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  
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  
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  
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  
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  
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  
4259 39322 swimming_water_temperature 2019-07-26T10:09:11.901961+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
4331 39322 swimming_water_temperature 2019-07-26T13:56:57.833553+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9433 39322 swimming_water_temperature 2020-06-15T14:22:06.501545+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9449 39322 swimming_water_temperature 2020-06-15T17:58:36.660246+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9451 39322 swimming_water_temperature 2020-06-15T18:00:09.879986+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9514 39322 swimming_water_temperature 2020-06-16T13:57:00.836013+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9530 39322 swimming_water_temperature 2020-06-16T18:13:22.405195+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9619 39322 swimming_water_temperature 2020-06-17T17:58:39.289578+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9637 39322 swimming_water_temperature 2020-06-18T09:34:16.800503+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9694 39322 swimming_water_temperature 2020-06-18T18:05:33.552939+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9696 39322 swimming_water_temperature 2020-06-18T18:16:54.025644+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9821 39322 swimming_water_temperature 2020-06-22T09:46:24.984534+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
9890 39322 swimming_water_temperature 2020-06-23T09:14:45.440058+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  
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  
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  
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  
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  
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  
10887 39322 swimming_water_temperature 2020-07-05T13:52:09.847845+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11669 39322 swimming_water_temperature 2020-07-16T17:43:52.451862+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11748 39322 swimming_water_temperature 2020-07-17T18:36:51.833212+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11808 39322 swimming_water_temperature 2020-07-18T14:22:15.370296+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11903 39322 swimming_water_temperature 2020-07-20T10:32:54.044403+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11944 39322 swimming_water_temperature 2020-07-20T13:48:08.903081+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11957 39322 swimming_water_temperature 2020-07-20T18:25:08.056848+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12036 39322 swimming_water_temperature 2020-07-21T14:45:24.210012+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12048 39322 swimming_water_temperature 2020-07-21T18:03:19.242010+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12138 39322 swimming_water_temperature 2020-07-22T18:49:41.083565+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12516 39322 swimming_water_temperature 2020-07-27T17:58:20.423133+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13467 39322 swimming_water_temperature 2020-08-08T14:05:25.658428+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13496 39322 swimming_water_temperature 2020-08-09T10:11:30.826163+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13522 39322 swimming_water_temperature 2020-08-09T13:57:03.168042+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13571 39322 swimming_water_temperature 2020-08-10T14:05:09.050466+0300     21-23°C   21-23°C 0 21-23°C 21-23 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  
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  
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  
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  
9588 39368 swimming_water_temperature 2020-06-17T11:01:36.486371+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11984 39368 swimming_water_temperature 2020-07-21T10:20:29.344918+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13577 39368 swimming_water_temperature 2020-08-10T14:25:22.663454+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  
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  
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  

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