observation
1,261 rows where name_en = "17-19°C" and primary = 0
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 );