1. Home
  2. Datasets
  3. Average Overall Pensions in ...
To download the data set, please sign up or log in

Average Overall Pensions in One's Own Right (in Euros per Month)

The dataset collection consists of one table named 'Average Overall Pensions in One's Own Right (in Euros per Month)'. The tables in this dataset collection are sourced from the website of Sotkanet in Finland.

Tables

  • Average Overall Pensions in One's Own Right (in Euros per Month)TSV

    The indicator gives the average overall pension (EUR /month) of persons receiving pension in one's own right under the earnings-based and/or national pension scheme at the end of the statistical year. The pension may consist of earnings-based pension, pension paid by the Social Insurance Institution as well as military injuries pension and pension from employment accidents insurance and motor liability insurance. The average pension is based on the mean value of gross pensions. Recipients of pensions in one's own right include persons receiving old-age, unemployment, part-time or special agricultural pension. Overall pension comprises pension in one's own right and survivors' pension.

  • Average Overall Pensions Pensions In Ones Own Right Euro Per MonthTSV

    The indicator gives the average overall pension (EUR /month) of persons receiving pension in one's own right under the earnings-based and/or national pension scheme at the end of the statistical year. The pension may consist of earnings-based pension, pension paid by the Social Insurance Institution as well as military injuries pension and pension from employment accidents insurance and motor liability insurance. The average pension is based on the mean value of gross pensions. Recipients of pensions in one's own right include persons receiving old-age, unemployment, part-time or special agricultural pension. Overall pension comprises pension in one's own right and survivors' pension.

  • Version History of Average Overall Pensions in One's Own Right per Month (Euro) - History (from Sotkanet - Finland)TSV

    This table, sourced from the 'Sotkanet' website in Finland, provides the version history of the average overall pensions in one's own right in euros per month. It contains information on various attributes such as the year, region, gender, value per1, and absolute value. The '_start_date' column represents the date when the row was extracted from the data source, 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. This table can be utilized in various data analytics scenarios, such as determining trends in pension values over time, analyzing regional variations, and comparing pension values between genders.

Column Descriptions

Average Overall Pensions Pensions In Ones Own Right Euro Per Month

Column Type Comment
year int Observation year. Column year has 29988 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1996 and maximum value is 2016.
region int Sotkanet region code (Municipality, whole country). Column region has 29988 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 29988 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_per1 int Per capita. Column value_per1 has 29988 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 558 and maximum value is 4128.
absolute_value int Absolute value. Column absolute_value has 29988 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 17270 and maximum value is 2147483647.
orig_extractdate string The date when the data was originally fetched from the source.

Average Overall Pensions in One's Own Right (in Euros per Month)

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 The year value.
region int The region value.
gender string The gender value.
value_per1 int The value per 1 unit.
absolute_value int The absolute value.

Version History of Average Overall Pensions in One's Own Right per Month (Euro) - History (from Sotkanet - 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 null, it means that the row is the most recent version.
_row_number long The number of the row in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row in this version history table.
year int The year value.
region int The region value.
gender string The gender value.
value_per1 int The value per 1.
absolute_value int The absolute value.

Additional Info

Last Updated May 22, 2024
Created March 7, 2019