observation

497 rows where name_en = "below 15°C"

✎ View and edit SQL

This data as json, CSV (advanced)

name_en ✖

  • below 15°C · 397 ✖
id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
2044 39568 swimming_water_temperature 2019-07-01T18:40:40.680455+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2046 40258 swimming_water_temperature 2019-07-02T09:56:27.007744+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2080 40150 swimming_water_temperature 2019-07-02T10:20:32.782000+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2082 40142 swimming_water_temperature 2019-07-02T10:47:21.357968+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2088 40559 swimming_water_temperature 2019-07-02T13:47:41.104848+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2090 39693 swimming_water_temperature 2019-07-03T08:15:32.021411+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2101 39693 swimming_water_temperature 2019-07-03T10:03:36.548464+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2103 40559 swimming_water_temperature 2019-07-03T10:04:30.892129+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2108 40950 swimming_water_temperature 2019-07-03T10:05:05.044101+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2116 40150 swimming_water_temperature 2019-07-03T10:36:27.711945+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2126 39568 swimming_water_temperature 2019-07-03T11:09:03.948749+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2127 40142 swimming_water_temperature 2019-07-03T12:03:51.260273+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2131 52958 swimming_water_temperature 2019-07-03T12:24:04.425214+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2146 39568 swimming_water_temperature 2019-07-03T17:20:11.125564+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2150 52959 swimming_water_temperature 2019-07-03T17:56:53.836667+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2162 39815 swimming_water_temperature 2019-07-04T08:11:02.733645+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2165 39693 swimming_water_temperature 2019-07-04T09:57:21.466248+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2172 40950 swimming_water_temperature 2019-07-04T10:01:02.366982+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2174 41791 swimming_water_temperature 2019-07-04T10:05:09.429330+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2186 40559 swimming_water_temperature 2019-07-04T10:08:30.796185+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2191 40150 swimming_water_temperature 2019-07-04T10:19:36.558811+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2193 52959 swimming_water_temperature 2019-07-04T10:29:58.611966+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2195 39527 swimming_water_temperature 2019-07-04T11:46:35.178176+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2197 40142 swimming_water_temperature 2019-07-04T11:56:34.254960+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2198 39815 swimming_water_temperature 2019-07-04T13:52:15.931766+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2200 41907 swimming_water_temperature 2019-07-04T13:52:44.910957+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2202 40798 swimming_water_temperature 2019-07-04T13:52:57.110176+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2206 39910 swimming_water_temperature 2019-07-04T13:54:45.821105+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2214 41031 swimming_water_temperature 2019-07-04T13:55:20.188903+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2218 40098 swimming_water_temperature 2019-07-04T13:56:04.550062+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2220 40258 swimming_water_temperature 2019-07-04T13:56:20.321468+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2222 39527 swimming_water_temperature 2019-07-04T13:56:31.650386+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2225 41326 swimming_water_temperature 2019-07-04T14:04:11.853899+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2227 40921 swimming_water_temperature 2019-07-04T14:04:24.945072+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2229 40020 swimming_water_temperature 2019-07-04T14:04:35.502366+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2231 40677 swimming_water_temperature 2019-07-04T14:04:41.858900+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2248 39815 swimming_water_temperature 2019-07-04T17:50:49.129425+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2255 40802 swimming_water_temperature 2019-07-05T08:31:56.156699+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2273 40559 swimming_water_temperature 2019-07-05T09:55:59.059309+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2288 39693 swimming_water_temperature 2019-07-05T10:08:37.249185+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2293 41791 swimming_water_temperature 2019-07-05T10:11:32.948155+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2299 40258 swimming_water_temperature 2019-07-05T10:41:52.593124+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2309 39568 swimming_water_temperature 2019-07-05T11:55:25.991460+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2311 40142 swimming_water_temperature 2019-07-05T12:05:17.567019+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2314 40142 swimming_water_temperature 2019-07-05T12:05:39.262366+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2315 40142 swimming_water_temperature 2019-07-05T12:05:41.182024+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2319 39693 swimming_water_temperature 2019-07-05T13:44:49.257827+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2328 39568 swimming_water_temperature 2019-07-05T14:38:19.633616+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2330 52959 swimming_water_temperature 2019-07-05T15:06:57.238688+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2332 52959 swimming_water_temperature 2019-07-05T17:46:37.914861+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2339 39568 swimming_water_temperature 2019-07-05T18:00:09.544582+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2347 39527 swimming_water_temperature 2019-07-05T19:59:41.774650+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2349 39693 swimming_water_temperature 2019-07-06T09:32:52.158449+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2356 41791 swimming_water_temperature 2019-07-06T10:01:56.593543+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2358 52959 swimming_water_temperature 2019-07-06T10:08:55.909974+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2362 40142 swimming_water_temperature 2019-07-06T10:12:53.652098+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2368 40802 swimming_water_temperature 2019-07-06T10:15:10.093590+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2370 39583 swimming_water_temperature 2019-07-06T10:16:15.781751+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2378 39815 swimming_water_temperature 2019-07-06T10:19:32.879921+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2380 40150 swimming_water_temperature 2019-07-06T10:20:04.850294+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2383 39527 swimming_water_temperature 2019-07-06T10:39:17.747107+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2385 40950 swimming_water_temperature 2019-07-06T10:55:28.076072+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2387 40098 swimming_water_temperature 2019-07-06T11:12:30.079119+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2390 40559 swimming_water_temperature 2019-07-06T11:58:36.050112+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2392 40258 swimming_water_temperature 2019-07-06T12:51:08.180292+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2402 39583 swimming_water_temperature 2019-07-06T14:16:08.022698+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2404 52959 swimming_water_temperature 2019-07-06T14:17:13.365995+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2408 39583 swimming_water_temperature 2019-07-06T17:45:37.924256+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2413 52959 swimming_water_temperature 2019-07-06T17:49:07.395106+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2417 39693 swimming_water_temperature 2019-07-06T18:00:41.944341+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2420 39815 swimming_water_temperature 2019-07-06T18:45:55.064454+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2423 39693 swimming_water_temperature 2019-07-07T09:43:08.261264+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2428 41791 swimming_water_temperature 2019-07-07T10:02:21.516835+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2439 39815 swimming_water_temperature 2019-07-07T10:13:01.873699+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2440 40150 swimming_water_temperature 2019-07-07T10:13:03.023726+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2444 40950 swimming_water_temperature 2019-07-07T10:17:23.855815+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2446 52959 swimming_water_temperature 2019-07-07T10:18:09.744871+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2449 40802 swimming_water_temperature 2019-07-07T10:21:12.833049+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2451 39527 swimming_water_temperature 2019-07-07T10:31:20.885625+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2453 40098 swimming_water_temperature 2019-07-07T10:35:30.103026+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2455 40258 swimming_water_temperature 2019-07-07T10:38:04.016363+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2458 40142 swimming_water_temperature 2019-07-07T10:50:58.951569+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2463 39568 swimming_water_temperature 2019-07-07T10:54:43.021478+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2467 40559 swimming_water_temperature 2019-07-07T11:17:38.746752+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2478 39568 swimming_water_temperature 2019-07-07T14:04:46.830475+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2500 39693 swimming_water_temperature 2019-07-08T09:50:36.010730+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2504 40142 swimming_water_temperature 2019-07-08T09:59:19.838618+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2514 40950 swimming_water_temperature 2019-07-08T10:05:49.949070+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2521 39583 swimming_water_temperature 2019-07-08T10:10:57.318786+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2525 39527 swimming_water_temperature 2019-07-08T10:17:33.486203+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2529 40098 swimming_water_temperature 2019-07-08T10:37:42.622366+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2531 40802 swimming_water_temperature 2019-07-08T10:39:02.372857+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2533 40150 swimming_water_temperature 2019-07-08T10:40:14.454905+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2537 40258 swimming_water_temperature 2019-07-08T11:39:00.499204+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2540 40559 swimming_water_temperature 2019-07-08T12:38:33.904302+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2542 39568 swimming_water_temperature 2019-07-08T13:52:17.203341+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2546 39527 swimming_water_temperature 2019-07-08T13:59:12.331068+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2552 52959 swimming_water_temperature 2019-07-08T14:05:44.060213+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2558 41791 swimming_water_temperature 2019-07-08T15:12:03.436845+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2560 39693 swimming_water_temperature 2019-07-08T15:44:52.306760+0300     alle 15°C   under 15°C 0 below 15°C 0-15 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
);