Version History of Average Retirement Age Data in Finland
Click here for a data sample
The 'average_retirement_agetablehistory' table contains the version history of rows extracted from the 'average_retirement_age__table' base table. It includes the columns '_start_date', '_end_date', '_row_number', 'year', 'region', 'gender', 'value_ka', and 'absolute_value'. The '_start_date' column represents the extraction date of each row, while the '_end_date' column indicates the date when a new version of the row was extracted. If the '_end_date' value is null, it signifies that the corresponding row is the most recent version. This historical version data can be utilized in data analytics to perform various analyses such as monitoring retirement age trends over time, comparing retirement ages across different regions and genders, identifying outliers or changes in retirement age patterns, and calculating the average retirement age or absolute retirement values. The data for this table is sourced from the 'Sotkanet' website, which originates from Finland (ISO country code: 'fi').
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The date when the row was extracted from the data source |
|---|
| _end_date | date | The date when a new version of the row was extracted from the data source. If the value is null, it means the row is the most recent version. |
|---|
| _row_number | long | The number of the row in the raw data extracted from the data source |
|---|
| year | int | The year associated with the data row |
|---|
| region | int | The region associated with the data row |
|---|
| gender | string | The gender associated with the data row |
|---|
| value_ka | float | The value of a specific attribute 'KA' for the data row |
|---|
| absolute_value | int | The absolute value of the data row |
|---|
