1. Home
  2. Datasets
  3. Profitability Factor of ...
To download the data set, please sign up or log in

Profitability Factor of Organic and Regular Production

This dataset collection consists of one or more dataset tables related to the profitability factor of organic and regular production. The tables are sourced from the web site of 'Luke' in Finland.

Tables

  • Profitability Factor of Organic and Regular ProductionTSV

    This table contains information about the profitability factor of organic and regular production. The data is sourced from the website of Luke, which is an agricultural research center located in Finland (ISO country code: FI). The table includes columns such as 'extract_date', 'row_number', 'national_support_area', 'production_method', 'year', and 'profitability_factor_of_organic_and_regular_production'. The data in this table can be utilized in various data analytics scenarios, such as analyzing the profitability of organic versus regular production methods over different years, comparing the profitability in different national support areas, or examining the overall trends in profitability within the agricultural sector.

  • Profitability Factor of Organic and Regular Production - Version HistoryTSV

    This table contains the version history of the rows in the 'Profitability Factor of Organic and Regular Production' table. The rows in this table represent different versions of the data extracted from the 'Profitability Factor of Organic and Regular Production' data source. Each row in this table has additional columns '_start_date' and '_end_date', which store the extraction dates of the row versions. The '_start_date' column contains the date when the row version 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 of the '_end_date' column is null, it indicates that the row is the most recent version. The table data includes information such as the national support area, production method, year,...

  • Profitability Factor of Organic and Regular Production by National Support AreaTSV

    This table contains the profitability factor of organic and regular production in different national support areas. The data is sourced from the web site of Luke, which originates from Finland (ISO country code: FI). The table provides 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 analyzing the profitability trends of organic and regular production in different national support areas, comparing the profitability factors between different areas, and identifying the areas with the highest and lowest profitability factors, among others.

  • Profitability Factor of Organic and Regular Production by YearTSV

    The 'profitability_factor_of_organic_and_regular_production__dim_year' table contains data from the web site of Luke, which originates from Finland (ISO country code 'fi'). This table provides information about the profitability factor of organic and regular production for different years. 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 profitability trends of organic and regular production over the years, compare profitability between different codes or labels, and identify patterns or insights related to organic and regular production profitability.

  • Profitability Factors of Organic and Regular Production by Production MethodTSV

    This table contains data on the profitability factor of organic and regular production. The data is categorized based on the production method. The table is sourced from the website of Luke, which originates from Finland (ISO country code: FI). The table includes information on the extract date, row number, code, and label. The data in this table can be utilized for data analytics to analyze and compare the profitability of organic and regular production methods. It can provide insights into the financial performance of different production methods and contribute to informed decision-making.

  • Version History of Profitability Factor for Organic and Regular Production Dim National Support Area Data from Luke (Finland)TSV

    This table contains the version history of profitability factors of organic and regular production in different national support areas. It is sourced from the web site of 'Luke', which originates from Finland. The table provides insights into the changes and updates made to the profitability factors over time. Each row corresponds to a specific version of a profitability factor and includes information such as the start date, end date, row number, code, and label. The start date indicates when the row was extracted from the data source, and the end date represents 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 scenarios to analyze the trends,...

  • Version History of Profitability Factor of Organic and Regular Production (by Year) from Luke (Finland)TSV

    This table contains the version history of the profitability factor of organic and regular production, with respect to different years. It is derived from the base table 'profitability_factor_of_organic_and_regular_production__dim_year'. The table includes additional columns '_start_date' and '_end_date', which represent the extraction dates of each row's version. The data in this table can be utilized in various data analytics scenarios. For example, it can be used to analyze the trends and changes in profitability factors over time for both organic and regular production. Moreover, it can also be utilized to compare the profitability of organic and regular production in different years, enabling deeper insights into the performance and potential of each production method. The table's...

  • Version History of Profitability Factor of Organic and Regular Production by Production Method - Luke (Finland)TSV

    This table contains the version history of profitability factors for organic and regular production. The base table for this history table is 'profitability_factor_of_organic_and_regular_production__dim_production_method'. The columns in this table include '_start_date' which represents the date when the row was extracted from the data source, '_end_date' which represents the date when a new version of the row was extracted, '_row_number' to identify each row, 'code' to indicate the code associated with the profitability factor, and 'label' to represent the label or description of the profitability factor. This data is sourced from the web site of 'Luke' which originates from the country with ISO country code 'FI' (Finland).

Column Descriptions

Profitability Factor of Organic and Regular Production by National Support Area

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The unique identifier or index number of each row in the table.
code string The code or identifier associated with a specific data entry.
label string The descriptive label or name associated with a specific data entry.

Version History of Profitability Factor for Organic and Regular Production Dim National Support Area Data from Luke (Finland)

Column Type Comment
_start_date date '_start_date' column indicates the validity start date for a particular row version.
_end_date date '_end_date' column indicates the validity end date for a particular row version.
_row_number long '_row_number' column indicates the unique identifier for each row version.
code string 'code' column represents the code associated with the row version.
label string 'label' column represents the label associated with the row version.

Profitability Factor of Organic and Regular Production by Year

Column Type Comment
_extract_date date The date when the data was extracted from the source system.
_row_number long The order in which the record appears in the table.
code int A unique identifier associated with a particular element.
label int A descriptive name or title assigned to an element or object.

Version History of Profitability Factor of Organic and Regular Production (by Year) 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 unique identifier of each row version.
code int The code associated with the row version.
label int The label or description of the row version.

Profitability Factors of Organic and Regular Production by Production Method

Column Type Comment
_extract_date date The date when the data was extracted from the source.
_row_number long The unique identifier for each row in the table.
code string The code associated with a particular item.
label string The label or description of a particular item.

Version History of Profitability Factor of Organic and Regular Production by Production Method - 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 numerical value indicating the row number of the version.
code string The code associated with the row version.
label string The label or description associated with the row version.

Profitability Factor of Organic and Regular Production

Column Type Comment
_extract_date date The date when the row was extracted from the source system.
_row_number long A unique identifier assigned to each row of the table.
national_support_area string The geographical area where the national support program is implemented.
production_method string The method used for production, such as organic or regular.
year int The year to which the data corresponds.
profitability_factor_of_organic_and_regular_production string The ratio of profitability between organic and regular production methods.

Profitability Factor of Organic and Regular Production - Version History

Column Type Comment
_start_date date The starting date for the validity period of the row version.
_end_date date The ending date for the validity period of the row version.
_row_number long A unique identifier for each row version.
national_support_area string The geographic area where national support is provided.
production_method string The method used for production.
year int The year associated with the row version.
profitability_factor_of_organic_and_regular_production string The factor determining the profitability of organic and regular production methods.

Additional Info

Last Updated May 20, 2024
Created October 1, 2023