Cumulative Antibiogram From an Isolate List (AHRQ Specification)

Builds a cumulative antibiogram from an isolate list by the AHRQ specification.

Open the tool → Runs in your browser. Data leaves only if you deliberately send a problem report from the interactive tool.

Example

Isolate list with a header row
patient,organism,date,status,purpose,Ceftriaxone A,Escherichia coli,2026-03-02,final,diagnostic,S A,Escherichia coli,2026-03-10,final,diagnostic,R B,Escherichia coli,2026-03-05,final,diagnostic,R

Result: Antibiogram of 2 first isolates across 1 organism; 1 duplicate removed.

The tool opens with these values already filled in. Replace them with your own.

What you enter

  • Isolate list with a header row: patient, organism, date, optional status and purpose, then one column per agent holding S, I or R
  • First day of the period (YYYY-MM-DD)
  • Last day of the period (YYYY-MM-DD)
How this is calculated

Citation

AHRQ. Nursing Home Antimicrobial Stewardship Guide, Comprehensive Antibiogram Toolkit: Antibiogram Specifications. AHRQ Pub. No. 14-0022-4-EF, May 2014. Interval: Wilson EB. J Am Stat Assoc. 1927;22(158):209-212. Read the source ↗

A reference and educational tool. Not medical, legal, or financial advice, and not a substitute for clinician judgment.

Browse all tools

Built by Clay Good. Source on GitHub.