observation
51,120 rows
This data as json, CSV (advanced)
property ✖
- live_swimming_water_temperature 34,569
- swimming_water_cyanobacteria 5,010
- swimming_water_temperature 4,648
- notice 3,581
- ice_skating_field_condition 2,494
- ski_trail_condition 355
- ski_trail_maintenance 220
- season_status 13
| id ▼ | unit | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 276 | 41601 | swimming_water_cyanobacteria | 2019-06-08T10:39:35.893100+0300 | 2019-06-09T10:39:35.893100+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 277 | 40950 | swimming_water_temperature | 2019-06-08T10:42:23.679616+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 278 | 40950 | swimming_water_cyanobacteria | 2019-06-08T10:42:27.900203+0300 | 2019-06-09T10:42:27.900203+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 279 | 40950 | swimming_water_temperature | 2019-06-08T10:42:31.568387+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 280 | 40950 | swimming_water_temperature | 2019-06-08T10:42:39.967382+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 281 | 40950 | notice | 2019-06-08T10:43:16.278124+0300 | Valvonta klo. 10-18 | |||||||||
| 282 | 40142 | swimming_water_temperature | 2019-06-08T10:56:28.697399+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 283 | 40142 | swimming_water_cyanobacteria | 2019-06-08T10:56:32.085681+0300 | 2019-06-09T10:56:32.085681+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 284 | 40142 | notice | 2019-06-08T10:56:35.146446+0300 | Rantavalvojat paikalla 3.6.-11.8.2019 klo 10-20, joka päivä. Yleiset tilat menevät kiinni noin kello 19:45. Ranta hyvässä kunnossa. | |||||||||
| 285 | 39568 | swimming_water_temperature | 2019-06-08T11:04:03.917676+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 286 | 39568 | swimming_water_cyanobacteria | 2019-06-08T11:04:09.535241+0300 | 2019-06-09T11:04:09.535241+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 287 | 39568 | swimming_water_temperature | 2019-06-08T11:04:17.424698+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 288 | 40950 | swimming_water_temperature | 2019-06-08T13:50:00.248514+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 289 | 39693 | swimming_water_temperature | 2019-06-08T14:07:46.413233+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 290 | 39693 | swimming_water_cyanobacteria | 2019-06-08T14:07:54.007108+0300 | 2019-06-09T14:07:54.007108+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 291 | 39693 | notice | 2019-06-08T14:08:01.969988+0300 | Veden lämpötila 23º a stetta | |||||||||
| 292 | 39693 | notice | 2019-06-08T14:08:17.671686+0300 | Veden lämpötila 23º astetta | |||||||||
| 293 | 39815 | swimming_water_temperature | 2019-06-08T14:37:24.368764+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 294 | 39815 | swimming_water_cyanobacteria | 2019-06-08T14:37:26.875102+0300 | 2019-06-09T14:37:26.875102+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 295 | 39815 | notice | 2019-06-08T14:37:33.157156+0300 | Vesi 23°C | |||||||||
| 296 | 39267 | swimming_water_temperature | 2019-06-08T17:01:07.633245+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 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 | |||
| 298 | 39815 | swimming_water_temperature | 2019-06-08T17:52:09.671494+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 299 | 39815 | swimming_water_cyanobacteria | 2019-06-08T17:52:12.127172+0300 | 2019-06-09T17:52:12.127172+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 300 | 39815 | notice | 2019-06-08T17:52:14.091476+0300 | Vesi 23°C | |||||||||
| 301 | 39267 | swimming_water_temperature | 2019-06-08T17:58:54.777603+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 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 | |||
| 303 | 39693 | swimming_water_temperature | 2019-06-08T17:59:20.966316+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 304 | 39693 | swimming_water_cyanobacteria | 2019-06-08T17:59:31.611858+0300 | 2019-06-09T17:59:31.611858+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 305 | 39693 | notice | 2019-06-08T17:59:48.663080+0300 | Veden lämpötila 23º astetta | |||||||||
| 306 | 39693 | notice | 2019-06-08T17:59:59.716206+0300 | Veden lämpötila 23º astetta | |||||||||
| 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 | |||
| 308 | 52959 | swimming_water_cyanobacteria | 2019-06-08T23:42:58.130605+0300 | 2019-06-09T23:42:58.130605+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 309 | 39527 | swimming_water_cyanobacteria | 2019-06-08T23:43:20.801648+0300 | 2019-06-09T23:43:20.801648+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 310 | 40921 | swimming_water_temperature | 2019-06-09T08:58:41.314672+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 311 | 40921 | swimming_water_cyanobacteria | 2019-06-09T08:58:46.214216+0300 | 2019-06-10T08:58:46.214216+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 312 | 41326 | swimming_water_temperature | 2019-06-09T08:59:01.215687+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 313 | 41326 | swimming_water_cyanobacteria | 2019-06-09T08:59:03.247621+0300 | 2019-06-10T08:59:03.247621+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 314 | 40020 | swimming_water_temperature | 2019-06-09T08:59:13.060529+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 315 | 40020 | swimming_water_cyanobacteria | 2019-06-09T08:59:14.907268+0300 | 2019-06-10T08:59:14.907268+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 316 | 40677 | swimming_water_temperature | 2019-06-09T08:59:50.077804+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 317 | 40677 | swimming_water_cyanobacteria | 2019-06-09T08:59:51.845599+0300 | 2019-06-10T08:59:51.845599+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 318 | 41907 | swimming_water_temperature | 2019-06-09T09:00:59.552292+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 319 | 41907 | swimming_water_cyanobacteria | 2019-06-09T09:01:01.776393+0300 | 2019-06-10T09:01:01.776393+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 320 | 39910 | swimming_water_temperature | 2019-06-09T09:01:09.742957+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 321 | 39910 | swimming_water_cyanobacteria | 2019-06-09T09:01:11.390362+0300 | 2019-06-10T09:01:11.390362+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 322 | 40798 | swimming_water_temperature | 2019-06-09T09:01:21.102140+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 323 | 40798 | swimming_water_cyanobacteria | 2019-06-09T09:01:22.807277+0300 | 2019-06-10T09:01:22.807277+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 324 | 41791 | swimming_water_temperature | 2019-06-09T09:56:10.160415+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 325 | 41791 | swimming_water_cyanobacteria | 2019-06-09T09:56:13.442634+0300 | 2019-06-10T09:56:13.442634+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 326 | 41601 | swimming_water_temperature | 2019-06-09T10:04:55.527909+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 327 | 41601 | swimming_water_cyanobacteria | 2019-06-09T10:04:57.642821+0300 | 2019-06-10T10:04:57.642821+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 328 | 39693 | swimming_water_temperature | 2019-06-09T10:07:57.806433+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 329 | 39693 | swimming_water_cyanobacteria | 2019-06-09T10:08:00.843698+0300 | 2019-06-10T10:08:00.843698+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 330 | 39693 | notice | 2019-06-09T10:08:18.022589+0300 | Veden lämpötila 22º astetta | |||||||||
| 331 | 39815 | swimming_water_temperature | 2019-06-09T10:13:45.481338+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 332 | 39815 | swimming_water_cyanobacteria | 2019-06-09T10:13:47.623117+0300 | 2019-06-10T10:13:47.623117+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 333 | 39815 | notice | 2019-06-09T10:13:53.527653+0300 | Vesi 22°C | Vesi 22°C | ||||||||
| 334 | 40559 | swimming_water_temperature | 2019-06-09T10:15:07.789629+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 335 | 40559 | notice | 2019-06-09T10:15:15.581523+0300 | ||||||||||
| 336 | 39322 | swimming_water_temperature | 2019-06-09T10:15:16.605748+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 337 | 40559 | swimming_water_cyanobacteria | 2019-06-09T10:15:18.357109+0300 | 2019-06-10T10:15:18.357109+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 | |||
| 339 | 39267 | swimming_water_temperature | 2019-06-09T10:21:42.793020+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 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 | |||
| 341 | 40950 | swimming_water_temperature | 2019-06-09T10:22:13.251403+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 342 | 40950 | swimming_water_cyanobacteria | 2019-06-09T10:22:30.603308+0300 | 2019-06-10T10:22:30.603308+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 343 | 40157 | swimming_water_temperature | 2019-06-09T10:23:07.028385+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 344 | 40157 | swimming_water_cyanobacteria | 2019-06-09T10:23:09.627366+0300 | 2019-06-10T10:23:09.627366+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 345 | 40142 | swimming_water_temperature | 2019-06-09T10:31:49.644740+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 346 | 40142 | swimming_water_cyanobacteria | 2019-06-09T10:31:52.689274+0300 | 2019-06-10T10:31:52.689274+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 347 | 40142 | notice | 2019-06-09T10:31:55.737111+0300 | Rantavalvojat paikalla 3.6.-11.8.2019 klo 10-20, joka päivä. Yleiset tilat menevät kiinni noin kello 19:45. Ranta hyvässä kunnossa. | |||||||||
| 348 | 40258 | swimming_water_temperature | 2019-06-09T10:45:11.049642+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 349 | 40258 | swimming_water_cyanobacteria | 2019-06-09T10:45:17.109611+0300 | 2019-06-10T10:45:17.109611+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 350 | 40258 | notice | 2019-06-09T10:45:23.660646+0300 | Valvonta rannalla klo 10-20 | |||||||||
| 351 | 40258 | notice | 2019-06-09T10:45:27.486517+0300 | Valvonta rannalla klo 10-20 | |||||||||
| 352 | 40150 | swimming_water_temperature | 2019-06-09T12:28:43.832936+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 353 | 40150 | swimming_water_cyanobacteria | 2019-06-09T12:28:44.046330+0300 | 2019-06-10T12:28:44.046330+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 354 | 40098 | swimming_water_temperature | 2019-06-09T12:28:44.344657+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 355 | 40098 | swimming_water_cyanobacteria | 2019-06-09T12:28:44.546780+0300 | 2019-06-10T12:28:44.546780+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 356 | 39815 | swimming_water_temperature | 2019-06-09T13:56:38.214778+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 357 | 39815 | swimming_water_cyanobacteria | 2019-06-09T13:56:42.913548+0300 | 2019-06-10T13:56:42.913548+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 358 | 39815 | notice | 2019-06-09T13:57:22.856366+0300 | Vesi 23°C | |||||||||
| 359 | 39815 | notice | 2019-06-09T13:57:35.221412+0300 | Vesi 23°C | |||||||||
| 360 | 39815 | notice | 2019-06-09T13:57:38.661993+0300 | Vesi 23°C | |||||||||
| 361 | 39815 | notice | 2019-06-09T13:57:40.764003+0300 | Vesi 23°C | |||||||||
| 362 | 39815 | notice | 2019-06-09T13:57:41.489198+0300 | Vesi 23°C | |||||||||
| 363 | 39815 | notice | 2019-06-09T13:57:42.192799+0300 | Vesi 23°C | |||||||||
| 364 | 39815 | notice | 2019-06-09T13:57:42.429334+0300 | Vesi 23°C | Vesi 23°C | ||||||||
| 365 | 39815 | notice | 2019-06-09T13:57:42.638897+0300 | Vesi 23°C | |||||||||
| 366 | 39322 | swimming_water_temperature | 2019-06-09T14:07:43.671307+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 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 | |||
| 368 | 39693 | swimming_water_temperature | 2019-06-09T14:14:24.082178+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 369 | 39693 | notice | 2019-06-09T14:14:25.551302+0300 | Veden lämpötila 22º astetta | |||||||||
| 370 | 39693 | swimming_water_cyanobacteria | 2019-06-09T14:14:29.120574+0300 | 2019-06-10T14:14:29.120574+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 371 | 39693 | swimming_water_temperature | 2019-06-09T17:53:47.088974+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 372 | 39693 | notice | 2019-06-09T17:53:47.096114+0300 | Veden lämpötila 22º astetta | Veden lämpötila 22º astetta | ||||||||
| 373 | 39693 | swimming_water_cyanobacteria | 2019-06-09T17:53:48.981656+0300 | 2019-06-10T17:53:48.981656+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
| 374 | 39267 | swimming_water_temperature | 2019-06-09T17:54:11.286114+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 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 |
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 );