OpenSAFELY-TPP Database Historical Coverage

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

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 24 April 2023. It reflects the state of the database on this date.

Event Activity

In the figures below, event activity (counts of events, such as in-patient hospital admissions) is reported for data sources from 1 January 2016 to 24 April 2023.

The 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 database therefore captures event activity for these patients only.

Data sources:

apcs

appointment

codedevent

cpns

ec

icnarc

ons_deaths

opa

sgss_alltests_negative

sgss_alltests_positive

sgss_negative

sgss_positive