observation
4,968 rows where primary = 0 sorted by unit
This data as json, CSV (advanced)
name_sv ✖
- 17-19°C 1,261
- 19-21°C 1,246
- 15-17°C 818
- 21-23°C 746
- under 15°C 497
- Iståndsatt 220
- över 23°C 180
name_en ✖
- 17-19°C 1,261
- 19-21°C 1,246
- 15-17°C 818
- 21-23°C 746
- below 15°C 497
- Maintenance finished 220
- above 23°C 180
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 |
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 );