1. Home
  2. Datasets
  3. 001 -- Ansiotasoindeksi ja ...
To download the data set, please sign up or log in

001 -- Ansiotasoindeksi ja säännöllisen ansion indeksi työnantajasektoreittain

001 -- Ansiotasoindeksi ja säännöllisen ansion indeksi työnantajasektoreittain

Tables

Column Descriptions

Dim palkkausmuoto, Statfinpas ati pxt 001 2018q4 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 3 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 T.
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 Kuukausipalkkaiset and maximum string is Tuntipalkkaiset.

Dim sukupuoli, Statfinpas ati pxt 001 2018q4 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 ati pxt 001 2018q4 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 ati pxt 001 2018q4 fi px, Full history

Column Type Comment
indeksi string Datasource did not contain a description for Indeksi. Column indeksi has 37800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ati_1995_100 and maximum string is Sani_2015_100.
sektori int Ansiotasoindeksissä käytettävä sektoriluokitus on rakenteeltaan seuraava: Kuntasektori Kuntien ja kuntayhtymien toimintayksiköt sekä kuntien liikelaitokset Valtio Valtion budjettitalouden piirissä olevat virastot ja laitokset Yksityinen sektori Yksityiset yritykset, valtio- ja kuntaenemmistöiset yritykset sekä valtion liikelaitokset Muut Voittoa tavoittelemattomat yhteisöt, seurakunnat sekä järjestöt. Vuodesta 2010 alkaen yliopistot kuuluvat muut-sektoriin. . Column sektori has 37800 rows, out of which 7560 are empty, making the null percent 20.00. Minimum value is 1 and maximum value is 7.
palkkausmuoto string Datasource did not contain a description for Palkkausmuoto. Column palkkausmuoto has 37800 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 T.
sukupuoli int Palkansaajan sukupuoli . Column sukupuoli has 37800 rows, out of which 12600 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 37800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1995 and maximum value is 2018.
neljannes string Datasource did not contain a description for Neljannes. Column neljannes has 37800 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 Q1-Q4.
ansiotasoindeksi_ja_saannollisen_ansion_indeksi_tyonantajasektoreittain int Datasource did not contain a description for Ansiotasoindeksi_ja_saannollisen_ansion_indeksi_tyonantajasektoreittain. Column ansiotasoindeksi_ja_saannollisen_ansion_indeksi_tyonantajasektoreittain has 37800 rows, out of which 23880 are empty, making the null percent 63.17. Minimum value is 97 and maximum value is 224.
orig_extractdate string The date when the data was originally fetched from the source.

Dim sektori, Statfinpas ati pxt 001 2018q4 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 5 rows, out of which 1 are empty, making the null percent 20.00. Minimum value is 1 and maximum value is 7.
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 Kunnat and maximum string is Muut.

Dim sektori, Statfinpas ati pxt 001 2018q4 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 5 rows, out of which 1 are empty, making the null percent 20.00. Minimum value is 1 and maximum value is 7.
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 Kunnat and maximum string is Muut.
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosi, Statfinpas ati pxt 001 2018q4 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 24 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1995 and maximum value is 2018.
label int The label for the dimension value. Column label has 24 rows, out of which 1 are empty, making the null percent 4.17. Minimum value is 1995 and maximum value is 2017.

Dim vuosi, Statfinpas ati pxt 001 2018q4 fi px, Full history

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

Fact, Statfinpas ati pxt 001 2018q4 fi px, Latest

Column Type Comment
indeksi string Datasource did not contain a description for Indeksi. Column indeksi has 37800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ati_1995_100 and maximum string is Sani_2015_100.
sektori int Ansiotasoindeksissä käytettävä sektoriluokitus on rakenteeltaan seuraava: Kuntasektori Kuntien ja kuntayhtymien toimintayksiköt sekä kuntien liikelaitokset Valtio Valtion budjettitalouden piirissä olevat virastot ja laitokset Yksityinen sektori Yksityiset yritykset, valtio- ja kuntaenemmistöiset yritykset sekä valtion liikelaitokset Muut Voittoa tavoittelemattomat yhteisöt, seurakunnat sekä järjestöt. Vuodesta 2010 alkaen yliopistot kuuluvat muut-sektoriin. . Column sektori has 37800 rows, out of which 7560 are empty, making the null percent 20.00. Minimum value is 1 and maximum value is 7.
palkkausmuoto string Datasource did not contain a description for Palkkausmuoto. Column palkkausmuoto has 37800 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 T.
sukupuoli int Palkansaajan sukupuoli . Column sukupuoli has 37800 rows, out of which 12600 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 37800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1995 and maximum value is 2018.
neljannes string Datasource did not contain a description for Neljannes. Column neljannes has 37800 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 Q1-Q4.
ansiotasoindeksi_ja_saannollisen_ansion_indeksi_tyonantajasektoreittain int Datasource did not contain a description for Ansiotasoindeksi_ja_saannollisen_ansion_indeksi_tyonantajasektoreittain. Column ansiotasoindeksi_ja_saannollisen_ansion_indeksi_tyonantajasektoreittain has 37800 rows, out of which 23880 are empty, making the null percent 63.17. Minimum value is 97 and maximum value is 224.

Dim neljannes, Statfinpas ati pxt 001 2018q4 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 Q1-Q4.
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 1.-4. vuosineljännes and maximum string is 4. vuosineljännes.
orig_extractdate string The date when the data was originally fetched from the source.

Dim neljannes, Statfinpas ati pxt 001 2018q4 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 Q1-Q4.
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 1.-4. vuosineljännes and maximum string is 4. vuosineljännes.

Dim indeksi, Statfinpas ati pxt 001 2018q4 fi px, Full history

Column Type Comment
code string 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 string is Ati_1995_100 and maximum string is Sani_2015_100.
label string 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 string is ATI 1995=100 and maximum string is SANI 2015=100.
orig_extractdate string The date when the data was originally fetched from the source.

Dim palkkausmuoto, Statfinpas ati pxt 001 2018q4 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 3 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 T.
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 Kuukausipalkkaiset and maximum string is Tuntipalkkaiset.
orig_extractdate string The date when the data was originally fetched from the source.

Dim indeksi, Statfinpas ati pxt 001 2018q4 fi px, Latest

Column Type Comment
code string 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 string is Ati_1995_100 and maximum string is Sani_2015_100.
label string 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 string is ATI 1995=100 and maximum string is SANI 2015=100.

Additional Info

Last Updated July 21, 2019
Created July 18, 2019