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

Open Field Production Dataset Collection

This dataset collection contains tables sourced from the web site of Luke, the Natural Resources Institute Finland, located in Finland. It consists of one or more tables related to open field production.

Tables

  • Open Field Production Facts from Luke (Finland)TSV

    This table contains open field production data sourced from the website of Luke, which originates from Finland. The table consists of various columns such as '_extract_date', '_row_number', 'year', 'variable', 'plant_group', and 'openfield_production'. The data in this table can be used for various data analytics tasks, such as analyzing the annual open field production trends for different variables and plant groups, identifying the highest and lowest production values for a specific year, comparing the production of different plant groups over time, and examining the correlation between variables and open field production. These insights can be valuable for agricultural research, market analysis, and decision-making related to open field production in Finland.

  • Open Field Production Plant Group (Luke - Finland)TSV

    This table contains data from the 'Luke' website in Finland, with the purpose of providing open field production information categorized by plant groups. The data includes the extraction date, row number, plant group code, and corresponding label. It can be utilized for various data analytics purposes, such as analyzing trends in plant group production over time, identifying the most common plant groups cultivated, or comparing production quantities between different plant groups.

  • Version History of Open Field Plant Group Production Data from Luke (Finland)TSV

    This table contains the version history of the rows from the base table 'open_field_production__dim_plant_group'. Each row in this table represents a specific version of a row from the base table and includes additional information about the start date and end date of the version. The '_start_date' column stores the date when this particular version of the row was extracted from the data source, while the '_end_date' column stores the date when a new version of the row was extracted. If the value in the '_end_date' column is null, it indicates that the row is the most recent version. The rows in this table can be utilized in various data analytics scenarios, such as tracking changes in plant group information over time, identifying trends in code and label modifications, and analyzing...

  • Version History of Open Field Production Data in FinlandTSV

    This table contains the version history of the rows extracted from the 'Luke' website's base table, which originates from Finland. The table includes columns such as '_start_date' and '_end_date', which represent the extraction dates of each row. The other columns in the table ('_row_number', 'year', 'variable', 'plant_group', 'openfield_production') contain data related to open field production. The table can be utilized in data analytics to analyze trends and changes in open field production over time. For example, it can be used to compare production levels of different plant groups or to track production changes in specific years. The table provides valuable insights into the historical data of open field production and allows for in-depth analysis of the factors affecting the...

Column Descriptions

Open Field Production Plant Group (Luke - Finland)

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The row number of the record in the dataset.
code string The code associated with a specific item.
label string The label or name of a specific item.

Version History of Open Field Plant Group Production Data from 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 number assigned to each row in the version history table.
code string The code associated with the row version.
label string The label associated with the row version.

Open Field Production Facts from Luke (Finland)

Column Type Comment
_extract_date date The date when the data was extracted from the source.
_row_number long A unique identifier for each row in the table.
year int The year when the data was recorded.
variable string The specific variable or metric being measured or recorded.
plant_group string The group or classification of plants to which the data refers.
openfield_production int The quantity or volume of production generated by open field agriculture.

Version History of Open Field Production Data in Finland

Column Type Comment
_start_date date The start date of the validity period for a row version.
_end_date date The end date of the validity period for a row version.
_row_number long A unique identifier for each row version in the table.
year int The year corresponding to the data in the row.
variable string The specific variable associated with the data in the row.
plant_group string The group or category of plants to which the data in the row belongs.
openfield_production int The production value or quantity associated with the open field crops in the row.

Additional Info

Last Updated May 20, 2024
Created October 2, 2023