observation
497 rows where name_en = "below 15°C" sorted by id descending
This data as json, CSV (advanced)
id ▲ | unit | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24082 | 39322 | swimming_water_temperature | 2020-10-14T11:05:00.666183+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
13436 | 40258 | swimming_water_temperature | 2020-08-08T09:55:35.945642+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
13391 | 40150 | swimming_water_temperature | 2020-08-07T10:07:37.960100+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
13383 | 40258 | swimming_water_temperature | 2020-08-07T09:59:38.066374+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
13311 | 40150 | swimming_water_temperature | 2020-08-06T10:38:05.990688+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
13307 | 40258 | swimming_water_temperature | 2020-08-06T10:34:53.428759+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
13238 | 40150 | swimming_water_temperature | 2020-08-05T10:29:28.995748+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
13204 | 40258 | swimming_water_temperature | 2020-08-05T09:49:54.462443+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
13145 | 40950 | swimming_water_temperature | 2020-08-04T10:39:58.411213+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
13138 | 40258 | swimming_water_temperature | 2020-08-04T10:10:25.455296+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
13028 | 40950 | swimming_water_temperature | 2020-08-03T10:05:00.626281+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12880 | 40258 | swimming_water_temperature | 2020-08-01T11:53:15.490628+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12836 | 40950 | swimming_water_temperature | 2020-07-31T15:56:26.300164+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12833 | 40258 | swimming_water_temperature | 2020-07-31T15:38:41.546188+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12721 | 40150 | swimming_water_temperature | 2020-07-30T10:08:47.465058+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12667 | 40150 | swimming_water_temperature | 2020-07-29T12:22:15.155990+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12654 | 40258 | swimming_water_temperature | 2020-07-29T10:27:44.861896+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12637 | 40950 | swimming_water_temperature | 2020-07-29T10:00:36.968322+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12607 | 39527 | swimming_water_temperature | 2020-07-29T08:18:14.666008+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12555 | 40950 | swimming_water_temperature | 2020-07-28T10:14:28.059640+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12548 | 40150 | swimming_water_temperature | 2020-07-28T10:06:55.029458+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12543 | 40258 | swimming_water_temperature | 2020-07-28T09:55:47.988941+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12520 | 39527 | swimming_water_temperature | 2020-07-28T08:13:31.183734+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12477 | 40150 | swimming_water_temperature | 2020-07-27T10:14:50.914921+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12470 | 40950 | swimming_water_temperature | 2020-07-27T10:07:18.896436+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12453 | 40258 | swimming_water_temperature | 2020-07-27T09:54:33.679569+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12397 | 39568 | swimming_water_temperature | 2020-07-26T13:52:09.139325+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12384 | 40950 | swimming_water_temperature | 2020-07-26T10:17:15.003847+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12381 | 40802 | swimming_water_temperature | 2020-07-26T10:12:52.387329+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12377 | 39527 | swimming_water_temperature | 2020-07-26T10:08:03.937303+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12374 | 40150 | swimming_water_temperature | 2020-07-26T10:03:26.082448+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12361 | 39568 | swimming_water_temperature | 2020-07-26T09:15:09.797332+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12341 | 41470 | swimming_water_temperature | 2020-07-25T10:38:53.185775+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12334 | 52959 | swimming_water_temperature | 2020-07-25T10:16:05.943571+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12332 | 40950 | swimming_water_temperature | 2020-07-25T10:13:04.503262+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12327 | 40150 | swimming_water_temperature | 2020-07-25T10:07:12.795100+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12311 | 40258 | swimming_water_temperature | 2020-07-25T09:37:06.003997+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12309 | 39527 | swimming_water_temperature | 2020-07-25T09:09:41.896741+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12290 | 52959 | swimming_water_temperature | 2020-07-24T11:46:24.627599+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12288 | 40150 | swimming_water_temperature | 2020-07-24T11:04:52.932452+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12276 | 40950 | swimming_water_temperature | 2020-07-24T10:10:27.779181+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12266 | 40258 | swimming_water_temperature | 2020-07-24T09:55:14.986891+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12230 | 39568 | swimming_water_temperature | 2020-07-24T08:26:07.613327+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12227 | 39527 | swimming_water_temperature | 2020-07-24T07:56:18.925684+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12171 | 40950 | swimming_water_temperature | 2020-07-23T10:11:34.974694+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12162 | 40559 | swimming_water_temperature | 2020-07-23T09:59:21.709960+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12159 | 40258 | swimming_water_temperature | 2020-07-23T09:59:12.376200+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12152 | 52959 | swimming_water_temperature | 2020-07-23T09:24:34.979564+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12148 | 39568 | swimming_water_temperature | 2020-07-23T09:02:05.133213+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12146 | 39527 | swimming_water_temperature | 2020-07-23T08:40:28.331757+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12108 | 40150 | swimming_water_temperature | 2020-07-22T10:27:17.272403+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
12085 | 40258 | swimming_water_temperature | 2020-07-22T09:50:17.482295+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11623 | 40258 | swimming_water_temperature | 2020-07-16T09:55:40.437874+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11604 | 39527 | swimming_water_temperature | 2020-07-15T15:43:25.351708+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11602 | 52959 | swimming_water_temperature | 2020-07-15T15:43:04.683917+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11590 | 52958 | swimming_water_temperature | 2020-07-15T11:59:56.825402+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11548 | 40950 | swimming_water_temperature | 2020-07-15T10:15:59.697752+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11515 | 39527 | swimming_water_temperature | 2020-07-14T22:54:47.249613+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11504 | 52959 | swimming_water_temperature | 2020-07-14T16:19:00.271428+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11460 | 40150 | swimming_water_temperature | 2020-07-14T10:11:40.998155+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11455 | 40950 | swimming_water_temperature | 2020-07-14T10:10:00.766169+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11448 | 41960 | swimming_water_temperature | 2020-07-14T09:58:52.861796+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11375 | 41960 | swimming_water_temperature | 2020-07-13T10:07:25.583162+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11372 | 40950 | swimming_water_temperature | 2020-07-13T10:06:53.019262+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11330 | 39568 | swimming_water_temperature | 2020-07-12T14:06:13.325033+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11328 | 39527 | swimming_water_temperature | 2020-07-12T14:06:02.422587+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11326 | 52959 | swimming_water_temperature | 2020-07-12T14:05:48.899069+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11314 | 40950 | swimming_water_temperature | 2020-07-12T10:14:32.995007+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11293 | 41960 | swimming_water_temperature | 2020-07-12T09:53:44.221833+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11275 | 40802 | swimming_water_temperature | 2020-07-11T10:23:17.493815+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11248 | 39568 | swimming_water_temperature | 2020-07-10T23:54:23.312656+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11246 | 52959 | swimming_water_temperature | 2020-07-10T23:54:07.006257+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11205 | 39568 | swimming_water_temperature | 2020-07-10T12:56:56.750866+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11201 | 40802 | swimming_water_temperature | 2020-07-10T12:22:19.917875+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11160 | 39527 | swimming_water_temperature | 2020-07-10T08:09:36.055647+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
11076 | 40802 | swimming_water_temperature | 2020-07-08T11:30:53.761726+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
9162 | 40993 | swimming_water_temperature | 2020-06-12T10:01:32.478351+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
9087 | 58015 | swimming_water_temperature | 2020-06-11T10:04:27.738654+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
9061 | 40258 | swimming_water_temperature | 2020-06-11T10:00:10.501231+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
9054 | 40559 | swimming_water_temperature | 2020-06-11T09:54:03.877372+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
9048 | 40993 | swimming_water_temperature | 2020-06-11T09:45:46.700792+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8985 | 40258 | swimming_water_temperature | 2020-06-10T10:04:51.542902+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8975 | 39693 | swimming_water_temperature | 2020-06-10T09:53:51.612783+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8971 | 40993 | swimming_water_temperature | 2020-06-10T09:52:56.247097+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8946 | 52959 | swimming_water_temperature | 2020-06-09T16:49:25.839554+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8944 | 40993 | swimming_water_temperature | 2020-06-09T15:38:57.523798+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8936 | 39693 | swimming_water_temperature | 2020-06-09T12:57:02.789630+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8924 | 40258 | swimming_water_temperature | 2020-06-09T10:19:38.267967+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8920 | 40950 | swimming_water_temperature | 2020-06-09T10:06:44.950998+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8918 | 40142 | swimming_water_temperature | 2020-06-09T10:06:07.037605+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8914 | 40559 | swimming_water_temperature | 2020-06-09T09:59:35.269207+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8910 | 39815 | swimming_water_temperature | 2020-06-09T09:55:58.789091+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8905 | 39693 | swimming_water_temperature | 2020-06-09T08:27:46.582297+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8903 | 39527 | swimming_water_temperature | 2020-06-09T08:13:44.613876+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8888 | 39527 | swimming_water_temperature | 2020-06-08T13:37:44.271269+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8882 | 40950 | swimming_water_temperature | 2020-06-08T10:30:53.653729+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8880 | 40142 | swimming_water_temperature | 2020-06-08T10:23:40.429353+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8871 | 40993 | swimming_water_temperature | 2020-06-08T10:19:50.456002+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8865 | 52959 | swimming_water_temperature | 2020-06-08T10:09:07.633769+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8857 | 40258 | swimming_water_temperature | 2020-06-08T10:04:28.413118+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | 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 );