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

Population according to citizenship, country of birth, language and origin 1990-2017 (overlap of the groups)

Population according to citizenship, country of birth, language and origin 1990-2017 (overlap of the groups)

Tables

Column Descriptions

Fact, T005 kaikki px, Full history

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 694008 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.
age int Datasource did not contain a description for Age. Column age has 694008 rows, out of which 6804 are empty, making the null percent 0.98. Minimum value is 0 and maximum value is 100.
sex int Datasource did not contain a description for Sex. Column sex has 694008 rows, out of which 231336 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
citizenship int Datasource did not contain a description for Citizenship. Column citizenship has 694008 rows, out of which 462672 are empty, making the null percent 66.67. Constant value is 246.
language int Datasource did not contain a description for Language. Column language has 694008 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 2.
country_of_birth int Datasource did not contain a description for Country_of_birth. Column country_of_birth has 694008 rows, out of which 462672 are empty, making the null percent 66.67. Constant value is 246.
origin int Datasource did not contain a description for Origin. Column origin has 694008 rows, out of which 462672 are empty, making the null percent 66.67. Constant value is 246.
information string Datasource did not contain a description for Information. Column information has 694008 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: vaesto.
population_31_12 int Datasource did not contain a description for Population_31_12. Column population_31_12 has 694008 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 5513130.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, T005 kaikki px, Latest

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 694008 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.
age int Datasource did not contain a description for Age. Column age has 694008 rows, out of which 6804 are empty, making the null percent 0.98. Minimum value is 0 and maximum value is 100.
sex int Datasource did not contain a description for Sex. Column sex has 694008 rows, out of which 231336 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
citizenship int Datasource did not contain a description for Citizenship. Column citizenship has 694008 rows, out of which 462672 are empty, making the null percent 66.67. Constant value is 246.
language int Datasource did not contain a description for Language. Column language has 694008 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 2.
country_of_birth int Datasource did not contain a description for Country_of_birth. Column country_of_birth has 694008 rows, out of which 462672 are empty, making the null percent 66.67. Constant value is 246.
origin int Datasource did not contain a description for Origin. Column origin has 694008 rows, out of which 462672 are empty, making the null percent 66.67. Constant value is 246.
information string Datasource did not contain a description for Information. Column information has 694008 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: vaesto.
population_31_12 int Datasource did not contain a description for Population_31_12. Column population_31_12 has 694008 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 5513130.

Additional Info

Last Updated July 21, 2019
Created July 16, 2019