Household Composition 2021 Census

CREATE TABLE household_composition_all_plymouth_wards (
  "ward" VARCHAR,
  "one_person_household_aged_66_years_and_over" DOUBLE  -- One-person Household: Aged 66 Years And Over (%),
  "one_person_household_other" DOUBLE  -- One-person Household: Other (%),
  "single_family_household_all_aged_66_years_and_over" DOUBLE  -- Single Family Household: All Aged 66 Years And Over (%),
  "single_family_household_married_or_civil_partnership_c_3b267626" DOUBLE  -- Single Family Household: Married Or Civil Partnership Couple: No Children (%),
  "single_family_household_married_or_civil_partnership_c_5bdef768" DOUBLE  -- Single Family Household: Married Or Civil Partnership Couple: Dependent Children (%),
  "single_family_household_married_or_civil_partnership_c_4ed29b17" DOUBLE  -- Single Family Household: Married Or Civil Partnership Couple: All Children Non-dependent (%),
  "single_family_household_cohabiting_couple_family_no_children" DOUBLE  -- Single Family Household: Cohabiting Couple Family: No Children (%),
  "single_family_household_cohabiting_couple_family_with__cd4979d2" DOUBLE  -- Single Family Household: Cohabiting Couple Family: With Dependent Children (%),
  "single_family_household_cohabiting_couple_family_all_c_3401fa6d" DOUBLE  -- Single Family Household: Cohabiting Couple Family: All Children Non-dependent (%),
  "single_family_household_lone_parent_family_with_depend_1ee37ac5" DOUBLE  -- Single Family Household: Lone Parent Family: With Dependent Children (%),
  "single_family_household_lone_parent_family_all_childre_c6ab2fcd" DOUBLE  -- Single Family Household: Lone Parent Family: All Children Non-dependent (%),
  "other_household_types_other_related_household_other_fa_2cb993ef" DOUBLE  -- Other Household Types: Other Related Household: Other Family Composition (%),
  "other_household_types_with_dependent_children" DOUBLE  -- Other Household Types: With Dependent Children (%),
  "other_household_types_other_including_all_full_time_st_d11bbbca" DOUBLE  -- Other Household Types: Other, Including All Full-time Students And All Aged 66 Years And Over (%)
);

CREATE TABLE household_composition_budshead_ward (
  "household_composition" VARCHAR,
  "budshead" DOUBLE  -- Budshead (%),
  "plymouth_minimum" DOUBLE  -- Plymouth Minimum (%),
  "plymouth_mean" DOUBLE  -- Plymouth Mean (%),
  "plymouth_maximum" DOUBLE  -- Plymouth Maximum (%)
);

CREATE TABLE household_composition_compton_ward (
  "household_composition" VARCHAR,
  "compton" DOUBLE  -- Compton (%),
  "plymouth_minimum" DOUBLE  -- Plymouth Minimum (%),
  "plymouth_mean" DOUBLE  -- Plymouth Mean (%),
  "plymouth_maximum" DOUBLE  -- Plymouth Maximum (%)
);

CREATE TABLE household_composition_devonport_ward (
  "household_composition" VARCHAR,
  "devonport" DOUBLE,
  "plymouth_minimum" DOUBLE  -- Plymouth Minimum (%),
  "plymouth_mean" DOUBLE  -- Plymouth Mean (%),
  "plymouth_maximum" DOUBLE  -- Plymouth Maximum (%)
);

CREATE TABLE household_composition_drake_ward (
  "household_composition" VARCHAR,
  "drake" DOUBLE  -- Drake (%),
  "plymouth_minimum" DOUBLE  -- Plymouth Minimum (%),
  "plymouth_mean" DOUBLE  -- Plymouth Mean (%),
  "plymouth_maximum" DOUBLE  -- Plymouth Maximum (%)
);

CREATE TABLE household_composition_efford_lipson (
  "household_composition" VARCHAR,
  "efford_and_lipson" DOUBLE  -- Efford And Lipson (%),
  "plymouth_minimum" DOUBLE  -- Plymouth Minimum (%),
  "plymouth_mean" DOUBLE  -- Plymouth Mean (%),
  "plymouth_maximum" DOUBLE  -- Plymouth Maximum (%)
);

CREATE TABLE household_composition_eggbuckland (
  "household_composition" VARCHAR,
  "eggbuckland" DOUBLE  -- Eggbuckland (%),
  "plymouth_minimum" DOUBLE  -- Plymouth Minimum (%),
  "plymouth_mean" DOUBLE  -- Plymouth Mean (%),
  "plymouth_maximum" DOUBLE  -- Plymouth Maximum (%)
);

CREATE TABLE household_composition_ham_ward (
  "household_composition" VARCHAR,
  "ham" DOUBLE  -- Ham (%),
  "plymouth_minimum" DOUBLE  -- Plymouth Minimum (%),
  "plymouth_mean" DOUBLE  -- Plymouth Mean (%),
  "plymouth_maximum" DOUBLE  -- Plymouth Maximum (%)
);

CREATE TABLE household_composition_honicknowle (
  "household_composition" VARCHAR,
  "honicknowle" DOUBLE  -- Honicknowle (%),
  "plymouth_minimum" DOUBLE  -- Plymouth Minimum (%),
  "plymouth_mean" DOUBLE  -- Plymouth Mean (%),
  "plymouth_maximum" DOUBLE  -- Plymouth Maximum (%)
);

CREATE TABLE household_composition_moor_view (
  "household_composition" VARCHAR,
  "moor_view" DOUBLE  -- Moor View (%),
  "plymouth_minimum" DOUBLE  -- Plymouth Minimum (%),
  "plymouth_mean" DOUBLE  -- Plymouth Mean (%),
  "plymouth_maximum" DOUBLE  -- Plymouth Maximum (%)
);

CREATE TABLE household_composition_peverell (
  "household_composition" VARCHAR,
  "peverell" DOUBLE  -- Peverell (%),
  "plymouth_minimum" DOUBLE  -- Plymouth Minimum (%),
  "plymouth_mean" DOUBLE  -- Plymouth Mean (%),
  "plymouth_maximum" DOUBLE  -- Plymouth Maximum (%)
);

CREATE TABLE household_composition_plymouth_erle (
  "household_composition" VARCHAR,
  "plympton_erle" DOUBLE  -- Plympton Erle (%),
  "plymouth_minimum" DOUBLE  -- Plymouth Minimum (%),
  "plymouth_mean" DOUBLE  -- Plymouth Mean (%),
  "plymouth_maximum" DOUBLE  -- Plymouth Maximum (%)
);

CREATE TABLE household_composition_plympton_chaddlewood (
  "household_composition" VARCHAR,
  "plympton_chaddlewood" DOUBLE  -- Plympton Chaddlewood (%),
  "plymouth_minimum" DOUBLE  -- Plymouth Minimum (%),
  "plymouth_mean" DOUBLE  -- Plymouth Mean (%),
  "plymouth_maximum" DOUBLE  -- Plymouth Maximum (%)
);

CREATE TABLE household_composition_plympton_st_mary (
  "household_composition" VARCHAR,
  "plympton_st_mary" DOUBLE  -- Plympton St Mary (%),
  "plymouth_minimum" DOUBLE  -- Plymouth Minimum (%),
  "plymouth_mean" DOUBLE  -- Plymouth Mean (%),
  "plymouth_maximum" DOUBLE  -- Plymouth Maximum (%)
);

CREATE TABLE household_composition_plymstock_dunstone (
  "household_composition" VARCHAR,
  "plymstock_dunstone" DOUBLE  -- Plymstock Dunstone (%),
  "plymouth_minimum" DOUBLE  -- Plymouth Minimum (%),
  "plymouth_mean" DOUBLE  -- Plymouth Mean (%),
  "plymouth_maximum" DOUBLE  -- Plymouth Maximum (%)
);

CREATE TABLE household_composition_plymstock_radford (
  "household_composition" VARCHAR,
  "plymstock_radford" DOUBLE  -- Plymstock Radford (%),
  "plymouth_minimum" DOUBLE  -- Plymouth Minimum (%),
  "plymouth_mean" DOUBLE  -- Plymouth Mean (%),
  "plymouth_maximum" DOUBLE  -- Plymouth Maximum (%)
);

CREATE TABLE household_composition_southway (
  "household_composition" VARCHAR,
  "southway" DOUBLE  -- Southway (%),
  "plymouth_minimum" DOUBLE  -- Plymouth Minimum (%),
  "plymouth_mean" DOUBLE  -- Plymouth Mean (%),
  "plymouth_maximum" DOUBLE  -- Plymouth Maximum (%)
);

CREATE TABLE household_composition_st_budeaux (
  "household_composition" VARCHAR,
  "st_budeaux" DOUBLE  -- St Budeaux (%),
  "plymouth_minimum" DOUBLE  -- Plymouth Minimum (%),
  "plymouth_mean" DOUBLE  -- Plymouth Mean (%),
  "plymouth_maximum" DOUBLE  -- Plymouth Maximum (%)
);

CREATE TABLE household_composition_stoke (
  "household_composition" VARCHAR,
  "stoke" DOUBLE  -- Stoke (%),
  "plymouth_minimum" DOUBLE  -- Plymouth Minimum (%),
  "plymouth_mean" DOUBLE  -- Plymouth Mean (%),
  "plymouth_maximum" DOUBLE  -- Plymouth Maximum (%)
);

CREATE TABLE household_composition_st_peter_and_waterfront (
  "household_composition" VARCHAR,
  "st_peter_and_the_waterfront" DOUBLE  -- St Peter And The Waterfront (%),
  "plymouth_minimum" DOUBLE  -- Plymouth Minimum (%),
  "plymouth_mean" DOUBLE  -- Plymouth Mean (%),
  "plymouth_maximum" DOUBLE  -- Plymouth Maximum (%)
);

CREATE TABLE household_composition_sutton_and_mount_gould (
  "household_composition" VARCHAR,
  "sutton_and_mount_gould" DOUBLE  -- Sutton And Mount Gould (%),
  "plymouth_minimum" DOUBLE  -- Plymouth Minimum (%),
  "plymouth_mean" DOUBLE  -- Plymouth Mean (%),
  "plymouth_maximum" DOUBLE  -- Plymouth Maximum (%)
);