observation

4,968 rows where primary = 0 sorted by unit

✎ View and edit SQL

This data as json, CSV (advanced)

primary ✖

  • 0 · 4,868 ✖
id unit ▼ property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
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  
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  
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  
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  
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  
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  
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  
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  
9017 39267 swimming_water_temperature 2020-06-10T15:00:34.668854+0300     15-17°C   15-17°C 0 15-17°C 15-17 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  
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  
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  
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  
8977 39289 swimming_water_temperature 2020-06-10T10:03:16.609252+0300     15-17°C   15-17°C 0 15-17°C 15-17 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  
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  
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  
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  
381 39322 swimming_water_temperature 2019-06-09T18:44:40.198426+0300     15-17°C   15-17°C 0 15-17°C 15-17 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  
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  
410 39322 swimming_water_temperature 2019-06-10T13:45:12.831410+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
424 39322 swimming_water_temperature 2019-06-10T17:50:52.926026+0300     15-17°C   15-17°C 0 15-17°C 15-17 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  
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  
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  
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  

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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
);