Agricultural Enterprises by Business Size in Finland

This dataset collection contains information about agricultural enterprises in Finland. The collection includes one or more dataset tables sourced from the website of Luke, the Natural Resources Institute Finland. Luke provides comprehensive data on agricultural businesses in the country. The dataset collection provides insights into the size of agricultural enterprises, their business operations, and related information essential for understanding the agricultural sector in Finland.

Tables

Agricultural Enterprises by Business SizeTSV
This table contains information about agricultural enterprises by business size in Finland. The data is sourced from 'Luke' website, which is the Natural Resources Institute Finland. The table provides details such as the extraction date, row number, code, and label of the different business sizes. This data can be utilized in various data analytics scenarios, for example, to analyze the distribution of agricultural enterprises across different business sizes, identify trends in the growth or decline of specific business sizes over time, or compare the performance of agricultural enterprises based on their business size.
Agricultural Enterprises by Business Size (Year-wise)TSV
This table contains data about agricultural enterprises by business size and year. The data is sourced from the website of Luke, which originates from Finland (ISO country code: FI). The table includes columns such as 'extract date', 'row number', 'code', and 'label'. The data in this table can be utilized in data analytics to analyze the distribution and growth of agricultural enterprises by business size over the years, identify trends and patterns in the agricultural industry, and compare the performance of different business sizes within the sector.
Agricultural Enterprises by Business Size - Dim Urban/Rural ClassificationTSV
This table contains data on agricultural enterprises by business size and urban/rural classification. It is sourced from 'Luke', the Natural Resources Institute Finland website, which originates from the country with the ISO country code 'Finland'. The table provides information on various agricultural enterprises and their corresponding codes and labels. The data in this table can be utilized for various data analytics purposes, such as analyzing the distribution of agricultural enterprises across different urban and rural areas, analyzing the trends in business sizes within the agricultural sector, and identifying patterns or correlations between business size and urban/rural classification.
Agricultural Enterprises by Business Size - Fact TableTSV
This table contains data on agricultural enterprises by business size in Finland. The data is sourced from the website of Luke (Natural Resources Institute Finland). The table provides information on the extract date, row number, year, size class, urban-rural classification, data, and the number of agricultural enterprises. The data in this table can be utilized in data analytics to analyze the distribution of agricultural enterprises by business size and location, to study trends in the agricultural sector over time, and to generate insights into the characteristics and dynamics of agricultural businesses in Finland.
Agricultural Enterprises by Business Size Data from Luke in FinlandTSV
This table contains data related to agricultural enterprises categorized by business size. The data is sourced from the website of Luke, which is an organization based in Finland (ISO country code: FI). The table includes information such as the extract date, row number, code, and label. The data in this table can be utilized in various data analytics scenarios, such as understanding the distribution of agricultural enterprises by business size, analyzing trends over time, and comparing the performance of different enterprises based on their business size.
Version History of Agricultural Enterprises by Business SizeTSV
The table contains the version history of the agricultural enterprises by business size, categorized by different size classes. It is sourced from the web site of Luke, which originates from the country Finland (ISO country code 'FI'). The table includes the start date, end date, row number, code, and label columns. The start date indicates when a particular version of a row was extracted from the data source, while the end date represents the date when a new version of the row was extracted. If the end date is null, it means the row is the most recent version. This table provides valuable information for data analytics, such as analyzing trends in agricultural enterprise sizes over time, comparing the distribution of enterprises across size classes, and tracking changes in the labels...
Version History of Agricultural Enterprises by Business Size (Year Level) in Finland (Source: Luke)TSV
This table contains the version history of agricultural enterprises by business size over different years. It is sourced from the website of Luke, which originates from the country Finland (ISO country code: FI). The table includes columns '_start_date' and '_end_date' that indicate the extraction dates of each row from the data source. The 'code' column represents a unique identifier for each agricultural enterprise, while the 'label' column provides a label or description for each enterprise. This table can be utilized in data analytics to analyze trends and changes in agricultural enterprise sizes over time, to compare the growth rates of different business sizes, or to identify the most recent version of each agricultural enterprise's data. By examining the extraction dates, it is...
Version History of Agricultural Enterprises by Business Size - sourced from Luke (Finland)TSV
This table contains the version history of the rows from the 'Agricultural Enterprises by Business Size Fact' table. Each row represents a specific version of the data extracted from the data source. The '_start_date' column indicates the date when the row was extracted, while the '_end_date' column indicates the date when a new version of the row was extracted. If the '_end_date' is null, it means that the row is the most recent version. The data in this table can be utilized in various data analytics applications. For example, it can be used to analyze the changes in the number of agricultural enterprises over time based on different business sizes and urban-rural classifications. It can also be used to track the data quality and consistency over time. The source of the data in this...
Version History of Agricultural Enterprises by Business Size Data from Luke (Finland)TSV
This table contains the version history of the rows in the 'Agricultural Enterprises by Business Size' table, sourced from the website of 'Luke' from Finland. It provides information on the start and end dates of each version, as well as a row number, code, and label. The table can be utilized in data analytics to track changes in the business sizes of agricultural enterprises over time, identify trends and patterns, and compare the distribution of enterprises across different sizes. By analyzing the historical versions, researchers and analysts can gain valuable insights into the evolution of the agricultural sector in Finland.
Version History of Agricultural Enterprises by Business Size in Urban/Rural Classification sourced from Luke (Finland)TSV
This table provides the version history of agricultural enterprises by business size and dimension of urban-rural classification. It contains the start and end dates for each row, along with a unique row number, a code, and a label. The data in this table can be utilized in data analytics to analyze the changes in agricultural enterprises over time and their distribution across different urban-rural classifications. It is sourced from the web site of 'Luke' which originates from the country 'Finland' (ISO country code: 'FI').

Column Descriptions

Agricultural Enterprises by Business Size

Column	Type	Comment
_extract_date	date	The date when the data was extracted from the source.
_row_number	long	The unique identifier assigned to each row in the table.
code	string	The unique code or identifier associated with a specific element.
label	string	The descriptive label or name given to a specific element.

Version History of Agricultural Enterprises by Business Size

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 identifier of the row version
code	string	The code associated with the row version
label	string	The label associated with the row version

Agricultural Enterprises by Business Size - Dim Urban/Rural Classification

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	string	A code that identifies a specific item or entity.
label	string	A descriptive label or name for a specific item or entity.

Version History of Agricultural Enterprises by Business Size in Urban/Rural Classification sourced 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 of the row version.
code	string	The code associated with the row version.
label	string	The label associated with the row version.

Agricultural Enterprises by Business Size Data from Luke in Finland

Column	Type	Comment
_extract_date	date	The date on which the data was extracted.
_row_number	long	The row number of the record.
code	string	The code associated with a label.
label	string	The label for a particular code.

Version History of Agricultural Enterprises by Business Size Data 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	The row number of the version history entry.
code	string	The code associated with the row version.
label	string	The label associated with the row version.

Agricultural Enterprises by Business Size (Year-wise)

Column	Type	Comment
_extract_date	date	The date when the data was extracted from the source system.
_row_number	long	The numbering of each row in the table.
code	int	The code assigned to an entity or item.
label	int	The label or name associated with a code.

Version History of Agricultural Enterprises by Business Size (Year Level) in Finland (Source: Luke)

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 identifier for each row version.
code	int	The code associated with the row version.
label	int	The label or name assigned to the row version.

Agricultural Enterprises by Business Size - Fact Table

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.
year	int	The year for which the data is recorded.
size_class	string	The size classification of a certain entity.
urbanrural_classification	string	The classification of an area as urban or rural.
data	string	The numerical data value.
agricultural_enterprises	int	The number of agricultural enterprises recorded for a certain category.

Version History of Agricultural Enterprises by Business Size - sourced 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 version.
year	int	The year associated with the row version.
size_class	string	The classification of the size of the row version.
urbanrural_classification	string	The classification of urban or rural for the row version.
data	string	The data stored in the row version.
agricultural_enterprises	int	The number of agricultural enterprises for the row version.

Additional Info

Last Updated	May 20, 2024
Created	September 29, 2023