observation

1,261 rows where name_sv = "17-19°C" sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

name_sv ✖

  • 17-19°C · 1,161 ✖
id ▲ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
13245 39881 swimming_water_temperature 2020-08-05T13:19:25.330341+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13232 40098 swimming_water_temperature 2020-08-05T10:18:00.027960+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13226 41601 swimming_water_temperature 2020-08-05T10:12:42.524603+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13223 40157 swimming_water_temperature 2020-08-05T10:11:45.061703+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13220 39693 swimming_water_temperature 2020-08-05T10:05:55.056717+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13217 40386 swimming_water_temperature 2020-08-05T10:02:20.066423+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13215 41791 swimming_water_temperature 2020-08-05T10:02:08.954331+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13210 39815 swimming_water_temperature 2020-08-05T09:57:23.537890+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13165 39693 swimming_water_temperature 2020-08-04T13:48:25.589338+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13161 39583 swimming_water_temperature 2020-08-04T12:13:26.449916+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13156 40098 swimming_water_temperature 2020-08-04T11:52:09.246248+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13132 40386 swimming_water_temperature 2020-08-04T10:03:55.629503+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13121 41791 swimming_water_temperature 2020-08-04T09:50:43.409077+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13119 40157 swimming_water_temperature 2020-08-04T09:45:14.607963+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13090 39693 swimming_water_temperature 2020-08-03T18:48:30.765649+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13086 40802 swimming_water_temperature 2020-08-03T14:49:06.573854+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13079 39583 swimming_water_temperature 2020-08-03T13:18:28.377672+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13076 40677 swimming_water_temperature 2020-08-03T12:50:15.872674+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13073 40356 swimming_water_temperature 2020-08-03T12:49:14.783292+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13071 40993 swimming_water_temperature 2020-08-03T12:48:51.952892+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13069 40798 swimming_water_temperature 2020-08-03T12:48:40.389700+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13063 40020 swimming_water_temperature 2020-08-03T12:47:55.601788+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13059 41031 swimming_water_temperature 2020-08-03T12:46:34.110675+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13057 39910 swimming_water_temperature 2020-08-03T12:46:23.978795+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13055 41907 swimming_water_temperature 2020-08-03T12:46:15.142716+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13050 40157 swimming_water_temperature 2020-08-03T11:16:22.209979+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13047 39815 swimming_water_temperature 2020-08-03T11:01:17.890695+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13041 39693 swimming_water_temperature 2020-08-03T10:23:33.703610+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13035 40098 swimming_water_temperature 2020-08-03T10:11:07.453879+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13026 40386 swimming_water_temperature 2020-08-03T09:54:28.160354+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
13019 41791 swimming_water_temperature 2020-08-03T09:51:24.867182+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12997 52959 swimming_water_temperature 2020-08-02T18:03:19.815329+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12991 39583 swimming_water_temperature 2020-08-02T17:50:23.298476+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12989 40802 swimming_water_temperature 2020-08-02T14:41:48.158397+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12988 39693 swimming_water_temperature 2020-08-02T14:11:20.334719+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12985 39583 swimming_water_temperature 2020-08-02T13:56:57.436376+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12981 52959 swimming_water_temperature 2020-08-02T13:46:47.826678+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12967 40098 swimming_water_temperature 2020-08-02T10:53:08.823469+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12965 39815 swimming_water_temperature 2020-08-02T10:47:46.201367+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12960 40142 swimming_water_temperature 2020-08-02T10:29:39.991069+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12958 39693 swimming_water_temperature 2020-08-02T10:24:45.498707+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12946 40157 swimming_water_temperature 2020-08-02T10:09:31.665367+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12935 39583 swimming_water_temperature 2020-08-02T10:03:18.239014+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12932 40386 swimming_water_temperature 2020-08-02T09:59:39.226737+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12928 41791 swimming_water_temperature 2020-08-02T09:51:08.162493+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12897 39583 swimming_water_temperature 2020-08-01T17:47:39.314871+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12894 39815 swimming_water_temperature 2020-08-01T14:08:26.758630+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12892 39693 swimming_water_temperature 2020-08-01T14:04:39.492399+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12885 39583 swimming_water_temperature 2020-08-01T13:57:26.222483+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12869 39815 swimming_water_temperature 2020-08-01T10:14:41.174644+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12862 39583 swimming_water_temperature 2020-08-01T10:11:58.114829+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12858 40157 swimming_water_temperature 2020-08-01T10:09:25.601466+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12849 40386 swimming_water_temperature 2020-08-01T10:04:23.272469+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12845 39693 swimming_water_temperature 2020-08-01T10:02:50.499633+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12841 39693 swimming_water_temperature 2020-07-31T18:41:31.419130+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12837 39815 swimming_water_temperature 2020-07-31T18:01:19.650946+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12829 40098 swimming_water_temperature 2020-07-31T14:08:33.716240+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12827 39815 swimming_water_temperature 2020-07-31T14:01:49.629829+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12824 39693 swimming_water_temperature 2020-07-31T13:58:59.823574+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12820 39583 swimming_water_temperature 2020-07-31T13:42:29.268524+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12818 40993 swimming_water_temperature 2020-07-31T13:42:05.548935+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12813 39693 swimming_water_temperature 2020-07-31T11:49:25.949492+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12805 40559 swimming_water_temperature 2020-07-31T10:41:53.758803+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12799 40157 swimming_water_temperature 2020-07-31T10:11:40.409699+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12798 40386 swimming_water_temperature 2020-07-31T10:06:45.209345+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12752 39693 swimming_water_temperature 2020-07-30T19:30:51.791076+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12746 39322 swimming_water_temperature 2020-07-30T18:26:55.437738+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12742 39815 swimming_water_temperature 2020-07-30T13:59:09.916023+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12740 39583 swimming_water_temperature 2020-07-30T13:59:03.795232+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12739 39815 swimming_water_temperature 2020-07-30T13:25:44.676069+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12731 40386 swimming_water_temperature 2020-07-30T10:25:01.943381+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12720 52959 swimming_water_temperature 2020-07-30T10:07:21.455898+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12715 39693 swimming_water_temperature 2020-07-30T10:06:29.879346+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12713 40157 swimming_water_temperature 2020-07-30T09:55:18.352123+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12711 40559 swimming_water_temperature 2020-07-30T09:53:16.423277+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12689 39693 swimming_water_temperature 2020-07-29T18:51:17.001336+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12684 39583 swimming_water_temperature 2020-07-29T17:57:29.452355+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12675 39583 swimming_water_temperature 2020-07-29T14:02:59.921316+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12673 39693 swimming_water_temperature 2020-07-29T13:58:22.876275+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12662 40157 swimming_water_temperature 2020-07-29T10:45:34.703807+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12661 40559 swimming_water_temperature 2020-07-29T10:36:19.819951+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12648 39583 swimming_water_temperature 2020-07-29T10:16:51.208750+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12646 39693 swimming_water_temperature 2020-07-29T10:08:48.737789+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12609 39693 swimming_water_temperature 2020-07-29T08:27:08.154202+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12544 40142 swimming_water_temperature 2020-07-28T09:58:21.444495+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12518 39815 swimming_water_temperature 2020-07-27T17:58:30.818205+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12494 53461 swimming_water_temperature 2020-07-27T10:59:36.720800+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12490 41601 swimming_water_temperature 2020-07-27T10:48:00.609727+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12488 39823 swimming_water_temperature 2020-07-27T10:37:18.133892+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12485 39693 swimming_water_temperature 2020-07-27T10:35:46.227844+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12482 40098 swimming_water_temperature 2020-07-27T10:29:05.812191+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12472 39412 swimming_water_temperature 2020-07-27T10:10:47.090941+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12462 40386 swimming_water_temperature 2020-07-27T10:03:01.135781+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12459 40142 swimming_water_temperature 2020-07-27T10:02:36.301317+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12457 41791 swimming_water_temperature 2020-07-27T09:56:41.847030+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12455 39322 swimming_water_temperature 2020-07-27T09:55:58.699622+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12450 39815 swimming_water_temperature 2020-07-27T09:46:34.236746+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12448 39875 swimming_water_temperature 2020-07-27T09:38:36.661788+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12446 39713 swimming_water_temperature 2020-07-27T09:38:07.827219+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
12444 39875 swimming_water_temperature 2020-07-27T09:07:58.404651+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
);