Identifying Ethnicity in OpenSAFELY-TPP

This short report describes how ethnicity can be identified in the OpenSAFELY-TPP database, and the strengths and weaknesses of the methods. This is a living document that will be updated to reflect changes to the OpenSAFELY-TPP database and the patient records within.

OpenSAFELY

OpenSAFELY is an analytics platform for conducting analyses on Electronic Health Records inside the secure environment where the records are held. This has multiple benefits:

  • We don't transport large volumes of potentially disclosive pseudonymised patient data outside of the secure environments for analysis
  • Analyses can run in near real-time as records are ready for analysis as soon as they appear in the secure environment
  • All infrastructure and analysis code is stored in GitHub repositories, which are open for security review, scientific review, and re-use

A key feature of OpenSAFELY is the use of study definitions, which are formal specifications of the datasets to be generated from the OpenSAFELY database. This takes care of much of the complex EHR data wrangling required to create a dataset in an analysis-ready format. It also creates a library of standardised and validated variable definitions that can be deployed consistently across multiple projects.

The purpose of this report is to describe all such variables that relate to BMI, their relative strengths and weaknesses, in what scenarios they are best deployed. It will also describe potential future definitions that have not yet been implemented.

Available Records

OpenSAFELY-TPP runs inside TPP’s data centre which contains the primary care records for all patients registered at practices using TPP’s SystmOne Clinical Information System. This data centre also imports external datasets from other sources, including A&E attendances and hospital admissions from NHS Digital’s Secondary Use Service, and death registrations from the ONS. More information on available data sources can be found within the OpenSAFELY documentation.

Results

Count of Patients

ethnicity_16 ethnicity_new_16 ethnicity_primis_16 all_filled population
group subgroup
all with records 24474735.0 (74.6) 24129590.0 (73.5) 19159630.0 (58.4) 18943015.0 (57.7) 32807505.0
age_band 0-19 3948960.0 (62.5) 3892720.0 (61.6) 2988370.0 (47.3) 2956815.0 (46.8) 6314700.0
20-29 3014255.0 (72.1) 2971670.0 (71.1) 2406685.0 (57.6) 2380180.0 (56.9) 4181455.0
30-39 3967180.0 (81.4) 3903095.0 (80.0) 3193225.0 (65.5) 3152280.0 (64.7) 4875825.0
40-49 3242920.0 (81.4) 3188675.0 (80.0) 2585550.0 (64.9) 2551215.0 (64.0) 3985390.0
50-59 3169745.0 (79.5) 3126855.0 (78.4) 2506200.0 (62.8) 2478290.0 (62.1) 3988210.0
60-69 2578365.0 (79.5) 2547130.0 (78.6) 2025760.0 (62.5) 2005025.0 (61.8) 3242295.0
70-79 2230210.0 (78.9) 2204475.0 (78.0) 1734190.0 (61.4) 1716875.0 (60.8) 2825395.0
80+ 2310790.0 (68.9) 2282770.0 (68.1) 1713295.0 (51.1) 1695985.0 (50.6) 3352430.0
missing 12310.0 (29.4) 12200.0 (29.2) 6360.0 (15.2) 6350.0 (15.2) 41810.0
sex F 12567380.0 (76.2) 12390885.0 (75.2) 9900805.0 (60.1) 9788470.0 (59.4) 16485060.0
M 11907360.0 (73.0) 11738705.0 (71.9) 9258825.0 (56.7) 9154545.0 (56.1) 16322445.0
region East 4354510.0 (75.6) 4294100.0 (74.6) 3380420.0 (58.7) 3344085.0 (58.1) 5758535.0
East Midlands 3262875.0 (76.6) 3208865.0 (75.3) 2507680.0 (58.9) 2472405.0 (58.0) 4260350.0
London 1436215.0 (80.0) 1409285.0 (78.5) 1262330.0 (70.4) 1243690.0 (69.3) 1794330.0
North East 888240.0 (76.1) 881040.0 (75.5) 739970.0 (63.4) 734745.0 (63.0) 1166440.0
North West 1621780.0 (76.0) 1603115.0 (75.1) 1193320.0 (55.9) 1183135.0 (55.4) 2134525.0
South East 1216550.0 (74.0) 1199055.0 (72.9) 939735.0 (57.2) 928370.0 (56.5) 1643790.0
South West 2481280.0 (73.0) 2454175.0 (72.2) 1886215.0 (55.5) 1868945.0 (55.0) 3399525.0
West Midlands 811275.0 (80.2) 794275.0 (78.6) 616410.0 (61.0) 605155.0 (59.9) 1010960.0
Yorkshire and The Humber 2688860.0 (75.7) 2658015.0 (74.8) 2170395.0 (61.1) 2148670.0 (60.5) 3552510.0
imd 1 Most deprived 4918965.0 (76.3) 4836790.0 (75.0) 3899640.0 (60.5) 3850080.0 (59.7) 6450350.0
2 4889880.0 (75.6) 4817165.0 (74.5) 3872780.0 (59.9) 3826505.0 (59.2) 6467650.0
3 5122765.0 (75.2) 5054475.0 (74.2) 4007860.0 (58.8) 3963295.0 (58.2) 6811855.0
4 4647340.0 (74.1) 4585355.0 (73.1) 3618525.0 (57.7) 3578945.0 (57.1) 6270250.0
5 Least deprived 4127870.0 (73.0) 4077950.0 (72.1) 3165520.0 (56.0) 3134720.0 (55.4) 5656380.0
Unknown 767920.0 (66.7) 757855.0 (65.8) 595310.0 (51.7) 589475.0 (51.2) 1151025.0
dementia False 24333695.0 (74.6) 23990845.0 (73.6) 19052375.0 (58.4) 18837280.0 (57.8) 32614480.0
True 141040.0 (73.1) 138745.0 (71.9) 107255.0 (55.6) 105740.0 (54.8) 193025.0
diabetes False 21870490.0 (73.9) 21562400.0 (72.9) 17102235.0 (57.8) 16910840.0 (57.2) 29576355.0
True 2604250.0 (80.6) 2567190.0 (79.5) 2057395.0 (63.7) 2032175.0 (62.9) 3231150.0
hypertension False 22878575.0 (74.1) 22551810.0 (73.0) 17912060.0 (58.0) 17707690.0 (57.3) 30881665.0
True 1596160.0 (82.9) 1577785.0 (81.9) 1247570.0 (64.8) 1235325.0 (64.1) 1925840.0
learning_disability False 24332055.0 (74.6) 23989775.0 (73.5) 19043695.0 (58.4) 18829235.0 (57.7) 32632255.0
True 142680.0 (81.4) 139815.0 (79.8) 115935.0 (66.2) 113780.0 (64.9) 175250.0

Count of Missings

ethnicity_16 ethnicity_new_16 ethnicity_primis_16 all_missing population
group subgroup
all missing records 8332770.0 (25.4) 8677915.0 (26.5) 13647875.0 (41.6) 8332770.0 (25.4) 32807505.0
age_band 0-19 2365740.0 (37.5) 2421980.0 (38.4) 3326330.0 (52.7) 2365740.0 (37.5) 6314700.0
20-29 1167200.0 (27.9) 1209785.0 (28.9) 1774775.0 (42.4) 1167200.0 (27.9) 4181455.0
30-39 908640.0 (18.6) 972730.0 (20.0) 1682600.0 (34.5) 908640.0 (18.6) 4875825.0
40-49 742465.0 (18.6) 796715.0 (20.0) 1399835.0 (35.1) 742465.0 (18.6) 3985390.0
50-59 818470.0 (20.5) 861355.0 (21.6) 1482010.0 (37.2) 818470.0 (20.5) 3988210.0
60-69 663930.0 (20.5) 695165.0 (21.4) 1216535.0 (37.5) 663930.0 (20.5) 3242295.0
70-79 595185.0 (21.1) 620920.0 (22.0) 1091205.0 (38.6) 595185.0 (21.1) 2825395.0
80+ 1041640.0 (31.1) 1069660.0 (31.9) 1639135.0 (48.9) 1041640.0 (31.1) 3352430.0
missing 29495.0 (70.5) 29610.0 (70.8) 35450.0 (84.8) 29495.0 (70.5) 41810.0
sex F 3917680.0 (23.8) 4094175.0 (24.8) 6584255.0 (39.9) 3917680.0 (23.8) 16485060.0
M 4415090.0 (27.0) 4583740.0 (28.1) 7063620.0 (43.3) 4415090.0 (27.0) 16322445.0
region East 1404020.0 (24.4) 1464430.0 (25.4) 2378115.0 (41.3) 1404020.0 (24.4) 5758535.0
East Midlands 997470.0 (23.4) 1051485.0 (24.7) 1752665.0 (41.1) 997470.0 (23.4) 4260350.0
London 358115.0 (20.0) 385045.0 (21.5) 532005.0 (29.6) 358115.0 (20.0) 1794330.0
North East 278200.0 (23.9) 285400.0 (24.5) 426475.0 (36.6) 278200.0 (23.9) 1166440.0
North West 512745.0 (24.0) 531410.0 (24.9) 941205.0 (44.1) 512745.0 (24.0) 2134525.0
South East 427245.0 (26.0) 444735.0 (27.1) 704060.0 (42.8) 427245.0 (26.0) 1643790.0
South West 918245.0 (27.0) 945350.0 (27.8) 1513310.0 (44.5) 918245.0 (27.0) 3399525.0
West Midlands 199685.0 (19.8) 216685.0 (21.4) 394550.0 (39.0) 199685.0 (19.8) 1010960.0
Yorkshire and The Humber 863655.0 (24.3) 894500.0 (25.2) 1382115.0 (38.9) 863655.0 (24.3) 3552510.0
imd 1 Most deprived 1531390.0 (23.7) 1613560.0 (25.0) 2550710.0 (39.5) 1531390.0 (23.7) 6450350.0
2 1577770.0 (24.4) 1650485.0 (25.5) 2594870.0 (40.1) 1577770.0 (24.4) 6467650.0
3 1689090.0 (24.8) 1757380.0 (25.8) 2804000.0 (41.2) 1689090.0 (24.8) 6811855.0
4 1622910.0 (25.9) 1684890.0 (26.9) 2651725.0 (42.3) 1622910.0 (25.9) 6270250.0
5 Least deprived 1528510.0 (27.0) 1578430.0 (27.9) 2490860.0 (44.0) 1528510.0 (27.0) 5656380.0
Unknown 383105.0 (33.3) 393170.0 (34.2) 555715.0 (48.3) 383105.0 (33.3) 1151025.0
dementia False 8280780.0 (25.4) 8623630.0 (26.4) 13562105.0 (41.6) 8280780.0 (25.4) 32614480.0
True 51985.0 (26.9) 54280.0 (28.1) 85770.0 (44.4) 51985.0 (26.9) 193025.0
diabetes False 7705865.0 (26.1) 8013955.0 (27.1) 12474120.0 (42.2) 7705865.0 (26.1) 29576355.0
True 626905.0 (19.4) 663960.0 (20.5) 1173755.0 (36.3) 626905.0 (19.4) 3231150.0
hypertension False 8003090.0 (25.9) 8329855.0 (27.0) 12969605.0 (42.0) 8003090.0 (25.9) 30881665.0
True 329680.0 (17.1) 348060.0 (18.1) 678270.0 (35.2) 329680.0 (17.1) 1925840.0
learning_disability False 8300200.0 (25.4) 8642480.0 (26.5) 13588560.0 (41.6) 8300200.0 (25.4) 32632255.0
True 32570.0 (18.6) 35435.0 (20.2) 59315.0 (33.8) 32570.0 (18.6) 175250.0

Count by Category

ethnicity_16_African ethnicity_new_16_African ethnicity_primis_16_African ethnicity_16_Any_other_ethnic_group ethnicity_new_16_Any_other_ethnic_group ethnicity_primis_16_Any_other_ethnic_group ethnicity_16_Bangladeshi ethnicity_new_16_Bangladeshi ethnicity_primis_16_Bangladeshi ethnicity_16_Caribbean ethnicity_new_16_Caribbean ethnicity_primis_16_Caribbean ethnicity_16_Chinese ethnicity_new_16_Chinese ethnicity_primis_16_Chinese ethnicity_16_Indian ethnicity_new_16_Indian ethnicity_primis_16_Indian ethnicity_16_Other_Asian ethnicity_new_16_Other_Asian ethnicity_primis_16_Other_Asian ethnicity_16_Other_Black ethnicity_new_16_Other_Black ethnicity_primis_16_Other_Black ethnicity_16_Other_Mixed ethnicity_new_16_Other_Mixed ethnicity_primis_16_Other_Mixed ethnicity_16_Other_White ethnicity_new_16_Other_White ethnicity_primis_16_Other_White ethnicity_16_Pakistani ethnicity_new_16_Pakistani ethnicity_primis_16_Pakistani ethnicity_16_White_British ethnicity_new_16_White_British ethnicity_primis_16_White_British ethnicity_16_White_Irish ethnicity_new_16_White_Irish ethnicity_primis_16_White_Irish ethnicity_16_White_and_Asian ethnicity_new_16_White_and_Asian ethnicity_primis_16_White_and_Asian ethnicity_16_White_and_Black_African ethnicity_new_16_White_and_Black_African ethnicity_primis_16_White_and_Black_African ethnicity_16_White_and_Black_Caribbean ethnicity_new_16_White_and_Black_Caribbean ethnicity_primis_16_White_and_Black_Caribbean all_filled population
group subgroup
all with records 462975.0 (1.4) 495065.0 (1.5) 400755.0 (1.2) 547375.0 (1.7) 411605.0 (1.3) 426520.0 (1.3) 147920.0 (0.5) 146470.0 (0.4) 126265.0 (0.4) 143395.0 (0.4) 144930.0 (0.4) 112850.0 (0.3) 286085.0 (0.9) 285040.0 (0.9) 250100.0 (0.8) 903480.0 (2.8) 901870.0 (2.7) 773030.0 (2.4) 510855.0 (1.6) 532905.0 (1.6) 441730.0 (1.3) 171320.0 (0.5) 128510.0 (0.4) 93390.0 (0.3) 178655.0 (0.5) 174875.0 (0.5) 149975.0 (0.5) 2806585.0 (8.6) 3103285.0 (9.5) 2162505.0 (6.6) 597280.0 (1.8) 592250.0 (1.8) 533330.0 (1.6) 17269720.0 (52.6) 16768685.0 (51.1) 13283385.0 (40.5) 156470.0 (0.5) 153715.0 (0.5) 127640.0 (0.4) 100350.0 (0.3) 99165.0 (0.3) 93255.0 (0.3) 92720.0 (0.3) 91635.0 (0.3) 92855.0 (0.3) 99555.0 (0.3) 99585.0 (0.3) 92040.0 (0.3) 18943015.0 (57.7) 32807505.0
age_band 0-19 107205.0 (1.7) 115980.0 (1.8) 90005.0 (1.4) 111980.0 (1.8) 86160.0 (1.4) 87070.0 (1.4) 38360.0 (0.6) 38075.0 (0.6) 32600.0 (0.5) 17940.0 (0.3) 18135.0 (0.3) 13415.0 (0.2) 30985.0 (0.5) 30910.0 (0.5) 25885.0 (0.4) 150800.0 (2.4) 150280.0 (2.4) 126235.0 (2.0) 97685.0 (1.5) 101495.0 (1.6) 82680.0 (1.3) 43920.0 (0.7) 33115.0 (0.5) 23485.0 (0.4) 60120.0 (1.0) 58880.0 (0.9) 48255.0 (0.8) 424090.0 (6.7) 459405.0 (7.3) 322280.0 (5.1) 160180.0 (2.5) 159015.0 (2.5) 141465.0 (2.2) 2596240.0 (41.1) 2532700.0 (40.1) 1897705.0 (30.1) 10620.0 (0.2) 10355.0 (0.2) 8515.0 (0.1) 36225.0 (0.6) 35835.0 (0.6) 32140.0 (0.5) 28815.0 (0.5) 28480.0 (0.5) 27010.0 (0.4) 33800.0 (0.5) 33900.0 (0.5) 29615.0 (0.5) 2956815.0 (46.8) 6314700.0
20-29 79605.0 (1.9) 85155.0 (2.0) 69445.0 (1.7) 94650.0 (2.3) 72270.0 (1.7) 74915.0 (1.8) 24015.0 (0.6) 23800.0 (0.6) 20290.0 (0.5) 17970.0 (0.4) 18070.0 (0.4) 13820.0 (0.3) 102125.0 (2.4) 102115.0 (2.4) 92595.0 (2.2) 131480.0 (3.1) 131140.0 (3.1) 109720.0 (2.6) 84895.0 (2.0) 89030.0 (2.1) 73155.0 (1.7) 29030.0 (0.7) 21930.0 (0.5) 16105.0 (0.4) 32415.0 (0.8) 31730.0 (0.8) 27295.0 (0.7) 437480.0 (10.5) 469250.0 (11.2) 357750.0 (8.6) 88715.0 (2.1) 87855.0 (2.1) 78290.0 (1.9) 1819840.0 (43.5) 1767865.0 (42.3) 1406870.0 (33.6) 16440.0 (0.4) 16160.0 (0.4) 13860.0 (0.3) 19815.0 (0.5) 19625.0 (0.5) 18780.0 (0.4) 16000.0 (0.4) 15855.0 (0.4) 15760.0 (0.4) 19780.0 (0.5) 19820.0 (0.5) 18025.0 (0.4) 2380180.0 (56.9) 4181455.0
30-39 97075.0 (2.0) 102915.0 (2.1) 84590.0 (1.7) 133345.0 (2.7) 100275.0 (2.1) 106015.0 (2.2) 32165.0 (0.7) 31815.0 (0.7) 27675.0 (0.6) 21125.0 (0.4) 21255.0 (0.4) 16315.0 (0.3) 75840.0 (1.6) 75280.0 (1.5) 66760.0 (1.4) 222890.0 (4.6) 222465.0 (4.6) 191370.0 (3.9) 122265.0 (2.5) 126895.0 (2.6) 103880.0 (2.1) 30140.0 (0.6) 22470.0 (0.5) 16140.0 (0.3) 36655.0 (0.8) 35905.0 (0.7) 31795.0 (0.7) 756375.0 (15.5) 809400.0 (16.6) 645110.0 (13.2) 123635.0 (2.5) 122530.0 (2.5) 110770.0 (2.3) 2233910.0 (45.8) 2151115.0 (44.1) 1716920.0 (35.2) 27775.0 (0.6) 27250.0 (0.6) 23470.0 (0.5) 18580.0 (0.4) 18365.0 (0.4) 17765.0 (0.4) 17255.0 (0.4) 17060.0 (0.3) 17795.0 (0.4) 18145.0 (0.4) 18110.0 (0.4) 16860.0 (0.3) 3152280.0 (64.7) 4875825.0
40-49 90760.0 (2.3) 96425.0 (2.4) 78805.0 (2.0) 100745.0 (2.5) 74385.0 (1.9) 78755.0 (2.0) 27970.0 (0.7) 27650.0 (0.7) 24045.0 (0.6) 18930.0 (0.5) 19240.0 (0.5) 15015.0 (0.4) 35680.0 (0.9) 35460.0 (0.9) 30125.0 (0.8) 169530.0 (4.3) 168855.0 (4.2) 146560.0 (3.7) 97915.0 (2.5) 103035.0 (2.6) 87100.0 (2.2) 27780.0 (0.7) 20025.0 (0.5) 14900.0 (0.4) 23845.0 (0.6) 23295.0 (0.6) 20740.0 (0.5) 509040.0 (12.8) 547910.0 (13.7) 414995.0 (10.4) 101745.0 (2.6) 100860.0 (2.5) 91520.0 (2.3) 1981245.0 (49.7) 1914615.0 (48.0) 1529180.0 (38.4) 21065.0 (0.5) 20650.0 (0.5) 17210.0 (0.4) 11990.0 (0.3) 11790.0 (0.3) 11405.0 (0.3) 15040.0 (0.4) 14830.0 (0.4) 15960.0 (0.4) 9640.0 (0.2) 9650.0 (0.2) 9235.0 (0.2) 2551215.0 (64.0) 3985390.0
50-59 53950.0 (1.4) 57880.0 (1.5) 47885.0 (1.2) 53995.0 (1.4) 39545.0 (1.0) 40665.0 (1.0) 12820.0 (0.3) 12685.0 (0.3) 11090.0 (0.3) 25855.0 (0.6) 26390.0 (0.7) 21080.0 (0.5) 20220.0 (0.5) 20130.0 (0.5) 17200.0 (0.4) 87425.0 (2.2) 87455.0 (2.2) 76400.0 (1.9) 53620.0 (1.3) 56760.0 (1.4) 48115.0 (1.2) 23555.0 (0.6) 17830.0 (0.4) 13350.0 (0.3) 13440.0 (0.3) 13125.0 (0.3) 11450.0 (0.3) 282895.0 (7.1) 314785.0 (7.9) 201215.0 (5.0) 54695.0 (1.4) 54220.0 (1.4) 49940.0 (1.3) 2441885.0 (61.2) 2381240.0 (59.7) 1926330.0 (48.3) 20230.0 (0.5) 19875.0 (0.5) 16275.0 (0.4) 7235.0 (0.2) 7135.0 (0.2) 6885.0 (0.2) 8965.0 (0.2) 8860.0 (0.2) 9500.0 (0.2) 8960.0 (0.2) 8940.0 (0.2) 8825.0 (0.2) 2478290.0 (62.1) 3988210.0
60-69 21235.0 (0.7) 22625.0 (0.7) 18705.0 (0.6) 27875.0 (0.9) 20640.0 (0.6) 20965.0 (0.6) 6395.0 (0.2) 6335.0 (0.2) 5410.0 (0.2) 17655.0 (0.5) 17935.0 (0.6) 14430.0 (0.4) 12125.0 (0.4) 12065.0 (0.4) 10145.0 (0.3) 67820.0 (2.1) 67925.0 (2.1) 59420.0 (1.8) 28940.0 (0.9) 29810.0 (0.9) 24950.0 (0.8) 10340.0 (0.3) 8055.0 (0.2) 5840.0 (0.2) 6805.0 (0.2) 6675.0 (0.2) 5895.0 (0.2) 175985.0 (5.4) 202850.0 (6.3) 112195.0 (3.5) 33765.0 (1.0) 33490.0 (1.0) 30630.0 (0.9) 2139750.0 (66.0) 2089465.0 (64.4) 1690980.0 (52.2) 17715.0 (0.5) 17440.0 (0.5) 14070.0 (0.4) 3470.0 (0.1) 3430.0 (0.1) 3385.0 (0.1) 3940.0 (0.1) 3880.0 (0.1) 4095.0 (0.1) 4550.0 (0.1) 4515.0 (0.1) 4645.0 (0.1) 2005025.0 (61.8) 3242295.0
70-79 8220.0 (0.3) 8750.0 (0.3) 7115.0 (0.3) 14480.0 (0.5) 10615.0 (0.4) 10630.0 (0.4) 2845.0 (0.1) 2805.0 (0.1) 2425.0 (0.1) 8325.0 (0.3) 8355.0 (0.3) 6660.0 (0.2) 5600.0 (0.2) 5585.0 (0.2) 4600.0 (0.2) 40565.0 (1.4) 40640.0 (1.4) 35420.0 (1.3) 15710.0 (0.6) 16180.0 (0.6) 13550.0 (0.5) 3645.0 (0.1) 2845.0 (0.1) 2045.0 (0.1) 3040.0 (0.1) 2975.0 (0.1) 2620.0 (0.1) 111530.0 (3.9) 139945.0 (5.0) 56765.0 (2.0) 17085.0 (0.6) 16945.0 (0.6) 15380.0 (0.5) 1974390.0 (69.9) 1924395.0 (68.1) 1555990.0 (55.1) 19480.0 (0.7) 19200.0 (0.7) 15685.0 (0.6) 1745.0 (0.1) 1720.0 (0.1) 1655.0 (0.1) 1690.0 (0.1) 1665.0 (0.1) 1720.0 (0.1) 1860.0 (0.1) 1850.0 (0.1) 1935.0 (0.1) 1716875.0 (60.8) 2825395.0
80+ 4665.0 (0.1) 5045.0 (0.2) 4050.0 (0.1) 9980.0 (0.3) 7490.0 (0.2) 7310.0 (0.2) 3225.0 (0.1) 3185.0 (0.1) 2665.0 (0.1) 15560.0 (0.5) 15505.0 (0.5) 12095.0 (0.4) 3475.0 (0.1) 3460.0 (0.1) 2765.0 (0.1) 32600.0 (1.0) 32745.0 (1.0) 27685.0 (0.8) 9600.0 (0.3) 9460.0 (0.3) 8145.0 (0.2) 2785.0 (0.1) 2150.0 (0.1) 1475.0 (0.0) 2115.0 (0.1) 2075.0 (0.1) 1770.0 (0.1) 108240.0 (3.2) 158665.0 (4.7) 51605.0 (1.5) 17000.0 (0.5) 16880.0 (0.5) 15010.0 (0.4) 2073705.0 (61.9) 1998690.0 (59.6) 1555315.0 (46.4) 23115.0 (0.7) 22760.0 (0.7) 18540.0 (0.6) 1140.0 (0.0) 1120.0 (0.0) 1135.0 (0.0) 925.0 (0.0) 915.0 (0.0) 950.0 (0.0) 2650.0 (0.1) 2635.0 (0.1) 2780.0 (0.1) 1695985.0 (50.6) 3352430.0
missing 265.0 (0.6) 290.0 (0.7) 155.0 (0.4) 325.0 (0.8) 220.0 (0.5) 200.0 (0.5) 115.0 (0.3) 115.0 (0.3) 70.0 (0.2) 40.0 (0.1) 45.0 (0.1) 20.0 (0.0) 40.0 (0.1) 40.0 (0.1) 25.0 (0.1) 360.0 (0.9) 360.0 (0.9) 215.0 (0.5) 230.0 (0.6) 235.0 (0.6) 155.0 (0.4) 120.0 (0.3) 90.0 (0.2) 50.0 (0.1) 215.0 (0.5) 215.0 (0.5) 160.0 (0.4) 950.0 (2.3) 1075.0 (2.6) 590.0 (1.4) 455.0 (1.1) 455.0 (1.1) 315.0 (0.8) 8750.0 (20.9) 8610.0 (20.6) 4095.0 (9.8) 25.0 (0.1) 25.0 (0.1) 15.0 (0.0) 150.0 (0.4) 150.0 (0.4) 110.0 (0.3) 95.0 (0.2) 95.0 (0.2) 75.0 (0.2) 165.0 (0.4) 170.0 (0.4) 110.0 (0.3) 6350.0 (15.2) 41810.0
sex F 232365.0 (1.4) 248755.0 (1.5) 202295.0 (1.2) 269230.0 (1.6) 198175.0 (1.2) 205745.0 (1.2) 69995.0 (0.4) 69270.0 (0.4) 59780.0 (0.4) 74645.0 (0.5) 75480.0 (0.5) 59420.0 (0.4) 163200.0 (1.0) 162605.0 (1.0) 143575.0 (0.9) 430070.0 (2.6) 429255.0 (2.6) 369460.0 (2.2) 258835.0 (1.6) 273680.0 (1.7) 227630.0 (1.4) 86615.0 (0.5) 64750.0 (0.4) 47395.0 (0.3) 92030.0 (0.6) 90095.0 (0.5) 77875.0 (0.5) 1468735.0 (8.9) 1619535.0 (9.8) 1146910.0 (7.0) 287640.0 (1.7) 285105.0 (1.7) 257470.0 (1.6) 8903275.0 (54.0) 8645955.0 (52.4) 6893755.0 (41.8) 79905.0 (0.5) 78510.0 (0.5) 65530.0 (0.4) 51545.0 (0.3) 50965.0 (0.3) 48155.0 (0.3) 47050.0 (0.3) 46515.0 (0.3) 47290.0 (0.3) 52250.0 (0.3) 52245.0 (0.3) 48520.0 (0.3) 9788470.0 (59.4) 16485060.0
M 230615.0 (1.4) 246310.0 (1.5) 198460.0 (1.2) 278145.0 (1.7) 213430.0 (1.3) 220775.0 (1.4) 77925.0 (0.5) 77200.0 (0.5) 66485.0 (0.4) 68750.0 (0.4) 69450.0 (0.4) 53425.0 (0.3) 122885.0 (0.8) 122435.0 (0.8) 106525.0 (0.7) 473410.0 (2.9) 472615.0 (2.9) 403570.0 (2.5) 252020.0 (1.5) 259225.0 (1.6) 214100.0 (1.3) 84705.0 (0.5) 63760.0 (0.4) 45995.0 (0.3) 86625.0 (0.5) 84785.0 (0.5) 72100.0 (0.4) 1337845.0 (8.2) 1483750.0 (9.1) 1015595.0 (6.2) 309645.0 (1.9) 307145.0 (1.9) 275855.0 (1.7) 8366445.0 (51.3) 8122730.0 (49.8) 6389630.0 (39.1) 76565.0 (0.5) 75200.0 (0.5) 62115.0 (0.4) 48805.0 (0.3) 48200.0 (0.3) 45100.0 (0.3) 45670.0 (0.3) 45125.0 (0.3) 45570.0 (0.3) 47305.0 (0.3) 47340.0 (0.3) 43520.0 (0.3) 9154545.0 (56.1) 16322445.0
region East 88840.0 (1.5) 92820.0 (1.6) 72255.0 (1.3) 73005.0 (1.3) 50945.0 (0.9) 54870.0 (1.0) 35960.0 (0.6) 35620.0 (0.6) 30155.0 (0.5) 22385.0 (0.4) 22660.0 (0.4) 16945.0 (0.3) 35620.0 (0.6) 35455.0 (0.6) 30220.0 (0.5) 105110.0 (1.8) 104470.0 (1.8) 88265.0 (1.5) 67810.0 (1.2) 71000.0 (1.2) 59025.0 (1.0) 31995.0 (0.6) 26055.0 (0.5) 18165.0 (0.3) 31935.0 (0.6) 31320.0 (0.5) 26470.0 (0.5) 533995.0 (9.3) 608455.0 (10.6) 411130.0 (7.1) 78650.0 (1.4) 77945.0 (1.4) 68385.0 (1.2) 3166320.0 (55.0) 3055345.0 (53.1) 2428950.0 (42.2) 27550.0 (0.5) 27095.0 (0.5) 22145.0 (0.4) 17100.0 (0.3) 16890.0 (0.3) 16055.0 (0.3) 20025.0 (0.3) 19805.0 (0.3) 20525.0 (0.4) 18220.0 (0.3) 18225.0 (0.3) 16855.0 (0.3) 3344085.0 (58.1) 5758535.0
East Midlands 56860.0 (1.3) 61945.0 (1.5) 49455.0 (1.2) 54195.0 (1.3) 40145.0 (0.9) 41130.0 (1.0) 13115.0 (0.3) 13025.0 (0.3) 11245.0 (0.3) 17020.0 (0.4) 17450.0 (0.4) 13055.0 (0.3) 23960.0 (0.6) 23830.0 (0.6) 21160.0 (0.5) 195040.0 (4.6) 194650.0 (4.6) 165700.0 (3.9) 51525.0 (1.2) 52605.0 (1.2) 38530.0 (0.9) 20785.0 (0.5) 14335.0 (0.3) 10080.0 (0.2) 18095.0 (0.4) 17650.0 (0.4) 13885.0 (0.3) 330765.0 (7.8) 349300.0 (8.2) 237835.0 (5.6) 49030.0 (1.2) 48460.0 (1.1) 42610.0 (1.0) 2378710.0 (55.8) 2322300.0 (54.5) 1814725.0 (42.6) 13600.0 (0.3) 13290.0 (0.3) 10795.0 (0.3) 12285.0 (0.3) 12120.0 (0.3) 11290.0 (0.3) 10475.0 (0.2) 10355.0 (0.2) 10520.0 (0.2) 17425.0 (0.4) 17410.0 (0.4) 15670.0 (0.4) 2472405.0 (58.0) 4260350.0
London 65025.0 (3.6) 71625.0 (4.0) 62175.0 (3.5) 106405.0 (5.9) 84645.0 (4.7) 87605.0 (4.9) 17440.0 (1.0) 17290.0 (1.0) 15730.0 (0.9) 27065.0 (1.5) 26945.0 (1.5) 22660.0 (1.3) 41940.0 (2.3) 41935.0 (2.3) 37445.0 (2.1) 167190.0 (9.3) 168045.0 (9.4) 148740.0 (8.3) 117040.0 (6.5) 122165.0 (6.8) 109160.0 (6.1) 28455.0 (1.6) 20290.0 (1.1) 16295.0 (0.9) 30685.0 (1.7) 30100.0 (1.7) 28155.0 (1.6) 386540.0 (21.5) 390470.0 (21.8) 341305.0 (19.0) 50210.0 (2.8) 49790.0 (2.8) 44420.0 (2.5) 348315.0 (19.4) 336760.0 (18.8) 302790.0 (16.9) 21850.0 (1.2) 21445.0 (1.2) 19230.0 (1.1) 10875.0 (0.6) 10745.0 (0.6) 10020.0 (0.6) 8510.0 (0.5) 8390.0 (0.5) 8330.0 (0.5) 8660.0 (0.5) 8645.0 (0.5) 8265.0 (0.5) 1243690.0 (69.3) 1794330.0
North East 13365.0 (1.1) 14340.0 (1.2) 12545.0 (1.1) 16080.0 (1.4) 13270.0 (1.1) 14215.0 (1.2) 2500.0 (0.2) 2490.0 (0.2) 2215.0 (0.2) 2495.0 (0.2) 2560.0 (0.2) 2095.0 (0.2) 6430.0 (0.6) 6420.0 (0.6) 5920.0 (0.5) 8415.0 (0.7) 8395.0 (0.7) 7325.0 (0.6) 11145.0 (1.0) 11330.0 (1.0) 9945.0 (0.9) 3580.0 (0.3) 2415.0 (0.2) 1940.0 (0.2) 4110.0 (0.4) 3965.0 (0.3) 3335.0 (0.3) 63530.0 (5.4) 64670.0 (5.5) 43010.0 (3.7) 24850.0 (2.1) 24760.0 (2.1) 22460.0 (1.9) 720380.0 (61.8) 715065.0 (61.3) 604275.0 (51.8) 2580.0 (0.2) 2545.0 (0.2) 2180.0 (0.2) 2900.0 (0.2) 2880.0 (0.2) 2955.0 (0.3) 2685.0 (0.2) 2665.0 (0.2) 2675.0 (0.2) 3205.0 (0.3) 3280.0 (0.3) 2875.0 (0.2) 734745.0 (63.0) 1166440.0
North West 12035.0 (0.6) 12725.0 (0.6) 9770.0 (0.5) 17060.0 (0.8) 12795.0 (0.6) 12915.0 (0.6) 6625.0 (0.3) 6575.0 (0.3) 5100.0 (0.2) 1065.0 (0.0) 1095.0 (0.1) 745.0 (0.0) 9250.0 (0.4) 9265.0 (0.4) 7255.0 (0.3) 22110.0 (1.0) 21965.0 (1.0) 17730.0 (0.8) 15790.0 (0.7) 16480.0 (0.8) 12110.0 (0.6) 3665.0 (0.2) 2775.0 (0.1) 1770.0 (0.1) 5485.0 (0.3) 5385.0 (0.3) 4645.0 (0.2) 85410.0 (4.0) 98260.0 (4.6) 42355.0 (2.0) 20490.0 (1.0) 20325.0 (1.0) 15915.0 (0.7) 1409500.0 (66.0) 1382310.0 (64.8) 1051830.0 (49.3) 5075.0 (0.2) 5025.0 (0.2) 3475.0 (0.2) 3850.0 (0.2) 3795.0 (0.2) 3505.0 (0.2) 2915.0 (0.1) 2885.0 (0.1) 2895.0 (0.1) 1445.0 (0.1) 1460.0 (0.1) 1305.0 (0.1) 1183135.0 (55.4) 2134525.0
South East 14735.0 (0.9) 15425.0 (0.9) 12225.0 (0.7) 25480.0 (1.6) 18950.0 (1.2) 19360.0 (1.2) 7250.0 (0.4) 7195.0 (0.4) 6220.0 (0.4) 2510.0 (0.2) 2645.0 (0.2) 1975.0 (0.1) 9800.0 (0.6) 9690.0 (0.6) 8350.0 (0.5) 20980.0 (1.3) 20855.0 (1.3) 17275.0 (1.1) 18340.0 (1.1) 19850.0 (1.2) 16310.0 (1.0) 5630.0 (0.3) 4455.0 (0.3) 3340.0 (0.2) 9545.0 (0.6) 9355.0 (0.6) 7525.0 (0.5) 125500.0 (7.6) 152960.0 (9.3) 101070.0 (6.1) 9080.0 (0.6) 9025.0 (0.5) 7640.0 (0.5) 947040.0 (57.6) 908205.0 (55.3) 720010.0 (43.8) 7360.0 (0.4) 7235.0 (0.4) 5870.0 (0.4) 5565.0 (0.3) 5510.0 (0.3) 5125.0 (0.3) 4545.0 (0.3) 4495.0 (0.3) 4560.0 (0.3) 3185.0 (0.2) 3190.0 (0.2) 2880.0 (0.2) 928370.0 (56.5) 1643790.0
South West 13330.0 (0.4) 14085.0 (0.4) 11395.0 (0.3) 27380.0 (0.8) 19295.0 (0.6) 20290.0 (0.6) 4765.0 (0.1) 4720.0 (0.1) 3970.0 (0.1) 3975.0 (0.1) 4130.0 (0.1) 3005.0 (0.1) 14300.0 (0.4) 14230.0 (0.4) 12050.0 (0.4) 31575.0 (0.9) 31385.0 (0.9) 27275.0 (0.8) 23940.0 (0.7) 25470.0 (0.7) 20090.0 (0.6) 6230.0 (0.2) 5020.0 (0.1) 3655.0 (0.1) 11660.0 (0.3) 11380.0 (0.3) 9800.0 (0.3) 199180.0 (5.9) 245650.0 (7.2) 144315.0 (4.2) 4555.0 (0.1) 4515.0 (0.1) 3865.0 (0.1) 2110845.0 (62.1) 2045130.0 (60.2) 1600355.0 (47.1) 10375.0 (0.3) 10180.0 (0.3) 8180.0 (0.2) 7770.0 (0.2) 7645.0 (0.2) 7300.0 (0.2) 5385.0 (0.2) 5335.0 (0.2) 5155.0 (0.2) 6020.0 (0.2) 6000.0 (0.2) 5520.0 (0.2) 1868945.0 (55.0) 3399525.0
West Midlands 25810.0 (2.6) 29885.0 (3.0) 24630.0 (2.4) 19950.0 (2.0) 15025.0 (1.5) 13700.0 (1.4) 14720.0 (1.5) 14420.0 (1.4) 12235.0 (1.2) 21340.0 (2.1) 21960.0 (2.2) 16890.0 (1.7) 10475.0 (1.0) 10280.0 (1.0) 9550.0 (0.9) 62175.0 (6.2) 61745.0 (6.1) 50465.0 (5.0) 22180.0 (2.2) 22055.0 (2.2) 18495.0 (1.8) 16455.0 (1.6) 10615.0 (1.0) 7145.0 (0.7) 8245.0 (0.8) 7995.0 (0.8) 6310.0 (0.6) 72925.0 (7.2) 68705.0 (6.8) 44795.0 (4.4) 67370.0 (6.7) 66275.0 (6.6) 58460.0 (5.8) 443530.0 (43.9) 439580.0 (43.5) 330865.0 (32.7) 6335.0 (0.6) 6155.0 (0.6) 4745.0 (0.5) 5115.0 (0.5) 5035.0 (0.5) 4545.0 (0.4) 3675.0 (0.4) 3620.0 (0.4) 3705.0 (0.4) 10975.0 (1.1) 10930.0 (1.1) 9875.0 (1.0) 605155.0 (59.9) 1010960.0
Yorkshire and The Humber 39375.0 (1.1) 40910.0 (1.2) 33685.0 (0.9) 42860.0 (1.2) 32325.0 (0.9) 35020.0 (1.0) 14915.0 (0.4) 14775.0 (0.4) 13420.0 (0.4) 8815.0 (0.2) 8890.0 (0.3) 7370.0 (0.2) 14150.0 (0.4) 14095.0 (0.4) 12325.0 (0.3) 52815.0 (1.5) 52605.0 (1.5) 49485.0 (1.4) 34755.0 (1.0) 36170.0 (1.0) 28480.0 (0.8) 12085.0 (0.3) 9980.0 (0.3) 7670.0 (0.2) 11805.0 (0.3) 11600.0 (0.3) 9835.0 (0.3) 205055.0 (5.8) 224445.0 (6.3) 156645.0 (4.4) 183740.0 (5.2) 182705.0 (5.1) 174365.0 (4.9) 2032585.0 (57.2) 1994020.0 (56.1) 1609085.0 (45.3) 9465.0 (0.3) 9305.0 (0.3) 7765.0 (0.2) 9230.0 (0.3) 9135.0 (0.3) 8465.0 (0.2) 8640.0 (0.2) 8510.0 (0.2) 8705.0 (0.2) 8570.0 (0.2) 8545.0 (0.2) 8080.0 (0.2) 2148670.0 (60.5) 3552510.0
imd 1 Most deprived 178950.0 (2.8) 194275.0 (3.0) 158750.0 (2.5) 159515.0 (2.5) 120560.0 (1.9) 126815.0 (2.0) 64170.0 (1.0) 63460.0 (1.0) 55160.0 (0.9) 54825.0 (0.8) 55405.0 (0.9) 43655.0 (0.7) 40735.0 (0.6) 40425.0 (0.6) 35265.0 (0.5) 177355.0 (2.7) 176825.0 (2.7) 151900.0 (2.4) 126030.0 (2.0) 130240.0 (2.0) 103690.0 (1.6) 64095.0 (1.0) 44675.0 (0.7) 32250.0 (0.5) 43010.0 (0.7) 42000.0 (0.7) 35530.0 (0.6) 667430.0 (10.3) 705455.0 (10.9) 514685.0 (8.0) 297515.0 (4.6) 294990.0 (4.6) 270560.0 (4.2) 2936095.0 (45.5) 2860300.0 (44.3) 2270930.0 (35.2) 27245.0 (0.4) 26710.0 (0.4) 22245.0 (0.3) 21385.0 (0.3) 21105.0 (0.3) 19765.0 (0.3) 28745.0 (0.4) 28460.0 (0.4) 29055.0 (0.5) 31855.0 (0.5) 31905.0 (0.5) 29390.0 (0.5) 3850080.0 (59.7) 6450350.0
2 112825.0 (1.7) 120925.0 (1.9) 98700.0 (1.5) 129145.0 (2.0) 97260.0 (1.5) 101595.0 (1.6) 38325.0 (0.6) 37995.0 (0.6) 32670.0 (0.5) 36035.0 (0.6) 36400.0 (0.6) 28485.0 (0.4) 66390.0 (1.0) 66100.0 (1.0) 59015.0 (0.9) 272730.0 (4.2) 273090.0 (4.2) 235805.0 (3.6) 134005.0 (2.1) 138810.0 (2.1) 117250.0 (1.8) 42785.0 (0.7) 32050.0 (0.5) 23165.0 (0.4) 40125.0 (0.6) 39260.0 (0.6) 34170.0 (0.5) 664945.0 (10.3) 703085.0 (10.9) 518635.0 (8.0) 138965.0 (2.1) 137875.0 (2.1) 123585.0 (1.9) 3117795.0 (48.2) 3039585.0 (47.0) 2411960.0 (37.3) 32340.0 (0.5) 31725.0 (0.5) 26770.0 (0.4) 19950.0 (0.3) 19725.0 (0.3) 18815.0 (0.3) 21045.0 (0.3) 20810.0 (0.3) 21185.0 (0.3) 22475.0 (0.3) 22470.0 (0.3) 20980.0 (0.3) 3826505.0 (59.2) 6467650.0
3 71870.0 (1.1) 75280.0 (1.1) 60905.0 (0.9) 100985.0 (1.5) 76700.0 (1.1) 78915.0 (1.2) 23025.0 (0.3) 22815.0 (0.3) 19540.0 (0.3) 25685.0 (0.4) 25920.0 (0.4) 20055.0 (0.3) 63075.0 (0.9) 62885.0 (0.9) 55795.0 (0.8) 199020.0 (2.9) 198975.0 (2.9) 172880.0 (2.5) 109070.0 (1.6) 113105.0 (1.7) 96325.0 (1.4) 26950.0 (0.4) 21920.0 (0.3) 16375.0 (0.2) 35825.0 (0.5) 35070.0 (0.5) 30220.0 (0.4) 592470.0 (8.7) 662085.0 (9.7) 462635.0 (6.8) 78385.0 (1.2) 77750.0 (1.1) 67900.0 (1.0) 3705820.0 (54.4) 3592435.0 (52.7) 2845195.0 (41.8) 35200.0 (0.5) 34645.0 (0.5) 28740.0 (0.4) 20130.0 (0.3) 19885.0 (0.3) 18575.0 (0.3) 16745.0 (0.2) 16520.0 (0.2) 16650.0 (0.2) 18505.0 (0.3) 18500.0 (0.3) 17155.0 (0.3) 3963295.0 (58.2) 6811855.0
4 45000.0 (0.7) 46660.0 (0.7) 37395.0 (0.6) 79415.0 (1.3) 59850.0 (1.0) 61325.0 (1.0) 10835.0 (0.2) 10725.0 (0.2) 9265.0 (0.1) 14455.0 (0.2) 14600.0 (0.2) 11205.0 (0.2) 54070.0 (0.9) 53935.0 (0.9) 47255.0 (0.8) 119280.0 (1.9) 118660.0 (1.9) 100885.0 (1.6) 71240.0 (1.1) 75600.0 (1.2) 63630.0 (1.0) 17460.0 (0.3) 14605.0 (0.2) 10800.0 (0.2) 29540.0 (0.5) 28970.0 (0.5) 25145.0 (0.4) 478570.0 (7.6) 541335.0 (8.6) 363600.0 (5.8) 40230.0 (0.6) 39795.0 (0.6) 34895.0 (0.6) 3611195.0 (57.6) 3505565.0 (55.9) 2785270.0 (44.4) 32145.0 (0.5) 31555.0 (0.5) 26065.0 (0.4) 18265.0 (0.3) 18040.0 (0.3) 17045.0 (0.3) 12460.0 (0.2) 12290.0 (0.2) 12490.0 (0.2) 13180.0 (0.2) 13175.0 (0.2) 12245.0 (0.2) 3578945.0 (57.1) 6270250.0
5 Least deprived 28210.0 (0.5) 29260.0 (0.5) 23110.0 (0.4) 54475.0 (1.0) 39140.0 (0.7) 39410.0 (0.7) 6305.0 (0.1) 6245.0 (0.1) 5295.0 (0.1) 8595.0 (0.2) 8720.0 (0.2) 6465.0 (0.1) 44660.0 (0.8) 44520.0 (0.8) 37860.0 (0.7) 92560.0 (1.6) 91865.0 (1.6) 76755.0 (1.4) 49450.0 (0.9) 52935.0 (0.9) 43780.0 (0.8) 11575.0 (0.2) 9730.0 (0.2) 6970.0 (0.1) 23310.0 (0.4) 22855.0 (0.4) 19230.0 (0.3) 318700.0 (5.6) 400120.0 (7.1) 237065.0 (4.2) 24260.0 (0.4) 24000.0 (0.4) 20780.0 (0.4) 3404930.0 (60.2) 3288410.0 (58.1) 2595155.0 (45.9) 25460.0 (0.5) 25080.0 (0.4) 20455.0 (0.4) 16580.0 (0.3) 16395.0 (0.3) 15355.0 (0.3) 9035.0 (0.2) 8920.0 (0.2) 8875.0 (0.2) 9765.0 (0.2) 9755.0 (0.2) 8955.0 (0.2) 3134720.0 (55.4) 5656380.0
Unknown 26125.0 (2.3) 28665.0 (2.5) 21895.0 (1.9) 23840.0 (2.1) 18095.0 (1.6) 18460.0 (1.6) 5260.0 (0.5) 5230.0 (0.5) 4335.0 (0.4) 3795.0 (0.3) 3885.0 (0.3) 2975.0 (0.3) 17150.0 (1.5) 17180.0 (1.5) 14915.0 (1.3) 42540.0 (3.7) 42455.0 (3.7) 34805.0 (3.0) 21060.0 (1.8) 22220.0 (1.9) 17055.0 (1.5) 8450.0 (0.7) 5530.0 (0.5) 3830.0 (0.3) 6840.0 (0.6) 6725.0 (0.6) 5680.0 (0.5) 84470.0 (7.3) 91205.0 (7.9) 65880.0 (5.7) 17925.0 (1.6) 17840.0 (1.5) 15615.0 (1.4) 493885.0 (42.9) 482390.0 (41.9) 374875.0 (32.6) 4075.0 (0.4) 4000.0 (0.3) 3365.0 (0.3) 4040.0 (0.4) 4015.0 (0.3) 3710.0 (0.3) 4685.0 (0.4) 4640.0 (0.4) 4595.0 (0.4) 3775.0 (0.3) 3780.0 (0.3) 3320.0 (0.3) 589475.0 (51.2) 1151025.0
dementia False 462675.0 (1.4) 494750.0 (1.5) 400495.0 (1.2) 546795.0 (1.7) 411190.0 (1.3) 426080.0 (1.3) 147670.0 (0.5) 146220.0 (0.4) 126035.0 (0.4) 142150.0 (0.4) 143695.0 (0.4) 111835.0 (0.3) 285950.0 (0.9) 284910.0 (0.9) 249995.0 (0.8) 901885.0 (2.8) 900270.0 (2.8) 771620.0 (2.4) 510370.0 (1.6) 532440.0 (1.6) 441320.0 (1.4) 171095.0 (0.5) 128325.0 (0.4) 93265.0 (0.3) 178550.0 (0.5) 174775.0 (0.5) 149880.0 (0.5) 2800205.0 (8.6) 3094215.0 (9.5) 2159400.0 (6.6) 596320.0 (1.8) 591295.0 (1.8) 532465.0 (1.6) 17142895.0 (52.6) 16646585.0 (51.0) 13185870.0 (40.4) 154830.0 (0.5) 152115.0 (0.5) 126290.0 (0.4) 100280.0 (0.3) 99095.0 (0.3) 93185.0 (0.3) 92660.0 (0.3) 91580.0 (0.3) 92800.0 (0.3) 99355.0 (0.3) 99390.0 (0.3) 91835.0 (0.3) 18837280.0 (57.8) 32614480.0
True 300.0 (0.2) 315.0 (0.2) 260.0 (0.1) 580.0 (0.3) 415.0 (0.2) 435.0 (0.2) 250.0 (0.1) 250.0 (0.1) 225.0 (0.1) 1245.0 (0.6) 1230.0 (0.6) 1010.0 (0.5) 135.0 (0.1) 130.0 (0.1) 110.0 (0.1) 1595.0 (0.8) 1600.0 (0.8) 1410.0 (0.7) 480.0 (0.2) 465.0 (0.2) 410.0 (0.2) 225.0 (0.1) 185.0 (0.1) 125.0 (0.1) 105.0 (0.1) 100.0 (0.1) 95.0 (0.0) 6380.0 (3.3) 9070.0 (4.7) 3105.0 (1.6) 960.0 (0.5) 955.0 (0.5) 865.0 (0.4) 126825.0 (65.7) 122100.0 (63.3) 97510.0 (50.5) 1640.0 (0.8) 1600.0 (0.8) 1350.0 (0.7) 70.0 (0.0) 70.0 (0.0) 70.0 (0.0) 55.0 (0.0) 55.0 (0.0) 60.0 (0.0) 200.0 (0.1) 200.0 (0.1) 205.0 (0.1) 105740.0 (54.8) 193025.0
diabetes False 420630.0 (1.4) 449440.0 (1.5) 361485.0 (1.2) 507710.0 (1.7) 382770.0 (1.3) 396320.0 (1.3) 121650.0 (0.4) 120495.0 (0.4) 103470.0 (0.3) 112965.0 (0.4) 114295.0 (0.4) 87855.0 (0.3) 275300.0 (0.9) 274330.0 (0.9) 241000.0 (0.8) 761615.0 (2.6) 759800.0 (2.6) 647125.0 (2.2) 449680.0 (1.5) 470830.0 (1.6) 388520.0 (1.3) 154360.0 (0.5) 116155.0 (0.4) 84615.0 (0.3) 168980.0 (0.6) 165425.0 (0.6) 141495.0 (0.5) 2649005.0 (9.0) 2908735.0 (9.8) 2061510.0 (7.0) 502650.0 (1.7) 498460.0 (1.7) 446835.0 (1.5) 15334110.0 (51.8) 14894335.0 (50.4) 11770570.0 (39.8) 138450.0 (0.5) 135990.0 (0.5) 112760.0 (0.4) 94760.0 (0.3) 93655.0 (0.3) 87880.0 (0.3) 86630.0 (0.3) 85615.0 (0.3) 86415.0 (0.3) 92000.0 (0.3) 92065.0 (0.3) 84375.0 (0.3) 16910840.0 (57.2) 29576355.0
True 42345.0 (1.3) 45625.0 (1.4) 39270.0 (1.2) 39665.0 (1.2) 28830.0 (0.9) 30200.0 (0.9) 26270.0 (0.8) 25975.0 (0.8) 22795.0 (0.7) 30430.0 (0.9) 30630.0 (0.9) 24995.0 (0.8) 10785.0 (0.3) 10715.0 (0.3) 9105.0 (0.3) 141865.0 (4.4) 142070.0 (4.4) 125905.0 (3.9) 61175.0 (1.9) 62075.0 (1.9) 53210.0 (1.6) 16960.0 (0.5) 12355.0 (0.4) 8775.0 (0.3) 9680.0 (0.3) 9455.0 (0.3) 8480.0 (0.3) 157580.0 (4.9) 194550.0 (6.0) 100995.0 (3.1) 94635.0 (2.9) 93790.0 (2.9) 86490.0 (2.7) 1935610.0 (59.9) 1874350.0 (58.0) 1512815.0 (46.8) 18020.0 (0.6) 17720.0 (0.5) 14880.0 (0.5) 5590.0 (0.2) 5510.0 (0.2) 5375.0 (0.2) 6090.0 (0.2) 6020.0 (0.2) 6440.0 (0.2) 7555.0 (0.2) 7520.0 (0.2) 7665.0 (0.2) 2032175.0 (62.9) 3231150.0
hypertension False 445355.0 (1.4) 476270.0 (1.5) 385260.0 (1.2) 534665.0 (1.7) 402675.0 (1.3) 417185.0 (1.4) 142500.0 (0.5) 141115.0 (0.5) 121590.0 (0.4) 132085.0 (0.4) 133470.0 (0.4) 103670.0 (0.3) 281905.0 (0.9) 280885.0 (0.9) 246645.0 (0.8) 869820.0 (2.8) 868175.0 (2.8) 743460.0 (2.4) 495320.0 (1.6) 516740.0 (1.7) 428415.0 (1.4) 163950.0 (0.5) 122940.0 (0.4) 89365.0 (0.3) 175230.0 (0.6) 171530.0 (0.6) 147025.0 (0.5) 2713640.0 (8.8) 2996170.0 (9.7) 2107680.0 (6.8) 575395.0 (1.9) 570555.0 (1.8) 513240.0 (1.7) 15917310.0 (51.5) 15444680.0 (50.0) 12218460.0 (39.6) 146435.0 (0.5) 143815.0 (0.5) 119835.0 (0.4) 98525.0 (0.3) 97355.0 (0.3) 91510.0 (0.3) 89940.0 (0.3) 88890.0 (0.3) 89805.0 (0.3) 96500.0 (0.3) 96550.0 (0.3) 88925.0 (0.3) 17707690.0 (57.3) 30881665.0
True 17620.0 (0.9) 18795.0 (1.0) 15500.0 (0.8) 12710.0 (0.7) 8930.0 (0.5) 9335.0 (0.5) 5420.0 (0.3) 5355.0 (0.3) 4675.0 (0.2) 11310.0 (0.6) 11455.0 (0.6) 9175.0 (0.5) 4175.0 (0.2) 4160.0 (0.2) 3460.0 (0.2) 33660.0 (1.7) 33700.0 (1.7) 29570.0 (1.5) 15535.0 (0.8) 16170.0 (0.8) 13315.0 (0.7) 7370.0 (0.4) 5570.0 (0.3) 4025.0 (0.2) 3430.0 (0.2) 3345.0 (0.2) 2950.0 (0.2) 92940.0 (4.8) 107115.0 (5.6) 54825.0 (2.8) 21890.0 (1.1) 21700.0 (1.1) 20090.0 (1.0) 1352410.0 (70.2) 1324005.0 (68.7) 1064920.0 (55.3) 10035.0 (0.5) 9895.0 (0.5) 7810.0 (0.4) 1825.0 (0.1) 1810.0 (0.1) 1745.0 (0.1) 2775.0 (0.1) 2750.0 (0.1) 3055.0 (0.2) 3055.0 (0.2) 3035.0 (0.2) 3115.0 (0.2) 1235325.0 (64.1) 1925840.0
learning_disability False 461705.0 (1.4) 493665.0 (1.5) 399580.0 (1.2) 546115.0 (1.7) 410690.0 (1.3) 425565.0 (1.3) 147150.0 (0.5) 145710.0 (0.4) 125590.0 (0.4) 142420.0 (0.4) 143950.0 (0.4) 112010.0 (0.3) 285850.0 (0.9) 284815.0 (0.9) 249905.0 (0.8) 900995.0 (2.8) 899420.0 (2.8) 770760.0 (2.4) 509330.0 (1.6) 531380.0 (1.6) 440555.0 (1.4) 170340.0 (0.5) 127715.0 (0.4) 92860.0 (0.3) 177855.0 (0.5) 174100.0 (0.5) 149295.0 (0.5) 2800495.0 (8.6) 3095245.0 (9.5) 2159160.0 (6.6) 592820.0 (1.8) 587845.0 (1.8) 529180.0 (1.6) 17149840.0 (52.6) 16653065.0 (51.0) 13185210.0 (40.4) 155955.0 (0.5) 153210.0 (0.5) 127220.0 (0.4) 99955.0 (0.3) 98780.0 (0.3) 92895.0 (0.3) 92385.0 (0.3) 91310.0 (0.3) 92535.0 (0.3) 98850.0 (0.3) 98885.0 (0.3) 91370.0 (0.3) 18829235.0 (57.7) 32632255.0
True 1275.0 (0.7) 1400.0 (0.8) 1180.0 (0.7) 1260.0 (0.7) 910.0 (0.5) 950.0 (0.5) 770.0 (0.4) 760.0 (0.4) 675.0 (0.4) 970.0 (0.6) 980.0 (0.6) 840.0 (0.5) 230.0 (0.1) 230.0 (0.1) 195.0 (0.1) 2485.0 (1.4) 2450.0 (1.4) 2270.0 (1.3) 1520.0 (0.9) 1525.0 (0.9) 1175.0 (0.7) 980.0 (0.6) 795.0 (0.5) 530.0 (0.3) 805.0 (0.5) 780.0 (0.4) 680.0 (0.4) 6090.0 (3.5) 8040.0 (4.6) 3345.0 (1.9) 4465.0 (2.5) 4405.0 (2.5) 4150.0 (2.4) 119880.0 (68.4) 115620.0 (66.0) 98170.0 (56.0) 515.0 (0.3) 505.0 (0.3) 420.0 (0.2) 395.0 (0.2) 385.0 (0.2) 360.0 (0.2) 335.0 (0.2) 330.0 (0.2) 320.0 (0.2) 705.0 (0.4) 705.0 (0.4) 670.0 (0.4) 113780.0 (64.9) 175250.0

Overlapping Definitions

Idea: Use an upset plot

Latest vs. Most Common

matching (n=24093590.0) not_matching (n=1396310.0)
ethnicity_16
African 453220.0 55365.0
Any_other_ethnic_group 504845.0 147830.0
Bangladeshi 146340.0 8590.0
Caribbean 137775.0 25465.0
Chinese 284485.0 9055.0
Indian 894075.0 47405.0
Other_Asian 477225.0 112910.0
Other_Black 152000.0 62760.0
Other_Mixed 162955.0 58010.0
Other_White 2684930.0 360110.0
Pakistani 591150.0 30340.0
White_British 17194385.0 349440.0
White_Irish 143990.0 34000.0
White_and_Asian 91930.0 31020.0
White_and_Black_African 83350.0 32555.0
White_and_Black_Caribbean 90935.0 31455.0
African (n=522990.0) Any_other_ethnic_group (n=635060.0) Bangladeshi (n=156620.0) Caribbean (n=167705.0) Chinese (n=300100.0) Indian (n=956460.0) Other_Asian (n=572265.0) Other_Black (n=198670.0) Other_Mixed (n=219305.0) Other_White (n=3023260.0) Pakistani (n=626285.0) White_British (n=17603600.0) White_Irish (n=169155.0) White_and_Asian (n=117285.0) White_and_Black_African (n=108845.0) White_and_Black_Caribbean (n=112295.0)
ethnicity_16
African 453220 6465 70 2790 55 895 1645 19800 2410 3215 335 5880 190 160 10690 765.0
Any_other_ethnic_group 6550 504845 805 1210 3080 6105 29165 3250 9120 56040 3205 22255 395 3775 1845 1030.0
Bangladeshi 75 735 146340 15 40 1140 2490 90 195 270 1960 1325 10 235 10 -
Caribbean 2650 960 15 137775 30 255 265 7415 1345 715 30 6405 20 30 455 4875.0
Chinese 40 2055 20 20 284485 65 3125 50 875 585 30 1695 15 455 15 10.0
Indian 780 4390 1215 240 125 894075 22430 550 1510 1345 5610 6820 90 2120 110 70.0
Other_Asian 1785 28910 3750 400 6050 33335 477225 1435 4500 5770 14905 6535 60 5075 280 120.0
Other_Black 29135 3545 105 9455 90 595 1300 152000 2445 1845 270 8060 90 130 3400 2295.0
Other_Mixed 2100 8750 255 1145 2085 1570 4735 1750 162955 12725 870 14095 190 2935 1920 2885.0
Other_White 3160 45575 525 710 840 2165 5630 1520 11395 2684930 1315 277275 3700 3110 1905 1285.0
Pakistani 280 2660 1720 45 155 5745 12040 380 930 890 591150 4255 35 1120 55 30.0
White_British 6540 18945 1450 5720 2120 7340 5985 4795 11715 243250 4895 17194385 20225 5920 3640 6900.0
White_Irish 140 345 10 30 15 80 60 75 125 4210 35 28740 143990 50 55 30.0
White_and_Asian 185 3940 310 45 900 2860 5695 170 3010 3305 1590 8745 50 91930 150 65.0
White_and_Black_African 15200 1900 20 715 10 150 335 3015 2475 2490 60 4980 60 145 83350 1000.0
White_and_Black_Caribbean 1150 1040 10 7390 20 85 140 2375 4300 1675 25 12150 35 95 965 90935.0
matching (n=23753730.0) not_matching (n=1452240.0)
ethnicity_new_16
African 486800.0 50760.0
Any_other_ethnic_group 380790.0 107335.0
Bangladeshi 144965.0 8280.0
Caribbean 139385.0 25880.0
Chinese 283195.0 10650.0
Indian 892985.0 44080.0
Other_Asian 503520.0 104510.0
Other_Black 114425.0 48030.0
Other_Mixed 159575.0 57570.0
Other_White 2985505.0 352220.0
Pakistani 586420.0 29110.0
White_British 16668420.0 487235.0
White_Irish 142135.0 33710.0
White_and_Asian 91245.0 30045.0
White_and_Black_African 82650.0 31780.0
White_and_Black_Caribbean 91715.0 31045.0
African (n=546945.0) Any_other_ethnic_group (n=477530.0) Bangladeshi (n=154795.0) Caribbean (n=168365.0) Chinese (n=297270.0) Indian (n=950015.0) Other_Asian (n=591270.0) Other_Black (n=154335.0) Other_Mixed (n=211480.0) Other_White (n=3465125.0) Pakistani (n=619600.0) White_British (n=17065430.0) White_Irish (n=167355.0) White_and_Asian (n=115700.0) White_and_Black_African (n=107450.0) White_and_Black_Caribbean (n=113305.0)
ethnicity_new_16
African 486800 5550 70 3095 45 925 1770 15020 2285 3345 375 5960 185 165 11085 885.0
Any_other_ethnic_group 5480 380790 430 885 1480 2195 20830 2335 6695 45290 1470 15330 255 2585 1420 655.0
Bangladeshi 80 480 144965 15 35 1130 2485 80 185 285 1945 1305 10 235 10 -
Caribbean 3070 730 15 139385 25 270 275 7415 1215 765 30 6525 25 30 500 4990.0
Chinese 45 1340 25 25 283195 80 4480 85 1130 745 35 2000 15 615 15 15.0
Indian 800 2305 1205 240 105 892985 21255 505 1465 1435 5685 6690 90 2115 110 75.0
Other_Asian 1865 20950 3735 410 6385 31885 503520 1365 4685 6355 14700 6435 65 5250 285 140.0
Other_Black 19105 2415 95 8395 80 545 1155 114425 2010 1775 210 7455 75 125 2540 2050.0
Other_Mixed 2375 6840 250 1230 2055 1595 5045 1855 159575 13465 880 13610 180 2950 2060 3180.0
Other_White 3185 37410 500 630 870 2070 5940 1370 11470 2985505 1160 276640 4510 3165 2015 1285.0
Pakistani 305 1640 1710 45 120 5800 11920 345 885 860 586420 4245 35 1115 55 30.0
White_British 6690 11750 1450 5785 1950 7350 6075 4570 10650 389885 4985 16668420 19635 5815 3520 7125.0
White_Irish 145 235 10 30 15 80 60 55 110 7425 30 25390 142135 50 50 25.0
White_and_Asian 190 2885 305 45 880 2860 5970 155 2965 3610 1580 8330 50 91245 150 70.0
White_and_Black_African 15605 1470 20 725 5 150 335 2410 2280 2625 60 4830 55 145 82650 1065.0
White_and_Black_Caribbean 1205 740 10 7425 25 95 155 2345 3875 1755 35 12265 35 95 985 91715.0
matching (n=18998375.0) not_matching (n=706220.0)
ethnicity_primis_16
African 395210.0 35335.0
Any_other_ethnic_group 404685.0 82725.0
Bangladeshi 125270.0 6180.0
Caribbean 109445.0 16915.0
Chinese 248915.0 8060.0
Indian 766740.0 32995.0
Other_Asian 427010.0 59625.0
Other_Black 87025.0 25055.0
Other_Mixed 140385.0 39620.0
Other_White 2132065.0 127605.0
Pakistani 529710.0 20635.0
White_British 13248420.0 164175.0
White_Irish 121475.0 19385.0
White_and_Asian 88000.0 22540.0
White_and_Black_African 86995.0 23865.0
White_and_Black_Caribbean 87025.0 21505.0
African (n=432790.0) Any_other_ethnic_group (n=480705.0) Bangladeshi (n=131935.0) Caribbean (n=125960.0) Chinese (n=258390.0) Indian (n=799970.0) Other_Asian (n=491200.0) Other_Black (n=111205.0) Other_Mixed (n=176145.0) Other_White (n=2281215.0) Pakistani (n=550970.0) White_British (n=13409380.0) White_Irish (n=137635.0) White_and_Asian (n=106305.0) White_and_Black_African (n=107045.0) White_and_Black_Caribbean (n=103745.0)
ethnicity_primis_16
African 395210 4385 45 1530 20.0 660 1300 8815 1420 2100 285 4575 120.0 115 9270 695.0
Any_other_ethnic_group 4365 404685 350 640 1135.0 1660 17235 1720 5755 33255 1305 10795 225.0 2280 1420 585.0
Bangladeshi 45 390 125270 10 10.0 820 1620 40 160 215 1520 1145 - 195 10 -
Caribbean 1465 580 10 109445 15.0 120 215 4095 700 360 25 4780 15.0 15 345 4175.0
Chinese 30 990 20 20 248915.0 50 3285 40 1000 525 25 1555 15.0 485 15 5.0
Indian 680 1685 840 130 45.0 766740 15760 195 1020 865 4035 5745 75.0 1755 110 55.0
Other_Asian 1180 14410 1940 260 3725.0 15145 427010 685 3160 3980 6900 4545 40.0 3340 220 95.0
Other_Black 8675 1465 40 3855 60.0 140 595 87025 965 935 95 5185 45.0 75 1590 1335.0
Other_Mixed 1380 5385 195 695 1815.0 1095 3745 1030 140385 8505 670 9430 110.0 2195 1375 1995.0
Other_White 1910 30355 325 325 495.0 1125 4020 830 8160 2132065 725 72795 2140.0 2080 1490 830.0
Pakistani 220 1385 1310 20 25.0 4170 7145 80 705 640 529710 3920 40.0 905 45 25.0
White_British 5155 10400 1305 3895 1415.0 5840 4605 3175 7070 90075 4300 13248420 13215.0 4635 3100 5990.0
White_Irish 115 200 10 25 10.0 65 45 35 70 2415 25 16275 121475.0 35 40 20.0
White_and_Asian 140 2380 250 25 695.0 2190 4245 105 2055 2320 1295 6620 45.0 88000 125 50.0
White_and_Black_African 11435 1405 20 400 - 85 265 1860 1445 1905 40 3970 50.0 120 86995 865.0
White_and_Black_Caribbean 785 605 5 4685 10.0 65 110 1475 2075 1055 15 9625 25.0 75 895 87025.0

State Change

African Any_other_ethnic_group Bangladeshi Caribbean Chinese Indian Other_Asian Other_Black Other_Mixed Other_White Pakistani White_British White_Irish White_and_Asian White_and_Black_African White_and_Black_Caribbean
ethnicity_16
African (n = 462975) 462975.0 10780.0 105.0 4685.0 85.0 1200.0 2780.0 36610.0 3890.0 4945.0 535.0 9845.0 265.0 295.0 21205.0 1600.0
Any_other_ethnic_group (n = 547375) 8660.0 547375.0 935.0 1500.0 3560.0 6960.0 39425.0 4890.0 13635.0 66220.0 3830.0 27470.0 510.0 5795.0 2605.0 1350.0
Bangladeshi (n = 147920) 110.0 1480.0 147920.0 30.0 45.0 2140.0 5475.0 180.0 395.0 685.0 3455.0 2315.0 20.0 455.0 25.0 10.0
Caribbean (n = 143395) 4125.0 1670.0 30.0 143395.0 35.0 435.0 485.0 12795.0 2010.0 1235.0 55.0 10230.0 45.0 55.0 830.0 9390.0
Chinese (n = 286085) 50.0 4685.0 40.0 50.0 286085.0 100.0 6915.0 135.0 2355.0 1320.0 45.0 3705.0 25.0 1135.0 30.0 15.0
Indian (n = 903480) 1820.0 9710.0 1815.0 425.0 210.0 903480.0 46860.0 1315.0 3010.0 2770.0 9140.0 13925.0 170.0 4560.0 250.0 115.0
Other_Asian (n = 510855) 2585.0 44400.0 4420.0 565.0 7110.0 41860.0 510855.0 2465.0 8195.0 8870.0 17940.0 10090.0 125.0 8535.0 450.0 200.0
Other_Black (n = 171320) 34825.0 4870.0 120.0 11955.0 110.0 725.0 1720.0 171320.0 3185.0 2530.0 335.0 10530.0 125.0 200.0 5065.0 3395.0
Other_Mixed (n = 178655) 2860.0 11895.0 295.0 1635.0 2230.0 1930.0 5975.0 2820.0 178655.0 15375.0 1050.0 18265.0 245.0 3925.0 2800.0 4050.0
Other_White (n = 2806585) 4385.0 83270.0 620.0 915.0 1070.0 2660.0 8120.0 2495.0 20795.0 2806585.0 1600.0 356300.0 5620.0 4840.0 2890.0 1875.0
Pakistani (n = 597280) 455.0 5950.0 2625.0 80.0 205.0 10175.0 26215.0 665.0 1825.0 1990.0 597280.0 8900.0 80.0 2465.0 105.0 45.0
White_British (n = 17269720) 8830.0 36980.0 2180.0 8490.0 2865.0 9475.0 8505.0 7940.0 19500.0 509375.0 6000.0 17269720.0 40795.0 10020.0 6205.0 11055.0
White_Irish (n = 156470) 170.0 590.0 15.0 50.0 20.0 110.0 90.0 95.0 210.0 7045.0 50.0 38360.0 156470.0 80.0 80.0 40.0
White_and_Asian (n = 100350) 245.0 5135.0 355.0 65.0 1035.0 3300.0 7150.0 250.0 4315.0 4345.0 1910.0 11235.0 90.0 100350.0 195.0 100.0
White_and_Black_African (n = 92720) 17530.0 2600.0 20.0 955.0 10.0 175.0 460.0 4330.0 3400.0 3195.0 75.0 6420.0 80.0 195.0 92720.0 1460.0
White_and_Black_Caribbean (n = 99555) 1420.0 1640.0 10.0 9660.0 30.0 125.0 190.0 3445.0 6225.0 2400.0 35.0 16330.0 60.0 140.0 1535.0 99555.0
African Any_other_ethnic_group Bangladeshi Caribbean Chinese Indian Other_Asian Other_Black Other_Mixed Other_White Pakistani White_British White_Irish White_and_Asian White_and_Black_African White_and_Black_Caribbean
ethnicity_new_16
African (n = 495065) 495065.0 9370.0 115.0 5180.0 95.0 1260.0 3020.0 28635.0 4050.0 5125.0 610.0 10115.0 280.0 310.0 22350.0 1810.0
Any_other_ethnic_group (n = 411605) 7060.0 411605.0 500.0 1075.0 1720.0 2595.0 27320.0 3435.0 9835.0 51980.0 1835.0 17845.0 330.0 3910.0 1945.0 865.0
Bangladeshi (n = 146470) 120.0 870.0 146470.0 30.0 45.0 2120.0 5445.0 155.0 390.0 625.0 3425.0 2355.0 20.0 450.0 25.0 10.0
Caribbean (n = 144930) 4630.0 1270.0 30.0 144930.0 35.0 445.0 500.0 12760.0 1995.0 1335.0 55.0 10330.0 45.0 55.0 895.0 9570.0
Chinese (n = 285040) 50.0 2300.0 40.0 55.0 285040.0 105.0 7615.0 130.0 2340.0 1435.0 45.0 3560.0 20.0 1130.0 25.0 20.0
Indian (n = 901870) 1845.0 4345.0 1805.0 430.0 210.0 901870.0 44120.0 1250.0 3015.0 2980.0 9220.0 13650.0 170.0 4555.0 250.0 120.0
Other_Asian (n = 532905) 2670.0 33525.0 4400.0 570.0 7940.0 40240.0 532905.0 2365.0 8525.0 9770.0 17675.0 9830.0 125.0 8895.0 450.0 235.0
Other_Black (n = 128510) 22125.0 3180.0 110.0 10570.0 100.0 635.0 1445.0 128510.0 2800.0 2365.0 245.0 9610.0 100.0 185.0 3665.0 3030.0
Other_Mixed (n = 174875) 2900.0 9140.0 290.0 1605.0 2230.0 1905.0 6115.0 2580.0 174875.0 16000.0 1030.0 16800.0 225.0 3880.0 2735.0 4120.0
Other_White (n = 3103285) 4450.0 70050.0 590.0 855.0 1160.0 2580.0 8465.0 2310.0 21240.0 3103285.0 1435.0 336075.0 6620.0 4950.0 3060.0 1905.0
Pakistani (n = 592250) 495.0 3170.0 2610.0 80.0 205.0 10330.0 25845.0 615.0 1810.0 1805.0 592250.0 8995.0 80.0 2445.0 100.0 50.0
White_British (n = 16768685) 8905.0 24565.0 2175.0 8480.0 2750.0 9430.0 8510.0 7520.0 18265.0 830775.0 6080.0 16768685.0 39115.0 9765.0 5955.0 11235.0
White_Irish (n = 153715) 175.0 395.0 15.0 50.0 15.0 110.0 85.0 75.0 185.0 12855.0 50.0 33675.0 153715.0 75.0 75.0 35.0
White_and_Asian (n = 99165) 245.0 3770.0 350.0 65.0 1030.0 3290.0 7355.0 230.0 4260.0 4725.0 1895.0 10735.0 80.0 99165.0 195.0 110.0
White_and_Black_African (n = 91635) 17855.0 2040.0 20.0 965.0 10.0 180.0 460.0 3465.0 3315.0 3295.0 75.0 6175.0 70.0 190.0 91635.0 1530.0
White_and_Black_Caribbean (n = 99585) 1480.0 1125.0 15.0 9640.0 30.0 140.0 215.0 3340.0 6050.0 2505.0 45.0 16320.0 60.0 140.0 1550.0 99585.0
African Any_other_ethnic_group Bangladeshi Caribbean Chinese Indian Other_Asian Other_Black Other_Mixed Other_White Pakistani White_British White_Irish White_and_Asian White_and_Black_African White_and_Black_Caribbean
ethnicity_primis_16
African (n = 400755) 400755.0 6825.0 70.0 2255.0 30.0 865.0 2010.0 14200.0 2165.0 2925.0 405.0 6970.0 170.0 185.0 15650.0 1235.0
Any_other_ethnic_group (n = 426520) 5470.0 426520.0 410.0 775.0 1280.0 1915.0 21975.0 2425.0 7950.0 38315.0 1565.0 12630.0 275.0 3220.0 1880.0 735.0
Bangladeshi (n = 126265) 65.0 640.0 126265.0 15.0 15.0 1300.0 2970.0 65.0 260.0 415.0 2395.0 1805.0 15.0 320.0 20.0 NaN
Caribbean (n = 112850) 2080.0 875.0 15.0 112850.0 15.0 205.0 355.0 6355.0 990.0 560.0 35.0 6910.0 30.0 30.0 595.0 6885.0
Chinese (n = 250100) 35.0 1515.0 25.0 40.0 250100.0 55.0 4900.0 60.0 1740.0 855.0 30.0 2465.0 15.0 800.0 20.0 10.0
Indian (n = 773030) 1260.0 2720.0 1200.0 185.0 60.0 773030.0 27860.0 345.0 1700.0 1455.0 6105.0 10385.0 125.0 3320.0 205.0 95.0
Other_Asian (n = 441730) 1575.0 21325.0 2275.0 345.0 4660.0 18335.0 441730.0 1075.0 5180.0 5760.0 8135.0 6670.0 75.0 5285.0 310.0 135.0
Other_Black (n = 93390) 9895.0 1845.0 45.0 4660.0 65.0 170.0 705.0 93390.0 1225.0 1155.0 105.0 6165.0 50.0 90.0 2055.0 1770.0
Other_Mixed (n = 149975) 1640.0 6775.0 220.0 855.0 1955.0 1245.0 4410.0 1335.0 149975.0 9980.0 770.0 11385.0 135.0 2755.0 1760.0 2450.0
Other_White (n = 2162505) 2575.0 50135.0 375.0 415.0 625.0 1400.0 5480.0 1265.0 12845.0 2162505.0 860.0 95685.0 3055.0 3115.0 2085.0 1155.0
Pakistani (n = 533330) 335.0 2370.0 1850.0 35.0 45.0 6575.0 13180.0 160.0 1215.0 1140.0 533330.0 7425.0 65.0 1810.0 75.0 35.0
White_British (n = 13283385) 6475.0 18170.0 1815.0 5155.0 1850.0 7170.0 6060.0 4605.0 11010.0 152665.0 5095.0 13283385.0 23600.0 7190.0 4715.0 8770.0
White_Irish (n = 127640) 130.0 300.0 15.0 35.0 10.0 85.0 60.0 45.0 110.0 3675.0 35.0 20900.0 127640.0 55.0 55.0 30.0
White_and_Asian (n = 93255) 170.0 2915.0 280.0 35.0 805.0 2480.0 5070.0 135.0 2795.0 2875.0 1505.0 8335.0 65.0 93255.0 150.0 70.0
White_and_Black_African (n = 92855) 12995.0 1825.0 20.0 500.0 NaN 105.0 330.0 2380.0 1955.0 2315.0 50.0 4915.0 60.0 150.0 92855.0 1205.0
White_and_Black_Caribbean (n = 92040) 905.0 830.0 10.0 5890.0 15.0 90.0 145.0 1920.0 3015.0 1350.0 25.0 12320.0 40.0 100.0 1270.0 92040.0