Clinical Record Explorer

See how decisions about clinical data change research results. Compare the results before and after checking corrections, diagnosis status, units and dates, then trace each decision back to the original record.

Study definition

Adults with confirmed, active recorded diabetes. Select their latest eligible HbA1c.

Index = earliest qualifying recorded diagnosis date. Inclusive window. Final/corrected results in UCUM %. Threshold is illustrative.

A controlled comparison

Patient counts meeting the threshold under two* queries.

*The naive query ignores revisions, status, units and the study window. These fixtures deliberately
expose those failures (this is not a benchmark).

Patient decisions

PatientStudy indexSelected HbA1cOutcomeExplanation
Inspect the rules, SQL and run information