observation

1,246 rows where name_fi = "19-21°C"

✎ View and edit SQL

This data as json, CSV (advanced)

name_fi ✖

  • 19-21°C · 1,146 ✖
id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
973 39693 swimming_water_temperature 2019-06-18T09:14:44.346461+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  
985 39815 swimming_water_temperature 2019-06-18T10:08:58.163846+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
987 41601 swimming_water_temperature 2019-06-18T10:09:02.391852+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
998 41960 swimming_water_temperature 2019-06-18T12:25:33.925206+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  
1004 39693 swimming_water_temperature 2019-06-18T14:02:58.538067+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1008 39322 swimming_water_temperature 2019-06-18T14:03:26.589887+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1011 39815 swimming_water_temperature 2019-06-18T14:08:15.633290+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  
1022 39693 swimming_water_temperature 2019-06-18T18:03:27.116163+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1026 39322 swimming_water_temperature 2019-06-18T18:28:36.975793+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1027 39815 swimming_water_temperature 2019-06-18T18:34:37.210909+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1029 39693 swimming_water_temperature 2019-06-19T08:53:16.300412+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1034 39815 swimming_water_temperature 2019-06-19T09:57:26.877364+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1037 39322 swimming_water_temperature 2019-06-19T10:00:23.206036+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  
1052 41960 swimming_water_temperature 2019-06-19T10:54:37.660937+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1077 53461 swimming_water_temperature 2019-06-19T13:51:27.872640+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1078 39902 swimming_water_temperature 2019-06-19T13:51:31.888677+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1079 39875 swimming_water_temperature 2019-06-19T13:51:36.544111+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1080 39823 swimming_water_temperature 2019-06-19T13:51:40.877643+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1081 39606 swimming_water_temperature 2019-06-19T13:51:45.586754+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1082 39412 swimming_water_temperature 2019-06-19T13:52:05.552107+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1083 39322 swimming_water_temperature 2019-06-19T13:56:43.298178+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1085 39322 swimming_water_temperature 2019-06-19T13:56:50.743850+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1086 39693 swimming_water_temperature 2019-06-19T14:02:42.761295+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  
1097 39322 swimming_water_temperature 2019-06-19T17:53:32.524886+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1101 39693 swimming_water_temperature 2019-06-19T18:11:56.001979+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1108 39815 swimming_water_temperature 2019-06-19T18:14:20.981814+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1110 39412 swimming_water_temperature 2019-06-20T08:17:31.288276+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1112 39823 swimming_water_temperature 2019-06-20T09:06:02.130469+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1114 53461 swimming_water_temperature 2019-06-20T09:06:24.012568+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1116 39693 swimming_water_temperature 2019-06-20T09:28:01.506713+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1119 39875 swimming_water_temperature 2019-06-20T09:55:35.742758+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1121 39713 swimming_water_temperature 2019-06-20T10:02:04.748221+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1132 39815 swimming_water_temperature 2019-06-20T10:08:55.582249+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1134 40098 swimming_water_temperature 2019-06-20T10:11:06.108590+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1140 39322 swimming_water_temperature 2019-06-20T10:20:03.741205+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1141 40142 swimming_water_temperature 2019-06-20T10:21:34.903362+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1145 41960 swimming_water_temperature 2019-06-20T10:27:08.938367+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1147 41601 swimming_water_temperature 2019-06-20T10:32:53.639607+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  
1167 40921 swimming_water_temperature 2019-06-20T13:51:35.632755+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1169 41326 swimming_water_temperature 2019-06-20T13:51:49.039025+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1173 40677 swimming_water_temperature 2019-06-20T13:52:59.988979+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1177 40993 swimming_water_temperature 2019-06-20T13:54:46.207449+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1179 39322 swimming_water_temperature 2019-06-20T13:58:33.371598+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1182 39693 swimming_water_temperature 2019-06-20T14:00:53.666634+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  
1188 39583 swimming_water_temperature 2019-06-20T14:19:21.794125+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1191 39846 swimming_water_temperature 2019-06-20T14:20:08.098425+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  
1201 39322 swimming_water_temperature 2019-06-20T18:02:19.222924+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1203 39527 swimming_water_temperature 2019-06-20T18:08:41.351778+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1204 40142 swimming_water_temperature 2019-06-21T10:02:45.520295+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1277 41601 swimming_water_temperature 2019-06-21T17:01:36.871912+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1290 40386 swimming_water_temperature 2019-06-22T11:48:02.391028+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1298 41601 swimming_water_temperature 2019-06-22T14:36:58.192142+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1300 40142 swimming_water_temperature 2019-06-22T16:26:46.567295+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1304 41960 swimming_water_temperature 2019-06-23T10:09:58.917524+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1310 41601 swimming_water_temperature 2019-06-23T10:19:49.828890+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1314 40098 swimming_water_temperature 2019-06-23T10:42:30.032492+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1322 40142 swimming_water_temperature 2019-06-23T12:16:26.148406+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1342 39713 swimming_water_temperature 2019-06-24T07:33:14.638974+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1344 39875 swimming_water_temperature 2019-06-24T07:45:22.657856+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1346 39902 swimming_water_temperature 2019-06-24T08:07:07.943922+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1348 39606 swimming_water_temperature 2019-06-24T08:13:48.284584+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1349 39606 swimming_water_temperature 2019-06-24T08:13:51.069412+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1351 53461 swimming_water_temperature 2019-06-24T08:27:14.155427+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1353 39823 swimming_water_temperature 2019-06-24T08:48:01.340865+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1355 39412 swimming_water_temperature 2019-06-24T09:15:58.463154+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1361 41960 swimming_water_temperature 2019-06-24T10:08:17.002441+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1372 41326 swimming_water_temperature 2019-06-24T10:19:57.049806+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1374 41031 swimming_water_temperature 2019-06-24T10:20:26.766826+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1376 40921 swimming_water_temperature 2019-06-24T10:20:33.206691+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1378 40677 swimming_water_temperature 2019-06-24T10:20:42.111151+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1382 40020 swimming_water_temperature 2019-06-24T10:21:08.695418+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1384 40993 swimming_water_temperature 2019-06-24T10:21:17.892138+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1386 41601 swimming_water_temperature 2019-06-24T10:23:21.271018+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1388 39815 swimming_water_temperature 2019-06-24T10:28:26.877686+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1392 39322 swimming_water_temperature 2019-06-24T10:32:17.606737+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1403 39583 swimming_water_temperature 2019-06-24T10:55:51.663438+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1413 40142 swimming_water_temperature 2019-06-24T12:12:14.050950+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1419 39815 swimming_water_temperature 2019-06-24T13:56:35.519199+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1421 39583 swimming_water_temperature 2019-06-24T14:01:10.970245+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1424 39322 swimming_water_temperature 2019-06-24T14:04:30.533467+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1436 39583 swimming_water_temperature 2019-06-24T17:43:24.944374+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1445 39815 swimming_water_temperature 2019-06-24T17:49:41.407724+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1459 39322 swimming_water_temperature 2019-06-25T09:57:50.869978+0300     19-21°C   19-21°C 0 19-21°C 19-21 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  
1475 41960 swimming_water_temperature 2019-06-25T10:19:42.935985+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1477 39583 swimming_water_temperature 2019-06-25T10:21:56.858506+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1492 40386 swimming_water_temperature 2019-06-25T12:06:11.586989+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1494 40142 swimming_water_temperature 2019-06-25T13:17:30.922629+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1504 39322 swimming_water_temperature 2019-06-25T14:08:27.238526+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1506 39322 swimming_water_temperature 2019-06-25T14:10:38.668208+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
);