4,968 rows where primary = 0 sorted by primary

View and edit SQL

Suggested facets: property, name_fi, name_sv, name_en, value

primary

  • 0 · 4,968
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  

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