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 31 March 2025. 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 15 data sources for each of three date ranges.

Data sources:

1. APCS
2. APCS_ARCHIVED
3. Appointment
4. CPNS
5. CodedEvent
6. EC
7. EC_ARCHIVED
8. ICNARC
9. ONS_Deaths
10. OPA
11. OPA_ARCHIVED
12. SGSS_AllTests_Negative
13. SGSS_AllTests_Positive
14. SGSS_Negative
15. 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 (31 March 2025)
3. Event activity from the first occurrence on or after 1 January 2016 to the last occurrence on or before the report run date (31 March 2025)

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

APCS_ARCHIVED

Appointment

CPNS

CodedEvent

EC

EC_ARCHIVED

ICNARC

ONS_Deaths

OPA

OPA_ARCHIVED

SGSS_AllTests_Negative

SGSS_AllTests_Positive

SGSS_Negative

SGSS_Positive