Concealed Families

Cambridgeshire Insight

@ukgov.concealed_families

Table List

1 table(140.95 KB)

Table 1

@ukgov.concealed_families.table_1

140.95 KB
324 rows
74 columns

ons_code ONS Code	local_authority_area Local Authority Area	all_families_total All Families Total	all_families_age_of_family_reference_person_24_and_under All Families Age Of Family Reference Person 24 And Under	all_families_age_of_family_reference_person_25_to_34 All Families Age Of Family Reference Person 25 To 34	all_families_age_of_family_reference_person_35_to_49 All Families Age Of Family Reference Person 35 To 49	all_families_age_of_family_reference_person_50_to_64 All Families Age Of Family Reference Person 50 To 64	all_families_age_of_family_reference_person_65_to_74 All Families Age Of Family Reference Person 65 To 74	all_families_age_of_family_reference_person_75_to_84 All Families Age Of Family Reference Person 75 To 84	all_families_age_of_family_reference_person_85_and_over All Families Age Of Family Reference Person 85 And Over	concealed_families_total Concealed Families Total	concealed_family_age_of_family_reference_person_24_and_under Concealed Family Age Of Family Reference Person 24 And Under	concealed_family_age_of_family_reference_person_25_to_34 Concealed Family Age Of Family Reference Person 25 To 34	concealed_family_age_of_family_reference_person_35_to_49 Concealed Family Age Of Family Reference Person 35 To 49	concealed_family_age_of_family_reference_person_50_to_64 Concealed Family Age Of Family Reference Person 50 To 64	concealed_family_age_of_family_reference_person_65_to_74 Concealed Family Age Of Family Reference Person 65 To 74	concealed_family_age_of_family_reference_person_75_to_84 Concealed Family Age Of Family Reference Person 75 To 84	concealed_family_age_of_family_reference_person_85_and_over Concealed Family Age Of Family Reference Person 85 And Over	concealed_lone_parent_families_total Concealed Lone Parent Families Total	concealed_lone_parent_family_age_of_family_reference_p_8e72b765 Concealed Lone Parent Family Age Of Family Reference Person 24 And Under	concealed_lone_parent_family_age_of_family_reference_p_1ed89dd8 Concealed Lone Parent Family Age Of Family Reference Person 25 To 34	concealed_lone_parent_family_age_of_family_reference_p_a19263ab Concealed Lone Parent Family Age Of Family Reference Person 35 To 49	concealed_lone_parent_family_age_of_family_reference_p_667820ca Concealed Lone Parent Family Age Of Family Reference Person 50 To 64	concealed_lone_parent_family_age_of_family_reference_p_13f52b9b Concealed Lone Parent Family Age Of Family Reference Person 65 To 74	concealed_lone_parent_family_age_of_family_reference_p_c1595560 Concealed Lone Parent Family Age Of Family Reference Person 75 To 84	concealed_lone_parent_family_age_of_family_reference_p_10580dce Concealed Lone Parent Family Age Of Family Reference Person 85 And Over	concealed_lone_parent_family_with_dependent_children_total Concealed Lone Parent Family With Dependent Children Total	concealed_lone_parent_family_with_dependent_children_a_cd6da8c6 Concealed Lone Parent Family With Dependent Children Age Of Family Reference Person 24 And Under	concealed_lone_parent_family_with_dependent_children_a_74c2b8d4 Concealed Lone Parent Family With Dependent Children Age Of Family Reference Person 25 To 34	concealed_lone_parent_family_with_dependent_children_a_8689a4f0 Concealed Lone Parent Family With Dependent Children Age Of Family Reference Person 35 To 49	concealed_lone_parent_family_with_dependent_children_a_803a7082 Concealed Lone Parent Family With Dependent Children Age Of Family Reference Person 50 To 64	concealed_lone_parent_family_with_dependent_children_a_43666d60 Concealed Lone Parent Family With Dependent Children Age Of Family Reference Person 65 To 74	concealed_lone_parent_family_with_dependent_children_a_f1deeef7 Concealed Lone Parent Family With Dependent Children Age Of Family Reference Person 75 To 84	concealed_lone_parent_family_with_dependent_children_a_cbee194b 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 Concealed Lone Parent Family With All Children Non-dependent Total	concealed_lone_parent_family_with_all_children_non_dep_4d35784b 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 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 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 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 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 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 Concealed Lone Parent Family With All Children Non-dependent Age Of Family Reference Person 85 And Over	concealed_couple_families_total Concealed Couple Families Total	concealed_couple_families_age_of_family_reference_pers_d7bad7c3 Concealed Couple Families Age Of Family Reference Person 24 And Under	concealed_couple_families_age_of_family_reference_pers_7f93f847 Concealed Couple Families Age Of Family Reference Person 25 To 34	concealed_couple_families_age_of_family_reference_pers_8366c45c Concealed Couple Families Age Of Family Reference Person 35 To 49	concealed_couple_families_age_of_family_reference_pers_43a0d2e6 Concealed Couple Families Age Of Family Reference Person 50 To 64	concealed_couple_families_age_of_family_reference_pers_a71856e8 Concealed Couple Families Age Of Family Reference Person 65 To 74	concealed_couple_families_age_of_family_reference_pers_2d6d78f0 Concealed Couple Families Age Of Family Reference Person 75 To 84	concealed_couple_families_age_of_family_reference_pers_d89312ba Concealed Couple Families Age Of Family Reference Person 85 And Over	concealed_couple_family_with_no_children_total Concealed Couple Family With No Children Total	concealed_couple_family_with_no_children_age_of_family_468eb6a7 Concealed Couple Family With No Children Age Of Family Reference Person 24 And Under	concealed_couple_family_with_no_children_age_of_family_c58b10d1 Concealed Couple Family With No Children Age Of Family Reference Person 25 To 34	concealed_couple_family_with_no_children_age_of_family_18d6090c Concealed Couple Family With No Children Age Of Family Reference Person 35 To 49	concealed_couple_family_with_no_children_age_of_family_59085177 Concealed Couple Family With No Children Age Of Family Reference Person 50 To 64	concealed_couple_family_with_no_children_age_of_family_ed8b52f3 Concealed Couple Family With No Children Age Of Family Reference Person 65 To 74	concealed_couple_family_with_no_children_age_of_family_1811b52a Concealed Couple Family With No Children Age Of Family Reference Person 75 To 84	concealed_couple_family_with_no_children_age_of_family_324fc04c Concealed Couple Family With No Children Age Of Family Reference Person 85 And Over	concealed_couple_family_with_dependent_children_total Concealed Couple Family With Dependent Children Total	concealed_couple_family_with_dependent_children_age_of_5cb345a1 Concealed Couple Family With Dependent Children Age Of Family Reference Person 24 And Under	concealed_couple_family_with_dependent_children_age_of_3f99dd7f Concealed Couple Family With Dependent Children Age Of Family Reference Person 25 To 34	concealed_couple_family_with_dependent_children_age_of_a20c2736 Concealed Couple Family With Dependent Children Age Of Family Reference Person 35 To 49	concealed_couple_family_with_dependent_children_age_of_37de52cf Concealed Couple Family With Dependent Children Age Of Family Reference Person 50 To 64	concealed_couple_family_with_dependent_children_age_of_70f3b7e2 Concealed Couple Family With Dependent Children Age Of Family Reference Person 65 To 74	concealed_couple_family_with_dependent_children_age_of_4532dad6 Concealed Couple Family With Dependent Children Age Of Family Reference Person 75 To 84	concealed_couple_family_with_dependent_children_age_of_794b1ebe Concealed Couple Family With Dependent Children Age Of Family Reference Person 85 And Over	concealed_couple_family_with_all_children_non_dependent_total Concealed Couple Family With All Children Non-dependent Total	concealed_couple_family_with_all_children_non_dependen_5d2dc979 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 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 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 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 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 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 Concealed Couple Family With All Children Non-dependent Age Of Family Reference Person 85 And Over
E41000244	Adur	18076	422	2108	5920	5206	2396	1550	474	261	55	80	35	35	35	19	2	82	21	17	22	10	4	7	1	59	21	17	18	2	1			23			4	8	3	7	1	179	34	63	13	25	31	12	1	138	30	43	7	21	27	9	1	38	4	20	6	3	3	2		3				1	1	1
E41000065	Allerdale	28891	661	3206	8966	9133	4086	2294	545	339	102	104	46	24	32	21	10	154	68	46	26	6	3	4	1	137	67	45	21	1	2	1		17	1	1	5	5	1	3	1	185	34	58	20	18	29	17	9	145	29	42	7	16	29	14	8	34	5	16	12			1		6			1	2		2	1
E41000071	Amber Valley	37437	928	4548	12388	11404	4958	2552	659	395	113	107	53	51	51	18	2	158	55	50	23	14	9	6	1	131	55	50	20	2	2	1	1	27			3	12	7	5		237	58	57	30	37	42	12	1	192	53	46	19	28	35	11		30	5	11	8	4	2			15			3	5	5	1	1
E41000245	Arun	43896	1069	4723	12702	12409	6961	4635	1397	666	166	202	100	79	65	43	11	186	61	39	44	22	6	10	4	143	61	39	35	7	1			43			9	15	5	10	4	480	105	163	56	57	59	33	7	371	92	120	30	45	47	30	7	90	13	43	25	2	6	1		19			1	10	6	2
E41000196	Ashfield	36285	1387	5352	12363	9941	4547	2207	488	426	138	114	49	51	45	24	5	190	75	55	34	11	6	7	2	157	75	55	25	1	1			33			9	10	5	7	2	236	63	59	15	40	39	17	3	184	51	51	4	24	34	17	3	39	12	8	11	7	1			13				9	4
E41000137	Ashford	35197	1093	4764	12266	9859	4230	2306	679	562	135	141	94	78	65	39	10	167	64	32	38	19	4	4	6	137	63	31	34	7	1	1		30	1	1	4	12	3	3	6	395	71	109	56	59	61	35	4	288	56	86	27	40	46	30	3	80	15	23	27	11	4			27			2	8	11	5	1
E41000056	Aylesbury Vale	50748	1005	6489	18484	15564	5530	2936	740	736	168	207	99	103	91	54	14	240	78	70	42	23	10	12	5	188	78	70	35	3	2			52			7	20	8	12	5	496	90	137	57	80	81	42	9	352	81	101	20	33	69	39	9	99	9	35	35	13	6	1		45		1	2	34	6	2
E41000221	Babergh	26633	521	2657	8433	8286	3946	2232	558	233	54	65	31	32	27	17	7	65	25	12	14	8	2	2	2	48	25	12	10	1				17			4	7	2	2	2	168	29	53	17	24	25	15	5	135	25	39	9	19	24	14	5	28	4	14	8	1		1		5				4	1
E41000293	Barking and Dagenham	49396	2255	10594	19641	10784	3266	2186	670	1612	340	610	293	188	111	57	13	695	206	211	141	82	35	14	6	546	206	210	113	12	4	1		149		1	28	70	31	13	6	917	134	399	152	106	76	43	7	572	117	254	67	46	53	29	6	279	17	144	77	26	8	6	1	66		1	8	34	15	8
E41000294	Barnet	92793	1948	16230	33997	24699	8638	5507	1774	2876	283	1072	502	398	315	241	65	732	120	164	176	140	61	47	24	473	118	163	149	32	6	4	1	259	2	1	27	108	55	43	23	2144	163	908	326	258	254	194	41	1576	147	712	166	155	194	166	36	421	15	195	152	32	20	6	1	147	1	1	8	71	40	22	4


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_p_1ed89dd8" BIGINT,
  "concealed_lone_parent_family_age_of_family_reference_p_a19263ab" BIGINT,
  "concealed_lone_parent_family_age_of_family_reference_p_667820ca" BIGINT,
  "concealed_lone_parent_family_age_of_family_reference_p_13f52b9b" BIGINT,
  "concealed_lone_parent_family_age_of_family_reference_p_c1595560" BIGINT,
  "concealed_lone_parent_family_age_of_family_reference_p_10580dce" BIGINT,
  "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_a_74c2b8d4" BIGINT,
  "concealed_lone_parent_family_with_dependent_children_a_8689a4f0" BIGINT,
  "concealed_lone_parent_family_with_dependent_children_a_803a7082" BIGINT,
  "concealed_lone_parent_family_with_dependent_children_a_43666d60" BIGINT,
  "concealed_lone_parent_family_with_dependent_children_a_f1deeef7" BIGINT,
  "concealed_lone_parent_family_with_dependent_children_a_cbee194b" BIGINT,
  "concealed_lone_parent_family_with_all_children_non_dep_8090d8b8" BIGINT,
  "concealed_lone_parent_family_with_all_children_non_dep_4d35784b" BIGINT,
  "concealed_lone_parent_family_with_all_children_non_dep_e51a759e" BIGINT,
  "concealed_lone_parent_family_with_all_children_non_dep_1a380c04" BIGINT,
  "concealed_lone_parent_family_with_all_children_non_dep_0e5b3e07" BIGINT,
  "concealed_lone_parent_family_with_all_children_non_dep_3d2d9172" BIGINT,
  "concealed_lone_parent_family_with_all_children_non_dep_7fbbc515" BIGINT,
  "concealed_lone_parent_family_with_all_children_non_dep_4ec72cde" BIGINT,
  "concealed_couple_families_total" BIGINT,
  "concealed_couple_families_age_of_family_reference_pers_d7bad7c3" BIGINT,
  "concealed_couple_families_age_of_family_reference_pers_7f93f847" BIGINT,
  "concealed_couple_families_age_of_family_reference_pers_8366c45c" BIGINT,
  "concealed_couple_families_age_of_family_reference_pers_43a0d2e6" BIGINT,
  "concealed_couple_families_age_of_family_reference_pers_a71856e8" BIGINT,
  "concealed_couple_families_age_of_family_reference_pers_2d6d78f0" BIGINT,
  "concealed_couple_families_age_of_family_reference_pers_d89312ba" BIGINT,
  "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_c58b10d1" BIGINT,
  "concealed_couple_family_with_no_children_age_of_family_18d6090c" BIGINT,
  "concealed_couple_family_with_no_children_age_of_family_59085177" BIGINT,
  "concealed_couple_family_with_no_children_age_of_family_ed8b52f3" BIGINT,
  "concealed_couple_family_with_no_children_age_of_family_1811b52a" BIGINT,
  "concealed_couple_family_with_no_children_age_of_family_324fc04c" BIGINT,
  "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_3f99dd7f" BIGINT,
  "concealed_couple_family_with_dependent_children_age_of_a20c2736" BIGINT,
  "concealed_couple_family_with_dependent_children_age_of_37de52cf" BIGINT,
  "concealed_couple_family_with_dependent_children_age_of_70f3b7e2" BIGINT,
  "concealed_couple_family_with_dependent_children_age_of_4532dad6" BIGINT,
  "concealed_couple_family_with_dependent_children_age_of_794b1ebe" BIGINT,
  "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_dependen_e81657ac" BIGINT,
  "concealed_couple_family_with_all_children_non_dependen_403069ba" BIGINT,
  "concealed_couple_family_with_all_children_non_dependen_3232a888" BIGINT,
  "concealed_couple_family_with_all_children_non_dependen_94bd3adf" BIGINT,
  "concealed_couple_family_with_all_children_non_dependen_882f2823" BIGINT,
  "concealed_couple_family_with_all_children_non_dependen_a9d2e789" BIGINT
);