Version History of Open Field Plant Group Production Data from Luke (Finland)
Click here for a data sample
This table contains the version history of the rows from the base table 'open_field_production__dim_plant_group'. Each row in this table represents a specific version of a row from the base table and includes additional information about the start date and end date of the version. The '_start_date' column stores the date when this particular version of 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 value in the '_end_date' column is null, it indicates that the row is the most recent version. The rows in this table can be utilized in various data analytics scenarios, such as tracking changes in plant group information over time, identifying trends in code and label modifications, and analyzing the frequency of updates to the data. The data in this table is sourced from the website of Luke, which is an agricultural research organization in 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 in the version history table. |
|---|
| code | string | The code associated with the row version. |
|---|
| label | string | The label associated with the row version. |
|---|
