observation

180 rows where name_en = "above 23°C"

✎ View and edit SQL

This data as json, CSV (advanced)

name_en ✖

  • above 23°C · 80 ✖
id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
10170 50549 swimming_water_temperature 2020-06-25T15:52:31.200307+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10173 39583 swimming_water_temperature 2020-06-25T17:41:09.153987+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10177 39815 swimming_water_temperature 2020-06-25T17:47:30.990529+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10179 39322 swimming_water_temperature 2020-06-25T18:01:40.262239+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10182 39693 swimming_water_temperature 2020-06-25T18:14:31.169484+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10196 40157 swimming_water_temperature 2020-06-26T09:53:55.214804+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10200 40142 swimming_water_temperature 2020-06-26T09:56:48.346620+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10203 41791 swimming_water_temperature 2020-06-26T10:03:48.535123+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10208 39815 swimming_water_temperature 2020-06-26T10:05:31.710623+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10211 40386 swimming_water_temperature 2020-06-26T10:10:18.485002+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10217 39583 swimming_water_temperature 2020-06-26T10:21:42.346187+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10220 39693 swimming_water_temperature 2020-06-26T10:23:44.683113+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10223 39322 swimming_water_temperature 2020-06-26T10:24:09.487236+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10230 41601 swimming_water_temperature 2020-06-26T10:45:43.032483+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10239 52959 swimming_water_temperature 2020-06-26T12:16:47.575496+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10252 40020 swimming_water_temperature 2020-06-26T13:34:28.554066+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10263 39815 swimming_water_temperature 2020-06-26T13:53:15.779518+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10270 39322 swimming_water_temperature 2020-06-26T14:16:15.957267+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10272 39693 swimming_water_temperature 2020-06-26T14:21:48.433310+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10274 39583 swimming_water_temperature 2020-06-26T14:25:47.452954+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10277 39815 swimming_water_temperature 2020-06-26T17:33:58.755629+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10279 39583 swimming_water_temperature 2020-06-26T17:47:05.296119+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10282 39693 swimming_water_temperature 2020-06-26T18:02:43.768481+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10302 41791 swimming_water_temperature 2020-06-27T09:40:46.163841+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10304 40559 swimming_water_temperature 2020-06-27T09:58:47.210297+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10306 40157 swimming_water_temperature 2020-06-27T10:00:30.762267+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10308 39693 swimming_water_temperature 2020-06-27T10:08:11.278637+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10312 40386 swimming_water_temperature 2020-06-27T10:14:18.411395+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10314 39583 swimming_water_temperature 2020-06-27T10:15:35.353006+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10315 39815 swimming_water_temperature 2020-06-27T10:15:40.965867+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10323 39322 swimming_water_temperature 2020-06-27T10:39:02.328595+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10325 41601 swimming_water_temperature 2020-06-27T10:46:29.040693+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10332 40142 swimming_water_temperature 2020-06-27T11:30:10.225909+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10336 52959 swimming_water_temperature 2020-06-27T11:37:39.656172+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10343 39815 swimming_water_temperature 2020-06-27T13:54:05.459550+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10347 39693 swimming_water_temperature 2020-06-27T13:54:53.618726+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10349 39322 swimming_water_temperature 2020-06-27T14:10:15.808817+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10350 39322 swimming_water_temperature 2020-06-27T14:10:26.078149+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10352 39583 swimming_water_temperature 2020-06-27T14:14:20.446472+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10354 39815 swimming_water_temperature 2020-06-27T17:44:03.018759+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10356 39583 swimming_water_temperature 2020-06-27T17:44:58.754837+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10358 39693 swimming_water_temperature 2020-06-27T18:08:38.876359+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10365 39902 swimming_water_temperature 2020-06-28T08:10:22.365351+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10371 39412 swimming_water_temperature 2020-06-28T09:17:49.501789+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10373 39815 swimming_water_temperature 2020-06-28T09:45:28.542941+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10375 39693 swimming_water_temperature 2020-06-28T09:47:00.711127+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10385 40157 swimming_water_temperature 2020-06-28T10:06:38.523736+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10387 41791 swimming_water_temperature 2020-06-28T10:10:00.933659+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10391 39583 swimming_water_temperature 2020-06-28T10:15:42.177052+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10393 39322 swimming_water_temperature 2020-06-28T10:19:46.641853+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10395 40386 swimming_water_temperature 2020-06-28T10:20:40.121635+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10397 41601 swimming_water_temperature 2020-06-28T10:21:45.738030+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10403 40993 swimming_water_temperature 2020-06-28T10:46:39.854154+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10408 40142 swimming_water_temperature 2020-06-28T11:06:05.513140+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10411 39527 swimming_water_temperature 2020-06-28T12:49:52.473929+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10416 39815 swimming_water_temperature 2020-06-28T13:46:35.002089+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10420 39583 swimming_water_temperature 2020-06-28T14:04:47.285385+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10422 39322 swimming_water_temperature 2020-06-28T14:13:00.933100+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10424 39693 swimming_water_temperature 2020-06-28T14:48:00.687629+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10427 40020 swimming_water_temperature 2020-06-28T16:38:40.241914+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10450 39815 swimming_water_temperature 2020-06-28T17:34:25.641034+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10452 39583 swimming_water_temperature 2020-06-28T17:42:36.153938+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10454 39693 swimming_water_temperature 2020-06-28T18:14:37.195346+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10455 39693 swimming_water_temperature 2020-06-28T18:14:56.991933+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10468 39815 swimming_water_temperature 2020-06-29T09:33:46.664255+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10473 40157 swimming_water_temperature 2020-06-29T09:56:52.252559+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10474 41601 swimming_water_temperature 2020-06-29T10:01:13.601517+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10476 40386 swimming_water_temperature 2020-06-29T10:07:18.208533+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10480 40993 swimming_water_temperature 2020-06-29T10:11:01.952659+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10490 39583 swimming_water_temperature 2020-06-29T10:35:38.730708+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10498 39322 swimming_water_temperature 2020-06-29T11:16:05.524715+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10505 39322 swimming_water_temperature 2020-06-29T14:04:31.971744+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10512 39322 swimming_water_temperature 2020-06-29T17:51:58.962965+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
10531 40386 swimming_water_temperature 2020-06-30T10:07:02.952836+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
11810 39815 swimming_water_temperature 2020-07-18T17:44:37.477328+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
11859 39815 swimming_water_temperature 2020-07-19T18:00:48.913708+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
11861 39322 swimming_water_temperature 2020-07-19T18:09:35.905875+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
12034 39815 swimming_water_temperature 2020-07-21T14:37:14.601685+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
12046 39815 swimming_water_temperature 2020-07-21T17:54:29.112075+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
13529 39815 swimming_water_temperature 2020-08-09T17:51:53.321131+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  

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