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

004 -- Ansiotasoindeksin ja säännöllisen ansion indeksin muutosprosentit

004 -- Ansiotasoindeksin ja säännöllisen ansion indeksin muutosprosentit

Tables

Column Descriptions

Dim indeksi, Statfinpas ati pxt 004 2018q4 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 Ati_2005_100 and maximum string is Sani_2015_100.
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 ATI 2005=100 and maximum string is SANI 2015=100.

Dim indeksi, Statfinpas ati pxt 004 2018q4 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 Ati_2005_100 and maximum string is Sani_2015_100.
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 ATI 2005=100 and maximum string is SANI 2015=100.
orig_extractdate string The date when the data was originally fetched from the source.

Dim sektoritoimiala, Statfinpas ati pxt 004 2018q4 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 27 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1_S and maximum string is S AS.
label string The label for the dimension value. Column label has 27 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A Maa- ja metsätalous and maximum string is S Muu palvelutoiminta.
orig_extractdate string The date when the data was originally fetched from the source.

Dim muutos, Statfinpas ati pxt 004 2018q4 fi px, Full history

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

Dim muutos, Statfinpas ati pxt 004 2018q4 fi px, Latest

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

Fact, Statfinpas ati pxt 004 2018q4 fi px, Full history

Column Type Comment
indeksi string Datasource did not contain a description for Indeksi. Column indeksi has 15120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ati_2005_100 and maximum string is Sani_2015_100.
sektoritoimiala string 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 sektoritoimiala has 15120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1_S and maximum string is S AS.
muutos int Datasource did not contain a description for Muutos. Column muutos has 15120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 3.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 15120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2018.
neljannes string Datasource did not contain a description for Neljannes. Column neljannes has 15120 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.
ansiotasoindeksin_ja_saannollisen_ansion_indeksin_muutosprosentit int Datasource did not contain a description for Ansiotasoindeksin_ja_saannollisen_ansion_indeksin_muutosprosentit. Column ansiotasoindeksin_ja_saannollisen_ansion_indeksin_muutosprosentit has 15120 rows, out of which 7020 are empty, making the null percent 46.43. Minimum value is -1 and maximum value is 9.
orig_extractdate string The date when the data was originally fetched from the source.

Dim neljannes, Statfinpas ati pxt 004 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.

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

Column Type Comment
indeksi string Datasource did not contain a description for Indeksi. Column indeksi has 15120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ati_2005_100 and maximum string is Sani_2015_100.
sektoritoimiala string 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 sektoritoimiala has 15120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1_S and maximum string is S AS.
muutos int Datasource did not contain a description for Muutos. Column muutos has 15120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 3.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 15120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2018.
neljannes string Datasource did not contain a description for Neljannes. Column neljannes has 15120 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.
ansiotasoindeksin_ja_saannollisen_ansion_indeksin_muutosprosentit int Datasource did not contain a description for Ansiotasoindeksin_ja_saannollisen_ansion_indeksin_muutosprosentit. Column ansiotasoindeksin_ja_saannollisen_ansion_indeksin_muutosprosentit has 15120 rows, out of which 7020 are empty, making the null percent 46.43. Minimum value is -1 and maximum value is 9.

Dim sektoritoimiala, Statfinpas ati pxt 004 2018q4 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 27 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1_S and maximum string is S AS.
label string The label for the dimension value. Column label has 27 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A Maa- ja metsätalous and maximum string is S Muu palvelutoiminta.

Dim neljannes, Statfinpas ati pxt 004 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 vuosi, Statfinpas ati pxt 004 2018q4 fi px, Full history

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

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

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

Additional Info

Last Updated September 22, 2019
Created August 6, 2019