observation
497 rows where name_en = "below 15°C" and primary = 0 sorted by unit
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 | ||||
791 | 39527 | swimming_water_temperature | 2019-06-15T15:56:24.279647+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
1432 | 39527 | swimming_water_temperature | 2019-06-24T14:39:56.078527+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
1482 | 39527 | swimming_water_temperature | 2019-06-25T10:42:46.178701+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
1596 | 39527 | swimming_water_temperature | 2019-06-27T09:04:50.295586+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
1636 | 39527 | swimming_water_temperature | 2019-06-27T13:16:26.703830+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
1811 | 39527 | swimming_water_temperature | 2019-06-29T10:35:09.132448+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
1842 | 39527 | swimming_water_temperature | 2019-06-29T14:39:13.572336+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
1900 | 39527 | swimming_water_temperature | 2019-06-30T12:36:43.333583+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
1991 | 39527 | swimming_water_temperature | 2019-07-01T10:36:01.507939+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
1992 | 39527 | swimming_water_temperature | 2019-07-01T10:36:22.100902+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
1993 | 39527 | swimming_water_temperature | 2019-07-01T10:36:51.678706+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
1996 | 39527 | swimming_water_temperature | 2019-07-01T10:37:07.201673+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2019 | 39527 | swimming_water_temperature | 2019-07-01T14:10:01.247802+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2195 | 39527 | swimming_water_temperature | 2019-07-04T11:46:35.178176+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2222 | 39527 | swimming_water_temperature | 2019-07-04T13:56:31.650386+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2347 | 39527 | swimming_water_temperature | 2019-07-05T19:59:41.774650+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2383 | 39527 | swimming_water_temperature | 2019-07-06T10:39:17.747107+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2451 | 39527 | swimming_water_temperature | 2019-07-07T10:31:20.885625+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2525 | 39527 | swimming_water_temperature | 2019-07-08T10:17:33.486203+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2546 | 39527 | swimming_water_temperature | 2019-07-08T13:59:12.331068+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2661 | 39527 | swimming_water_temperature | 2019-07-10T10:01:14.812001+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2871 | 39527 | swimming_water_temperature | 2019-07-12T15:37:38.160641+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2882 | 39527 | swimming_water_temperature | 2019-07-13T09:17:58.628768+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
3046 | 39527 | swimming_water_temperature | 2019-07-15T10:10:00.805006+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
3094 | 39527 | swimming_water_temperature | 2019-07-15T14:10:51.465109+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8357 | 39527 | swimming_water_temperature | 2020-06-01T10:41:35.614635+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8361 | 39527 | swimming_water_temperature | 2020-06-01T10:45:04.388055+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8362 | 39527 | swimming_water_temperature | 2020-06-01T10:45:07.299199+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8363 | 39527 | swimming_water_temperature | 2020-06-01T10:45:09.040748+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8442 | 39527 | swimming_water_temperature | 2020-06-02T10:04:25.196825+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8508 | 39527 | swimming_water_temperature | 2020-06-02T18:01:14.285686+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8542 | 39527 | swimming_water_temperature | 2020-06-03T10:13:44.753310+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8809 | 39527 | swimming_water_temperature | 2020-06-07T10:58:53.139152+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8819 | 39527 | swimming_water_temperature | 2020-06-07T14:16:27.736246+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8843 | 39527 | swimming_water_temperature | 2020-06-08T08:43:51.423919+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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
687 | 39568 | swimming_water_temperature | 2019-06-13T16:33:38.469330+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
689 | 39568 | swimming_water_temperature | 2019-06-13T16:33:49.353692+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
692 | 39568 | swimming_water_temperature | 2019-06-13T18:16:53.623298+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
975 | 39568 | swimming_water_temperature | 2019-06-18T09:52:13.128959+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
1457 | 39568 | swimming_water_temperature | 2019-06-25T09:38:13.506010+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
1702 | 39568 | swimming_water_temperature | 2019-06-27T14:58:52.599260+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
1815 | 39568 | swimming_water_temperature | 2019-06-29T10:37:15.570586+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
1839 | 39568 | swimming_water_temperature | 2019-06-29T14:36:03.257726+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
1840 | 39568 | swimming_water_temperature | 2019-06-29T14:36:09.937849+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
1852 | 39568 | swimming_water_temperature | 2019-06-29T18:22:20.289613+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
1903 | 39568 | swimming_water_temperature | 2019-06-30T13:49:12.486308+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
1904 | 39568 | swimming_water_temperature | 2019-06-30T13:49:23.543952+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
1969 | 39568 | swimming_water_temperature | 2019-07-01T10:07:55.633355+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2044 | 39568 | swimming_water_temperature | 2019-07-01T18:40:40.680455+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2126 | 39568 | swimming_water_temperature | 2019-07-03T11:09:03.948749+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2146 | 39568 | swimming_water_temperature | 2019-07-03T17:20:11.125564+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2309 | 39568 | swimming_water_temperature | 2019-07-05T11:55:25.991460+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2328 | 39568 | swimming_water_temperature | 2019-07-05T14:38:19.633616+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2339 | 39568 | swimming_water_temperature | 2019-07-05T18:00:09.544582+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2463 | 39568 | swimming_water_temperature | 2019-07-07T10:54:43.021478+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2478 | 39568 | swimming_water_temperature | 2019-07-07T14:04:46.830475+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2542 | 39568 | swimming_water_temperature | 2019-07-08T13:52:17.203341+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2610 | 39568 | swimming_water_temperature | 2019-07-09T11:15:57.035398+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2669 | 39568 | swimming_water_temperature | 2019-07-10T10:12:53.283387+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2732 | 39568 | swimming_water_temperature | 2019-07-10T18:38:53.374227+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2787 | 39568 | swimming_water_temperature | 2019-07-11T10:32:15.659731+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2811 | 39568 | swimming_water_temperature | 2019-07-11T18:02:31.361019+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2900 | 39568 | swimming_water_temperature | 2019-07-13T10:26:41.196324+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2934 | 39568 | swimming_water_temperature | 2019-07-13T14:59:26.484239+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2949 | 39568 | swimming_water_temperature | 2019-07-13T18:09:53.095297+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2973 | 39568 | swimming_water_temperature | 2019-07-14T10:13:40.210585+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
3022 | 39568 | swimming_water_temperature | 2019-07-14T19:35:18.145893+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8408 | 39568 | swimming_water_temperature | 2020-06-01T13:33:35.638740+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8499 | 39568 | swimming_water_temperature | 2020-06-02T15:30:38.994620+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8610 | 39568 | swimming_water_temperature | 2020-06-04T10:30:50.607339+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8648 | 39568 | swimming_water_temperature | 2020-06-05T09:52:48.469011+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8649 | 39568 | swimming_water_temperature | 2020-06-05T09:52:53.521156+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8650 | 39568 | swimming_water_temperature | 2020-06-05T09:52:58.076787+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
8697 | 39568 | swimming_water_temperature | 2020-06-05T14:20:04.905257+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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
2370 | 39583 | swimming_water_temperature | 2019-07-06T10:16:15.781751+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2402 | 39583 | swimming_water_temperature | 2019-07-06T14:16:08.022698+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2408 | 39583 | swimming_water_temperature | 2019-07-06T17:45:37.924256+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2521 | 39583 | swimming_water_temperature | 2019-07-08T10:10:57.318786+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2670 | 39583 | swimming_water_temperature | 2019-07-10T10:13:51.633773+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
2701 | 39583 | swimming_water_temperature | 2019-07-10T13:51:08.431318+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 );