observation
818 rows where name_fi = "15-17°C"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1000 | 40950 | swimming_water_temperature | 2019-06-18T13:31:03.564720+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1009 | 39568 | swimming_water_temperature | 2019-06-18T14:07:06.253777+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1015 | 52959 | swimming_water_temperature | 2019-06-18T15:39:09.272717+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1018 | 52959 | swimming_water_temperature | 2019-06-18T17:43:59.085560+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1023 | 39568 | swimming_water_temperature | 2019-06-18T18:05:17.763908+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1032 | 39568 | swimming_water_temperature | 2019-06-19T09:49:50.906020+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1046 | 39527 | swimming_water_temperature | 2019-06-19T10:24:54.041705+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1048 | 40802 | swimming_water_temperature | 2019-06-19T10:43:49.796571+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1050 | 52959 | swimming_water_temperature | 2019-06-19T10:52:59.683937+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1054 | 39902 | swimming_water_temperature | 2019-06-19T10:58:55.489579+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1056 | 39875 | swimming_water_temperature | 2019-06-19T10:59:21.634110+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1060 | 40950 | swimming_water_temperature | 2019-06-19T11:22:33.245881+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1064 | 40559 | swimming_water_temperature | 2019-06-19T12:15:44.263082+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1067 | 39823 | swimming_water_temperature | 2019-06-19T12:41:47.568465+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1070 | 53461 | swimming_water_temperature | 2019-06-19T13:09:50.536410+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1073 | 39606 | swimming_water_temperature | 2019-06-19T13:48:50.963802+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1075 | 39412 | swimming_water_temperature | 2019-06-19T13:51:02.392224+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1151 | 40150 | swimming_water_temperature | 2019-06-20T10:46:41.164819+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1153 | 40258 | swimming_water_temperature | 2019-06-20T10:58:31.386420+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1157 | 39527 | swimming_water_temperature | 2019-06-20T11:13:39.685236+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1242 | 40258 | swimming_water_temperature | 2019-06-21T12:10:42.990869+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1263 | 40150 | swimming_water_temperature | 2019-06-21T12:54:55.978481+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1292 | 40150 | swimming_water_temperature | 2019-06-22T12:17:17.840012+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1294 | 40258 | swimming_water_temperature | 2019-06-22T12:27:00.776515+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1317 | 40950 | swimming_water_temperature | 2019-06-23T10:55:25.298137+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1380 | 40150 | swimming_water_temperature | 2019-06-24T10:20:55.726738+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1398 | 40098 | swimming_water_temperature | 2019-06-24T10:36:51.580005+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1401 | 39527 | swimming_water_temperature | 2019-06-24T10:42:44.270153+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1409 | 40950 | swimming_water_temperature | 2019-06-24T11:10:42.118136+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1415 | 40258 | swimming_water_temperature | 2019-06-24T12:44:30.755366+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1428 | 52959 | swimming_water_temperature | 2019-06-24T14:20:58.938333+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1434 | 52959 | swimming_water_temperature | 2019-06-24T16:18:19.614660+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1450 | 39568 | swimming_water_temperature | 2019-06-24T18:49:31.382489+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1451 | 39568 | swimming_water_temperature | 2019-06-24T19:39:35.053265+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1484 | 40258 | swimming_water_temperature | 2019-06-25T11:05:15.745315+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1508 | 52959 | swimming_water_temperature | 2019-06-25T14:38:58.013518+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1530 | 39568 | swimming_water_temperature | 2019-06-25T15:34:41.046014+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1553 | 40559 | swimming_water_temperature | 2019-06-26T10:10:11.742472+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1566 | 40142 | swimming_water_temperature | 2019-06-26T11:13:29.688732+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1583 | 40098 | swimming_water_temperature | 2019-06-26T14:34:04.435393+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1598 | 40559 | swimming_water_temperature | 2019-06-27T09:48:13.302714+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1630 | 41791 | swimming_water_temperature | 2019-06-27T10:55:15.678980+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1631 | 40142 | swimming_water_temperature | 2019-06-27T11:58:31.778915+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1632 | 40142 | swimming_water_temperature | 2019-06-27T11:58:43.880122+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1638 | 39568 | swimming_water_temperature | 2019-06-27T13:16:52.191071+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1644 | 39784 | swimming_water_temperature | 2019-06-27T13:19:23.816530+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1650 | 52959 | swimming_water_temperature | 2019-06-27T13:23:19.401753+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1696 | 40020 | swimming_water_temperature | 2019-06-27T14:42:40.162738+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1698 | 40993 | swimming_water_temperature | 2019-06-27T14:42:52.648452+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1708 | 39693 | swimming_water_temperature | 2019-06-27T17:59:31.073259+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1714 | 39693 | swimming_water_temperature | 2019-06-28T08:17:43.137604+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1724 | 39815 | swimming_water_temperature | 2019-06-28T10:10:35.519353+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1727 | 40098 | swimming_water_temperature | 2019-06-28T10:12:30.134422+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1739 | 40802 | swimming_water_temperature | 2019-06-28T10:24:42.508288+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1750 | 39583 | swimming_water_temperature | 2019-06-28T12:08:02.517964+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1758 | 39693 | swimming_water_temperature | 2019-06-28T14:02:41.491091+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1760 | 39583 | swimming_water_temperature | 2019-06-28T14:20:18.204630+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1772 | 39693 | swimming_water_temperature | 2019-06-28T17:35:22.954656+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1779 | 41791 | swimming_water_temperature | 2019-06-28T17:57:19.013183+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1780 | 39583 | swimming_water_temperature | 2019-06-28T17:57:36.805141+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1783 | 39815 | swimming_water_temperature | 2019-06-28T17:59:56.699731+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1786 | 39693 | swimming_water_temperature | 2019-06-29T09:39:13.947878+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1793 | 40802 | swimming_water_temperature | 2019-06-29T10:03:15.411983+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1816 | 39583 | swimming_water_temperature | 2019-06-29T10:37:31.920374+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1823 | 40386 | swimming_water_temperature | 2019-06-29T11:26:50.755241+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1827 | 39693 | swimming_water_temperature | 2019-06-29T13:31:29.756536+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1830 | 39815 | swimming_water_temperature | 2019-06-29T13:50:49.613189+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1835 | 39583 | swimming_water_temperature | 2019-06-29T14:02:14.798706+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1843 | 39583 | swimming_water_temperature | 2019-06-29T17:45:31.741201+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1848 | 39693 | swimming_water_temperature | 2019-06-29T18:12:33.679089+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1853 | 39815 | swimming_water_temperature | 2019-06-30T08:07:39.593080+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1854 | 39815 | swimming_water_temperature | 2019-06-30T09:40:03.050339+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1864 | 39693 | swimming_water_temperature | 2019-06-30T10:05:41.634817+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1867 | 40386 | swimming_water_temperature | 2019-06-30T10:07:15.973731+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1869 | 40802 | swimming_water_temperature | 2019-06-30T10:09:27.292477+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1871 | 39583 | swimming_water_temperature | 2019-06-30T10:11:45.008240+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1873 | 39583 | swimming_water_temperature | 2019-06-30T10:11:55.027027+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1902 | 40993 | swimming_water_temperature | 2019-06-30T13:40:46.619510+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1909 | 39583 | swimming_water_temperature | 2019-06-30T14:03:21.469435+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1913 | 39693 | swimming_water_temperature | 2019-06-30T14:40:24.261573+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1919 | 39815 | swimming_water_temperature | 2019-06-30T15:03:23.698953+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1920 | 39583 | swimming_water_temperature | 2019-06-30T17:27:39.485548+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1927 | 39815 | swimming_water_temperature | 2019-06-30T18:07:18.213790+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1930 | 39693 | swimming_water_temperature | 2019-06-30T18:11:20.407118+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1951 | 40950 | swimming_water_temperature | 2019-07-01T09:55:58.474069+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1957 | 40802 | swimming_water_temperature | 2019-07-01T10:03:36.354126+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1963 | 41791 | swimming_water_temperature | 2019-07-01T10:04:11.942484+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
1976 | 39583 | swimming_water_temperature | 2019-07-01T10:19:50.517511+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
2000 | 40142 | swimming_water_temperature | 2019-07-01T12:10:32.098271+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
2050 | 40802 | swimming_water_temperature | 2019-07-02T10:00:50.674232+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
2055 | 41791 | swimming_water_temperature | 2019-07-02T10:04:30.063172+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
2056 | 41907 | swimming_water_temperature | 2019-07-02T10:05:35.107656+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
2058 | 40798 | swimming_water_temperature | 2019-07-02T10:05:42.369119+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
2060 | 39910 | swimming_water_temperature | 2019-07-02T10:05:49.442322+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
2074 | 40950 | swimming_water_temperature | 2019-07-02T10:13:20.342940+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
2092 | 39815 | swimming_water_temperature | 2019-07-03T08:42:44.351903+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
2100 | 41791 | swimming_water_temperature | 2019-07-03T10:01:14.651428+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
2118 | 40386 | swimming_water_temperature | 2019-07-03T10:46:48.628049+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
2121 | 39583 | swimming_water_temperature | 2019-07-03T10:55:26.453697+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
2129 | 50549 | swimming_water_temperature | 2019-07-03T12:22:22.698416+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | 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 );