Version History of Greenhouse Production Data
Click here for a data sample
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').
Field Descriptions
Name |
Data type |
Description |
_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 number assigned to each row version. |
year | int | The year associated with the dataset. |
variable | string | The variable associated with the dataset. |
plant_group | string | The group that the plant belongs to. |
greenhouse_production | int | The amount of production in the greenhouse for the corresponding row version. |