observation

180 rows where name_en = "above 23°C" sorted by unit

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

name_en ✖

  • above 23°C · 180 ✖
id unit ▼ property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
4338 39267 swimming_water_temperature 2019-07-26T14:08:48.575391+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4346 39267 swimming_water_temperature 2019-07-26T17:32:52.575018+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4477 39267 swimming_water_temperature 2019-07-27T17:44:10.582720+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4547 39267 swimming_water_temperature 2019-07-28T17:51:24.318070+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4604 39267 swimming_water_temperature 2019-07-29T10:01:43.611270+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4669 39267 swimming_water_temperature 2019-07-29T16:29:33.675718+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4678 39267 swimming_water_temperature 2019-07-29T17:45:23.075920+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4063 39322 swimming_water_temperature 2019-07-24T14:18:36.028851+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4070 39322 swimming_water_temperature 2019-07-24T17:49:13.043673+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4161 39322 swimming_water_temperature 2019-07-25T12:45:29.700086+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4180 39322 swimming_water_temperature 2019-07-25T14:06:58.048721+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4203 39322 swimming_water_temperature 2019-07-25T17:56:30.488448+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4353 39322 swimming_water_temperature 2019-07-26T18:01:04.396061+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4392 39322 swimming_water_temperature 2019-07-27T10:00:45.420185+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4479 39322 swimming_water_temperature 2019-07-27T17:45:55.150610+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4555 39322 swimming_water_temperature 2019-07-28T18:06:08.842456+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4615 39322 swimming_water_temperature 2019-07-29T10:11:15.826929+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4663 39322 swimming_water_temperature 2019-07-29T14:23:16.678223+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4677 39322 swimming_water_temperature 2019-07-29T17:45:22.217619+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
9607 39322 swimming_water_temperature 2020-06-17T14:19:18.096819+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
9682 39322 swimming_water_temperature 2020-06-18T14:00:17.799570+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
9866 39322 swimming_water_temperature 2020-06-22T14:03:39.396058+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
9882 39322 swimming_water_temperature 2020-06-22T18:01:46.615473+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
9928 39322 swimming_water_temperature 2020-06-23T10:10:44.019821+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
9989 39322 swimming_water_temperature 2020-06-23T14:11:02.617590+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10005 39322 swimming_water_temperature 2020-06-23T18:36:53.231384+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10038 39322 swimming_water_temperature 2020-06-24T10:02:52.592545+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10085 39322 swimming_water_temperature 2020-06-24T13:58:06.001512+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10096 39322 swimming_water_temperature 2020-06-24T18:12:32.504006+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10124 39322 swimming_water_temperature 2020-06-25T09:59:19.912704+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10166 39322 swimming_water_temperature 2020-06-25T14:14:51.498763+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10179 39322 swimming_water_temperature 2020-06-25T18:01:40.262239+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10223 39322 swimming_water_temperature 2020-06-26T10:24:09.487236+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10270 39322 swimming_water_temperature 2020-06-26T14:16:15.957267+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10323 39322 swimming_water_temperature 2020-06-27T10:39:02.328595+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10349 39322 swimming_water_temperature 2020-06-27T14:10:15.808817+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10350 39322 swimming_water_temperature 2020-06-27T14:10:26.078149+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10393 39322 swimming_water_temperature 2020-06-28T10:19:46.641853+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10422 39322 swimming_water_temperature 2020-06-28T14:13:00.933100+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10498 39322 swimming_water_temperature 2020-06-29T11:16:05.524715+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10505 39322 swimming_water_temperature 2020-06-29T14:04:31.971744+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10512 39322 swimming_water_temperature 2020-06-29T17:51:58.962965+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
11861 39322 swimming_water_temperature 2020-07-19T18:09:35.905875+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10371 39412 swimming_water_temperature 2020-06-28T09:17:49.501789+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10411 39527 swimming_water_temperature 2020-06-28T12:49:52.473929+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10098 39568 swimming_water_temperature 2020-06-24T18:44:59.432352+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4335 39583 swimming_water_temperature 2019-07-26T14:08:04.824195+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4350 39583 swimming_water_temperature 2019-07-26T17:46:30.519006+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4541 39583 swimming_water_temperature 2019-07-28T17:20:37.309044+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4542 39583 swimming_water_temperature 2019-07-28T17:20:48.495620+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4657 39583 swimming_water_temperature 2019-07-29T13:34:55.577984+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4673 39583 swimming_water_temperature 2019-07-29T17:27:26.194311+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4674 39583 swimming_water_temperature 2019-07-29T17:27:37.996541+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
9987 39583 swimming_water_temperature 2020-06-23T14:04:03.025272+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
9995 39583 swimming_water_temperature 2020-06-23T17:40:44.919744+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10049 39583 swimming_water_temperature 2020-06-24T10:18:50.290180+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10087 39583 swimming_water_temperature 2020-06-24T14:00:08.447304+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10091 39583 swimming_water_temperature 2020-06-24T17:44:09.829835+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10142 39583 swimming_water_temperature 2020-06-25T10:15:45.758026+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10163 39583 swimming_water_temperature 2020-06-25T13:57:37.920197+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10173 39583 swimming_water_temperature 2020-06-25T17:41:09.153987+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10217 39583 swimming_water_temperature 2020-06-26T10:21:42.346187+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10274 39583 swimming_water_temperature 2020-06-26T14:25:47.452954+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10279 39583 swimming_water_temperature 2020-06-26T17:47:05.296119+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10314 39583 swimming_water_temperature 2020-06-27T10:15:35.353006+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10352 39583 swimming_water_temperature 2020-06-27T14:14:20.446472+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10356 39583 swimming_water_temperature 2020-06-27T17:44:58.754837+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10391 39583 swimming_water_temperature 2020-06-28T10:15:42.177052+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10420 39583 swimming_water_temperature 2020-06-28T14:04:47.285385+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10452 39583 swimming_water_temperature 2020-06-28T17:42:36.153938+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10490 39583 swimming_water_temperature 2020-06-29T10:35:38.730708+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4382 39693 swimming_water_temperature 2019-07-27T09:38:57.454049+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4430 39693 swimming_water_temperature 2019-07-27T10:23:15.234079+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4432 39693 swimming_water_temperature 2019-07-27T10:23:33.196850+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4481 39693 swimming_water_temperature 2019-07-27T17:56:24.705394+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4531 39693 swimming_water_temperature 2019-07-28T14:35:09.808986+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4532 39693 swimming_water_temperature 2019-07-28T14:45:56.711015+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4552 39693 swimming_water_temperature 2019-07-28T18:01:57.460940+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10089 39693 swimming_water_temperature 2020-06-24T14:33:09.771137+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10121 39693 swimming_water_temperature 2020-06-25T09:58:39.408969+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10168 39693 swimming_water_temperature 2020-06-25T14:42:11.310041+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10182 39693 swimming_water_temperature 2020-06-25T18:14:31.169484+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10220 39693 swimming_water_temperature 2020-06-26T10:23:44.683113+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10272 39693 swimming_water_temperature 2020-06-26T14:21:48.433310+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10282 39693 swimming_water_temperature 2020-06-26T18:02:43.768481+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10308 39693 swimming_water_temperature 2020-06-27T10:08:11.278637+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10347 39693 swimming_water_temperature 2020-06-27T13:54:53.618726+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10358 39693 swimming_water_temperature 2020-06-27T18:08:38.876359+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10375 39693 swimming_water_temperature 2020-06-28T09:47:00.711127+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10424 39693 swimming_water_temperature 2020-06-28T14:48:00.687629+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10454 39693 swimming_water_temperature 2020-06-28T18:14:37.195346+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10455 39693 swimming_water_temperature 2020-06-28T18:14:56.991933+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4474 39815 swimming_water_temperature 2019-07-27T17:41:54.574327+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4485 39815 swimming_water_temperature 2019-07-27T20:33:09.382850+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4520 39815 swimming_water_temperature 2019-07-28T13:58:05.603518+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4550 39815 swimming_water_temperature 2019-07-28T17:57:03.719199+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
5897 39815 swimming_water_temperature 2019-08-19T16:08:38.740058+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
9621 39815 swimming_water_temperature 2020-06-17T17:58:54.496045+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
9693 39815 swimming_water_temperature 2020-06-18T17:52:52.852145+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
9879 39815 swimming_water_temperature 2020-06-22T17:59:57.791073+0300     yli 23°C   över 23°C 0 above 23°C 23-100 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
);