observation

4,968 rows where primary = 0 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name_fi, 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
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  

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