observation

1,261 rows where value = "17-19"

✎ View and edit SQL

This data as json, CSV (advanced)

value ✖

  • 17-19 · 1,161 ✖
id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
946 39568 swimming_water_temperature 2019-06-17T17:05:20.898072+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
962 41031 swimming_water_temperature 2019-06-18T08:47:41.256675+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
977 41791 swimming_water_temperature 2019-06-18T10:04:21.004713+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
982 39322 swimming_water_temperature 2019-06-18T10:07:13.667769+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
989 40150 swimming_water_temperature 2019-06-18T10:32:11.695220+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
991 40142 swimming_water_temperature 2019-06-18T10:40:33.387440+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1039 40098 swimming_water_temperature 2019-06-19T10:09:49.577820+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1042 40142 swimming_water_temperature 2019-06-19T10:24:14.606228+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1058 40150 swimming_water_temperature 2019-06-19T11:00:17.137531+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1062 40386 swimming_water_temperature 2019-06-19T12:02:14.444189+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1069 41791 swimming_water_temperature 2019-06-19T13:03:09.077695+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1093 52959 swimming_water_temperature 2019-06-19T14:38:08.490739+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1099 52959 swimming_water_temperature 2019-06-19T17:57:45.767053+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1123 41791 swimming_water_temperature 2019-06-20T10:03:49.526621+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1124 40802 swimming_water_temperature 2019-06-20T10:03:53.438511+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1127 40559 swimming_water_temperature 2019-06-20T10:07:01.282340+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1138 40950 swimming_water_temperature 2019-06-20T10:14:26.600270+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1161 40798 swimming_water_temperature 2019-06-20T13:49:29.839753+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1163 41907 swimming_water_temperature 2019-06-20T13:49:38.826753+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1165 39910 swimming_water_temperature 2019-06-20T13:51:00.850207+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1171 41031 swimming_water_temperature 2019-06-20T13:52:27.684785+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1192 39568 swimming_water_temperature 2019-06-20T16:43:34.115609+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1206 41791 swimming_water_temperature 2019-06-21T10:03:12.444489+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1208 40950 swimming_water_temperature 2019-06-21T10:06:13.986976+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1210 40559 swimming_water_temperature 2019-06-21T10:18:28.417437+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1279 41791 swimming_water_temperature 2019-06-22T10:00:16.238404+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1281 40559 swimming_water_temperature 2019-06-22T10:04:21.327358+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1284 40950 swimming_water_temperature 2019-06-22T10:23:28.114960+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1297 40098 swimming_water_temperature 2019-06-22T13:08:30.361940+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1302 41791 swimming_water_temperature 2019-06-23T09:58:39.282122+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1306 40559 swimming_water_temperature 2019-06-23T10:14:53.865609+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1312 40150 swimming_water_temperature 2019-06-23T10:33:46.310238+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1357 41791 swimming_water_temperature 2019-06-24T10:01:16.524988+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1363 40559 swimming_water_temperature 2019-06-24T10:10:59.495167+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1366 41907 swimming_water_temperature 2019-06-24T10:19:25.444915+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1368 40798 swimming_water_temperature 2019-06-24T10:19:41.118766+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1370 39910 swimming_water_temperature 2019-06-24T10:19:48.680227+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1393 39693 swimming_water_temperature 2019-06-24T10:32:27.984826+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1430 40802 swimming_water_temperature 2019-06-24T14:31:41.475318+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1439 39693 swimming_water_temperature 2019-06-24T17:44:04.349186+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1454 39815 swimming_water_temperature 2019-06-25T09:24:09.673303+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1461 41791 swimming_water_temperature 2019-06-25T10:00:23.569717+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1471 40559 swimming_water_temperature 2019-06-25T10:16:32.385757+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1491 39693 swimming_water_temperature 2019-06-25T11:54:15.982144+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1496 39693 swimming_water_temperature 2019-06-25T13:52:32.110125+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1501 39815 swimming_water_temperature 2019-06-25T13:58:11.958071+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1510 41907 swimming_water_temperature 2019-06-25T15:02:41.089863+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1512 39910 swimming_water_temperature 2019-06-25T15:02:57.754700+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1516 40798 swimming_water_temperature 2019-06-25T15:03:14.472566+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1526 40802 swimming_water_temperature 2019-06-25T15:04:35.638100+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1541 39815 swimming_water_temperature 2019-06-25T18:13:25.855640+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1545 39815 swimming_water_temperature 2019-06-26T10:02:04.126918+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1546 39693 swimming_water_temperature 2019-06-26T10:05:17.100763+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1560 39583 swimming_water_temperature 2019-06-26T10:29:34.559969+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1574 39693 swimming_water_temperature 2019-06-26T13:59:10.346353+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1580 39583 swimming_water_temperature 2019-06-26T14:14:05.830590+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1585 41791 swimming_water_temperature 2019-06-26T17:07:25.770919+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1586 39583 swimming_water_temperature 2019-06-26T17:45:52.469008+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1591 39693 swimming_water_temperature 2019-06-26T18:21:38.351348+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1594 39815 swimming_water_temperature 2019-06-26T18:43:02.879217+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1600 39815 swimming_water_temperature 2019-06-27T09:53:13.308886+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1604 39693 swimming_water_temperature 2019-06-27T10:01:43.396790+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1616 39583 swimming_water_temperature 2019-06-27T10:14:32.779929+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1623 40157 swimming_water_temperature 2019-06-27T10:23:55.326452+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1633 39583 swimming_water_temperature 2019-06-27T13:15:17.504987+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1634 39583 swimming_water_temperature 2019-06-27T13:15:24.975898+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1640 39815 swimming_water_temperature 2019-06-27T13:17:12.665066+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1642 39693 swimming_water_temperature 2019-06-27T13:17:27.063303+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1648 39667 swimming_water_temperature 2019-06-27T13:22:41.249374+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1670 39693 swimming_water_temperature 2019-06-27T13:48:14.166516+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1673 39583 swimming_water_temperature 2019-06-27T14:05:14.734495+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1692 41031 swimming_water_temperature 2019-06-27T14:39:05.657212+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1694 40677 swimming_water_temperature 2019-06-27T14:39:44.815919+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1711 39815 swimming_water_temperature 2019-06-27T18:21:16.293589+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1717 40076 swimming_water_temperature 2019-06-28T08:26:48.789501+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1734 40157 swimming_water_temperature 2019-06-28T10:21:51.579124+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1746 41960 swimming_water_temperature 2019-06-28T10:49:31.107457+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1748 41601 swimming_water_temperature 2019-06-28T11:30:03.438119+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1825 40157 swimming_water_temperature 2019-06-29T11:39:14.441069+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1889 41601 swimming_water_temperature 2019-06-30T10:28:21.658632+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1893 40157 swimming_water_temperature 2019-06-30T10:49:32.481554+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1942 39815 swimming_water_temperature 2019-07-01T09:40:07.696305+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1967 40150 swimming_water_temperature 2019-07-01T10:06:52.183081+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1971 40386 swimming_water_temperature 2019-07-01T10:10:41.943668+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1980 39693 swimming_water_temperature 2019-07-01T10:22:46.063056+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
1989 41601 swimming_water_temperature 2019-07-01T10:31:18.468612+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2012 39583 swimming_water_temperature 2019-07-01T14:06:16.677865+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2015 39583 swimming_water_temperature 2019-07-01T14:06:26.359217+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2027 39693 swimming_water_temperature 2019-07-01T14:24:37.694720+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2031 39583 swimming_water_temperature 2019-07-01T17:45:06.402069+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2034 39815 swimming_water_temperature 2019-07-01T17:49:47.027355+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2039 39693 swimming_water_temperature 2019-07-01T17:59:46.321933+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2062 41326 swimming_water_temperature 2019-07-02T10:06:11.769356+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2064 41031 swimming_water_temperature 2019-07-02T10:06:18.993224+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2066 40921 swimming_water_temperature 2019-07-02T10:06:24.674401+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2068 40677 swimming_water_temperature 2019-07-02T10:06:30.742561+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2070 40020 swimming_water_temperature 2019-07-02T10:06:36.322022+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2072 40993 swimming_water_temperature 2019-07-02T10:06:43.263886+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2076 40386 swimming_water_temperature 2019-07-02T10:15:40.273871+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2086 41601 swimming_water_temperature 2019-07-02T10:59:50.153349+0300     17-19°C   17-19°C 0 17-19°C 17-19 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
);