observation

4,968 rows where primary = 0 sorted by name_en

✎ View and edit SQL

This data as json, CSV (advanced)

primary ✖

  • 0 · 4,868 ✖
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  

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