observation
4,968 rows where primary = 0 sorted by id descending
This data as json, CSV (advanced)
name_en ✖
- 17-19°C 1,230
- 19-21°C 1,227
- 15-17°C 809
- 21-23°C 738
- below 15°C 496
- Maintenance finished 188
- above 23°C 180
id ▲ | unit | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13723 | 39815 | swimming_water_temperature | 2020-08-13T14:00:51.236478+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13717 | 39583 | swimming_water_temperature | 2020-08-13T12:05:18.215525+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13714 | 39815 | swimming_water_temperature | 2020-08-13T10:36:22.421956+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13712 | 39322 | swimming_water_temperature | 2020-08-13T10:02:57.398810+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13693 | 40157 | swimming_water_temperature | 2020-08-13T08:46:29.418678+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13692 | 40802 | swimming_water_temperature | 2020-08-13T08:46:12.362334+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13691 | 40150 | swimming_water_temperature | 2020-08-13T08:45:59.248379+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13690 | 40950 | swimming_water_temperature | 2020-08-13T08:45:48.437164+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13689 | 40150 | swimming_water_temperature | 2020-08-13T08:45:33.647611+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13687 | 40258 | swimming_water_temperature | 2020-08-13T08:45:01.247218+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13685 | 39568 | swimming_water_temperature | 2020-08-13T08:25:17.526176+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13682 | 39815 | swimming_water_temperature | 2020-08-13T08:19:45.536904+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13681 | 39815 | swimming_water_temperature | 2020-08-12T18:55:01.191676+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13679 | 39322 | swimming_water_temperature | 2020-08-12T18:41:06.969147+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13676 | 39583 | swimming_water_temperature | 2020-08-12T17:47:11.639366+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13673 | 39815 | swimming_water_temperature | 2020-08-12T14:10:12.180913+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13670 | 39815 | swimming_water_temperature | 2020-08-12T14:09:06.160694+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13666 | 39583 | swimming_water_temperature | 2020-08-12T14:07:51.962436+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13663 | 39693 | swimming_water_temperature | 2020-08-12T14:06:20.816129+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13661 | 39693 | swimming_water_temperature | 2020-08-12T14:02:47.519936+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13659 | 39322 | swimming_water_temperature | 2020-08-12T13:56:54.987149+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13640 | 39583 | swimming_water_temperature | 2020-08-12T10:12:53.678697+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13636 | 39693 | swimming_water_temperature | 2020-08-12T10:11:40.978726+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13634 | 39322 | swimming_water_temperature | 2020-08-12T09:56:50.857383+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13632 | 39693 | swimming_water_temperature | 2020-08-11T18:11:24.202010+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13630 | 39693 | swimming_water_temperature | 2020-08-11T17:53:29.036539+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13627 | 39583 | swimming_water_temperature | 2020-08-11T15:05:28.234604+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13625 | 39322 | swimming_water_temperature | 2020-08-11T14:16:12.084130+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13623 | 39693 | swimming_water_temperature | 2020-08-11T14:01:30.649371+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13621 | 39527 | swimming_water_temperature | 2020-08-11T13:44:34.401530+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13619 | 39322 | swimming_water_temperature | 2020-08-11T11:56:45.959411+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13617 | 52959 | swimming_water_temperature | 2020-08-11T11:41:10.043713+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13614 | 39693 | swimming_water_temperature | 2020-08-11T10:07:24.910075+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13593 | 39815 | swimming_water_temperature | 2020-08-11T08:39:44.619852+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13590 | 39693 | swimming_water_temperature | 2020-08-11T08:33:41.770519+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13587 | 39693 | swimming_water_temperature | 2020-08-10T18:00:25.435987+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13586 | 39815 | swimming_water_temperature | 2020-08-10T17:55:33.488830+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13584 | 39322 | swimming_water_temperature | 2020-08-10T17:53:09.403632+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13582 | 39583 | swimming_water_temperature | 2020-08-10T17:43:58.418065+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13579 | 39693 | swimming_water_temperature | 2020-08-10T15:15:52.633703+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13578 | 39412 | swimming_water_temperature | 2020-08-10T14:25:39.741558+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13577 | 39368 | swimming_water_temperature | 2020-08-10T14:25:22.663454+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13576 | 52958 | swimming_water_temperature | 2020-08-10T14:24:02.628875+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13575 | 50549 | swimming_water_temperature | 2020-08-10T14:23:27.481034+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13574 | 52960 | swimming_water_temperature | 2020-08-10T14:23:06.552866+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13572 | 39815 | swimming_water_temperature | 2020-08-10T14:08:58.999911+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13571 | 39322 | swimming_water_temperature | 2020-08-10T14:05:09.050466+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13568 | 39583 | swimming_water_temperature | 2020-08-10T13:57:19.332274+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13566 | 39815 | swimming_water_temperature | 2020-08-10T12:18:37.890647+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13564 | 39527 | swimming_water_temperature | 2020-08-10T11:50:03.034109+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13561 | 39322 | swimming_water_temperature | 2020-08-10T11:14:46.745764+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13548 | 39693 | swimming_water_temperature | 2020-08-10T10:49:02.383881+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13539 | 39568 | swimming_water_temperature | 2020-08-10T10:40:29.021569+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13537 | 52959 | swimming_water_temperature | 2020-08-10T10:16:56.202218+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13534 | 39583 | swimming_water_temperature | 2020-08-10T10:07:41.921718+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13532 | 39322 | swimming_water_temperature | 2020-08-09T17:56:46.753506+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | 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 | ||||
13527 | 39583 | swimming_water_temperature | 2020-08-09T17:41:26.595094+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13524 | 39815 | swimming_water_temperature | 2020-08-09T14:03:50.810138+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13522 | 39322 | swimming_water_temperature | 2020-08-09T13:57:03.168042+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13520 | 39583 | swimming_water_temperature | 2020-08-09T13:56:56.562432+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13518 | 40802 | swimming_water_temperature | 2020-08-09T13:45:51.067802+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13516 | 39527 | swimming_water_temperature | 2020-08-09T12:31:26.082193+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13514 | 40993 | swimming_water_temperature | 2020-08-09T11:55:05.710341+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13512 | 40258 | swimming_water_temperature | 2020-08-09T11:37:28.691880+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13510 | 40150 | swimming_water_temperature | 2020-08-09T11:10:20.973354+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13508 | 39815 | swimming_water_temperature | 2020-08-09T11:06:56.161131+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13506 | 40142 | swimming_water_temperature | 2020-08-09T10:56:53.131921+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13504 | 40098 | swimming_water_temperature | 2020-08-09T10:51:50.562189+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13502 | 39693 | swimming_water_temperature | 2020-08-09T10:50:50.934558+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13500 | 40950 | swimming_water_temperature | 2020-08-09T10:44:13.073823+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13499 | 39583 | swimming_water_temperature | 2020-08-09T10:33:13.420224+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13496 | 39322 | swimming_water_temperature | 2020-08-09T10:11:30.826163+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13494 | 52959 | swimming_water_temperature | 2020-08-09T10:07:49.977106+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13492 | 40386 | swimming_water_temperature | 2020-08-09T10:07:27.309910+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13490 | 41791 | swimming_water_temperature | 2020-08-09T10:06:33.402783+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13488 | 39568 | swimming_water_temperature | 2020-08-09T09:58:17.948224+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13486 | 41601 | swimming_water_temperature | 2020-08-09T09:56:07.449501+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13484 | 40559 | swimming_water_temperature | 2020-08-09T09:55:05.986446+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13481 | 40157 | swimming_water_temperature | 2020-08-09T09:42:42.516222+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13478 | 39815 | swimming_water_temperature | 2020-08-08T18:05:49.749595+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13476 | 39693 | swimming_water_temperature | 2020-08-08T17:49:52.468272+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13474 | 39583 | swimming_water_temperature | 2020-08-08T17:47:06.132575+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13473 | 39815 | swimming_water_temperature | 2020-08-08T14:21:40.603344+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13469 | 39583 | swimming_water_temperature | 2020-08-08T14:05:39.538990+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13467 | 39322 | swimming_water_temperature | 2020-08-08T14:05:25.658428+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13465 | 39693 | swimming_water_temperature | 2020-08-08T13:48:48.980868+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13464 | 40142 | swimming_water_temperature | 2020-08-08T12:50:07.298808+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13462 | 40802 | swimming_water_temperature | 2020-08-08T11:36:03.449967+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13460 | 39322 | swimming_water_temperature | 2020-08-08T10:57:49.243369+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13458 | 40950 | swimming_water_temperature | 2020-08-08T10:31:46.048601+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13457 | 40098 | swimming_water_temperature | 2020-08-08T10:26:01.500890+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13454 | 41791 | swimming_water_temperature | 2020-08-08T10:18:18.366469+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13451 | 40142 | swimming_water_temperature | 2020-08-08T10:13:47.588691+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13449 | 39583 | swimming_water_temperature | 2020-08-08T10:10:40.247901+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13448 | 40559 | swimming_water_temperature | 2020-08-08T10:08:27.505133+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13445 | 52959 | swimming_water_temperature | 2020-08-08T10:07:13.024815+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13443 | 40386 | swimming_water_temperature | 2020-08-08T10:01:30.356401+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13441 | 41601 | swimming_water_temperature | 2020-08-08T10:01:02.259139+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13440 | 41960 | swimming_water_temperature | 2020-08-08T10:00:06.689992+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 );