Version History of Utilized Agricultural Area by Municipality Fact Data from Luke in Finland
Click here for a data sample
This table contains the version history of rows from the utilized agricultural area by municipality fact table. Each row in this table represents a specific version of a row from the base table. The version history is tracked using the '_start_date' and '_end_date' columns. The '_start_date' column indicates the date when the row was extracted from the data source, while the '_end_date' column indicates the date when a new version of the row was extracted from the data source. If the value of the '_end_date' column is null, it means that the row is the most recent version. The table includes additional columns such as '_row_number', 'year', 'municipality', 'variable', 'species', and 'utilized_agricultural_area', which contain various information related to the utilized agricultural area by municipality. This data can be utilized in data analytics to analyze the changes in utilized agricultural areas over time, compare agricultural productivity across municipalities, study the impact of different variables and species on the agricultural area, and more. The data in this table is sourced from the website of 'Luke', which is an agricultural research and innovation organization. The organization is based in Finland (ISO country code: 'fi').
Field Descriptions
Name |
Data type |
Description |
_start_date | date | The start date indicating the validity period of the row version |
_end_date | date | The end date indicating the validity period of the row version |
_row_number | long | The numeric identifier for the row version |
year | int | The year associated with the data |
municipality | int | The name of the municipality |
variable | string | The variable representing the data type |
species | string | The species related to the data |
utilized_agricultural_area | int | The value indicating the utilized agricultural area |