observation
4,968 rows where primary = 0 sorted by expiration_time
This data as json, CSV (advanced)
Suggested facets: name_fi, name_sv, value
name_en ✖
- 17-19°C 1,261
- 19-21°C 1,246
- 15-17°C 818
- 21-23°C 746
- below 15°C 497
- Maintenance finished 220
- above 23°C 180
property ✖
id | unit | property | time | expiration_time ▼ | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
46 | 40802 | swimming_water_temperature | 2019-06-03T14:59:26.683795+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
47 | 40157 | swimming_water_temperature | 2019-06-03T14:59:26.889067+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
48 | 40559 | swimming_water_temperature | 2019-06-03T14:59:27.096032+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
50 | 40258 | swimming_water_temperature | 2019-06-03T14:59:27.503232+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
54 | 41791 | swimming_water_temperature | 2019-06-04T17:02:44.678313+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
55 | 41791 | swimming_water_temperature | 2019-06-04T17:02:48.561805+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
57 | 41791 | swimming_water_temperature | 2019-06-04T17:03:08.170718+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 | ||||
63 | 41791 | swimming_water_temperature | 2019-06-04T17:51:03.957383+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
65 | 40386 | swimming_water_temperature | 2019-06-04T17:51:04.266278+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
68 | 40150 | swimming_water_temperature | 2019-06-04T17:51:04.763516+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
70 | 40157 | swimming_water_temperature | 2019-06-04T17:51:05.085267+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | 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 | ||||
75 | 40950 | swimming_water_temperature | 2019-06-04T17:51:05.913205+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
76 | 41601 | swimming_water_temperature | 2019-06-04T17:51:06.065823+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
79 | 41960 | swimming_water_temperature | 2019-06-04T17:51:06.514230+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
85 | 40559 | swimming_water_temperature | 2019-06-04T17:51:07.434079+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
87 | 40802 | swimming_water_temperature | 2019-06-04T17:51:07.737749+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
88 | 41791 | swimming_water_temperature | 2019-06-05T10:02:48.653427+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
91 | 41791 | swimming_water_temperature | 2019-06-05T10:03:11.627900+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
93 | 41791 | swimming_water_temperature | 2019-06-05T10:03:29.593551+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
94 | 41791 | swimming_water_temperature | 2019-06-05T10:05:42.075508+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
95 | 41791 | swimming_water_temperature | 2019-06-05T10:05:51.578180+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
96 | 41791 | swimming_water_temperature | 2019-06-05T10:06:52.817594+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
99 | 41791 | swimming_water_temperature | 2019-06-05T10:07:07.929682+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
100 | 41791 | swimming_water_temperature | 2019-06-05T10:10:24.986235+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
101 | 41791 | swimming_water_temperature | 2019-06-05T10:12:19.549239+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
102 | 41791 | swimming_water_temperature | 2019-06-05T10:22:24.463276+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
103 | 41960 | swimming_water_temperature | 2019-06-05T10:38:12.282812+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
105 | 40098 | swimming_water_temperature | 2019-06-05T10:51:42.918514+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
107 | 40150 | swimming_water_temperature | 2019-06-05T10:51:43.333717+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
114 | 41791 | swimming_water_temperature | 2019-06-05T10:58:48.364030+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
115 | 40157 | swimming_water_temperature | 2019-06-05T11:00:53.385560+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
117 | 41791 | swimming_water_temperature | 2019-06-05T11:10:49.786995+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
118 | 41791 | swimming_water_temperature | 2019-06-05T11:12:13.132939+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
120 | 41791 | swimming_water_temperature | 2019-06-05T11:12:34.375472+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
122 | 40559 | swimming_water_temperature | 2019-06-05T15:36:12.236080+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
127 | 40142 | swimming_water_temperature | 2019-06-05T18:40:57.305007+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
128 | 41960 | swimming_water_temperature | 2019-06-06T10:01:22.538355+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
130 | 39693 | swimming_water_temperature | 2019-06-06T10:03:55.102230+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
133 | 40142 | swimming_water_temperature | 2019-06-06T10:18:07.863798+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
135 | 40157 | swimming_water_temperature | 2019-06-06T10:23:15.997900+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
137 | 40559 | swimming_water_temperature | 2019-06-06T10:27:19.376612+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
140 | 40386 | swimming_water_temperature | 2019-06-06T10:43:25.060063+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
142 | 39568 | swimming_water_temperature | 2019-06-06T10:43:25.340222+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
144 | 40150 | swimming_water_temperature | 2019-06-06T10:43:25.600773+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
145 | 40150 | swimming_water_temperature | 2019-06-06T10:43:25.735993+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
146 | 40950 | swimming_water_temperature | 2019-06-06T10:43:25.862374+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
147 | 40950 | swimming_water_temperature | 2019-06-06T10:43:25.994094+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
148 | 40950 | swimming_water_temperature | 2019-06-06T10:43:26.123955+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
149 | 40950 | swimming_water_temperature | 2019-06-06T10:43:26.250756+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
150 | 41601 | swimming_water_temperature | 2019-06-06T11:02:33.045041+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
152 | 41601 | swimming_water_temperature | 2019-06-06T11:07:55.044976+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
153 | 40258 | swimming_water_temperature | 2019-06-06T11:12:03.138542+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
158 | 40386 | swimming_water_temperature | 2019-06-06T11:16:25.589048+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
160 | 40098 | swimming_water_temperature | 2019-06-06T11:16:25.883143+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
162 | 39815 | swimming_water_temperature | 2019-06-06T11:16:26.153952+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
169 | 40993 | swimming_water_temperature | 2019-06-06T12:51:31.517274+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
170 | 40993 | swimming_water_temperature | 2019-06-06T12:51:31.651501+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
173 | 39267 | swimming_water_temperature | 2019-06-06T12:51:32.063938+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
180 | 39267 | swimming_water_temperature | 2019-06-06T14:10:39.608279+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
182 | 40950 | swimming_water_temperature | 2019-06-06T14:10:39.914760+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
184 | 39815 | swimming_water_temperature | 2019-06-06T15:18:31.932506+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
186 | 40386 | swimming_water_temperature | 2019-06-06T15:18:32.220657+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
187 | 39693 | swimming_water_temperature | 2019-06-06T17:51:51.799967+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
189 | 39815 | swimming_water_temperature | 2019-06-06T19:43:24.985518+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
192 | 39815 | swimming_water_temperature | 2019-06-07T08:30:29.052361+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
195 | 39693 | swimming_water_temperature | 2019-06-07T09:40:40.293487+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
197 | 39527 | swimming_water_temperature | 2019-06-07T09:44:25.167317+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
201 | 39815 | swimming_water_temperature | 2019-06-07T09:58:44.666515+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
204 | 40802 | swimming_water_temperature | 2019-06-07T10:02:44.386293+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
206 | 40950 | swimming_water_temperature | 2019-06-07T10:09:54.471137+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
207 | 41601 | swimming_water_temperature | 2019-06-07T10:14:41.514036+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
211 | 41791 | swimming_water_temperature | 2019-06-07T10:24:59.111664+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
212 | 41791 | swimming_water_temperature | 2019-06-07T10:25:44.452775+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
213 | 41791 | swimming_water_temperature | 2019-06-07T10:26:07.112503+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
214 | 40150 | swimming_water_temperature | 2019-06-07T10:35:30.790678+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
216 | 40157 | swimming_water_temperature | 2019-06-07T10:35:43.267632+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
218 | 40142 | swimming_water_temperature | 2019-06-07T11:22:11.956190+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
222 | 39322 | swimming_water_temperature | 2019-06-07T11:23:40.887777+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
224 | 39322 | swimming_water_temperature | 2019-06-07T11:35:37.055471+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
226 | 39322 | swimming_water_temperature | 2019-06-07T11:35:37.494252+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
228 | 39322 | swimming_water_temperature | 2019-06-07T11:35:37.963596+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
230 | 40559 | swimming_water_temperature | 2019-06-07T12:33:44.310597+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
232 | 41791 | swimming_water_temperature | 2019-06-07T13:42:22.858744+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
235 | 41791 | swimming_water_temperature | 2019-06-07T13:45:23.030764+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
238 | 39693 | swimming_water_temperature | 2019-06-07T13:53:24.595690+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
240 | 39815 | swimming_water_temperature | 2019-06-07T14:12:33.987424+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
244 | 39322 | swimming_water_temperature | 2019-06-07T15:15:49.773357+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
245 | 39322 | swimming_water_temperature | 2019-06-07T15:17:51.123747+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
247 | 39568 | swimming_water_temperature | 2019-06-07T16:12:54.240114+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
253 | 39583 | swimming_water_temperature | 2019-06-07T16:16:17.022761+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
255 | 39815 | swimming_water_temperature | 2019-06-07T18:22:39.344024+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
258 | 39322 | swimming_water_temperature | 2019-06-07T19:42:40.358960+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
265 | 39693 | swimming_water_temperature | 2019-06-08T08:17:40.785403+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
266 | 41791 | swimming_water_temperature | 2019-06-08T10:05:04.461932+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
268 | 40559 | swimming_water_temperature | 2019-06-08T10:06:22.810174+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
271 | 40157 | swimming_water_temperature | 2019-06-08T10:08:25.066166+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
273 | 39815 | swimming_water_temperature | 2019-06-08T10:19:17.389316+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
275 | 41601 | swimming_water_temperature | 2019-06-08T10:39:32.888284+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );