OpenSAFELY
Reports

OpenSAFELY-TPP Database Import Dates

Description
This report displays the import dates of the data sources in 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
06 Jan 2021
Last released
20 Dec 2023
Links
OpenSAFELY-TPP Database Import Dates

OpenSAFELY-TPP Database Import Dates

This report displays the import dates of the data sources in 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 20 December 2023. It reflects the state of the database on this date.

Import Dates

TPP create a snapshot of the primary care information captured in the SystmOne database; this is processed before it is imported into the OpenSAFELY-TPP database. TPP also receive (or "ingest") external data sources from NHS Digital, ONS, etc. These external data sources are also processed before they are imported into the OpenSAFELY-TPP database. In each case, a new import overwrites the previous import. Once a data source has been imported, it can be queried immediately from Level 3.

The dates in the sections below reflect when the data sources were last imported into the OpenSAFELY-TPP database. They do not reflect when the data sources were received by TPP, nor when the event activity occurred.

Latest Import Dates

Data Source Latest Import Date
APCS 28 November 2023
CPNS 20 July 2023
EC 5 December 2023
ECDS 21 April 2020
HealthCareWorker 8 December 2022
HighCostDrugs 27 November 2020
ICNARC 21 January 2021
ISARIC_New 27 January 2023
MPI 5 August 2020
ONS_CIS 28 April 2021
ONS_CIS_New 16 December 2022
ONS_CIS_New_Swab_Clearance 16 December 2022
ONS_Deaths 12 December 2023
OPA 28 November 2023
S1 15 December 2023
SGSS_AllTests_Negative 8 December 2022
SGSS_AllTests_Positive 5 December 2023
SGSS_Negative 5 December 2023
SGSS_Positive 5 December 2023
Therapeutics 5 December 2023
UKRR 24 March 2022
UPRN 5 August 2020
WL_ClockStops 3 August 2022
WL_Diagnostics 3 August 2022
WL_OpenPathways 3 August 2022

All Import Dates