observation
51,120 rows sorted by unit
This data as json, CSV (advanced)
name_en ✖
- No cyanobacteria 2,799
- Some cyanobacteria 1,855
- Ice-covered 1,452
- 17-19°C 1,227
- 19-21°C 1,191
- 15-17°C 818
- 21-23°C 732
- Cleared of snow 526
- below 15°C 497
- Closed 419
- Plenty of cyanobacteria 240
- Maintenance finished 220
- above 23°C 180
- Good condition 147
- The icing has begun 117
- Decent 92
- Very high levels of cyanobacteria 75
- Lack of snow 54
- Poor condition 20
- Closed for other reasons 16
- Snowmaking unfinished 16
- Season underway 10
- Season over 5
- Closed due to training or a competition 4
- Foundation laid (no skiing trail) 2
| id | unit ▼ | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3201 | 39267 | swimming_water_cyanobacteria | 2019-07-17T10:05:57.343600+0300 | 2019-07-18T10:05:57.343600+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
| 3246 | 39267 | swimming_water_temperature | 2019-07-17T14:02:52.847107+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 3247 | 39267 | swimming_water_cyanobacteria | 2019-07-17T14:02:55.800300+0300 | 2019-07-18T14:02:55.800300+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
| 3262 | 39267 | swimming_water_temperature | 2019-07-17T17:50:33.597449+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 3263 | 39267 | swimming_water_cyanobacteria | 2019-07-17T17:50:39.340483+0300 | 2019-07-18T17:50:39.340483+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
| 3292 | 39267 | swimming_water_temperature | 2019-07-18T09:59:48.718039+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 3293 | 39267 | swimming_water_cyanobacteria | 2019-07-18T09:59:50.826852+0300 | 2019-07-19T09:59:50.826852+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
| 3357 | 39267 | swimming_water_cyanobacteria | 2019-07-18T14:12:18.732739+0300 | 2019-07-19T14:12:18.732739+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 3358 | 39267 | swimming_water_temperature | 2019-07-18T14:12:23.276428+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 3386 | 39267 | swimming_water_cyanobacteria | 2019-07-18T17:52:23.015217+0300 | 2019-07-19T17:52:23.015217+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 3387 | 39267 | swimming_water_temperature | 2019-07-18T17:52:27.258064+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 3432 | 39267 | swimming_water_cyanobacteria | 2019-07-19T10:13:11.926419+0300 | 2019-07-20T10:13:11.926419+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 3433 | 39267 | swimming_water_temperature | 2019-07-19T10:13:18.233405+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 3469 | 39267 | swimming_water_temperature | 2019-07-19T13:53:31.318038+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 3470 | 39267 | swimming_water_cyanobacteria | 2019-07-19T13:53:36.819492+0300 | 2019-07-20T13:53:36.819492+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
| 3518 | 39267 | swimming_water_temperature | 2019-07-19T17:43:23.836817+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 3519 | 39267 | swimming_water_cyanobacteria | 2019-07-19T17:43:27.178015+0300 | 2019-07-20T17:43:27.178015+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 3537 | 39267 | swimming_water_temperature | 2019-07-20T09:57:54.462401+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 3538 | 39267 | swimming_water_cyanobacteria | 2019-07-20T09:57:57.706804+0300 | 2019-07-21T09:57:57.706804+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 3587 | 39267 | swimming_water_temperature | 2019-07-20T14:01:36.230761+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 3588 | 39267 | swimming_water_cyanobacteria | 2019-07-20T14:01:40.424177+0300 | 2019-07-21T14:01:40.424177+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 3603 | 39267 | swimming_water_temperature | 2019-07-20T17:45:25.194745+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 3604 | 39267 | swimming_water_cyanobacteria | 2019-07-20T17:45:29.995612+0300 | 2019-07-21T17:45:29.995612+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 3656 | 39267 | swimming_water_temperature | 2019-07-21T10:40:00.785107+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 3657 | 39267 | swimming_water_cyanobacteria | 2019-07-21T10:40:05.044381+0300 | 2019-07-22T10:40:05.044381+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 3684 | 39267 | swimming_water_temperature | 2019-07-21T14:16:04.111380+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 3685 | 39267 | swimming_water_cyanobacteria | 2019-07-21T14:16:11.695215+0300 | 2019-07-22T14:16:11.695215+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 3692 | 39267 | swimming_water_temperature | 2019-07-21T17:48:00.694868+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 3693 | 39267 | swimming_water_cyanobacteria | 2019-07-21T17:48:03.581398+0300 | 2019-07-22T17:48:03.581398+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 3715 | 39267 | notice | 2019-07-21T20:18:33.454524+0300 | ||||||||||
| 3787 | 39267 | swimming_water_temperature | 2019-07-22T10:30:29.201404+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 3788 | 39267 | swimming_water_cyanobacteria | 2019-07-22T10:30:32.509663+0300 | 2019-07-23T10:30:32.509663+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 3802 | 39267 | swimming_water_temperature | 2019-07-22T14:07:58.998499+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 3803 | 39267 | swimming_water_cyanobacteria | 2019-07-22T14:08:04.367743+0300 | 2019-07-23T14:08:04.367743+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 3813 | 39267 | swimming_water_temperature | 2019-07-22T17:42:43.626233+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 3814 | 39267 | swimming_water_cyanobacteria | 2019-07-22T17:42:46.894045+0300 | 2019-07-23T17:42:46.894045+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 3891 | 39267 | swimming_water_temperature | 2019-07-23T10:28:44.044986+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 3892 | 39267 | swimming_water_cyanobacteria | 2019-07-23T10:28:51.269186+0300 | 2019-07-24T10:28:51.269186+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 3931 | 39267 | swimming_water_temperature | 2019-07-23T17:39:38.202978+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 3932 | 39267 | swimming_water_cyanobacteria | 2019-07-23T17:39:41.338508+0300 | 2019-07-24T17:39:41.338508+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
| 3960 | 39267 | swimming_water_temperature | 2019-07-24T10:00:56.694968+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 3962 | 39267 | swimming_water_cyanobacteria | 2019-07-24T10:01:11.837366+0300 | 2019-07-25T10:01:11.837366+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 4068 | 39267 | swimming_water_temperature | 2019-07-24T17:48:03.304207+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 4069 | 39267 | swimming_water_cyanobacteria | 2019-07-24T17:48:06.183927+0300 | 2019-07-25T17:48:06.183927+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 4112 | 39267 | swimming_water_temperature | 2019-07-25T10:15:52.017826+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 4113 | 39267 | swimming_water_cyanobacteria | 2019-07-25T10:16:00.668792+0300 | 2019-07-26T10:16:00.668792+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 4176 | 39267 | swimming_water_temperature | 2019-07-25T14:04:46.430645+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 4177 | 39267 | swimming_water_cyanobacteria | 2019-07-25T14:04:48.980385+0300 | 2019-07-26T14:04:48.980385+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 4201 | 39267 | swimming_water_temperature | 2019-07-25T17:48:45.083968+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 4202 | 39267 | swimming_water_cyanobacteria | 2019-07-25T17:48:48.714107+0300 | 2019-07-26T17:48:48.714107+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 4254 | 39267 | swimming_water_temperature | 2019-07-26T10:04:13.204558+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 4255 | 39267 | swimming_water_cyanobacteria | 2019-07-26T10:04:16.345992+0300 | 2019-07-27T10:04:16.345992+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 4338 | 39267 | swimming_water_temperature | 2019-07-26T14:08:48.575391+0300 | yli 23°C | över 23°C | 0 | above 23°C | 23-100 | unknown | ||||
| 4339 | 39267 | swimming_water_cyanobacteria | 2019-07-26T14:08:51.830789+0300 | 2019-07-27T14:08:51.830789+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 4346 | 39267 | swimming_water_temperature | 2019-07-26T17:32:52.575018+0300 | yli 23°C | över 23°C | 0 | above 23°C | 23-100 | unknown | ||||
| 4347 | 39267 | swimming_water_cyanobacteria | 2019-07-26T17:32:58.213239+0300 | 2019-07-27T17:32:58.213239+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 4477 | 39267 | swimming_water_temperature | 2019-07-27T17:44:10.582720+0300 | yli 23°C | över 23°C | 0 | above 23°C | 23-100 | unknown | ||||
| 4478 | 39267 | swimming_water_cyanobacteria | 2019-07-27T17:44:13.370271+0300 | 2019-07-28T17:44:13.370271+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 4526 | 39267 | swimming_water_temperature | 2019-07-28T14:26:37.323033+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 4527 | 39267 | swimming_water_cyanobacteria | 2019-07-28T14:26:42.693130+0300 | 2019-07-29T14:26:42.693130+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 4528 | 39267 | swimming_water_cyanobacteria | 2019-07-28T14:26:48.426702+0300 | 2019-07-29T14:26:48.426702+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 4545 | 39267 | swimming_water_cyanobacteria | 2019-07-28T17:51:04.347677+0300 | 2019-07-29T17:51:04.347677+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 4546 | 39267 | swimming_water_temperature | 2019-07-28T17:51:04.366394+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 4547 | 39267 | swimming_water_temperature | 2019-07-28T17:51:24.318070+0300 | yli 23°C | över 23°C | 0 | above 23°C | 23-100 | unknown | ||||
| 4548 | 39267 | swimming_water_cyanobacteria | 2019-07-28T17:51:29.366868+0300 | 2019-07-29T17:51:29.366868+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 4604 | 39267 | swimming_water_temperature | 2019-07-29T10:01:43.611270+0300 | yli 23°C | över 23°C | 0 | above 23°C | 23-100 | unknown | ||||
| 4605 | 39267 | swimming_water_cyanobacteria | 2019-07-29T10:01:46.931835+0300 | 2019-07-30T10:01:46.931835+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 4669 | 39267 | swimming_water_temperature | 2019-07-29T16:29:33.675718+0300 | yli 23°C | över 23°C | 0 | above 23°C | 23-100 | unknown | ||||
| 4670 | 39267 | swimming_water_cyanobacteria | 2019-07-29T16:29:39.539074+0300 | 2019-07-30T16:29:39.539074+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 4678 | 39267 | swimming_water_temperature | 2019-07-29T17:45:23.075920+0300 | yli 23°C | över 23°C | 0 | above 23°C | 23-100 | unknown | ||||
| 4679 | 39267 | swimming_water_cyanobacteria | 2019-07-29T17:45:26.230935+0300 | 2019-07-30T17:45:26.230935+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 4693 | 39267 | swimming_water_temperature | 2019-07-30T10:02:12.366747+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 4694 | 39267 | swimming_water_cyanobacteria | 2019-07-30T10:02:15.097382+0300 | 2019-07-31T10:02:15.097382+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 4742 | 39267 | swimming_water_temperature | 2019-07-30T15:03:15.597544+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 4743 | 39267 | swimming_water_cyanobacteria | 2019-07-30T15:03:18.832264+0300 | 2019-07-31T15:03:18.832264+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 4748 | 39267 | swimming_water_temperature | 2019-07-30T17:56:11.499554+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 4749 | 39267 | swimming_water_cyanobacteria | 2019-07-30T17:56:22.798647+0300 | 2019-07-31T17:56:22.798647+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 4791 | 39267 | swimming_water_temperature | 2019-07-31T10:34:55.208445+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 4792 | 39267 | swimming_water_cyanobacteria | 2019-07-31T10:34:59.167817+0300 | 2019-08-01T10:34:59.167817+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 4845 | 39267 | swimming_water_temperature | 2019-07-31T14:19:22.756997+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 4846 | 39267 | swimming_water_cyanobacteria | 2019-07-31T14:19:25.689029+0300 | 2019-08-01T14:19:25.689029+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 4856 | 39267 | swimming_water_temperature | 2019-07-31T17:56:10.631577+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 4857 | 39267 | swimming_water_cyanobacteria | 2019-07-31T17:56:15.225833+0300 | 2019-08-01T17:56:15.225833+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 4889 | 39267 | swimming_water_temperature | 2019-08-01T10:21:41.840771+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 4890 | 39267 | swimming_water_cyanobacteria | 2019-08-01T10:22:24.167017+0300 | 2019-08-02T10:22:24.167017+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 4891 | 39267 | swimming_water_temperature | 2019-08-01T10:22:31.076396+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 4993 | 39267 | swimming_water_temperature | 2019-08-02T10:12:01.767455+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 4994 | 39267 | swimming_water_cyanobacteria | 2019-08-02T10:12:09.118282+0300 | 2019-08-03T10:12:09.118282+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 5026 | 39267 | swimming_water_temperature | 2019-08-02T14:14:57.553497+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 5027 | 39267 | swimming_water_cyanobacteria | 2019-08-02T14:15:02.918142+0300 | 2019-08-03T14:15:02.918142+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 5064 | 39267 | swimming_water_temperature | 2019-08-02T17:52:21.937724+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 5065 | 39267 | swimming_water_cyanobacteria | 2019-08-02T17:52:26.040204+0300 | 2019-08-03T17:52:26.040204+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 5083 | 39267 | swimming_water_temperature | 2019-08-03T10:01:28.119974+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 5084 | 39267 | swimming_water_cyanobacteria | 2019-08-03T10:01:31.397425+0300 | 2019-08-04T10:01:31.397425+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 5136 | 39267 | swimming_water_temperature | 2019-08-03T14:25:59.503130+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 5137 | 39267 | swimming_water_cyanobacteria | 2019-08-03T14:26:02.401814+0300 | 2019-08-04T14:26:02.401814+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 5149 | 39267 | swimming_water_temperature | 2019-08-03T17:55:44.801691+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 5150 | 39267 | swimming_water_cyanobacteria | 2019-08-03T17:55:47.489964+0300 | 2019-08-04T17:55:47.489964+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
| 5162 | 39267 | swimming_water_temperature | 2019-08-04T09:54:26.944076+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 5163 | 39267 | swimming_water_cyanobacteria | 2019-08-04T09:54:29.957081+0300 | 2019-08-05T09:54:29.957081+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | 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 );