observation
818 rows where name_fi = "15-17°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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17566 | 39412 | swimming_water_temperature | 2020-09-07T10:11:59.368806+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
17564 | 39412 | swimming_water_temperature | 2020-09-07T10:11:53.300729+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
17555 | 39713 | swimming_water_temperature | 2020-09-07T09:46:16.798143+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
17552 | 39875 | swimming_water_temperature | 2020-09-07T09:30:46.246035+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
17544 | 39902 | swimming_water_temperature | 2020-09-07T09:15:08.607089+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
17537 | 39606 | swimming_water_temperature | 2020-09-07T08:53:06.714842+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
17535 | 39823 | swimming_water_temperature | 2020-09-07T08:52:52.469770+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
17525 | 53461 | swimming_water_temperature | 2020-09-07T08:19:43.434408+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13814 | 39527 | swimming_water_temperature | 2020-08-15T15:32:40.700477+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13693 | 40157 | swimming_water_temperature | 2020-08-13T08:46:29.418678+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13692 | 40802 | swimming_water_temperature | 2020-08-13T08:46:12.362334+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13691 | 40150 | swimming_water_temperature | 2020-08-13T08:45:59.248379+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13690 | 40950 | swimming_water_temperature | 2020-08-13T08:45:48.437164+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13689 | 40150 | swimming_water_temperature | 2020-08-13T08:45:33.647611+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13687 | 40258 | swimming_water_temperature | 2020-08-13T08:45:01.247218+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13685 | 39568 | swimming_water_temperature | 2020-08-13T08:25:17.526176+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13636 | 39693 | swimming_water_temperature | 2020-08-12T10:11:40.978726+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13617 | 52959 | swimming_water_temperature | 2020-08-11T11:41:10.043713+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13576 | 52958 | swimming_water_temperature | 2020-08-10T14:24:02.628875+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13574 | 52960 | swimming_water_temperature | 2020-08-10T14:23:06.552866+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13564 | 39527 | swimming_water_temperature | 2020-08-10T11:50:03.034109+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13451 | 40142 | swimming_water_temperature | 2020-08-08T10:13:47.588691+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13427 | 39527 | swimming_water_temperature | 2020-08-08T08:20:32.645453+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13407 | 40802 | swimming_water_temperature | 2020-08-07T11:29:28.149381+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13389 | 40950 | swimming_water_temperature | 2020-08-07T10:04:54.197220+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13387 | 40559 | swimming_water_temperature | 2020-08-07T10:02:52.436954+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13379 | 40142 | swimming_water_temperature | 2020-08-07T09:57:10.134647+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13368 | 39568 | swimming_water_temperature | 2020-08-07T09:09:59.152804+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13347 | 39527 | swimming_water_temperature | 2020-08-07T08:16:54.244037+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13334 | 39527 | swimming_water_temperature | 2020-08-06T13:57:00.591590+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13324 | 41960 | swimming_water_temperature | 2020-08-06T11:28:19.312061+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13316 | 52959 | swimming_water_temperature | 2020-08-06T10:49:56.819072+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13314 | 40950 | swimming_water_temperature | 2020-08-06T10:41:57.735131+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13306 | 40559 | swimming_water_temperature | 2020-08-06T10:31:44.153057+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13303 | 40802 | swimming_water_temperature | 2020-08-06T10:20:28.505623+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13241 | 52959 | swimming_water_temperature | 2020-08-05T10:59:23.037033+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13236 | 40950 | swimming_water_temperature | 2020-08-05T10:28:01.499553+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13235 | 40559 | swimming_water_temperature | 2020-08-05T10:22:49.987025+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13201 | 41960 | swimming_water_temperature | 2020-08-05T09:46:08.682813+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13200 | 40142 | swimming_water_temperature | 2020-08-05T09:45:51.229018+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13182 | 39527 | swimming_water_temperature | 2020-08-05T08:31:50.713597+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13163 | 40993 | swimming_water_temperature | 2020-08-04T12:52:14.202686+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13154 | 39527 | swimming_water_temperature | 2020-08-04T11:40:16.904766+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13152 | 39568 | swimming_water_temperature | 2020-08-04T11:39:39.565683+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13143 | 40150 | swimming_water_temperature | 2020-08-04T10:25:11.133773+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13140 | 41960 | swimming_water_temperature | 2020-08-04T10:11:13.011460+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13135 | 40559 | swimming_water_temperature | 2020-08-04T10:10:15.641190+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13125 | 40142 | swimming_water_temperature | 2020-08-04T10:01:36.300829+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13123 | 52959 | swimming_water_temperature | 2020-08-04T10:01:16.538338+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13084 | 52959 | swimming_water_temperature | 2020-08-03T14:47:31.337596+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13077 | 39527 | swimming_water_temperature | 2020-08-03T13:16:38.970822+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13067 | 58015 | swimming_water_temperature | 2020-08-03T12:48:25.661952+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13065 | 41326 | swimming_water_temperature | 2020-08-03T12:48:11.251911+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13061 | 40921 | swimming_water_temperature | 2020-08-03T12:47:32.867206+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13052 | 40258 | swimming_water_temperature | 2020-08-03T12:45:18.563505+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13044 | 40559 | swimming_water_temperature | 2020-08-03T10:30:38.347648+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13039 | 39568 | swimming_water_temperature | 2020-08-03T10:20:09.545292+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13033 | 40150 | swimming_water_temperature | 2020-08-03T10:10:03.807761+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13031 | 52959 | swimming_water_temperature | 2020-08-03T10:09:35.618314+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13023 | 40142 | swimming_water_temperature | 2020-08-03T09:52:49.394789+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13021 | 41960 | swimming_water_temperature | 2020-08-03T09:52:46.102854+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12976 | 39527 | swimming_water_temperature | 2020-08-02T12:12:06.122823+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12973 | 40993 | swimming_water_temperature | 2020-08-02T11:27:57.936856+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12961 | 40142 | swimming_water_temperature | 2020-08-02T10:29:46.529914+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12954 | 40150 | swimming_water_temperature | 2020-08-02T10:16:37.563164+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12951 | 40950 | swimming_water_temperature | 2020-08-02T10:14:34.883088+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12948 | 52959 | swimming_water_temperature | 2020-08-02T10:13:03.584117+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12942 | 40559 | swimming_water_temperature | 2020-08-02T10:07:19.015941+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12940 | 40258 | swimming_water_temperature | 2020-08-02T10:03:38.594891+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12934 | 41960 | swimming_water_temperature | 2020-08-02T10:03:12.007838+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12905 | 39568 | swimming_water_temperature | 2020-08-02T08:56:06.183510+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12877 | 40098 | swimming_water_temperature | 2020-08-01T11:07:27.105428+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12875 | 41791 | swimming_water_temperature | 2020-08-01T11:02:18.683490+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12872 | 40559 | swimming_water_temperature | 2020-08-01T10:27:22.308552+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12871 | 40559 | swimming_water_temperature | 2020-08-01T10:27:16.640135+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12861 | 40150 | swimming_water_temperature | 2020-08-01T10:10:11.104871+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12854 | 40950 | swimming_water_temperature | 2020-08-01T10:08:31.546630+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12851 | 41960 | swimming_water_temperature | 2020-08-01T10:05:58.711175+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12847 | 40142 | swimming_water_temperature | 2020-08-01T10:03:50.548206+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12843 | 39568 | swimming_water_temperature | 2020-08-01T08:12:56.363232+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12810 | 40142 | swimming_water_temperature | 2020-07-31T11:12:51.981105+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12809 | 40802 | swimming_water_temperature | 2020-07-31T11:12:49.436541+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12807 | 40150 | swimming_water_temperature | 2020-07-31T10:50:39.411351+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12803 | 40950 | swimming_water_temperature | 2020-07-31T10:17:30.209690+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12801 | 52959 | swimming_water_temperature | 2020-07-31T10:14:00.802888+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12732 | 40098 | swimming_water_temperature | 2020-07-30T10:38:31.206121+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12723 | 40950 | swimming_water_temperature | 2020-07-30T10:09:49.744838+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12717 | 40142 | swimming_water_temperature | 2020-07-30T10:07:00.152468+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12709 | 41791 | swimming_water_temperature | 2020-07-30T09:50:48.485280+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12708 | 41960 | swimming_water_temperature | 2020-07-30T09:49:59.924937+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12680 | 39568 | swimming_water_temperature | 2020-07-29T15:40:33.047969+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12678 | 52959 | swimming_water_temperature | 2020-07-29T14:10:53.695590+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12665 | 40802 | swimming_water_temperature | 2020-07-29T10:57:23.944794+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12657 | 40098 | swimming_water_temperature | 2020-07-29T10:27:55.504922+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12639 | 52959 | swimming_water_temperature | 2020-07-29T10:06:03.066559+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12631 | 40142 | swimming_water_temperature | 2020-07-29T09:56:33.918639+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12629 | 41791 | swimming_water_temperature | 2020-07-29T09:44:54.653744+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12628 | 39527 | swimming_water_temperature | 2020-07-29T09:27:50.576197+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12576 | 40559 | swimming_water_temperature | 2020-07-28T11:21:36.199950+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
12569 | 40098 | swimming_water_temperature | 2020-07-28T11:06:06.408530+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | 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 );