observation

1,261 rows where name_en = "17-19°C" sorted by unit

✎ View and edit SQL

This data as json, CSV (advanced)

name_en ✖

  • 17-19°C · 1,261 ✖
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  

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