{{ ctx.nhits | number }} record

{{ ctx.nhits | number }} record

Active filters

No active filters

Filters

La recherche texte n'est pas appliquée pendant l'utilisation de la Console d'API.

Fingertips GP to Ward Lookup Matrix for Birmingham and Solihull

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

  1. Using a BI tool such as Power Query merge this with your GP Fingertips data based on the practice code.
  2. Expand the merged query to new rows
  3. Calculate the new count value using following formula: Count * Weighted Value
  4. Calculate the new denominator value using the following formula: Denominator * Weighted Value
  5. 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
  6. 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.

Dataset Identifier
fingertips-gp-to-ward-lookup-matrix-for-birmingham-and-solihull@cityobservatorybirmingham
Source
Birmingham City Observatory
Downloads
{{ ctx.dataset.extra_metas.explore.download_count | number }}
Last processing
{{ ctx.dataset.metas.metadata_processed|formatMeta:'datetime' }} (metadata)
{{ ctx.dataset.metas.data_processed|formatMeta:'datetime' }} (data)

Dataset schema

JSON Schema

The following JSON object is a standardized description of your dataset's schema. More about JSON schema.

Edit in advanced mode