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

Outdoor Nursery and Cut Flower Cultivation Dataset Collection

The dataset collection consists of one or more dataset tables sourced from the website of Luke in Finland.

Tables

  • Outdoor Nursery and Cut Flower Cultivation (Variable Table)TSV

    This table contains data on outdoor nursery and cut flower cultivation. The data is sourced from the web site of Luke, which originates from Finland.

  • Outdoor Nursery and Cut Flower Cultivation - DIM Ely Centre (Source: Luke - Finland)TSV

    This table contains data related to outdoor nursery and cut flower cultivation in Ely Centre. The data is sourced from the website of Luke, an organization from Finland.

  • Outdoor Nursery and Cut Flower Cultivation - Year DimensionTSV

    This table contains data related to outdoor nursery and cut flower cultivation, organized by year. The data is sourced from the Luke website, which originates from Finland (ISO country code: fi). The table provides information on the extraction date, row number, code, and label. The data in this table can be utilized for various data analytics purposes, such as analyzing trends in outdoor nursery and cut flower cultivation over the years, identifying popular cultivation codes, and studying the distribution of different types of flowers cultivated.

  • Outdoor Nursery and Cut Flower Cultivation Facts in FinlandTSV

    This table contains data from the outdoor nursery and cut flower cultivation in Finland. The data is sourced from the website of Luke, which is the Natural Resources Institute Finland. The table includes information such as the extraction date, row number, year, ELY centre, variable, species, and outdoor nursery and cut flower cultivation. These data can be utilized in various data analytics scenarios. For example, they can be used to analyze trends and patterns in outdoor nursery and cut flower cultivation over time. Moreover, the data can be utilized to evaluate the impact of different variables on the cultivation process, such as the type of species or the location (ELT centre). Additionally, the data can be used to compare the cultivation practices between different years and...

  • Outdoor Nursery and Cut Flower Cultivation SpeciesTSV

    This table contains data related to outdoor nursery and cut flower cultivation species. It is sourced from the website of Luke, which is an organization based in Finland (ISO country code 'fi'). The table consists of four columns: '_extract_date', '_row_number', 'code', and 'label'. The '_extract_date' column represents the date when the data was extracted, '_row_number' provides a unique identifier for each row, 'code' indicates the code associated with each species, and 'label' represents the label or name of the species. The data in this table can be utilized for various data analytics purposes, such as analyzing trends in outdoor nursery and cut flower cultivation, conducting species-specific studies, comparing different species, and identifying patterns or patterns in the...

  • Version history of Outdoor Nursery and Cut Flower Cultivation by Year - Luke (Finland)TSV

    This table contains the version history of the rows in the 'outdoor_nursery_and_cut_flower_cultivation__dim_year' table. Each row in this table represents a specific version of a row in the base table, with additional columns '_start_date' and '_end_date'. 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 that the row is the most recent version. The data in this table can be utilized for data analytics purposes, such as tracking changes over time, identifying trends, or conducting historical analysis. The table is sourced from the 'Luke' website, which originates from Finland (ISO country code: 'fi').

  • Version History of Outdoor Nursery and Cut Flower Cultivation FactsTSV

    This table contains the version history of the outdoor nursery and cut flower cultivation data. It is a historical record of the base table rows from the 'Outdoor Nursery and Cut Flower Cultivation Fact' table. The table consists of rows with additional columns '_start_date' and '_end_date', which represent the extraction dates of the rows from the data source. If the value of the '_end_date' column is null, it means that the row is the most recent version. The data in this table can be utilized in data analytics to explore trends and patterns in the outdoor nursery and cut flower cultivation industry. By analyzing the yearly data, planting locations, and variables associated with different species, one can gain insights into the development and changes in this sector over time. The...

  • Version History of Outdoor Nursery and Cut Flower Cultivation in Ely Centre (from Luke - Finland)TSV

    This table contains the version history of the rows in the 'Outdoor Nursery and Cut Flower Cultivation (Dim Ely Centre)' base table. It has two additional columns compared to the base table: '_start_date' and '_end_date'. The '_start_date' column represents the date when the row was extracted from the 'Luke' data source, which originates from Finland (ISO country code 'fi'). The '_end_date' column indicates the date when a new version of the row was extracted from the data source. If the value of the '_end_date' column is null, it signifies that the row represents the most recent version. This table provides valuable information for data analytics purposes, allowing the analysis of changes and updates in the outdoor nursery and cut flower cultivation data over time.

  • Version History of Outdoor Nursery and Cut Flower Cultivation SpeciesTSV

    This table contains the version history of the rows from the 'Outdoor Nursery and Cut Flower Cultivation - Species' table. The extracted rows are stored with additional information about their start and end dates. The '_start_date' column stores the date when the row 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 '_end_date' value is null, it indicates that the row is the most recent version. The table is sourced from the website of 'Luke', which originates from Finland (ISO country code: 'FI'). The data in this table can be used for various data analytics purposes, such as tracking changes in species over time, analyzing trends in species cultivation, and examining historical data for specific species...

  • Version History of Outdoor Nursery and Cut Flower Cultivation Variable Rows from Luke (Finland)TSV

    This table contains the version history of rows from the 'Outdoor Nursery and Cut Flower Cultivation - Dimension Variable' table. Each row in this table represents a different version of a row from the base table. The '_start_date' column stores the date when the row 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 '_end_date' value is null, it means that the row is the most recent version. This table is sourced from the web site of 'Luke' which originates from the country with the ISO country code 'fi' (Finland). There are additional columns '_row_number', 'code', and 'label' in this table which provide specific information related to the versions of the rows. This historical data can be utilized in...

Column Descriptions

Outdoor Nursery and Cut Flower Cultivation (Variable Table)

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The row number in the table.
code string The code associated with the data.
label string The label or name for the data.

Version History of Outdoor Nursery and Cut Flower Cultivation Variable Rows 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 An additional column indicating the number of the row version.
code string A column storing a specific code value associated with the row version.
label string A column storing a label or description for the row version.

Outdoor Nursery and Cut Flower Cultivation - Year Dimension

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 The code associated with the data entry.
label int The label corresponding to the data entry.

Version history of Outdoor Nursery and Cut Flower Cultivation by Year - Luke (Finland)

Column Type Comment
_start_date date '_start_date' column represents the start date of the validity period for the row version in the table.
_end_date date '_end_date' column represents the end date of the validity period for the row version in the table.
_row_number long '_row_number' column denotes the sequential number of the row version in the table.
code int 'code' column stores the code associated with the row version in the table.
label int 'label' column holds the label or description for the row version in the table.

Outdoor Nursery and Cut Flower Cultivation Facts in Finland

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The row number of the data entry.
year int The year when the data was recorded.
ely_centre int The name of the Ely Centre.
variable string The variable being measured or observed.
species string The species of the plant or organism being studied.
outdoor_nursery_and_cut_flower_cultivation int Indicates if the data corresponds to outdoor nursery and cut flower cultivation.

Version History of Outdoor Nursery and Cut Flower Cultivation Facts

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 A unique identifier for each row version in the table.
year int The year associated with the data in the row version.
ely_centre int The location identifier for a specific centre in Ely.
variable string A variable associated with the data in the row version.
species string The species associated with the data in the row version.
outdoor_nursery_and_cut_flower_cultivation int A flag indicating outdoor nursery and cut flower cultivation in the row version.

Outdoor Nursery and Cut Flower Cultivation - DIM Ely Centre (Source: Luke - Finland)

Column Type Comment
_extract_date date The date when the data was extracted from the source system.
_row_number long A unique identifier assigned to each row in the table.
code int A code that represents a specific item or entity.
label string A descriptive label or name for the corresponding code.

Version History of Outdoor Nursery and Cut Flower Cultivation in Ely Centre (from Luke - Finland)

Column Type Comment
_start_date date The '_start_date' column indicates the start date of the validity period for the row version.
_end_date date The '_end_date' column indicates the end date of the validity period for the row version.
_row_number long The '_row_number' column represents the unique identifier for each row version in the table.
code int The 'code' column stores the code associated with the row version.
label string The 'label' column contains the label or name of the row version.

Outdoor Nursery and Cut Flower Cultivation Species

Column Type Comment
_extract_date date This column represents the date when the data was extracted from the source system.
_row_number long This column represents the row number of the data.
code string This column contains the code associated with a specific item or entity.
label string This column contains the descriptive label or name of an item or entity.

Version History of Outdoor Nursery and Cut Flower Cultivation Species

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 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.

Additional Info

Last Updated May 20, 2024
Created October 1, 2023