observation
66 rows where value = "" sorted by value
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
121 | 41791 | notice | 2019-06-05T13:52:59.212201+0300 | ||||||||||
139 | 40559 | notice | 2019-06-06T10:27:36.510810+0300 | ||||||||||
335 | 40559 | notice | 2019-06-09T10:15:15.581523+0300 | ||||||||||
456 | 39693 | notice | 2019-06-11T09:16:28.327006+0300 | ||||||||||
501 | 41791 | notice | 2019-06-11T11:59:50.961295+0300 | ||||||||||
629 | 39527 | notice | 2019-06-12T19:06:10.261046+0300 | ||||||||||
1965 | 40993 | notice | 2019-07-01T10:05:40.586598+0300 | ||||||||||
1994 | 39527 | notice | 2019-07-01T10:36:57.743332+0300 | ||||||||||
2024 | 39527 | notice | 2019-07-01T14:11:15.191640+0300 | ||||||||||
2120 | 40386 | notice | 2019-07-03T10:47:18.067029+0300 | ||||||||||
2631 | 40798 | notice | 2019-07-10T08:09:33.067690+0300 | ||||||||||
2636 | 41031 | notice | 2019-07-10T08:10:22.717649+0300 | ||||||||||
3067 | 40386 | notice | 2019-07-15T10:29:41.559509+0300 | ||||||||||
5623 | 39815 | notice | 2019-08-09T09:25:17.097121+0300 | ||||||||||
6027 | 53615 | notice | 2019-11-11T16:10:48.185953+0200 | ||||||||||
6157 | 53563 | notice | 2019-11-27T08:29:11.544258+0200 | ||||||||||
6780 | 53710 | notice | 2020-01-12T08:36:14.149601+0200 | ||||||||||
6791 | 46144 | notice | 2020-01-12T11:24:35.624248+0200 | ||||||||||
6871 | 53710 | notice | 2020-01-17T06:36:08.077015+0200 | ||||||||||
6885 | 60871 | notice | 2020-01-17T09:57:35.816255+0200 | ||||||||||
6975 | 57401 | notice | 2020-01-21T09:38:22.826849+0200 | ||||||||||
7035 | 57401 | notice | 2020-01-24T09:54:22.586343+0200 | ||||||||||
7149 | 57401 | notice | 2020-01-30T07:53:30.000327+0200 | ||||||||||
7201 | 46144 | notice | 2020-02-02T08:05:08.628153+0200 | ||||||||||
7206 | 46144 | notice | 2020-02-02T08:59:20.844099+0200 | ||||||||||
7360 | 42249 | notice | 2020-02-06T14:36:45.061787+0200 | ||||||||||
7424 | 57401 | notice | 2020-02-07T18:58:55.239205+0200 | ||||||||||
7520 | 40934 | notice | 2020-02-10T08:26:59.634968+0200 | ||||||||||
7534 | 42128 | notice | 2020-02-10T11:54:04.601762+0200 | ||||||||||
7553 | 53710 | notice | 2020-02-11T06:18:10.769082+0200 | ||||||||||
7599 | 39834 | notice | 2020-02-12T15:40:48.175680+0200 | ||||||||||
7699 | 39834 | notice | 2020-02-17T06:27:45.821811+0200 | ||||||||||
7700 | 53563 | notice | 2020-02-17T06:28:13.987972+0200 | ||||||||||
7758 | 57401 | notice | 2020-02-19T09:37:35.126067+0200 | ||||||||||
7841 | 57401 | notice | 2020-02-24T16:18:20.282611+0200 | ||||||||||
7847 | 46144 | notice | 2020-02-24T18:37:29.462156+0200 | ||||||||||
7968 | 57401 | notice | 2020-02-29T13:44:08.829054+0200 | ||||||||||
8198 | 61464 | notice | 2020-03-12T09:04:03.242640+0200 | ||||||||||
8237 | 57401 | notice | 2020-03-14T23:21:44.357983+0200 | ||||||||||
8267 | 39834 | notice | 2020-03-16T14:37:40.836380+0200 | ||||||||||
8268 | 53563 | notice | 2020-03-16T14:37:53.095622+0200 | ||||||||||
8300 | 42185 | notice | 2020-03-18T14:19:33.954622+0200 | ||||||||||
8303 | 41770 | notice | 2020-03-18T14:20:38.160531+0200 | ||||||||||
8313 | 53563 | notice | 2020-03-19T20:35:01.283531+0200 | ||||||||||
8314 | 39834 | notice | 2020-03-19T20:35:14.172743+0200 | ||||||||||
8352 | 40725 | notice | 2020-03-23T13:17:44.593637+0200 | ||||||||||
8576 | 39267 | notice | 2020-06-04T09:01:48.666182+0300 | ||||||||||
12817 | 50549 | notice | 2020-07-31T13:24:20.338488+0300 | ||||||||||
27795 | 50354 | notice | 2020-10-26T16:21:04.480686+0200 | ||||||||||
27796 | 50568 | notice | 2020-10-26T16:22:18.099751+0200 | ||||||||||
34394 | 40550 | notice | 2020-11-17T13:39:50.167877+0200 | ||||||||||
35302 | 39834 | notice | 2020-11-20T15:49:17.226167+0200 | ||||||||||
35539 | 46144 | notice | 2020-11-21T09:33:26.747175+0200 | ||||||||||
35620 | 42699 | notice | 2020-11-21T15:34:24.945528+0200 | ||||||||||
35795 | 42699 | notice | 2020-11-22T09:07:23.877110+0200 | ||||||||||
37599 | 61464 | notice | 2020-11-28T06:56:42.030530+0200 | ||||||||||
41270 | 61464 | notice | 2020-12-09T16:01:05.927382+0200 | ||||||||||
42735 | 39370 | notice | 2020-12-14T05:21:13.502657+0200 | ||||||||||
43352 | 57401 | notice | 2020-12-16T02:59:23.017620+0200 | ||||||||||
43432 | 39911 | notice | 2020-12-16T08:13:14.718827+0200 | ||||||||||
43787 | 39911 | notice | 2020-12-17T09:17:57.757039+0200 | ||||||||||
43866 | 39911 | notice | 2020-12-17T14:59:53.268552+0200 | ||||||||||
49305 | 42699 | notice | 2020-12-31T13:27:58.045384+0200 | ||||||||||
49647 | 42699 | notice | 2021-01-01T11:21:34.164442+0200 | ||||||||||
50451 | 46144 | notice | 2021-01-03T10:55:14.831929+0200 | ||||||||||
50959 | 57401 | notice | 2021-01-04T14:34:07.849712+0200 |
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 );