About this Dataset

Patients Registered At A GP Practice

Modelled counts of patients registered at a GP practice by single year of age (0-95+), sex, and local authority of residence.

These modelled data contain information from NHS Digital, licenced under the current version of the Open Government Licence:

Counts of patients by practice attended x sex x LSOA of residence - currently published quarterly
Counts of patients by practice attended x sex x single year of age - currently published monthly

These data are published by NHS Digital here: https://digital.nhs.uk/data-and-information/publications/statistical/patients-registered-at-a-gp-practice

Please refer to NHS DIgital documentation for full data quality and metadata information about the original data.

The GLA modelled counts of patients by age, sex, and local authority of residence are created by a simple process of apportioning the data for each GP practice in (2) by the distribution for each practice in (1). As residence data is only published quarterly, distributions for other months are interpolated.

A respository of the code used to generate the modelled counts is available on GitHub at: https://github.com/Greater-London-Authority/process-published-nhs-data

This data is used as an input to Modelled estimates of recent births

Notes on usage

Patient register data can be used to provide frequent low-latency indicators of changing population trends. However, patient counts should not be interpreted as a direct proxy for population. Patient counts have been prone to compounding inflation in recent years, primarily as a result of failures to remove former patients that have since moved overseas (local inflation/deficits also occur due to delays in patients updating their records or registering with a new GP when moving within the UK).

The rate of inflation varies by area, sex, and age, being greatest for:

areas with high volumes of international migration
adults age 20-30 (with the impact spreading to older groups over time)
males - due to typically lower levels of interaction with health services
Publisher name: Greater London Authority
Last updated: 2025-05-27T04:01:25Z

Tables

Gp Sya Ctry

@ukgov.patients_registered_at_a_gp_practice_1.gp_sya_ctry

258.9 KB
324 rows
102 columns


CREATE TABLE gp_sya_ctry (
  "gss_code" VARCHAR,
  "gss_name" VARCHAR,
  "geography" VARCHAR,
  "measure" VARCHAR,
  "extract_date" TIMESTAMP,
  "sex" VARCHAR,
  "age_0" DOUBLE,
  "age_1" DOUBLE,
  "age_2" DOUBLE,
  "age_3" DOUBLE,
  "age_4" DOUBLE,
  "age_5" DOUBLE,
  "age_6" DOUBLE,
  "age_7" DOUBLE,
  "age_8" DOUBLE,
  "age_9" DOUBLE,
  "age_10" DOUBLE,
  "age_11" DOUBLE,
  "age_12" DOUBLE,
  "age_13" DOUBLE,
  "age_14" DOUBLE,
  "age_15" DOUBLE,
  "age_16" DOUBLE,
  "age_17" DOUBLE,
  "age_18" DOUBLE,
  "age_19" DOUBLE,
  "age_20" DOUBLE,
  "age_21" DOUBLE,
  "age_22" DOUBLE,
  "age_23" DOUBLE,
  "age_24" DOUBLE,
  "age_25" DOUBLE,
  "age_26" DOUBLE,
  "age_27" DOUBLE,
  "age_28" DOUBLE,
  "age_29" DOUBLE,
  "age_30" DOUBLE,
  "age_31" DOUBLE,
  "age_32" DOUBLE,
  "age_33" DOUBLE,
  "age_34" DOUBLE,
  "age_35" DOUBLE,
  "age_36" DOUBLE,
  "age_37" DOUBLE,
  "age_38" DOUBLE,
  "age_39" DOUBLE,
  "age_40" DOUBLE,
  "age_41" DOUBLE,
  "age_42" DOUBLE,
  "age_43" DOUBLE,
  "age_44" DOUBLE,
  "age_45" DOUBLE,
  "age_46" DOUBLE,
  "age_47" DOUBLE,
  "age_48" DOUBLE,
  "age_49" DOUBLE,
  "age_50" DOUBLE,
  "age_51" DOUBLE,
  "age_52" DOUBLE,
  "age_53" DOUBLE,
  "age_54" DOUBLE,
  "age_55" DOUBLE,
  "age_56" DOUBLE,
  "age_57" DOUBLE,
  "age_58" DOUBLE,
  "age_59" DOUBLE,
  "age_60" DOUBLE,
  "age_61" DOUBLE,
  "age_62" DOUBLE,
  "age_63" DOUBLE,
  "age_64" DOUBLE,
  "age_65" DOUBLE,
  "age_66" DOUBLE,
  "age_67" DOUBLE,
  "age_68" DOUBLE,
  "age_69" DOUBLE,
  "age_70" DOUBLE,
  "age_71" DOUBLE,
  "age_72" DOUBLE,
  "age_73" DOUBLE,
  "age_74" DOUBLE,
  "age_75" DOUBLE,
  "age_76" DOUBLE,
  "age_77" DOUBLE,
  "age_78" DOUBLE,
  "age_79" DOUBLE,
  "age_80" DOUBLE,
  "age_81" DOUBLE,
  "age_82" DOUBLE,
  "age_83" DOUBLE,
  "age_84" DOUBLE,
  "age_85" DOUBLE,
  "age_86" DOUBLE,
  "age_87" DOUBLE,
  "age_88" DOUBLE,
  "age_89" DOUBLE,
  "age_90" DOUBLE,
  "age_91" DOUBLE,
  "age_92" DOUBLE,
  "age_93" DOUBLE
);

Gp Sya Itl

@ukgov.patients_registered_at_a_gp_practice_1.gp_sya_itl

6.27 MB
10692 rows
102 columns


CREATE TABLE gp_sya_itl (
  "gss_code" VARCHAR,
  "gss_name" VARCHAR,
  "geography" VARCHAR,
  "measure" VARCHAR,
  "extract_date" TIMESTAMP,
  "sex" VARCHAR,
  "age_0" DOUBLE,
  "age_1" DOUBLE,
  "age_2" DOUBLE,
  "age_3" DOUBLE,
  "age_4" DOUBLE,
  "age_5" DOUBLE,
  "age_6" DOUBLE,
  "age_7" DOUBLE,
  "age_8" DOUBLE,
  "age_9" DOUBLE,
  "age_10" DOUBLE,
  "age_11" DOUBLE,
  "age_12" DOUBLE,
  "age_13" DOUBLE,
  "age_14" DOUBLE,
  "age_15" DOUBLE,
  "age_16" DOUBLE,
  "age_17" DOUBLE,
  "age_18" DOUBLE,
  "age_19" DOUBLE,
  "age_20" DOUBLE,
  "age_21" DOUBLE,
  "age_22" DOUBLE,
  "age_23" DOUBLE,
  "age_24" DOUBLE,
  "age_25" DOUBLE,
  "age_26" DOUBLE,
  "age_27" DOUBLE,
  "age_28" DOUBLE,
  "age_29" DOUBLE,
  "age_30" DOUBLE,
  "age_31" DOUBLE,
  "age_32" DOUBLE,
  "age_33" DOUBLE,
  "age_34" DOUBLE,
  "age_35" DOUBLE,
  "age_36" DOUBLE,
  "age_37" DOUBLE,
  "age_38" DOUBLE,
  "age_39" DOUBLE,
  "age_40" DOUBLE,
  "age_41" DOUBLE,
  "age_42" DOUBLE,
  "age_43" DOUBLE,
  "age_44" DOUBLE,
  "age_45" DOUBLE,
  "age_46" DOUBLE,
  "age_47" DOUBLE,
  "age_48" DOUBLE,
  "age_49" DOUBLE,
  "age_50" DOUBLE,
  "age_51" DOUBLE,
  "age_52" DOUBLE,
  "age_53" DOUBLE,
  "age_54" DOUBLE,
  "age_55" DOUBLE,
  "age_56" DOUBLE,
  "age_57" DOUBLE,
  "age_58" DOUBLE,
  "age_59" DOUBLE,
  "age_60" DOUBLE,
  "age_61" DOUBLE,
  "age_62" DOUBLE,
  "age_63" DOUBLE,
  "age_64" DOUBLE,
  "age_65" DOUBLE,
  "age_66" DOUBLE,
  "age_67" DOUBLE,
  "age_68" DOUBLE,
  "age_69" DOUBLE,
  "age_70" DOUBLE,
  "age_71" DOUBLE,
  "age_72" DOUBLE,
  "age_73" DOUBLE,
  "age_74" DOUBLE,
  "age_75" DOUBLE,
  "age_76" DOUBLE,
  "age_77" DOUBLE,
  "age_78" DOUBLE,
  "age_79" DOUBLE,
  "age_80" DOUBLE,
  "age_81" DOUBLE,
  "age_82" DOUBLE,
  "age_83" DOUBLE,
  "age_84" DOUBLE,
  "age_85" DOUBLE,
  "age_86" DOUBLE,
  "age_87" DOUBLE,
  "age_88" DOUBLE,
  "age_89" DOUBLE,
  "age_90" DOUBLE,
  "age_91" DOUBLE,
  "age_92" DOUBLE,
  "age_93" DOUBLE
);

Gp Sya Lad

@ukgov.patients_registered_at_a_gp_practice_1.gp_sya_lad

29.02 MB
95904 rows
102 columns


CREATE TABLE gp_sya_lad (
  "gss_code" VARCHAR,
  "measure" VARCHAR,
  "extract_date" TIMESTAMP,
  "sex" VARCHAR,
  "gss_name" VARCHAR,
  "geography" VARCHAR,
  "age_0" DOUBLE,
  "age_1" DOUBLE,
  "age_2" DOUBLE,
  "age_3" DOUBLE,
  "age_4" DOUBLE,
  "age_5" DOUBLE,
  "age_6" DOUBLE,
  "age_7" DOUBLE,
  "age_8" DOUBLE,
  "age_9" DOUBLE,
  "age_10" DOUBLE,
  "age_11" DOUBLE,
  "age_12" DOUBLE,
  "age_13" DOUBLE,
  "age_14" DOUBLE,
  "age_15" DOUBLE,
  "age_16" DOUBLE,
  "age_17" DOUBLE,
  "age_18" DOUBLE,
  "age_19" DOUBLE,
  "age_20" DOUBLE,
  "age_21" DOUBLE,
  "age_22" DOUBLE,
  "age_23" DOUBLE,
  "age_24" DOUBLE,
  "age_25" DOUBLE,
  "age_26" DOUBLE,
  "age_27" DOUBLE,
  "age_28" DOUBLE,
  "age_29" DOUBLE,
  "age_30" DOUBLE,
  "age_31" DOUBLE,
  "age_32" DOUBLE,
  "age_33" DOUBLE,
  "age_34" DOUBLE,
  "age_35" DOUBLE,
  "age_36" DOUBLE,
  "age_37" DOUBLE,
  "age_38" DOUBLE,
  "age_39" DOUBLE,
  "age_40" DOUBLE,
  "age_41" DOUBLE,
  "age_42" DOUBLE,
  "age_43" DOUBLE,
  "age_44" DOUBLE,
  "age_45" DOUBLE,
  "age_46" DOUBLE,
  "age_47" DOUBLE,
  "age_48" DOUBLE,
  "age_49" DOUBLE,
  "age_50" DOUBLE,
  "age_51" DOUBLE,
  "age_52" DOUBLE,
  "age_53" DOUBLE,
  "age_54" DOUBLE,
  "age_55" DOUBLE,
  "age_56" DOUBLE,
  "age_57" DOUBLE,
  "age_58" DOUBLE,
  "age_59" DOUBLE,
  "age_60" DOUBLE,
  "age_61" DOUBLE,
  "age_62" DOUBLE,
  "age_63" DOUBLE,
  "age_64" DOUBLE,
  "age_65" DOUBLE,
  "age_66" DOUBLE,
  "age_67" DOUBLE,
  "age_68" DOUBLE,
  "age_69" DOUBLE,
  "age_70" DOUBLE,
  "age_71" DOUBLE,
  "age_72" DOUBLE,
  "age_73" DOUBLE,
  "age_74" DOUBLE,
  "age_75" DOUBLE,
  "age_76" DOUBLE,
  "age_77" DOUBLE,
  "age_78" DOUBLE,
  "age_79" DOUBLE,
  "age_80" DOUBLE,
  "age_81" DOUBLE,
  "age_82" DOUBLE,
  "age_83" DOUBLE,
  "age_84" DOUBLE,
  "age_85" DOUBLE,
  "age_86" DOUBLE,
  "age_87" DOUBLE,
  "age_88" DOUBLE,
  "age_89" DOUBLE,
  "age_90" DOUBLE,
  "age_91" DOUBLE,
  "age_92" DOUBLE,
  "age_93" DOUBLE
);

Gp Sya Rgn

@ukgov.patients_registered_at_a_gp_practice_1.gp_sya_rgn

1.8 MB
2916 rows
102 columns


CREATE TABLE gp_sya_rgn (
  "gss_code" VARCHAR,
  "gss_name" VARCHAR,
  "geography" VARCHAR,
  "measure" VARCHAR,
  "extract_date" TIMESTAMP,
  "sex" VARCHAR,
  "age_0" DOUBLE,
  "age_1" DOUBLE,
  "age_2" DOUBLE,
  "age_3" DOUBLE,
  "age_4" DOUBLE,
  "age_5" DOUBLE,
  "age_6" DOUBLE,
  "age_7" DOUBLE,
  "age_8" DOUBLE,
  "age_9" DOUBLE,
  "age_10" DOUBLE,
  "age_11" DOUBLE,
  "age_12" DOUBLE,
  "age_13" DOUBLE,
  "age_14" DOUBLE,
  "age_15" DOUBLE,
  "age_16" DOUBLE,
  "age_17" DOUBLE,
  "age_18" DOUBLE,
  "age_19" DOUBLE,
  "age_20" DOUBLE,
  "age_21" DOUBLE,
  "age_22" DOUBLE,
  "age_23" DOUBLE,
  "age_24" DOUBLE,
  "age_25" DOUBLE,
  "age_26" DOUBLE,
  "age_27" DOUBLE,
  "age_28" DOUBLE,
  "age_29" DOUBLE,
  "age_30" DOUBLE,
  "age_31" DOUBLE,
  "age_32" DOUBLE,
  "age_33" DOUBLE,
  "age_34" DOUBLE,
  "age_35" DOUBLE,
  "age_36" DOUBLE,
  "age_37" DOUBLE,
  "age_38" DOUBLE,
  "age_39" DOUBLE,
  "age_40" DOUBLE,
  "age_41" DOUBLE,
  "age_42" DOUBLE,
  "age_43" DOUBLE,
  "age_44" DOUBLE,
  "age_45" DOUBLE,
  "age_46" DOUBLE,
  "age_47" DOUBLE,
  "age_48" DOUBLE,
  "age_49" DOUBLE,
  "age_50" DOUBLE,
  "age_51" DOUBLE,
  "age_52" DOUBLE,
  "age_53" DOUBLE,
  "age_54" DOUBLE,
  "age_55" DOUBLE,
  "age_56" DOUBLE,
  "age_57" DOUBLE,
  "age_58" DOUBLE,
  "age_59" DOUBLE,
  "age_60" DOUBLE,
  "age_61" DOUBLE,
  "age_62" DOUBLE,
  "age_63" DOUBLE,
  "age_64" DOUBLE,
  "age_65" DOUBLE,
  "age_66" DOUBLE,
  "age_67" DOUBLE,
  "age_68" DOUBLE,
  "age_69" DOUBLE,
  "age_70" DOUBLE,
  "age_71" DOUBLE,
  "age_72" DOUBLE,
  "age_73" DOUBLE,
  "age_74" DOUBLE,
  "age_75" DOUBLE,
  "age_76" DOUBLE,
  "age_77" DOUBLE,
  "age_78" DOUBLE,
  "age_79" DOUBLE,
  "age_80" DOUBLE,
  "age_81" DOUBLE,
  "age_82" DOUBLE,
  "age_83" DOUBLE,
  "age_84" DOUBLE,
  "age_85" DOUBLE,
  "age_86" DOUBLE,
  "age_87" DOUBLE,
  "age_88" DOUBLE,
  "age_89" DOUBLE,
  "age_90" DOUBLE,
  "age_91" DOUBLE,
  "age_92" DOUBLE,
  "age_93" DOUBLE
);