Open sidebar
Reports

OpenSAFELY-TPP Database Coverage

Description
This report displays the coverage of the OpenSAFELY-TPP database.
Contact
Get in touch and tell us how you use this report or new features you'd like to see: team@opensafely.org
First published
24 Apr 2023
Last released
04 Apr 2025
Links
OpenSAFELY-TPP Database Coverage

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