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

View and edit SQL

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
3796 52959 swimming_water_temperature 2019-07-22T11:57:18.259840+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10239 52959 swimming_water_temperature 2020-06-26T12:16:47.575496+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10336 52959 swimming_water_temperature 2020-06-27T11:37:39.656172+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10170 50549 swimming_water_temperature 2020-06-25T15:52:31.200307+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
9944 42114 swimming_water_temperature 2020-06-23T10:39:26.530085+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4517 41791 swimming_water_temperature 2019-07-28T12:05:36.618319+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10119 41791 swimming_water_temperature 2020-06-25T09:55:48.016223+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10203 41791 swimming_water_temperature 2020-06-26T10:03:48.535123+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10302 41791 swimming_water_temperature 2020-06-27T09:40:46.163841+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10387 41791 swimming_water_temperature 2020-06-28T10:10:00.933659+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
5016 41601 swimming_water_temperature 2019-08-02T11:04:12.415904+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10230 41601 swimming_water_temperature 2020-06-26T10:45:43.032483+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10325 41601 swimming_water_temperature 2020-06-27T10:46:29.040693+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10397 41601 swimming_water_temperature 2020-06-28T10:21:45.738030+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10474 41601 swimming_water_temperature 2020-06-29T10:01:13.601517+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10403 40993 swimming_water_temperature 2020-06-28T10:46:39.854154+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10480 40993 swimming_water_temperature 2020-06-29T10:11:01.952659+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4441 40802 swimming_water_temperature 2019-07-27T11:17:20.656154+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4445 40802 swimming_water_temperature 2019-07-27T11:18:06.473872+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4504 40802 swimming_water_temperature 2019-07-28T10:14:32.159414+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
9959 40802 swimming_water_temperature 2020-06-23T12:33:55.573832+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10043 40802 swimming_water_temperature 2020-06-24T10:07:59.303282+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10145 40802 swimming_water_temperature 2020-06-25T10:28:26.644148+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4523 40798 swimming_water_temperature 2019-07-28T14:03:56.769490+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4525 40798 swimming_water_temperature 2019-07-28T14:04:38.193748+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10304 40559 swimming_water_temperature 2020-06-27T09:58:47.210297+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
3921 40386 swimming_water_temperature 2019-07-23T14:19:00.682961+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4134 40386 swimming_water_temperature 2019-07-25T10:32:31.324151+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4263 40386 swimming_water_temperature 2019-07-26T10:11:50.996205+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4384 40386 swimming_water_temperature 2019-07-27T09:56:30.238288+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4613 40386 swimming_water_temperature 2019-07-29T10:07:48.223180+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4695 40386 swimming_water_temperature 2019-07-30T10:10:41.020619+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
9948 40386 swimming_water_temperature 2020-06-23T10:57:21.533592+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10133 40386 swimming_water_temperature 2020-06-25T10:03:30.461510+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10211 40386 swimming_water_temperature 2020-06-26T10:10:18.485002+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10312 40386 swimming_water_temperature 2020-06-27T10:14:18.411395+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10395 40386 swimming_water_temperature 2020-06-28T10:20:40.121635+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10476 40386 swimming_water_temperature 2020-06-29T10:07:18.208533+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10531 40386 swimming_water_temperature 2020-06-30T10:07:02.952836+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
9731 40157 swimming_water_temperature 2020-06-19T10:05:14.406938+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10023 40157 swimming_water_temperature 2020-06-24T09:51:18.809470+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10113 40157 swimming_water_temperature 2020-06-25T09:52:17.687290+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10196 40157 swimming_water_temperature 2020-06-26T09:53:55.214804+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10306 40157 swimming_water_temperature 2020-06-27T10:00:30.762267+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10385 40157 swimming_water_temperature 2020-06-28T10:06:38.523736+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10473 40157 swimming_water_temperature 2020-06-29T09:56:52.252559+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10056 40150 swimming_water_temperature 2020-06-24T10:29:58.644436+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10149 40150 swimming_water_temperature 2020-06-25T10:40:59.740282+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10160 40150 swimming_water_temperature 2020-06-25T13:56:22.084914+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
2313 40142 swimming_water_temperature 2019-07-05T12:05:28.533577+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10200 40142 swimming_water_temperature 2020-06-26T09:56:48.346620+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10332 40142 swimming_water_temperature 2020-06-27T11:30:10.225909+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10408 40142 swimming_water_temperature 2020-06-28T11:06:05.513140+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10252 40020 swimming_water_temperature 2020-06-26T13:34:28.554066+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10427 40020 swimming_water_temperature 2020-06-28T16:38:40.241914+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10365 39902 swimming_water_temperature 2020-06-28T08:10:22.365351+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4593 39881 swimming_water_temperature 2019-07-29T09:02:08.108373+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
4569 39846 swimming_water_temperature 2019-07-28T19:51:48.363528+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  
9983 39815 swimming_water_temperature 2020-06-23T14:03:21.225739+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
9999 39815 swimming_water_temperature 2020-06-23T17:44:41.466315+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10032 39815 swimming_water_temperature 2020-06-24T09:58:05.801997+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10094 39815 swimming_water_temperature 2020-06-24T17:56:55.522819+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10137 39815 swimming_water_temperature 2020-06-25T10:09:33.856396+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10157 39815 swimming_water_temperature 2020-06-25T13:47:59.453891+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10177 39815 swimming_water_temperature 2020-06-25T17:47:30.990529+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10208 39815 swimming_water_temperature 2020-06-26T10:05:31.710623+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10263 39815 swimming_water_temperature 2020-06-26T13:53:15.779518+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10277 39815 swimming_water_temperature 2020-06-26T17:33:58.755629+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10315 39815 swimming_water_temperature 2020-06-27T10:15:40.965867+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10343 39815 swimming_water_temperature 2020-06-27T13:54:05.459550+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10354 39815 swimming_water_temperature 2020-06-27T17:44:03.018759+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10373 39815 swimming_water_temperature 2020-06-28T09:45:28.542941+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10416 39815 swimming_water_temperature 2020-06-28T13:46:35.002089+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10450 39815 swimming_water_temperature 2020-06-28T17:34:25.641034+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10468 39815 swimming_water_temperature 2020-06-29T09:33:46.664255+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
11810 39815 swimming_water_temperature 2020-07-18T17:44:37.477328+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
11859 39815 swimming_water_temperature 2020-07-19T18:00:48.913708+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
12034 39815 swimming_water_temperature 2020-07-21T14:37:14.601685+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
12046 39815 swimming_water_temperature 2020-07-21T17:54:29.112075+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
13529 39815 swimming_water_temperature 2020-08-09T17:51:53.321131+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  

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