observation
4,968 rows where quality = "unknown" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
4338 | 39267 | swimming_water_temperature | 2019-07-26T14:08:48.575391+0300 | yli 23°C | över 23°C | 0 | above 23°C | 23-100 | unknown | ||||
4346 | 39267 | swimming_water_temperature | 2019-07-26T17:32:52.575018+0300 | yli 23°C | över 23°C | 0 | above 23°C | 23-100 | unknown | ||||
4477 | 39267 | swimming_water_temperature | 2019-07-27T17:44:10.582720+0300 | yli 23°C | över 23°C | 0 | above 23°C | 23-100 | 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 | ||||
4547 | 39267 | swimming_water_temperature | 2019-07-28T17:51:24.318070+0300 | yli 23°C | över 23°C | 0 | above 23°C | 23-100 | unknown | ||||
4604 | 39267 | swimming_water_temperature | 2019-07-29T10:01:43.611270+0300 | yli 23°C | över 23°C | 0 | above 23°C | 23-100 | unknown | ||||
4669 | 39267 | swimming_water_temperature | 2019-07-29T16:29:33.675718+0300 | yli 23°C | över 23°C | 0 | above 23°C | 23-100 | unknown | ||||
4678 | 39267 | swimming_water_temperature | 2019-07-29T17:45:23.075920+0300 | yli 23°C | över 23°C | 0 | above 23°C | 23-100 | 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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 |
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 );