observation

4,968 rows where primary = 0

✎ View and edit SQL

This data as json, CSV (advanced)

primary ✖

  • 0 · 4,868 ✖
id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
348 40258 swimming_water_temperature 2019-06-09T10:45:11.049642+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
352 40150 swimming_water_temperature 2019-06-09T12:28:43.832936+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
354 40098 swimming_water_temperature 2019-06-09T12:28:44.344657+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
356 39815 swimming_water_temperature 2019-06-09T13:56:38.214778+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
366 39322 swimming_water_temperature 2019-06-09T14:07:43.671307+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
368 39693 swimming_water_temperature 2019-06-09T14:14:24.082178+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
371 39693 swimming_water_temperature 2019-06-09T17:53:47.088974+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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  
376 39815 swimming_water_temperature 2019-06-09T18:17:47.234884+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
377 39815 swimming_water_temperature 2019-06-09T18:17:50.236158+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
381 39322 swimming_water_temperature 2019-06-09T18:44:40.198426+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
382 39693 swimming_water_temperature 2019-06-10T08:15:53.628150+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
385 39815 swimming_water_temperature 2019-06-10T10:00:34.828200+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
389 41791 swimming_water_temperature 2019-06-10T10:01:18.592635+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
391 39322 swimming_water_temperature 2019-06-10T10:01:21.612696+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
393 40098 swimming_water_temperature 2019-06-10T10:07:48.757221+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
395 41601 swimming_water_temperature 2019-06-10T10:13:27.071351+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
397 40559 swimming_water_temperature 2019-06-10T10:18:09.001672+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
400 40950 swimming_water_temperature 2019-06-10T10:29:40.224791+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
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  
403 40150 swimming_water_temperature 2019-06-10T10:37:08.378059+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
405 41960 swimming_water_temperature 2019-06-10T10:57:42.684782+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
408 39322 swimming_water_temperature 2019-06-10T13:40:51.100444+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
410 39322 swimming_water_temperature 2019-06-10T13:45:12.831410+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
413 39815 swimming_water_temperature 2019-06-10T13:46:34.972562+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  
416 39693 swimming_water_temperature 2019-06-10T14:11:28.424217+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
418 40142 swimming_water_temperature 2019-06-10T14:52:12.889585+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
421 40157 swimming_water_temperature 2019-06-10T14:54:25.564905+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
423 40258 swimming_water_temperature 2019-06-10T15:03:59.731489+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
424 39322 swimming_water_temperature 2019-06-10T17:50:52.926026+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
426 39693 swimming_water_temperature 2019-06-10T18:30:40.103809+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
429 41031 swimming_water_temperature 2019-06-11T07:35:39.937460+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
431 41326 swimming_water_temperature 2019-06-11T07:35:54.816735+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
433 41907 swimming_water_temperature 2019-06-11T07:36:03.716690+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
435 40921 swimming_water_temperature 2019-06-11T07:36:19.863504+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
437 40798 swimming_water_temperature 2019-06-11T07:36:30.314633+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
438 40798 swimming_water_temperature 2019-06-11T07:36:37.529518+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
440 40677 swimming_water_temperature 2019-06-11T07:36:52.756253+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
442 40020 swimming_water_temperature 2019-06-11T07:36:59.454932+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
444 39910 swimming_water_temperature 2019-06-11T07:37:06.926794+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
446 40993 swimming_water_temperature 2019-06-11T07:37:44.991784+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
448 40356 swimming_water_temperature 2019-06-11T07:38:15.879350+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
450 40386 swimming_water_temperature 2019-06-11T07:38:45.000109+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
451 40386 swimming_water_temperature 2019-06-11T07:38:49.711036+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
453 39693 swimming_water_temperature 2019-06-11T09:16:02.376158+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
454 39693 swimming_water_temperature 2019-06-11T09:16:09.387097+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
460 39322 swimming_water_temperature 2019-06-11T09:50:53.764841+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
462 39815 swimming_water_temperature 2019-06-11T09:52:59.453634+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
465 40950 swimming_water_temperature 2019-06-11T10:03:10.490044+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
467 41791 swimming_water_temperature 2019-06-11T10:05:11.341226+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
469 40802 swimming_water_temperature 2019-06-11T10:05:21.394543+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
471 40142 swimming_water_temperature 2019-06-11T10:06:22.076433+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
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  
478 40157 swimming_water_temperature 2019-06-11T10:10:55.622586+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
480 40559 swimming_water_temperature 2019-06-11T10:14:49.301140+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
483 39693 swimming_water_temperature 2019-06-11T10:21:09.542309+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
486 41960 swimming_water_temperature 2019-06-11T10:26:20.184265+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
488 40150 swimming_water_temperature 2019-06-11T10:41:02.674258+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
489 41601 swimming_water_temperature 2019-06-11T10:53:12.365926+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
549 41791 swimming_water_temperature 2019-06-11T12:44:05.760815+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
553 39693 swimming_water_temperature 2019-06-11T13:43:38.386127+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
554 39322 swimming_water_temperature 2019-06-11T13:45:44.348861+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
556 39815 swimming_water_temperature 2019-06-11T13:54:53.119475+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
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  
561 40258 swimming_water_temperature 2019-06-11T16:53:54.604428+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
565 39322 swimming_water_temperature 2019-06-11T17:52:45.689952+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  
569 39815 swimming_water_temperature 2019-06-11T18:08:16.960792+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
572 39322 swimming_water_temperature 2019-06-12T10:04:11.081301+0300     17-19°C   17-19°C 0 17-19°C 17-19 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
);