I work at an excellent state comprehensive school where children thrive. In fact, children thrive at all the state comprehensive schools in my area. Most of the schools in my area get progress and attainment results that are well above average, yet I see people comparing them in a league table and making decisions based on whichever one is highest in the table that year.
What you need to know is that although attainment and progress results are averaged across a whole cohort they can be significantly skewed by a very small number of "outlier" students. Most schools have a handful of students who perform significantly below par, due to social or medical reasons outside of the school's control. It is usually related to persistent absence and, in some cases, school refusal.
You simply can't tell from the results whether schools are doing everything they can to help these students and keep them in school, or whether they are managing them out. But if they are in the former category, then their averaged results will definitely be impacted.
The outliers should arguably be excluded from the published results. There is a DfE process for requesting this, but the evidence bar is very high, relying on testimony from social workers. Unfortunately the chaos in the social care system makes this extremely difficult to obtain. The children may have had several different social workers over the relevant time period and there is absolutely no incentive for any social worker to spend time on the sort of detailed paperwork that is needed to satisfy the DfE - why should they care enough about any school's reported results to put in this time and effort?
The more students a school has in this category, the more their results will be affected. Schools with fewer may have a more affluent catchment, a more nurturing approach (to help keep them in school), or a less nurturing approach (to push them out). You simply can't tell. But, the good news is that the below-par performance of a handful of persistently absent children will make no difference whatsoever to the performance of your child in the same school. So go with your gut and choose the school you know your child will be happiest at, not the one that is slightly higher in the league table. 🙂