observation
1,246 rows where name_en = "19-21°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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
402 | 39267 | swimming_water_temperature | 2019-06-10T10:34:16.433547+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
414 | 39267 | swimming_water_temperature | 2019-06-10T13:56:59.031717+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
477 | 39267 | swimming_water_temperature | 2019-06-11T10:10:30.491830+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
560 | 39267 | swimming_water_temperature | 2019-06-11T14:00:08.545368+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
567 | 39267 | swimming_water_temperature | 2019-06-11T17:56:58.976591+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
586 | 39267 | swimming_water_temperature | 2019-06-12T10:22:49.596387+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
590 | 39267 | swimming_water_temperature | 2019-06-12T10:45:40.373126+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
607 | 39267 | swimming_water_temperature | 2019-06-12T14:02:38.897497+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
789 | 39267 | swimming_water_temperature | 2019-06-15T15:47:49.654002+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
839 | 39267 | swimming_water_temperature | 2019-06-16T10:13:35.683029+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
866 | 39267 | swimming_water_temperature | 2019-06-16T13:57:23.060048+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
876 | 39267 | swimming_water_temperature | 2019-06-16T17:52:59.322927+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
903 | 39267 | swimming_water_temperature | 2019-06-17T10:04:13.439995+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
951 | 39267 | swimming_water_temperature | 2019-06-17T17:52:53.460520+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
979 | 39267 | swimming_water_temperature | 2019-06-18T10:04:57.735750+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
980 | 39267 | swimming_water_temperature | 2019-06-18T10:05:00.762138+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1002 | 39267 | swimming_water_temperature | 2019-06-18T13:57:25.844224+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1017 | 39267 | swimming_water_temperature | 2019-06-18T17:41:59.020786+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1040 | 39267 | swimming_water_temperature | 2019-06-19T10:10:03.476058+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1089 | 39267 | swimming_water_temperature | 2019-06-19T14:03:19.520056+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1095 | 39267 | swimming_water_temperature | 2019-06-19T17:34:57.302155+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1155 | 39267 | swimming_water_temperature | 2019-06-20T11:10:35.672801+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1185 | 39267 | swimming_water_temperature | 2019-06-20T14:07:46.017198+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1194 | 39267 | swimming_water_temperature | 2019-06-20T17:48:34.570676+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1470 | 39267 | swimming_water_temperature | 2019-06-25T10:16:26.334389+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1614 | 39267 | swimming_water_temperature | 2019-06-27T10:12:18.028207+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1700 | 39267 | swimming_water_temperature | 2019-06-27T14:45:09.722913+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1706 | 39267 | swimming_water_temperature | 2019-06-27T17:48:29.213219+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1722 | 39267 | swimming_water_temperature | 2019-06-28T10:03:09.841126+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1756 | 39267 | swimming_water_temperature | 2019-06-28T14:01:28.720519+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1775 | 39267 | swimming_water_temperature | 2019-06-28T17:42:46.574985+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1789 | 39267 | swimming_water_temperature | 2019-06-29T09:59:30.222957+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1833 | 39267 | swimming_water_temperature | 2019-06-29T13:56:02.824526+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1846 | 39267 | swimming_water_temperature | 2019-06-29T17:48:43.073234+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1876 | 39267 | swimming_water_temperature | 2019-06-30T10:12:20.686299+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1907 | 39267 | swimming_water_temperature | 2019-06-30T14:03:07.579893+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1923 | 39267 | swimming_water_temperature | 2019-06-30T17:38:52.157617+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1953 | 39267 | swimming_water_temperature | 2019-07-01T09:59:33.828571+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
2009 | 39267 | swimming_water_temperature | 2019-07-01T13:51:44.519459+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
2036 | 39267 | swimming_water_temperature | 2019-07-01T17:49:55.811806+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
2142 | 39267 | swimming_water_temperature | 2019-07-03T14:13:00.697612+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
2189 | 39267 | swimming_water_temperature | 2019-07-04T10:10:10.186814+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
2233 | 39267 | swimming_water_temperature | 2019-07-04T14:12:12.592060+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
2244 | 39267 | swimming_water_temperature | 2019-07-04T17:45:26.344932+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
2400 | 39267 | swimming_water_temperature | 2019-07-06T14:04:02.458633+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
2411 | 39267 | swimming_water_temperature | 2019-07-06T17:48:22.255463+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
2565 | 39267 | swimming_water_temperature | 2019-07-08T17:37:10.792865+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3004 | 39267 | swimming_water_temperature | 2019-07-14T14:53:49.894309+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3015 | 39267 | swimming_water_temperature | 2019-07-14T17:52:33.761530+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3039 | 39267 | swimming_water_temperature | 2019-07-15T10:04:27.014528+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3098 | 39267 | swimming_water_temperature | 2019-07-15T14:28:25.914776+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3105 | 39267 | swimming_water_temperature | 2019-07-15T17:44:05.128481+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3117 | 39267 | swimming_water_temperature | 2019-07-16T09:59:31.850108+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3162 | 39267 | swimming_water_temperature | 2019-07-16T15:09:56.292322+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3200 | 39267 | swimming_water_temperature | 2019-07-17T10:05:54.033584+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3246 | 39267 | swimming_water_temperature | 2019-07-17T14:02:52.847107+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3262 | 39267 | swimming_water_temperature | 2019-07-17T17:50:33.597449+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3292 | 39267 | swimming_water_temperature | 2019-07-18T09:59:48.718039+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3433 | 39267 | swimming_water_temperature | 2019-07-19T10:13:18.233405+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3469 | 39267 | swimming_water_temperature | 2019-07-19T13:53:31.318038+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3518 | 39267 | swimming_water_temperature | 2019-07-19T17:43:23.836817+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3537 | 39267 | swimming_water_temperature | 2019-07-20T09:57:54.462401+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3587 | 39267 | swimming_water_temperature | 2019-07-20T14:01:36.230761+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3603 | 39267 | swimming_water_temperature | 2019-07-20T17:45:25.194745+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
3692 | 39267 | swimming_water_temperature | 2019-07-21T17:48:00.694868+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
4791 | 39267 | swimming_water_temperature | 2019-07-31T10:34:55.208445+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
4845 | 39267 | swimming_water_temperature | 2019-07-31T14:19:22.756997+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
4856 | 39267 | swimming_water_temperature | 2019-07-31T17:56:10.631577+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
4993 | 39267 | swimming_water_temperature | 2019-08-02T10:12:01.767455+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
5026 | 39267 | swimming_water_temperature | 2019-08-02T14:14:57.553497+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
5064 | 39267 | swimming_water_temperature | 2019-08-02T17:52:21.937724+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
5083 | 39267 | swimming_water_temperature | 2019-08-03T10:01:28.119974+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
5352 | 39267 | swimming_water_temperature | 2019-08-05T15:57:13.133849+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
5354 | 39267 | swimming_water_temperature | 2019-08-05T17:43:57.104841+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
5420 | 39267 | swimming_water_temperature | 2019-08-06T15:39:40.834375+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
5422 | 39267 | swimming_water_temperature | 2019-08-06T17:45:55.968815+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
5744 | 39267 | swimming_water_temperature | 2019-08-10T17:45:36.514475+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
5787 | 39267 | swimming_water_temperature | 2019-08-11T10:05:05.064317+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
5863 | 39267 | swimming_water_temperature | 2019-08-13T13:15:07.243674+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
11920 | 39267 | swimming_water_temperature | 2020-07-20T13:02:30.258339+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
336 | 39322 | swimming_water_temperature | 2019-06-09T10:15:16.605748+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
391 | 39322 | swimming_water_temperature | 2019-06-10T10:01:21.612696+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
554 | 39322 | swimming_water_temperature | 2019-06-11T13:45:44.348861+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
565 | 39322 | swimming_water_temperature | 2019-06-11T17:52:45.689952+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
605 | 39322 | swimming_water_temperature | 2019-06-12T14:00:57.182507+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
620 | 39322 | swimming_water_temperature | 2019-06-12T17:49:09.441105+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
798 | 39322 | swimming_water_temperature | 2019-06-15T18:23:35.165620+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
832 | 39322 | swimming_water_temperature | 2019-06-16T10:08:45.758606+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1008 | 39322 | swimming_water_temperature | 2019-06-18T14:03:26.589887+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1026 | 39322 | swimming_water_temperature | 2019-06-18T18:28:36.975793+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1037 | 39322 | swimming_water_temperature | 2019-06-19T10:00:23.206036+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1083 | 39322 | swimming_water_temperature | 2019-06-19T13:56:43.298178+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1085 | 39322 | swimming_water_temperature | 2019-06-19T13:56:50.743850+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1097 | 39322 | swimming_water_temperature | 2019-06-19T17:53:32.524886+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1140 | 39322 | swimming_water_temperature | 2019-06-20T10:20:03.741205+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1179 | 39322 | swimming_water_temperature | 2019-06-20T13:58:33.371598+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1201 | 39322 | swimming_water_temperature | 2019-06-20T18:02:19.222924+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1392 | 39322 | swimming_water_temperature | 2019-06-24T10:32:17.606737+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1424 | 39322 | swimming_water_temperature | 2019-06-24T14:04:30.533467+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
1459 | 39322 | swimming_water_temperature | 2019-06-25T09:57:50.869978+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | 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 );