observation
117 rows where name_en = "The icing has begun"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41272 | 61464 | ice_skating_field_condition | 2020-12-09T16:03:00.652834+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
41485 | 61464 | ice_skating_field_condition | 2020-12-10T07:44:13.137670+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
43873 | 61464 | ice_skating_field_condition | 2020-12-17T15:11:39.112974+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
44422 | 61464 | ice_skating_field_condition | 2020-12-19T07:25:17.432276+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50804 | 50354 | ice_skating_field_condition | 2021-01-04T07:54:04.595592+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50836 | 41096 | ice_skating_field_condition | 2021-01-04T09:41:01.358685+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50920 | 40010 | ice_skating_field_condition | 2021-01-04T13:04:47.790620+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50921 | 41734 | ice_skating_field_condition | 2021-01-04T13:05:55.526403+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50922 | 40172 | ice_skating_field_condition | 2021-01-04T13:06:41.859849+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50923 | 39969 | ice_skating_field_condition | 2021-01-04T13:07:45.697883+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50924 | 40350 | ice_skating_field_condition | 2021-01-04T13:08:27.448711+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50925 | 40154 | ice_skating_field_condition | 2021-01-04T13:08:53.663175+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50926 | 42110 | ice_skating_field_condition | 2021-01-04T13:09:15.255958+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50927 | 42110 | ice_skating_field_condition | 2021-01-04T13:09:23.939446+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50928 | 42175 | ice_skating_field_condition | 2021-01-04T13:09:52.023140+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50933 | 42069 | ice_skating_field_condition | 2021-01-04T13:11:35.470065+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
50937 | 39903 | ice_skating_field_condition | 2021-01-04T13:25:02.327344+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable |
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 );