observation

51,120 rows sorted by value_sv descending

✎ View and edit SQL

This data as json, CSV (advanced)

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
21809 40157 live_swimming_water_temperature 2020-10-06T23:20:03.599329+0300   13.8   13.8            
22341 40386 live_swimming_water_temperature 2020-10-08T17:10:03.717931+0300   13.8   13.8            
22395 40157 live_swimming_water_temperature 2020-10-08T21:20:03.383772+0300   13.8   13.8            
22401 40157 live_swimming_water_temperature 2020-10-08T21:50:03.389763+0300   13.8   13.8            
22427 40157 live_swimming_water_temperature 2020-10-08T23:50:03.428851+0300   13.8   13.8            
22616 40157 live_swimming_water_temperature 2020-10-09T14:50:03.484037+0300   13.8   13.8            
21477 40157 live_swimming_water_temperature 2020-10-05T21:20:03.480654+0300   13.7   13.7            
21564 41977 live_swimming_water_temperature 2020-10-06T04:10:03.221748+0300   13.7   13.7            
21665 40157 live_swimming_water_temperature 2020-10-06T11:50:03.878552+0300   13.7   13.7            
21672 40157 live_swimming_water_temperature 2020-10-06T12:20:03.827213+0300   13.7   13.7            
22355 40386 live_swimming_water_temperature 2020-10-08T18:10:03.427953+0300   13.7   13.7            
22362 40386 live_swimming_water_temperature 2020-10-08T18:40:03.188894+0300   13.7   13.7            
22434 40157 live_swimming_water_temperature 2020-10-09T00:20:03.478307+0300   13.7   13.7            
22451 40157 live_swimming_water_temperature 2020-10-09T01:50:03.437685+0300   13.7   13.7            
22623 40157 live_swimming_water_temperature 2020-10-09T15:20:03.775233+0300   13.7   13.7            
22629 40157 live_swimming_water_temperature 2020-10-09T15:50:03.638235+0300   13.7   13.7            
22636 40157 live_swimming_water_temperature 2020-10-09T16:20:03.619743+0300   13.7   13.7            
21390 40386 live_swimming_water_temperature 2020-10-05T14:40:03.494961+0300   13.6   13.6            
21404 41977 live_swimming_water_temperature 2020-10-05T15:40:03.518118+0300   13.6   13.6            
21409 40386 live_swimming_water_temperature 2020-10-05T16:10:03.637153+0300   13.6   13.6            
21470 40157 live_swimming_water_temperature 2020-10-05T20:50:03.617962+0300   13.6   13.6            
21474 40386 live_swimming_water_temperature 2020-10-05T21:10:03.619987+0300   13.6   13.6            
21490 40157 live_swimming_water_temperature 2020-10-05T22:20:03.390389+0300   13.6   13.6            
21496 40157 live_swimming_water_temperature 2020-10-05T22:50:03.806007+0300   13.6   13.6            
21514 40157 live_swimming_water_temperature 2020-10-06T00:20:03.076843+0300   13.6   13.6            
21527 40157 live_swimming_water_temperature 2020-10-06T01:20:03.656806+0300   13.6   13.6            
21534 40157 live_swimming_water_temperature 2020-10-06T01:50:03.564149+0300   13.6   13.6            
21540 40157 live_swimming_water_temperature 2020-10-06T02:20:03.298961+0300   13.6   13.6            
21552 40157 live_swimming_water_temperature 2020-10-06T03:20:03.472222+0300   13.6   13.6            
21556 40386 live_swimming_water_temperature 2020-10-06T03:40:03.141686+0300   13.6   13.6            
21559 40157 live_swimming_water_temperature 2020-10-06T03:50:03.258824+0300   13.6   13.6            
21566 40157 live_swimming_water_temperature 2020-10-06T04:20:03.167036+0300   13.6   13.6            
21586 40157 live_swimming_water_temperature 2020-10-06T05:50:03.419771+0300   13.6   13.6            
21592 40157 live_swimming_water_temperature 2020-10-06T06:20:03.626121+0300   13.6   13.6            
21599 40157 live_swimming_water_temperature 2020-10-06T06:50:03.431766+0300   13.6   13.6            
21620 40157 live_swimming_water_temperature 2020-10-06T08:20:03.457183+0300   13.6   13.6            
21627 40157 live_swimming_water_temperature 2020-10-06T08:50:03.699118+0300   13.6   13.6            
21634 40157 live_swimming_water_temperature 2020-10-06T09:20:02.953687+0300   13.6   13.6            
21641 40157 live_swimming_water_temperature 2020-10-06T09:50:03.455158+0300   13.6   13.6            
21646 40157 live_swimming_water_temperature 2020-10-06T10:20:03.200654+0300   13.6   13.6            
21658 40157 live_swimming_water_temperature 2020-10-06T11:20:03.337638+0300   13.6   13.6            
21669 40386 live_swimming_water_temperature 2020-10-06T12:10:03.580018+0300   13.6   13.6            
21675 40386 live_swimming_water_temperature 2020-10-06T12:40:03.444451+0300   13.6   13.6            
21681 40386 live_swimming_water_temperature 2020-10-06T13:10:03.729869+0300   13.6   13.6            
21688 40386 live_swimming_water_temperature 2020-10-06T13:40:03.528768+0300   13.6   13.6            
21706 41977 live_swimming_water_temperature 2020-10-06T15:10:03.289380+0300   13.6   13.6            
21716 40386 live_swimming_water_temperature 2020-10-06T16:10:03.941054+0300   13.6   13.6            
21717 41977 live_swimming_water_temperature 2020-10-06T16:10:04.143162+0300   13.6   13.6            
21794 40386 live_swimming_water_temperature 2020-10-06T22:10:04.237743+0300   13.6   13.6            
21860 40157 live_swimming_water_temperature 2020-10-07T03:20:03.673394+0300   13.6   13.6            
21881 40157 live_swimming_water_temperature 2020-10-07T04:50:03.079809+0300   13.6   13.6            
21888 40157 live_swimming_water_temperature 2020-10-07T05:20:03.645530+0300   13.6   13.6            
22280 40157 live_swimming_water_temperature 2020-10-08T12:20:03.217295+0300   13.6   13.6            
22311 41977 live_swimming_water_temperature 2020-10-08T14:50:03.727122+0300   13.6   13.6            
22315 40386 live_swimming_water_temperature 2020-10-08T15:10:03.507967+0300   13.6   13.6            
22317 41977 live_swimming_water_temperature 2020-10-08T15:20:03.378807+0300   13.6   13.6            
22322 40386 live_swimming_water_temperature 2020-10-08T15:40:03.195868+0300   13.6   13.6            
22381 40386 live_swimming_water_temperature 2020-10-08T20:10:03.544090+0300   13.6   13.6            
22387 40386 live_swimming_water_temperature 2020-10-08T20:40:03.302876+0300   13.6   13.6            
22464 40157 live_swimming_water_temperature 2020-10-09T02:50:03.350108+0300   13.6   13.6            
22470 40157 live_swimming_water_temperature 2020-10-09T03:20:03.580184+0300   13.6   13.6            
22477 40157 live_swimming_water_temperature 2020-10-09T03:50:03.552177+0300   13.6   13.6            
22569 40157 live_swimming_water_temperature 2020-10-09T11:20:03.661956+0300   13.6   13.6            
22583 40157 live_swimming_water_temperature 2020-10-09T12:20:03.631588+0300   13.6   13.6            
22643 40157 live_swimming_water_temperature 2020-10-09T16:50:03.541785+0300   13.6   13.6            
22647 40157 live_swimming_water_temperature 2020-10-09T17:20:03.764015+0300   13.6   13.6            
22659 40157 live_swimming_water_temperature 2020-10-09T18:20:03.422013+0300   13.6   13.6            
21353 40386 live_swimming_water_temperature 2020-10-05T11:40:03.382057+0300   13.5   13.5            
21399 41977 live_swimming_water_temperature 2020-10-05T15:10:03.441036+0300   13.5   13.5            
21481 40386 live_swimming_water_temperature 2020-10-05T21:40:02.985066+0300   13.5   13.5            
21488 40386 live_swimming_water_temperature 2020-10-05T22:10:04.052937+0300   13.5   13.5            
21511 40386 live_swimming_water_temperature 2020-10-06T00:10:03.733917+0300   13.5   13.5            
21570 40386 live_swimming_water_temperature 2020-10-06T04:40:03.591164+0300   13.5   13.5            
21583 40386 live_swimming_water_temperature 2020-10-06T05:40:03.457138+0300   13.5   13.5            
21631 40386 live_swimming_water_temperature 2020-10-06T09:10:03.927241+0300   13.5   13.5            
21662 40386 live_swimming_water_temperature 2020-10-06T11:40:03.608076+0300   13.5   13.5            
21773 40386 live_swimming_water_temperature 2020-10-06T20:40:03.798811+0300   13.5   13.5            
21807 40386 live_swimming_water_temperature 2020-10-06T23:10:03.818265+0300   13.5   13.5            
21895 40157 live_swimming_water_temperature 2020-10-07T05:50:03.498912+0300   13.5   13.5            
21985 40157 live_swimming_water_temperature 2020-10-07T12:50:03.340437+0300   13.5   13.5            
21993 40386 live_swimming_water_temperature 2020-10-07T13:40:03.279053+0300   13.5   13.5            
22000 40386 live_swimming_water_temperature 2020-10-07T14:10:03.405167+0300   13.5   13.5            
22350 41977 live_swimming_water_temperature 2020-10-08T17:50:03.171558+0300   13.5   13.5            
22374 40386 live_swimming_water_temperature 2020-10-08T19:40:03.602420+0300   13.5   13.5            
22393 40386 live_swimming_water_temperature 2020-10-08T21:10:03.051734+0300   13.5   13.5            
22398 40386 live_swimming_water_temperature 2020-10-08T21:40:03.182119+0300   13.5   13.5            
22405 40386 live_swimming_water_temperature 2020-10-08T22:10:03.526314+0300   13.5   13.5            
22528 40157 live_swimming_water_temperature 2020-10-09T07:50:03.584411+0300   13.5   13.5            
22535 40157 live_swimming_water_temperature 2020-10-09T08:20:03.387024+0300   13.5   13.5            
22540 40157 live_swimming_water_temperature 2020-10-09T08:50:03.733634+0300   13.5   13.5            
22551 40157 live_swimming_water_temperature 2020-10-09T09:50:03.579910+0300   13.5   13.5            
22564 40157 live_swimming_water_temperature 2020-10-09T10:50:03.640144+0300   13.5   13.5            
22692 40157 live_swimming_water_temperature 2020-10-09T20:50:03.389002+0300   13.5   13.5            
22909 40386 live_swimming_water_temperature 2020-10-10T14:10:03.907655+0300   13.5   13.5            
22925 40386 live_swimming_water_temperature 2020-10-10T15:40:03.558096+0300   13.5   13.5            
22931 40386 live_swimming_water_temperature 2020-10-10T16:10:04.031067+0300   13.5   13.5            
20888 41960 live_swimming_water_temperature 2020-10-01T16:50:04.065354+0300   13.4   13.4            
21356 40157 live_swimming_water_temperature 2020-10-05T11:50:03.233370+0300   13.4   13.4            
21392 41977 live_swimming_water_temperature 2020-10-05T14:40:03.828397+0300   13.4   13.4            
21494 40386 live_swimming_water_temperature 2020-10-05T22:40:03.375460+0300   13.4   13.4            

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