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_other" DOUBLE,
  "single_family_household_all_aged_66_years_and_over" DOUBLE,
  "single_family_household_married_or_civil_partnership_c_3b267626" DOUBLE,
  "single_family_household_married_or_civil_partnership_c_5bdef768" DOUBLE,
  "single_family_household_married_or_civil_partnership_c_4ed29b17" DOUBLE,
  "single_family_household_cohabiting_couple_family_no_children" DOUBLE,
  "single_family_household_cohabiting_couple_family_with__cd4979d2" DOUBLE,
  "single_family_household_cohabiting_couple_family_all_c_3401fa6d" DOUBLE,
  "single_family_household_lone_parent_family_with_depend_1ee37ac5" DOUBLE,
  "single_family_household_lone_parent_family_all_childre_c6ab2fcd" DOUBLE,
  "other_household_types_other_related_household_other_fa_2cb993ef" DOUBLE,
  "other_household_types_with_dependent_children" DOUBLE,
  "other_household_types_other_including_all_full_time_st_d11bbbca" DOUBLE
);

CREATE TABLE household_composition_budshead_ward (
  "household_composition" VARCHAR,
  "budshead" DOUBLE,
  "plymouth_minimum" DOUBLE,
  "plymouth_mean" DOUBLE,
  "plymouth_maximum" DOUBLE
);

CREATE TABLE household_composition_compton_ward (
  "household_composition" VARCHAR,
  "compton" DOUBLE,
  "plymouth_minimum" DOUBLE,
  "plymouth_mean" DOUBLE,
  "plymouth_maximum" DOUBLE
);

CREATE TABLE household_composition_devonport_ward (
  "household_composition" VARCHAR,
  "devonport" DOUBLE,
  "plymouth_minimum" DOUBLE,
  "plymouth_mean" DOUBLE,
  "plymouth_maximum" DOUBLE
);

CREATE TABLE household_composition_drake_ward (
  "household_composition" VARCHAR,
  "drake" DOUBLE,
  "plymouth_minimum" DOUBLE,
  "plymouth_mean" DOUBLE,
  "plymouth_maximum" DOUBLE
);

CREATE TABLE household_composition_efford_lipson (
  "household_composition" VARCHAR,
  "efford_and_lipson" DOUBLE,
  "plymouth_minimum" DOUBLE,
  "plymouth_mean" DOUBLE,
  "plymouth_maximum" DOUBLE
);

CREATE TABLE household_composition_eggbuckland (
  "household_composition" VARCHAR,
  "eggbuckland" DOUBLE,
  "plymouth_minimum" DOUBLE,
  "plymouth_mean" DOUBLE,
  "plymouth_maximum" DOUBLE
);

CREATE TABLE household_composition_ham_ward (
  "household_composition" VARCHAR,
  "ham" DOUBLE,
  "plymouth_minimum" DOUBLE,
  "plymouth_mean" DOUBLE,
  "plymouth_maximum" DOUBLE
);

CREATE TABLE household_composition_honicknowle (
  "household_composition" VARCHAR,
  "honicknowle" DOUBLE,
  "plymouth_minimum" DOUBLE,
  "plymouth_mean" DOUBLE,
  "plymouth_maximum" DOUBLE
);

CREATE TABLE household_composition_moor_view (
  "household_composition" VARCHAR,
  "moor_view" DOUBLE,
  "plymouth_minimum" DOUBLE,
  "plymouth_mean" DOUBLE,
  "plymouth_maximum" DOUBLE
);

CREATE TABLE household_composition_peverell (
  "household_composition" VARCHAR,
  "peverell" DOUBLE,
  "plymouth_minimum" DOUBLE,
  "plymouth_mean" DOUBLE,
  "plymouth_maximum" DOUBLE
);

CREATE TABLE household_composition_plymouth_erle (
  "household_composition" VARCHAR,
  "plympton_erle" DOUBLE,
  "plymouth_minimum" DOUBLE,
  "plymouth_mean" DOUBLE,
  "plymouth_maximum" DOUBLE
);

CREATE TABLE household_composition_plympton_chaddlewood (
  "household_composition" VARCHAR,
  "plympton_chaddlewood" DOUBLE,
  "plymouth_minimum" DOUBLE,
  "plymouth_mean" DOUBLE,
  "plymouth_maximum" DOUBLE
);

CREATE TABLE household_composition_plympton_st_mary (
  "household_composition" VARCHAR,
  "plympton_st_mary" DOUBLE,
  "plymouth_minimum" DOUBLE,
  "plymouth_mean" DOUBLE,
  "plymouth_maximum" DOUBLE
);

CREATE TABLE household_composition_plymstock_dunstone (
  "household_composition" VARCHAR,
  "plymstock_dunstone" DOUBLE,
  "plymouth_minimum" DOUBLE,
  "plymouth_mean" DOUBLE,
  "plymouth_maximum" DOUBLE
);

CREATE TABLE household_composition_plymstock_radford (
  "household_composition" VARCHAR,
  "plymstock_radford" DOUBLE,
  "plymouth_minimum" DOUBLE,
  "plymouth_mean" DOUBLE,
  "plymouth_maximum" DOUBLE
);

CREATE TABLE household_composition_southway (
  "household_composition" VARCHAR,
  "southway" DOUBLE,
  "plymouth_minimum" DOUBLE,
  "plymouth_mean" DOUBLE,
  "plymouth_maximum" DOUBLE
);

CREATE TABLE household_composition_st_budeaux (
  "household_composition" VARCHAR,
  "st_budeaux" DOUBLE,
  "plymouth_minimum" DOUBLE,
  "plymouth_mean" DOUBLE,
  "plymouth_maximum" DOUBLE
);

CREATE TABLE household_composition_stoke (
  "household_composition" VARCHAR,
  "stoke" DOUBLE,
  "plymouth_minimum" DOUBLE,
  "plymouth_mean" DOUBLE,
  "plymouth_maximum" DOUBLE
);

CREATE TABLE household_composition_st_peter_and_waterfront (
  "household_composition" VARCHAR,
  "st_peter_and_the_waterfront" DOUBLE,
  "plymouth_minimum" DOUBLE,
  "plymouth_mean" DOUBLE,
  "plymouth_maximum" DOUBLE
);

CREATE TABLE household_composition_sutton_and_mount_gould (
  "household_composition" VARCHAR,
  "sutton_and_mount_gould" DOUBLE,
  "plymouth_minimum" DOUBLE,
  "plymouth_mean" DOUBLE,
  "plymouth_maximum" DOUBLE
);