observation
2,809 rows where value = 0 sorted by unit
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
166 | 39267 | swimming_water_cyanobacteria | 2019-06-06T11:41:52.590712+0300 | 2019-06-07T11:41:52.590712+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
181 | 39267 | swimming_water_cyanobacteria | 2019-06-06T14:10:39.762394+0300 | 2019-06-07T14:10:39.762394+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
297 | 39267 | swimming_water_cyanobacteria | 2019-06-08T17:01:12.529283+0300 | 2019-06-09T17:01:12.529283+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
302 | 39267 | swimming_water_cyanobacteria | 2019-06-08T17:58:58.552883+0300 | 2019-06-09T17:58:58.552883+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
340 | 39267 | swimming_water_cyanobacteria | 2019-06-09T10:21:47.250145+0300 | 2019-06-10T10:21:47.250145+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
375 | 39267 | swimming_water_cyanobacteria | 2019-06-09T17:54:15.065650+0300 | 2019-06-10T17:54:15.065650+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
476 | 39267 | swimming_water_cyanobacteria | 2019-06-11T10:10:11.349976+0300 | 2019-06-12T10:10:11.349976+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
591 | 39267 | swimming_water_cyanobacteria | 2019-06-12T10:45:42.523400+0300 | 2019-06-13T10:45:42.523400+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
608 | 39267 | swimming_water_cyanobacteria | 2019-06-12T14:02:40.781786+0300 | 2019-06-13T14:02:40.781786+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
686 | 39267 | swimming_water_cyanobacteria | 2019-06-13T15:03:58.499130+0300 | 2019-06-14T15:03:58.499130+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
13355 | 39267 | swimming_water_cyanobacteria | 2020-08-07T09:01:30.604509+0300 | 2020-08-08T09:01:30.604509+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
13542 | 39267 | swimming_water_cyanobacteria | 2020-08-10T10:45:49.935972+0300 | 2020-08-11T10:45:49.935972+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
13599 | 39267 | swimming_water_cyanobacteria | 2020-08-11T09:48:48.687193+0300 | 2020-08-12T09:48:48.687193+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
13646 | 39267 | swimming_water_cyanobacteria | 2020-08-12T10:47:18.051060+0300 | 2020-08-13T10:47:18.051060+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
13699 | 39267 | swimming_water_cyanobacteria | 2020-08-13T09:38:57.257624+0300 | 2020-08-14T09:38:57.257624+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
13739 | 39267 | swimming_water_cyanobacteria | 2020-08-14T09:05:18.949087+0300 | 2020-08-15T09:05:18.949087+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
13780 | 39267 | swimming_water_cyanobacteria | 2020-08-15T10:28:18.560527+0300 | 2020-08-16T10:28:18.560527+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
13831 | 39267 | swimming_water_cyanobacteria | 2020-08-16T10:24:09.270120+0300 | 2020-08-17T10:24:09.270120+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
13906 | 39267 | swimming_water_cyanobacteria | 2020-08-18T11:54:33.209405+0300 | 2020-08-19T11:54:33.209405+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
13928 | 39267 | swimming_water_cyanobacteria | 2020-08-19T10:52:10.652922+0300 | 2020-08-20T10:52:10.652922+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
8978 | 39289 | swimming_water_cyanobacteria | 2020-06-10T10:03:19.811846+0300 | 2020-06-11T10:03:19.811846+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
223 | 39322 | swimming_water_cyanobacteria | 2019-06-07T11:23:46.934289+0300 | 2019-06-08T11:23:46.934289+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
225 | 39322 | swimming_water_cyanobacteria | 2019-06-07T11:35:37.275884+0300 | 2019-06-08T11:35:37.275884+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
227 | 39322 | swimming_water_cyanobacteria | 2019-06-07T11:35:37.729851+0300 | 2019-06-08T11:35:37.729851+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
229 | 39322 | swimming_water_cyanobacteria | 2019-06-07T11:35:38.182549+0300 | 2019-06-08T11:35:38.182549+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
246 | 39322 | swimming_water_cyanobacteria | 2019-06-07T15:17:51.371667+0300 | 2019-06-08T15:17:51.371667+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
259 | 39322 | swimming_water_cyanobacteria | 2019-06-07T19:42:43.393878+0300 | 2019-06-08T19:42:43.393878+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
307 | 39322 | swimming_water_cyanobacteria | 2019-06-08T23:41:39.898126+0300 | 2019-06-09T23:41:39.898126+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
338 | 39322 | swimming_water_cyanobacteria | 2019-06-09T10:15:22.169332+0300 | 2019-06-10T10:15:22.169332+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
367 | 39322 | swimming_water_cyanobacteria | 2019-06-09T14:07:48.854694+0300 | 2019-06-10T14:07:48.854694+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
392 | 39322 | swimming_water_cyanobacteria | 2019-06-10T10:01:32.789022+0300 | 2019-06-11T10:01:32.789022+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
407 | 39322 | swimming_water_cyanobacteria | 2019-06-10T13:40:35.075811+0300 | 2019-06-11T13:40:35.075811+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
425 | 39322 | swimming_water_cyanobacteria | 2019-06-10T17:51:08.455237+0300 | 2019-06-11T17:51:08.455237+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
461 | 39322 | swimming_water_cyanobacteria | 2019-06-11T09:50:57.103281+0300 | 2019-06-12T09:50:57.103281+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
555 | 39322 | swimming_water_cyanobacteria | 2019-06-11T13:45:46.922981+0300 | 2019-06-12T13:45:46.922981+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
566 | 39322 | swimming_water_cyanobacteria | 2019-06-11T17:52:48.301558+0300 | 2019-06-12T17:52:48.301558+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
573 | 39322 | swimming_water_cyanobacteria | 2019-06-12T10:04:15.093719+0300 | 2019-06-13T10:04:15.093719+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
606 | 39322 | swimming_water_cyanobacteria | 2019-06-12T14:01:03.590432+0300 | 2019-06-13T14:01:03.590432+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
621 | 39322 | swimming_water_cyanobacteria | 2019-06-12T17:49:11.759700+0300 | 2019-06-13T17:49:11.759700+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
652 | 39322 | swimming_water_cyanobacteria | 2019-06-13T10:08:24.438606+0300 | 2019-06-14T10:08:24.438606+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
696 | 39322 | swimming_water_cyanobacteria | 2019-06-13T18:42:37.809008+0300 | 2019-06-14T18:42:37.809008+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
710 | 39322 | swimming_water_cyanobacteria | 2019-06-14T09:44:12.773863+0300 | 2019-06-15T09:44:12.773863+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
833 | 39322 | swimming_water_cyanobacteria | 2019-06-16T10:08:53.647603+0300 | 2019-06-17T10:08:53.647603+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
2043 | 39322 | swimming_water_cyanobacteria | 2019-07-01T18:09:21.935312+0300 | 2019-07-02T18:09:21.935312+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
2097 | 39322 | swimming_water_cyanobacteria | 2019-07-03T09:51:33.108914+0300 | 2019-07-04T09:51:33.108914+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
8621 | 39322 | swimming_water_cyanobacteria | 2020-06-04T13:31:19.565447+0300 | 2020-06-05T13:31:19.565447+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
8629 | 39322 | swimming_water_cyanobacteria | 2020-06-04T15:04:26.455349+0300 | 2020-06-05T15:04:26.455349+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
8642 | 39322 | swimming_water_cyanobacteria | 2020-06-04T19:26:00.900564+0300 | 2020-06-05T19:26:00.900564+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
8644 | 39322 | swimming_water_cyanobacteria | 2020-06-05T08:30:31.940629+0300 | 2020-06-06T08:30:31.940629+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
8701 | 39322 | swimming_water_cyanobacteria | 2020-06-05T14:21:21.577935+0300 | 2020-06-06T14:21:21.577935+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
8771 | 39322 | swimming_water_cyanobacteria | 2020-06-06T18:14:05.010617+0300 | 2020-06-07T18:14:05.010617+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
8792 | 39322 | swimming_water_cyanobacteria | 2020-06-07T10:09:35.389842+0300 | 2020-06-08T10:09:35.389842+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
8816 | 39322 | swimming_water_cyanobacteria | 2020-06-07T13:53:23.711738+0300 | 2020-06-08T13:53:23.711738+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
8825 | 39322 | swimming_water_cyanobacteria | 2020-06-07T14:40:36.392081+0300 | 2020-06-08T14:40:36.392081+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
8831 | 39322 | swimming_water_cyanobacteria | 2020-06-07T17:51:55.192106+0300 | 2020-06-08T17:51:55.192106+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
8861 | 39322 | swimming_water_cyanobacteria | 2020-06-08T10:05:25.541820+0300 | 2020-06-09T10:05:25.541820+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
8891 | 39322 | swimming_water_cyanobacteria | 2020-06-08T13:59:41.861684+0300 | 2020-06-09T13:59:41.861684+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
8898 | 39322 | swimming_water_cyanobacteria | 2020-06-08T17:51:54.558749+0300 | 2020-06-09T17:51:54.558749+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
8923 | 39322 | swimming_water_cyanobacteria | 2020-06-09T10:09:36.162775+0300 | 2020-06-10T10:09:36.162775+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
8939 | 39322 | swimming_water_cyanobacteria | 2020-06-09T13:58:21.098675+0300 | 2020-06-10T13:58:21.098675+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
8943 | 39322 | swimming_water_cyanobacteria | 2020-06-09T14:56:16.422279+0300 | 2020-06-10T14:56:16.422279+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
8951 | 39322 | swimming_water_cyanobacteria | 2020-06-09T18:00:51.021183+0300 | 2020-06-10T18:00:51.021183+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9016 | 39322 | swimming_water_cyanobacteria | 2020-06-10T14:44:25.179799+0300 | 2020-06-11T14:44:25.179799+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9028 | 39322 | swimming_water_cyanobacteria | 2020-06-10T17:53:00.155785+0300 | 2020-06-11T17:53:00.155785+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9092 | 39322 | swimming_water_cyanobacteria | 2020-06-11T10:08:02.997986+0300 | 2020-06-12T10:08:02.997986+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9120 | 39322 | swimming_water_cyanobacteria | 2020-06-11T14:42:34.386552+0300 | 2020-06-12T14:42:34.386552+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9132 | 39322 | swimming_water_cyanobacteria | 2020-06-11T18:00:02.458284+0300 | 2020-06-12T18:00:02.458284+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9189 | 39322 | swimming_water_cyanobacteria | 2020-06-12T11:24:38.307195+0300 | 2020-06-13T11:24:38.307195+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9209 | 39322 | swimming_water_cyanobacteria | 2020-06-12T18:04:10.099605+0300 | 2020-06-13T18:04:10.099605+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9250 | 39322 | swimming_water_cyanobacteria | 2020-06-13T11:15:24.569304+0300 | 2020-06-14T11:15:24.569304+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9259 | 39322 | swimming_water_cyanobacteria | 2020-06-13T14:15:58.221285+0300 | 2020-06-14T14:15:58.221285+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9291 | 39322 | swimming_water_cyanobacteria | 2020-06-14T10:13:51.779788+0300 | 2020-06-15T10:13:51.779788+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9318 | 39322 | swimming_water_cyanobacteria | 2020-06-14T13:46:32.134787+0300 | 2020-06-15T13:46:32.134787+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9371 | 39322 | swimming_water_cyanobacteria | 2020-06-15T09:54:22.298060+0300 | 2020-06-16T09:54:22.298060+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9434 | 39322 | swimming_water_cyanobacteria | 2020-06-15T14:22:09.130688+0300 | 2020-06-16T14:22:09.130688+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9450 | 39322 | swimming_water_cyanobacteria | 2020-06-15T17:58:38.978253+0300 | 2020-06-16T17:58:38.978253+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9452 | 39322 | swimming_water_cyanobacteria | 2020-06-15T18:00:14.727657+0300 | 2020-06-16T18:00:14.727657+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9515 | 39322 | swimming_water_cyanobacteria | 2020-06-16T13:57:06.392827+0300 | 2020-06-17T13:57:06.392827+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9531 | 39322 | swimming_water_cyanobacteria | 2020-06-16T18:13:24.918634+0300 | 2020-06-17T18:13:24.918634+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9571 | 39322 | swimming_water_cyanobacteria | 2020-06-17T10:11:27.141434+0300 | 2020-06-18T10:11:27.141434+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9608 | 39322 | swimming_water_cyanobacteria | 2020-06-17T14:19:22.937205+0300 | 2020-06-18T14:19:22.937205+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9620 | 39322 | swimming_water_cyanobacteria | 2020-06-17T17:58:41.358364+0300 | 2020-06-18T17:58:41.358364+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9638 | 39322 | swimming_water_cyanobacteria | 2020-06-18T09:34:19.146127+0300 | 2020-06-19T09:34:19.146127+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9683 | 39322 | swimming_water_cyanobacteria | 2020-06-18T14:00:21.579476+0300 | 2020-06-19T14:00:21.579476+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9695 | 39322 | swimming_water_cyanobacteria | 2020-06-18T18:05:39.431509+0300 | 2020-06-19T18:05:39.431509+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9697 | 39322 | swimming_water_cyanobacteria | 2020-06-18T18:16:56.781501+0300 | 2020-06-19T18:16:56.781501+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9822 | 39322 | swimming_water_cyanobacteria | 2020-06-22T09:46:30.354376+0300 | 2020-06-23T09:46:30.354376+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9865 | 39322 | swimming_water_cyanobacteria | 2020-06-22T14:03:35.174189+0300 | 2020-06-23T14:03:35.174189+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9883 | 39322 | swimming_water_cyanobacteria | 2020-06-22T18:01:49.226631+0300 | 2020-06-23T18:01:49.226631+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9891 | 39322 | swimming_water_cyanobacteria | 2020-06-23T09:14:49.376914+0300 | 2020-06-24T09:14:49.376914+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9929 | 39322 | swimming_water_cyanobacteria | 2020-06-23T10:10:46.775990+0300 | 2020-06-24T10:10:46.775990+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
9990 | 39322 | swimming_water_cyanobacteria | 2020-06-23T14:11:07.649365+0300 | 2020-06-24T14:11:07.649365+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
10006 | 39322 | swimming_water_cyanobacteria | 2020-06-23T18:36:55.274246+0300 | 2020-06-24T18:36:55.274246+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
10039 | 39322 | swimming_water_cyanobacteria | 2020-06-24T10:02:54.936726+0300 | 2020-06-25T10:02:54.936726+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
10086 | 39322 | swimming_water_cyanobacteria | 2020-06-24T13:58:09.622144+0300 | 2020-06-25T13:58:09.622144+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
10097 | 39322 | swimming_water_cyanobacteria | 2020-06-24T18:12:37.146743+0300 | 2020-06-25T18:12:37.146743+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
10125 | 39322 | swimming_water_cyanobacteria | 2020-06-25T09:59:23.395827+0300 | 2020-06-26T09:59:23.395827+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
10167 | 39322 | swimming_water_cyanobacteria | 2020-06-25T14:14:56.356339+0300 | 2020-06-26T14:14:56.356339+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
10180 | 39322 | swimming_water_cyanobacteria | 2020-06-25T18:01:42.923454+0300 | 2020-06-26T18:01:42.923454+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
10224 | 39322 | swimming_water_cyanobacteria | 2020-06-26T10:24:20.153206+0300 | 2020-06-27T10:24:20.153206+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good |
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 );