Version History of Land Use on Agricultural and Horticultural Enterprises
Click here for a data sample
This table contains the version history of the rows in the 'land_use_on_agricultural_and_horticultural_enterprises__fact' table. The table is sourced from the website of Luke, which originates from the country Finland (ISO country code 'FI'). It includes columns such as '_start_date', '_end_date', 'year', 'ely_centre', 'production_sector', 'variable', 'land_use', and 'agricultural_and_horticultural_enterprises'. The '_start_date' column represents the date when a row was extracted from the data source, while the '_end_date' column represents the date when a new version of the row was extracted. If the value of the '_end_date' column is null, it indicates that the row is the most recent version. The data in this table can be utilized in various data analytics scenarios, such as studying the historical trends of land use in agricultural and horticultural enterprises over time, analyzing production sectors and variables related to land use, and conducting regional analysis based on 'ely_centre' values.
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 unique identifier for each row version. |
|---|
| year | int | The year of the data entry. |
|---|
| ely_centre | int | The region or center for which the data is recorded. |
|---|
| production_sector | int | The sector of production to which the data belongs. |
|---|
| variable | string | The specific data variable being recorded. |
|---|
| land_use | string | The type of land use associated with the data entry. |
|---|
| agricultural_and_horticultural_enterprises | int | The number of agricultural and horticultural enterprises recorded for the given data entry. |
|---|
