1. Home
  2. Datasets
  3. Toimipaikat maakunnittain ja ...
To download the data set, please sign up or log in

Toimipaikat maakunnittain ja toimialoittain 2001-2007 (TOL 2002)

Toimipaikat maakunnittain ja toimialoittain 2001-2007 (TOL 2002)

Tables

Column Descriptions

Dim toimipaikkojen tiedot, T090 syr 2007 tau 109 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 0 and maximum value is 5.
label string 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. First 25 characters of minimum string: Aputoimipaikkoja... and first 25 characters of maximum string: Aputoimipaikkojen henkilö...

Dim vuosi, T090 syr 2007 tau 109 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 0 and maximum value is 6.
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.

Dim toimipaikkojen tiedot, T090 syr 2007 tau 109 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 0 and maximum value is 5.
label string 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. First 25 characters of minimum string: Aputoimipaikkoja... and first 25 characters of maximum string: Aputoimipaikkojen henkilö...
orig_extractdate string The date when the data was originally fetched from the source.

Fact, T090 syr 2007 tau 109 fi px, Full history

Column Type Comment
maakunta int Datasource did not contain a description for Maakunta. Column maakunta has 75600 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 21.
toimiala int Toimialaluokitus 2002 . Column toimiala has 75600 rows, out of which 27720 are empty, making the null percent 36.67. Minimum value is 1 and maximum value is 99.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 75600 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 6.
toimipaikkojen_tiedot int Datasource did not contain a description for Toimipaikkojen_tiedot. Column toimipaikkojen_tiedot has 75600 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 5.
toimipaikat_maakunnittain_ja_toimialoittain_20012007_tol_2002 int Datasource did not contain a description for Toimipaikat_maakunnittain_ja_toimialoittain_20012007_TOL_2002. Column toimipaikat_maakunnittain_ja_toimialoittain_20012007_tol_2002 has 75600 rows, out of which 21972 are empty, making the null percent 29.06. Minimum value is 0 and maximum value is 165926434.
orig_extractdate string The date when the data was originally fetched from the source.

Dim toimiala, T090 syr 2007 tau 109 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 90 rows, out of which 33 are empty, making the null percent 36.67. Minimum value is 1 and maximum value is 99.
label string The label for the dimension value. Column label has 90 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01 Maatalous, riistatalou... and first 25 characters of maximum string: 99 Toimiala tuntematon...

Dim toimiala, T090 syr 2007 tau 109 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 90 rows, out of which 33 are empty, making the null percent 36.67. Minimum value is 1 and maximum value is 99.
label string The label for the dimension value. Column label has 90 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01 Maatalous, riistatalou... and first 25 characters of maximum string: 99 Toimiala tuntematon...
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosi, T090 syr 2007 tau 109 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 0 and maximum value is 6.
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 maakunta, T090 syr 2007 tau 109 fi px, Latest

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

Fact, T090 syr 2007 tau 109 fi px, Latest

Column Type Comment
maakunta int Datasource did not contain a description for Maakunta. Column maakunta has 75600 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 21.
toimiala int Toimialaluokitus 2002 . Column toimiala has 75600 rows, out of which 27720 are empty, making the null percent 36.67. Minimum value is 1 and maximum value is 99.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 75600 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 6.
toimipaikkojen_tiedot int Datasource did not contain a description for Toimipaikkojen_tiedot. Column toimipaikkojen_tiedot has 75600 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 5.
toimipaikat_maakunnittain_ja_toimialoittain_20012007_tol_2002 int Datasource did not contain a description for Toimipaikat_maakunnittain_ja_toimialoittain_20012007_TOL_2002. Column toimipaikat_maakunnittain_ja_toimialoittain_20012007_tol_2002 has 75600 rows, out of which 21972 are empty, making the null percent 29.06. Minimum value is 0 and maximum value is 165926434.

Dim maakunta, T090 syr 2007 tau 109 fi px, Full history

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

Additional Info

Last Updated September 22, 2019
Created August 6, 2019