004 -- Employees and self-employed persons aged 15-74

Tables

Dim information, Statfinpas tyti pxt 004 2018q4 px, Full historyTSV
Dimension Information (Tiedot)
Dim information, Statfinpas tyti pxt 004 2018q4 px, LatestTSV
Dimension Information (Tiedot)
Dim period, Statfinpas tyti pxt 004 2018q4 px, Full historyTSV
Dimension Period (Ajanjakso)
Dim period, Statfinpas tyti pxt 004 2018q4 px, LatestTSV
Dimension Period (Ajanjakso)
Dim sex, Statfinpas tyti pxt 004 2018q4 px, Full historyTSV
Dimension Sex (Sukupuoli)
Dim sex, Statfinpas tyti pxt 004 2018q4 px, LatestTSV
Dimension Sex (Sukupuoli)
Dim year, Statfinpas tyti pxt 004 2018q4 px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfinpas tyti pxt 004 2018q4 px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfinpas tyti pxt 004 2018q4 px, Full historyTSV
004 -- Employees and self-employed persons aged 15-74
Fact, Statfinpas tyti pxt 004 2018q4 px, LatestTSV
004 -- Employees and self-employed persons aged 15-74

Column Descriptions

Fact, Statfinpas tyti pxt 004 2018q4 px, Latest

Column	Type	Comment
period	string	Datasource did not contain a description for Period. Column period has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ** and maximum string is Q4.
sex	int	Datasource did not contain a description for Sex. Column sex has 3600 rows, out of which 1200 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
information	string	Datasource did not contain a description for Information. Column information has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Palkansaaja and maximum string is Yksinyrittaja_pl_mmt.
year	int	Datasource did not contain a description for Year. Column year has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1989 and maximum value is 2018.
employees_and_selfemployed_persons	int	Datasource did not contain a description for Employees_and_selfemployed_persons. Column employees_and_selfemployed_persons has 3600 rows, out of which 240 are empty, making the null percent 6.67. Minimum value is 3 and maximum value is 2577.

Dim sex, Statfinpas tyti pxt 004 2018q4 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 information, Statfinpas tyti pxt 004 2018q4 px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Palkansaaja and maximum string is Yksinyrittaja_pl_mmt.
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: Employed, 1000 persons... and first 25 characters of maximum string: Self-employed without emp...

Dim year, Statfinpas tyti pxt 004 2018q4 px, Latest

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

Dim year, Statfinpas tyti pxt 004 2018q4 px, Full history

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

Fact, Statfinpas tyti pxt 004 2018q4 px, Full history

Column	Type	Comment
period	string	Datasource did not contain a description for Period. Column period has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ** and maximum string is Q4.
sex	int	Datasource did not contain a description for Sex. Column sex has 3600 rows, out of which 1200 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
information	string	Datasource did not contain a description for Information. Column information has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Palkansaaja and maximum string is Yksinyrittaja_pl_mmt.
year	int	Datasource did not contain a description for Year. Column year has 3600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1989 and maximum value is 2018.
employees_and_selfemployed_persons	int	Datasource did not contain a description for Employees_and_selfemployed_persons. Column employees_and_selfemployed_persons has 3600 rows, out of which 240 are empty, making the null percent 6.67. Minimum value is 3 and maximum value is 2577.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim period, Statfinpas tyti pxt 004 2018q4 px, Full history

Column	Type	Comment
code	string	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 string is ** and maximum string is Q4.
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 III quarter and maximum string is Year.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim information, Statfinpas tyti pxt 004 2018q4 px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Palkansaaja and maximum string is Yksinyrittaja_pl_mmt.
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: Employed, 1000 persons... and first 25 characters of maximum string: Self-employed without emp...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim period, Statfinpas tyti pxt 004 2018q4 px, Latest

Column	Type	Comment
code	string	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 string is ** and maximum string is Q4.
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 III quarter and maximum string is Year.

Dim sex, Statfinpas tyti pxt 004 2018q4 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.

Additional Info

Last Updated	July 21, 2019
Created	July 14, 2019