About this Dataset

Concealed Families

The Census 2011 identifies concealed families in each district of the country.

Here, we present the data and a breakdown of families into various groups; unconcealed, concealed lone parent families and concealed families.

It is important to note that the data only identifies families with children, and does not identify lone individuals concealed within another household.

So, what is a concealed family?

Where more than one family lives in a property, the “second” family is called concealed – for example a young couple living with parents, or an older couple living in their son or daughter’s family home.

What is a family reference person?

Using the Census, each family is assigned a Family Reference Person (FRP). Where there is more than one family reference person in the household, the primary family is identified (usually the one containing the oldest full-time worker). Other families living in the same property are then counted identified as “concealed”.

The Office for National Statistics (ONS) analyses concealed family types for each district, including the age group of the Family Reference Person. This is the data we have used, with a little editing to ensure it is "open" data.
Publisher name: Cambridgeshire Insight
Last updated: 2024-09-14T15:53:46Z

Tables

Table 1

@ukgov.concealed_families.table_1

144.33 kB
324 rows
74 columns

CREATE TABLE table_1 (
  "ons_code" VARCHAR,
  "local_authority_area" VARCHAR,
  "all_families_total" BIGINT,
  "all_families_age_of_family_reference_person_24_and_under" BIGINT,
  "all_families_age_of_family_reference_person_25_to_34" BIGINT,
  "all_families_age_of_family_reference_person_35_to_49" BIGINT,
  "all_families_age_of_family_reference_person_50_to_64" BIGINT,
  "all_families_age_of_family_reference_person_65_to_74" BIGINT,
  "all_families_age_of_family_reference_person_75_to_84" BIGINT,
  "all_families_age_of_family_reference_person_85_and_over" BIGINT,
  "concealed_families_total" BIGINT,
  "concealed_family_age_of_family_reference_person_24_and_under" BIGINT,
  "concealed_family_age_of_family_reference_person_25_to_34" BIGINT,
  "concealed_family_age_of_family_reference_person_35_to_49" BIGINT,
  "concealed_family_age_of_family_reference_person_50_to_64" BIGINT,
  "concealed_family_age_of_family_reference_person_65_to_74" BIGINT,
  "concealed_family_age_of_family_reference_person_75_to_84" BIGINT,
  "concealed_family_age_of_family_reference_person_85_and_over" BIGINT,
  "concealed_lone_parent_families_total" BIGINT,
  "concealed_lone_parent_family_age_of_family_reference_p_8e72b765" BIGINT  -- Concealed Lone Parent Family Age Of Family Reference Person 24 And Under,
  "concealed_lone_parent_family_age_of_family_reference_p_1ed89dd8" BIGINT  -- Concealed Lone Parent Family Age Of Family Reference Person 25 To 34,
  "concealed_lone_parent_family_age_of_family_reference_p_a19263ab" BIGINT  -- Concealed Lone Parent Family Age Of Family Reference Person 35 To 49,
  "concealed_lone_parent_family_age_of_family_reference_p_667820ca" BIGINT  -- Concealed Lone Parent Family Age Of Family Reference Person 50 To 64,
  "concealed_lone_parent_family_age_of_family_reference_p_13f52b9b" BIGINT  -- Concealed Lone Parent Family Age Of Family Reference Person 65 To 74,
  "concealed_lone_parent_family_age_of_family_reference_p_c1595560" BIGINT  -- Concealed Lone Parent Family Age Of Family Reference Person 75 To 84,
  "concealed_lone_parent_family_age_of_family_reference_p_10580dce" BIGINT  -- Concealed Lone Parent Family Age Of Family Reference Person 85 And Over,
  "concealed_lone_parent_family_with_dependent_children_total" BIGINT,
  "concealed_lone_parent_family_with_dependent_children_a_cd6da8c6" BIGINT  -- Concealed Lone Parent Family With Dependent Children Age Of Family Reference Person 24 And Under,
  "concealed_lone_parent_family_with_dependent_children_a_74c2b8d4" BIGINT  -- Concealed Lone Parent Family With Dependent Children Age Of Family Reference Person 25 To 34,
  "concealed_lone_parent_family_with_dependent_children_a_8689a4f0" BIGINT  -- Concealed Lone Parent Family With Dependent Children Age Of Family Reference Person 35 To 49,
  "concealed_lone_parent_family_with_dependent_children_a_803a7082" BIGINT  -- Concealed Lone Parent Family With Dependent Children Age Of Family Reference Person 50 To 64,
  "concealed_lone_parent_family_with_dependent_children_a_43666d60" BIGINT  -- Concealed Lone Parent Family With Dependent Children Age Of Family Reference Person 65 To 74,
  "concealed_lone_parent_family_with_dependent_children_a_f1deeef7" BIGINT  -- Concealed Lone Parent Family With Dependent Children Age Of Family Reference Person 75 To 84,
  "concealed_lone_parent_family_with_dependent_children_a_cbee194b" BIGINT  -- Concealed Lone Parent Family With Dependent Children Age Of Family Reference Person 85 And Over,
  "concealed_lone_parent_family_with_all_children_non_dep_8090d8b8" BIGINT  -- Concealed Lone Parent Family With All Children Non-dependent Total,
  "concealed_lone_parent_family_with_all_children_non_dep_4d35784b" BIGINT  -- Concealed Lone Parent Family With All Children Non-dependent Age Of Family Reference Person 24 And Under,
  "concealed_lone_parent_family_with_all_children_non_dep_e51a759e" BIGINT  -- Concealed Lone Parent Family With All Children Non-dependent Age Of Family Reference Person 25 To 34,
  "concealed_lone_parent_family_with_all_children_non_dep_1a380c04" BIGINT  -- Concealed Lone Parent Family With All Children Non-dependent Age Of Family Reference Person 35 To 49,
  "concealed_lone_parent_family_with_all_children_non_dep_0e5b3e07" BIGINT  -- Concealed Lone Parent Family With All Children Non-dependent Age Of Family Reference Person 50 To 64,
  "concealed_lone_parent_family_with_all_children_non_dep_3d2d9172" BIGINT  -- Concealed Lone Parent Family With All Children Non-dependent Age Of Family Reference Person 65 To 74,
  "concealed_lone_parent_family_with_all_children_non_dep_7fbbc515" BIGINT  -- Concealed Lone Parent Family With All Children Non-dependent Age Of Family Reference Person 75 To 84,
  "concealed_lone_parent_family_with_all_children_non_dep_4ec72cde" BIGINT  -- Concealed Lone Parent Family With All Children Non-dependent Age Of Family Reference Person 85 And Over,
  "concealed_couple_families_total" BIGINT,
  "concealed_couple_families_age_of_family_reference_pers_d7bad7c3" BIGINT  -- Concealed Couple Families Age Of Family Reference Person 24 And Under,
  "concealed_couple_families_age_of_family_reference_pers_7f93f847" BIGINT  -- Concealed Couple Families Age Of Family Reference Person 25 To 34,
  "concealed_couple_families_age_of_family_reference_pers_8366c45c" BIGINT  -- Concealed Couple Families Age Of Family Reference Person 35 To 49,
  "concealed_couple_families_age_of_family_reference_pers_43a0d2e6" BIGINT  -- Concealed Couple Families Age Of Family Reference Person 50 To 64,
  "concealed_couple_families_age_of_family_reference_pers_a71856e8" BIGINT  -- Concealed Couple Families Age Of Family Reference Person 65 To 74,
  "concealed_couple_families_age_of_family_reference_pers_2d6d78f0" BIGINT  -- Concealed Couple Families Age Of Family Reference Person 75 To 84,
  "concealed_couple_families_age_of_family_reference_pers_d89312ba" BIGINT  -- Concealed Couple Families Age Of Family Reference Person 85 And Over,
  "concealed_couple_family_with_no_children_total" BIGINT,
  "concealed_couple_family_with_no_children_age_of_family_468eb6a7" BIGINT  -- Concealed Couple Family With No Children Age Of Family Reference Person 24 And Under,
  "concealed_couple_family_with_no_children_age_of_family_c58b10d1" BIGINT  -- Concealed Couple Family With No Children Age Of Family Reference Person 25 To 34,
  "concealed_couple_family_with_no_children_age_of_family_18d6090c" BIGINT  -- Concealed Couple Family With No Children Age Of Family Reference Person 35 To 49,
  "concealed_couple_family_with_no_children_age_of_family_59085177" BIGINT  -- Concealed Couple Family With No Children Age Of Family Reference Person 50 To 64,
  "concealed_couple_family_with_no_children_age_of_family_ed8b52f3" BIGINT  -- Concealed Couple Family With No Children Age Of Family Reference Person 65 To 74,
  "concealed_couple_family_with_no_children_age_of_family_1811b52a" BIGINT  -- Concealed Couple Family With No Children Age Of Family Reference Person 75 To 84,
  "concealed_couple_family_with_no_children_age_of_family_324fc04c" BIGINT  -- Concealed Couple Family With No Children Age Of Family Reference Person 85 And Over,
  "concealed_couple_family_with_dependent_children_total" BIGINT,
  "concealed_couple_family_with_dependent_children_age_of_5cb345a1" BIGINT  -- Concealed Couple Family With Dependent Children Age Of Family Reference Person 24 And Under,
  "concealed_couple_family_with_dependent_children_age_of_3f99dd7f" BIGINT  -- Concealed Couple Family With Dependent Children Age Of Family Reference Person 25 To 34,
  "concealed_couple_family_with_dependent_children_age_of_a20c2736" BIGINT  -- Concealed Couple Family With Dependent Children Age Of Family Reference Person 35 To 49,
  "concealed_couple_family_with_dependent_children_age_of_37de52cf" BIGINT  -- Concealed Couple Family With Dependent Children Age Of Family Reference Person 50 To 64,
  "concealed_couple_family_with_dependent_children_age_of_70f3b7e2" BIGINT  -- Concealed Couple Family With Dependent Children Age Of Family Reference Person 65 To 74,
  "concealed_couple_family_with_dependent_children_age_of_4532dad6" BIGINT  -- Concealed Couple Family With Dependent Children Age Of Family Reference Person 75 To 84,
  "concealed_couple_family_with_dependent_children_age_of_794b1ebe" BIGINT  -- Concealed Couple Family With Dependent Children Age Of Family Reference Person 85 And Over,
  "concealed_couple_family_with_all_children_non_dependent_total" BIGINT,
  "concealed_couple_family_with_all_children_non_dependen_5d2dc979" BIGINT  -- Concealed Couple Family With All Children Non-dependent Age Of Family Reference Person 24 And Under,
  "concealed_couple_family_with_all_children_non_dependen_e81657ac" BIGINT  -- Concealed Couple Family With All Children Non-dependent Age Of Family Reference Person 25 To 34,
  "concealed_couple_family_with_all_children_non_dependen_403069ba" BIGINT  -- Concealed Couple Family With All Children Non-dependent Age Of Family Reference Person 35 To 49,
  "concealed_couple_family_with_all_children_non_dependen_3232a888" BIGINT  -- Concealed Couple Family With All Children Non-dependent Age Of Family Reference Person 50 To 64,
  "concealed_couple_family_with_all_children_non_dependen_94bd3adf" BIGINT  -- Concealed Couple Family With All Children Non-dependent Age Of Family Reference Person 65 To 74,
  "concealed_couple_family_with_all_children_non_dependen_882f2823" BIGINT  -- Concealed Couple Family With All Children Non-dependent Age Of Family Reference Person 75 To 84,
  "concealed_couple_family_with_all_children_non_dependen_a9d2e789" BIGINT  -- Concealed Couple Family With All Children Non-dependent Age Of Family Reference Person 85 And Over
);