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
- 03 Mar 2025
- Links
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 26 February 2025. 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 | 4 February 2025 |
CPNS | 20 July 2023 |
EC | 24 February 2025 |
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 | 11 February 2025 |
OPA | 4 February 2025 |
S1 | 21 February 2025 |
SGSS_AllTests_Negative | 8 December 2022 |
SGSS_AllTests_Positive | 24 February 2025 |
SGSS_Negative | 24 February 2025 |
SGSS_Positive | 24 February 2025 |
Therapeutics | 24 February 2025 |
UKRR | 24 March 2022 |
UPRN | 5 August 2020 |
WL_ClockStops | 3 August 2022 |
WL_Diagnostics | 3 August 2022 |
WL_OpenPathways | 3 August 2022 |