observation

220 rows where name_fi = "Kunnostettu" sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

name_fi ✖

  • Kunnostettu · 220 ✖
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  
8342 60871 ski_trail_maintenance 2020-03-22T21:11:42.745322+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8340 57401 ski_trail_maintenance 2020-03-22T10:44:49.506667+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8336 57401 ski_trail_maintenance 2020-03-22T08:19:37.199729+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8332 53710 ski_trail_maintenance 2020-03-22T01:20:40.714734+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8328 57401 ski_trail_maintenance 2020-03-21T11:40:11.499262+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8324 57401 ski_trail_maintenance 2020-03-21T08:22:42.718269+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8315 57401 ski_trail_maintenance 2020-03-20T06:26:03.690872+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8306 57401 ski_trail_maintenance 2020-03-19T08:00:34.196525+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8297 57401 ski_trail_maintenance 2020-03-18T08:15:55.392234+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8295 53710 ski_trail_maintenance 2020-03-18T07:51:46.366764+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8291 57401 ski_trail_maintenance 2020-03-17T13:28:13.865996+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8287 57401 ski_trail_maintenance 2020-03-17T11:55:16.286272+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8285 57401 ski_trail_maintenance 2020-03-17T09:26:03.990867+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8281 53710 ski_trail_maintenance 2020-03-17T08:46:21.661452+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  
8270 53710 ski_trail_maintenance 2020-03-16T15:04:03.490018+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8265 57401 ski_trail_maintenance 2020-03-16T12:44:48.974622+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8261 57401 ski_trail_maintenance 2020-03-16T09:27:58.359621+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8242 57401 ski_trail_maintenance 2020-03-15T09:23:58.613945+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8238 53710 ski_trail_maintenance 2020-03-15T02:03:02.603783+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8229 57401 ski_trail_maintenance 2020-03-14T11:15:26.033939+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  
8202 60871 ski_trail_maintenance 2020-03-12T12:41:52.934489+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8194 57401 ski_trail_maintenance 2020-03-12T08:49:57.146671+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  
8166 57401 ski_trail_maintenance 2020-03-10T07:08:25.482086+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8147 57401 ski_trail_maintenance 2020-03-09T07:05:19.199434+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8138 57401 ski_trail_maintenance 2020-03-08T10:38:22.987654+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8131 57401 ski_trail_maintenance 2020-03-08T08:23:49.721343+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  
8124 53710 ski_trail_maintenance 2020-03-07T16:13:54.098929+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8111 57401 ski_trail_maintenance 2020-03-07T00:40:29.937266+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  
8102 57401 ski_trail_maintenance 2020-03-06T12:41:40.542658+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8083 57401 ski_trail_maintenance 2020-03-06T08:08:53.044979+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8078 57401 ski_trail_maintenance 2020-03-05T13:52:03.963809+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8071 57401 ski_trail_maintenance 2020-03-05T08:38:49.705571+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8052 57401 ski_trail_maintenance 2020-03-04T09:19:56.446391+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8042 57401 ski_trail_maintenance 2020-03-03T12:24:11.435003+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8040 57401 ski_trail_maintenance 2020-03-03T09:10:10.738725+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8034 57401 ski_trail_maintenance 2020-03-03T07:47:51.051472+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  
8016 57401 ski_trail_maintenance 2020-03-02T12:56:01.941416+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  
8009 57401 ski_trail_maintenance 2020-03-02T09:19:20.582421+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
8006 53710 ski_trail_maintenance 2020-03-02T07:54:35.921101+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7991 57401 ski_trail_maintenance 2020-03-01T09:36:09.384585+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  
7974 57401 ski_trail_maintenance 2020-02-29T15:04:04.897212+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7966 57401 ski_trail_maintenance 2020-02-29T13:43:59.514229+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7953 57401 ski_trail_maintenance 2020-02-29T07:17:20.026242+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  
7944 57401 ski_trail_maintenance 2020-02-28T15:31:54.435420+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7927 53710 ski_trail_maintenance 2020-02-28T04:52:34.368224+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7871 51086 ski_trail_maintenance 2020-02-25T12:03:44.898028+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  
7849 60871 ski_trail_maintenance 2020-02-24T22:14:31.815186+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7771 53710 ski_trail_maintenance 2020-02-20T00:52:20.900814+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  
7745 60871 ski_trail_maintenance 2020-02-19T08:09:24.405837+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7742 53710 ski_trail_maintenance 2020-02-19T07:58:28.133899+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  
7653 57401 ski_trail_maintenance 2020-02-15T06:45:32.218884+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7649 54329 ski_trail_maintenance 2020-02-15T03:44:25.849912+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7647 53710 ski_trail_maintenance 2020-02-15T03:43:44.409406+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7641 57401 ski_trail_maintenance 2020-02-14T13:44:15.553657+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  
7633 57401 ski_trail_maintenance 2020-02-14T09:26:42.848904+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished 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
);