observation
51,120 rows sorted by unit
This data as json, CSV (advanced)
name_en ✖
- No cyanobacteria 2,809
- Some cyanobacteria 1,881
- Ice-covered 1,452
- 17-19°C 1,261
- 19-21°C 1,246
- 15-17°C 818
- 21-23°C 746
- Cleared of snow 526
- below 15°C 497
- Closed 419
- Plenty of cyanobacteria 281
- Maintenance finished 220
- above 23°C 180
- Good condition 147
- The icing has begun 117
- Very high levels of cyanobacteria 94
- Decent 92
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
167 | 39267 | notice | 2019-06-06T11:41:52.730227+0300 | ||||||||||
173 | 39267 | swimming_water_temperature | 2019-06-06T12:51:32.063938+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
180 | 39267 | swimming_water_temperature | 2019-06-06T14:10:39.608279+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
402 | 39267 | swimming_water_temperature | 2019-06-10T10:34:16.433547+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
414 | 39267 | swimming_water_temperature | 2019-06-10T13:56:59.031717+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
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 | |||
477 | 39267 | swimming_water_temperature | 2019-06-11T10:10:30.491830+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
559 | 39267 | swimming_water_cyanobacteria | 2019-06-11T14:00:01.071450+0300 | 2019-06-12T14:00:01.071450+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
560 | 39267 | swimming_water_temperature | 2019-06-11T14:00:08.545368+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
567 | 39267 | swimming_water_temperature | 2019-06-11T17:56:58.976591+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
568 | 39267 | swimming_water_cyanobacteria | 2019-06-11T17:57:02.168113+0300 | 2019-06-12T17:57:02.168113+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
586 | 39267 | swimming_water_temperature | 2019-06-12T10:22:49.596387+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
590 | 39267 | swimming_water_temperature | 2019-06-12T10:45:40.373126+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
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 | |||
607 | 39267 | swimming_water_temperature | 2019-06-12T14:02:38.897497+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
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 | |||
654 | 39267 | swimming_water_temperature | 2019-06-13T10:08:49.115932+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
685 | 39267 | swimming_water_temperature | 2019-06-13T15:03:53.067568+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
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 | |||
720 | 39267 | swimming_water_temperature | 2019-06-14T10:04:47.457711+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
721 | 39267 | swimming_water_cyanobacteria | 2019-06-14T10:05:35.446913+0300 | 2019-06-15T10:05:35.446913+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
745 | 39267 | swimming_water_temperature | 2019-06-14T17:56:22.115728+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
746 | 39267 | swimming_water_cyanobacteria | 2019-06-14T17:56:44.684015+0300 | 2019-06-15T17:56:44.684015+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
766 | 39267 | swimming_water_temperature | 2019-06-15T10:23:55.291543+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
767 | 39267 | swimming_water_cyanobacteria | 2019-06-15T10:24:01.520366+0300 | 2019-06-16T10:24:01.520366+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
789 | 39267 | swimming_water_temperature | 2019-06-15T15:47:49.654002+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
790 | 39267 | swimming_water_cyanobacteria | 2019-06-15T15:47:53.775392+0300 | 2019-06-16T15:47:53.775392+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
839 | 39267 | swimming_water_temperature | 2019-06-16T10:13:35.683029+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
840 | 39267 | swimming_water_cyanobacteria | 2019-06-16T10:13:39.756849+0300 | 2019-06-17T10:13:39.756849+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
866 | 39267 | swimming_water_temperature | 2019-06-16T13:57:23.060048+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
867 | 39267 | swimming_water_cyanobacteria | 2019-06-16T13:57:29.422195+0300 | 2019-06-17T13:57:29.422195+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
876 | 39267 | swimming_water_temperature | 2019-06-16T17:52:59.322927+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
877 | 39267 | swimming_water_cyanobacteria | 2019-06-16T17:53:02.260278+0300 | 2019-06-17T17:53:02.260278+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
902 | 39267 | swimming_water_cyanobacteria | 2019-06-17T10:04:00.803311+0300 | 2019-06-18T10:04:00.803311+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
903 | 39267 | swimming_water_temperature | 2019-06-17T10:04:13.439995+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
933 | 39267 | swimming_water_temperature | 2019-06-17T13:59:33.608988+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
934 | 39267 | swimming_water_cyanobacteria | 2019-06-17T13:59:41.167721+0300 | 2019-06-18T13:59:41.167721+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
951 | 39267 | swimming_water_temperature | 2019-06-17T17:52:53.460520+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
952 | 39267 | swimming_water_cyanobacteria | 2019-06-17T17:52:56.665844+0300 | 2019-06-18T17:52:56.665844+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
979 | 39267 | swimming_water_temperature | 2019-06-18T10:04:57.735750+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
980 | 39267 | swimming_water_temperature | 2019-06-18T10:05:00.762138+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
981 | 39267 | swimming_water_cyanobacteria | 2019-06-18T10:05:04.684092+0300 | 2019-06-19T10:05:04.684092+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
1002 | 39267 | swimming_water_temperature | 2019-06-18T13:57:25.844224+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1003 | 39267 | swimming_water_cyanobacteria | 2019-06-18T13:57:29.809081+0300 | 2019-06-19T13:57:29.809081+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
1016 | 39267 | swimming_water_cyanobacteria | 2019-06-18T17:41:54.059959+0300 | 2019-06-19T17:41:54.059959+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
1017 | 39267 | swimming_water_temperature | 2019-06-18T17:41:59.020786+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1040 | 39267 | swimming_water_temperature | 2019-06-19T10:10:03.476058+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1041 | 39267 | swimming_water_cyanobacteria | 2019-06-19T10:10:09.189838+0300 | 2019-06-20T10:10:09.189838+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
1089 | 39267 | swimming_water_temperature | 2019-06-19T14:03:19.520056+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1090 | 39267 | swimming_water_cyanobacteria | 2019-06-19T14:03:23.722331+0300 | 2019-06-20T14:03:23.722331+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
1095 | 39267 | swimming_water_temperature | 2019-06-19T17:34:57.302155+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1096 | 39267 | swimming_water_cyanobacteria | 2019-06-19T17:35:00.848562+0300 | 2019-06-20T17:35:00.848562+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
1155 | 39267 | swimming_water_temperature | 2019-06-20T11:10:35.672801+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1156 | 39267 | swimming_water_cyanobacteria | 2019-06-20T11:10:42.343577+0300 | 2019-06-21T11:10:42.343577+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
1185 | 39267 | swimming_water_temperature | 2019-06-20T14:07:46.017198+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1186 | 39267 | swimming_water_cyanobacteria | 2019-06-20T14:07:52.466674+0300 | 2019-06-21T14:07:52.466674+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
1194 | 39267 | swimming_water_temperature | 2019-06-20T17:48:34.570676+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1195 | 39267 | swimming_water_cyanobacteria | 2019-06-20T17:48:38.752324+0300 | 2019-06-21T17:48:38.752324+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
1359 | 39267 | swimming_water_temperature | 2019-06-24T10:07:46.646036+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
1360 | 39267 | swimming_water_cyanobacteria | 2019-06-24T10:07:58.914113+0300 | 2019-06-25T10:07:58.914113+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
1426 | 39267 | swimming_water_temperature | 2019-06-24T14:13:53.042983+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
1427 | 39267 | swimming_water_cyanobacteria | 2019-06-24T14:13:55.769110+0300 | 2019-06-25T14:13:55.769110+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
1443 | 39267 | swimming_water_temperature | 2019-06-24T17:46:11.049406+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
1444 | 39267 | swimming_water_cyanobacteria | 2019-06-24T17:46:14.434426+0300 | 2019-06-25T17:46:14.434426+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
1470 | 39267 | swimming_water_temperature | 2019-06-25T10:16:26.334389+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1474 | 39267 | swimming_water_cyanobacteria | 2019-06-25T10:16:50.559655+0300 | 2019-06-26T10:16:50.559655+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1499 | 39267 | swimming_water_temperature | 2019-06-25T13:56:36.662049+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
1500 | 39267 | swimming_water_cyanobacteria | 2019-06-25T13:56:40.296869+0300 | 2019-06-26T13:56:40.296869+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
1537 | 39267 | swimming_water_temperature | 2019-06-25T17:45:23.883233+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
1538 | 39267 | swimming_water_cyanobacteria | 2019-06-25T17:45:28.044838+0300 | 2019-06-26T17:45:28.044838+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
1556 | 39267 | swimming_water_temperature | 2019-06-26T10:21:48.404757+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
1557 | 39267 | swimming_water_cyanobacteria | 2019-06-26T10:21:56.337607+0300 | 2019-06-27T10:21:56.337607+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
1578 | 39267 | swimming_water_temperature | 2019-06-26T14:04:59.960700+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
1579 | 39267 | swimming_water_cyanobacteria | 2019-06-26T14:05:07.395076+0300 | 2019-06-27T14:05:07.395076+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1589 | 39267 | swimming_water_temperature | 2019-06-26T18:01:29.156373+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
1590 | 39267 | swimming_water_cyanobacteria | 2019-06-26T18:01:32.930330+0300 | 2019-06-27T18:01:32.930330+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1614 | 39267 | swimming_water_temperature | 2019-06-27T10:12:18.028207+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1615 | 39267 | swimming_water_cyanobacteria | 2019-06-27T10:12:28.446126+0300 | 2019-06-28T10:12:28.446126+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1629 | 39267 | swimming_water_cyanobacteria | 2019-06-27T10:37:00.225862+0300 | 2019-06-28T10:37:00.225862+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
1700 | 39267 | swimming_water_temperature | 2019-06-27T14:45:09.722913+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1701 | 39267 | swimming_water_cyanobacteria | 2019-06-27T14:45:15.617184+0300 | 2019-06-28T14:45:15.617184+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
1706 | 39267 | swimming_water_temperature | 2019-06-27T17:48:29.213219+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1707 | 39267 | swimming_water_cyanobacteria | 2019-06-27T17:48:31.873013+0300 | 2019-06-28T17:48:31.873013+0300 | Vähän sinilevää | Lite blågröna alger | 1 | Some cyanobacteria | 1 | satisfactory | |||
1722 | 39267 | swimming_water_temperature | 2019-06-28T10:03:09.841126+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1723 | 39267 | swimming_water_cyanobacteria | 2019-06-28T10:03:13.874257+0300 | 2019-06-29T10:03:13.874257+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1755 | 39267 | swimming_water_temperature | 2019-06-28T12:30:03.099858+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
1756 | 39267 | swimming_water_temperature | 2019-06-28T14:01:28.720519+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1757 | 39267 | swimming_water_cyanobacteria | 2019-06-28T14:01:32.873491+0300 | 2019-06-29T14:01:32.873491+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1775 | 39267 | swimming_water_temperature | 2019-06-28T17:42:46.574985+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1776 | 39267 | swimming_water_cyanobacteria | 2019-06-28T17:42:49.663827+0300 | 2019-06-29T17:42:49.663827+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 );