Dataset: Divorce/marriage Dataset With Birth Dates

About this Dataset

Divorce/marriage Dataset With Birth Dates

Context

This dataset was obtained from the https://datos.gob.mx/busca/dataset/registro-civil

This is the Mexican government official dataset for the number of divorces in the city of Xalapa, Mexico

Content

The dataset contains records of approximately 4,900+ divorces for the 15 years period (2000-2015) in the city of Xalapa, Mexico. The special good thing about this dataset is that it contains divorcees birth dates which are usually considered as being sensitive information and usually not included in the public datasets.

The dataset is originally in Spanish and I did translate all the column headers into English. Files are as follows:

divorces_2000-2015_original.csv - original dataset (in Spanish)
descriptions_for_ column.csv - descriptions for each column (in Spanish)
divorces_2000-2015_translated.csv - the version with the English translated column headers (please note that only column headers were translated)
comp_matrix.csv - the table of the zodiac signs compatibility rates that were used in my notebook (https://www.kaggle.com/aagghh/testing-the-astrology-and-zodiac-claims). Note: ignore it if you do not need it

Major features are:

Date of divorce

Birth dates for both partners (man/woman)

Nationality for both partners (man/woman)

Place of birth and residence for both partners (man/woman)

Monthly income for both partners (man/woman)

Occupation for both partners (man/woman)

Date of marriage (man/woman)

Level of education for both partners (man/woman)

Employment status for both partners (man/woman)

Number of children and their custody

Other features - please refer to the file & columns descriptions below

Inspiration

A potential use-case for this data could be a practice in classification/clustering problems in an attempt to predict a divorce.

Some other data analysis can be applied to this dataset. For instance, I am gonna use this data for the horoscope/zodiac/astrology claims validation/testing.

Please refer to my notebook on it here: https://www.kaggle.com/aagghh/is-astrology-right-testing-the-zodiac-claims

Tables

Comp Matrix

@kaggle.aagghh_divorcemarriage_dataset_with_birth_dates.comp_matrix

3.67 KB
144 rows
2 columns


CREATE TABLE comp_matrix (
  "zodiac_combination" VARCHAR,
  "compatibility_rate" DOUBLE
);

Divorces 2000–2015 Original

@kaggle.aagghh_divorcemarriage_dataset_with_birth_dates.divorces_2000_2015_original

266.48 KB
4923 rows
41 columns


CREATE TABLE divorces_2000_2015_original (
  "fecha_de_registro" VARCHAR,
  "tipo" VARCHAR,
  "nacionalidad" VARCHAR,
  "f_naci_do" VARCHAR,
  "locnaci_do" VARCHAR,
  "mpionaci_do" VARCHAR,
  "efednaci_do" VARCHAR,
  "paisnaci_do" VARCHAR,
  "edad" DOUBLE,
  "mpiohab_do" VARCHAR,
  "efedhab_do" VARCHAR,
  "paishab_do" VARCHAR,
  "elingreso" DOUBLE,
  "ocupaci_n_do" VARCHAR,
  "lochabi_do" VARCHAR,
  "nacionalidad2" VARCHAR,
  "f_naci_da" VARCHAR,
  "fecha_de_registro_2" VARCHAR,
  "locnaci_da" VARCHAR,
  "mpionaci_da" VARCHAR,
  "efednaci_da" VARCHAR,
  "paisnaci_da" VARCHAR,
  "edad2" DOUBLE,
  "lochabi_da" VARCHAR,
  "mpiohab_da" VARCHAR,
  "efedhab_da" VARCHAR,
  "paishab_da" VARCHAR,
  "ocupaci_n_da" VARCHAR,
  "ellaingreso" DOUBLE,
  "fecha" VARCHAR,
  "localidad" VARCHAR,
  "municipio" VARCHAR,
  "entidad_federativa" VARCHAR,
  "elescolaridad" VARCHAR,
  "eltrabajo" VARCHAR,
  "ellaescolaridad" VARCHAR,
  "ellatrabajo" VARCHAR,
  "matri_a_os" DOUBLE,
  "matri_meses" DOUBLE,
  "num_hijos" DOUBLE,
  "custodia" VARCHAR
);

Divorces 2000–2015 Translated

@kaggle.aagghh_divorcemarriage_dataset_with_birth_dates.divorces_2000_2015_translated

271.92 KB
4923 rows
41 columns


CREATE TABLE divorces_2000_2015_translated (
  "divorce_date" VARCHAR,
  "type_of_divorce" VARCHAR,
  "nationality_partner_man" VARCHAR,
  "dob_partner_man" VARCHAR,
  "place_of_birth_partner_man" VARCHAR,
  "birth_municipality_of_partner_man" VARCHAR,
  "birth_federal_partner_man" VARCHAR,
  "birth_country_partner_man" VARCHAR,
  "age_partner_man" DOUBLE,
  "residence_municipality_partner_man" VARCHAR,
  "residence_federal_partner_man" VARCHAR,
  "residence_country_partner_man" VARCHAR,
  "monthly_income_partner_man_peso" DOUBLE,
  "occupation_partner_man" VARCHAR,
  "place_of_residence_partner_man" VARCHAR,
  "nationality_partner_woman" VARCHAR,
  "dob_partner_woman" VARCHAR,
  "dob_registration_date_partner_woman" VARCHAR,
  "place_of_birth_partner_woman" VARCHAR,
  "birth_municipality_of_partner_woman" VARCHAR,
  "birth_federal_partner_woman" VARCHAR,
  "birth_country_partner_woman" VARCHAR,
  "age_partner_woman" DOUBLE,
  "place_of_residence_partner_woman" VARCHAR,
  "residence_municipality_partner_woman" VARCHAR,
  "residence_federal_partner_woman" VARCHAR,
  "residence_country_partner_woman" VARCHAR,
  "occupation_partner_woman" VARCHAR,
  "monthly_income_partner_woman_peso" DOUBLE,
  "date_of_marriage" VARCHAR,
  "marriage_certificate_place" VARCHAR,
  "marriage_certificate_municipality" VARCHAR,
  "marriage_certificate_federal" VARCHAR,
  "level_of_education_partner_man" VARCHAR,
  "employment_status_partner_man" VARCHAR,
  "level_of_education_partner_woman" VARCHAR,
  "employment_status_partner_woman" VARCHAR,
  "marriage_duration" DOUBLE,
  "marriage_duration_months" DOUBLE,
  "num_children" DOUBLE,
  "custody" VARCHAR
);