OpenSAFELY-TPP Database Coverage

This report displays the coverage of the OpenSAFELY-TPP database. It is part of the OpenSAFELY platform's technical documentation and is published at https://reports.opensafely.org/.

This report should not be used for inference about any aspect of the pandemic, public health, or health service activity. For the avoidance of doubt, any clinical or epidemiological interpretation of this report is likely to be a misinterpretation.

If you would like to use the OpenSAFELY platform, then you should read our documentation, our principles, and our process for onboarding new users. If you would like to see the code we used to create this report, then you can view it on GitHub.

Data Sources

The OpenSAFELY-TPP Database Schema report contains information about the data sources in the OpenSAFELY-TPP database.

Report Run Date

This report was run on 19 December 2023. It reflects the state of the OpenSAFELY-TPP database on this date.

Event Activity

In the figures below, event activity (counts of events, such as in-patient hospital admissions) is reported for each of 12 data sources for each of three date ranges.

Data sources:

1. APCS
2. Appointment
3. CPNS
4. CodedEvent
5. EC
6. ICNARC
7. ONS_Deaths
8. OPA
9. SGSS_AllTests_Negative
10. SGSS_AllTests_Positive
11. SGSS_Negative
12. SGSS_Positive

Date ranges:

1. The most recent 30 days for which there is event activity
2. Event activity from the first occurrence on or after 1 February 2020 to the last occurrence on or before the report run date (19 December 2023)
3. Event activity from the first occurrence on or after 1 January 2016 to the last occurrence on or before the report run date (19 December 2023)

The OpenSAFELY-TPP database only includes patients who were registered at GP practices using TPP's SystmOne clinical information system (which is used by roughly 40% of GP practices) on or after 1 January 2009, including those patients who have since deregistered or died. The OpenSAFELY-TPP database therefore captures event activity for these patients only.

APCS

Appointment

CPNS

CodedEvent

EC

ICNARC

ONS_Deaths

OPA

SGSS_AllTests_Negative

SGSS_AllTests_Positive

SGSS_Negative

SGSS_Positive