1. Home
  2. Datasets
  3. Yield of the Main Crops in ...
To download the data set, please sign up or log in

Yield of the Main Crops in Finland

This dataset collection contains information about the yield of the main crops. The tables within this collection are sourced from the website of Luke (Natural Resources Institute Finland), which is located in the country of Finland. The dataset provides valuable insights into the agricultural production and performance of various crops in Finland.

Tables

  • Version History of Yield of Main Crops in Finland from Luke WebsiteTSV

    This table contains the version history of the rows from the 'yield_of_the_main_cropsfact' table. It provides information about the date when each version of the rows was extracted from the data source. The table includes historical data for various years and locations related to the yields of the main crops. The 'yield_of_the_main_cropsfact__history' table can be used for data analytics and trend analysis to understand the changes in crop yields over time. It is sourced from the 'Luke' website, which is an agricultural data source originating from Finland (ISO country code: FI).

  • Version History of Yield of the Main Crops by Year - Data Source: Luke (Finland)TSV

    This table contains the version history of the rows from the base table 'yield_of_the_main_crops__dim_year'. Each row in this table corresponds to a specific version of a row in the base table, denoted by the extraction date. The '_start_date' column represents the date when the version of the row was extracted from the data source. The '_end_date' column indicates the date when a new version of the row was extracted. If the value in the '_end_date' column is null, it means that the row is the most recent version. In addition to the base table columns, this table also includes the '_row_number' column, which represents the number of the row in this version history table, the 'code' column, which contains a specific code related to the crops, and the 'label' column, which provides a...

  • Yield of Main Crops by YearTSV

    This table contains information about the yield of the main crops. The data is sourced from the website of Luke, which is the Natural Resources Institute Finland. The data originates from Finland (ISO country code 'fi'). The table includes the following columns: '_extract_date', '_row_number', 'code', and 'label'. The '_extract_date' column represents the date when the data was extracted. The '_row_number' column is a unique identifier for each record in the table. The 'code' column contains codes assigned to specific crops. The 'label' column provides the corresponding labels or names for each crop. This table can be utilized in various data analytics scenarios, such as analyzing the yield trends of different crops over time, comparing the yield of different crops in a specific year,...

  • Yield of Main Crops in FinlandTSV

    This database table contains data on the yield of the main crops in Finland. The data is sourced from the website of Luke, which is the Natural Resources Institute Finland. The table includes information such as the extraction date, row number, year, ELY centre, variable, species, and the yield of the main crops. The data in this table can be utilized for various data analytics purposes such as analyzing trends in crop yields over time, comparing yields across different ELY centres or species, and conducting statistical analyses to identify factors influencing crop yield.

Column Descriptions

Yield of Main Crops in Finland

Column Type Comment
_extract_date date The date when the row was extracted from the table.
_row_number long The number assigned to each row in the table.
year int The year of the data entry.
ely_centre int The geographical center of the Ely area associated with the data.
variable string The variable being measured or recorded.
species string The species of interest.
yield_of_the_main_crops int The yield of the main crops in the specified area and year.

Version History of Yield of Main Crops in Finland from Luke Website

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 assigned to each row version.
year int The year of the data for the row version.
ely_centre int The geographic area or centre associated with the row version.
variable string The type or category of the data for the row version.
species string The species or group of plants/animals for the row version.
yield_of_the_main_crops int The yield or production of the main crops for the row version.

Yield of Main Crops by Year

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The unique identifier for each row in the table.
code int The code associated with a particular label.
label int The label associated with a particular code.

Version History of Yield of the Main Crops by Year - Data Source: 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 number assigned to each row version to identify its order in the version history.
code int The code associated with the row version.
label int The label or name of the row version.

Additional Info

Last Updated May 20, 2024
Created September 29, 2023