observation
180 rows where name_en = "above 23°C" sorted by unit descending
This data as json, CSV (advanced)
Suggested facets: unit
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );