Fingertips GP to Ward Lookup Matrix for Birmingham and Solihull
Published by Birmingham City Council
About this dataset
A weighted matrix to convert fingertips GP practice code data into Birmingham and Solihull wards. The matrix uses the GP census data to allocate a percentage of their patients to each ward based on the citizens home address. How to use Using a BI tool such as Power Query merge this with your GP Fingertips data based on the practice code. Expand the merged query to new rows Calculate the new count value using following formula: Count * Weighted Value Calculate the new denominator value using the following formula: Denominator * Weighted Value Group the Fingertips data by Indicator ID, Indicator name, Local authority. Ward code, Ward, Time period, Sex, Age with the aggregation of SUM on the New count and New denominator columns Calculate the new value with the following formula: new count / new denominator *100 Useful information The matrix is based on a recent GP census. It is therefore advisable to only work with the latest Fingertips data as historical information will be inaccurate. To view previous versions see the Snapshots section on the Export tab. ℹ️ Release September 2025
Tags
Live preview
The first rows, fetched from Opendatasoft hub when you open this page.
Loading the first rows from the source…