To download the data set, please sign up or log in
Työpaikat (alueella työssäkäyvät) toimialan (TOL 2008, 2-3-nro) mukaan 31.12.
Tables
-
Dim Alue, Tyopaikat Alueella Tyossakayvat Toimialan Tol 2008 2 3 Nro Mukaan 31 12TSV
Dimension Alue (Alue)
-
Dim Toimiala, Tyopaikat Alueella Tyossakayvat Toimialan Tol 2008 2 3 Nro Mukaan 31 12TSV
Dimension Toimiala (Toimiala)
-
Dim Vuosi, Tyopaikat Alueella Tyossakayvat Toimialan Tol 2008 2 3 Nro Mukaan 31 12TSV
Dimension Vuosi (Vuosi)
-
Fact, Tyopaikat Alueella Tyossakayvat Toimialan Tol 2008 2 3 Nro Mukaan 31 12TSV
Työpaikat (alueella työssäkäyvät) toimialan (TOL 2008, 2-3-nro) mukaan 31.12.
Column Descriptions
Dim Toimiala, Tyopaikat 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 Alue, Tyopaikat 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 18 rows, out of which 4 are empty, making the null percent 22.22. Minimum value is 49 and maximum value is 927. |
| label | string | The label for the dimension value. Column label has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Espoo and maximum string is Suomi. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Dim Vuosi, Tyopaikat 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. |
Fact, Tyopaikat 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 15552 rows, out of which 3456 are empty, making the null percent 22.22. Minimum value is 49 and maximum value is 927. |
| toimiala | int | Datasource did not contain a description for Toimiala. Column toimiala has 15552 rows, out of which 162 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 15552 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. |
| tyopaikat_alueella_tyossakayvat_toimialan_tol_2008_23nro_mukaan_31_12_2008 | int | Datasource did not contain a description for Tyopaikat_alueella_tyossakayvat_toimialan_TOL_2008_23nro_mukaan_31_12_2008. Column tyopaikat_alueella_tyossakayvat_toimialan_tol_2008_23nro_mukaan_31_12_2008 has 15552 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 2377181. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Additional Info
| Last Updated | April 12, 2019 |
|---|---|
| Created | February 3, 2019 |