Case-mix: Clinical combinations

Using a database of hospital episodes in the UK from 1998 up to the present day, analysed as Finished Consultant Episodes (FCEs), we tabulated numbers of FCEs where a particular diagnosis or operation occurs on the same FCE as another diagnosis or operation. The purpose of the tables is to provide information relevant to understanding and studying case-mix.

Each FCE will have a main diagnosis field and has fields for up to 19 other diagnoses recorded for that patient during the FCE. Similarly, there will be a main operation field, and fields for up to 23 other operations performed and/or information such as the site or laterality of an operation.

So, for example, we can show the total number of episodes where asthma appears as a main diagnosis, and list the condtions most likely to occur in any other diagnosis field. Alternatively, we can look at the number of records where asthma appears in any field, or any field other than main. Then we can list the conditions that also appear elsewhere on these records. We can look at operation codes in a similar way. For example we can look at an operation of interest and see what other operations were undertaken in the same admission. Or we can see, for that operation, what diagnoses were recorded in association with it. Some of the associated diagnoses will be those for which the operation was undertaken; others will be those that represent comorbidity; and others may be those that arose as postoperative complications.

To begin, please select one of the following combinations:

Given a diagnosis in the main field - what are diagnoses in other fields?

Given a diagnosis in fields other than main - what are diagnoses in the main field?


Given a diagnosis in the main field - what are the operations in any field?

Given a diagnosis in fields other than main - what are the operations in any field?


Given an operation in any field - what are the diagnoses in any field?

Given an operation in any field - what are the diagnoses in main field?


Given an operation in the main field - what are the operations in all other fields?

Given an operation in any field - what are the operations in all other fields?

Given an operation in fields other than main - what are the operations in the main field?



Big Data Institute

Unit of Health Care Epidemiology


The content of this website was designed and produced by Michael Goldacre, Nick Hall, Mattasser Nazir, Leicester Gill, Myfanwy Griffith, and Glenys Bettley.

The work was funded at various times by the Department of Health, the NHS National Co-ordinating Centre for Research Capacity Development, the Department of Health's National Institute for Health Research, the Department of Health's National Centre for Health Outcomes Development, and the Nuffield Department of Population Health.

© 2023 Unit of Health Care Epidemiology, Nuffield Department of Population Health, University of Oxford, Old Road Campus, Headington, Oxford, OX3 7LF
Tel: +44 (0)1865 289377/8