Version History of Total Drain by Regional Unit in Finland Extracted from Luke Website
Click here for a data sample
This table contains the version history of the rows from the 'total drain by regional unit, dimension year' table. The rows in this table represent the different versions of the data extracted from the data source, where each version is identified by a unique '_row_number'. The '_start_date' column indicates the date when the row was extracted, while the '_end_date' column represents the date when a new version of the row was extracted. If the '_end_date' is null, it means that the row is the most recent version of the data. The 'code' column contains the codes associated with the regional units, and the 'label' column provides the labels or names corresponding to those codes. The data in this table can be utilized in data analytics to analyze the changes in the total drain by regional unit over time. For example, it can be used to track the evolution of total drain patterns across different years or to identify trends and patterns in the drain levels of specific regional units. This historical data can also be used for forecasting future drain levels or for identifying any significant fluctuations or anomalies in the drain by regional unit. The data for this table is sourced from the web site of 'Luke', which is an agricultural research organization based 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 | int | The code associated with the row version. |
label | int | The label associated with the row version. |