Version History of Forestry Land Ownership (1000 ha) in Finland (Luke)
Click here for a data sample
The table 'ownership_of_forestry_land_1000_hafacthistory' contains the version history of rows from the base table 'ownership_of_forestry_land_1000_ha__fact'. The table has two additional columns compared to its base table: '_start_date' and '_end_date'. The column '_start_date' stores the date when a row was extracted from the data source. The column '_end_date' stores the date when a new version of the row was extracted. If the value of the column '_end_date' is null, it indicates that the row is the most recent version. This table provides a historical record of the ownership of forestry land measured in thousands of hectares. It includes information such as the inventory, region, ownership category, and the actual land ownership. The table can be utilized in data analytics for various purposes such as trend analysis, tracking changes in land ownership over time, evaluating the distribution of forestry land across regions, and identifying patterns or patterns of ownership categories over specific periods. The data in this table is sourced from the website of 'Luke', which is an organization from Finland (ISO country code: 'fi').
Field Descriptions
Name |
Data type |
Description |
_start_date | date | The start date of the validity period for the row version. |
_end_date | date | The end date of the validity period for the row version. |
_row_number | long | The row number of the version history entry. |
inventory | int | The inventory value of the row version. |
region | timestamp | The region value of the row version. |
ownership_category | string | The ownership category of the row version. |
ownership_of_forestry_land_1000_ha | int | The ownership of forestry land in 1000 hectares of the row version. |