Household Composition 2011 Census

CREATE TABLE household_composition_of_budshead_ward (
  "household_composition_in_h_budshead_ward_plymouth_from_410a58cc" VARCHAR,
  "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,
  "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,
  "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,
  "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,
  "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,
  "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,
  "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,
  "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,
  "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,
  "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,
  "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,
  "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,
  "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,
  "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,
  "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,
  "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,
  "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,
  "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__c4075325" DOUBLE,
  "percentage_in_ward_of_one_family_household_cohabiting__c46a7d60" DOUBLE,
  "percentage_in_ward_of_other_household_types_other" DOUBLE,
  "percentage_in_ward_of_one_family_household_lone_parent_d509fe9b" DOUBLE,
  "percentage_in_ward_of_other_household_types_all_aged_6_7122b3a4" DOUBLE,
  "percentage_in_ward_of_one_person_household_aged_65_and_over" DOUBLE,
  "percentage_in_ward_of_one_family_household_married_or__5cd8fce6" DOUBLE,
  "percentage_in_ward_of_one_person_household_other" DOUBLE,
  "percentage_in_ward_of_other_household_types_with_depen_b44b1af0" DOUBLE,
  "percentage_in_ward_of_one_family_household_all_aged_65_bf7fa98c" DOUBLE,
  "percentage_in_ward_of_one_family_household_lone_parent_6feb2fc7" DOUBLE,
  "percentage_in_ward_of_other_household_types_all_full_t_ac757582" DOUBLE,
  "percentage_in_ward_of_one_family_household_cohabiting__3e025a82" DOUBLE,
  "percentage_in_ward_of_one_family_household_cohabiting__827607de" DOUBLE
);