1. Home
  2. Datasets
  3. 905 -- Avoimet työpaikat ...
To download the data set, please sign up or log in

905 -- Avoimet työpaikat toimialan (TOL 2008) mukaan 2003-2012

905 -- Avoimet työpaikat toimialan (TOL 2008) mukaan 2003-2012

Tables

Column Descriptions

Dim neljannesvuosi ja vuosikeskiarvo, Statfinpas atp pxt 905 2012q4 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Q1 and maximum string is YA.
label string The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is III vuosineljännes and maximum string is Vuosikeskiarvo.

Dim tol2008, Statfinpas atp pxt 905 2012q4 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 and maximum string is R.
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: A Maa-, metsä- ja kalatal... and first 25 characters of maximum string: R-S Muut palvelut (90-96)...
orig_extractdate string The date when the data was originally fetched from the source.

Dim neljannesvuosi ja vuosikeskiarvo, Statfinpas atp pxt 905 2012q4 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Q1 and maximum string is YA.
label string The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is III vuosineljännes and maximum string is Vuosikeskiarvo.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas atp pxt 905 2012q4 fi px, Full history

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 500 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2003 and maximum value is 2012.
neljannesvuosi_ja_vuosikeskiarvo string Datasource did not contain a description for Neljannesvuosi_ja_vuosikeskiarvo. Column neljannesvuosi_ja_vuosikeskiarvo has 500 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Q1 and maximum string is YA.
tol2008 string Datasource did not contain a description for TOL2008. Column tol2008 has 500 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 and maximum string is R.
avoimet_tyopaikat_toimialan_tol_2008_mukaan_20032012 int Datasource did not contain a description for Avoimet_tyopaikat_toimialan_TOL_2008_mukaan_20032012. Column avoimet_tyopaikat_toimialan_tol_2008_mukaan_20032012 has 500 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 100 and maximum value is 80400.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas atp pxt 905 2012q4 fi px, Latest

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 500 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2003 and maximum value is 2012.
neljannesvuosi_ja_vuosikeskiarvo string Datasource did not contain a description for Neljannesvuosi_ja_vuosikeskiarvo. Column neljannesvuosi_ja_vuosikeskiarvo has 500 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Q1 and maximum string is YA.
tol2008 string Datasource did not contain a description for TOL2008. Column tol2008 has 500 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 and maximum string is R.
avoimet_tyopaikat_toimialan_tol_2008_mukaan_20032012 int Datasource did not contain a description for Avoimet_tyopaikat_toimialan_TOL_2008_mukaan_20032012. Column avoimet_tyopaikat_toimialan_tol_2008_mukaan_20032012 has 500 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 100 and maximum value is 80400.

Dim tol2008, Statfinpas atp pxt 905 2012q4 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 and maximum string is R.
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: A Maa-, metsä- ja kalatal... and first 25 characters of maximum string: R-S Muut palvelut (90-96)...

Dim vuosi, Statfinpas atp pxt 905 2012q4 fi px, Full history

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

Dim vuosi, Statfinpas atp pxt 905 2012q4 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2003 and maximum value is 2012.
label int 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. Minimum value is 2003 and maximum value is 2012.

Additional Info

Last Updated July 21, 2019
Created July 17, 2019