observation

746 rows where name_fi = "21-23°C" sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

name_fi ✖

  • 21-23°C · 746 ✖
id ▲ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
13890 42114 swimming_water_temperature 2020-08-17T13:04:42.675993+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13886 39267 swimming_water_temperature 2020-08-17T12:36:24.340709+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13878 39322 swimming_water_temperature 2020-08-17T12:35:21.055110+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13867 39583 swimming_water_temperature 2020-08-16T21:54:47.324929+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13864 39815 swimming_water_temperature 2020-08-16T18:10:46.405573+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13857 39583 swimming_water_temperature 2020-08-16T14:17:34.158021+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13855 39815 swimming_water_temperature 2020-08-16T14:11:53.022410+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
13810 39322 swimming_water_temperature 2020-08-15T14:00:22.620339+0300     21-23°C   21-23°C 0 21-23°C 21-23 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  
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  
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  
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  
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  
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  
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  
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  
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  
13425 39815 swimming_water_temperature 2020-08-07T18:14:34.241070+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12585 41601 swimming_water_temperature 2020-07-28T13:00:30.268391+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12516 39322 swimming_water_temperature 2020-07-27T17:58:20.423133+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12258 39846 swimming_water_temperature 2020-07-24T09:14:40.022636+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12257 39667 swimming_water_temperature 2020-07-24T09:14:40.012106+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12256 39412 swimming_water_temperature 2020-07-24T09:14:40.008918+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12253 39897 swimming_water_temperature 2020-07-24T09:14:39.900281+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12250 39412 swimming_water_temperature 2020-07-24T09:14:39.808927+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12249 39881 swimming_water_temperature 2020-07-24T09:14:39.807298+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12206 39606 swimming_water_temperature 2020-07-23T10:58:00.315202+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12204 39902 swimming_water_temperature 2020-07-23T10:57:29.496407+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12203 39875 swimming_water_temperature 2020-07-23T10:56:46.873427+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12202 39713 swimming_water_temperature 2020-07-23T10:56:29.661011+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12201 39823 swimming_water_temperature 2020-07-23T10:56:07.681304+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12200 53461 swimming_water_temperature 2020-07-23T10:55:44.880271+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12164 41601 swimming_water_temperature 2020-07-23T10:04:13.215553+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12138 39322 swimming_water_temperature 2020-07-22T18:49:41.083565+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12120 39583 swimming_water_temperature 2020-07-22T14:20:15.170234+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12100 41601 swimming_water_temperature 2020-07-22T10:09:56.358361+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12083 40157 swimming_water_temperature 2020-07-22T09:49:00.508888+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12075 40020 swimming_water_temperature 2020-07-22T08:29:33.565425+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12050 39693 swimming_water_temperature 2020-07-21T18:18:12.086989+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12048 39322 swimming_water_temperature 2020-07-21T18:03:19.242010+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12043 39583 swimming_water_temperature 2020-07-21T17:49:54.936496+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12042 39583 swimming_water_temperature 2020-07-21T17:47:13.345222+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12036 39322 swimming_water_temperature 2020-07-21T14:45:24.210012+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12031 39583 swimming_water_temperature 2020-07-21T13:58:26.891540+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
12002 39815 swimming_water_temperature 2020-07-21T11:20:33.596209+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11996 39846 swimming_water_temperature 2020-07-21T11:12:34.301958+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11994 39897 swimming_water_temperature 2020-07-21T11:12:18.243088+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11992 39881 swimming_water_temperature 2020-07-21T11:11:58.160206+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11989 39693 swimming_water_temperature 2020-07-21T10:32:48.751747+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11986 39412 swimming_water_temperature 2020-07-21T10:22:05.678182+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11984 39368 swimming_water_temperature 2020-07-21T10:20:29.344918+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11972 40386 swimming_water_temperature 2020-07-21T10:08:43.988563+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11965 41791 swimming_water_temperature 2020-07-21T09:57:49.329143+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11961 40157 swimming_water_temperature 2020-07-21T09:48:31.368742+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11957 39322 swimming_water_temperature 2020-07-20T18:25:08.056848+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11955 39815 swimming_water_temperature 2020-07-20T17:57:34.825799+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11953 39693 swimming_water_temperature 2020-07-20T17:55:01.096858+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11948 39815 swimming_water_temperature 2020-07-20T14:06:21.972350+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11944 39322 swimming_water_temperature 2020-07-20T13:48:08.903081+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11940 41601 swimming_water_temperature 2020-07-20T13:44:20.689174+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11915 53461 swimming_water_temperature 2020-07-20T12:04:22.704733+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11909 39815 swimming_water_temperature 2020-07-20T11:15:45.650740+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11903 39322 swimming_water_temperature 2020-07-20T10:32:54.044403+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11891 41601 swimming_water_temperature 2020-07-20T10:10:59.351670+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11885 41791 swimming_water_temperature 2020-07-20T10:04:58.087991+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11878 40157 swimming_water_temperature 2020-07-20T09:53:18.619005+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11863 39693 swimming_water_temperature 2020-07-19T18:17:54.184872+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11854 39815 swimming_water_temperature 2020-07-19T14:53:00.989511+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11851 39693 swimming_water_temperature 2020-07-19T13:58:22.647109+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11826 41601 swimming_water_temperature 2020-07-19T10:03:19.352497+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11823 40157 swimming_water_temperature 2020-07-19T10:02:31.071933+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11817 39693 swimming_water_temperature 2020-07-18T18:24:17.508575+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11812 39583 swimming_water_temperature 2020-07-18T17:55:51.797309+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11808 39322 swimming_water_temperature 2020-07-18T14:22:15.370296+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11803 39583 swimming_water_temperature 2020-07-18T14:05:12.113303+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11799 39815 swimming_water_temperature 2020-07-18T14:00:19.273986+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11789 41601 swimming_water_temperature 2020-07-18T10:42:00.263623+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11782 39583 swimming_water_temperature 2020-07-18T10:18:16.088742+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11755 39815 swimming_water_temperature 2020-07-17T19:47:33.209449+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11748 39322 swimming_water_temperature 2020-07-17T18:36:51.833212+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11739 39815 swimming_water_temperature 2020-07-17T14:56:01.166549+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11723 41601 swimming_water_temperature 2020-07-17T10:48:55.915160+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11688 41601 swimming_water_temperature 2020-07-17T09:51:01.680434+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11669 39322 swimming_water_temperature 2020-07-16T17:43:52.451862+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11653 41601 swimming_water_temperature 2020-07-16T11:13:20.921799+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
11638 41601 swimming_water_temperature 2020-07-16T10:13:16.477856+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10895 39815 swimming_water_temperature 2020-07-05T14:28:33.361719+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10892 39583 swimming_water_temperature 2020-07-05T14:08:59.768961+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10887 39322 swimming_water_temperature 2020-07-05T13:52:09.847845+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
10737 40386 swimming_water_temperature 2020-07-03T09:49:53.810941+0300     21-23°C   21-23°C 0 21-23°C 21-23 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
);