To download the data set, please sign up or log in
11 l 5 -- Citizenships granted according to country of birth and sex, 1990-2017
Tables
-
Dim country of birth, Statfin kans pxt 11l5 px, Full historyTSV
Dimension Country_of_birth (Syntymävaltio)
-
Dim country of birth, Statfin kans pxt 11l5 px, LatestTSV
Dimension Country_of_birth (Syntymävaltio)
-
Dim sex, Statfin kans pxt 11l5 px, Full historyTSV
Dimension Sex (Sukupuoli)
-
Dim sex, Statfin kans pxt 11l5 px, LatestTSV
Dimension Sex (Sukupuoli)
-
Dim year, Statfin kans pxt 11l5 px, Full historyTSV
Dimension Year (Vuosi)
-
Dim year, Statfin kans pxt 11l5 px, LatestTSV
Dimension Year (Vuosi)
-
Fact, Statfin kans pxt 11l5 px, Full historyTSV
Citizenships granted by Country of birth, Sex, Year and Information
-
Fact, Statfin kans pxt 11l5 px, LatestTSV
Citizenships granted by Country of birth, Sex, Year and Information
Column Descriptions
Dim year, Statfin kans pxt 11l5 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 year, Statfin kans pxt 11l5 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. |
Dim country of birth, Statfin kans pxt 11l5 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 894. |
| 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 11l5 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. |
Dim sex, Statfin kans pxt 11l5 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. |
Fact, Statfin kans pxt 11l5 px, Full history
| Column | Type | Comment |
|---|---|---|
| country_of_birth | 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. 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 country_of_birth has 17724 rows, out of which 756 are empty, making the null percent 4.27. Minimum value is 4 and maximum value is 894. |
| sex | int | Datasource did not contain a description for Sex. Column sex has 17724 rows, out of which 5908 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2. |
| year | int | Datasource did not contain a description for Year. Column year has 17724 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 17724 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. |
Fact, Statfin kans pxt 11l5 px, Latest
| Column | Type | Comment |
|---|---|---|
| country_of_birth | 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. 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 country_of_birth has 17724 rows, out of which 756 are empty, making the null percent 4.27. Minimum value is 4 and maximum value is 894. |
| sex | int | Datasource did not contain a description for Sex. Column sex has 17724 rows, out of which 5908 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2. |
| year | int | Datasource did not contain a description for Year. Column year has 17724 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 17724 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 country of birth, Statfin kans pxt 11l5 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 894. |
| 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. |
Additional Info
| Last Updated | July 20, 2019 |
|---|---|
| Created | July 20, 2019 |