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

Palveluiden alue- ja toimialatiedot (TOL 2002)

Palveluiden alue- ja toimialatiedot (TOL 2002)

Tables

Column Descriptions

Fact, T010 pata tau 101 fi px, Latest

Column Type Comment
toimiala int Datasource did not contain a description for Toimiala. Column toimiala has 10560 rows, out of which 6336 are empty, making the null percent 60.00. Minimum value is 50 and maximum value is 74.
maakunta int Datasource did not contain a description for Maakunta. Column maakunta has 10560 rows, out of which 480 are empty, making the null percent 4.55. Minimum value is 1 and maximum value is 200.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 10560 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Braeu2 and maximum string is Toplkm.
tilastovuosi int Datasource did not contain a description for Tilastovuosi. Column tilastovuosi has 10560 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2002 and maximum value is 2007.
palveluiden_alue_ja_toimialatilasto int Datasource did not contain a description for Palveluiden_alue_ja_toimialatilasto. Column palveluiden_alue_ja_toimialatilasto has 10560 rows, out of which 168 are empty, making the null percent 1.59. Minimum value is -162249 and maximum value is 28655866.

Fact, T010 pata tau 101 fi px, Full history

Column Type Comment
toimiala int Datasource did not contain a description for Toimiala. Column toimiala has 10560 rows, out of which 6336 are empty, making the null percent 60.00. Minimum value is 50 and maximum value is 74.
maakunta int Datasource did not contain a description for Maakunta. Column maakunta has 10560 rows, out of which 480 are empty, making the null percent 4.55. Minimum value is 1 and maximum value is 200.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 10560 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Braeu2 and maximum string is Toplkm.
tilastovuosi int Datasource did not contain a description for Tilastovuosi. Column tilastovuosi has 10560 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2002 and maximum value is 2007.
palveluiden_alue_ja_toimialatilasto int Datasource did not contain a description for Palveluiden_alue_ja_toimialatilasto. Column palveluiden_alue_ja_toimialatilasto has 10560 rows, out of which 168 are empty, making the null percent 1.59. Minimum value is -162249 and maximum value is 28655866.
orig_extractdate string The date when the data was originally fetched from the source.

Dim toimiala, T010 pata tau 101 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 10 rows, out of which 6 are empty, making the null percent 60.00. Minimum value is 50 and maximum value is 74.
label string The label for the dimension value. Column label has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 50 Moottoriajon.kauppa, k... and first 25 characters of maximum string: 553-555 Ravitsemistoimint...

Dim toimiala, T010 pata tau 101 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 10 rows, out of which 6 are empty, making the null percent 60.00. Minimum value is 50 and maximum value is 74.
label string The label for the dimension value. Column label has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 50 Moottoriajon.kauppa, k... and first 25 characters of maximum string: 553-555 Ravitsemistoimint...
orig_extractdate string The date when the data was originally fetched from the source.

Dim maakunta, T010 pata tau 101 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 22 rows, out of which 1 are empty, making the null percent 4.55. Minimum value is 1 and maximum value is 200.
label string The label for the dimension value. Column label has 22 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 Uusimaa... and first 25 characters of maximum string: 200 Tuntematon tai ulkoma...
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, T010 pata tau 101 fi 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 Braeu2 and maximum string is Toplkm.
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. Minimum string is Henkilöstö yhteensä and maximum string is Toimipaikkojen lukumäärä.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, T010 pata tau 101 fi 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 Braeu2 and maximum string is Toplkm.
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. Minimum string is Henkilöstö yhteensä and maximum string is Toimipaikkojen lukumäärä.

Dim tilastovuosi, T010 pata tau 101 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 2002 and maximum value is 2007.
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 2002 and maximum value is 2007.

Dim tilastovuosi, T010 pata tau 101 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 2002 and maximum value is 2007.
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 2002 and maximum value is 2007.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 22, 2019
Created July 22, 2019