To download the data set, please sign up or log in

Average Utilised Agricultural Area of Agricultural and Horticultural Enterprises in Finland

This dataset collection contains information about the average utilised agricultural area of agricultural and horticultural enterprises in Finland. The tables in this collection are sourced from the website of Luke, which is the Natural Resources Institute Finland. Luke provides data on the agricultural and horticultural sector in Finland, including details about the average utilised agricultural area. This dataset collection offers valuable insights into the land usage patterns and productivity of agricultural and horticultural enterprises in Finland.

Tables

  • Average Utilised Agricultural Area of Agricultural and Horticultural EnterprisesTSV

    This table contains the average utilised agricultural area of agricultural and horticultural enterprises. The data is sourced from 'Luke', which is an organization in Finland. It provides information on the average utilised agricultural area for different years in various ELY centres. The table includes information on the specific year, ELY centre, and the average utilised agricultural area of agricultural and horticultural enterprises. This data can be utilized for data analytics purposes to analyze trends and patterns in agricultural land use over time, identify regional variations in agricultural area utilization, and conduct comparative analysis of agricultural and horticultural enterprises across different ELY centres in Finland.

  • Average Utilised Agricultural Area of Agricultural and Horticultural Enterprises (History)TSV

    This table provides the version history of the average utilised agricultural area of agricultural and horticultural enterprises. It contains the extracted rows from the data source 'Luke' which originates from Finland. The rows in this table represent different versions of the base table 'average_utilised_agricultural_area_of_agricultural_and_horticultural_enterprises__fact'. The 'year', 'ely_centre', 'variable', and 'average_utilised_agricultural_area_of_agricultural_and_horticultural_enterprises' columns contain data related to agricultural and horticultural enterprises. The '_start_date' column indicates the date when each 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 '_end_date'...

  • Average Utilised Agricultural Area of Agricultural and Horticultural Enterprises - DIM ELY CentreTSV

    This table contains data on the average utilised agricultural area of agricultural and horticultural enterprises in the Ely Centre region. The data is sourced from the website of Luke, a research and innovation organization in Finland (ISO country code: FI). The table includes information such as extract date, row number, code, and label. This data can be utilized in various data analytics applications, such as analyzing trends in the agricultural and horticultural sector, comparing the utilization of agricultural areas between different regions, and identifying patterns or correlations between the average utilised area and other factors such as crop yield or economic indicators.

  • Average Utilized Agricultural Area of Agricultural and Horticultural EnterprisesTSV

    This table contains data on the average utilised agricultural area of agricultural and horticultural enterprises. The data is sourced from the website of Luke, which originates from Finland (ISO country code: FI). The table includes columns such as 'extract_date', 'row_number', 'code', and 'label'. The data in this table can be used for various data analytics purposes, such as analyzing trends in agricultural and horticultural land utilization, comparing the average area across different enterprises, and identifying geographical patterns in agricultural practices.

  • Average Utilized Agricultural Area of Agricultural and Horticultural Enterprises by YearTSV

    This table contains average utilised agricultural area of agricultural and horticultural enterprises data. It is sourced from the website of Luke, which originates from Finland (ISO country code: FI). The table provides information about the average area utilized by agricultural and horticultural enterprises. The data in this table can be utilized in various data analytics tasks such as analyzing trends in agricultural land usage, identifying patterns in the allocation of agricultural resources, comparing the utilization of agricultural land across different regions or years, and examining the relationship between agricultural land usage and other economic or environmental factors. By analyzing this data, insights can be gained to inform decision-making and policy formulation related to...

  • Version History of Average Utilised Agricultural Area of Agricultural and Horticultural EnterprisesTSV

    This table contains the historical version history of the rows from the 'average_utilised_agricultural_area_of_agricultural_and_horticultural_enterprises__dim_variable' table. The rows in this table represent different versions of the data extracted from the web site of 'Luke', which originates from Finland. Each row has additional columns '_start_date' and '_end_date', indicating the extraction dates of the respective row versions. The '_start_date' column contains the date when the row was extracted, while the '_end_date' column contains the date when a new version of the row was extracted. If 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 tracking the historical...

  • Version History of Average Utilised Agricultural Area of Agricultural and Horticultural Enterprises - Dim Ely CentreTSV

    This table contains the version history of the average utilised agricultural area of agricultural and horticultural enterprises in Ely Centre. The data is sourced from Luke, which is a web site originating from Finland (ISO country code: FI). The table includes information about the starting date and ending date of each version, as well as a row number, code, and label for each entry. The table can be utilized in data analytics to track changes in the average utilised agricultural area over time, analyze trends, and compare differences between different versions.

  • Version History of Average Utilised Agricultural Area of Agricultural and Horticultural Enterprises by Year in Finland (Luke)TSV

    This table contains the version history of the average utilised agricultural area of agricultural and horticultural enterprises, categorized by year. It is sourced from the Luke website, which originates from Finland (ISO country code 'fi'). The table includes information related to the start and end dates of each version, along with a row number, code, and label. The '_end_date' column is null for the most recent version of each row. The data in this table can be utilized for various data analytics purposes, such as analyzing changes in the agricultural area over time, identifying trends in utilization, and comparing different years' data to understand patterns and fluctuations in agricultural land usage in Finland.

Column Descriptions

Average Utilised Agricultural Area of Agricultural and Horticultural Enterprises

Column Type Comment
_extract_date date The date on which the data was extracted from the source system.
_row_number long The sequential number of the row in the table.
year int The year for which the data is recorded.
ely_centre int The European Level of the Ely Centre that represents a geographical area.
variable string The specific variable or measurement being recorded.
average_utilised_agricultural_area_of_agricultural_and_horticultural_enterprises int The average area of land utilized by agricultural and horticultural enterprises.

Average Utilised Agricultural Area of Agricultural and Horticultural Enterprises (History)

Column Type Comment
_start_date date The start date of the validity period of the row version.
_end_date date The end date of the validity period of the row version.
_row_number long A unique identifier for each row version.
year int The year of the data recorded.
ely_centre int The center code of the ELY (Centre for Economic Development, Transport and the Environment) where the data is applicable.
variable string The name of the variable or data being recorded.
average_utilised_agricultural_area_of_agricultural_and_horticultural_enterprises int The average area of agricultural and horticultural enterprises that is utilized for agricultural activities.

Average Utilised Agricultural Area of Agricultural and Horticultural Enterprises - DIM ELY Centre

Column Type Comment
_extract_date date The date when the data was extracted from the source
_row_number long The unique identifier for each row in the table
code int The code assigned to a specific item or entity
label string The descriptive label or name for a specific item or entity

Version History of Average Utilised Agricultural Area of Agricultural and Horticultural Enterprises - Dim Ely Centre

Column Type Comment
_start_date date This column stores the start date of the validity period for the row version in the table.
_end_date date This column stores the end date of the validity period for the row version in the table.
_row_number long This column stores the unique identifier of each row version in the table.
code int This column stores the code associated with the row version in the table.
label string This column stores the label associated with the row version in the table.

Average Utilized Agricultural Area of Agricultural and Horticultural Enterprises

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long An auto-incrementing row number for each record.
code string A unique code assigned to each item.
label string A descriptive label for each item.

Version History of Average Utilised Agricultural Area of Agricultural and Horticultural Enterprises

Column Type Comment
_start_date date This column indicates the start date of the validity period of the row version.
_end_date date This column indicates the end date of the validity period of the row version.
_row_number long This column represents the unique identifier of each row version in the table.
code string This column contains the code associated with the row version.
label string This column contains the label or name associated with the row version.

Average Utilized Agricultural Area of Agricultural and Horticultural Enterprises by Year

Column Type Comment
_extract_date date The date when the row was extracted from the source
_row_number long The unique identifier of each row
code int The code associated with the label
label int The label of a specific item

Version History of Average Utilised Agricultural Area of Agricultural and Horticultural Enterprises by Year in Finland (Luke)

Column Type Comment
_start_date date The start date of the validity period for this row version.
_end_date date The end date of the validity period for this row version.
_row_number long A unique identifier for each row version.
code int The code associated with this row version.
label int The label associated with this row version.

Additional Info

Last Updated May 20, 2024
Created September 29, 2023