Public sandbox
Synthetic data onlySee the platform work, without a single real patient record
Everything below runs in your browser against deterministic synthetic data. It is the same model, the same API shapes and the same analytics as the reference build — but nothing here is derived from any Trust's data, and the build itself stays behind authorised access.
patient
Master patient index conformed from PAS. Demographics, registration and death notification, with a stable surrogate key used across every clinical domain.
episode_of_care · outpatient_appointment · emergency_care_attendance · rtt_pathway
| Column | Type | Key | Notes |
|---|---|---|---|
| patient_sk | bigint | PK | |
| nhs_number | char(10) | restricted to the identifiable visibility group | |
| local_patient_identifier | varchar(20) | ||
| birth_date | date | ||
| death_date | date | nullable | |
| gender_code | varchar(2) | FK | |
| ethnic_category_code | varchar(2) | FK | |
| lsoa_2021_code | varchar(9) | FK | |
| registered_gp_practice_code | varchar(6) | FK | |
| record_effective_from | timestamptz | ||
| record_effective_to | timestamptz | nullable |
A documentation-grade subset of the canonical model is shown here. The generator, the full 72-table DDL and the dbt test project are released to authorised evaluators only.
What the sandbox shows
Structure, interfaces and behaviour: how the canonical model is shaped, what the API returns, how quality is proven and what the analytics look like on top.
What it deliberately withholds
The schema generator, dbt project, transformation logic, deployment code and IG pack. None of that is downloadable from this page.
Want the real thing?
Named evaluators get the full build, free for non-production use, with a walkthrough. Request evaluation access.