Household Composition 2011 Census

CREATE TABLE household_composition_of_budshead_ward (
  "household_composition_in_h_budshead_ward_plymouth_from_410a58cc" VARCHAR  -- Household Composition In H Budshead Ward Plymouth Data From Census 2011,
  "percentage_of_households_budshead_2011" DOUBLE,
  "minimum_for_plymouth_wards" DOUBLE,
  "average_for_plymouth_wards" DOUBLE,
  "maximum_for_plymouth_wards" DOUBLE
);

CREATE TABLE household_composition_of_devonport_ward (
  "household_composition_in_devonport_ward_plymouth_from__b4d07dcd" VARCHAR  -- Household Composition In Devonport Ward Plymouth Data From Census 2011,
  "percentage_of_households_devonport_2011" DOUBLE,
  "minimum_for_plymouth_wards" DOUBLE,
  "mean_for_plymouth_wards" DOUBLE,
  "maximum_for_plymouth_wards" DOUBLE
);

CREATE TABLE household_composition_of_drake_ward (
  "household_composition_in_drake_ward_plymouth_from_census_2011" VARCHAR  -- Household Composition In Drake Ward Plymouth Data From Census 2011,
  "percentage_of_households_drake_2011" DOUBLE,
  "minimum_for_plymouth_wards" DOUBLE,
  "mean_for_plymouth_wards" DOUBLE,
  "maximum_for_plymouth_wards" DOUBLE
);

CREATE TABLE household_composition_of_efford_lipson_ward (
  "household_composition_in_efford_and_lipson_ward_plymou_40dd5083" VARCHAR  -- Household Composition In Efford And Lipson Ward Plymouth Data From Census 2011,
  "percentage_of_households_efford_and_lipson_2011" DOUBLE,
  "minimum_for_plymouth_wards" DOUBLE,
  "mean_for_plymouth_wards" DOUBLE,
  "maximum_for_plymouth_wards" DOUBLE
);

CREATE TABLE household_composition_of_eggbuckland_ward (
  "household_composition_in_eggbuckland_ward_plymouth_fro_3f170788" VARCHAR  -- Household Composition In Eggbuckland Ward Plymouth Data From Census 2011,
  "percentage_of_households_eggbuckland_2011" DOUBLE,
  "minimum_for_plymouth_wards" DOUBLE,
  "mean_for_plymouth_wards" DOUBLE,
  "maximum_for_plymouth_wards" DOUBLE
);

CREATE TABLE household_composition_of_ham_ward (
  "household_composition_in_ham_ward_plymouth_from_census_2011" VARCHAR  -- Household Composition In Ham Ward Plymouth Data From Census 2011,
  "ham_percentage_of_households_ham_2011" DOUBLE,
  "minimum_for_plymouth_wards" DOUBLE,
  "mean_for_plymouth_wards" DOUBLE,
  "maximum_for_plymouth_wards" DOUBLE
);

CREATE TABLE household_composition_of_honicknowle_ward (
  "household_composition_in_honicknowle_ward_plymouth_fro_25ae3c86" VARCHAR  -- Household Composition In Honicknowle Ward Plymouth Data From Census 2011,
  "percentage_of_households_honicknowle_2011" DOUBLE,
  "minimum_for_plymouth_wards" DOUBLE,
  "mean_for_plymouth_wards" DOUBLE,
  "maximum_for_plymouth_wards" DOUBLE
);

CREATE TABLE household_composition_of_moor_view_ward (
  "household_composition_in_moor_view_ward_plymouth_from__dc723ca4" VARCHAR  -- Household Composition In Moor View Ward Plymouth Data From Census 2011,
  "percentage_of_households_moor_view_2011" DOUBLE,
  "minimum_for_plymouth_wards" DOUBLE,
  "mean_for_plymouth_wards" DOUBLE,
  "maximum_for_plymouth_wards" DOUBLE
);

CREATE TABLE household_composition_of_peverell_ward (
  "household_composition_in_peverell_ward_plymouth_from_c_468f917d" VARCHAR  -- Household Composition In Peverell Ward Plymouth Data From Census 2011,
  "percentage_of_households_peverell_2011" DOUBLE,
  "minimum_for_plymouth_wards" DOUBLE,
  "mean_for_plymouth_wards" DOUBLE,
  "maximum_for_plymouth_wards" DOUBLE
);

CREATE TABLE household_composition_of_plympton_chaddlewood_ward (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "plympton_chaddlewood" VARCHAR,
  "minimum_for_plymouth_wards" VARCHAR,
  "mean_for_plymouth_wards" VARCHAR,
  "maximum_for_plymouth_wards" VARCHAR
);

CREATE TABLE household_composition_of_plympton_st_mary_ward (
  "household_composition_in_plympton_st_mary_ward_plymout_9b785395" VARCHAR  -- Household Composition In Plympton St Mary Ward Plymouth Data From Census 2011,
  "percentage_of_households_plympton_st_mary_2011" DOUBLE,
  "minimum_for_plymouth_wards" DOUBLE,
  "mean_for_plymouth_wards" DOUBLE,
  "maximum_for_plymouth_wards" DOUBLE
);

CREATE TABLE household_composition_of_plymstock_dunston (
  "household_composition_in_plymstock_dunstone_ward_plymo_e57c8839" VARCHAR  -- Household Composition In Plymstock Dunstone Ward Plymouth Data From Census 2011,
  "percentage_of_households_plymstock_dunstone_2011" DOUBLE,
  "minimum_for_plymouth_wards" DOUBLE,
  "mean_for_plymouth_wards" DOUBLE,
  "maximum_for_plymouth_wards" DOUBLE
);

CREATE TABLE household_composition_of_radford_ward (
  "household_composition_in_plymstock_radford_ward_plymou_5e14b585" VARCHAR  -- Household Composition In Plymstock Radford Ward Plymouth Data From Census 2011,
  "plymstock_radford" DOUBLE,
  "minimum_for_plymouth_wards" DOUBLE,
  "mean_for_plymouth_wards" DOUBLE,
  "maximum_for_plymouth_wards" DOUBLE
);

CREATE TABLE household_composition_of_southway_ward (
  "household_composition_in_southway_ward_plymouth_from_c_afeabd70" VARCHAR  -- Household Composition In Southway Ward Plymouth Data From Census 2011,
  "percentage_of_households_southway_2011" DOUBLE,
  "minimum_for_plymouth_wards" DOUBLE,
  "mean_for_plymouth_wards" DOUBLE,
  "maximum_for_plymouth_wards" DOUBLE
);

CREATE TABLE household_composition_of_st_budeaux_ward (
  "household_composition_in_st_budeaux_ward_plymouth_from_743d4dbf" VARCHAR  -- Household Composition In St Budeaux Ward Plymouth Data From Census 2011,
  "percentage_of_households_st_budeaux_2011" DOUBLE,
  "minimum_for_plymouth_wards" DOUBLE,
  "mean_for_plymouth_wards" DOUBLE,
  "maximum_for_plymouth_wards" DOUBLE
);

CREATE TABLE household_composition_of_stoke_ward (
  "household_composition_in_stoke_ward_plymouth_from_census_2011" VARCHAR  -- Household Composition In Stoke Ward Plymouth Data From Census 2011,
  "percentage_of_households_stoke_2011" DOUBLE,
  "minimum_for_plymouth_wards" DOUBLE,
  "mean_for_plymouth_wards" DOUBLE,
  "maximum_for_plymouth_wards" DOUBLE
);

CREATE TABLE household_composition_of_st_peter_and_waterfront_ward (
  "household_composition_in_st_peter_waterfront_ward_plym_423591e9" VARCHAR  -- Household Composition In St Peter Waterfront Ward Plymouth Data From Census 2011,
  "percentage_of_households_st_peter_waterfront_2011" DOUBLE,
  "minimum_for_plymouth_wards" DOUBLE,
  "mean_for_plymouth_wards" DOUBLE,
  "maximum_for_plymouth_wards" DOUBLE
);

CREATE TABLE household_composition_of_sutton_and_mount_gould_ward (
  "household_composition_in_sutton_and_mount_gould_ward_p_c086065a" VARCHAR  -- Household Composition In Sutton And Mount Gould Ward Plymouth Data From Census 2011,
  "percentage_of_households_sutton_and_mount_gould_2011" DOUBLE,
  "minimum_for_plymouth_wards" DOUBLE,
  "mean_for_plymouth_wards" DOUBLE,
  "maximum_for_plymouth_wards" DOUBLE
);

CREATE TABLE household_composition_plymouth_wards_census_2011 (
  "households_composition_per_plymouth_ward_from_census_2011" VARCHAR,
  "percentage_in_ward_of_one_family_household_married_or__a0606ad8" DOUBLE  -- Percentage In Ward Of One Family Household: Married Or Same-sex Civil Partnership Couple: Dependent Children,
  "percentage_in_ward_of_one_family_household_married_or__c4075325" DOUBLE  -- Percentage In Ward Of One Family Household: Married Or Same-sex Civil Partnership Couple: All Children Non-dependent,
  "percentage_in_ward_of_one_family_household_cohabiting__c46a7d60" DOUBLE  -- Percentage In Ward Of One Family Household: Cohabiting Couple: No Children,
  "percentage_in_ward_of_other_household_types_other" DOUBLE  -- Percentage In Ward Of Other Household Types: Other,
  "percentage_in_ward_of_one_family_household_lone_parent_d509fe9b" DOUBLE  -- Percentage In Ward Of One Family Household: Lone Parent Family: All Children Non-dependent,
  "percentage_in_ward_of_other_household_types_all_aged_6_7122b3a4" DOUBLE  -- Percentage In Ward Of Other Household Types: All Aged 65 And Over,
  "percentage_in_ward_of_one_person_household_aged_65_and_over" DOUBLE  -- Percentage In Ward Of One Person Household: Aged 65 And Over,
  "percentage_in_ward_of_one_family_household_married_or__5cd8fce6" DOUBLE  -- Percentage In Ward Of One Family Household: Married Or Same-sex Civil Partnership Couple: No Children,
  "percentage_in_ward_of_one_person_household_other" DOUBLE  -- Percentage In Ward Of One Person Household: Other,
  "percentage_in_ward_of_other_household_types_with_depen_b44b1af0" DOUBLE  -- Percentage In Ward Of Other Household Types: With Dependent Children,
  "percentage_in_ward_of_one_family_household_all_aged_65_bf7fa98c" DOUBLE  -- Percentage In Ward Of One Family Household: All Aged 65 And Over,
  "percentage_in_ward_of_one_family_household_lone_parent_6feb2fc7" DOUBLE  -- Percentage In Ward Of One Family Household: Lone Parent: Dependent Children,
  "percentage_in_ward_of_other_household_types_all_full_t_ac757582" DOUBLE  -- Percentage In Ward Of Other Household Types: All Full-time Students,
  "percentage_in_ward_of_one_family_household_cohabiting__3e025a82" DOUBLE  -- Percentage In Ward Of One Family Household: Cohabiting Couple: Dependent Children,
  "percentage_in_ward_of_one_family_household_cohabiting__827607de" DOUBLE  -- Percentage In Ward Of One Family Household: Cohabiting Couple: All Children Non-dependent
);