observation
147 rows where name_sv = "Bra" sorted by name_en
This data as json, CSV (advanced)
| id | unit | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en ▼ | value | quality | value_en |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7975 | 57401 | ski_trail_condition | 2020-02-29T15:04:04.897212+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 | ||||
| 7985 | 60871 | ski_trail_condition | 2020-03-01T07:53:48.833028+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 | ||||
| 8010 | 57401 | ski_trail_condition | 2020-03-02T09:19:20.582421+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
| 8030 | 60871 | ski_trail_condition | 2020-03-02T22:36:06.751040+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 | ||||
| 8105 | 60871 | ski_trail_condition | 2020-03-06T13:38:25.245857+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 | ||||
| 8125 | 53710 | ski_trail_condition | 2020-03-07T16:13:54.098929+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
| 8127 | 60871 | ski_trail_condition | 2020-03-08T07:49:17.629415+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
| 8129 | 60871 | ski_trail_condition | 2020-03-08T07:49:30.428948+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 | ||||
| 42185 | 60871 | ski_trail_condition | 2020-12-12T11:41:02.503575+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 | ||||
| 43474 | 51028 | ski_trail_condition | 2020-12-16T10:53:33.275444+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 | ||||
| 44840 | 60871 | ski_trail_condition | 2020-12-20T07:15:44.615047+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 | ||||
| 47456 | 60871 | ski_trail_condition | 2020-12-27T01:11:22.949464+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 | ||||
| 48004 | 60871 | ski_trail_condition | 2020-12-28T10:27:27.097583+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
| 48430 | 60871 | ski_trail_condition | 2020-12-29T10:48:25.489601+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 | ||||
| 48768 | 60871 | ski_trail_condition | 2020-12-30T07:39:48.552666+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
| 49160 | 60871 | ski_trail_condition | 2020-12-31T07:26:26.000942+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
| 49555 | 60871 | ski_trail_condition | 2021-01-01T07:21:11.560439+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 | ||||
| 49957 | 60871 | ski_trail_condition | 2021-01-02T07:07:06.440744+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 |
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 );