Information Needs in Agricultural and Horticultural Enterprises by Production Sector

This dataset collection contains information on the need for new information in agricultural and horticultural enterprises, categorized by production sector. The data tables are sourced from the Luke website in Finland.

Tables

Need for New Information in Agricultural and Horticultural Enterprises by Production SectorTSV
This table contains information about the need for new information in agricultural and horticultural enterprises by production sector. The data is sourced from the website of Luke, which originates from Finland.
Need for New Information in Agricultural and Horticultural Enterprises by Production SectorTSV
This table contains information about the need for new information in agricultural and horticultural enterprises by production sector. The data is sourced from the web site of Luke, which originates from Finland (ISO country code: FI). The table includes columns such as 'extract date', 'row number', 'year', 'production sector', 'sector with the greatest need for information', and 'need for new information in agricultural and horticultural enterprises'. The data in this table can be utilized in data analytics to analyze the trends and patterns of information needs in different agricultural and horticultural production sectors over time. It can also be used to identify the sectors that require the most attention and resources for providing relevant and up-to-date information.
Version History of Need for New Information in Agricultural and Horticultural Enterprises by Production SectorTSV
This table contains the version history of the rows from the 'need_for_new_information_in_agricultural_and_horticultural_enterprises_by_production_sector__dim_production_sector' table. The rows in this table represent the different versions of the data extracted from the data source. The '_start_date' column indicates the date when a particular version of the row was extracted, while the '_end_date' column indicates the date when a new version of the row was extracted. If the value of the '_end_date' column is null, it means that the row is the most recent version of the data. The table is sourced from the web site of 'Luke', which originates from Finland (ISO country code: FI). This historical version information can be utilized in data analytics to track changes over time, identify...
Version History of Need for New Information in Agricultural and Horticultural Enterprises by Production SectorTSV
This table contains the version history of the rows in the 'Need for New Information in Agricultural and Horticultural Enterprises by Production Sector - Fact' table. It provides information about the need for new information in agricultural and horticultural enterprises across different production sectors. The table includes columns such as '_start_date' which represents the date when the row was extracted, and '_end_date' which represents the date when a new version of the row was extracted. The 'year' column represents the year of the data, while 'production_sector' indicates the specific sector of production. The column 'sector_with_the_greatest_need_for_information' identifies the sector with the highest need for information. Additionally, the...

Column Descriptions

Need for New Information in Agricultural and Horticultural Enterprises by Production Sector

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The sequential number assigned to each row in the table.
code	int	A unique code assigned to each record.
label	string	The label or name associated with each record.

Version History of Need for New Information in Agricultural and Horticultural Enterprises by Production Sector

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	The unique identifier for each row version.
code	int	The code associated with the row version.
label	string	The label associated with the row version.

Need for New Information in Agricultural and Horticultural Enterprises by Production Sector

Column	Type	Comment
_extract_date	date	The date when the data was extracted from the table.
_row_number	long	Unique identifier for each row in the table.
year	int	The year of the data recorded.
production_sector	int	The sector in which the production occurred.
sector_with_the_greatest_need_for_information	string	The sector that has the highest requirement for information.
need_for_new_information_in_agricultural_and_horticultural_enterprises	int	The need for new information in agricultural and horticultural enterprises.

Version History of Need for New Information in Agricultural and Horticultural Enterprises by Production Sector

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 in the version history table.
year	int	The year corresponding to the data in the row version.
production_sector	int	The sector of production to which the data in the row version belongs.
sector_with_the_greatest_need_for_information	string	The sector with the greatest need for information based on the data in the row version.
need_for_new_information_in_agricultural_and_horticultural_enterprises	int	The need for new information in agricultural and horticultural enterprises based on the data in the row version.

Additional Info

Last Updated	April 20, 2025
Created	October 2, 2023