observation
746 rows where name_en = "21-23°C" sorted by unit
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
296 | 39267 | swimming_water_temperature | 2019-06-08T17:01:07.633245+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
301 | 39267 | swimming_water_temperature | 2019-06-08T17:58:54.777603+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
339 | 39267 | swimming_water_temperature | 2019-06-09T10:21:42.793020+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
374 | 39267 | swimming_water_temperature | 2019-06-09T17:54:11.286114+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
933 | 39267 | swimming_water_temperature | 2019-06-17T13:59:33.608988+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
1359 | 39267 | swimming_water_temperature | 2019-06-24T10:07:46.646036+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
1426 | 39267 | swimming_water_temperature | 2019-06-24T14:13:53.042983+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
1443 | 39267 | swimming_water_temperature | 2019-06-24T17:46:11.049406+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
1499 | 39267 | swimming_water_temperature | 2019-06-25T13:56:36.662049+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
1537 | 39267 | swimming_water_temperature | 2019-06-25T17:45:23.883233+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
1556 | 39267 | swimming_water_temperature | 2019-06-26T10:21:48.404757+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
1578 | 39267 | swimming_water_temperature | 2019-06-26T14:04:59.960700+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
1589 | 39267 | swimming_water_temperature | 2019-06-26T18:01:29.156373+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
1755 | 39267 | swimming_water_temperature | 2019-06-28T12:30:03.099858+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
3656 | 39267 | swimming_water_temperature | 2019-07-21T10:40:00.785107+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
3684 | 39267 | swimming_water_temperature | 2019-07-21T14:16:04.111380+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
3787 | 39267 | swimming_water_temperature | 2019-07-22T10:30:29.201404+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
3802 | 39267 | swimming_water_temperature | 2019-07-22T14:07:58.998499+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
3813 | 39267 | swimming_water_temperature | 2019-07-22T17:42:43.626233+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
3891 | 39267 | swimming_water_temperature | 2019-07-23T10:28:44.044986+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
3931 | 39267 | swimming_water_temperature | 2019-07-23T17:39:38.202978+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
3960 | 39267 | swimming_water_temperature | 2019-07-24T10:00:56.694968+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
4068 | 39267 | swimming_water_temperature | 2019-07-24T17:48:03.304207+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
4112 | 39267 | swimming_water_temperature | 2019-07-25T10:15:52.017826+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
4176 | 39267 | swimming_water_temperature | 2019-07-25T14:04:46.430645+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
4201 | 39267 | swimming_water_temperature | 2019-07-25T17:48:45.083968+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
4254 | 39267 | swimming_water_temperature | 2019-07-26T10:04:13.204558+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
4526 | 39267 | swimming_water_temperature | 2019-07-28T14:26:37.323033+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
4546 | 39267 | swimming_water_temperature | 2019-07-28T17:51:04.366394+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
4693 | 39267 | swimming_water_temperature | 2019-07-30T10:02:12.366747+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
4742 | 39267 | swimming_water_temperature | 2019-07-30T15:03:15.597544+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
4748 | 39267 | swimming_water_temperature | 2019-07-30T17:56:11.499554+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
4889 | 39267 | swimming_water_temperature | 2019-08-01T10:21:41.840771+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
4891 | 39267 | swimming_water_temperature | 2019-08-01T10:22:31.076396+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
9545 | 39267 | swimming_water_temperature | 2020-06-17T08:55:10.220727+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
9902 | 39267 | swimming_water_temperature | 2020-06-23T09:47:45.753569+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 | ||||
222 | 39322 | swimming_water_temperature | 2019-06-07T11:23:40.887777+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
224 | 39322 | swimming_water_temperature | 2019-06-07T11:35:37.055471+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
226 | 39322 | swimming_water_temperature | 2019-06-07T11:35:37.494252+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
228 | 39322 | swimming_water_temperature | 2019-06-07T11:35:37.963596+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
244 | 39322 | swimming_water_temperature | 2019-06-07T15:15:49.773357+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
245 | 39322 | swimming_water_temperature | 2019-06-07T15:17:51.123747+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
1180 | 39322 | swimming_water_temperature | 2019-06-20T13:58:38.404204+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
1448 | 39322 | swimming_water_temperature | 2019-06-24T17:52:07.245628+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
3388 | 39322 | swimming_water_temperature | 2019-07-18T17:59:16.367615+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
3589 | 39322 | swimming_water_temperature | 2019-07-20T14:02:13.169518+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
3676 | 39322 | swimming_water_temperature | 2019-07-21T14:01:53.621932+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
3700 | 39322 | swimming_water_temperature | 2019-07-21T18:17:28.032777+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
3768 | 39322 | swimming_water_temperature | 2019-07-22T10:04:21.673127+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
3822 | 39322 | swimming_water_temperature | 2019-07-22T18:20:20.549804+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
3853 | 39322 | swimming_water_temperature | 2019-07-23T10:04:59.367446+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
3924 | 39322 | swimming_water_temperature | 2019-07-23T14:30:21.199704+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
3937 | 39322 | swimming_water_temperature | 2019-07-23T18:08:28.237910+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
3955 | 39322 | swimming_water_temperature | 2019-07-24T09:58:46.245526+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
4160 | 39322 | swimming_water_temperature | 2019-07-25T12:40:00.256076+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
4259 | 39322 | swimming_water_temperature | 2019-07-26T10:09:11.901961+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
4331 | 39322 | swimming_water_temperature | 2019-07-26T13:56:57.833553+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
9433 | 39322 | swimming_water_temperature | 2020-06-15T14:22:06.501545+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
9449 | 39322 | swimming_water_temperature | 2020-06-15T17:58:36.660246+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
9451 | 39322 | swimming_water_temperature | 2020-06-15T18:00:09.879986+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
9514 | 39322 | swimming_water_temperature | 2020-06-16T13:57:00.836013+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
9530 | 39322 | swimming_water_temperature | 2020-06-16T18:13:22.405195+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
9619 | 39322 | swimming_water_temperature | 2020-06-17T17:58:39.289578+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
9637 | 39322 | swimming_water_temperature | 2020-06-18T09:34:16.800503+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
9694 | 39322 | swimming_water_temperature | 2020-06-18T18:05:33.552939+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
9696 | 39322 | swimming_water_temperature | 2020-06-18T18:16:54.025644+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
9821 | 39322 | swimming_water_temperature | 2020-06-22T09:46:24.984534+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
9890 | 39322 | swimming_water_temperature | 2020-06-23T09:14:45.440058+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
10284 | 39322 | swimming_water_temperature | 2020-06-26T19:10:44.738510+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
10527 | 39322 | swimming_water_temperature | 2020-06-30T10:01:33.203172+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
10562 | 39322 | swimming_water_temperature | 2020-06-30T14:13:26.137857+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
10605 | 39322 | swimming_water_temperature | 2020-07-01T10:55:06.129346+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
10619 | 39322 | swimming_water_temperature | 2020-07-01T13:51:22.286098+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
10686 | 39322 | swimming_water_temperature | 2020-07-02T14:10:32.034085+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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
3919 | 39368 | swimming_water_temperature | 2019-07-23T13:45:48.253194+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
9588 | 39368 | swimming_water_temperature | 2020-06-17T11:01:36.486371+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 | ||||
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 | ||||
3915 | 39412 | swimming_water_temperature | 2019-07-23T13:30:21.949031+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
4035 | 39412 | swimming_water_temperature | 2019-07-24T12:21:30.083616+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
4145 | 39412 | swimming_water_temperature | 2019-07-25T10:55:55.890977+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 );