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,254
- 19-21°C 1,215
- 15-17°C 818
- 21-23°C 732
- Cleared of snow 526
- below 15°C 497
- Closed 419
- Plenty of cyanobacteria 273
- Maintenance finished 220
- above 23°C 180
- Good condition 147
- The icing has begun 117
- Decent 92
- Very high levels of cyanobacteria 91
- 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
quality ✖
- good 4,934
- unknown 4,916
- satisfactory 1,949
- unusable 1,015
id | unit ▼ | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1789 | 39267 | swimming_water_temperature | 2019-06-29T09:59:30.222957+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1790 | 39267 | swimming_water_cyanobacteria | 2019-06-29T09:59:32.992284+0300 | 2019-06-30T09:59:32.992284+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1833 | 39267 | swimming_water_temperature | 2019-06-29T13:56:02.824526+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1834 | 39267 | swimming_water_cyanobacteria | 2019-06-29T13:56:10.814640+0300 | 2019-06-30T13:56:10.814640+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1846 | 39267 | swimming_water_temperature | 2019-06-29T17:48:43.073234+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1847 | 39267 | swimming_water_cyanobacteria | 2019-06-29T17:48:50.016329+0300 | 2019-06-30T17:48:50.016329+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1876 | 39267 | swimming_water_temperature | 2019-06-30T10:12:20.686299+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1877 | 39267 | swimming_water_cyanobacteria | 2019-06-30T10:12:26.595205+0300 | 2019-07-01T10:12:26.595205+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1907 | 39267 | swimming_water_temperature | 2019-06-30T14:03:07.579893+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1908 | 39267 | swimming_water_cyanobacteria | 2019-06-30T14:03:13.873297+0300 | 2019-07-01T14:03:13.873297+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1923 | 39267 | swimming_water_temperature | 2019-06-30T17:38:52.157617+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1924 | 39267 | swimming_water_cyanobacteria | 2019-06-30T17:38:59.481516+0300 | 2019-07-01T17:38:59.481516+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
1953 | 39267 | swimming_water_temperature | 2019-07-01T09:59:33.828571+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1954 | 39267 | swimming_water_cyanobacteria | 2019-07-01T09:59:39.080433+0300 | 2019-07-02T09:59:39.080433+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2009 | 39267 | swimming_water_temperature | 2019-07-01T13:51:44.519459+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
2010 | 39267 | swimming_water_cyanobacteria | 2019-07-01T13:51:48.992729+0300 | 2019-07-02T13:51:48.992729+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2036 | 39267 | swimming_water_temperature | 2019-07-01T17:49:55.811806+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
2037 | 39267 | swimming_water_cyanobacteria | 2019-07-01T17:49:59.217861+0300 | 2019-07-02T17:49:59.217861+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2110 | 39267 | swimming_water_temperature | 2019-07-03T10:13:45.186996+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2112 | 39267 | swimming_water_temperature | 2019-07-03T10:15:05.155744+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2114 | 39267 | swimming_water_temperature | 2019-07-03T10:15:47.945661+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2115 | 39267 | swimming_water_cyanobacteria | 2019-07-03T10:15:50.706358+0300 | 2019-07-04T10:15:50.706358+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2142 | 39267 | swimming_water_temperature | 2019-07-03T14:13:00.697612+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
2143 | 39267 | swimming_water_cyanobacteria | 2019-07-03T14:13:04.257612+0300 | 2019-07-04T14:13:04.257612+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2189 | 39267 | swimming_water_temperature | 2019-07-04T10:10:10.186814+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
2190 | 39267 | swimming_water_cyanobacteria | 2019-07-04T10:10:15.014333+0300 | 2019-07-05T10:10:15.014333+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2233 | 39267 | swimming_water_temperature | 2019-07-04T14:12:12.592060+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
2234 | 39267 | swimming_water_cyanobacteria | 2019-07-04T14:12:16.814909+0300 | 2019-07-05T14:12:16.814909+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2244 | 39267 | swimming_water_temperature | 2019-07-04T17:45:26.344932+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
2245 | 39267 | swimming_water_cyanobacteria | 2019-07-04T17:45:33.968651+0300 | 2019-07-05T17:45:33.968651+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2317 | 39267 | swimming_water_temperature | 2019-07-05T12:33:07.402395+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2318 | 39267 | swimming_water_cyanobacteria | 2019-07-05T12:33:19.308854+0300 | 2019-07-06T12:33:19.308854+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2326 | 39267 | swimming_water_temperature | 2019-07-05T14:05:04.871221+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2327 | 39267 | swimming_water_cyanobacteria | 2019-07-05T14:05:15.534562+0300 | 2019-07-06T14:05:15.534562+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2338 | 39267 | swimming_water_temperature | 2019-07-05T18:00:06.343013+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2340 | 39267 | swimming_water_cyanobacteria | 2019-07-05T18:00:10.779753+0300 | 2019-07-06T18:00:10.779753+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2373 | 39267 | swimming_water_temperature | 2019-07-06T10:17:47.427550+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2375 | 39267 | swimming_water_cyanobacteria | 2019-07-06T10:17:52.405252+0300 | 2019-07-07T10:17:52.405252+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2400 | 39267 | swimming_water_temperature | 2019-07-06T14:04:02.458633+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
2401 | 39267 | swimming_water_cyanobacteria | 2019-07-06T14:04:07.409313+0300 | 2019-07-07T14:04:07.409313+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2411 | 39267 | swimming_water_temperature | 2019-07-06T17:48:22.255463+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
2412 | 39267 | swimming_water_cyanobacteria | 2019-07-06T17:48:28.825465+0300 | 2019-07-07T17:48:28.825465+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2430 | 39267 | swimming_water_cyanobacteria | 2019-07-07T10:03:18.702191+0300 | 2019-07-08T10:03:18.702191+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2431 | 39267 | swimming_water_temperature | 2019-07-07T10:07:56.387691+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2471 | 39267 | swimming_water_temperature | 2019-07-07T13:54:25.098157+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2472 | 39267 | swimming_water_cyanobacteria | 2019-07-07T13:54:31.207894+0300 | 2019-07-08T13:54:31.207894+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2488 | 39267 | swimming_water_temperature | 2019-07-07T17:53:52.990159+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2489 | 39267 | swimming_water_cyanobacteria | 2019-07-07T17:53:55.571998+0300 | 2019-07-08T17:53:55.571998+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2507 | 39267 | swimming_water_temperature | 2019-07-08T10:01:25.838792+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2508 | 39267 | swimming_water_cyanobacteria | 2019-07-08T10:01:28.571989+0300 | 2019-07-09T10:01:28.571989+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2544 | 39267 | swimming_water_temperature | 2019-07-08T13:53:49.390740+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2545 | 39267 | swimming_water_cyanobacteria | 2019-07-08T13:53:53.200144+0300 | 2019-07-09T13:53:53.200144+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2565 | 39267 | swimming_water_temperature | 2019-07-08T17:37:10.792865+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
2566 | 39267 | swimming_water_cyanobacteria | 2019-07-08T17:37:16.075515+0300 | 2019-07-09T17:37:16.075515+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2603 | 39267 | swimming_water_temperature | 2019-07-09T10:50:29.075385+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2604 | 39267 | swimming_water_cyanobacteria | 2019-07-09T10:50:33.661335+0300 | 2019-07-10T10:50:33.661335+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2620 | 39267 | swimming_water_temperature | 2019-07-09T16:00:51.895245+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2621 | 39267 | swimming_water_cyanobacteria | 2019-07-09T16:00:54.993722+0300 | 2019-07-10T16:00:54.993722+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2622 | 39267 | swimming_water_temperature | 2019-07-09T17:48:13.835579+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2623 | 39267 | swimming_water_cyanobacteria | 2019-07-09T17:48:16.860886+0300 | 2019-07-10T17:48:16.860886+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2659 | 39267 | swimming_water_temperature | 2019-07-10T10:00:50.201105+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2660 | 39267 | swimming_water_cyanobacteria | 2019-07-10T10:00:53.096823+0300 | 2019-07-11T10:00:53.096823+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2716 | 39267 | swimming_water_temperature | 2019-07-10T14:49:51.523271+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2717 | 39267 | swimming_water_cyanobacteria | 2019-07-10T14:49:59.596844+0300 | 2019-07-11T14:49:59.596844+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2725 | 39267 | swimming_water_temperature | 2019-07-10T17:46:18.601814+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2726 | 39267 | swimming_water_cyanobacteria | 2019-07-10T17:46:26.116613+0300 | 2019-07-11T17:46:26.116613+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2801 | 39267 | swimming_water_temperature | 2019-07-11T15:15:35.883695+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2802 | 39267 | swimming_water_cyanobacteria | 2019-07-11T15:15:41.153681+0300 | 2019-07-12T15:15:41.153681+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2803 | 39267 | swimming_water_cyanobacteria | 2019-07-11T15:15:43.693659+0300 | 2019-07-12T15:15:43.693659+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2809 | 39267 | swimming_water_temperature | 2019-07-11T17:57:47.566309+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2810 | 39267 | swimming_water_cyanobacteria | 2019-07-11T17:57:50.323784+0300 | 2019-07-12T17:57:50.323784+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2827 | 39267 | swimming_water_temperature | 2019-07-12T10:04:28.034084+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2828 | 39267 | swimming_water_cyanobacteria | 2019-07-12T10:04:30.878488+0300 | 2019-07-13T10:04:30.878488+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2857 | 39267 | swimming_water_temperature | 2019-07-12T14:01:13.640568+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2858 | 39267 | swimming_water_cyanobacteria | 2019-07-12T14:01:16.595045+0300 | 2019-07-13T14:01:16.595045+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2873 | 39267 | swimming_water_temperature | 2019-07-12T17:47:57.139204+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2874 | 39267 | swimming_water_cyanobacteria | 2019-07-12T17:47:59.735519+0300 | 2019-07-13T17:47:59.735519+0300 | Erittäin runsaasti sinilevää | Mycket rikligt med blågröna alger | 1 | Very high levels of cyanobacteria | 3 | unusable | |||
2888 | 39267 | swimming_water_cyanobacteria | 2019-07-13T10:03:16.125405+0300 | 2019-07-14T10:03:16.125405+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2889 | 39267 | swimming_water_temperature | 2019-07-13T10:03:49.496036+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2932 | 39267 | swimming_water_temperature | 2019-07-13T14:39:05.529237+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2933 | 39267 | swimming_water_cyanobacteria | 2019-07-13T14:39:08.561550+0300 | 2019-07-14T14:39:08.561550+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2939 | 39267 | swimming_water_temperature | 2019-07-13T17:45:21.461912+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2940 | 39267 | swimming_water_cyanobacteria | 2019-07-13T17:45:44.945271+0300 | 2019-07-14T17:45:44.945271+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
2975 | 39267 | swimming_water_temperature | 2019-07-14T10:14:52.184559+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2976 | 39267 | swimming_water_cyanobacteria | 2019-07-14T10:15:00.625315+0300 | 2019-07-15T10:15:00.625315+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3004 | 39267 | swimming_water_temperature | 2019-07-14T14:53:49.894309+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3005 | 39267 | swimming_water_cyanobacteria | 2019-07-14T14:53:53.347520+0300 | 2019-07-15T14:53:53.347520+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3015 | 39267 | swimming_water_temperature | 2019-07-14T17:52:33.761530+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3016 | 39267 | swimming_water_cyanobacteria | 2019-07-14T17:52:36.351142+0300 | 2019-07-15T17:52:36.351142+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3038 | 39267 | swimming_water_cyanobacteria | 2019-07-15T10:04:23.444120+0300 | 2019-07-16T10:04:23.444120+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3039 | 39267 | swimming_water_temperature | 2019-07-15T10:04:27.014528+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3098 | 39267 | swimming_water_temperature | 2019-07-15T14:28:25.914776+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3099 | 39267 | swimming_water_cyanobacteria | 2019-07-15T14:28:31.862333+0300 | 2019-07-16T14:28:31.862333+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3105 | 39267 | swimming_water_temperature | 2019-07-15T17:44:05.128481+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3106 | 39267 | swimming_water_cyanobacteria | 2019-07-15T17:44:12.716109+0300 | 2019-07-16T17:44:12.716109+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3117 | 39267 | swimming_water_temperature | 2019-07-16T09:59:31.850108+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3119 | 39267 | swimming_water_cyanobacteria | 2019-07-16T09:59:50.396099+0300 | 2019-07-17T09:59:50.396099+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3162 | 39267 | swimming_water_temperature | 2019-07-16T15:09:56.292322+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3163 | 39267 | swimming_water_cyanobacteria | 2019-07-16T15:10:01.452514+0300 | 2019-07-17T15:10:01.452514+0300 | Runsaasti sinilevää | Rikligt med blågröna alger | 1 | Plenty of cyanobacteria | 2 | unusable | |||
3200 | 39267 | swimming_water_temperature | 2019-07-17T10:05:54.033584+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown |
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 );