1. Home
  2. Datasets
  3. 007 -- Kokoaikaisten ...
To download the data set, please sign up or log in

007 -- Kokoaikaisten palkansaajien kokonaisansiot maakunnan ja työnantajasektorin mukaan vuonna 2009

007 -- Kokoaikaisten palkansaajien kokonaisansiot maakunnan ja työnantajasektorin mukaan vuonna 2009

Tables

Column Descriptions

Dim maakunta, Statfinpas pra pxt 007 200900 fi px, Full history

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

Dim maakunta, Statfinpas pra pxt 007 200900 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 22 rows, out of which 2 are empty, making the null percent 9.09. Minimum value is 1 and maximum value is 21.
label string The label for the dimension value. Column label has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 01 Uusimaa and maximum string is Tuntematon.

Dim sukupuoli, Statfinpas pra pxt 007 200900 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.

Dim sukupuoli, Statfinpas pra pxt 007 200900 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, Statfinpas pra pxt 007 200900 fi px, Latest

Column Type Comment
maakunta int Datasource did not contain a description for Maakunta. Column maakunta has 1584 rows, out of which 144 are empty, making the null percent 9.09. Minimum value is 1 and maximum value is 21.
tyonantajasektori string Datasource did not contain a description for Tyonantajasektori. Column tyonantajasektori has 1584 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is K and maximum string is V.
sukupuoli int Datasource did not contain a description for Sukupuoli. Column sukupuoli has 1584 rows, out of which 528 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 1584 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kkp_cv and maximum string is Kkp_p90.
kokoaikaisten_palkansaajien_kokonaisansiot_maakunnan_ja_tyonantajasektorin_mukaan_vuonna_2009 int Datasource did not contain a description for Kokoaikaisten_palkansaajien_kokonaisansiot_maakunnan_ja_tyonantajasektorin_mukaan_vuonna_2009. Column kokoaikaisten_palkansaajien_kokonaisansiot_maakunnan_ja_tyonantajasektorin_mukaan_vuonna_2009 has 1584 rows, out of which 46 are empty, making the null percent 2.90. Minimum value is 1 and maximum value is 1387953.

Fact, Statfinpas pra pxt 007 200900 fi px, Full history

Column Type Comment
maakunta int Datasource did not contain a description for Maakunta. Column maakunta has 1584 rows, out of which 144 are empty, making the null percent 9.09. Minimum value is 1 and maximum value is 21.
tyonantajasektori string Datasource did not contain a description for Tyonantajasektori. Column tyonantajasektori has 1584 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is K and maximum string is V.
sukupuoli int Datasource did not contain a description for Sukupuoli. Column sukupuoli has 1584 rows, out of which 528 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 1584 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kkp_cv and maximum string is Kkp_p90.
kokoaikaisten_palkansaajien_kokonaisansiot_maakunnan_ja_tyonantajasektorin_mukaan_vuonna_2009 int Datasource did not contain a description for Kokoaikaisten_palkansaajien_kokonaisansiot_maakunnan_ja_tyonantajasektorin_mukaan_vuonna_2009. Column kokoaikaisten_palkansaajien_kokonaisansiot_maakunnan_ja_tyonantajasektorin_mukaan_vuonna_2009 has 1584 rows, out of which 46 are empty, making the null percent 2.90. Minimum value is 1 and maximum value is 1387953.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tyonantajasektori, Statfinpas pra pxt 007 200900 fi px, Full history

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

Dim tyonantajasektori, Statfinpas pra pxt 007 200900 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is K and maximum string is V.
label string The label for the dimension value. Column label has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kuntasektori and maximum string is Valtio.

Dim tiedot, Statfinpas pra pxt 007 200900 fi px, Full history

Column Type Comment
code string 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 string is Kkp_cv and maximum string is Kkp_p90.
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. First 25 characters of minimum string: Kokonaisansion 1.desiili,... and first 25 characters of maximum string: Kokonaisansion variaatiok...
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, Statfinpas pra pxt 007 200900 fi px, Latest

Column Type Comment
code string 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 string is Kkp_cv and maximum string is Kkp_p90.
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. First 25 characters of minimum string: Kokonaisansion 1.desiili,... and first 25 characters of maximum string: Kokonaisansion variaatiok...

Additional Info

Last Updated July 21, 2019
Created July 19, 2019