Open Field Production Dataset Collection
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 |