Historical Versions of Monthly Indexes from Luke (Finland)
Click here for a data sample
This table contains the version history of extracted rows from the 'Luke' data source's 'indeksitdim_kuukausi' table. Each row in this table represents a specific version of a row in the base table. The 'indeksitdim_kuukausi__history' table includes additional columns compared to the base table, such as '_start_date' and '_end_date', which indicate the extraction dates of each row version. If the '_end_date' column has a null value, it means that the row is the most recent version. This table sourced from the web site of 'Luke' from Finland (ISO country code: 'fi'). Examples of how this data can be utilized in data analytics include analyzing the historical changes in the 'code' and 'label' columns over time, identifying trends, and understanding the evolution of dimensions during different extraction periods.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period of the row version. |
|---|
| _end_date | date | The end date of the validity period of the row version. |
|---|
| _row_number | long | An additional column indicating the row number of the version in the table. |
|---|
| code | string | A column representing the code associated with the row version. |
|---|
| label | string | A column representing the label associated with the row version. |
|---|
