020 -- Population by socio-economic status, main type of activity, sex, age and year 2010-2016

Tables

Dim age, Statfinpas tyokay pxt 020 201600 px, Full historyTSV
Dimension Age (Ikä)
Dim age, Statfinpas tyokay pxt 020 201600 px, LatestTSV
Dimension Age (Ikä)
Dim main type of activity, Statfinpas tyokay pxt 020 201600 px, Full historyTSV
Dimension Main_type_of_activity (Pääasiallinen toiminta)
Dim main type of activity, Statfinpas tyokay pxt 020 201600 px, LatestTSV
Dimension Main_type_of_activity (Pääasiallinen toiminta)
Dim sex, Statfinpas tyokay pxt 020 201600 px, Full historyTSV
Dimension Sex (Sukupuoli)
Dim sex, Statfinpas tyokay pxt 020 201600 px, LatestTSV
Dimension Sex (Sukupuoli)
Dim socioeconomic status, Statfinpas tyokay pxt 020 201600 px, Full historyTSV
Dimension Socioeconomic_status (Sosioekonominen asema)
Dim socioeconomic status, Statfinpas tyokay pxt 020 201600 px, LatestTSV
Dimension Socioeconomic_status (Sosioekonominen asema)
Dim year, Statfinpas tyokay pxt 020 201600 px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfinpas tyokay pxt 020 201600 px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfinpas tyokay pxt 020 201600 px, Full historyTSV
Population by Socio-economic status, Main type of activity, Sex, Age and Year
Fact, Statfinpas tyokay pxt 020 201600 px, LatestTSV
Population by Socio-economic status, Main type of activity, Sex, Age and Year

Column Descriptions

Dim year, Statfinpas tyokay pxt 020 201600 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010 and maximum value is 2016.
label	int	The label for the dimension value. Column label has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010 and maximum value is 2016.

Dim age, Statfinpas tyokay pxt 020 201600 px, Full history

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

Dim socioeconomic status, Statfinpas tyokay pxt 020 201600 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 23 rows, out of which 1 are empty, making the null percent 4.35. Minimum value is 1 and maximum value is 54.
label	string	The label for the dimension value. Column label has 23 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 10 Farmer etc. entrepeneu... and first 25 characters of maximum string: 9 Unknown...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim socioeconomic status, Statfinpas tyokay pxt 020 201600 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 23 rows, out of which 1 are empty, making the null percent 4.35. Minimum value is 1 and maximum value is 54.
label	string	The label for the dimension value. Column label has 23 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 10 Farmer etc. entrepeneu... and first 25 characters of maximum string: 9 Unknown...

Dim year, Statfinpas tyokay pxt 020 201600 px, Full history

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

Dim main type of activity, Statfinpas tyokay pxt 020 201600 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 3 rows, out of which 2 are empty, making the null percent 66.67. Constant value is 11.
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. First 25 characters of minimum string: Employed... and first 25 characters of maximum string: Unemployed and persons ou...

Dim main type of activity, Statfinpas tyokay pxt 020 201600 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 3 rows, out of which 2 are empty, making the null percent 66.67. Constant value is 11.
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. First 25 characters of minimum string: Employed... and first 25 characters of maximum string: Unemployed and persons ou...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim age, Statfinpas tyokay pxt 020 201600 px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0-17 and maximum string is 75-.
label	string	The label for the dimension value. Column label has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 - 17 and maximum string is 75 -.

Dim sex, Statfinpas tyokay pxt 020 201600 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 Both sexes and maximum string is Females.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim sex, Statfinpas tyokay pxt 020 201600 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 Both sexes and maximum string is Females.

Fact, Statfinpas tyokay pxt 020 201600 px, Full history

Column	Type	Comment
socioeconomic_status	int	Datasource did not contain a description for Socioeconomic_status. Column socioeconomic_status has 13041 rows, out of which 567 are empty, making the null percent 4.35. Minimum value is 1 and maximum value is 54.
main_type_of_activity	string	Datasource did not contain a description for Main_type_of_activity. Column main_type_of_activity has 13041 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 11 and maximum string is 12-99.
sex	int	Datasource did not contain a description for Sex. Column sex has 13041 rows, out of which 4347 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
age	string	Datasource did not contain a description for Age. Column age has 13041 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0-17 and maximum string is 75-.
year	int	Datasource did not contain a description for Year. Column year has 13041 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010 and maximum value is 2016.
population	int	Datasource did not contain a description for Population. Column population has 13041 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 5503297.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfinpas tyokay pxt 020 201600 px, Latest

Column	Type	Comment
socioeconomic_status	int	Datasource did not contain a description for Socioeconomic_status. Column socioeconomic_status has 13041 rows, out of which 567 are empty, making the null percent 4.35. Minimum value is 1 and maximum value is 54.
main_type_of_activity	string	Datasource did not contain a description for Main_type_of_activity. Column main_type_of_activity has 13041 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 11 and maximum string is 12-99.
sex	int	Datasource did not contain a description for Sex. Column sex has 13041 rows, out of which 4347 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
age	string	Datasource did not contain a description for Age. Column age has 13041 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0-17 and maximum string is 75-.
year	int	Datasource did not contain a description for Year. Column year has 13041 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010 and maximum value is 2016.
population	int	Datasource did not contain a description for Population. Column population has 13041 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 5503297.

Additional Info

Last Updated	September 22, 2019
Created	August 6, 2019