Greenhouse Production Dataset Collection

Tables

• Greenhouse Production - Plant Group Dimension DataTSV

  The 'greenhouse_production__dim_plant_group' table contains data from the web site of 'Luke' which originates from Finland. This table provides information about different plant groups used in greenhouse production. The table can be utilized in data analytics to analyze and compare the production of different plant groups over time. By analyzing the '_extract_date' column, trends and patterns in plant group production can be identified. The 'code' column can be used to classify and categorize the plant groups, while the 'label' column provides the descriptive name for each plant group. The '_row_number' column indicates the position of each record in the dataset. Using this table, valuable insights can be gained regarding the production and cultivation of various plant groups in...

• Greenhouse Production by YearTSV

  This table contains information about greenhouse production by year. It is sourced from the website of 'Luke', which originates from Finland.

• Greenhouse Production Data from Luke (Finland)TSV

  This table contains data on greenhouse production sourced from the Luke website in Finland. It includes information such as the extraction date, row number, year, variable, plant group, and greenhouse production. The data in this table can be utilized in various data analytics tasks, for example: Analyzing the yearly greenhouse production trends for different plant groups Comparing the greenhouse production of different variables Identifying the top greenhouse production contributors among plant groups Assessing the relationship between greenhouse production and other variables

• Historical Versions of Year Dimension in Greenhouse Production DatabaseTSV

  This table contains the version history of the rows from the 'Greenhouse Production Dimension - Year' table. The data is sourced from the 'Luke' website, which originates from Finland (ISO country code: FI). The table includes the columns '_start_date', '_end_date', '_row_number', 'code', and 'label'. The '_start_date' column represents the date when each row was extracted from the data source, while the '_end_date' column contains the date when a newer version of the row was extracted. Rows with a null '_end_date' value indicate that they are the most recent versions. This table can be utilized in data analytics to track changes over time in greenhouse production by year, analyze trends, and perform historical comparisons.

• Plant Group Version History for Luke from FinlandTSV

  This table contains the version history of the rows in the 'greenhouse_production__dim_plant_group' table sourced from the 'Luke' website, originating from the country 'Finland'. Each row in this table represents a specific version of a plant group and includes information about the start and end dates of that version. The '_start_date' column indicates the date when the row was extracted from the data source, while the '_end_date' column represents 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 table can be utilized in data analytics to track changes in plant groups over time and analyze trends or patterns in their labels and codes.

• Version History of Greenhouse Production DataTSV

  This table contains the version history of the rows in the 'greenhouse_production__fact' table. The rows in this table represent different versions of the base table rows over time. Each row has information about the start date and end date of its version. If the end date is null, it means that the row represents the most recent version. The data in this table can be used for data analytics purposes, such as analyzing the changes in greenhouse production over time. By comparing the values of different variables, plant groups, and years, valuable insights can be gained about the trends and patterns in greenhouse production. The data in this table is sourced from the website of 'Luke' which originates from Finland (ISO country code: 'FI').