Adoptions by country of birth, age and sex of children and type of adoption 1987 - 2016

Tables

Dim Age Of Children, Adoptions By Country Of Birth Age And Sex Of Children And Type Of Adoption 1987 2016TSV
Dimension Age_of_children (Adoptoitavan ikä)
Dim Country Of Birth, Adoptions By Country Of Birth Age And Sex Of Children And Type Of Adoption 1987 2016TSV
Dimension Country_of_birth (Syntymävaltio)
Dim Sex, Adoptions By Country Of Birth Age And Sex Of Children And Type Of Adoption 1987 2016TSV
Dimension Sex (Adoptoitavan sukupuoli)
Dim Type Of Adoption, Adoptions By Country Of Birth Age And Sex Of Children And Type Of Adoption 1987 2016TSV
Dimension Type_of_adoption (Adoptiotyyppi)
Dim Year, Adoptions By Country Of Birth Age And Sex Of Children And Type Of Adoption 1987 2016TSV
Dimension Year (Vuosi)
Fact, Adoptions By Country Of Birth Age And Sex Of Children And Type Of Adoption 1987 2016TSV
Adoptions by Year, Country of birth, Type of adoption, Age of children and Sex

Column Descriptions

Fact, Adoptions By Country Of Birth Age And Sex Of Children And Type Of Adoption 1987 2016

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 166050 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1987 and maximum value is 2016.
country_of_birth	int	Country of birth (ISO 3166). The used classification of continents is the classification of Eurostat, where Cyprus and Turkey belong to Europe. . Column country_of_birth has 166050 rows, out of which 7290 are empty, making the null percent 4.39. Minimum value is 4 and maximum value is 999.
type_of_adoption	string	Datasource did not contain a description for Type_of_adoption. Column type_of_adoption has 166050 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_of_children	string	Datasource did not contain a description for Age_of_children. Column age_of_children has 166050 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 18-.
sex	int	Datasource did not contain a description for Sex. Column sex has 166050 rows, out of which 55350 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
adoptions	int	Datasource did not contain a description for Adoptions. Column adoptions has 166050 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 515.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim Year, Adoptions By Country Of Birth Age And Sex Of Children And Type Of Adoption 1987 2016

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

Dim Country Of Birth, Adoptions By Country Of Birth Age And Sex Of Children And Type Of Adoption 1987 2016

Column	Type	Comment
code	int	The code for the dimension value. Column code has 205 rows, out of which 9 are empty, making the null percent 4.39. Minimum value is 4 and maximum value is 999.
label	string	The label for the dimension value. Column label has 205 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 Type Of Adoption, Adoptions By Country Of Birth Age And Sex Of Children And Type Of Adoption 1987 2016

Column	Type	Comment
code	string	The code for the dimension value. Column code has 3 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.
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 Adoptions by one parent and maximum string is Adoptions total.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim Age Of Children, Adoptions By Country Of Birth Age And Sex Of Children And Type Of Adoption 1987 2016

Column	Type	Comment
code	string	The code for the dimension value. Column code has 3 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 18-.
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 0 - 17 and maximum string is 18 -.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim Sex, Adoptions By Country Of Birth Age And Sex Of Children And Type Of Adoption 1987 2016

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 Both sexes and maximum string is Females.
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	April 12, 2019
Created	November 30, 2018