observation
4,968 rows where primary = 0 sorted by unit descending
This data as json, CSV (advanced)
Suggested facets: property
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
| id | unit ▲ | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6342 | 60871 | ski_trail_maintenance | 2019-12-11T09:08:19.813530+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6380 | 60871 | ski_trail_maintenance | 2019-12-13T13:57:33.341521+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6387 | 60871 | ski_trail_maintenance | 2019-12-14T10:38:45.600268+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6395 | 60871 | ski_trail_maintenance | 2019-12-15T07:39:59.437880+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6417 | 60871 | ski_trail_maintenance | 2019-12-16T12:25:51.151374+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6441 | 60871 | ski_trail_maintenance | 2019-12-19T07:45:54.212502+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6455 | 60871 | ski_trail_maintenance | 2019-12-20T00:04:26.555249+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6470 | 60871 | ski_trail_maintenance | 2019-12-21T10:07:09.645066+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6475 | 60871 | ski_trail_maintenance | 2019-12-21T22:15:08.210428+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6492 | 60871 | ski_trail_maintenance | 2019-12-23T08:26:52.872679+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6513 | 60871 | ski_trail_maintenance | 2019-12-25T08:50:10.732707+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6519 | 60871 | ski_trail_maintenance | 2019-12-26T08:21:36.458645+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6529 | 60871 | ski_trail_maintenance | 2019-12-27T08:13:48.995474+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6547 | 60871 | ski_trail_maintenance | 2019-12-28T06:39:35.545330+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6567 | 60871 | ski_trail_maintenance | 2019-12-29T08:51:39.970376+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6600 | 60871 | ski_trail_maintenance | 2019-12-31T07:42:35.781015+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6609 | 60871 | ski_trail_maintenance | 2019-12-31T21:31:32.314416+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6631 | 60871 | ski_trail_maintenance | 2020-01-02T10:00:45.665837+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6653 | 60871 | ski_trail_maintenance | 2020-01-04T07:42:49.854593+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6666 | 60871 | ski_trail_maintenance | 2020-01-05T07:46:19.292266+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6876 | 60871 | ski_trail_maintenance | 2020-01-17T08:15:49.872372+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6900 | 60871 | ski_trail_maintenance | 2020-01-18T07:57:33.829939+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6916 | 60871 | ski_trail_maintenance | 2020-01-19T07:47:33.094254+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6990 | 60871 | ski_trail_maintenance | 2020-01-21T21:41:41.750505+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7011 | 60871 | ski_trail_maintenance | 2020-01-23T06:19:06.249894+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7036 | 60871 | ski_trail_maintenance | 2020-01-24T09:55:53.390561+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7069 | 60871 | ski_trail_maintenance | 2020-01-25T23:04:35.866730+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7089 | 60871 | ski_trail_maintenance | 2020-01-27T07:50:48.053429+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7114 | 60871 | ski_trail_maintenance | 2020-01-28T09:57:20.669282+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7130 | 60871 | ski_trail_maintenance | 2020-01-29T08:03:32.880807+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7132 | 60871 | ski_trail_maintenance | 2020-01-29T08:05:06.716643+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7153 | 60871 | ski_trail_maintenance | 2020-01-30T08:52:29.583774+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7168 | 60871 | ski_trail_maintenance | 2020-01-31T08:00:26.192021+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7181 | 60871 | ski_trail_maintenance | 2020-01-31T22:24:26.862505+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7199 | 60871 | ski_trail_maintenance | 2020-02-02T06:54:03.673970+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7222 | 60871 | ski_trail_maintenance | 2020-02-03T08:38:45.078520+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7323 | 60871 | ski_trail_maintenance | 2020-02-06T00:24:34.490282+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7450 | 60871 | ski_trail_maintenance | 2020-02-08T11:11:04.440142+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7459 | 60871 | ski_trail_maintenance | 2020-02-08T16:26:09.418862+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7521 | 60871 | ski_trail_maintenance | 2020-02-10T08:36:42.291038+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7607 | 60871 | ski_trail_maintenance | 2020-02-13T07:59:42.417578+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7636 | 60871 | ski_trail_maintenance | 2020-02-14T09:55:48.094355+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7655 | 60871 | ski_trail_maintenance | 2020-02-15T07:09:46.017331+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7745 | 60871 | ski_trail_maintenance | 2020-02-19T08:09:24.405837+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7769 | 60871 | ski_trail_maintenance | 2020-02-19T22:42:28.908174+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7849 | 60871 | ski_trail_maintenance | 2020-02-24T22:14:31.815186+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7866 | 60871 | ski_trail_maintenance | 2020-02-25T09:47:38.728329+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7951 | 60871 | ski_trail_maintenance | 2020-02-29T06:46:24.181772+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 7984 | 60871 | ski_trail_maintenance | 2020-03-01T07:53:48.833028+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 8014 | 60871 | ski_trail_maintenance | 2020-03-02T10:26:49.134372+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 8029 | 60871 | ski_trail_maintenance | 2020-03-02T22:36:06.751040+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 8104 | 60871 | ski_trail_maintenance | 2020-03-06T13:38:25.245857+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 8128 | 60871 | ski_trail_maintenance | 2020-03-08T07:49:30.428948+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 8181 | 60871 | ski_trail_maintenance | 2020-03-10T13:37:33.621502+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 8202 | 60871 | ski_trail_maintenance | 2020-03-12T12:41:52.934489+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 8212 | 60871 | ski_trail_maintenance | 2020-03-13T08:30:55.333394+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 8279 | 60871 | ski_trail_maintenance | 2020-03-17T07:42:43.043355+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 8342 | 60871 | ski_trail_maintenance | 2020-03-22T21:11:42.745322+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 44839 | 60871 | ski_trail_maintenance | 2020-12-20T07:15:44.615047+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 45682 | 60871 | ski_trail_maintenance | 2020-12-22T07:42:29.221769+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 47455 | 60871 | ski_trail_maintenance | 2020-12-27T01:11:22.949464+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 48003 | 60871 | ski_trail_maintenance | 2020-12-28T10:27:27.097583+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 48429 | 60871 | ski_trail_maintenance | 2020-12-29T10:48:25.489601+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 48767 | 60871 | ski_trail_maintenance | 2020-12-30T07:39:48.552666+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 49159 | 60871 | ski_trail_maintenance | 2020-12-31T07:26:26.000942+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 49554 | 60871 | ski_trail_maintenance | 2021-01-01T07:21:11.560439+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 49956 | 60871 | ski_trail_maintenance | 2021-01-02T07:07:06.440744+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 2654 | 58015 | swimming_water_temperature | 2019-07-10T08:14:12.977327+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
| 2754 | 58015 | swimming_water_temperature | 2019-07-11T08:47:47.778010+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 3506 | 58015 | swimming_water_temperature | 2019-07-19T16:33:11.927602+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 4157 | 58015 | swimming_water_temperature | 2019-07-25T11:55:53.250923+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 4234 | 58015 | swimming_water_temperature | 2019-07-26T08:57:12.003337+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 4831 | 58015 | swimming_water_temperature | 2019-07-31T13:29:18.325621+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 5242 | 58015 | swimming_water_temperature | 2019-08-04T20:20:42.000506+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 8483 | 58015 | swimming_water_temperature | 2020-06-02T14:01:17.721756+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
| 8761 | 58015 | swimming_water_temperature | 2020-06-06T13:43:29.021115+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
| 9087 | 58015 | swimming_water_temperature | 2020-06-11T10:04:27.738654+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
| 9978 | 58015 | swimming_water_temperature | 2020-06-23T13:04:47.943876+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 10262 | 58015 | swimming_water_temperature | 2020-06-26T13:35:47.649082+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
| 10447 | 58015 | swimming_water_temperature | 2020-06-28T16:41:53.165268+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
| 10726 | 58015 | swimming_water_temperature | 2020-07-03T09:42:41.040848+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
| 11567 | 58015 | swimming_water_temperature | 2020-07-15T10:26:30.947714+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 12069 | 58015 | swimming_water_temperature | 2020-07-22T08:28:49.685912+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 13067 | 58015 | swimming_water_temperature | 2020-08-03T12:48:25.661952+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
| 6580 | 57401 | ski_trail_maintenance | 2019-12-29T11:19:37.341758+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6584 | 57401 | ski_trail_maintenance | 2019-12-30T07:13:10.054466+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6611 | 57401 | ski_trail_maintenance | 2020-01-01T07:44:18.918301+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6615 | 57401 | ski_trail_maintenance | 2020-01-02T07:13:32.980528+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6633 | 57401 | ski_trail_maintenance | 2020-01-03T06:51:07.389426+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6651 | 57401 | ski_trail_maintenance | 2020-01-03T22:18:01.255784+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6679 | 57401 | ski_trail_maintenance | 2020-01-05T09:21:07.649472+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6686 | 57401 | ski_trail_maintenance | 2020-01-06T06:07:14.197337+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6701 | 57401 | ski_trail_maintenance | 2020-01-07T07:38:14.369933+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6720 | 57401 | ski_trail_maintenance | 2020-01-08T09:04:22.736449+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6765 | 57401 | ski_trail_maintenance | 2020-01-11T12:21:06.555406+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6776 | 57401 | ski_trail_maintenance | 2020-01-12T08:19:17.928143+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6805 | 57401 | ski_trail_maintenance | 2020-01-13T08:52:44.529606+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6811 | 57401 | ski_trail_maintenance | 2020-01-13T13:43:32.263283+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6818 | 57401 | ski_trail_maintenance | 2020-01-14T08:01:43.100199+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6828 | 57401 | ski_trail_maintenance | 2020-01-14T13:13:58.104888+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | 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 );