Percentage of homes spent on social care costs

	A	B	C	D
1	Region_Name	Average_Price	Potential Care bill	% of value of family home taken up in care costs
2	Northern Ireland	124,007	24,007	19.40%
3	Scotland	137,139	37,139	27.10%
4	Wales	147,746	47,746	32.30%
5	England	232,530	132,530	57.00%
6	Outer London	424,138	324,138	76.40%
7	Inner London	579,331	479,331	82.70%
8	East Renfrewshire	205,759	105,759	51.40%
9	Clackmannanshire	112,849	12,849	11.40%
10	Aberdeenshire	189,831	89,831	47.30%
11	Angus	141,848	41,848	29.50%
12	Argyll and Bute	124,138	24,138	19.40%
13	City of Aberdeen	163,050	63,050	38.70%
14	City of Dundee	117,274	17,274	14.70%
15	City of Edinburgh	227,597	127,597	56.10%
16	City of Glasgow	116,022	16,022	13.80%
17	North Ayrshire	96,131	-	0.00%
18	North East	122,298	22,298	18.20%
19	North Lanarkshire	98,660	-	0.00%
20	North West	150,250	50,250	33.40%
21	Highland	155,312	55,312	35.60%
22	Inverclyde	100,230	230	0.20%
23	Midlothian	154,194	54,194	35.10%
24	Moray	140,549	40,549	28.90%
25	Na h-Eileanan Siar	103,986	3,986	3.80%
26	Yorkshire and The Humber	149,606	49,606	33.20%
27	Falkirk	109,614	9,614	8.80%
28	Fife	127,774	27,774	21.70%
29	London	471,742	371,742	78.80%
30	West Dunbartonshire	94,691	-	0.00%
31	West Lothian	137,847	37,847	27.50%
32	West Midlands Region	180,293	80,293	44.50%
33	Scottish Borders	139,213	39,213	28.20%
34	Shetland Islands	158,411	58,411	36.90%
35	South Ayrshire	128,232	28,232	22.00%
36	South East	311,514	211,514	67.90%
37	South Lanarkshire	121,155	21,155	17.50%
38	South West	240,222	140,222	58.40%
39	Stirling	170,141	70,141	41.20%
40	Orkney Islands	143,751	43,751	30.40%
41	Perth and Kinross	175,435	75,435	43.00%
42	Renfrewshire	109,973	9,973	9.10%
43	Dumfries and Galloway	118,307	18,307	15.50%
44	East Ayrshire	87,657	-	0.00%
45	East Dunbartonshire	196,332	96,332	49.10%
46	East Lothian	194,868	94,868	48.70%
47	East Midlands	176,213	76,213	43.30%
48	East of England	277,127	177,127	63.90%
49	West Midlands	164,272	64,272	39.10%
50	South Yorkshire	130,665	30,665	23.50%
51	Merseyside	136,067	36,067	26.50%
52	Tyne and Wear	133,021	33,021	24.80%
53	West Yorkshire	144,367	44,367	30.70%
54	Greater Manchester	154,037	54,037	35.10%
55	Kent	276,850	176,850	63.90%
56	Lancashire	136,344	36,344	26.70%
57	Leicestershire	208,246	108,246	52.00%
58	Worcestershire	220,003	120,003	54.50%
59	East Sussex	263,744	163,744	62.10%
60	Essex	296,869	196,869	66.30%
61	Norfolk	211,390	111,390	52.70%
62	Hampshire	304,535	204,535	67.20%
63	Hertfordshire	394,501	294,501	74.70%
64	Lincolnshire	170,322	70,322	41.30%
65	West Sussex	311,301	211,301	67.90%
66	Somerset	220,643	120,643	54.70%
67	Gloucestershire	245,787	145,787	59.30%
68	Staffordshire	177,488	77,488	43.70%
69	Suffolk	231,702	131,702	56.80%
70	Surrey	437,726	337,726	77.20%
71	Oxfordshire	351,703	251,703	71.60%
72	Warwickshire	232,532	132,532	57.00%
73	Buckinghamshire	400,255	300,255	75.00%
74	Cambridgeshire	282,737	182,737	64.60%
75	Nottinghamshire	159,096	59,096	37.10%
76	Northamptonshire	211,530	111,530	52.70%
77	North Yorkshire	207,106	107,106	51.70%
78	Devon	241,028	141,028	58.50%
79	Dorset	283,691	183,691	64.80%
80	Cumbria	150,556	50,556	33.60%
81	Derbyshire	163,039	63,039	38.70%
82	North Down and Ards	142,807	42,807	30.00%
83	Hillingdon	415,716	315,716	75.90%
84	Hounslow	406,976	306,976	75.40%
85	Islington	615,100	515,100	83.70%
86	Kensington And Chelsea	1,406,839	1,306,839	92.90%
87	Kingston upon Thames	488,416	388,416	79.50%
88	Lambeth	512,409	412,409	80.50%
89	Lewisham	414,721	314,721	75.90%
90	Merton	509,193	409,193	80.40%
91	Mid and East Antrim	114,932	14,932	13.00%
92	Mid Ulster	124,950	24,950	20.00%
93	Enfield	393,414	293,414	74.60%
94	Fermanagh and Omagh	112,358	12,358	11.00%
95	Newham	353,300	253,300	71.70%
96	Newry Mourne and Down	130,322	30,322	23.30%
97	Greenwich	368,451	268,451	72.90%
98	Hackney	571,016	471,016	82.50%
99	Hammersmith and Fulham	755,233	655,233	86.80%
100	Haringey	571,511	471,511	82.50%