observation

4,968 rows where primary = 0 sorted by id descending

✎ 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
13723 39815 swimming_water_temperature 2020-08-13T14:00:51.236478+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13717 39583 swimming_water_temperature 2020-08-13T12:05:18.215525+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13714 39815 swimming_water_temperature 2020-08-13T10:36:22.421956+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13712 39322 swimming_water_temperature 2020-08-13T10:02:57.398810+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13693 40157 swimming_water_temperature 2020-08-13T08:46:29.418678+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13692 40802 swimming_water_temperature 2020-08-13T08:46:12.362334+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13691 40150 swimming_water_temperature 2020-08-13T08:45:59.248379+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13690 40950 swimming_water_temperature 2020-08-13T08:45:48.437164+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13689 40150 swimming_water_temperature 2020-08-13T08:45:33.647611+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13687 40258 swimming_water_temperature 2020-08-13T08:45:01.247218+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13685 39568 swimming_water_temperature 2020-08-13T08:25:17.526176+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13682 39815 swimming_water_temperature 2020-08-13T08:19:45.536904+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13681 39815 swimming_water_temperature 2020-08-12T18:55:01.191676+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13679 39322 swimming_water_temperature 2020-08-12T18:41:06.969147+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13676 39583 swimming_water_temperature 2020-08-12T17:47:11.639366+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13673 39815 swimming_water_temperature 2020-08-12T14:10:12.180913+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13670 39815 swimming_water_temperature 2020-08-12T14:09:06.160694+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13666 39583 swimming_water_temperature 2020-08-12T14:07:51.962436+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13663 39693 swimming_water_temperature 2020-08-12T14:06:20.816129+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13661 39693 swimming_water_temperature 2020-08-12T14:02:47.519936+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13659 39322 swimming_water_temperature 2020-08-12T13:56:54.987149+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13640 39583 swimming_water_temperature 2020-08-12T10:12:53.678697+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13636 39693 swimming_water_temperature 2020-08-12T10:11:40.978726+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13634 39322 swimming_water_temperature 2020-08-12T09:56:50.857383+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13632 39693 swimming_water_temperature 2020-08-11T18:11:24.202010+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13630 39693 swimming_water_temperature 2020-08-11T17:53:29.036539+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13627 39583 swimming_water_temperature 2020-08-11T15:05:28.234604+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13625 39322 swimming_water_temperature 2020-08-11T14:16:12.084130+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13623 39693 swimming_water_temperature 2020-08-11T14:01:30.649371+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13621 39527 swimming_water_temperature 2020-08-11T13:44:34.401530+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13619 39322 swimming_water_temperature 2020-08-11T11:56:45.959411+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13617 52959 swimming_water_temperature 2020-08-11T11:41:10.043713+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13614 39693 swimming_water_temperature 2020-08-11T10:07:24.910075+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13593 39815 swimming_water_temperature 2020-08-11T08:39:44.619852+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13590 39693 swimming_water_temperature 2020-08-11T08:33:41.770519+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13587 39693 swimming_water_temperature 2020-08-10T18:00:25.435987+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13586 39815 swimming_water_temperature 2020-08-10T17:55:33.488830+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13584 39322 swimming_water_temperature 2020-08-10T17:53:09.403632+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13582 39583 swimming_water_temperature 2020-08-10T17:43:58.418065+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13579 39693 swimming_water_temperature 2020-08-10T15:15:52.633703+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13578 39412 swimming_water_temperature 2020-08-10T14:25:39.741558+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13577 39368 swimming_water_temperature 2020-08-10T14:25:22.663454+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13576 52958 swimming_water_temperature 2020-08-10T14:24:02.628875+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13575 50549 swimming_water_temperature 2020-08-10T14:23:27.481034+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13574 52960 swimming_water_temperature 2020-08-10T14:23:06.552866+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13572 39815 swimming_water_temperature 2020-08-10T14:08:58.999911+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13571 39322 swimming_water_temperature 2020-08-10T14:05:09.050466+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13568 39583 swimming_water_temperature 2020-08-10T13:57:19.332274+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13566 39815 swimming_water_temperature 2020-08-10T12:18:37.890647+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13564 39527 swimming_water_temperature 2020-08-10T11:50:03.034109+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13561 39322 swimming_water_temperature 2020-08-10T11:14:46.745764+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13548 39693 swimming_water_temperature 2020-08-10T10:49:02.383881+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13539 39568 swimming_water_temperature 2020-08-10T10:40:29.021569+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13537 52959 swimming_water_temperature 2020-08-10T10:16:56.202218+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13534 39583 swimming_water_temperature 2020-08-10T10:07:41.921718+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13532 39322 swimming_water_temperature 2020-08-09T17:56:46.753506+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13529 39815 swimming_water_temperature 2020-08-09T17:51:53.321131+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
13527 39583 swimming_water_temperature 2020-08-09T17:41:26.595094+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13524 39815 swimming_water_temperature 2020-08-09T14:03:50.810138+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13522 39322 swimming_water_temperature 2020-08-09T13:57:03.168042+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13520 39583 swimming_water_temperature 2020-08-09T13:56:56.562432+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13518 40802 swimming_water_temperature 2020-08-09T13:45:51.067802+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13516 39527 swimming_water_temperature 2020-08-09T12:31:26.082193+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13514 40993 swimming_water_temperature 2020-08-09T11:55:05.710341+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13512 40258 swimming_water_temperature 2020-08-09T11:37:28.691880+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13510 40150 swimming_water_temperature 2020-08-09T11:10:20.973354+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13508 39815 swimming_water_temperature 2020-08-09T11:06:56.161131+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13506 40142 swimming_water_temperature 2020-08-09T10:56:53.131921+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13504 40098 swimming_water_temperature 2020-08-09T10:51:50.562189+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13502 39693 swimming_water_temperature 2020-08-09T10:50:50.934558+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13500 40950 swimming_water_temperature 2020-08-09T10:44:13.073823+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13499 39583 swimming_water_temperature 2020-08-09T10:33:13.420224+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13496 39322 swimming_water_temperature 2020-08-09T10:11:30.826163+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13494 52959 swimming_water_temperature 2020-08-09T10:07:49.977106+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13492 40386 swimming_water_temperature 2020-08-09T10:07:27.309910+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13490 41791 swimming_water_temperature 2020-08-09T10:06:33.402783+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13488 39568 swimming_water_temperature 2020-08-09T09:58:17.948224+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13486 41601 swimming_water_temperature 2020-08-09T09:56:07.449501+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13484 40559 swimming_water_temperature 2020-08-09T09:55:05.986446+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13481 40157 swimming_water_temperature 2020-08-09T09:42:42.516222+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13478 39815 swimming_water_temperature 2020-08-08T18:05:49.749595+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13476 39693 swimming_water_temperature 2020-08-08T17:49:52.468272+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13474 39583 swimming_water_temperature 2020-08-08T17:47:06.132575+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13473 39815 swimming_water_temperature 2020-08-08T14:21:40.603344+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13469 39583 swimming_water_temperature 2020-08-08T14:05:39.538990+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13467 39322 swimming_water_temperature 2020-08-08T14:05:25.658428+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13465 39693 swimming_water_temperature 2020-08-08T13:48:48.980868+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13464 40142 swimming_water_temperature 2020-08-08T12:50:07.298808+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13462 40802 swimming_water_temperature 2020-08-08T11:36:03.449967+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13460 39322 swimming_water_temperature 2020-08-08T10:57:49.243369+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13458 40950 swimming_water_temperature 2020-08-08T10:31:46.048601+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13457 40098 swimming_water_temperature 2020-08-08T10:26:01.500890+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13454 41791 swimming_water_temperature 2020-08-08T10:18:18.366469+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13451 40142 swimming_water_temperature 2020-08-08T10:13:47.588691+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
13449 39583 swimming_water_temperature 2020-08-08T10:10:40.247901+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13448 40559 swimming_water_temperature 2020-08-08T10:08:27.505133+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13445 52959 swimming_water_temperature 2020-08-08T10:07:13.024815+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13443 40386 swimming_water_temperature 2020-08-08T10:01:30.356401+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13441 41601 swimming_water_temperature 2020-08-08T10:01:02.259139+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
13440 41960 swimming_water_temperature 2020-08-08T10:00:06.689992+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
);