1. Home
  2. Datasets
  3. Työpaikat Helsingissä ...
To download the data set, please sign up or log in

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

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

Tables

Column Descriptions

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

Column Type Comment
alue int Datasource did not contain a description for Alue. Column alue has 91728 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 91728 rows, out of which 1092 are empty, making the null percent 1.19. Minimum value is 1 and maximum value is 83.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 91728 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.
h2_tyopaikat_helsingissa_alueella_tyossakayvat_toimialan_tol_2002_23nro_mukaan_31_12_20022007 int Datasource did not contain a description for H2_Tyopaikat_Helsingissa_alueella_tyossakayvat_toimialan_TOL_2002_23nro_mukaan_31_12_20022007. Column h2_tyopaikat_helsingissa_alueella_tyossakayvat_toimialan_tol_2002_23nro_mukaan_31_12_20022007 has 91728 rows, out of which 12432 are empty, making the null percent 13.55. Minimum value is 0 and maximum value is 385356.
orig_extractdate string The date when the data was originally fetched from the source.

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

Column Type Comment
code int The code for the dimension value. Column code has 182 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 182 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 and maximum string is 091 997 Esikaupungit.
orig_extractdate string The date when the data was originally fetched from the source.

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

Column Type Comment
code int The code for the dimension value. Column code has 84 rows, out of which 1 are empty, making the null percent 1.19. Minimum value is 1 and maximum value is 83.
label string The label for the dimension value. Column label has 84 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 15 Elintarvikkeiden ja ju... 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 2002 2 3 Nro Mukaan 31 12

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 April 12, 2019
Created February 4, 2019