11 zq -- Index of wage and salary earnings and index of regular earnings by employer sector, 1995 Q 1-2019 Q 1*

Tables

Dim base of payment, Statfin ati pxt 11zq px, Full historyTSV
Dimension Base_of_payment (Palkkausmuoto)
Dim base of payment, Statfin ati pxt 11zq px, LatestTSV
Dimension Base_of_payment (Palkkausmuoto)
Dim employer sector, Statfin ati pxt 11zq px, Full historyTSV
Dimension Employer_sector (Työnantajasektori)
Dim employer sector, Statfin ati pxt 11zq px, LatestTSV
Dimension Employer_sector (Työnantajasektori)
Dim gender, Statfin ati pxt 11zq px, Full historyTSV
Dimension Gender (Sukupuoli)
Dim gender, Statfin ati pxt 11zq px, LatestTSV
Dimension Gender (Sukupuoli)
Dim quarter, Statfin ati pxt 11zq px, Full historyTSV
Dimension Quarter (Vuosineljännes)
Dim quarter, Statfin ati pxt 11zq px, LatestTSV
Dimension Quarter (Vuosineljännes)
Fact, Statfin ati pxt 11zq px, Full historyTSV
Index of wage and salary earnings and index of regular earnings by employer sector by Quarter, Employer sector, Base of payment, Gender and Information
Fact, Statfin ati pxt 11zq px, LatestTSV
Index of wage and salary earnings and index of regular earnings by employer sector by Quarter, Employer sector, Base of payment, Gender and Information

Column Descriptions

Dim gender, Statfin ati pxt 11zq px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
label	string	The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Females and maximum string is Total.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim quarter, Statfin ati pxt 11zq px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 97 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1995Q1 and maximum string is 2019Q1.
label	string	The label for the dimension value. Column label has 97 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1995Q1 and maximum string is 2019Q1*.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim quarter, Statfin ati pxt 11zq px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 97 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1995Q1 and maximum string is 2019Q1.
label	string	The label for the dimension value. Column label has 97 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1995Q1 and maximum string is 2019Q1*.

Dim employer sector, Statfin ati pxt 11zq px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 5 rows, out of which 1 are empty, making the null percent 20.00. Minimum value is 1 and maximum value is 7.
label	string	The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is All sectors and maximum string is Others.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim employer sector, Statfin ati pxt 11zq px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 5 rows, out of which 1 are empty, making the null percent 20.00. Minimum value is 1 and maximum value is 7.
label	string	The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is All sectors and maximum string is Others.

Fact, Statfin ati pxt 11zq px, Full history

Column	Type	Comment
quarter	string	* preliminary data . Column quarter has 4365 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1995Q1 and maximum string is 2019Q1.
employer_sector	int	Datasource did not contain a description for Employer_sector. Column employer_sector has 4365 rows, out of which 873 are empty, making the null percent 20.00. Minimum value is 1 and maximum value is 7.
base_of_payment	int	Datasource did not contain a description for Base_of_payment. Column base_of_payment has 4365 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 2.
gender	int	Datasource did not contain a description for Gender. Column gender has 4365 rows, out of which 1455 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
index_of_wage_and_salary_earnings_1995100	int	Datasource did not contain a description for Index_of_wage_and_salary_earnings_1995100. Column index_of_wage_and_salary_earnings_1995100 has 4365 rows, out of which 873 are empty, making the null percent 20.00. Minimum value is 97 and maximum value is 227.
index_of_wage_and_salary_earnings_2005100	int	Datasource did not contain a description for Index_of_wage_and_salary_earnings_2005100. Column index_of_wage_and_salary_earnings_2005100 has 4365 rows, out of which 2313 are empty, making the null percent 52.99. Minimum value is 97 and maximum value is 152.
index_of_regular_earnings_2005100	int	Datasource did not contain a description for Index_of_regular_earnings_2005100. Column index_of_regular_earnings_2005100 has 4365 rows, out of which 2313 are empty, making the null percent 52.99. Minimum value is 97 and maximum value is 153.
index_of_wage_and_salary_earnings_2010100	int	Datasource did not contain a description for Index_of_wage_and_salary_earnings_2010100. Column index_of_wage_and_salary_earnings_2010100 has 4365 rows, out of which 3033 are empty, making the null percent 69.48. Minimum value is 99 and maximum value is 120.
index_of_regular_earnings_2010100	int	Datasource did not contain a description for Index_of_regular_earnings_2010100. Column index_of_regular_earnings_2010100 has 4365 rows, out of which 3033 are empty, making the null percent 69.48. Minimum value is 99 and maximum value is 121.
index_of_wage_and_salary_earnings_2015100	int	Datasource did not contain a description for Index_of_wage_and_salary_earnings_2015100. Column index_of_wage_and_salary_earnings_2015100 has 4365 rows, out of which 3804 are empty, making the null percent 87.15. Minimum value is 98 and maximum value is 105.
index_of_regular_earnings_2015100	int	Datasource did not contain a description for Index_of_regular_earnings_2015100. Column index_of_regular_earnings_2015100 has 4365 rows, out of which 3804 are empty, making the null percent 87.15. Minimum value is 99 and maximum value is 105.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfin ati pxt 11zq px, Latest

Column	Type	Comment
quarter	string	* preliminary data . Column quarter has 4365 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1995Q1 and maximum string is 2019Q1.
employer_sector	int	Datasource did not contain a description for Employer_sector. Column employer_sector has 4365 rows, out of which 873 are empty, making the null percent 20.00. Minimum value is 1 and maximum value is 7.
base_of_payment	int	Datasource did not contain a description for Base_of_payment. Column base_of_payment has 4365 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 2.
gender	int	Datasource did not contain a description for Gender. Column gender has 4365 rows, out of which 1455 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
index_of_wage_and_salary_earnings_1995100	int	Datasource did not contain a description for Index_of_wage_and_salary_earnings_1995100. Column index_of_wage_and_salary_earnings_1995100 has 4365 rows, out of which 873 are empty, making the null percent 20.00. Minimum value is 97 and maximum value is 227.
index_of_wage_and_salary_earnings_2005100	int	Datasource did not contain a description for Index_of_wage_and_salary_earnings_2005100. Column index_of_wage_and_salary_earnings_2005100 has 4365 rows, out of which 2313 are empty, making the null percent 52.99. Minimum value is 97 and maximum value is 152.
index_of_regular_earnings_2005100	int	Datasource did not contain a description for Index_of_regular_earnings_2005100. Column index_of_regular_earnings_2005100 has 4365 rows, out of which 2313 are empty, making the null percent 52.99. Minimum value is 97 and maximum value is 153.
index_of_wage_and_salary_earnings_2010100	int	Datasource did not contain a description for Index_of_wage_and_salary_earnings_2010100. Column index_of_wage_and_salary_earnings_2010100 has 4365 rows, out of which 3033 are empty, making the null percent 69.48. Minimum value is 99 and maximum value is 120.
index_of_regular_earnings_2010100	int	Datasource did not contain a description for Index_of_regular_earnings_2010100. Column index_of_regular_earnings_2010100 has 4365 rows, out of which 3033 are empty, making the null percent 69.48. Minimum value is 99 and maximum value is 121.
index_of_wage_and_salary_earnings_2015100	int	Datasource did not contain a description for Index_of_wage_and_salary_earnings_2015100. Column index_of_wage_and_salary_earnings_2015100 has 4365 rows, out of which 3804 are empty, making the null percent 87.15. Minimum value is 98 and maximum value is 105.
index_of_regular_earnings_2015100	int	Datasource did not contain a description for Index_of_regular_earnings_2015100. Column index_of_regular_earnings_2015100 has 4365 rows, out of which 3804 are empty, making the null percent 87.15. Minimum value is 99 and maximum value is 105.

Dim base of payment, Statfin ati pxt 11zq px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 2.
label	string	The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is All employees and maximum string is Monthly paid employees.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim base of payment, Statfin ati pxt 11zq px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 2.
label	string	The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is All employees and maximum string is Monthly paid employees.

Dim gender, Statfin ati pxt 11zq px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
label	string	The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Females and maximum string is Total.

Additional Info

Last Updated	July 22, 2019
Created	July 19, 2019