To download the data set, please sign up or log in

906 -- Toimipaikat toimialoittain 2007 - 2012(TOL 2008)

906 -- Toimipaikat toimialoittain 2007 - 2012(TOL 2008)

Tables

Column Descriptions

Fact, Statfinpas alyr pxt 906 201200 fi px, Full history

Column Type Comment
toimiala int Datasource did not contain a description for Toimiala. Column toimiala has 45738 rows, out of which 882 are empty, making the null percent 1.93. Minimum value is 0 and maximum value is 96022.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 45738 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2007 and maximum value is 2012.
toimipaikan_tiedot int Datasource did not contain a description for Toimipaikan_tiedot. Column toimipaikan_tiedot has 45738 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 7.
toimipaikat_toimialoittain_vuonna_20072012_tol_2008 int Datasource did not contain a description for Toimipaikat_toimialoittain_vuonna_20072012_TOL_2008. Column toimipaikat_toimialoittain_vuonna_20072012_tol_2008 has 45738 rows, out of which 7881 are empty, making the null percent 17.23. Minimum value is 1 and maximum value is 394578493.
orig_extractdate string The date when the data was originally fetched from the source.

Dim toimipaikan tiedot, Statfinpas alyr pxt 906 201200 fi 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 1 and maximum value is 7.
label string 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 string is Aputoimipaikkoja and maximum string is Toimialayksiköitä.

Dim toimipaikan tiedot, Statfinpas alyr pxt 906 201200 fi 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 1 and maximum value is 7.
label string 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 string is Aputoimipaikkoja and maximum string is Toimialayksiköitä.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas alyr pxt 906 201200 fi px, Latest

Column Type Comment
toimiala int Datasource did not contain a description for Toimiala. Column toimiala has 45738 rows, out of which 882 are empty, making the null percent 1.93. Minimum value is 0 and maximum value is 96022.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 45738 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2007 and maximum value is 2012.
toimipaikan_tiedot int Datasource did not contain a description for Toimipaikan_tiedot. Column toimipaikan_tiedot has 45738 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 7.
toimipaikat_toimialoittain_vuonna_20072012_tol_2008 int Datasource did not contain a description for Toimipaikat_toimialoittain_vuonna_20072012_TOL_2008. Column toimipaikat_toimialoittain_vuonna_20072012_tol_2008 has 45738 rows, out of which 7881 are empty, making the null percent 17.23. Minimum value is 1 and maximum value is 394578493.

Dim vuosi, Statfinpas alyr pxt 906 201200 fi px, Latest

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

Dim vuosi, Statfinpas alyr pxt 906 201200 fi px, Full history

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

Dim toimiala, Statfinpas alyr pxt 906 201200 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 1089 rows, out of which 21 are empty, making the null percent 1.93. Minimum value is 0 and maximum value is 96022.
label string The label for the dimension value. Column label has 1089 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 00 Toimiala tuntematon and maximum string is X Toimiala tuntematon.

Dim toimiala, Statfinpas alyr pxt 906 201200 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 1089 rows, out of which 21 are empty, making the null percent 1.93. Minimum value is 0 and maximum value is 96022.
label string The label for the dimension value. Column label has 1089 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 00 Toimiala tuntematon and maximum string is X Toimiala tuntematon.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 21, 2019
Created July 13, 2019