observation
1,881 rows where value = 1 sorted by unit descending
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4158 | 58015 | swimming_water_cyanobacteria | 2019-07-25T11:56:01.165382+0300 | 2019-07-26T11:56:01.165382+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 4235 | 58015 | swimming_water_cyanobacteria | 2019-07-26T08:57:25.404011+0300 | 2019-07-27T08:57:25.404011+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 9893 | 53476 | swimming_water_cyanobacteria | 2020-06-23T09:15:18.879852+0300 | 2020-06-24T09:15:18.879852+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 10983 | 53476 | swimming_water_cyanobacteria | 2020-07-07T10:15:36.859321+0300 | 2020-07-08T10:15:36.859321+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 11216 | 53476 | swimming_water_cyanobacteria | 2020-07-10T13:54:40.510080+0300 | 2020-07-11T13:54:40.510080+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 11475 | 53476 | swimming_water_cyanobacteria | 2020-07-14T11:50:56.967006+0300 | 2020-07-15T11:50:56.967006+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 11925 | 53476 | swimming_water_cyanobacteria | 2020-07-20T13:04:25.680691+0300 | 2020-07-21T13:04:25.680691+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12017 | 53476 | swimming_water_cyanobacteria | 2020-07-21T13:23:40.268288+0300 | 2020-07-22T13:23:40.268288+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12179 | 53476 | swimming_water_cyanobacteria | 2020-07-23T10:45:33.977941+0300 | 2020-07-24T10:45:33.977941+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12440 | 53476 | swimming_water_cyanobacteria | 2020-07-27T09:05:09.996839+0300 | 2020-07-28T09:05:09.996839+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12539 | 53476 | swimming_water_cyanobacteria | 2020-07-28T09:51:14.592712+0300 | 2020-07-29T09:51:14.592712+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12625 | 53476 | swimming_water_cyanobacteria | 2020-07-29T09:07:29.017348+0300 | 2020-07-30T09:07:29.017348+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12702 | 53476 | swimming_water_cyanobacteria | 2020-07-30T08:45:38.194246+0300 | 2020-07-31T08:45:38.194246+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12775 | 53476 | swimming_water_cyanobacteria | 2020-07-31T09:13:49.722434+0300 | 2020-08-01T09:13:49.722434+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12908 | 53476 | swimming_water_cyanobacteria | 2020-08-02T09:31:01.846956+0300 | 2020-08-03T09:31:01.846956+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12926 | 53476 | swimming_water_cyanobacteria | 2020-08-02T09:36:08.868357+0300 | 2020-08-03T09:36:08.868357+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13002 | 53476 | swimming_water_cyanobacteria | 2020-08-03T08:54:24.480329+0300 | 2020-08-04T08:54:24.480329+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13100 | 53476 | swimming_water_cyanobacteria | 2020-08-04T07:55:36.325925+0300 | 2020-08-05T07:55:36.325925+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13183 | 53476 | swimming_water_cyanobacteria | 2020-08-05T08:48:46.704772+0300 | 2020-08-06T08:48:46.704772+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13268 | 53476 | swimming_water_cyanobacteria | 2020-08-06T08:29:53.389355+0300 | 2020-08-07T08:29:53.389355+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13351 | 53476 | swimming_water_cyanobacteria | 2020-08-07T09:00:31.861313+0300 | 2020-08-08T09:00:31.861313+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13551 | 53476 | swimming_water_cyanobacteria | 2020-08-10T10:53:52.179885+0300 | 2020-08-11T10:53:52.179885+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13595 | 53476 | swimming_water_cyanobacteria | 2020-08-11T09:48:25.160243+0300 | 2020-08-12T09:48:25.160243+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13642 | 53476 | swimming_water_cyanobacteria | 2020-08-12T10:46:48.207348+0300 | 2020-08-13T10:46:48.207348+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13695 | 53476 | swimming_water_cyanobacteria | 2020-08-13T09:38:31.140238+0300 | 2020-08-14T09:38:31.140238+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13735 | 53476 | swimming_water_cyanobacteria | 2020-08-14T09:04:54.626027+0300 | 2020-08-15T09:04:54.626027+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13778 | 53476 | swimming_water_cyanobacteria | 2020-08-15T10:27:38.898670+0300 | 2020-08-16T10:27:38.898670+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13827 | 53476 | swimming_water_cyanobacteria | 2020-08-16T10:23:49.108089+0300 | 2020-08-17T10:23:49.108089+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13898 | 53476 | swimming_water_cyanobacteria | 2020-08-18T11:53:32.445171+0300 | 2020-08-19T11:53:32.445171+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13922 | 53476 | swimming_water_cyanobacteria | 2020-08-19T10:51:33.581016+0300 | 2020-08-20T10:51:33.581016+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13948 | 53476 | swimming_water_cyanobacteria | 2020-08-20T09:53:47.757475+0300 | 2020-08-21T09:53:47.757475+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13985 | 53476 | swimming_water_cyanobacteria | 2020-08-21T12:11:33.842542+0300 | 2020-08-22T12:11:33.842542+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2026 | 53461 | swimming_water_cyanobacteria | 2019-07-01T14:21:50.011953+0300 | 2019-07-02T14:21:50.011953+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3745 | 53461 | swimming_water_cyanobacteria | 2019-07-22T08:18:39.672717+0300 | 2019-07-23T08:18:39.672717+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 11916 | 53461 | swimming_water_cyanobacteria | 2020-07-20T12:04:25.193106+0300 | 2020-07-21T12:04:25.193106+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12199 | 53461 | swimming_water_cyanobacteria | 2020-07-23T10:55:33.931485+0300 | 2020-07-24T10:55:33.931485+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12431 | 53461 | swimming_water_cyanobacteria | 2020-07-27T08:58:04.364329+0300 | 2020-07-28T08:58:04.364329+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12592 | 53461 | swimming_water_cyanobacteria | 2020-07-28T13:30:57.214172+0300 | 2020-07-29T13:30:57.214172+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12617 | 53461 | swimming_water_cyanobacteria | 2020-07-29T09:06:27.589039+0300 | 2020-07-30T09:06:27.589039+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12695 | 53461 | swimming_water_cyanobacteria | 2020-07-30T08:43:31.800215+0300 | 2020-07-31T08:43:31.800215+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12769 | 53461 | swimming_water_cyanobacteria | 2020-07-31T08:24:40.163179+0300 | 2020-08-01T08:24:40.163179+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12786 | 53461 | swimming_water_cyanobacteria | 2020-07-31T09:15:07.181502+0300 | 2020-08-01T09:15:07.181502+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12918 | 53461 | swimming_water_cyanobacteria | 2020-08-02T09:34:01.862903+0300 | 2020-08-03T09:34:01.862903+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13011 | 53461 | swimming_water_cyanobacteria | 2020-08-03T08:55:30.321288+0300 | 2020-08-04T08:55:30.321288+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13107 | 53461 | swimming_water_cyanobacteria | 2020-08-04T07:56:23.892006+0300 | 2020-08-05T07:56:23.892006+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13192 | 53461 | swimming_water_cyanobacteria | 2020-08-05T08:49:30.405089+0300 | 2020-08-06T08:49:30.405089+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13279 | 53461 | swimming_water_cyanobacteria | 2020-08-06T08:31:09.355613+0300 | 2020-08-07T08:31:09.355613+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13360 | 53461 | swimming_water_cyanobacteria | 2020-08-07T09:01:41.870639+0300 | 2020-08-08T09:01:41.870639+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13543 | 53461 | swimming_water_cyanobacteria | 2020-08-10T10:46:12.592402+0300 | 2020-08-11T10:46:12.592402+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13604 | 53461 | swimming_water_cyanobacteria | 2020-08-11T09:49:23.934987+0300 | 2020-08-12T09:49:23.934987+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13651 | 53461 | swimming_water_cyanobacteria | 2020-08-12T10:47:52.182407+0300 | 2020-08-13T10:47:52.182407+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13705 | 53461 | swimming_water_cyanobacteria | 2020-08-13T09:40:25.012276+0300 | 2020-08-14T09:40:25.012276+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13744 | 53461 | swimming_water_cyanobacteria | 2020-08-14T09:05:52.988744+0300 | 2020-08-15T09:05:52.988744+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13788 | 53461 | swimming_water_cyanobacteria | 2020-08-15T10:28:43.910716+0300 | 2020-08-16T10:28:43.910716+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13836 | 53461 | swimming_water_cyanobacteria | 2020-08-16T10:24:38.272242+0300 | 2020-08-17T10:24:38.272242+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13877 | 53461 | swimming_water_cyanobacteria | 2020-08-17T11:10:47.563319+0300 | 2020-08-18T11:10:47.563319+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13975 | 53461 | swimming_water_cyanobacteria | 2020-08-21T11:23:03.616510+0300 | 2020-08-22T11:23:03.616510+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 4131 | 52960 | swimming_water_cyanobacteria | 2019-07-25T10:27:56.673651+0300 | 2019-07-26T10:27:56.673651+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 10992 | 52960 | swimming_water_cyanobacteria | 2020-07-07T10:18:54.615445+0300 | 2020-07-08T10:18:54.615445+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 11219 | 52960 | swimming_water_cyanobacteria | 2020-07-10T13:55:48.435121+0300 | 2020-07-11T13:55:48.435121+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 11481 | 52960 | swimming_water_cyanobacteria | 2020-07-14T11:53:40.689713+0300 | 2020-07-15T11:53:40.689713+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 11589 | 52960 | swimming_water_cyanobacteria | 2020-07-15T11:59:36.613457+0300 | 2020-07-16T11:59:36.613457+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 11930 | 52960 | swimming_water_cyanobacteria | 2020-07-20T13:05:26.368613+0300 | 2020-07-21T13:05:26.368613+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12021 | 52960 | swimming_water_cyanobacteria | 2020-07-21T13:24:48.622819+0300 | 2020-07-22T13:24:48.622819+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12184 | 52960 | swimming_water_cyanobacteria | 2020-07-23T10:46:47.026859+0300 | 2020-07-24T10:46:47.026859+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12239 | 52960 | swimming_water_cyanobacteria | 2020-07-24T09:05:30.631092+0300 | 2020-07-25T09:05:30.631092+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12438 | 52960 | swimming_water_cyanobacteria | 2020-07-27T09:01:35.755487+0300 | 2020-07-28T09:01:35.755487+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12536 | 52960 | swimming_water_cyanobacteria | 2020-07-28T09:50:23.831539+0300 | 2020-07-29T09:50:23.831539+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12615 | 52960 | swimming_water_cyanobacteria | 2020-07-29T09:06:07.308432+0300 | 2020-07-30T09:06:07.308432+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12694 | 52960 | swimming_water_cyanobacteria | 2020-07-30T08:43:24.170210+0300 | 2020-07-31T08:43:24.170210+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12789 | 52960 | swimming_water_cyanobacteria | 2020-07-31T09:15:31.261944+0300 | 2020-08-01T09:15:31.261944+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12923 | 52960 | swimming_water_cyanobacteria | 2020-08-02T09:35:54.984901+0300 | 2020-08-03T09:35:54.984901+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 12924 | 52960 | swimming_water_cyanobacteria | 2020-08-02T09:35:54.984025+0300 | 2020-08-03T09:35:54.984025+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13015 | 52960 | swimming_water_cyanobacteria | 2020-08-03T08:56:01.562721+0300 | 2020-08-04T08:56:01.562721+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13111 | 52960 | swimming_water_cyanobacteria | 2020-08-04T07:57:08.584791+0300 | 2020-08-05T07:57:08.584791+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13196 | 52960 | swimming_water_cyanobacteria | 2020-08-05T08:49:58.356096+0300 | 2020-08-06T08:49:58.356096+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13282 | 52960 | swimming_water_cyanobacteria | 2020-08-06T08:34:24.531894+0300 | 2020-08-07T08:34:24.531894+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13365 | 52960 | swimming_water_cyanobacteria | 2020-08-07T09:02:42.354507+0300 | 2020-08-08T09:02:42.354507+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13557 | 52960 | swimming_water_cyanobacteria | 2020-08-10T10:54:57.656516+0300 | 2020-08-11T10:54:57.656516+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13608 | 52960 | swimming_water_cyanobacteria | 2020-08-11T09:49:56.045921+0300 | 2020-08-12T09:49:56.045921+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13655 | 52960 | swimming_water_cyanobacteria | 2020-08-12T10:48:27.048462+0300 | 2020-08-13T10:48:27.048462+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13708 | 52960 | swimming_water_cyanobacteria | 2020-08-13T09:40:40.376804+0300 | 2020-08-14T09:40:40.376804+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13748 | 52960 | swimming_water_cyanobacteria | 2020-08-14T09:07:15.298776+0300 | 2020-08-15T09:07:15.298776+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13791 | 52960 | swimming_water_cyanobacteria | 2020-08-15T10:29:49.388411+0300 | 2020-08-16T10:29:49.388411+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13840 | 52960 | swimming_water_cyanobacteria | 2020-08-16T10:25:01.572541+0300 | 2020-08-17T10:25:01.572541+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13914 | 52960 | swimming_water_cyanobacteria | 2020-08-18T11:56:37.525709+0300 | 2020-08-19T11:56:37.525709+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13936 | 52960 | swimming_water_cyanobacteria | 2020-08-19T10:53:05.363247+0300 | 2020-08-20T10:53:05.363247+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13955 | 52960 | swimming_water_cyanobacteria | 2020-08-20T09:53:47.870384+0300 | 2020-08-21T09:53:47.870384+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 13987 | 52960 | swimming_water_cyanobacteria | 2020-08-21T12:12:56.350705+0300 | 2020-08-22T12:12:56.350705+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 2850 | 52959 | swimming_water_cyanobacteria | 2019-07-12T10:35:36.442768+0300 | 2019-07-13T10:35:36.442768+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3007 | 52959 | swimming_water_cyanobacteria | 2019-07-14T15:07:04.764863+0300 | 2019-07-15T15:07:04.764863+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3152 | 52959 | swimming_water_cyanobacteria | 2019-07-16T10:43:01.531507+0300 | 2019-07-17T10:43:01.531507+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3199 | 52959 | swimming_water_cyanobacteria | 2019-07-17T10:05:14.730181+0300 | 2019-07-18T10:05:14.730181+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3332 | 52959 | swimming_water_cyanobacteria | 2019-07-18T10:53:43.241620+0300 | 2019-07-19T10:53:43.241620+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3449 | 52959 | swimming_water_cyanobacteria | 2019-07-19T10:45:31.235691+0300 | 2019-07-20T10:45:31.235691+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3475 | 52959 | swimming_water_cyanobacteria | 2019-07-19T14:19:10.310405+0300 | 2019-07-20T14:19:10.310405+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3521 | 52959 | swimming_water_cyanobacteria | 2019-07-19T17:47:16.744990+0300 | 2019-07-20T17:47:16.744990+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3552 | 52959 | swimming_water_cyanobacteria | 2019-07-20T10:16:25.108758+0300 | 2019-07-21T10:16:25.108758+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3598 | 52959 | swimming_water_cyanobacteria | 2019-07-20T16:59:20.217701+0300 | 2019-07-21T16:59:20.217701+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
| 3651 | 52959 | swimming_water_cyanobacteria | 2019-07-21T10:32:41.848087+0300 | 2019-07-22T10:32:41.848087+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory |
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 );