observation

497 rows where name_sv = "under 15°C" sorted by unit

✎ View and edit SQL

This data as json, CSV (advanced)

primary ✖

  • 0 397

name_sv ✖

  • under 15°C · 397 ✖
id unit ▼ property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
2912 39583 swimming_water_temperature 2019-07-13T12:09:20.642302+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8451 39583 swimming_water_temperature 2020-06-02T10:26:55.404461+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  
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  
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  
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  
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  
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  
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  
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  
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  
2572 39693 swimming_water_temperature 2019-07-08T18:19:59.620716+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2576 39693 swimming_water_temperature 2019-07-09T08:14:03.462115+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2617 39693 swimming_water_temperature 2019-07-09T13:56:27.141119+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2624 39693 swimming_water_temperature 2019-07-09T17:50:42.903860+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2656 39693 swimming_water_temperature 2019-07-10T09:59:06.931562+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2819 39693 swimming_water_temperature 2019-07-12T08:50:41.844881+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2859 39693 swimming_water_temperature 2019-07-12T14:05:52.051780+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
3115 39693 swimming_water_temperature 2019-07-16T08:11:44.020653+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8428 39693 swimming_water_temperature 2020-06-02T09:48:42.296314+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8511 39693 swimming_water_temperature 2020-06-03T09:20:48.500114+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8609 39693 swimming_water_temperature 2020-06-04T10:28:07.990941+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8653 39693 swimming_water_temperature 2020-06-05T09:55:21.464997+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8692 39693 swimming_water_temperature 2020-06-05T13:59:06.348321+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8709 39693 swimming_water_temperature 2020-06-06T09:29:04.143822+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8774 39693 swimming_water_temperature 2020-06-07T09:44:08.744730+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8905 39693 swimming_water_temperature 2020-06-09T08:27:46.582297+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8936 39693 swimming_water_temperature 2020-06-09T12:57:02.789630+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8975 39693 swimming_water_temperature 2020-06-10T09:53:51.612783+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  
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  
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  
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  
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  
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  
2614 39815 swimming_water_temperature 2019-07-09T13:56:06.378680+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2690 39815 swimming_water_temperature 2019-07-10T10:40:21.877477+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2731 39815 swimming_water_temperature 2019-07-10T18:09:41.311714+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2818 39815 swimming_water_temperature 2019-07-11T19:24:10.143058+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2831 39815 swimming_water_temperature 2019-07-12T10:06:38.217670+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8405 39815 swimming_water_temperature 2020-06-01T12:47:15.173935+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8417 39815 swimming_water_temperature 2020-06-01T15:26:53.680375+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8421 39815 swimming_water_temperature 2020-06-02T08:18:11.802238+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8595 39815 swimming_water_temperature 2020-06-04T10:02:32.927331+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8910 39815 swimming_water_temperature 2020-06-09T09:55:58.789091+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1686 39910 swimming_water_temperature 2019-06-27T14:37:47.284884+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  
2639 39910 swimming_water_temperature 2019-07-10T08:10:44.659492+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8366 39910 swimming_water_temperature 2020-06-01T11:04:22.616452+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8469 39910 swimming_water_temperature 2020-06-02T14:00:24.928367+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8756 39910 swimming_water_temperature 2020-06-06T13:43:12.599708+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  
2647 40020 swimming_water_temperature 2019-07-10T08:12:00.001153+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8473 40020 swimming_water_temperature 2020-06-02T14:00:39.943729+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8748 40020 swimming_water_temperature 2020-06-06T13:41:58.578383+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
73 40098 swimming_water_temperature 2019-06-04T17:51:05.596938+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
595 40098 swimming_water_temperature 2019-06-12T10:52:11.718054+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
659 40098 swimming_water_temperature 2019-06-13T10:13:04.081492+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1465 40098 swimming_water_temperature 2019-06-25T10:05:06.757173+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1742 40098 swimming_water_temperature 2019-06-28T10:33:16.026183+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1820 40098 swimming_water_temperature 2019-06-29T10:40:57.376395+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1895 40098 swimming_water_temperature 2019-06-30T11:06:36.999675+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  
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  
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  
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  
2607 40098 swimming_water_temperature 2019-07-09T11:03:45.236950+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2693 40098 swimming_water_temperature 2019-07-10T12:37:30.273582+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2770 40098 swimming_water_temperature 2019-07-11T10:07:30.366600+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2847 40098 swimming_water_temperature 2019-07-12T10:32:16.313614+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
3040 40098 swimming_water_temperature 2019-07-15T10:04:38.761839+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8431 40098 swimming_water_temperature 2020-06-02T09:56:42.584261+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8688 40098 swimming_water_temperature 2020-06-05T13:35:30.422787+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8833 40098 swimming_water_temperature 2020-06-07T17:53:48.035442+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
58 40142 swimming_water_temperature 2019-06-04T17:39:46.130880+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
660 40142 swimming_water_temperature 2019-06-13T10:26:03.251281+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
726 40142 swimming_water_temperature 2019-06-14T10:14:59.703173+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
777 40142 swimming_water_temperature 2019-06-15T12:20:13.303202+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1719 40142 swimming_water_temperature 2019-06-28T09:59:01.316791+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1802 40142 swimming_water_temperature 2019-06-29T10:14:00.117733+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1898 40142 swimming_water_temperature 2019-06-30T12:12:25.712341+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
1899 40142 swimming_water_temperature 2019-06-30T12:12:39.210766+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  
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  
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  
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  
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  
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  
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  
2583 40142 swimming_water_temperature 2019-07-09T10:07:35.718447+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2590 40142 swimming_water_temperature 2019-07-09T10:15:54.883564+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2684 40142 swimming_water_temperature 2019-07-10T10:32:45.961978+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2775 40142 swimming_water_temperature 2019-07-11T10:09:20.986414+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2835 40142 swimming_water_temperature 2019-07-12T10:07:44.786645+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
2981 40142 swimming_water_temperature 2019-07-14T10:29:23.970599+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
3051 40142 swimming_water_temperature 2019-07-15T10:16:30.236361+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8388 40142 swimming_water_temperature 2020-06-01T11:12:57.238957+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
);