Version History of Yield of the Main Crops by Year - Data Source: Luke (Finland)
Click here for a data sample
This table contains the version history of the rows from the base table 'yield_of_the_main_crops__dim_year'. Each row in this table corresponds to a specific version of a row in the base table, denoted by the extraction date. The '_start_date' column represents the date when the version of the row was extracted from the data source. The '_end_date' column indicates the date when a new version of the row was extracted. If the value in the '_end_date' column is null, it means that the row is the most recent version. In addition to the base table columns, this table also includes the '_row_number' column, which represents the number of the row in this version history table, the 'code' column, which contains a specific code related to the crops, and the 'label' column, which provides a label associated with the code. This data can be utilized in data analytics to analyze the changes in crop yields over time, identify trends, calculate growth rates, and compare the performance of different crops. The data originates from the web site of 'Luke' from 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 | A number assigned to each row version to identify its order in the version history. |
|---|
| code | int | The code associated with the row version. |
|---|
| label | int | The label or name of the row version. |
|---|
