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

001 -- Työllinen työvoima kulttuuriammateissa ammatin ja sukupuolen mukaan 2010-2016

001 -- Työllinen työvoima kulttuuriammateissa ammatin ja sukupuolen mukaan 2010-2016

Tables

Column Descriptions

Dim ammattiryhma, Statfin klt pxt 001 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 48 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 1221 Myynti- ja markkin... and first 25 characters of maximum string: 7323 Jälkikäsittelijät ...
label string The label for the dimension value. Column label has 48 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 1221 Myynti- ja markkin... and first 25 characters of maximum string: 7323 Jälkikäsittelijät ...

Dim vuosi, Statfin klt pxt 001 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010 and maximum value is 2016.
label int The label for the dimension value. Column label has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010 and maximum value is 2016.

Dim ammattiryhma, Statfin klt pxt 001 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 48 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 1221 Myynti- ja markkin... and first 25 characters of maximum string: 7323 Jälkikäsittelijät ...
label string The label for the dimension value. Column label has 48 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 1221 Myynti- ja markkin... and first 25 characters of maximum string: 7323 Jälkikäsittelijät ...
orig_extractdate string The date when the data was originally fetched from the source.

Dim sukupuoli, Statfin klt pxt 001 fi px, Full history

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

Fact, Statfin klt pxt 001 fi px, Full history

Column Type Comment
ammattiryhma string Datasource did not contain a description for Ammattiryhma. Column ammattiryhma has 1008 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 1221 Myynti- ja markkin... and first 25 characters of maximum string: 7323 Jälkikäsittelijät ...
sukupuoli int Datasource did not contain a description for Sukupuoli. Column sukupuoli has 1008 rows, out of which 336 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
vuosi int Datasource did not contain a description for vuosi. Column vuosi has 1008 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010 and maximum value is 2016.
tyollinen_tyovoima int Datasource did not contain a description for Tyollinen_tyovoima. Column tyollinen_tyovoima has 1008 rows, out of which 81 are empty, making the null percent 8.04. Minimum value is 3 and maximum value is 91563.
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosi, Statfin klt pxt 001 fi px, Full history

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

Fact, Statfin klt pxt 001 fi px, Latest

Column Type Comment
ammattiryhma string Datasource did not contain a description for Ammattiryhma. Column ammattiryhma has 1008 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 1221 Myynti- ja markkin... and first 25 characters of maximum string: 7323 Jälkikäsittelijät ...
sukupuoli int Datasource did not contain a description for Sukupuoli. Column sukupuoli has 1008 rows, out of which 336 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
vuosi int Datasource did not contain a description for vuosi. Column vuosi has 1008 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010 and maximum value is 2016.
tyollinen_tyovoima int Datasource did not contain a description for Tyollinen_tyovoima. Column tyollinen_tyovoima has 1008 rows, out of which 81 are empty, making the null percent 8.04. Minimum value is 3 and maximum value is 91563.

Dim sukupuoli, Statfin klt pxt 001 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
label string The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Miehet and maximum string is Naiset.

Additional Info

Last Updated June 13, 2019
Created June 12, 2019