Dataset

To download the data set, please sign up or log in

11 l 4 -- Citizenships granted according to age group and sex by region, 2010-2017

11 l 4 -- Citizenships granted according to age group and sex by region, 2010-2017

Tables

Dim age, Statfin kans pxt 11l4 px, Full historyTSV
Dimension Age (Ikä)
Dim age, Statfin kans pxt 11l4 px, LatestTSV
Dimension Age (Ikä)
Dim region, Statfin kans pxt 11l4 px, Full historyTSV
Dimension Region (Maakunta)
Dim region, Statfin kans pxt 11l4 px, LatestTSV
Dimension Region (Maakunta)
Dim sex, Statfin kans pxt 11l4 px, Full historyTSV
Dimension Sex (Sukupuoli)
Dim sex, Statfin kans pxt 11l4 px, LatestTSV
Dimension Sex (Sukupuoli)
Dim year, Statfin kans pxt 11l4 px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfin kans pxt 11l4 px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfin kans pxt 11l4 px, Full historyTSV
Citizenships granted by Region, Year, Sex, Age and Information
Fact, Statfin kans pxt 11l4 px, LatestTSV
Citizenships granted by Region, Year, Sex, Age and Information

Column Descriptions

Fact, Statfin kans pxt 11l4 px, Full history

Column	Type	Comment
region	string	These statistics apply the regional division of 1 January 2018 to the whole time series. . Column region has 2640 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MA1 and maximum string is MK21.
year	int	Datasource did not contain a description for Year. Column year has 2640 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010 and maximum value is 2017.
sex	int	Datasource did not contain a description for Sex. Column sex has 2640 rows, out of which 880 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
age	string	Datasource did not contain a description for Age. Column age has 2640 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0-17 and maximum string is 55-.
finnish_citizenships_granted	int	Datasource did not contain a description for Finnish_citizenships_granted. Column finnish_citizenships_granted has 2640 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 region, Statfin kans pxt 11l4 px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MA1 and maximum string is MK21.
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 MA1 MAINLAND FINLAND and maximum string is MK21 Åland.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim region, Statfin kans pxt 11l4 px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MA1 and maximum string is MK21.
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 MA1 MAINLAND FINLAND and maximum string is MK21 Åland.

Fact, Statfin kans pxt 11l4 px, Latest

Column	Type	Comment
region	string	These statistics apply the regional division of 1 January 2018 to the whole time series. . Column region has 2640 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MA1 and maximum string is MK21.
year	int	Datasource did not contain a description for Year. Column year has 2640 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010 and maximum value is 2017.
sex	int	Datasource did not contain a description for Sex. Column sex has 2640 rows, out of which 880 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
age	string	Datasource did not contain a description for Age. Column age has 2640 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0-17 and maximum string is 55-.
finnish_citizenships_granted	int	Datasource did not contain a description for Finnish_citizenships_granted. Column finnish_citizenships_granted has 2640 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 year, Statfin kans pxt 11l4 px, Latest

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

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

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

Dim sex, Statfin kans pxt 11l4 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 11l4 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 age, Statfin kans pxt 11l4 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 0-17 and maximum string is 55-.
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 - 17 and maximum string is 55 -.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim age, Statfin kans pxt 11l4 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 0-17 and maximum string is 55-.
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 - 17 and maximum string is 55 -.

Additional Info

Last Updated	July 10, 2019
Created	July 10, 2019