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

Toimipaikat toimialoittain 2001-2007 (TOL 2002)

Toimipaikat toimialoittain 2001-2007 (TOL 2002)

Tables

Column Descriptions

Dim toimipaikan tiedot, T120 syr 2007 tau 112 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, T120 syr 2007 tau 112 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.

Dim vuosi, T120 syr 2007 tau 112 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 2001 and maximum value is 2007.
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 2001 and maximum value is 2007.
orig_extractdate string The date when the data was originally fetched from the source.

Dim toimiala, T120 syr 2007 tau 112 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 968 rows, out of which 36 are empty, making the null percent 3.72. Minimum value is 1 and maximum value is 99999.
label string The label for the dimension value. Column label has 968 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01111 Viljakasvien sekä p... and first 25 characters of maximum string: 99999 Toimiala tuntematon...
orig_extractdate string The date when the data was originally fetched from the source.

Fact, T120 syr 2007 tau 112 fi px, Latest

Column Type Comment
toimiala int Toimialaluokitus 2002 . Column toimiala has 47432 rows, out of which 1764 are empty, making the null percent 3.72. Minimum value is 1 and maximum value is 99999.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 47432 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2001 and maximum value is 2007.
toimipaikan_tiedot int Datasource did not contain a description for Toimipaikan_tiedot. Column toimipaikan_tiedot has 47432 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_vv_20012007_tol2002mukaisena int Datasource did not contain a description for Toimipaikat_toimialoittain_vv_20012007_tol2002mukaisena. Column toimipaikat_toimialoittain_vv_20012007_tol2002mukaisena has 47432 rows, out of which 7133 are empty, making the null percent 15.04. Minimum value is 1 and maximum value is 372486826.

Dim toimiala, T120 syr 2007 tau 112 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 968 rows, out of which 36 are empty, making the null percent 3.72. Minimum value is 1 and maximum value is 99999.
label string The label for the dimension value. Column label has 968 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01111 Viljakasvien sekä p... and first 25 characters of maximum string: 99999 Toimiala tuntematon...

Fact, T120 syr 2007 tau 112 fi px, Full history

Column Type Comment
toimiala int Toimialaluokitus 2002 . Column toimiala has 47432 rows, out of which 1764 are empty, making the null percent 3.72. Minimum value is 1 and maximum value is 99999.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 47432 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2001 and maximum value is 2007.
toimipaikan_tiedot int Datasource did not contain a description for Toimipaikan_tiedot. Column toimipaikan_tiedot has 47432 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_vv_20012007_tol2002mukaisena int Datasource did not contain a description for Toimipaikat_toimialoittain_vv_20012007_tol2002mukaisena. Column toimipaikat_toimialoittain_vv_20012007_tol2002mukaisena has 47432 rows, out of which 7133 are empty, making the null percent 15.04. Minimum value is 1 and maximum value is 372486826.
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosi, T120 syr 2007 tau 112 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 2001 and maximum value is 2007.
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 2001 and maximum value is 2007.

Additional Info

Last Updated July 20, 2019
Created July 16, 2019