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

Työpaikat Helsingissä (alueella työssäkäyvät) toimialan (TOL 2008, 2-3-nro) mukaan 31.12.

Työpaikat Helsingissä (alueella työssäkäyvät) toimialan (TOL 2008, 2-3-nro) mukaan 31.12.

Tables

Column Descriptions

Dim Alue, Tyopaikat Helsingissa Alueella Tyossakayvat Toimialan Tol 2008 2 3 Nro Mukaan 31 12

Column Type Comment
code int The code for the dimension value. Column code has 197 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 910000000 and maximum value is 919999999.
label string The label for the dimension value. Column label has 197 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 091 100 Sörnäinen (Ent.) and maximum string is 091 997 Esikaupungit.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Tyopaikat Helsingissa Alueella Tyossakayvat Toimialan Tol 2008 2 3 Nro Mukaan 31 12

Column Type Comment
alue int Datasource did not contain a description for Alue. Column alue has 170208 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 910000000 and maximum value is 919999999.
toimiala int Datasource did not contain a description for Toimiala. Column toimiala has 170208 rows, out of which 1773 are empty, making the null percent 1.04. Minimum value is 1 and maximum value is 95.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 170208 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2008 and maximum value is 2016.
h1_tyopaikat_helsingissa_alueella_tyossakayvat_toimialan_tol_2008_23nro_mukaan_31_12_2008 int Datasource did not contain a description for H1_Tyopaikat_Helsingissa_alueella_tyossakayvat_toimialan_TOL_2008_23nro_mukaan_31_12_2008. Column h1_tyopaikat_helsingissa_alueella_tyossakayvat_toimialan_tol_2008_23nro_mukaan_31_12_2008 has 170208 rows, out of which 28800 are empty, making the null percent 16.92. Minimum value is 0 and maximum value is 388053.
orig_extractdate string The date when the data was originally fetched from the source.

Dim Toimiala, Tyopaikat Helsingissa Alueella Tyossakayvat Toimialan Tol 2008 2 3 Nro Mukaan 31 12

Column Type Comment
code int The code for the dimension value. Column code has 96 rows, out of which 1 are empty, making the null percent 1.04. Minimum value is 1 and maximum value is 95.
label string The label for the dimension value. Column label has 96 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 10 Elintarvikkeiden valmi... and first 25 characters of maximum string: X Toimiala tuntematon...
orig_extractdate string The date when the data was originally fetched from the source.

Dim Vuosi, Tyopaikat Helsingissa Alueella Tyossakayvat Toimialan Tol 2008 2 3 Nro Mukaan 31 12

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

Additional Info

Last Updated April 12, 2019
Created February 2, 2019