observation

497 rows where name_en = "below 15°C" sorted by unit

✎ View and edit SQL

This data as json, CSV (advanced)

name_en ✖

  • below 15°C · 497 ✖
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  

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