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

906 -- Avoimet työpaikat lääneittäin 2003-2011

906 -- Avoimet työpaikat lääneittäin 2003-2011

Tables

Column Descriptions

Fact, Statfinpas atp pxt 906 2011q4 fi px, Latest

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 270 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 2011.
neljannesvuosi_ja_vuosikeskiarvo string Datasource did not contain a description for Neljannesvuosi_ja_vuosikeskiarvo. Column neljannesvuosi_ja_vuosikeskiarvo has 270 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.
suuralue int Datasource did not contain a description for Suuralue. Column suuralue has 270 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 5.
avoimet_tyopaikat_laaneittain_20032011 int Datasource did not contain a description for Avoimet_tyopaikat_laaneittain_20032011. Column avoimet_tyopaikat_laaneittain_20032011 has 270 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2000 and maximum value is 80400.

Dim suuralue, Statfinpas atp pxt 906 2011q4 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 0 and maximum value is 5.
label string 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 string is Etelä-Suomi (pl. Uusimaa) and maximum string is Oulu + Lappi.

Dim suuralue, Statfinpas atp pxt 906 2011q4 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 0 and maximum value is 5.
label string 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 string is Etelä-Suomi (pl. Uusimaa) and maximum string is Oulu + Lappi.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas atp pxt 906 2011q4 fi px, Full history

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 270 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 2011.
neljannesvuosi_ja_vuosikeskiarvo string Datasource did not contain a description for Neljannesvuosi_ja_vuosikeskiarvo. Column neljannesvuosi_ja_vuosikeskiarvo has 270 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.
suuralue int Datasource did not contain a description for Suuralue. Column suuralue has 270 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 5.
avoimet_tyopaikat_laaneittain_20032011 int Datasource did not contain a description for Avoimet_tyopaikat_laaneittain_20032011. Column avoimet_tyopaikat_laaneittain_20032011 has 270 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2000 and maximum value is 80400.
orig_extractdate string The date when the data was originally fetched from the source.

Dim neljannesvuosi ja vuosikeskiarvo, Statfinpas atp pxt 906 2011q4 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 vuosi, Statfinpas atp pxt 906 2011q4 fi px, Full history

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 2003 and maximum value is 2011.
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 2003 and maximum value is 2011.
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosi, Statfinpas atp pxt 906 2011q4 fi px, Latest

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 2003 and maximum value is 2011.
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 2003 and maximum value is 2011.

Additional Info

Last Updated July 21, 2019
Created July 13, 2019