observation
4,968 rows where primary = 0 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: property, name_fi, value
name_sv ✖
- 17-19°C 1,261
- 19-21°C 1,246
- 15-17°C 818
- 21-23°C 746
- under 15°C 497
- Iståndsatt 220
- över 23°C 180
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
50549 | 53710 | ski_trail_maintenance | 2021-01-03T15:23:05.174367+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
50380 | 53710 | ski_trail_maintenance | 2021-01-03T07:08:36.692071+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 | ||||
49879 | 53710 | ski_trail_maintenance | 2021-01-02T00:34:59.827964+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 | ||||
49159 | 60871 | ski_trail_maintenance | 2020-12-31T07:26:26.000942+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 | ||||
48748 | 53710 | ski_trail_maintenance | 2020-12-30T06:19:32.883301+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 | ||||
48003 | 60871 | ski_trail_maintenance | 2020-12-28T10:27:27.097583+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
47463 | 53710 | ski_trail_maintenance | 2020-12-27T01:43:46.631087+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 | ||||
45682 | 60871 | ski_trail_maintenance | 2020-12-22T07:42:29.221769+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
45672 | 53710 | ski_trail_maintenance | 2020-12-22T07:03:59.145956+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
45261 | 53710 | ski_trail_maintenance | 2020-12-21T06:46:18.715867+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 | ||||
44443 | 57401 | ski_trail_maintenance | 2020-12-19T08:35:31.727189+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
44346 | 53710 | ski_trail_maintenance | 2020-12-19T01:34:06.524073+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
44191 | 57401 | ski_trail_maintenance | 2020-12-18T14:31:26.232730+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
44127 | 57401 | ski_trail_maintenance | 2020-12-18T10:10:18.986324+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
44066 | 53710 | ski_trail_maintenance | 2020-12-18T06:41:50.663424+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
43849 | 57401 | ski_trail_maintenance | 2020-12-17T13:50:28.864271+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
43778 | 57401 | ski_trail_maintenance | 2020-12-17T09:08:00.553888+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
43744 | 53710 | ski_trail_maintenance | 2020-12-17T07:03:20.878325+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
43414 | 53710 | ski_trail_maintenance | 2020-12-16T07:11:33.976982+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
43350 | 57401 | ski_trail_maintenance | 2020-12-16T02:58:58.706463+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
43235 | 57401 | ski_trail_maintenance | 2020-12-15T18:15:22.964565+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
42873 | 53710 | ski_trail_maintenance | 2020-12-14T15:40:19.068128+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
42724 | 53710 | ski_trail_maintenance | 2020-12-14T04:43:32.329164+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
42722 | 53710 | ski_trail_maintenance | 2020-12-14T04:43:27.140083+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
42518 | 53710 | ski_trail_maintenance | 2020-12-13T12:42:55.526175+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
41917 | 53710 | ski_trail_maintenance | 2020-12-11T16:09:15.450515+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
24082 | 39322 | swimming_water_temperature | 2020-10-14T11:05:00.666183+0300 | alle 15°C | under 15°C | 0 | below 15°C | 0-15 | unknown | ||||
17566 | 39412 | swimming_water_temperature | 2020-09-07T10:11:59.368806+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
17564 | 39412 | swimming_water_temperature | 2020-09-07T10:11:53.300729+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
17555 | 39713 | swimming_water_temperature | 2020-09-07T09:46:16.798143+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
17552 | 39875 | swimming_water_temperature | 2020-09-07T09:30:46.246035+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
17544 | 39902 | swimming_water_temperature | 2020-09-07T09:15:08.607089+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
17537 | 39606 | swimming_water_temperature | 2020-09-07T08:53:06.714842+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
17535 | 39823 | swimming_water_temperature | 2020-09-07T08:52:52.469770+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
17525 | 53461 | swimming_water_temperature | 2020-09-07T08:19:43.434408+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
14484 | 39583 | swimming_water_temperature | 2020-08-28T08:43:07.548111+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13974 | 53461 | swimming_water_temperature | 2020-08-21T11:23:03.184224+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13972 | 39713 | swimming_water_temperature | 2020-08-21T11:09:51.348003+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13970 | 39823 | swimming_water_temperature | 2020-08-21T11:09:22.320503+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13969 | 39875 | swimming_water_temperature | 2020-08-21T10:12:16.211484+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13967 | 39875 | swimming_water_temperature | 2020-08-21T10:12:09.731511+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13965 | 39902 | swimming_water_temperature | 2020-08-21T09:45:02.019102+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13963 | 39606 | swimming_water_temperature | 2020-08-21T09:31:55.941932+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13890 | 42114 | swimming_water_temperature | 2020-08-17T13:04:42.675993+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13888 | 52959 | swimming_water_temperature | 2020-08-17T12:37:07.381585+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13886 | 39267 | swimming_water_temperature | 2020-08-17T12:36:24.340709+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13884 | 39693 | swimming_water_temperature | 2020-08-17T12:36:09.329837+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13882 | 39568 | swimming_water_temperature | 2020-08-17T12:35:54.164611+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13880 | 39527 | swimming_water_temperature | 2020-08-17T12:35:38.285569+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13878 | 39322 | swimming_water_temperature | 2020-08-17T12:35:21.055110+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13876 | 53461 | swimming_water_temperature | 2020-08-17T11:10:45.274995+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13874 | 39606 | swimming_water_temperature | 2020-08-17T10:09:47.344109+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13873 | 39902 | swimming_water_temperature | 2020-08-17T09:47:18.772678+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13871 | 39875 | swimming_water_temperature | 2020-08-17T09:26:42.758776+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13869 | 39713 | swimming_water_temperature | 2020-08-17T09:11:31.771240+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13867 | 39583 | swimming_water_temperature | 2020-08-16T21:54:47.324929+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13864 | 39815 | swimming_water_temperature | 2020-08-16T18:10:46.405573+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13861 | 39693 | swimming_water_temperature | 2020-08-16T18:01:54.056600+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13859 | 39322 | swimming_water_temperature | 2020-08-16T14:53:18.650321+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13857 | 39583 | swimming_water_temperature | 2020-08-16T14:17:34.158021+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13855 | 39815 | swimming_water_temperature | 2020-08-16T14:11:53.022410+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13853 | 39693 | swimming_water_temperature | 2020-08-16T13:57:59.214444+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13851 | 52959 | swimming_water_temperature | 2020-08-16T12:18:21.427698+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13849 | 39693 | swimming_water_temperature | 2020-08-16T11:40:55.631651+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13846 | 39815 | swimming_water_temperature | 2020-08-16T11:15:22.949399+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13844 | 39322 | swimming_water_temperature | 2020-08-16T10:31:46.597902+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13824 | 39568 | swimming_water_temperature | 2020-08-16T10:08:07.980630+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13822 | 39815 | swimming_water_temperature | 2020-08-15T18:42:43.077057+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13819 | 39693 | swimming_water_temperature | 2020-08-15T18:18:42.858743+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13816 | 39583 | swimming_water_temperature | 2020-08-15T17:46:12.005510+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13814 | 39527 | swimming_water_temperature | 2020-08-15T15:32:40.700477+0300 | 15-17°C | 15-17°C | 0 | 15-17°C | 15-17 | unknown | ||||
13813 | 39693 | swimming_water_temperature | 2020-08-15T14:13:08.899502+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13810 | 39322 | swimming_water_temperature | 2020-08-15T14:00:22.620339+0300 | 21-23°C | 21-23°C | 0 | 21-23°C | 21-23 | unknown | ||||
13807 | 39583 | swimming_water_temperature | 2020-08-15T13:51:22.654067+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13805 | 39815 | swimming_water_temperature | 2020-08-15T13:48:39.493764+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13803 | 39693 | swimming_water_temperature | 2020-08-15T12:55:04.548964+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13800 | 39815 | swimming_water_temperature | 2020-08-15T11:37:14.309248+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13798 | 52959 | swimming_water_temperature | 2020-08-15T10:55:15.573262+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13796 | 39322 | swimming_water_temperature | 2020-08-15T10:35:22.380884+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13775 | 39568 | swimming_water_temperature | 2020-08-15T08:32:06.194728+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13774 | 39815 | swimming_water_temperature | 2020-08-14T18:46:59.477704+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13772 | 39693 | swimming_water_temperature | 2020-08-14T18:42:33.748153+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13769 | 39583 | swimming_water_temperature | 2020-08-14T17:53:07.050472+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13765 | 39815 | swimming_water_temperature | 2020-08-14T14:20:40.988035+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13762 | 39583 | swimming_water_temperature | 2020-08-14T13:46:11.499356+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13760 | 39693 | swimming_water_temperature | 2020-08-14T12:33:22.192086+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13758 | 39322 | swimming_water_temperature | 2020-08-14T11:27:10.378148+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13755 | 39583 | swimming_water_temperature | 2020-08-14T10:07:32.848389+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13752 | 39815 | swimming_water_temperature | 2020-08-14T09:52:40.512337+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13733 | 39815 | swimming_water_temperature | 2020-08-13T19:02:44.722945+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13731 | 39322 | swimming_water_temperature | 2020-08-13T18:58:39.993882+0300 | 19-21°C | 19-21°C | 0 | 19-21°C | 19-21 | unknown | ||||
13729 | 39693 | swimming_water_temperature | 2020-08-13T18:30:14.317739+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13727 | 39815 | swimming_water_temperature | 2020-08-13T15:01:22.268718+0300 | 17-19°C | 17-19°C | 0 | 17-19°C | 17-19 | unknown | ||||
13726 | 39322 | swimming_water_temperature | 2020-08-13T14:31:00.540025+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 );