Average Retirement Age - Finland

The dataset collection contains the 'Average Retirement Age Table - Finland' table. The data for this table is sourced from the website 'Sotkanet' in Finland.

Tables

Average Retirement AgeTSV
This indicator gives the arithmetic average age of retired people (old age, disability and unemployment pensions, and special pensions for farmers). Those receiving part-time pensions are not included in the average.
Average Retirement Age Table - FinlandTSV
This table contains data on the average retirement age in different regions, genders, and years. The data is sourced from the 'Sotkanet' website, which originates from Finland (ISO country code 'fi'). Each row in the table represents a specific combination of the extract date, row number, year, region, gender, and retirement age values. The '_extract_date' column specifies the date when the data on the row was extracted from the data source, and the '_row_number' column indicates the position of the row in the extracted data on that extract date. The combination of '_extract_date' and '_row_number' columns uniquely identifies each row in the table. The 'value_ka' column represents the retirement age value in a specific region, gender, and year. The 'absolute_value' column provides...
Version History of Average Retirement Age Data in FinlandTSV
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...

Column Descriptions

Average Retirement Age

Column	Type	Comment
year	int	Observation year. Column year has 21440 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2002 and maximum value is 2016.
region	int	Sotkanet region code (Municipality, sub-region, region, area for the regional state administrative agency, major region, Mainland Finland/Åland, hospital district, university hospital special responsibility area, whole country). Column region has 21440 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 955.
gender	string	male, female, combined. Column gender has 21440 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is female and maximum string is total.
value_ka	float	Average. Column value_ka has 21440 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 17.10 and maximum value is 67.60.
absolute_value	int	Absolute value. Column absolute_value has 21440 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 83376.
orig_extractdate	string	The date when the data was originally fetched from the source.

Average Retirement Age Table - Finland

Column	Type	Comment
_extract_date	date	The date when the data on the row of the table was extracted from the data source.
_row_number	long	The row number in the data extracted from the source on the extract date specified by the column '_extract_date'. The combination of the columns '_extract_date' and '_row_number' uniquely identifies each row.
year	int
region	int
gender	string
value_ka	float
absolute_value	int

Version History of Average Retirement Age Data in Finland

Column	Type	Comment
_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

Additional Info

Last Updated	May 22, 2024
Created	March 5, 2019