observation
1,261 rows where name_en = "17-19°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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
173 | 39267 | swimming_water_temperature | 2019-06-06T12:51:32.063938+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
180 | 39267 | swimming_water_temperature | 2019-06-06T14:10:39.608279+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
654 | 39267 | swimming_water_temperature | 2019-06-13T10:08:49.115932+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
685 | 39267 | swimming_water_temperature | 2019-06-13T15:03:53.067568+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
720 | 39267 | swimming_water_temperature | 2019-06-14T10:04:47.457711+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
745 | 39267 | swimming_water_temperature | 2019-06-14T17:56:22.115728+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
766 | 39267 | swimming_water_temperature | 2019-06-15T10:23:55.291543+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2110 | 39267 | swimming_water_temperature | 2019-07-03T10:13:45.186996+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2112 | 39267 | swimming_water_temperature | 2019-07-03T10:15:05.155744+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2114 | 39267 | swimming_water_temperature | 2019-07-03T10:15:47.945661+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2317 | 39267 | swimming_water_temperature | 2019-07-05T12:33:07.402395+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2326 | 39267 | swimming_water_temperature | 2019-07-05T14:05:04.871221+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2338 | 39267 | swimming_water_temperature | 2019-07-05T18:00:06.343013+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2373 | 39267 | swimming_water_temperature | 2019-07-06T10:17:47.427550+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2431 | 39267 | swimming_water_temperature | 2019-07-07T10:07:56.387691+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2471 | 39267 | swimming_water_temperature | 2019-07-07T13:54:25.098157+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2488 | 39267 | swimming_water_temperature | 2019-07-07T17:53:52.990159+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2507 | 39267 | swimming_water_temperature | 2019-07-08T10:01:25.838792+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2544 | 39267 | swimming_water_temperature | 2019-07-08T13:53:49.390740+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2603 | 39267 | swimming_water_temperature | 2019-07-09T10:50:29.075385+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2620 | 39267 | swimming_water_temperature | 2019-07-09T16:00:51.895245+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2622 | 39267 | swimming_water_temperature | 2019-07-09T17:48:13.835579+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2659 | 39267 | swimming_water_temperature | 2019-07-10T10:00:50.201105+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2716 | 39267 | swimming_water_temperature | 2019-07-10T14:49:51.523271+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2725 | 39267 | swimming_water_temperature | 2019-07-10T17:46:18.601814+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2801 | 39267 | swimming_water_temperature | 2019-07-11T15:15:35.883695+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2809 | 39267 | swimming_water_temperature | 2019-07-11T17:57:47.566309+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2827 | 39267 | swimming_water_temperature | 2019-07-12T10:04:28.034084+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2857 | 39267 | swimming_water_temperature | 2019-07-12T14:01:13.640568+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2873 | 39267 | swimming_water_temperature | 2019-07-12T17:47:57.139204+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2889 | 39267 | swimming_water_temperature | 2019-07-13T10:03:49.496036+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2932 | 39267 | swimming_water_temperature | 2019-07-13T14:39:05.529237+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2939 | 39267 | swimming_water_temperature | 2019-07-13T17:45:21.461912+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2975 | 39267 | swimming_water_temperature | 2019-07-14T10:14:52.184559+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
3358 | 39267 | swimming_water_temperature | 2019-07-18T14:12:23.276428+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
3387 | 39267 | swimming_water_temperature | 2019-07-18T17:52:27.258064+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
5136 | 39267 | swimming_water_temperature | 2019-08-03T14:25:59.503130+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
5149 | 39267 | swimming_water_temperature | 2019-08-03T17:55:44.801691+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
5162 | 39267 | swimming_water_temperature | 2019-08-04T09:54:26.944076+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
5215 | 39267 | swimming_water_temperature | 2019-08-04T14:20:04.068388+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
5225 | 39267 | swimming_water_temperature | 2019-08-04T17:48:49.545908+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
5279 | 39267 | swimming_water_temperature | 2019-08-05T10:14:23.887367+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
5453 | 39267 | swimming_water_temperature | 2019-08-07T10:13:29.700982+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
5474 | 39267 | swimming_water_temperature | 2019-08-07T14:19:45.231829+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
5505 | 39267 | swimming_water_temperature | 2019-08-07T17:51:23.360001+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
5564 | 39267 | swimming_water_temperature | 2019-08-08T11:41:01.813272+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
5593 | 39267 | swimming_water_temperature | 2019-08-08T15:05:48.037389+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
5642 | 39267 | swimming_water_temperature | 2019-08-09T10:25:25.422185+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
5696 | 39267 | swimming_water_temperature | 2019-08-10T10:07:47.993942+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
5742 | 39267 | swimming_water_temperature | 2019-08-10T15:09:01.272047+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
5812 | 39267 | swimming_water_temperature | 2019-08-11T13:51:00.562388+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
5824 | 39267 | swimming_water_temperature | 2019-08-11T17:33:37.726233+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
5906 | 39267 | swimming_water_temperature | 2019-08-21T11:32:23.926614+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
11470 | 39267 | swimming_water_temperature | 2020-07-14T11:36:20.143010+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
258 | 39322 | swimming_water_temperature | 2019-06-07T19:42:40.358960+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
366 | 39322 | swimming_water_temperature | 2019-06-09T14:07:43.671307+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
408 | 39322 | swimming_water_temperature | 2019-06-10T13:40:51.100444+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
460 | 39322 | swimming_water_temperature | 2019-06-11T09:50:53.764841+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
572 | 39322 | swimming_water_temperature | 2019-06-12T10:04:11.081301+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
651 | 39322 | swimming_water_temperature | 2019-06-13T10:08:10.286362+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
695 | 39322 | swimming_water_temperature | 2019-06-13T18:42:33.276787+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
709 | 39322 | swimming_water_temperature | 2019-06-14T09:44:09.977393+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
716 | 39322 | swimming_water_temperature | 2019-06-14T10:00:50.300444+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
743 | 39322 | swimming_water_temperature | 2019-06-14T14:18:25.495876+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
757 | 39322 | swimming_water_temperature | 2019-06-15T10:02:51.692215+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
785 | 39322 | swimming_water_temperature | 2019-06-15T13:56:34.538850+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
796 | 39322 | swimming_water_temperature | 2019-06-15T18:21:00.124038+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
884 | 39322 | swimming_water_temperature | 2019-06-16T19:01:21.720326+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
900 | 39322 | swimming_water_temperature | 2019-06-17T09:59:14.994200+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
935 | 39322 | swimming_water_temperature | 2019-06-17T14:01:39.827519+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
982 | 39322 | swimming_water_temperature | 2019-06-18T10:07:13.667769+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2095 | 39322 | swimming_water_temperature | 2019-07-03T09:51:30.497559+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2140 | 39322 | swimming_water_temperature | 2019-07-03T14:07:20.363201+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2168 | 39322 | swimming_water_temperature | 2019-07-04T09:59:02.771170+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2239 | 39322 | swimming_water_temperature | 2019-07-04T14:32:00.559812+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2246 | 39322 | swimming_water_temperature | 2019-07-04T17:49:01.897395+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2279 | 39322 | swimming_water_temperature | 2019-07-05T09:59:44.735819+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2324 | 39322 | swimming_water_temperature | 2019-07-05T13:58:28.574554+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2342 | 39322 | swimming_water_temperature | 2019-07-05T18:08:52.771046+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2352 | 39322 | swimming_water_temperature | 2019-07-06T09:50:23.441295+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2415 | 39322 | swimming_water_temperature | 2019-07-06T17:57:55.076023+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2435 | 39322 | swimming_water_temperature | 2019-07-07T10:11:49.007038+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2519 | 39322 | swimming_water_temperature | 2019-07-08T10:07:07.554278+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2556 | 39322 | swimming_water_temperature | 2019-07-08T14:27:30.373899+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2570 | 39322 | swimming_water_temperature | 2019-07-08T18:10:35.944554+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2588 | 39322 | swimming_water_temperature | 2019-07-09T10:10:27.295438+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2612 | 39322 | swimming_water_temperature | 2019-07-09T13:54:08.973160+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2629 | 39322 | swimming_water_temperature | 2019-07-09T19:53:45.665798+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2686 | 39322 | swimming_water_temperature | 2019-07-10T10:35:56.495250+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2712 | 39322 | swimming_water_temperature | 2019-07-10T14:05:06.362782+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2759 | 39322 | swimming_water_temperature | 2019-07-11T10:00:32.715725+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2807 | 39322 | swimming_water_temperature | 2019-07-11T17:55:40.167288+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2813 | 39322 | swimming_water_temperature | 2019-07-11T18:05:25.412908+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2865 | 39322 | swimming_water_temperature | 2019-07-12T14:15:32.341606+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2902 | 39322 | swimming_water_temperature | 2019-07-13T10:38:15.436999+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2922 | 39322 | swimming_water_temperature | 2019-07-13T13:48:20.670844+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2941 | 39322 | swimming_water_temperature | 2019-07-13T17:47:42.960222+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
2952 | 39322 | swimming_water_temperature | 2019-07-14T09:48:27.641824+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
3137 | 39322 | swimming_water_temperature | 2019-07-16T10:10:31.223766+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
3164 | 39322 | swimming_water_temperature | 2019-07-16T15:32:01.620567+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | 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 );