observation
281 rows where primary = 1 and value = 2 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: unit
id ▲ | unit | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13978 | 39267 | swimming_water_cyanobacteria | 2020-08-21T12:10:09.650343+0300 | 2020-08-22T12:10:09.650343+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13945 | 39267 | swimming_water_cyanobacteria | 2020-08-20T09:47:37.985942+0300 | 2020-08-21T09:47:37.985942+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13905 | 39693 | swimming_water_cyanobacteria | 2020-08-18T11:54:28.199001+0300 | 2020-08-19T11:54:28.199001+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13887 | 39267 | swimming_water_cyanobacteria | 2020-08-17T12:36:28.638134+0300 | 2020-08-18T12:36:28.638134+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13669 | 39693 | swimming_water_cyanobacteria | 2020-08-12T14:08:48.941251+0300 | 2020-08-13T14:08:48.941251+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13662 | 39693 | swimming_water_cyanobacteria | 2020-08-12T14:02:47.587146+0300 | 2020-08-13T14:02:47.587146+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13637 | 39693 | swimming_water_cyanobacteria | 2020-08-12T10:11:46.049455+0300 | 2020-08-13T10:11:46.049455+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13507 | 40142 | swimming_water_cyanobacteria | 2020-08-09T10:57:03.161826+0300 | 2020-08-10T10:57:03.161826+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13485 | 40559 | swimming_water_cyanobacteria | 2020-08-09T09:55:12.004728+0300 | 2020-08-10T09:55:12.004728+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13475 | 39583 | swimming_water_cyanobacteria | 2020-08-08T17:47:10.685075+0300 | 2020-08-09T17:47:10.685075+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13470 | 39583 | swimming_water_cyanobacteria | 2020-08-08T14:05:44.266758+0300 | 2020-08-09T14:05:44.266758+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13459 | 40950 | swimming_water_cyanobacteria | 2020-08-08T10:31:54.061435+0300 | 2020-08-09T10:31:54.061435+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13456 | 40098 | swimming_water_cyanobacteria | 2020-08-08T10:25:51.575865+0300 | 2020-08-09T10:25:51.575865+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13452 | 40142 | swimming_water_cyanobacteria | 2020-08-08T10:13:52.400163+0300 | 2020-08-09T10:13:52.400163+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13450 | 39583 | swimming_water_cyanobacteria | 2020-08-08T10:11:17.896955+0300 | 2020-08-09T10:11:17.896955+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13447 | 40559 | swimming_water_cyanobacteria | 2020-08-08T10:08:18.582846+0300 | 2020-08-09T10:08:18.582846+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13442 | 41601 | swimming_water_cyanobacteria | 2020-08-08T10:01:06.941894+0300 | 2020-08-09T10:01:06.941894+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13433 | 39568 | swimming_water_cyanobacteria | 2020-08-08T09:43:17.684005+0300 | 2020-08-09T09:43:17.684005+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13421 | 39583 | swimming_water_cyanobacteria | 2020-08-07T17:49:21.834088+0300 | 2020-08-08T17:49:21.834088+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13417 | 39583 | swimming_water_cyanobacteria | 2020-08-07T14:24:16.696312+0300 | 2020-08-08T14:24:16.696312+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13403 | 40098 | swimming_water_cyanobacteria | 2020-08-07T11:14:52.675441+0300 | 2020-08-08T11:14:52.675441+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13396 | 39583 | swimming_water_cyanobacteria | 2020-08-07T10:15:01.928154+0300 | 2020-08-08T10:15:01.928154+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13394 | 40150 | swimming_water_cyanobacteria | 2020-08-07T10:12:03.865472+0300 | 2020-08-08T10:12:03.865472+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13380 | 40142 | swimming_water_cyanobacteria | 2020-08-07T09:57:20.324432+0300 | 2020-08-08T09:57:20.324432+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13376 | 40993 | swimming_water_cyanobacteria | 2020-08-07T09:53:26.565927+0300 | 2020-08-08T09:53:26.565927+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13372 | 39568 | swimming_water_cyanobacteria | 2020-08-07T09:25:50.150616+0300 | 2020-08-08T09:25:50.150616+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13289 | 40142 | swimming_water_cyanobacteria | 2020-08-06T09:52:45.996810+0300 | 2020-08-07T09:52:45.996810+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13209 | 40142 | swimming_water_cyanobacteria | 2020-08-05T09:50:45.324900+0300 | 2020-08-06T09:50:45.324900+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13162 | 39583 | swimming_water_cyanobacteria | 2020-08-04T12:13:30.808428+0300 | 2020-08-05T12:13:30.808428+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
13128 | 41601 | swimming_water_cyanobacteria | 2020-08-04T10:02:54.373699+0300 | 2020-08-05T10:02:54.373699+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
12931 | 41601 | swimming_water_cyanobacteria | 2020-08-02T09:57:24.011744+0300 | 2020-08-03T09:57:24.011744+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
12866 | 41601 | swimming_water_cyanobacteria | 2020-08-01T10:12:59.955090+0300 | 2020-08-02T10:12:59.955090+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
12679 | 52959 | swimming_water_cyanobacteria | 2020-07-29T14:10:59.234010+0300 | 2020-07-30T14:10:59.234010+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
12634 | 41601 | swimming_water_cyanobacteria | 2020-07-29T09:56:45.227033+0300 | 2020-07-30T09:56:45.227033+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
12586 | 41601 | swimming_water_cyanobacteria | 2020-07-28T13:00:39.006120+0300 | 2020-07-29T13:00:39.006120+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
12562 | 52959 | swimming_water_cyanobacteria | 2020-07-28T10:20:27.549382+0300 | 2020-07-29T10:20:27.549382+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
12165 | 41601 | swimming_water_cyanobacteria | 2020-07-23T10:04:19.824257+0300 | 2020-07-24T10:04:19.824257+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
12101 | 41601 | swimming_water_cyanobacteria | 2020-07-22T10:10:02.322925+0300 | 2020-07-23T10:10:02.322925+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
11890 | 41601 | swimming_water_cyanobacteria | 2020-07-20T10:10:53.800997+0300 | 2020-07-21T10:10:53.800997+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
11827 | 41601 | swimming_water_cyanobacteria | 2020-07-19T10:03:24.574749+0300 | 2020-07-20T10:03:24.574749+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
11791 | 41601 | swimming_water_cyanobacteria | 2020-07-18T11:27:27.370745+0300 | 2020-07-19T11:27:27.370745+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
11724 | 41601 | swimming_water_cyanobacteria | 2020-07-17T10:49:35.140434+0300 | 2020-07-18T10:49:35.140434+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
11687 | 41601 | swimming_water_cyanobacteria | 2020-07-17T09:50:56.814497+0300 | 2020-07-18T09:50:56.814497+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
11654 | 41601 | swimming_water_cyanobacteria | 2020-07-16T11:13:29.039062+0300 | 2020-07-17T11:13:29.039062+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
10130 | 40258 | swimming_water_cyanobacteria | 2020-06-25T10:01:27.744745+0300 | 2020-06-26T10:01:27.744745+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
10044 | 40802 | swimming_water_cyanobacteria | 2020-06-24T10:08:10.091793+0300 | 2020-06-25T10:08:10.091793+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
10036 | 40142 | swimming_water_cyanobacteria | 2020-06-24T10:02:47.066598+0300 | 2020-06-25T10:02:47.066598+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
9998 | 39815 | swimming_water_cyanobacteria | 2020-06-23T17:44:31.306185+0300 | 2020-06-24T17:44:31.306185+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
9984 | 39815 | swimming_water_cyanobacteria | 2020-06-23T14:03:51.627049+0300 | 2020-06-24T14:03:51.627049+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
9938 | 39815 | swimming_water_cyanobacteria | 2020-06-23T10:24:23.248841+0300 | 2020-06-24T10:24:23.248841+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
9640 | 39568 | swimming_water_cyanobacteria | 2020-06-18T09:35:17.086184+0300 | 2020-06-19T09:35:17.086184+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
9614 | 52959 | swimming_water_cyanobacteria | 2020-06-17T15:26:43.950416+0300 | 2020-06-18T15:26:43.950416+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
9594 | 40258 | swimming_water_cyanobacteria | 2020-06-17T11:11:14.413683+0300 | 2020-06-18T11:11:14.413683+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
9592 | 39568 | swimming_water_cyanobacteria | 2020-06-17T11:08:43.389887+0300 | 2020-06-18T11:08:43.389887+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
6002 | 53461 | swimming_water_cyanobacteria | 2019-09-13T09:37:39.937572+0300 | 2019-09-14T09:37:39.937572+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5977 | 53461 | swimming_water_cyanobacteria | 2019-09-02T09:35:57.728808+0300 | 2019-09-03T09:35:57.728808+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5946 | 53461 | swimming_water_cyanobacteria | 2019-08-28T10:16:29.013979+0300 | 2019-08-29T10:16:29.013979+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5936 | 53461 | swimming_water_cyanobacteria | 2019-08-26T13:26:40.072133+0300 | 2019-08-27T13:26:40.072133+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5924 | 53461 | swimming_water_cyanobacteria | 2019-08-21T12:46:43.778456+0300 | 2019-08-22T12:46:43.778456+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5907 | 39267 | swimming_water_cyanobacteria | 2019-08-21T11:32:29.418248+0300 | 2019-08-22T11:32:29.418248+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5890 | 53461 | swimming_water_cyanobacteria | 2019-08-19T08:36:12.740068+0300 | 2019-08-20T08:36:12.740068+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5881 | 53461 | swimming_water_cyanobacteria | 2019-08-16T10:15:49.698832+0300 | 2019-08-17T10:15:49.698832+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5803 | 40258 | swimming_water_cyanobacteria | 2019-08-11T10:36:00.844120+0300 | 2019-08-12T10:36:00.844120+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5728 | 39568 | swimming_water_cyanobacteria | 2019-08-10T11:20:09.329098+0300 | 2019-08-11T11:20:09.329098+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5726 | 40802 | swimming_water_cyanobacteria | 2019-08-10T11:10:48.470721+0300 | 2019-08-11T11:10:48.470721+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5712 | 40258 | swimming_water_cyanobacteria | 2019-08-10T10:30:07.110518+0300 | 2019-08-11T10:30:07.110518+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5692 | 40386 | swimming_water_cyanobacteria | 2019-08-10T10:03:13.918218+0300 | 2019-08-11T10:03:13.918218+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5688 | 39527 | swimming_water_cyanobacteria | 2019-08-10T08:48:46.736851+0300 | 2019-08-11T08:48:46.736851+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5536 | 40559 | swimming_water_cyanobacteria | 2019-08-08T10:22:04.270255+0300 | 2019-08-09T10:22:04.270255+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5512 | 53461 | swimming_water_cyanobacteria | 2019-08-08T09:18:45.023231+0300 | 2019-08-09T09:18:45.023231+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5486 | 53461 | swimming_water_cyanobacteria | 2019-08-07T14:38:52.935154+0300 | 2019-08-08T14:38:52.935154+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5402 | 53461 | swimming_water_cyanobacteria | 2019-08-06T12:30:21.253625+0300 | 2019-08-07T12:30:21.253625+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5385 | 53476 | swimming_water_cyanobacteria | 2019-08-06T10:34:59.694304+0300 | 2019-08-07T10:34:59.694304+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5383 | 50549 | swimming_water_cyanobacteria | 2019-08-06T10:34:48.032360+0300 | 2019-08-07T10:34:48.032360+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5380 | 52960 | swimming_water_cyanobacteria | 2019-08-06T10:34:25.861764+0300 | 2019-08-07T10:34:25.861764+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5374 | 40386 | swimming_water_cyanobacteria | 2019-08-06T10:18:03.975858+0300 | 2019-08-07T10:18:03.975858+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5260 | 53461 | swimming_water_cyanobacteria | 2019-08-05T09:37:50.776569+0300 | 2019-08-06T09:37:50.776569+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5089 | 40386 | swimming_water_cyanobacteria | 2019-08-03T10:15:20.333899+0300 | 2019-08-04T10:15:20.333899+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
5017 | 41601 | swimming_water_cyanobacteria | 2019-08-02T11:04:12.417535+0300 | 2019-08-03T11:04:12.417535+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4965 | 53461 | swimming_water_cyanobacteria | 2019-08-02T07:33:21.816524+0300 | 2019-08-03T07:33:21.816524+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4868 | 53461 | swimming_water_cyanobacteria | 2019-08-01T09:35:35.368553+0300 | 2019-08-02T09:35:35.368553+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4768 | 53461 | swimming_water_cyanobacteria | 2019-07-31T08:49:58.944314+0300 | 2019-08-01T08:49:58.944314+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4745 | 39583 | swimming_water_cyanobacteria | 2019-07-30T17:39:33.226807+0300 | 2019-07-31T17:39:33.226807+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4659 | 39583 | swimming_water_cyanobacteria | 2019-07-29T13:35:02.968634+0300 | 2019-07-30T13:35:02.968634+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4648 | 40258 | swimming_water_cyanobacteria | 2019-07-29T12:42:15.118188+0300 | 2019-07-30T12:42:15.118188+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4580 | 53461 | swimming_water_cyanobacteria | 2019-07-29T07:55:32.235291+0300 | 2019-07-30T07:55:32.235291+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4574 | 52959 | swimming_water_cyanobacteria | 2019-07-28T19:52:55.733956+0300 | 2019-07-29T19:52:55.733956+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4572 | 39568 | swimming_water_cyanobacteria | 2019-07-28T19:52:15.726425+0300 | 2019-07-29T19:52:15.726425+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4543 | 39583 | swimming_water_cyanobacteria | 2019-07-28T17:20:54.972671+0300 | 2019-07-29T17:20:54.972671+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4539 | 39583 | swimming_water_cyanobacteria | 2019-07-28T17:20:37.282823+0300 | 2019-07-29T17:20:37.282823+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4507 | 40142 | swimming_water_cyanobacteria | 2019-07-28T10:15:52.545486+0300 | 2019-07-29T10:15:52.545486+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4503 | 40142 | swimming_water_cyanobacteria | 2019-07-28T10:07:57.917329+0300 | 2019-07-29T10:07:57.917329+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4493 | 39568 | swimming_water_cyanobacteria | 2019-07-28T08:44:55.677123+0300 | 2019-07-29T08:44:55.677123+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4444 | 40802 | swimming_water_cyanobacteria | 2019-07-27T11:18:06.458000+0300 | 2019-07-28T11:18:06.458000+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4443 | 40802 | swimming_water_cyanobacteria | 2019-07-27T11:17:52.053161+0300 | 2019-07-28T11:17:52.053161+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4442 | 40802 | swimming_water_cyanobacteria | 2019-07-27T11:17:30.716946+0300 | 2019-07-28T11:17:30.716946+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4433 | 41601 | swimming_water_cyanobacteria | 2019-07-27T10:23:55.060897+0300 | 2019-07-28T10:23:55.060897+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4427 | 41601 | swimming_water_cyanobacteria | 2019-07-27T10:21:52.834077+0300 | 2019-07-28T10:21:52.834077+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4426 | 41791 | swimming_water_cyanobacteria | 2019-07-27T10:20:20.755763+0300 | 2019-07-28T10:20:20.755763+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
4425 | 41601 | swimming_water_cyanobacteria | 2019-07-27T10:20:20.097666+0300 | 2019-07-28T10:20:20.097666+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable |
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 );