observation
51,120 rows sorted by expiration_time
This data as json, CSV (advanced)
name_sv ✖
- Inga blågröna alger 2,809
- Lite blågröna alger 1,881
- Isad 1,452
- 17-19°C 1,246
- 19-21°C 1,240
- 15-17°C 790
- 21-23°C 745
- 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
name_en ✖
- No cyanobacteria 2,809
- Some cyanobacteria 1,881
- Ice-covered 1,452
- 17-19°C 1,246
- 19-21°C 1,240
- 15-17°C 790
- 21-23°C 745
- Cleared of snow 526
- below 15°C 482
- 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 8
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
191 | 39815 | notice | 2019-06-06T19:43:40.879925+0300 | Kesän 2019 uimavalvontakausi on Alkanut! Vesi 19ºC | |||||||||
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 | ||||
194 | 39815 | notice | 2019-06-07T08:30:53.437773+0300 | Kesän 2019 uimavalvontakausi on Alkanut! Vesi 20ºC | |||||||||
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 | ||||
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 | ||||
199 | 39527 | notice | 2019-06-07T09:44:25.598278+0300 | Kesän 2019 uimavalvontakausi on alkanut! | |||||||||
200 | 39527 | notice | 2019-06-07T09:44:25.795468+0300 | Kesän 2019 uimavalvontakausi on alkanut! | |||||||||
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 | ||||
203 | 39527 | notice | 2019-06-07T10:00:53.010960+0300 | Kesän 2019 uimavalvontakausi on alkanut! | |||||||||
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 | ||||
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 | ||||
209 | 41601 | notice | 2019-06-07T10:16:31.947231+0300 | Puh. 0504013590Sisäpukukopit suljetaan 1730Ulkosuihku, - pukukoppi ja bajamaja käytössä kellon ympäri | |||||||||
210 | 41601 | notice | 2019-06-07T10:17:00.874242+0300 | Puh. 0504013590 /Sisäpukukopit suljetaan 1730 /Ulkosuihku, - pukukoppi ja bajamaja käytössä kellon ympäri | |||||||||
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 | ||||
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 | ||||
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 | ||||
220 | 40142 | notice | 2019-06-07T11:22:30.692790+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. | |||||||||
221 | 40142 | notice | 2019-06-07T11:22:34.578216+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. | |||||||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
233 | 41791 | notice | 2019-06-07T13:42:34.258751+0300 | ||||||||||
234 | 41791 | notice | 2019-06-07T13:42:36.560646+0300 | ||||||||||
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 | ||||
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 | ||||
239 | 39693 | notice | 2019-06-07T13:53:42.721581+0300 | Veden lämpötila 21º astetta | |||||||||
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 | ||||
242 | 39815 | notice | 2019-06-07T14:12:53.667506+0300 | Kesän 2019 uimavalvontakausi on Alkanut! Vesi 22°C | |||||||||
243 | 39815 | notice | 2019-06-07T14:12:55.238468+0300 | Kesän 2019 uimavalvontakausi on Alkanut! Vesi 22°C | |||||||||
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 | ||||
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 | ||||
249 | 39568 | notice | 2019-06-07T16:13:30.959929+0300 | Valvontaa klo 8-20 aina 11.8 saakka, tervetuloa! | |||||||||
250 | 39568 | notice | 2019-06-07T16:13:32.342780+0300 | Valvontaa klo 8-20 aina 11.8 saakka, tervetuloa! | |||||||||
251 | 39583 | notice | 2019-06-07T16:16:03.890646+0300 | Uimavalvonta alkaa 24.6.2019 | |||||||||
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 | ||||
254 | 39693 | notice | 2019-06-07T18:00:59.029870+0300 | Veden lämpötila 22º a stetta | |||||||||
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 | ||||
257 | 39815 | notice | 2019-06-07T18:22:53.096142+0300 | Vesi 22°C | |||||||||
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 | ||||
260 | 39322 | notice | 2019-06-07T19:43:24.706395+0300 | Valvontaa rannalla klo 8-20 joka päivä 11.8 saakka, tervetuloa! | |||||||||
261 | 39322 | notice | 2019-06-07T19:43:27.312315+0300 | Valvontaa rannalla klo 8-20 joka päivä 11.8 saakka, tervetuloa! | |||||||||
262 | 39322 | notice | 2019-06-07T19:43:28.776751+0300 | Valvontaa rannalla klo 8-20 joka päivä 11.8 saakka, tervetuloa! | |||||||||
263 | 39693 | notice | 2019-06-08T08:17:31.498979+0300 | Veden lämpötila 21º a stetta | |||||||||
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 | ||||
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 | ||||
269 | 40559 | notice | 2019-06-08T10:06:31.513803+0300 | 18 astetta | |||||||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | |||||||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 |
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 );