1. Home
  2. Datasets
  3. Key Figures of Agricultural ...
To download the data set, please sign up or log in

Key Figures of Agricultural and Horticultural Enterprises by Production Type

This dataset collection contains key figures of agricultural and horticultural enterprises grouped by production type. The tables in this collection are sourced from 'Luke' which is the Natural Resources Institute Finland. Luke's website provides data on agricultural and horticultural enterprises from Finland.

Tables

  • Key Figures of Agricultural and Horticultural Enterprises by Production TypeTSV

    This table contains key figures of agricultural and horticultural enterprises, categorized by production type. The data is sourced from the web site of Luke, which originates from Finland (ISO country code 'fi'). The table provides information on various production types, which can be utilized in data analytics to analyze the performance and trends of agricultural and horticultural enterprises based on their production activities.

  • Key Figures of Agricultural and Horticultural Enterprises by Production TypeTSV

    This table contains key figures of agricultural and horticultural enterprises by production type. The data is sourced from 'Luke' which is a web site originating from Finland (ISO country code 'FI'). The table includes columns '_extract_date', '_row_number', 'code', and 'label'. The data in this table can be utilized in data analytics for various purposes such as analyzing the production trends of agricultural and horticultural enterprises, comparing key figures across different production types, identifying outliers or anomalies in the data, and conducting statistical analysis on the key figures.

  • Key Figures of Agricultural and Horticultural Enterprises by Production Type - FactTSV

    This table provides key figures of agricultural and horticultural enterprises by production type. The data in this table is sourced from 'Luke', which is the Natural Resources Institute Finland. The data originates from Finland (ISO country code 'fi'). The table contains information on the extract date, row number, key figure, year, production type, and the number of agricultural and horticultural enterprises. This dataset can be utilized in data analytics for various purposes, such as analyzing the trends and changes in key figures over time, comparing the number of enterprises across different production types and years, and identifying the dominant production types in the agricultural and horticultural sector. By analyzing this data, one can gain insights into the agricultural and...

  • Key Figures of Agricultural and Horticultural Enterprises by Production Type - Year DimensionTSV

    This table contains key figures of agricultural and horticultural enterprises by production type, categorized by year. The data in this table is sourced from the 'Luke' website, 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 used for various data analytics purposes, such as analyzing trends and patterns in agricultural and horticultural production over the years, comparing different production types, or understanding the overall performance of agricultural and horticultural enterprises in Finland.

  • Version History of Agricultural and Horticultural Enterprises' Key Figures by Production TypeTSV

    This table contains the version history of key figures of agricultural and horticultural enterprises by production type. It is a history table derived from the base table, which provides the most recent versions of the rows. The table includes additional columns for '_start_date' and '_end_date', indicating the extraction dates of each row. The data in this table is sourced from the 'Luke' website, which originates from Finland (ISO country code: 'fi'). The table's contents can be utilized in data analytics to analyze trends and changes in key figures for different production types in agricultural and horticultural enterprises over time. For instance, it can help in identifying growth patterns, comparing performance, and making informed decisions related to agricultural and...

  • Version History of Key Figures of Agricultural and Horticultural Enterprises by Production TypeTSV

    This table holds the version history of the key figures of agricultural and horticultural enterprises by production type. It is a historical record of the base table 'key_figures_of_agricultural_and_horticultural_enterprises_by_production_type__dim_production_type'. The table contains columns such as '_start_date', '_end_date', '_row_number', 'code', and 'label'. The '_start_date' column indicates the date when a particular version of the row was extracted from the data source. The '_end_date' column indicates the date when a new version of the row was extracted from the data source. If the value in the '_end_date' column is null, it means that the row is the most recent version. This data is obtained from the web site of 'Luke' from the country with the ISO country code 'fi', which...

  • Version History of Key Figures of Agricultural and Horticultural Enterprises by Production Type (Fact) from Luke (Finland)TSV

    This table contains the version history of the base table 'Key Figures of Agricultural and Horticultural Enterprises by Production Type (Fact)'. It records the changes in key figures of agricultural and horticultural enterprises over time, categorized by production type. The data is sourced from the web site of 'Luke' which originates from the country Finland (ISO country code 'fi'). The table includes columns such as '_start_date' and '_end_date', which represent the extraction dates of each row. Additionally, it contains columns like '_row_number', 'key_figure', 'year', 'production_type', and 'agricultural_and_horticultural_enterprises'. These columns provide valuable information for data analytics, allowing analysts to track changes, perform trend analysis, and compare key figures of...

  • Version History of Key Figures of Agricultural and Horticultural Enterprises by Production Type - Dimension Year (from Luke - Finland)TSV

    This table contains the version history of the rows from the 'key_figures_of_agricultural_and_horticultural_enterprises_by_production_type__dim_year' table. Each row in this table represents a specific version of a row in the base table. The '_start_date' column indicates the date when the 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 the row is the most recent version. The data in this table is sourced from the web site of 'Luke' which originates from the country with the ISO country code 'fi'.

Column Descriptions

Key Figures of Agricultural and Horticultural Enterprises by Production Type

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The unique row number assigned to each record.
code string The code associated with the given record.
label string The label or description of the record.

Version History of Key Figures of Agricultural and Horticultural Enterprises by Production Type

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 number indicating the order of the row version within the table.
code string A unique identifier for the row version.
label string A descriptive label for the row version.

Key Figures of Agricultural and Horticultural Enterprises by Production Type

Column Type Comment
_extract_date date The date the data was extracted from the source system.
_row_number long The sequential row number of the data entry.
code string The unique code associated with the entry.
label string The label or name that identifies the entry.

Version History of Agricultural and Horticultural Enterprises' Key Figures by Production Type

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 number assigned to each row version
code string The code associated with the row version
label string The label or name associated with the row version

Key Figures of Agricultural and Horticultural Enterprises by Production Type - Year Dimension

Column Type Comment
_extract_date date The date when the data was extracted
_row_number long The row number of the data
code int The code associated with the label
label int The label associated with the data

Version History of Key Figures of Agricultural and Horticultural Enterprises by Production Type - Dimension 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 A unique identifier for each row version within the table.
code int The code associated with the row version.
label int The label associated with the row version.

Key Figures of Agricultural and Horticultural Enterprises by Production Type - Fact

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The number assigned to each row in the table.
key_figure string The main numeric value or measurement for each entry.
year int The year corresponding to the data entry.
production_type string The type of production activity described in the entry.
agricultural_and_horticultural_enterprises int A description of agricultural and horticultural enterprises associated with the entry.

Version History of Key Figures of Agricultural and Horticultural Enterprises by Production Type (Fact) 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 sequential number assigned to each row version.
key_figure string The key figure associated with the row version.
year int The year of the row version.
production_type string The type of production associated with the row version.
agricultural_and_horticultural_enterprises int The data related to agricultural and horticultural enterprises for the row version.

Additional Info

Last Updated May 20, 2024
Created September 29, 2023