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

Agricultural Area Cultivated with the Same Crop by Region in Finland

This dataset collection consists of one or more dataset tables sourced from the website of 'Luke' in Finland. It provides information about agricultural areas cultivated with the same crop by region. The tables in this collection contain data related to various regions within Finland and the specific crops cultivated in those areas. The dataset collection offers valuable insights into the agricultural practices and crop distribution across different regions in Finland.

Tables

  • Agricultural Area Cultivated with the Same Crop by RegionTSV

    This table contains data from the agricultural sector in Finland. It provides information on the agricultural area cultivated with the same crop by region. The data includes details such as the extract date, row number, year, ELY centre, and additional information. The 'agricultural_area_cultivated_with_the_same_crop' column represents the area of agricultural land dedicated to specific crops in each region. This table can be utilized in various data analytics scenarios, such as studying trends in crop cultivation over time, analyzing regional differences in agricultural practices, and identifying patterns in crop production based on extract dates. The data is sourced from the website of 'Luke', which is the Natural Resources Institute Finland.

  • Agricultural Area Cultivated with the Same Crop by Region InformationTSV

    This dataset provides information about the agricultural area cultivated with the same crop by region. It is sourced from the web site of Luke, which originates from Finland (country code: FI). The table contains data on the extract date, row number, code, and label. The data in this table can be utilized in various data analytics scenarios, such as analyzing the distribution of cultivated agricultural areas across different regions, identifying trends in crop cultivation over time, and comparing the cultivation patterns of different crops in specific regions.

  • Agricultural Areas Cultivated with the Same Crop by Region in Ely CentreTSV

    This table contains information on agricultural areas cultivated with the same crop by region from the data source 'Luke'. The data is sourced from the website of Luke, which originates from the country Finland (ISO country code 'fi'). The table includes columns such as '_extract_date' which represents the date the data was extracted, '_row_number' indicating the row number of the data, 'code' representing the code of the region, and 'label' providing the label or name of the region. This table can be used for data analytics to analyze the distribution and trends of agricultural areas cultivated with the same crop across different regions in Finland.

  • Crop Cultivated Area by Region and YearTSV

    This table contains data on the agricultural areas cultivated with the same crop by region and year in Finland. The data is sourced from the web site of Luke, which is a Finnish research institute focusing on natural resources and the bioeconomy.

  • Version History of Agricultural Area Cultivated with the Same Crop by Region - Dimensional Information - Luke - FinlandTSV

    This table contains the version history of agricultural areas cultivated with the same crop by region, along with additional dimension information. The data in this table is sourced from the 'Luke' website, which originates from Finland (ISO country code 'fi'). It is a historical record of the cultivated agricultural areas, indicating the start and end dates of each version. The '_start_date' column shows the date when a particular version of 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. If the '_end_date' value is null, it means that the row is the most recent version. This table provides valuable data for various data analytics purposes, such as analyzing the changes in agricultural cultivation...

  • Version History of Agricultural Area Cultivated with the Same Crop by Region and Year - Luke (Finland)TSV

    This table contains the version history of the base table 'agricultural_area_cultivated_with_the_same_crop_by_region__dim_year'. It tracks the changes made to the base table rows over time. The table includes columns for '_start_date' and '_end_date', which indicate the start and end dates of each version of the rows. Additionally, the table has columns for '_row_number', 'code', and 'label'. While the table does not provide a description of these individual columns, it can be utilized in data analytics to analyze the historical changes in agricultural area cultivated with the same crop by region and year. For example, it can be used to track trends and patterns in agricultural practices across different regions and years. The data in this table is sourced from the web site of 'Luke',...

  • Version History of Agricultural Area Cultivated with the Same Crop by Region Fact (Luke - Finland)TSV

    This table contains the version history of the rows in the 'agricultural_area_cultivated_with_the_same_crop_by_region__fact' table. The rows in this table represent the agricultural area cultivated with the same crop by region and its historical changes over time. Each row has two additional columns compared to the base table: '_start_date' and '_end_date', which indicate the period when the row was extracted from the source. If the '_end_date' column has a null value, it signifies that the row is the most recent version. The table's data is sourced from Luke, which is an agricultural research organization in Finland (ISO country code: FI). The data in this table can be utilized for various data analytics purposes, such as analyzing trends in agricultural area cultivated with the same...

  • Version History of Agricultural Area Cultivated with the Same Crop by Region in Ely Centre from Luke (Finland)TSV

    This table contains the version history of the rows from the 'agricultural_area_cultivated_with_the_same_crop_by_region__dim_ely_centre' table. It includes additional columns '_start_date' and '_end_date' to indicate the extraction dates of each row. The data in this table is sourced from the 'Luke' website, which originates from Finland (ISO country code: 'fi'). The table can be utilized in data analytics to track changes in the agricultural areas cultivated with the same crop by region over time. By analyzing the start and end dates, trends and patterns in agricultural cultivation can be identified. This information can be valuable for studying the evolution of crop cultivation practices, understanding regional variations, and predicting future crop trends.

Column Descriptions

Agricultural Area Cultivated with the Same Crop by Region

Column Type Comment
_extract_date date The date when the information was extracted.
_row_number long The row number of the data entry.
year string The year of the data entry.
ely_centre int The geographical center of the ELY (Centres for Economic Development, Transport and the Environment) region.
info string Additional information related to the data entry.
agricultural_area_cultivated_with_the_same_crop int The area of agricultural land that is cultivated with the same crop.

Version History of Agricultural Area Cultivated with the Same Crop by Region Fact (Luke - Finland)

Column Type Comment
_start_date date This column indicates the start date of the validity period of a row version in the table. It is used to track when the row version became active.
_end_date date This column indicates the end date of the validity period of a row version in the table. It is used to track when the row version expires.
_row_number long This column represents the unique identifier assigned to each row version in the table.
year string This column stores the year information related to the data represented by a row version.
ely_centre int This column contains information about the ELY centre associated with the row version.
info string This column stores additional information or details related to the row version.
agricultural_area_cultivated_with_the_same_crop int This column stores the size or area of agricultural land cultivated with the same crop for the row version.

Agricultural Areas Cultivated with the Same Crop by Region in Ely Centre

Column Type Comment
_extract_date date This column represents the date when the data was extracted from its source.
_row_number long This column represents the sequence number of each row in the table.
code int This column stores the unique code assigned to each entry in the table.
label string This column stores the label or name associated with each entry in the table.

Version History of Agricultural Area Cultivated with the Same Crop by Region in Ely Centre from Luke (Finland)

Column Type Comment
_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 A unique number assigned to each row version.
code int The code associated with the row version.
label string The label associated with the row version.

Crop Cultivated Area by Region and Year

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The unique identifier of a row in the table.
code string The code assigned to a particular item or label.
label string The description or name of a particular item.

Version History of Agricultural Area Cultivated with the Same Crop by Region and Year - Luke (Finland)

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 The unique number assigned to each row version.
code string The code associated with the row version.
label string The label associated with the row version.

Agricultural Area Cultivated with the Same Crop by Region Information

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long A unique row number assigned to each entry.
code string A code representing a specific category or label.
label string The corresponding label or name for the given code.

Version History of Agricultural Area Cultivated with the Same Crop by Region - Dimensional Information - Luke - Finland

Column Type Comment
_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 An additional column indicating the row number of the version in the history.
code string A column storing a code associated with the row version.
label string A column storing a label associated with the row version.

Additional Info

Last Updated May 20, 2024
Created October 2, 2023