Annex: Data and methodology

We have relied on a small number of key data sources when analysing health care output and activity. For total NHS output, we used the public service productivity estimates for health care in England produced by the ONS. NHS reference costs data were used to understand the average unit cost and activity delivered by NHS Trust and Foundation Trusts by service.

Methodology

We model demographic factors that are readily available and relatively easy for planners to project into the future – and therefore useful in planning. These include: size of the population, age, gender and proximity to death. For proximity to death, we use successive years of HES or CPRD data supplemented with information regarding an individual’s death from linked ONS mortality data.

We use a nested modelling approach to estimate the relative scale of the effect of changes in population size, the age and gender makeup of the population, and proximity to death (as a proxy for levels of morbidity) on activity.

We start with an initial model – with time as the sole explanatory variable – that estimates the absolute increase in attendances. This model takes no account of changes in population size, the age and gender makeup of the population or levels of morbidity. We then expand the model, adding one factor at a time until all potential explanatory factors are included. At each stage, we use the model to generate a prediction for the overall number of units of activity (attendances etc).

In effect, we create a counterfactual estimate of attendance numbers by applying the modelled relationships between our explanatory factors and attendances to the population in the final year. If the number of attendances predicted by the final model (including all potential explanatory factors) were only marginally different to the number of attendances in the final year, then we might conclude that these factors are sufficient to explain the observed trend.

It is possible that some of the explanatory factors listed above will be collinear. As such, the order in which the factors are introduced into the model will influence their reported effect on attendance numbers. The change in predicted attendances when a factor is introduced represents the additional change that this variable produces having taken account of all other variables in higher nest levels. For example, at nest level 3, the model adjusts for age, population size and the fixed effect of time.

Time period

As far as possible, we have sought to model the 20 years from 2000/01. In many instances, the latest available data are 2017/18. Where data were unavailable for the whole time series – for instance, HES data are incomplete for A&E attendances prior to 2010/11 – we project the contribution of model parameters from available data over the longest available time span. See the further notes in data definitions.

Results

The full set of results from our model can be found in the table below. This breaks out demographics into its composite factors: population size, age, gender and proximity to death.

Average annual growth rate by service area (%)

Service

Time period

Observed

Demographics

Other factors

Population size

Age

Gender

Proximity to death

NHS111 calls handled

(2000/01 to 2017/18)

8.80%

0.72%

n/a

8.04%

999 calls

(2000/01 to 2017/18)

5.40%

0.72%

n/a

4.65%

Ambulance conveyances to A&E

(2000/01 to 2017/18)

1.20%

0.72%

n/a

0.50%

Minor A&E attendances

(2003/04 to 2017/18)

6.5%

0.77%

n/a

5.8%

Major A&E attendances

(2003/04 to 2017/18)

1.40%

0.78%

0.20%

0.07%

-0.06%

0.40%

Hospital admissions

(2000/01 to 2017/18)

1.90%

0.72%

0.20%

0.06%

-0.14%

1.10%

Emergency bed-days

(2000/01 to 2017/18)

-1.10%

0.72%

0.51%

0.04%

-0.24%

-2.11%

Outpatient appointments

(2003/04 to 2017/18)

3.80%

0.78%

0.19%

0.09%

-0.02%

2.76%

Diagnostics

(2008/09 to 2018/19)

5.80%

0.77%

n/a

5.01%

Elective procedures

(2000/01 to 2017/18)

9.60%

0.72%

0.26%

0.06%

-0.08%

8.66%

Planned bed-days

(2000/01 to 2017/18)

-3.50%

0.72%

0.57%

0.03%

-0.27%

-4.55%

Maternity admissions

(2000/01 to 2017/18)

0.5%

0.84%

n/a

-0.3%

Maternity bed-days

(2000/01 to 2017/18)

-1.1%

0.84%

n/a

-1.9%

Consultations in general practice

(2000/01 to 2018/19)

0.70%

0.72%

-0.09%

0.02%

0.03%

-0.02%

Community prescribing

(2000/01 to 2018/19)

3.82%

0.72%

n/a

3.10%

Community services

(2004/05 to 2017/18)

0.90%

0.79%

n/a

0.08%

MH hospital admissions

(2000/01 to 2017/18)

-4.40%

0.72%

-0.53%

-0.04%

0.27%

-4.78%

MH hospital bed-days

(2000/01 to 2017/18)

-3.90%

0.72%

-0.15%

0.02%

-0.15%

-4.33%

MH hospital outpatients

(2003/04 to 2017/18)

5.60%

0.78%

0.15%

-0.03%

0.02%

4.73%

Community MH

(2011/12 to 2017/18)

1.50%

0.77%

n/a

0.69%

Data definitions and sources

When modelling changes in activity, we rely on a range of sources, most often hospital episode statistics (HES). Note, this contains data for all NHS funded care, including that delivered by the non-NHS providers, which is missing in NHS reference costs. Importantly, this is a patient level dataset, meaning we can understand the profile of those using services, which informs our model. A full list of sources and definitions used in the modelling for chapter 4 are provided in the table that follows.

Area

Series

Definition

Source

Full model?

Notes

Unplanned care

NHS 111 / NHS Direct

Number of answered calls

NHS 111 Minimum Data Set, NHS England

https://www.england.nhs.uk/statistics/statistical-work-areas/nhs-111-minimum-data-set

No 

NHS Direct was set up in 2000. The service was replaced by NHS 111 in 2010, although the transition to NHS 111 was not completed until 2014.

Control room contacts

Count of all ambulance control room contacts (A0)

Ambulance quality indicators, NHS England

https://www.england.nhs.uk/statistics/statistical-work-areas/ambulance-quality-indicators

No 

Transfers to emergency departments (ED)

Count of incidents with any patients transported to an ED

(A53).

Ambulance quality indicators, NHS England

https://www.england.nhs.uk/statistics/statistical-work-areas/ambulance-quality-indicators

No 

Attendances at major A&E departments

Count of attendances at type-1 A&E departments

HES A&E dataset; Unify2 system

Yes

There are two primary sources for administrative data on the number of attendances at A&E departments. Individual NHS provider organisations submit regular reports to a central repository and these reports are collated under the umbrella name ‘Unify2 collections’. For A&E attendances, the reporting is monthly and comprises aggregate counts of attendances for each provider. A consistent historical series exists from 2003–04. Hospital Episode Statistics (HES) provide a much richer source of information on patient-level hospital use taken directly from provider’s Patient Administration Systems (PAS). For A&E activity the HES dataset starts in 2007–08 but coverage in the first few years is incomplete. In more recent years, the main cause of difference between the two sources is that a number of smaller walk-in centres and minor injury units do not submit to HES. Unify2 does not include planned follow-up attendances. Unify is used for the full time series, while HES is used over a shorter period (2010/11 to 2014/15) to inform the model parameters.

Attendances at minor A&E departments

Count of attendances at type-2 single specialty departments, type-3 UTCs or MIUs, and type-4 walk-in departments

Unify2 system

No

To avoid problems of comparability related to the increased supply of minor injury units and walk-in centres, we limit our full analyses to type-1 or ‘major’ A&E departments.

Emergency admissions

Count of admissions where the method of admission code denotes an emergency admission (code starts with ‘2’)

HES inpatient dataset

Yes 

Admissions where the main specialty or treatment specialty is mental health-related (specialty code starts ‘71’ or ‘72’) are excluded here. They appear in a separate mental health category.

Emergency bed days

Count of overnight bed days where the method of admission code denotes an emergency admission (code starts with ‘2’)

HES inpatient dataset

Yes 

See note above.

Planned care

Outpatient appointments

Count of completed outpatient appointments

HES outpatient dataset

Yes 

Outpatient appointments where a procedure (diagnostic or otherwise) was undertaken are excluded here. They appear in a separate ‘planned care’ category; Appointments where the main specialty or treatment specialty is mental health-related (specialty code starts ‘71’ or ‘72’) are excluded here. They appear in a separate mental health category.

Diagnostics

Count of 15 key diagnostic tests and procedures. All referral routes and all settings are included

Diagnostic activity, NHSE

https://www.england.nhs.uk/statistics/statistical-work-areas/diagnostics-waiting-times-and-activity/

No

One unit of activity is recorded for each distinct clinical test or procedure undertaken. For example, a patient having more than one MR scan of a knee at the same visit would count as one unit of activity.

Elective procedures

Sum of ordinary elective, day-case, regular day/night admissions, and outpatient appointments where a procedure was undertaken

Yes 

Elective admissions defined by admission method code starting ‘1’, or patient classification code equal to ‘3’ or ‘4’;

Admissions where the only procedure undertaken was one of a set of key diagnostic tests or procedures are excluded here as diagnostic activity is captured in a separate category;

Admissions where the main specialty or treatment specialty is mental health-related (specialty code starts ‘71’ or ‘72’) are excluded here. They appear in a separate mental health category.

Bed days

Count of overnight bed days for ordinary elective admissions

 

Yes 

See note above.

Maternity

Maternity admissions

Count of admissions where the method of admission code denotes an emergency admission (code starts with ‘3’)

HES inpatient dataset

No

Maternity bed days

Count of overnight bed days for maternity admissions

HES inpatient dataset

No

Primary care and community services

Consultations in general practice

Count of GP-led and other consultations

CPRD GOLD

Yes

The analysis was of a sample of 1,688,836 patients from CPRD GOLD that were ‘active’ for any time period between 1 April 2000 to 31 March 2019. A patient is defined as active if they were registered at an English GP practice on or before 31 March 2019 and did not de-register for any reason (including death) prior to 1 April 2000.

A consultation was defined as GP-led if the staff role code was 1, 2, 5, 6, 7, 8, 10, 47 or 50. The following staff role codes were defined as ‘other’: 3, 4, 9, 11–46, 48, 49, 51–68. Consultation types were defined using the constype code as follows:

  • Face-to-face: 1, 7, 9, 18, 36, 39, 40, 61
  • Home visit: 2, 3, 4, 6, 8, 11, 24, 27, 28, 30, 31, 32, 37, 50
  • Telephone: 10, 21, 35, 55.

Total consultations are the sum of face-to-face, home visits and telephone. All other consultation type codes were excluded and defined as administrative events.

GP prescribing

Count of all items (eg medicines, dressings, and appliances) prescribed and dispensed in the community

Practice Level Prescribing, NHSD

https://digital.nhs.uk/data-and-information/areas-of-interest/prescribing/practice-level-prescribing-in-england-a-summary

Prescription Cost Analysis, NHSD

https://digital.nhs.uk/data-and-information/publications/statistical/prescription-cost-analysis

No 

 

Community services

Count of community services activity undertaken by NHS organisations. This activity is predominantly visits or assessments

NHS reference costs 

No

Mental health

Mental health inpatients 

Count of admissions where the main specialty or treatment specialty is mental-health-related (specialty code starts ‘71’ or ‘72’)

HES inpatient dataset

Yes 

Admissions where the only procedure undertaken was one of a set of key diagnostic tests or procedures are excluded here as diagnostic activity is captured in a separate category.

Mental health outpatients 

Count of appointments where the main specialty or treatment specialty is mental-health-related (specialty code starts ‘71’ or ‘72’)

HES outpatient dataset

Yes 

Appointments where the only procedure undertaken was one of a set of key diagnostic tests or procedures are excluded here as diagnostic activity is captured in a separate category.

Community mental health

This includes care delivered by specialist mental health teams (i.e. not in a non-specialist mental health hospital)

NHS reference costs

No

Care clusters cover services for working age adults and older people. A care cluster counts caseload rather than activity as defined elsewhere.

Not all specialist mental health services are captured by clusters; child and adolescent mental health services (CAMHS) activity, for instance, is reported separately.

Note, Community Mental Health data were reclassified in 2011/12, meaning the data are not comparable with previous years.

Previous