Version History of Dairy Milk Production by Year
Click here for a data sample
This table contains the version history of production data for dairy milk annually, with each row representing a different version of the data extracted from the web site of 'Luke', originating from Finland. The table is a historical log of changes made to the base table 'production_of_dairy_milk_annually__dim_year'. The '_start_date' column represents the date when each row was extracted from the data source, while the '_end_date' column represents the date when a new version was extracted. If the '_end_date' value is null, it means that the row represents the most recent version of the data. This table can be utilized in data analytics to track changes in dairy milk production over time, identify trends and patterns in annual production, compare different versions to analyze differences in production figures, and assess the impact of changes in production techniques or policies on overall output.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period for a row version. |
|---|
| _end_date | date | The end date of the validity period for a row version. |
|---|
| _row_number | long | An additional column indicating the number of the row version. |
|---|
| code | int | The code associated with the row version. |
|---|
| label | int | The label associated with the row version. |
|---|
