OECD Family Database
@owid.family_database
@owid.family_database
CREATE TABLE owid_births_outside_marriage (
"country" VARCHAR,
"year" INTEGER,
"births_outside_marriage" FLOAT
);CREATE TABLE owid_children_in_families (
"country" VARCHAR,
"year" INTEGER,
"indicator" VARCHAR,
"value" FLOAT
);CREATE TABLE owid_family_database (
"country" VARCHAR,
"year" INTEGER,
"child_poverty_rate" FLOAT,
"divorce_rate" FLOAT,
"marriage_rate" FLOAT,
"employment_rates_pct_for_all_mothers_15_64_year_olds_w_ab9f48ce" FLOAT -- Employment Rates, Pct, For All Mothers, 15–64 Year Olds, With At Least One Child Under 15,
"employment_rates_pct_for_partnered_mothers_15_64_year__6df107ea" FLOAT -- Employment Rates, Pct, For Partnered Mothers, 15–64 Year Olds, With At Least One Child Under 15,
"employment_rates_pct_for_sole_parent_mothers_15_64_yea_badacd33" FLOAT -- Employment Rates, Pct, For Sole Parent Mothers, 15–64 Year Olds, With At Least One Child Under 15,
"length_of_paid_maternity_parental_and_home_care_leave__96bb6627" FLOAT -- Length Of Paid Maternity, Parental And Home Care Leave Available To Mothers In Weeks,
"length_of_paid_paternity_and_parental_leave_reserved_f_246622d9" FLOAT -- Length Of Paid Paternity And Parental Leave Reserved For Fathers In Weeks,
"proportion_pct_of_children_aged_0_14_that_live_in_hous_d001fcdf" FLOAT -- Proportion, Pct, Of Children, Aged 0–14, That Live In Households Where All Adults Are In Employment, Working,
"proportion_pct_of_children_aged_0_17_living_in_other_t_0af48919" FLOAT -- Proportion, Pct, Of Children, Aged 0–17, Living In Other Types Of Household,
"proportion_pct_of_children_aged_0_17_living_with_a_sin_5bbfe5a2" FLOAT -- Proportion, Pct, Of Children, Aged 0–17, Living With A Single Parent,
"proportion_pct_of_children_aged_0_17_living_with_two_parents" FLOAT -- Proportion, Pct, Of Children, Aged 0–17, Living With Two Parents,
"proportion_pct_of_children_aged_0_2_enrolled_in_formal_4cd1ebf3" FLOAT -- Proportion, Pct, Of Children Aged 0–2 Enrolled In Formal Childcare And Pre School,
"share_of_births_outside_of_marriage_pct_of_all_births" FLOAT -- Share Of Births Outside Of Marriage, Pct Of All Births,
"public_social_expenditure_on_services_and_in_kind_bene_75ca2f15" FLOAT -- Public Social Expenditure On Services And In Kind Benefits For Families As A Pct Of Gdp,
"public_social_expenditure_on_cash_benefits_for_familie_23226f0d" FLOAT -- Public Social Expenditure On Cash Benefits For Families As A Pct Of Gdp,
"public_social_expenditure_on_tax_breaks_for_families_a_d5907dff" FLOAT -- Public Social Expenditure On Tax Breaks For Families As A Pct Of Gdp,
"total_public_social_expenditure_on_families_as_a_pct_of_gdp" FLOAT
);CREATE TABLE owid_marriage_divorce_rates (
"country" VARCHAR,
"year" INTEGER,
"gender" VARCHAR,
"indicator" VARCHAR,
"value" FLOAT
);CREATE TABLE owid_mean_age_first_marriage (
"country" VARCHAR,
"year" INTEGER,
"gender" VARCHAR,
"indicator" VARCHAR,
"value" FLOAT
);Anyone who has the link will be able to view this.