Historical Versions of Year Dimension in Greenhouse Production Database
Click here for a data sample
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.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date indicating the beginning of the validity period of the row version. |
|---|
| _end_date | date | The end date indicating the end of the validity period of the row version. |
|---|
| _row_number | long | A unique identifier for each row version. |
|---|
| code | int | A code associated with the row version. |
|---|
| label | int | The label or name associated with the row version. |
|---|
