observation
147 rows where name_en = "Good condition" sorted by unit
This data as json, CSV (advanced)
Suggested facets: unit
id | unit ▼ | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
43474 | 51028 | ski_trail_condition | 2020-12-16T10:53:33.275444+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6016 | 53710 | ski_trail_condition | 2019-11-08T14:21:00.052967+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6019 | 53710 | ski_trail_condition | 2019-11-09T23:47:01.036909+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6048 | 53710 | ski_trail_condition | 2019-11-16T01:05:56.223240+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6120 | 53710 | ski_trail_condition | 2019-11-25T14:06:25.226345+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6126 | 53710 | ski_trail_condition | 2019-11-26T08:37:51.926400+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6161 | 53710 | ski_trail_condition | 2019-11-27T10:12:39.120372+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6201 | 53710 | ski_trail_condition | 2019-12-01T11:09:04.755950+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6206 | 53710 | ski_trail_condition | 2019-12-02T07:12:42.393218+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6237 | 53710 | ski_trail_condition | 2019-12-04T08:14:21.041850+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6252 | 53710 | ski_trail_condition | 2019-12-05T06:47:02.298313+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6289 | 53710 | ski_trail_condition | 2019-12-07T22:30:27.408710+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6339 | 53710 | ski_trail_condition | 2019-12-11T08:55:58.890711+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6446 | 53710 | ski_trail_condition | 2019-12-19T08:26:13.707965+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6464 | 53710 | ski_trail_condition | 2019-12-20T08:45:19.352442+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6478 | 53710 | ski_trail_condition | 2019-12-22T00:04:11.782017+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6489 | 53710 | ski_trail_condition | 2019-12-23T06:55:35.440364+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6512 | 53710 | ski_trail_condition | 2019-12-25T06:24:02.901542+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6517 | 53710 | ski_trail_condition | 2019-12-26T00:22:59.249937+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6554 | 53710 | ski_trail_condition | 2019-12-28T09:20:04.907795+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6618 | 53710 | ski_trail_condition | 2020-01-02T07:22:42.310049+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6635 | 53710 | ski_trail_condition | 2020-01-03T07:08:30.612702+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6646 | 53710 | ski_trail_condition | 2020-01-03T11:44:12.936348+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6650 | 53710 | ski_trail_condition | 2020-01-03T21:53:02.260982+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6671 | 53710 | ski_trail_condition | 2020-01-05T08:32:29.955758+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6699 | 53710 | ski_trail_condition | 2020-01-07T07:08:38.379249+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6740 | 53710 | ski_trail_condition | 2020-01-10T07:10:53.882427+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6779 | 53710 | ski_trail_condition | 2020-01-12T08:35:32.650176+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6799 | 53710 | ski_trail_condition | 2020-01-13T07:34:01.597104+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6853 | 53710 | ski_trail_condition | 2020-01-16T07:42:51.652733+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6870 | 53710 | ski_trail_condition | 2020-01-17T06:35:55.553872+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6895 | 53710 | ski_trail_condition | 2020-01-18T00:51:56.860643+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6914 | 53710 | ski_trail_condition | 2020-01-19T03:09:43.545641+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6947 | 53710 | ski_trail_condition | 2020-01-20T07:34:37.896855+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6998 | 53710 | ski_trail_condition | 2020-01-22T08:56:38.405788+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7065 | 53710 | ski_trail_condition | 2020-01-25T17:00:27.557055+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7072 | 53710 | ski_trail_condition | 2020-01-26T00:17:23.849306+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7088 | 53710 | ski_trail_condition | 2020-01-27T07:34:59.593960+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7198 | 53710 | ski_trail_condition | 2020-02-02T00:02:33.014238+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7216 | 53710 | ski_trail_condition | 2020-02-03T07:08:32.944135+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7233 | 53710 | ski_trail_condition | 2020-02-04T02:45:55.867748+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7274 | 53710 | ski_trail_condition | 2020-02-05T06:45:12.655449+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7552 | 53710 | ski_trail_condition | 2020-02-11T06:17:52.833501+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7617 | 53710 | ski_trail_condition | 2020-02-13T13:16:02.728670+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7623 | 53710 | ski_trail_condition | 2020-02-14T01:13:13.788951+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7648 | 53710 | ski_trail_condition | 2020-02-15T03:43:44.409406+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7743 | 53710 | ski_trail_condition | 2020-02-19T07:58:28.133899+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7772 | 53710 | ski_trail_condition | 2020-02-20T00:52:20.900814+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7928 | 53710 | ski_trail_condition | 2020-02-28T04:52:34.368224+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7977 | 53710 | ski_trail_condition | 2020-02-29T16:37:16.350555+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
8007 | 53710 | ski_trail_condition | 2020-03-02T07:54:35.921101+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
8125 | 53710 | ski_trail_condition | 2020-03-07T16:13:54.098929+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
8239 | 53710 | ski_trail_condition | 2020-03-15T02:03:02.603783+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
8271 | 53710 | ski_trail_condition | 2020-03-16T15:04:03.490018+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
8282 | 53710 | ski_trail_condition | 2020-03-17T08:46:21.661452+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
8296 | 53710 | ski_trail_condition | 2020-03-18T07:51:46.366764+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
8333 | 53710 | ski_trail_condition | 2020-03-22T01:20:40.714734+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
41918 | 53710 | ski_trail_condition | 2020-12-11T16:09:15.450515+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
42519 | 53710 | ski_trail_condition | 2020-12-13T12:42:55.526175+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
42723 | 53710 | ski_trail_condition | 2020-12-14T04:43:27.140083+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
42725 | 53710 | ski_trail_condition | 2020-12-14T04:43:32.329164+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
42874 | 53710 | ski_trail_condition | 2020-12-14T15:40:19.068128+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
43063 | 53710 | ski_trail_condition | 2020-12-15T06:33:25.850229+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
43413 | 53710 | ski_trail_condition | 2020-12-16T07:11:30.017847+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
43415 | 53710 | ski_trail_condition | 2020-12-16T07:11:33.976982+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
43745 | 53710 | ski_trail_condition | 2020-12-17T07:03:20.878325+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
44067 | 53710 | ski_trail_condition | 2020-12-18T06:41:50.663424+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
44347 | 53710 | ski_trail_condition | 2020-12-19T01:34:06.524073+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
45262 | 53710 | ski_trail_condition | 2020-12-21T06:46:18.715867+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
45673 | 53710 | ski_trail_condition | 2020-12-22T07:03:59.145956+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
47464 | 53710 | ski_trail_condition | 2020-12-27T01:43:46.631087+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
48749 | 53710 | ski_trail_condition | 2020-12-30T06:19:32.883301+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
49880 | 53710 | ski_trail_condition | 2021-01-02T00:34:59.827964+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
50381 | 53710 | ski_trail_condition | 2021-01-03T07:08:36.692071+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
50550 | 53710 | ski_trail_condition | 2021-01-03T15:23:05.174367+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7650 | 54329 | ski_trail_condition | 2020-02-15T03:44:25.849912+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6581 | 57401 | ski_trail_condition | 2019-12-29T11:19:37.341758+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6585 | 57401 | ski_trail_condition | 2019-12-30T07:13:10.054466+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6607 | 57401 | ski_trail_condition | 2019-12-31T11:28:09.621779+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6766 | 57401 | ski_trail_condition | 2020-01-11T12:21:06.555406+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7328 | 57401 | ski_trail_condition | 2020-02-06T08:00:16.857249+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7354 | 57401 | ski_trail_condition | 2020-02-06T13:58:35.149930+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7373 | 57401 | ski_trail_condition | 2020-02-07T05:49:26.323084+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7423 | 57401 | ski_trail_condition | 2020-02-07T18:58:45.551149+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7444 | 57401 | ski_trail_condition | 2020-02-08T09:55:15.643443+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7478 | 57401 | ski_trail_condition | 2020-02-09T08:14:29.411644+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7582 | 57401 | ski_trail_condition | 2020-02-12T07:50:36.634179+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7610 | 57401 | ski_trail_condition | 2020-02-13T08:16:01.120662+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7954 | 57401 | ski_trail_condition | 2020-02-29T07:17:20.026242+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7967 | 57401 | ski_trail_condition | 2020-02-29T13:43:59.514229+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
7975 | 57401 | ski_trail_condition | 2020-02-29T15:04:04.897212+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
8010 | 57401 | ski_trail_condition | 2020-03-02T09:19:20.582421+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
8035 | 57401 | ski_trail_condition | 2020-03-03T07:47:51.051472+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
8041 | 57401 | ski_trail_condition | 2020-03-03T09:10:10.738725+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
8043 | 57401 | ski_trail_condition | 2020-03-03T12:24:11.435003+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
8112 | 57401 | ski_trail_condition | 2020-03-07T00:40:29.937266+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6343 | 60871 | ski_trail_condition | 2019-12-11T09:08:19.813530+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6381 | 60871 | ski_trail_condition | 2019-12-13T13:57:33.341521+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6388 | 60871 | ski_trail_condition | 2019-12-14T10:38:45.600268+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6396 | 60871 | ski_trail_condition | 2019-12-15T07:39:59.437880+0200 | Hyvä | Bra | 1 | Good condition | good | good |
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 );