observation
180 rows where name_en = "above 23°C" sorted by id 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 |
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 );