observation
51,120 rows sorted by value_fi
This data as json, CSV (advanced)
name_sv ✖
- Inga blågröna alger 2,771
- Lite blågröna alger 1,880
- Isad 1,452
- 17-19°C 1,251
- 19-21°C 1,242
- 15-17°C 790
- 21-23°C 746
- Plogad 526
- under 15°C 482
- Stängd 419
- Rikligt med blågröna alger 281
- Iståndsatt 220
- över 23°C 180
- Bra 147
- Isningen har inletts 117
- Mycket rikligt med blågröna alger 94
- Hyfsad 92
- Snöbrist 54
- Svag 20
- Snöproduktionen oavslutad 16
- Stängd av andra skäl 16
- Säsongen igång 8
- Säsongen är över 5
- Tävlingar/träningar 4
- Grunden lagd (inget skidspår) 2
id | unit | property | time | expiration_time | value_fi ▼ | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
169 | 40993 | swimming_water_temperature | 2019-06-06T12:51:31.517274+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
170 | 40993 | swimming_water_temperature | 2019-06-06T12:51:31.651501+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
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 | ||||
174 | 39693 | swimming_water_cyanobacteria | 2019-06-06T13:43:56.339090+0300 | 2019-06-07T13:43:56.339090+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
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 | |||
182 | 40950 | swimming_water_temperature | 2019-06-06T14:10:39.914760+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
184 | 39815 | swimming_water_temperature | 2019-06-06T15:18:31.932506+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
185 | 39815 | swimming_water_cyanobacteria | 2019-06-06T15:18:32.085266+0300 | 2019-06-07T15:18:32.085266+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
186 | 40386 | swimming_water_temperature | 2019-06-06T15:18:32.220657+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
187 | 39693 | swimming_water_temperature | 2019-06-06T17:51:51.799967+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
188 | 39693 | swimming_water_cyanobacteria | 2019-06-06T17:51:56.490257+0300 | 2019-06-07T17:51:56.490257+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
189 | 39815 | swimming_water_temperature | 2019-06-06T19:43:24.985518+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
190 | 39815 | swimming_water_cyanobacteria | 2019-06-06T19:43:29.756550+0300 | 2019-06-07T19:43:29.756550+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
192 | 39815 | swimming_water_temperature | 2019-06-07T08:30:29.052361+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
193 | 39815 | swimming_water_cyanobacteria | 2019-06-07T08:30:31.141466+0300 | 2019-06-08T08:30:31.141466+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
195 | 39693 | swimming_water_temperature | 2019-06-07T09:40:40.293487+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
196 | 39693 | swimming_water_cyanobacteria | 2019-06-07T09:40:44.456354+0300 | 2019-06-08T09:40:44.456354+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
197 | 39527 | swimming_water_temperature | 2019-06-07T09:44:25.167317+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
198 | 39527 | swimming_water_cyanobacteria | 2019-06-07T09:44:25.383206+0300 | 2019-06-08T09:44:25.383206+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
201 | 39815 | swimming_water_temperature | 2019-06-07T09:58:44.666515+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
202 | 39815 | swimming_water_cyanobacteria | 2019-06-07T09:58:46.944319+0300 | 2019-06-08T09:58:46.944319+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
204 | 40802 | swimming_water_temperature | 2019-06-07T10:02:44.386293+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
205 | 40802 | swimming_water_cyanobacteria | 2019-06-07T10:02:46.586267+0300 | 2019-06-08T10:02:46.586267+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
206 | 40950 | swimming_water_temperature | 2019-06-07T10:09:54.471137+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
207 | 41601 | swimming_water_temperature | 2019-06-07T10:14:41.514036+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
208 | 41601 | swimming_water_cyanobacteria | 2019-06-07T10:14:43.966094+0300 | 2019-06-08T10:14:43.966094+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
211 | 41791 | swimming_water_temperature | 2019-06-07T10:24:59.111664+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
212 | 41791 | swimming_water_temperature | 2019-06-07T10:25:44.452775+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
213 | 41791 | swimming_water_temperature | 2019-06-07T10:26:07.112503+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
214 | 40150 | swimming_water_temperature | 2019-06-07T10:35:30.790678+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
215 | 40150 | swimming_water_cyanobacteria | 2019-06-07T10:35:31.010497+0300 | 2019-06-08T10:35:31.010497+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
216 | 40157 | swimming_water_temperature | 2019-06-07T10:35:43.267632+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
217 | 40157 | swimming_water_cyanobacteria | 2019-06-07T10:35:47.192802+0300 | 2019-06-08T10:35:47.192802+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
218 | 40142 | swimming_water_temperature | 2019-06-07T11:22:11.956190+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
219 | 40142 | swimming_water_cyanobacteria | 2019-06-07T11:22:19.144470+0300 | 2019-06-08T11:22:19.144470+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
222 | 39322 | swimming_water_temperature | 2019-06-07T11:23:40.887777+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
223 | 39322 | swimming_water_cyanobacteria | 2019-06-07T11:23:46.934289+0300 | 2019-06-08T11:23:46.934289+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
224 | 39322 | swimming_water_temperature | 2019-06-07T11:35:37.055471+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
225 | 39322 | swimming_water_cyanobacteria | 2019-06-07T11:35:37.275884+0300 | 2019-06-08T11:35:37.275884+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
226 | 39322 | swimming_water_temperature | 2019-06-07T11:35:37.494252+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
227 | 39322 | swimming_water_cyanobacteria | 2019-06-07T11:35:37.729851+0300 | 2019-06-08T11:35:37.729851+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
228 | 39322 | swimming_water_temperature | 2019-06-07T11:35:37.963596+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
229 | 39322 | swimming_water_cyanobacteria | 2019-06-07T11:35:38.182549+0300 | 2019-06-08T11:35:38.182549+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
230 | 40559 | swimming_water_temperature | 2019-06-07T12:33:44.310597+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
231 | 40559 | swimming_water_cyanobacteria | 2019-06-07T12:33:46.546318+0300 | 2019-06-08T12:33:46.546318+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
232 | 41791 | swimming_water_temperature | 2019-06-07T13:42:22.858744+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
235 | 41791 | swimming_water_temperature | 2019-06-07T13:45:23.030764+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
236 | 41791 | swimming_water_cyanobacteria | 2019-06-07T13:45:35.883926+0300 | 2019-06-08T13:45:35.883926+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
237 | 39693 | swimming_water_cyanobacteria | 2019-06-07T13:53:20.573133+0300 | 2019-06-08T13:53:20.573133+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
238 | 39693 | swimming_water_temperature | 2019-06-07T13:53:24.595690+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
240 | 39815 | swimming_water_temperature | 2019-06-07T14:12:33.987424+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
241 | 39815 | swimming_water_cyanobacteria | 2019-06-07T14:12:36.283058+0300 | 2019-06-08T14:12:36.283058+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
244 | 39322 | swimming_water_temperature | 2019-06-07T15:15:49.773357+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
245 | 39322 | swimming_water_temperature | 2019-06-07T15:17:51.123747+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
246 | 39322 | swimming_water_cyanobacteria | 2019-06-07T15:17:51.371667+0300 | 2019-06-08T15:17:51.371667+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
247 | 39568 | swimming_water_temperature | 2019-06-07T16:12:54.240114+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
248 | 39568 | swimming_water_cyanobacteria | 2019-06-07T16:12:57.200876+0300 | 2019-06-08T16:12:57.200876+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
252 | 39583 | swimming_water_cyanobacteria | 2019-06-07T16:16:06.378059+0300 | 2019-06-08T16:16:06.378059+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
253 | 39583 | swimming_water_temperature | 2019-06-07T16:16:17.022761+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
255 | 39815 | swimming_water_temperature | 2019-06-07T18:22:39.344024+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
256 | 39815 | swimming_water_cyanobacteria | 2019-06-07T18:22:42.163638+0300 | 2019-06-08T18:22:42.163638+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
258 | 39322 | swimming_water_temperature | 2019-06-07T19:42:40.358960+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
259 | 39322 | swimming_water_cyanobacteria | 2019-06-07T19:42:43.393878+0300 | 2019-06-08T19:42:43.393878+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
264 | 39693 | swimming_water_cyanobacteria | 2019-06-08T08:17:34.950319+0300 | 2019-06-09T08:17:34.950319+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
265 | 39693 | swimming_water_temperature | 2019-06-08T08:17:40.785403+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
266 | 41791 | swimming_water_temperature | 2019-06-08T10:05:04.461932+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
267 | 41791 | swimming_water_cyanobacteria | 2019-06-08T10:05:12.370805+0300 | 2019-06-09T10:05:12.370805+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
268 | 40559 | swimming_water_temperature | 2019-06-08T10:06:22.810174+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
270 | 40559 | swimming_water_cyanobacteria | 2019-06-08T10:06:35.326766+0300 | 2019-06-09T10:06:35.326766+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
271 | 40157 | swimming_water_temperature | 2019-06-08T10:08:25.066166+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
272 | 40157 | swimming_water_cyanobacteria | 2019-06-08T10:08:29.379228+0300 | 2019-06-09T10:08:29.379228+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
273 | 39815 | swimming_water_temperature | 2019-06-08T10:19:17.389316+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
274 | 39815 | swimming_water_cyanobacteria | 2019-06-08T10:19:19.630268+0300 | 2019-06-09T10:19:19.630268+0300 | Ei sinilevää | Inga blågröna alger | 1 | No cyanobacteria | 0 | good | |||
275 | 41601 | swimming_water_temperature | 2019-06-08T10:39:32.888284+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
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 );