observation

51,120 rows

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
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  
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                
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  
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  
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  
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  
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  
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                
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  
269 40559 notice 2019-06-08T10:06:31.513803+0300   18 astetta                
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  
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  

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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
);