Version History of Monthly Production of Dairy Milk
Click here for a data sample
This table stores the version history of the rows from the 'production_of_dairy_milk_monthly__dim_month' table. It contains two additional columns compared to its base table: '_start_date' which represents the date when the row was extracted from the data source, and '_end_date' which represents the date when a new version of the row was extracted. If the value of the '_end_date' column is null, it indicates that the row is the most recent version of the row. The data in this table can be utilized for various data analytics purposes, such as analyzing the changes in dairy milk production on a monthly basis, identifying trends and patterns in production over time, and comparing production data between different periods. This version history table is sourced from the website of 'Luke', which is an agricultural research institute in Finland (ISO country code: FI).
Field Descriptions
| Name |
Data type |
Description |
| _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 | The unique identifier of the row version. |
|---|
| code | string | The code associated with the row version. |
|---|
| label | string | The label or name associated with the row version. |
|---|
