observation
746 rows where name_en = "21-23°C" sorted by id descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );