1. Home
  2. Datasets
  3. 11 l 3 -- Citizenships ...
To download the data set, please sign up or log in

11 l 3 -- Citizenships granted according to previous nationality, 1990-2017

11 l 3 -- Citizenships granted according to previous nationality, 1990-2017

Tables

Column Descriptions

Fact, Statfin kans pxt 11l3 px, Latest

Column Type Comment
previous_nationality int Countries (ISO 3166). The used classification of continents is the classification of Eurostat, where Cyprus and Turkey belong to Europe. Non-autonomous states are combined with the mother country. Czech Republic = Czech Republic + Former Czechoslovakia Sudan = Sudan + Former Sudan --- HDI = Human Development Index Ranking according to the 2016 HDI index by country: The former Soviet Union is included in the Russia HDI category The former Czechoslovakia is included in the Czech Republic HDI category The former Yugoslavia and Serbia and Montenegro are included in the Serbia HDI category . Column previous_nationality has 301308 rows, out of which 12852 are empty, making the null percent 4.27. Minimum value is 4 and maximum value
sex string Datasource did not contain a description for Sex. Column sex has 301308 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1 and maximum string is 2.
age string Datasource did not contain a description for Age. Column age has 301308 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0-4 and maximum string is 75-.
year int Datasource did not contain a description for Year. Column year has 301308 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1990 and maximum value is 2017.
finnish_citizenships_granted int Datasource did not contain a description for Finnish_citizenships_granted. Column finnish_citizenships_granted has 301308 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 12219.

Dim previous nationality, Statfin kans pxt 11l3 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 211 rows, out of which 9 are empty, making the null percent 4.27. Minimum value is 4 and maximum value is 991.
label string The label for the dimension value. Column label has 211 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Afghanistan and maximum string is Unknown.

Dim age, Statfin kans pxt 11l3 px, Full history

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

Dim year, Statfin kans pxt 11l3 px, Latest

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

Dim sex, Statfin kans pxt 11l3 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 Females and maximum string is Total.

Dim previous nationality, Statfin kans pxt 11l3 px, Full history

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

Dim sex, Statfin kans pxt 11l3 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 Females and maximum string is Total.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin kans pxt 11l3 px, Full history

Column Type Comment
previous_nationality int Countries (ISO 3166). The used classification of continents is the classification of Eurostat, where Cyprus and Turkey belong to Europe. Non-autonomous states are combined with the mother country. Czech Republic = Czech Republic + Former Czechoslovakia Sudan = Sudan + Former Sudan --- HDI = Human Development Index Ranking according to the 2016 HDI index by country: The former Soviet Union is included in the Russia HDI category The former Czechoslovakia is included in the Czech Republic HDI category The former Yugoslavia and Serbia and Montenegro are included in the Serbia HDI category . Column previous_nationality has 301308 rows, out of which 12852 are empty, making the null percent 4.27. Minimum value is 4 and maximum value
sex string Datasource did not contain a description for Sex. Column sex has 301308 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1 and maximum string is 2.
age string Datasource did not contain a description for Age. Column age has 301308 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0-4 and maximum string is 75-.
year int Datasource did not contain a description for Year. Column year has 301308 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1990 and maximum value is 2017.
finnish_citizenships_granted int Datasource did not contain a description for Finnish_citizenships_granted. Column finnish_citizenships_granted has 301308 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 12219.
orig_extractdate string The date when the data was originally fetched from the source.

Dim age, Statfin kans pxt 11l3 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 17 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0-4 and maximum string is 75-.
label string The label for the dimension value. Column label has 17 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 10 - 14 and maximum string is 75 -.

Dim year, Statfin kans pxt 11l3 px, Full history

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

Additional Info

Last Updated July 20, 2019
Created June 12, 2019