Version History of Irrigation Method by Production Sector Table - Luke (Finland)
Click here for a data sample
This table contains the version history of the base table rows from the 'irrigation_method_by_production_sector__dim_method' table. The table is sourced from the website of 'Luke', which originates from the country Finland. It includes information about the start and end dates of each row version, along with a unique row number, code, and label. The '_start_date' column represents the date when the row was extracted from the data source, while the '_end_date' column indicates the date when a new version of the row was extracted. If the value of the '_end_date' column is null, it means that the row is the most recent version. This version history table can be utilized in data analytics to track changes and modifications over time, monitor trends, perform temporal analysis, identify patterns, and analyze the evolution of irrigation methods by production sector. With the ability to examine past versions and compare them to the latest ones, valuable insights can be gained for research, planning, and decision-making purposes.
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 designated number assigned to each row version in the table. |
|---|
| code | string | The code associated with the row version. |
|---|
| label | string | A descriptive label for the row version. |
|---|
