observation

1,261 rows where name_sv = "17-19°C"

✎ 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
105 40098 swimming_water_temperature 2019-06-05T10:51:42.918514+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
130 39693 swimming_water_temperature 2019-06-06T10:03:55.102230+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
137 40559 swimming_water_temperature 2019-06-06T10:27:19.376612+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
145 40150 swimming_water_temperature 2019-06-06T10:43:25.735993+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
147 40950 swimming_water_temperature 2019-06-06T10:43:25.994094+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
148 40950 swimming_water_temperature 2019-06-06T10:43:26.123955+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
152 41601 swimming_water_temperature 2019-06-06T11:07:55.044976+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
153 40258 swimming_water_temperature 2019-06-06T11:12:03.138542+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
160 40098 swimming_water_temperature 2019-06-06T11:16:25.883143+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
162 39815 swimming_water_temperature 2019-06-06T11:16:26.153952+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
169 40993 swimming_water_temperature 2019-06-06T12:51:31.517274+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
173 39267 swimming_water_temperature 2019-06-06T12:51:32.063938+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
180 39267 swimming_water_temperature 2019-06-06T14:10:39.608279+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
182 40950 swimming_water_temperature 2019-06-06T14:10:39.914760+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
184 39815 swimming_water_temperature 2019-06-06T15:18:31.932506+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
206 40950 swimming_water_temperature 2019-06-07T10:09:54.471137+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
211 41791 swimming_water_temperature 2019-06-07T10:24:59.111664+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
212 41791 swimming_water_temperature 2019-06-07T10:25:44.452775+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
213 41791 swimming_water_temperature 2019-06-07T10:26:07.112503+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
214 40150 swimming_water_temperature 2019-06-07T10:35:30.790678+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
218 40142 swimming_water_temperature 2019-06-07T11:22:11.956190+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
232 41791 swimming_water_temperature 2019-06-07T13:42:22.858744+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
235 41791 swimming_water_temperature 2019-06-07T13:45:23.030764+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
578 39693 swimming_water_temperature 2019-06-12T10:11:33.149222+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
581 40157 swimming_water_temperature 2019-06-12T10:12:21.834732+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
583 40559 swimming_water_temperature 2019-06-12T10:20:27.188308+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
587 41791 swimming_water_temperature 2019-06-12T10:33:08.928678+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
598 39815 swimming_water_temperature 2019-06-12T11:37:58.845010+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
609 39693 swimming_water_temperature 2019-06-12T14:12:17.628770+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
617 39693 swimming_water_temperature 2019-06-12T17:47:21.157315+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
640 53461 swimming_water_temperature 2019-06-13T09:33:38.441460+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
642 39823 swimming_water_temperature 2019-06-13T09:47:39.492915+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
647 40157 swimming_water_temperature 2019-06-13T10:03:22.370237+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
651 39322 swimming_water_temperature 2019-06-13T10:08:10.286362+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
654 39267 swimming_water_temperature 2019-06-13T10:08:49.115932+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
662 41960 swimming_water_temperature 2019-06-13T10:30:03.327329+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
664 39815 swimming_water_temperature 2019-06-13T10:49:54.633216+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
675 39412 swimming_water_temperature 2019-06-13T12:30:07.178308+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
677 39368 swimming_water_temperature 2019-06-13T12:55:20.315406+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
685 39267 swimming_water_temperature 2019-06-13T15:03:53.067568+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
694 39815 swimming_water_temperature 2019-06-13T18:17:06.571420+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
695 39322 swimming_water_temperature 2019-06-13T18:42:33.276787+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
697 39823 swimming_water_temperature 2019-06-14T07:39:06.304126+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
699 53461 swimming_water_temperature 2019-06-14T07:52:56.389759+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
709 39322 swimming_water_temperature 2019-06-14T09:44:09.977393+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
711 39412 swimming_water_temperature 2019-06-14T09:53:14.083768+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
713 39815 swimming_water_temperature 2019-06-14T09:53:37.381412+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
716 39322 swimming_water_temperature 2019-06-14T10:00:50.300444+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
718 41960 swimming_water_temperature 2019-06-14T10:02:51.919296+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
720 39267 swimming_water_temperature 2019-06-14T10:04:47.457711+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
743 39322 swimming_water_temperature 2019-06-14T14:18:25.495876+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
745 39267 swimming_water_temperature 2019-06-14T17:56:22.115728+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
753 41960 swimming_water_temperature 2019-06-15T10:01:41.210720+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
757 39322 swimming_water_temperature 2019-06-15T10:02:51.692215+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
766 39267 swimming_water_temperature 2019-06-15T10:23:55.291543+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
782 39815 swimming_water_temperature 2019-06-15T13:49:51.228836+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
785 39322 swimming_water_temperature 2019-06-15T13:56:34.538850+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
796 39322 swimming_water_temperature 2019-06-15T18:21:00.124038+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
809 40921 swimming_water_temperature 2019-06-16T08:25:13.420760+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
812 41326 swimming_water_temperature 2019-06-16T08:25:43.676713+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
823 39815 swimming_water_temperature 2019-06-16T09:48:11.545095+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
834 41960 swimming_water_temperature 2019-06-16T10:11:34.437293+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
845 40802 swimming_water_temperature 2019-06-16T10:23:38.991788+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
848 40157 swimming_water_temperature 2019-06-16T10:24:58.361754+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
854 41601 swimming_water_temperature 2019-06-16T11:26:43.235105+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
874 39568 swimming_water_temperature 2019-06-16T14:18:36.257155+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
881 39568 swimming_water_temperature 2019-06-16T18:15:18.510130+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
883 39693 swimming_water_temperature 2019-06-16T18:45:22.488151+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
884 39322 swimming_water_temperature 2019-06-16T19:01:21.720326+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
900 39322 swimming_water_temperature 2019-06-17T09:59:14.994200+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
906 39693 swimming_water_temperature 2019-06-17T10:07:24.518192+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
911 40150 swimming_water_temperature 2019-06-17T10:31:47.816713+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
922 41791 swimming_water_temperature 2019-06-17T12:35:11.385520+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
935 39322 swimming_water_temperature 2019-06-17T14:01:39.827519+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
);