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

Toimipaikat maakunnittain ja toimialoittain 2007-2012 (TOL 2008 )

Toimipaikat maakunnittain ja toimialoittain 2007-2012 (TOL 2008 )

Tables

Column Descriptions

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

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

Fact, T090 syr tau 109 fi px, Latest

Column Type Comment
maakunta int Datasource did not contain a description for Maakunta. Column maakunta has 71820 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 Datasource did not contain a description for Toimiala. Column toimiala has 71820 rows, out of which 14364 are empty, making the null percent 20.00. Minimum value is 0 and maximum value is 96.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 71820 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.
toimipaikkojen_tiedot int Datasource did not contain a description for Toimipaikkojen_tiedot. Column toimipaikkojen_tiedot has 71820 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 6.
toimipaikat_maakunnittain_ja_toimialoittain_vuonna_20072012_tol2008 int Datasource did not contain a description for Toimipaikat_maakunnittain_ja_toimialoittain_vuonna_20072012_TOL2008. Column toimipaikat_maakunnittain_ja_toimialoittain_vuonna_20072012_tol2008 has 71820 rows, out of which 23445 are empty, making the null percent 32.64. Minimum value is 0 and maximum value is 187142124.

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

Column Type Comment
code int The code for the dimension value. Column code has 105 rows, out of which 21 are empty, making the null percent 20.00. Minimum value is 0 and maximum value is 96.
label string The label for the dimension value. Column label has 105 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.

Dim toimiala, T090 syr tau 109 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 105 rows, out of which 21 are empty, making the null percent 20.00. Minimum value is 0 and maximum value is 96.
label string The label for the dimension value. Column label has 105 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 vuosi, T090 syr 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 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 vuosi, T090 syr 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 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 toimipaikkojen tiedot, T090 syr 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 1 and maximum value is 6.
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 toimipaikkojen tiedot, T090 syr 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 1 and maximum value is 6.
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 tau 109 fi px, Full history

Column Type Comment
maakunta int Datasource did not contain a description for Maakunta. Column maakunta has 71820 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 Datasource did not contain a description for Toimiala. Column toimiala has 71820 rows, out of which 14364 are empty, making the null percent 20.00. Minimum value is 0 and maximum value is 96.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 71820 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.
toimipaikkojen_tiedot int Datasource did not contain a description for Toimipaikkojen_tiedot. Column toimipaikkojen_tiedot has 71820 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 6.
toimipaikat_maakunnittain_ja_toimialoittain_vuonna_20072012_tol2008 int Datasource did not contain a description for Toimipaikat_maakunnittain_ja_toimialoittain_vuonna_20072012_TOL2008. Column toimipaikat_maakunnittain_ja_toimialoittain_vuonna_20072012_tol2008 has 71820 rows, out of which 23445 are empty, making the null percent 32.64. Minimum value is 0 and maximum value is 187142124.
orig_extractdate string The date when the data was originally fetched from the source.

Dim maakunta, T090 syr tau 109 fi px, Latest

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

Additional Info

Last Updated September 22, 2019
Created August 6, 2019