observation

51,120 rows sorted by value_sv descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name_fi, name_sv, name_en, value, quality

primary ✖

  • 1 7,945
  • 0 4,968
id unit property time expiration_time value_fi name_fi value_sv ▲ name_sv primary name_en value quality value_en
13675 39815 notice 2020-08-12T14:10:19.166359+0300   Valvontaa rannalla klo 8-20 joka päivä 16.8 saakka, tervetuloa.   Valvontaa rannalla klo 8-20 joka päivä 16.8 saakka, tervetuloa.            
13684 39815 notice 2020-08-13T08:19:52.270799+0300   Valvontaa rannalla klo 8-20 joka päivä 16.8 saakka, tervetuloa.   Valvontaa rannalla klo 8-20 joka päivä 16.8 saakka, tervetuloa.            
13725 39815 notice 2020-08-13T14:00:59.720395+0300   Valvontaa rannalla klo 8-20 joka päivä 16.8 saakka, tervetuloa.   Valvontaa rannalla klo 8-20 joka päivä 16.8 saakka, tervetuloa.            
13754 39815 notice 2020-08-14T09:52:47.831475+0300   Valvontaa rannalla klo 8-20 joka päivä 16.8 saakka, tervetuloa.   Valvontaa rannalla klo 8-20 joka päivä 16.8 saakka, tervetuloa.            
13766 39815 notice 2020-08-14T14:20:43.202856+0300   Valvontaa rannalla klo 8-20 joka päivä 16.8 saakka, tervetuloa.   Valvontaa rannalla klo 8-20 joka päivä 16.8 saakka, tervetuloa.            
13802 39815 notice 2020-08-15T11:37:29.565309+0300   Valvontaa rannalla klo 8-20 joka päivä 16.8 saakka, tervetuloa.   Valvontaa rannalla klo 8-20 joka päivä 16.8 saakka, tervetuloa.            
13848 39815 notice 2020-08-16T11:15:31.993757+0300   Valvontaa rannalla klo 8-20 joka päivä 16.8 saakka, tervetuloa.   Valvontaa rannalla klo 8-20 joka päivä 16.8 saakka, tervetuloa.            
13665 39693 notice 2020-08-12T14:06:56.033446+0300   Valvontaa rannalla klo 8-20 joka päivä 16.8 saakka, tervetuloa.   Valvontaa rannalla klo 8-20 joka päivä 16.8 saakka, tervetuloa.            
13812 39693 notice 2020-08-15T14:12:58.945966+0300   Valvontaa rannalla klo 8-20 joka päivä 16.8 saakka, tervetuloa.   Valvontaa rannalla klo 8-20 joka päivä 16.8 saakka, tervetuloa.            
13821 39693 notice 2020-08-15T18:18:49.242050+0300   Valvontaa rannalla klo 8-20 joka päivä 16.8 saakka, tervetuloa.   Valvontaa rannalla klo 8-20 joka päivä 16.8 saakka, tervetuloa.            
13863 39693 notice 2020-08-16T18:01:58.871895+0300   Valvontaa rannalla klo 8-20 joka päivä 16.8 saakka, tervetuloa.   Valvontaa rannalla klo 8-20 joka päivä 16.8 saakka, tervetuloa.            
13721 39583 notice 2020-08-13T12:05:49.091843+0300   Valvontaa rannalla klo 10-18 joka päivä 16.8 saakka, tervetuloa.   Valvontaa rannalla klo 10-18 joka päivä 16.8 saakka, tervetuloa.            
13722 39583 notice 2020-08-13T12:05:50.600702+0300   Valvontaa rannalla klo 10-18 joka päivä 16.8 saakka, tervetuloa.   Valvontaa rannalla klo 10-18 joka päivä 16.8 saakka, tervetuloa.            
13757 39583 notice 2020-08-14T10:07:38.375398+0300   Valvontaa rannalla klo 10-18 joka päivä 16.8 saakka, tervetuloa.   Valvontaa rannalla klo 10-18 joka päivä 16.8 saakka, tervetuloa.            
13764 39583 notice 2020-08-14T13:46:19.150553+0300   Valvontaa rannalla klo 10-18 joka päivä 16.8 saakka, tervetuloa.   Valvontaa rannalla klo 10-18 joka päivä 16.8 saakka, tervetuloa.            
13771 39583 notice 2020-08-14T17:53:12.870876+0300   Valvontaa rannalla klo 10-18 joka päivä 16.8 saakka, tervetuloa.   Valvontaa rannalla klo 10-18 joka päivä 16.8 saakka, tervetuloa.            
13818 39583 notice 2020-08-15T17:46:17.226513+0300   Valvontaa rannalla klo 10-18 joka päivä 16.8 saakka, tervetuloa.   Valvontaa rannalla klo 10-18 joka päivä 16.8 saakka, tervetuloa.            
23999 41960 live_swimming_water_temperature 2020-10-14T04:40:03.365894+0300   9.9   9.9            
24003 41960 live_swimming_water_temperature 2020-10-14T05:00:04.230929+0300   9.9   9.9            
24005 41960 live_swimming_water_temperature 2020-10-14T05:10:03.514350+0300   9.9   9.9            
24012 41960 live_swimming_water_temperature 2020-10-14T05:40:03.887747+0300   9.9   9.9            
24018 41960 live_swimming_water_temperature 2020-10-14T06:10:03.925619+0300   9.9   9.9            
24029 41960 live_swimming_water_temperature 2020-10-14T07:00:04.777548+0300   9.9   9.9            
24119 41960 live_swimming_water_temperature 2020-10-14T13:40:03.673395+0300   9.9   9.9            
24024 41960 live_swimming_water_temperature 2020-10-14T06:40:03.711242+0300   9.8   9.8            
24026 41960 live_swimming_water_temperature 2020-10-14T06:50:03.720278+0300   9.8   9.8            
24031 41960 live_swimming_water_temperature 2020-10-14T07:10:03.881832+0300   9.8   9.8            
24033 41960 live_swimming_water_temperature 2020-10-14T07:20:03.565925+0300   9.8   9.8            
24038 41960 live_swimming_water_temperature 2020-10-14T07:40:04.007157+0300   9.8   9.8            
24045 41960 live_swimming_water_temperature 2020-10-14T08:10:03.731190+0300   9.8   9.8            
24050 41960 live_swimming_water_temperature 2020-10-14T08:30:03.782348+0300   9.8   9.8            
24052 41960 live_swimming_water_temperature 2020-10-14T08:40:03.378055+0300   9.8   9.8            
24054 41960 live_swimming_water_temperature 2020-10-14T08:50:03.642655+0300   9.8   9.8            
24057 41960 live_swimming_water_temperature 2020-10-14T09:10:03.782533+0300   9.8   9.8            
24059 41960 live_swimming_water_temperature 2020-10-14T09:20:03.966179+0300   9.8   9.8            
24074 41960 live_swimming_water_temperature 2020-10-14T10:30:03.741951+0300   9.8   9.8            
24078 41960 live_swimming_water_temperature 2020-10-14T10:50:03.832715+0300   9.8   9.8            
24090 41960 live_swimming_water_temperature 2020-10-14T11:30:03.484922+0300   9.8   9.8            
24105 41960 live_swimming_water_temperature 2020-10-14T12:30:03.634871+0300   9.8   9.8            
24108 41960 live_swimming_water_temperature 2020-10-14T12:50:03.780701+0300   9.8   9.8            
24113 41960 live_swimming_water_temperature 2020-10-14T13:10:03.459305+0300   9.8   9.8            
24115 41960 live_swimming_water_temperature 2020-10-14T13:20:03.839963+0300   9.8   9.8            
24639 40157 live_swimming_water_temperature 2020-10-16T07:30:03.849555+0300   9.4   9.4            
24645 40157 live_swimming_water_temperature 2020-10-16T08:00:04.768256+0300   9.3   9.3            
24405 41960 live_swimming_water_temperature 2020-10-15T12:20:03.940087+0300   9.2   9.2            
24419 41960 live_swimming_water_temperature 2020-10-15T13:20:03.279751+0300   9.2   9.2            
24430 41960 live_swimming_water_temperature 2020-10-15T14:00:04.678492+0300   9.2   9.2            
24662 40157 live_swimming_water_temperature 2020-10-16T09:30:03.620146+0300   9.2   9.2            
24402 41960 live_swimming_water_temperature 2020-10-15T12:00:04.316245+0300   9.1   9.1            
24409 41960 live_swimming_water_temperature 2020-10-15T12:30:04.248351+0300   9.1   9.1            
24410 41960 live_swimming_water_temperature 2020-10-15T12:40:03.706931+0300   9.1   9.1            
24412 41960 live_swimming_water_temperature 2020-10-15T12:50:03.323704+0300   9.1   9.1            
24417 41960 live_swimming_water_temperature 2020-10-15T13:10:03.761041+0300   9.1   9.1            
24426 41960 live_swimming_water_temperature 2020-10-15T13:50:03.328058+0300   9.1   9.1            
24640 41960 live_swimming_water_temperature 2020-10-16T07:30:04.014516+0300   8.2   8.2            
24641 41960 live_swimming_water_temperature 2020-10-16T07:40:03.534633+0300   8.2   8.2            
24654 41960 live_swimming_water_temperature 2020-10-16T08:50:03.435467+0300   8.2   8.2            
24664 41960 live_swimming_water_temperature 2020-10-16T09:30:03.916160+0300   8.2   8.2            
24665 41960 live_swimming_water_temperature 2020-10-16T09:40:03.713959+0300   8.2   8.2            
24658 41960 live_swimming_water_temperature 2020-10-16T09:10:03.537578+0300   8.1   8.1            
24671 41960 live_swimming_water_temperature 2020-10-16T10:00:04.898862+0300   8.1   8.1            
21405 40157 live_swimming_water_temperature 2020-10-05T15:50:03.619958+0300   14.6   14.6            
20889 40386 live_swimming_water_temperature 2020-10-01T17:00:03.779116+0300   14.2   14.2            
21519 41977 live_swimming_water_temperature 2020-10-06T00:40:03.252790+0300   14.2   14.2            
20886 40157 live_swimming_water_temperature 2020-10-01T16:50:03.756523+0300   14.1   14.1            
20915 40386 live_swimming_water_temperature 2020-10-01T19:00:03.919891+0300   14.1   14.1            
21427 40386 live_swimming_water_temperature 2020-10-05T17:40:03.492331+0300   14.1   14.1            
21393 40157 live_swimming_water_temperature 2020-10-05T14:50:03.501508+0300   14   14            
21418 40157 live_swimming_water_temperature 2020-10-05T16:50:03.743587+0300   14   14            
21422 40386 live_swimming_water_temperature 2020-10-05T17:10:03.718082+0300   14   14            
21430 40157 live_swimming_water_temperature 2020-10-05T17:50:03.343493+0300   14   14            
21550 41977 live_swimming_water_temperature 2020-10-06T03:10:03.391486+0300   14   14            
20912 40157 live_swimming_water_temperature 2020-10-01T18:50:03.867053+0300   13.9   13.9            
21379 40386 live_swimming_water_temperature 2020-10-05T13:40:03.895516+0300   13.9   13.9            
21400 40157 live_swimming_water_temperature 2020-10-05T15:20:03.201285+0300   13.9   13.9            
21416 40386 live_swimming_water_temperature 2020-10-05T16:40:03.249265+0300   13.9   13.9            
21442 40157 live_swimming_water_temperature 2020-10-05T18:50:03.235204+0300   13.9   13.9            
21449 40157 live_swimming_water_temperature 2020-10-05T19:20:03.071161+0300   13.9   13.9            
21702 40157 live_swimming_water_temperature 2020-10-06T14:50:03.579525+0300   13.9   13.9            
22313 40157 live_swimming_water_temperature 2020-10-08T14:50:04.073802+0300   13.9   13.9            
22325 40157 live_swimming_water_temperature 2020-10-08T15:50:03.945983+0300   13.9   13.9            
22328 40386 live_swimming_water_temperature 2020-10-08T16:10:04.076075+0300   13.9   13.9            
22331 40157 live_swimming_water_temperature 2020-10-08T16:20:03.714274+0300   13.9   13.9            
22338 40157 live_swimming_water_temperature 2020-10-08T16:50:03.482314+0300   13.9   13.9            
22345 40157 live_swimming_water_temperature 2020-10-08T17:20:03.638846+0300   13.9   13.9            
22358 40157 live_swimming_water_temperature 2020-10-08T18:20:03.819150+0300   13.9   13.9            
22377 40157 live_swimming_water_temperature 2020-10-08T19:50:03.599451+0300   13.9   13.9            
21397 40386 live_swimming_water_temperature 2020-10-05T15:10:03.077421+0300   13.8   13.8            
21439 40386 live_swimming_water_temperature 2020-10-05T18:40:02.825557+0300   13.8   13.8            
21446 40386 live_swimming_water_temperature 2020-10-05T19:10:03.496960+0300   13.8   13.8            
21460 40386 live_swimming_water_temperature 2020-10-05T20:10:03.838510+0300   13.8   13.8            
21678 40157 live_swimming_water_temperature 2020-10-06T12:50:03.196789+0300   13.8   13.8            
21691 40157 live_swimming_water_temperature 2020-10-06T13:50:03.465423+0300   13.8   13.8            
21698 40157 live_swimming_water_temperature 2020-10-06T14:20:03.574912+0300   13.8   13.8            
21725 40157 live_swimming_water_temperature 2020-10-06T16:50:03.657184+0300   13.8   13.8            
21752 40157 live_swimming_water_temperature 2020-10-06T18:50:03.898934+0300   13.8   13.8            
21769 40157 live_swimming_water_temperature 2020-10-06T20:20:03.271416+0300   13.8   13.8            
21783 40157 live_swimming_water_temperature 2020-10-06T21:20:03.756873+0300   13.8   13.8            
21797 40157 live_swimming_water_temperature 2020-10-06T22:20:03.516092+0300   13.8   13.8            
21803 40157 live_swimming_water_temperature 2020-10-06T22:50:03.514619+0300   13.8   13.8            

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