OECD 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
);