observation
4,968 rows where quality = "unknown"
This data as json, CSV (advanced)
name_sv ✖
- 17-19°C 1,236
- 19-21°C 1,224
- 15-17°C 790
- 21-23°C 736
- under 15°C 482
- Iståndsatt 220
- över 23°C 180
id ▼ | unit | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
277 | 40950 | swimming_water_temperature | 2019-06-08T10:42:23.679616+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
279 | 40950 | swimming_water_temperature | 2019-06-08T10:42:31.568387+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
280 | 40950 | swimming_water_temperature | 2019-06-08T10:42:39.967382+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
282 | 40142 | swimming_water_temperature | 2019-06-08T10:56:28.697399+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
285 | 39568 | swimming_water_temperature | 2019-06-08T11:04:03.917676+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
287 | 39568 | swimming_water_temperature | 2019-06-08T11:04:17.424698+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
288 | 40950 | swimming_water_temperature | 2019-06-08T13:50:00.248514+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
289 | 39693 | swimming_water_temperature | 2019-06-08T14:07:46.413233+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
293 | 39815 | swimming_water_temperature | 2019-06-08T14:37:24.368764+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
296 | 39267 | swimming_water_temperature | 2019-06-08T17:01:07.633245+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
298 | 39815 | swimming_water_temperature | 2019-06-08T17:52:09.671494+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
301 | 39267 | swimming_water_temperature | 2019-06-08T17:58:54.777603+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
303 | 39693 | swimming_water_temperature | 2019-06-08T17:59:20.966316+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
310 | 40921 | swimming_water_temperature | 2019-06-09T08:58:41.314672+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
312 | 41326 | swimming_water_temperature | 2019-06-09T08:59:01.215687+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
314 | 40020 | swimming_water_temperature | 2019-06-09T08:59:13.060529+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
316 | 40677 | swimming_water_temperature | 2019-06-09T08:59:50.077804+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
318 | 41907 | swimming_water_temperature | 2019-06-09T09:00:59.552292+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
320 | 39910 | swimming_water_temperature | 2019-06-09T09:01:09.742957+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
322 | 40798 | swimming_water_temperature | 2019-06-09T09:01:21.102140+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
324 | 41791 | swimming_water_temperature | 2019-06-09T09:56:10.160415+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
326 | 41601 | swimming_water_temperature | 2019-06-09T10:04:55.527909+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
328 | 39693 | swimming_water_temperature | 2019-06-09T10:07:57.806433+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
331 | 39815 | swimming_water_temperature | 2019-06-09T10:13:45.481338+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
334 | 40559 | swimming_water_temperature | 2019-06-09T10:15:07.789629+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
336 | 39322 | swimming_water_temperature | 2019-06-09T10:15:16.605748+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
339 | 39267 | swimming_water_temperature | 2019-06-09T10:21:42.793020+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
341 | 40950 | swimming_water_temperature | 2019-06-09T10:22:13.251403+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
343 | 40157 | swimming_water_temperature | 2019-06-09T10:23:07.028385+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
345 | 40142 | swimming_water_temperature | 2019-06-09T10:31:49.644740+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
348 | 40258 | swimming_water_temperature | 2019-06-09T10:45:11.049642+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
352 | 40150 | swimming_water_temperature | 2019-06-09T12:28:43.832936+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
354 | 40098 | swimming_water_temperature | 2019-06-09T12:28:44.344657+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
356 | 39815 | swimming_water_temperature | 2019-06-09T13:56:38.214778+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
366 | 39322 | swimming_water_temperature | 2019-06-09T14:07:43.671307+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
368 | 39693 | swimming_water_temperature | 2019-06-09T14:14:24.082178+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
371 | 39693 | swimming_water_temperature | 2019-06-09T17:53:47.088974+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
374 | 39267 | swimming_water_temperature | 2019-06-09T17:54:11.286114+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
376 | 39815 | swimming_water_temperature | 2019-06-09T18:17:47.234884+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
377 | 39815 | swimming_water_temperature | 2019-06-09T18:17:50.236158+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
381 | 39322 | swimming_water_temperature | 2019-06-09T18:44:40.198426+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
382 | 39693 | swimming_water_temperature | 2019-06-10T08:15:53.628150+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
385 | 39815 | swimming_water_temperature | 2019-06-10T10:00:34.828200+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
389 | 41791 | swimming_water_temperature | 2019-06-10T10:01:18.592635+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
391 | 39322 | swimming_water_temperature | 2019-06-10T10:01:21.612696+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
393 | 40098 | swimming_water_temperature | 2019-06-10T10:07:48.757221+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
395 | 41601 | swimming_water_temperature | 2019-06-10T10:13:27.071351+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
397 | 40559 | swimming_water_temperature | 2019-06-10T10:18:09.001672+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
400 | 40950 | swimming_water_temperature | 2019-06-10T10:29:40.224791+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
402 | 39267 | swimming_water_temperature | 2019-06-10T10:34:16.433547+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
403 | 40150 | swimming_water_temperature | 2019-06-10T10:37:08.378059+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
405 | 41960 | swimming_water_temperature | 2019-06-10T10:57:42.684782+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
408 | 39322 | swimming_water_temperature | 2019-06-10T13:40:51.100444+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
410 | 39322 | swimming_water_temperature | 2019-06-10T13:45:12.831410+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
413 | 39815 | swimming_water_temperature | 2019-06-10T13:46:34.972562+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
414 | 39267 | swimming_water_temperature | 2019-06-10T13:56:59.031717+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
416 | 39693 | swimming_water_temperature | 2019-06-10T14:11:28.424217+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
418 | 40142 | swimming_water_temperature | 2019-06-10T14:52:12.889585+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
421 | 40157 | swimming_water_temperature | 2019-06-10T14:54:25.564905+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
423 | 40258 | swimming_water_temperature | 2019-06-10T15:03:59.731489+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
424 | 39322 | swimming_water_temperature | 2019-06-10T17:50:52.926026+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
426 | 39693 | swimming_water_temperature | 2019-06-10T18:30:40.103809+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
429 | 41031 | swimming_water_temperature | 2019-06-11T07:35:39.937460+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
431 | 41326 | swimming_water_temperature | 2019-06-11T07:35:54.816735+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
433 | 41907 | swimming_water_temperature | 2019-06-11T07:36:03.716690+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
435 | 40921 | swimming_water_temperature | 2019-06-11T07:36:19.863504+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
437 | 40798 | swimming_water_temperature | 2019-06-11T07:36:30.314633+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
438 | 40798 | swimming_water_temperature | 2019-06-11T07:36:37.529518+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
440 | 40677 | swimming_water_temperature | 2019-06-11T07:36:52.756253+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
442 | 40020 | swimming_water_temperature | 2019-06-11T07:36:59.454932+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
444 | 39910 | swimming_water_temperature | 2019-06-11T07:37:06.926794+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
446 | 40993 | swimming_water_temperature | 2019-06-11T07:37:44.991784+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
448 | 40356 | swimming_water_temperature | 2019-06-11T07:38:15.879350+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
450 | 40386 | swimming_water_temperature | 2019-06-11T07:38:45.000109+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
451 | 40386 | swimming_water_temperature | 2019-06-11T07:38:49.711036+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
453 | 39693 | swimming_water_temperature | 2019-06-11T09:16:02.376158+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
454 | 39693 | swimming_water_temperature | 2019-06-11T09:16:09.387097+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
460 | 39322 | swimming_water_temperature | 2019-06-11T09:50:53.764841+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
462 | 39815 | swimming_water_temperature | 2019-06-11T09:52:59.453634+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
465 | 40950 | swimming_water_temperature | 2019-06-11T10:03:10.490044+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
467 | 41791 | swimming_water_temperature | 2019-06-11T10:05:11.341226+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
469 | 40802 | swimming_water_temperature | 2019-06-11T10:05:21.394543+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
471 | 40142 | swimming_water_temperature | 2019-06-11T10:06:22.076433+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
477 | 39267 | swimming_water_temperature | 2019-06-11T10:10:30.491830+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
478 | 40157 | swimming_water_temperature | 2019-06-11T10:10:55.622586+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
480 | 40559 | swimming_water_temperature | 2019-06-11T10:14:49.301140+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
483 | 39693 | swimming_water_temperature | 2019-06-11T10:21:09.542309+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
486 | 41960 | swimming_water_temperature | 2019-06-11T10:26:20.184265+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
488 | 40150 | swimming_water_temperature | 2019-06-11T10:41:02.674258+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
489 | 41601 | swimming_water_temperature | 2019-06-11T10:53:12.365926+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
549 | 41791 | swimming_water_temperature | 2019-06-11T12:44:05.760815+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
553 | 39693 | swimming_water_temperature | 2019-06-11T13:43:38.386127+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
554 | 39322 | swimming_water_temperature | 2019-06-11T13:45:44.348861+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
556 | 39815 | swimming_water_temperature | 2019-06-11T13:54:53.119475+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
560 | 39267 | swimming_water_temperature | 2019-06-11T14:00:08.545368+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
561 | 40258 | swimming_water_temperature | 2019-06-11T16:53:54.604428+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
565 | 39322 | swimming_water_temperature | 2019-06-11T17:52:45.689952+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
567 | 39267 | swimming_water_temperature | 2019-06-11T17:56:58.976591+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
569 | 39815 | swimming_water_temperature | 2019-06-11T18:08:16.960792+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
572 | 39322 | swimming_water_temperature | 2019-06-12T10:04:11.081301+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | 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 );