Version History of Irrigation Method by Region in Finland
Click here for a data sample
This table contains the version history of the base table 'irrigation_method_by_regiondim_method' extracted from the data source 'Luke' in Finland. The 'irrigation_method_by_regiondim_method__history' table includes additional columns compared to its base table, such as '_start_date' and '_end_date'. These columns represent the dates when each row was extracted from the data source and when a new version of the row was obtained. If the '_end_date' column value is null, it indicates that the row is the most recent version available. The table can be utilized in various data analytics scenarios, such as trend analysis of changes in irrigation methods by region over time, tracking the adoption of different irrigation techniques, or identifying patterns in the usage of irrigation methods across regions.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The validity start date of the row version. |
|---|
| _end_date | date | The validity end date of the row version. |
|---|
| _row_number | long | A unique number that identifies the row version. |
|---|
| code | string | The code associated with the row version. |
|---|
| label | string | The label or name of the row version. |
|---|
