observation

220 rows where value = "maintenance_finished" sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

value ✖

  • maintenance_finished · 120 ✖

primary ✖

  • 0 120
id ▲ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
7618 57401 ski_trail_maintenance 2020-02-13T13:23:18.835539+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7616 53710 ski_trail_maintenance 2020-02-13T13:16:02.728670+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7609 57401 ski_trail_maintenance 2020-02-13T08:16:01.120662+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  
7581 57401 ski_trail_maintenance 2020-02-12T07:50:36.634179+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7565 57401 ski_trail_maintenance 2020-02-11T13:44:17.099742+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7551 53710 ski_trail_maintenance 2020-02-11T06:17:52.833501+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  
7491 57401 ski_trail_maintenance 2020-02-09T11:09:37.721240+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7477 57401 ski_trail_maintenance 2020-02-09T08:14:29.411644+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  
7455 57401 ski_trail_maintenance 2020-02-08T13:16:51.022202+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  
7443 57401 ski_trail_maintenance 2020-02-08T09:55:15.643443+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7426 57401 ski_trail_maintenance 2020-02-08T06:44:59.727346+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7422 57401 ski_trail_maintenance 2020-02-07T18:58:45.551149+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7372 57401 ski_trail_maintenance 2020-02-07T05:49:26.323084+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7353 57401 ski_trail_maintenance 2020-02-06T13:58:35.149930+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7327 57401 ski_trail_maintenance 2020-02-06T08:00:16.857249+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  
7314 57401 ski_trail_maintenance 2020-02-05T14:17:02.699575+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7308 57401 ski_trail_maintenance 2020-02-05T10:38:46.614074+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7273 53710 ski_trail_maintenance 2020-02-05T06:45:12.655449+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7232 53710 ski_trail_maintenance 2020-02-04T02:45:55.867748+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  
7215 53710 ski_trail_maintenance 2020-02-03T07:08:32.944135+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  
7197 53710 ski_trail_maintenance 2020-02-02T00:02:33.014238+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  
7168 60871 ski_trail_maintenance 2020-01-31T08:00:26.192021+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  
7132 60871 ski_trail_maintenance 2020-01-29T08:05:06.716643+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  
7114 60871 ski_trail_maintenance 2020-01-28T09:57:20.669282+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7102 57401 ski_trail_maintenance 2020-01-27T12:39:03.568980+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7096 57401 ski_trail_maintenance 2020-01-27T08:18:31.264213+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  
7087 53710 ski_trail_maintenance 2020-01-27T07:34:59.593960+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7071 53710 ski_trail_maintenance 2020-01-26T00:17:23.849306+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  
7067 57401 ski_trail_maintenance 2020-01-25T20:40:57.050343+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7050 57401 ski_trail_maintenance 2020-01-25T06:53:50.789786+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
7043 57401 ski_trail_maintenance 2020-01-24T13:46:09.733827+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  
7033 57401 ski_trail_maintenance 2020-01-24T09:53:57.359809+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  
6997 53710 ski_trail_maintenance 2020-01-22T08:56:38.405788+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  
6946 53710 ski_trail_maintenance 2020-01-20T07:34:37.896855+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  
6900 60871 ski_trail_maintenance 2020-01-18T07:57:33.829939+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
6896 57401 ski_trail_maintenance 2020-01-18T07:25:32.604944+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
6894 53710 ski_trail_maintenance 2020-01-18T00:51:56.860643+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
6888 57401 ski_trail_maintenance 2020-01-17T13:29:49.942021+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  
6874 57401 ski_trail_maintenance 2020-01-17T07:46:21.549817+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
6869 53710 ski_trail_maintenance 2020-01-17T06:35:55.553872+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
6860 57401 ski_trail_maintenance 2020-01-16T10:45:40.686359+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
6855 57401 ski_trail_maintenance 2020-01-16T07:55:35.906710+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
6852 53710 ski_trail_maintenance 2020-01-16T07:42:51.652733+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  
6818 57401 ski_trail_maintenance 2020-01-14T08:01:43.100199+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  
6805 57401 ski_trail_maintenance 2020-01-13T08:52:44.529606+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
6798 53710 ski_trail_maintenance 2020-01-13T07:34:01.597104+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
6778 53710 ski_trail_maintenance 2020-01-12T08:35:32.650176+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  
6765 57401 ski_trail_maintenance 2020-01-11T12:21:06.555406+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  
6701 57401 ski_trail_maintenance 2020-01-07T07:38:14.369933+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
6698 53710 ski_trail_maintenance 2020-01-07T07:08:38.379249+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  
6679 57401 ski_trail_maintenance 2020-01-05T09:21:07.649472+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
6670 53710 ski_trail_maintenance 2020-01-05T08:32:29.955758+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  
6653 60871 ski_trail_maintenance 2020-01-04T07:42:49.854593+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  
6649 53710 ski_trail_maintenance 2020-01-03T21:53:02.260982+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  
6631 60871 ski_trail_maintenance 2020-01-02T10:00:45.665837+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
6617 53710 ski_trail_maintenance 2020-01-02T07:22:42.310049+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  
6611 57401 ski_trail_maintenance 2020-01-01T07:44:18.918301+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  
6600 60871 ski_trail_maintenance 2019-12-31T07:42:35.781015+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  
6580 57401 ski_trail_maintenance 2019-12-29T11:19:37.341758+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  
6547 60871 ski_trail_maintenance 2019-12-28T06:39:35.545330+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  
6519 60871 ski_trail_maintenance 2019-12-26T08:21:36.458645+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  
6511 53710 ski_trail_maintenance 2019-12-25T06:24:02.901542+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  
6488 53710 ski_trail_maintenance 2019-12-23T06:55:35.440364+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
6477 53710 ski_trail_maintenance 2019-12-22T00:04:11.782017+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  
6470 60871 ski_trail_maintenance 2019-12-21T10:07:09.645066+0200     Kunnostettu   Iståndsatt 0 Maintenance finished maintenance_finished unknown  
6463 53710 ski_trail_maintenance 2019-12-20T08:45:19.352442+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  

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