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

Number of Farms Engaged in Direct Sales in Finland

This dataset collection consists of one or more tables sourced from Luke, the Natural Resources Institute Finland. It provides information on the number of farms engaged in direct sales in Finland.

Tables

  • Historical Version History of Number of Farms Engaged in Direct Sales by Year in FinlandTSV

    This table contains the version history of the rows from the 'number_of_farms_engaged_in_direct_sales__dim_year' base table. The rows in this table represent the changes made to the base table over time, indicated by the '_start_date' and '_end_date' columns. The data in this table is sourced from 'Luke', a website originated from Finland (ISO country code 'fi'). This table can be used in data analytics to track the changes in the number of farms engaged in direct sales over time, analyze the impact of different factors on farm sales, and identify trends and patterns in direct sales by farms.

  • History of Number of Farms Engaged in Direct Sales - Ely Centre (Luke - Finland)TSV

    This table contains the version history of the 'number_of_farms_engaged_in_direct_sales__dim_ely_centre' table. It includes additional columns '_start_date' and '_end_date' for each row to indicate the extraction dates from the data source. The data in this table is sourced from the website of 'Luke', an organization from Finland (ISO country code: 'fi'). The table provides valuable information for data analytics, allowing analysts to track changes and trends over time. With the version history, one can analyze the evolution of the number of farms engaged in direct sales in different regions represented by the 'code' column. The 'label' column provides descriptive labels for each region. By comparing rows with different dates, analysts can examine the growth or decline of direct sales...

  • Number of Farms Engaged in Direct SalesTSV

    This table contains information about the number of farms engaged in direct sales in Finland. The data is sourced from Luke, which is the Natural Resources Institute Finland. The table provides data on the extract date, row number, year, ELY centre, variable, and the number of farms engaged in direct sales. This data can be used for various data analytics purposes, such as analyzing trends in the number of farms engaged in direct sales over time, comparing the number of farms across different ELY centres, or studying the relationship between the number of farms engaged in direct sales and other variables.

  • Number of Farms Engaged in Direct SalesTSV

    This table provides information on the number of farms engaged in direct sales. The data is sourced from the website of Luke, which originates from Finland.

  • Number of Farms Engaged in Direct Sales by YearTSV

    This table contains information about the number of farms engaged in direct sales, categorized by 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 trends and changes in the number of farms engaged in direct sales over time, identify the regions or areas with the highest number of farms involved in direct sales, and compare the performance of different years in terms of direct sales activity in the agricultural sector. It can also be useful for conducting market research, identifying potential growth opportunities, and making data-driven decisions related to direct sales...

  • Number of Farms Engaged in Direct Sales in Ely Centre, FinlandTSV

    This table contains data on the number of farms engaged in direct sales. It 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 trends and patterns in the number of farms engaged in direct sales over time. It can also be used to compare the distribution of farms across different regions based on their direct sales activities. Furthermore, the data can be used to identify the most common types of products being sold directly by farms and explore the relationship between direct sales and other relevant factors such as agricultural policies or local market conditions.

  • Version History of Farms Engaged in Direct Sales in FinlandTSV

    This table provides the version history of the rows in the 'Number of Farms Engaged in Direct Sales' fact table. The data in this table is sourced from the 'Luke' website, which originates from Finland. It contains information about the number of farms engaged in direct sales, categorized by different years, ely_centre, and variable. The 'start_date' column indicates the date when each row was extracted from the data source, while the 'end_date' column indicates the date when a new version of the row was extracted. If the 'end_date' value is null, it means that the row represents the most recent version. This table can be used for various data analytics purposes such as trend analysis, identifying changes in the number of farms engaged in direct sales over time, and comparing the...

  • Version History of Number of Farms Engaged in Direct Sales, by Variable, from Luke in FinlandTSV

    This table contains the version history of the rows in the 'Number of Farms Engaged in Direct Sales - Dim Variable' table. The data is sourced from the web site of Luke, which originates from Finland. The table has additional columns '_start_date' and '_end_date', which indicate the dates when the rows were extracted from the data source. Each row represents a version of a specific variable in the base table. The '_end_date' column is null for the most recent version of each row. The table can be used in data analytics to track changes in the values of variables over time, analyze trends and patterns, and for comparing the historical versions of the variables.

Column Descriptions

Number of Farms Engaged in Direct Sales in Ely Centre, Finland

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The row number of the data entry.
code int A code associated with the entry.
label string A label or description for the entry.

History of Number of Farms Engaged in Direct Sales - Ely Centre (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 A unique identifier for each row version in the table.
code int The code associated with the row version.
label string The label or name of the row version.

Number of Farms Engaged in Direct Sales by Year

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The number assigned to each row of data in the table.
code string The code associated with a particular item in the table.
label string The label or name assigned to a particular item in the table.

Historical Version History of Number of Farms Engaged in Direct Sales by Year in 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 unique number assigned to each row version in the table.
code string The code associated with the row version in the base table.
label string The label or name given to the row version in the base table.

Number of Farms Engaged in Direct Sales

Column Type Comment
_extract_date date The date on which the data was extracted.
_row_number long The row number of the data.
year int The year to which the data is related.
ely_centre int The center of the ELY (Centre for Economic Development, Transport and the Environment).
variable string The variable being measured or recorded.
number_of_farms_engaged_in_direct_sales int The number of farms engaged in direct sales.

Version History of Farms Engaged in Direct Sales in 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 unique row number of the version in the history table.
year int The year the data represents.
ely_centre int The geographical center of the Economic Local Area (ELY).
variable string The specific variable or metric measured.
number_of_farms_engaged_in_direct_sales int The count of farms engaged in direct sales for the given metric and ELY.

Number of Farms Engaged in Direct Sales

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

Version History of Number of Farms Engaged in Direct Sales, by Variable, from Luke in 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 sequential number assigned to the row version.
code string The code associated with the row version.
label string The label or name of the row version.

Additional Info

Last Updated May 15, 2024
Created May 14, 2024