Resources
Synthetic healthcare datasets, Power BI models and DAX, prompts, and project code, free to download and reuse.
Everything here comes from a project on this site, so each file has a write-up that explains how it was made and what it’s for. The datasets are synthetic: use them for practice, teaching, demos, and testing pipelines. Use and adapt them freely; a link back is appreciated.
Datasets
-
Daily ED attendances 2021-2025
One row per day: total, ambulance and walk-in arrivals, the planted flags, and the planted expected value. From Emergency department demand forecasting.
-
Backtest forecasts
Every forecast from 24 monthly origins, with 80% intervals for the 2025 origins and the actuals. From Emergency department demand forecasting.
-
Synthetic discharges sample 2023-2025
19,998 discharges for whole patients chosen at random. ward_code is the planted leak; leave it out of any model. From 30-day readmission risk model.
-
Model metrics by subgroup
Test-period metrics in long format: one row per model, group and metric, including call-list capture and PPV. From 30-day readmission risk model.
-
All seven CSVs
The star schema as CSV. Unzip into the folder the CsvFolder parameter points at. From Referral-to-treatment waiting list semantic model.
-
RTT pathways
One row per pathway: 58,050 rows, with clock start, clock stop and stop type. From Referral-to-treatment waiting list semantic model.
-
Weekly waiting list snapshot
Sunday × specialty × priority × wait band: 19,884 rows. From Referral-to-treatment waiting list semantic model.
-
Raw extract sample
13,030 rows: every extract row for one appointment in twelve, re-sent copies included. From Outpatient analytics pipeline.
-
Mart outputs
Seven marts as CSV. Rates come with their numerators and denominators. From Outpatient analytics pipeline.
-
Weekly assessment times with XmR limits and flags
78 synthetic weeks: the value, its moving range, the baseline limits, and one True/False column per special-cause rule, exactly as special_causes returns them. From SPC toolkit, a small Python package.
-
Clinic DNA rates with funnel limits
45 synthetic clinics: counts, rate, planted true rate, z-score, and 99.8% limits and flags with no adjustment, multiplicative and additive. From SPC toolkit, a small Python package.
-
All eight CSVs
The star schema as CSV, including the security mapping. Unzip into the folder the CsvFolder parameter points at. From Theatre utilisation semantic model.
-
Theatre lists
One row per list: 6,844 rows with planned and actual times and the minutes lost. From Theatre utilisation semantic model.
-
Booked cases
One row per booked case: 35,014 rows with times, touch minutes and cancellation reasons. From Theatre utilisation semantic model.
-
Scenario results summary
One row per scenario and measure: mean with 95% interval, 10th, 50th and 90th percentiles across 200 simulated years, and the paired change from current practice. From Bed occupancy simulation.
-
Hourly occupancy for one simulated year
Replication 1 of all six scenarios, hour by hour for 52 weeks: patients in a bed and patients waiting for one. From Bed occupancy simulation.
-
Test-practice letters with predictions
1,287 synthetic letters from 11 practices: labels, planted-difficulty flags, keyword and model predictions, probabilities and the routing decision. From Referral triage text classifier.
-
Appointment-level sample
Every appointment for a random 40% of trial patients (7,887 rows): arm, text delivery status, outcome, and the planted DNA probability under each arm. From Appointment reminder experiment.
-
Trial results
Every estimate on this page with its 95% interval, p-value and planted value. From Appointment reminder experiment.
Power BI models and DAX
-
RTT measures as a DAX query
All 18 measures with their descriptions. Paste into DAX query view and run. From Referral-to-treatment waiting list semantic model.
-
Theatre measures as a DAX query
All 17 measures, the 6 calculation items as comments and two test queries. Paste into DAX query view. From Theatre utilisation semantic model.
Project code
Guides and references
-
Metric definitions
DNA rate, cancellation rates, slot utilisation and new-to-follow-up ratio. From Outpatient analytics pipeline.
-
Data tests
Column tests and reconciliations in the shape of a dbt properties file. From Outpatient analytics pipeline.