Employed hrst-personnel by occupation and level of education in 2000, 2004, 2005, 2007 and 2008 (TOL 2002)

Tables

Dim degree of education, T110 tthv tau 111 en px, Full historyTSV
Dimension Degree_of_education (Degree of education)
Dim degree of education, T110 tthv tau 111 en px, LatestTSV
Dimension Degree_of_education (Degree of education)
Dim industry, T110 tthv tau 111 en px, Full historyTSV
Dimension Industry (Industry)
Dim industry, T110 tthv tau 111 en px, LatestTSV
Dimension Industry (Industry)
Dim occupation, T110 tthv tau 111 en px, Full historyTSV
Dimension Occupation (Occupation)
Dim occupation, T110 tthv tau 111 en px, LatestTSV
Dimension Occupation (Occupation)
Dim year, T110 tthv tau 111 en px, Full historyTSV
Dimension Year (Year)
Dim year, T110 tthv tau 111 en px, LatestTSV
Dimension Year (Year)
Fact, T110 tthv tau 111 en px, Full historyTSV
Employed hrst-personnel by occupation and level of education in 2000, 2004, 2005, 2007 and 2008 (Standard Industrial Classification TOL 2002) by Year, Industry, Occupation, Degree of education, Gender and Data
Fact, T110 tthv tau 111 en px, LatestTSV
Employed hrst-personnel by occupation and level of education in 2000, 2004, 2005, 2007 and 2008 (Standard Industrial Classification TOL 2002) by Year, Industry, Occupation, Degree of education, Gender and Data

Column Descriptions

Dim degree of education, T110 tthv tau 111 en px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 8 rows, out of which 5 are empty, making the null percent 62.50. Minimum value is 81 and maximum value is 99.
label	string	The label for the dimension value. Column label has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Degrees of education tota... and first 25 characters of maximum string: Other / unknown degree...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim degree of education, T110 tthv tau 111 en px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 8 rows, out of which 5 are empty, making the null percent 62.50. Minimum value is 81 and maximum value is 99.
label	string	The label for the dimension value. Column label has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Degrees of education tota... and first 25 characters of maximum string: Other / unknown degree...

Dim year, T110 tthv tau 111 en px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2000 and maximum value is 2008.
label	int	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 value is 2000 and maximum value is 2008.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim year, T110 tthv tau 111 en px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2000 and maximum value is 2008.
label	int	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 value is 2000 and maximum value is 2008.

Fact, T110 tthv tau 111 en px, Full history

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 42000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2000 and maximum value is 2008.
industry	string	Datasource did not contain a description for Industry. Column industry has 42000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 01 - 05 and maximum string is 99.
occupation	int	Datasource did not contain a description for Occupation. Column occupation has 42000 rows, out of which 9000 are empty, making the null percent 21.43. Minimum value is 21 and maximum value is 131.
degree_of_education	int	Datasource did not contain a description for Degree_of_education. Column degree_of_education has 42000 rows, out of which 26250 are empty, making the null percent 62.50. Minimum value is 81 and maximum value is 99.
gender	int	Datasource did not contain a description for Gender. Column gender has 42000 rows, out of which 14000 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
data	string	Datasource did not contain a description for Data. Column data has 42000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Lkm.
employed_hrstpersonnel_by_occupation_and_level_of_education_in_2000_2004_2005_2007_and_2008_standard_industrial_classification_tol_2002	int	Datasource did not contain a description for Employed_hrstpersonnel_by_occupation_and_level_of_education_in_2000_2004_2005_2007_and_2008_Standard_Industrial_Classification_TOL_2002. Column employed_hrstpersonnel_by_occupation_and_level_of_education_in_2000_2004_2005_2007_and_2008_standard_industrial_classification_tol_2002 has 42000 rows, out of which 5824 are empty, making the null percent 13.87. Minimum value is 1 and maximum value is 1147066.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim industry, T110 tthv tau 111 en px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 25 rows, out of which 19 are empty, making the null percent 76.00. Minimum value is 45 and maximum value is 642.
label	string	The label for the dimension value. Column label has 25 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Agriculture, forestry and... and first 25 characters of maximum string: Industry unknown...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim industry, T110 tthv tau 111 en px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 25 rows, out of which 19 are empty, making the null percent 76.00. Minimum value is 45 and maximum value is 642.
label	string	The label for the dimension value. Column label has 25 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Agriculture, forestry and... and first 25 characters of maximum string: Industry unknown...

Fact, T110 tthv tau 111 en px, Latest

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 42000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2000 and maximum value is 2008.
industry	string	Datasource did not contain a description for Industry. Column industry has 42000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 01 - 05 and maximum string is 99.
occupation	int	Datasource did not contain a description for Occupation. Column occupation has 42000 rows, out of which 9000 are empty, making the null percent 21.43. Minimum value is 21 and maximum value is 131.
degree_of_education	int	Datasource did not contain a description for Degree_of_education. Column degree_of_education has 42000 rows, out of which 26250 are empty, making the null percent 62.50. Minimum value is 81 and maximum value is 99.
gender	int	Datasource did not contain a description for Gender. Column gender has 42000 rows, out of which 14000 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
data	string	Datasource did not contain a description for Data. Column data has 42000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Lkm.
employed_hrstpersonnel_by_occupation_and_level_of_education_in_2000_2004_2005_2007_and_2008_standard_industrial_classification_tol_2002	int	Datasource did not contain a description for Employed_hrstpersonnel_by_occupation_and_level_of_education_in_2000_2004_2005_2007_and_2008_Standard_Industrial_Classification_TOL_2002. Column employed_hrstpersonnel_by_occupation_and_level_of_education_in_2000_2004_2005_2007_and_2008_standard_industrial_classification_tol_2002 has 42000 rows, out of which 5824 are empty, making the null percent 13.87. Minimum value is 1 and maximum value is 1147066.

Dim occupation, T110 tthv tau 111 en px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 14 rows, out of which 3 are empty, making the null percent 21.43. Minimum value is 21 and maximum value is 131.
label	string	The label for the dimension value. Column label has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Hrst-occupations total... and first 25 characters of maximum string: Other (non-hrst) occupati...

Dim occupation, T110 tthv tau 111 en px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 14 rows, out of which 3 are empty, making the null percent 21.43. Minimum value is 21 and maximum value is 131.
label	string	The label for the dimension value. Column label has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Hrst-occupations total... and first 25 characters of maximum string: Other (non-hrst) occupati...
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	July 20, 2019
Created	July 16, 2019