Clinical Dataset Data Quality Audit

845.7K audited rows across 3 clinical domains • 5 rule families • issue-heavy domains concentrated in vitals and labs

Total Rows Audited
845.7K
3 linked domains
Rule Breaches
135.7K
Vitals drive 66.8% of issues
Rows With Any Flag
61.9K
7.32% overall row rate
Completeness & Coverage
100%
0 missing / temporal flags
Audit framing
How to read these flags
  • Flags represent rule-based review conditions, not necessarily impossible clinical values.
  • Out-of-bounds checks use operational guardrails; cross-field checks emphasize oxygen-device logic, alert coverage, and event labeling consistency.
  • The expected intermediate JSON was absent at build time, so the report payload was reconstructed locally from the three clinical CSVs and serialized to dq_report.json before visualization.
MissingnessCategorical validityOut-of-boundsCross-field consistencyTemporal alignment
What stands out
Key findings from the audit
  • No missingness, categorical-validity, or temporal-coverage gaps were flagged in the reconstructed audit payload.
  • Vitals contribute 66.8% of all rule breaches and show the highest affected-row rate at 9.58%.
  • The largest review thresholds are low oxygen saturation (5.15%), elevated lactate (5.00%), and low systolic blood pressure (4.46%).
  • Issue rates rise late in the stay, peaking at hour 71 for vitals (28.67%) and hour 68 for labs (17.21%).
Highest-burden domain Vitals (9.58%)
Peak hourly vitals rate Hour 71 · 28.67%
Domain overview: affected-row rate and issue volume
Anomaly-rate heatmap by domain and check family
Issue-count composition by domain
Largest rule-level drivers
Highest-burden patients: issue concentration versus baseline risk
Hourly issue-rate trend across time-series domains
Top patients by total flagged rows
Patient Admission Age LOS Baseline risk Deterioration Vital issues Lab issues Total
220Transfer8371h0.809Event7050120
3878Elective3570h0.714Event6753120
3991Elective7372h0.840Event5856114
4369Transfer8568h0.715Event5554109
9759Elective8272h0.363Event5850108
638ED3969h0.433Event5652108
5784Transfer8968h0.590Event5652108
4108ED7972h0.387Event5552107
7907Elective7270h0.644Event5552107
4349ED7369h0.830Event5452106