Why are Medicare and Medicaid shown separately instead of combined?

They come from two different CMS data sources with no shared claim identifier, so they can't be reconciled into one number without double-counting or guessing. Every table and chart on this page keeps them fully separate.

Why is there no private/commercial revenue figure?

Private and commercial payer data comes from Transparency in Coverage files, which only publish negotiated rates — not claims or utilization volume. Without a volume figure, no revenue number can be computed for any provider from that data.

What does "Rank" mean in the Competitive Analysis & Benchmarks tables?

For a given CPT/HCPCS code, it's this provider's position by claims volume among all providers billing that same code at that geography level (State, National, or Missouri for Medicaid) — rank 1 means the highest claims volume for that code.

Why is the Medicaid comparison limited to Missouri only?

Medicaid is administered per-state with no single national fee schedule, so a state or national comparison the way Medicare has one isn't available. Missouri (this provider's own state) is the only grouping that's conceptually meaningful.

Why are the numbers rounded to the nearest 10?

To avoid implying more precision than the underlying data supports at a single-provider level. Ratios are kept precise since they're a relative comparison, not a volume or dollar figure.

How current is this data?

The Medicare and Medicaid tables are both single current snapshots, not refreshed on a recurring schedule yet.

Mercy Hospital Aurora (NPI 1467543090)

Field	Value
Entity Type	Organization
Organization	Mercy Hospital Aurora
Address	500 Porter Ave
City	Aurora
State	MO
ZIP	65605
Taxonomy	Critical Access Hospital
NPI Enumerated	September 27, 2006

Payer Source	Total Paid
Medicaid	$9.9M
Medicare	$0

Medicaid: Complete Services Breakdown

Every CPT/HCPCS code this provider has billed to Medicaid, with claims volume, average payment, and total revenue.

40 rows

CPT/HCPCS Code	Description	Claims	Avg Paid	Revenue
99283	The provider sees a patient for an emergency department visit involving evaluation and management (E/M). The visit involves a low level of medical decision making.	21,630	$130	$2.7M
Y7506	N/A	13,840	$150	$2M
99284	The provider sees a patient for an emergency department visit involving evaluation and management (E/M). The visit involves a moderate level of medical decision making.	14,050	$140	$2M
99285	The provider sees a patient for an emergency department visit involving evaluation and management (E/M). The visit involves a high level of medical decision making.	6,430	$220	$1.4M
X4011	N/A	3,300	$220	$715.9K
85025	A complete blood count (better known as a CBC) is a blood test request by a doctor that provides detailed information about various types of cells in a patient's blood. Usually a pathologist or a…	8,490	$40	$356.6K
80053	The lab analyst performs a comprehensive metabolic panel, or CMP test in which he measures the blood level of 14 chemicals the code descriptor lists for the panel.	6,950	$30	$236.2K
87804	The analyst performs an immunoassay with direct optical, meaning visual, observation to detect influenza, also called flu, in a patient sample, typically a throat or nasal swab or nasal washings.	420	$290	$122.8K
0241U	N/A	710	$110	$79.9K
96374	The provider administers a single medication or other substance rapidly into a vein to treat, prevent, or diagnose a condition.	760	$100	$78.1K

Showing 1–10 of 40

Medicaid: Competitive Analysis & Benchmarks

How this provider's Medicaid billing volume and revenue compare to other Missouri providers billing the same CPT/HCPCS codes.

Claims Volume vs. Missouri Distribution

Mercy Hospital Aurora — 2 of 25 codes billed far more than typical (above p95)

p5–p95 (all providers)p25–p75MedianThis providerOutlier

Rank Distribution — Missouri

Full comparison — all codes billed, vs. Missouri median

40 rows

CPT/HCPCS Code	Description	Rank	Provider Count	Median Claims	Avg Paid	Average Revenue
X4011	N/A	69	110	5,700	$340	$3.2M
G0463	Hospital outpatient clinic visit for assessment and management of a patient	80	100	2,240	$80	$2.2M
Y7506	N/A	15	100	980	$250	$1.6M
96374	The provider administers a single medication or other substance rapidly into a vein to treat, prevent, or diagnose a condition.	59	90	1,850	$120	$384.1K
99285	The provider sees a patient for an emergency department visit involving evaluation and management (E/M). The visit involves a high level of medical decision making.	56	600	140	$170	$384.1K
93005	The provider records the electrical conduction of the heart to examine any abnormality in its functioning, based on signals from at least 12 leads, wires that connect the recording device to…	75	110	2,100	$70	$364.3K
80053	The lab analyst performs a comprehensive metabolic panel, or CMP test in which he measures the blood level of 14 chemicals the code descriptor lists for the panel.	74	240	1,740	$40	$353.4K
85025	A complete blood count (better known as a CBC) is a blood test request by a doctor that provides detailed information about various types of cells in a patient's blood. Usually a pathologist or a…	70	320	980	$40	$352.7K
99284	The provider sees a patient for an emergency department visit involving evaluation and management (E/M). The visit involves a moderate level of medical decision making.	40	950	120	$150	$288.2K
99283	The provider sees a patient for an emergency department visit involving evaluation and management (E/M). The visit involves a low level of medical decision making.	26	1,260	220	$120	$242.4K

Showing 1–10 of 40

Related Providers

Other providers that share a Tax Identification Number (TIN) with Mercy Hospital Aurora, ranked by combined Medicare and Medicaid revenue.

Provider	State	Taxonomy	Medicare Revenue	Medicaid Revenue
Wendell Scott	MO	Ophthalmology Physician	$253.5K	$0
Sharad Bansal	MO	Cardiovascular Disease Physician	$132.6K	$0
Gerard Oghlakian	MO	Advanced Heart Failure and Transplant Cardiology Physician	$120.6K	$0
Anoop Parameswaran	MO	Cardiovascular Disease Physician	$116K	$0
Gary Gillham	MO	Ophthalmology Physician	$112.2K	$0
Joel Jones	AR	General Practice Physician	$111.4K	$30
Sadie Giedd	MO	Pain Medicine (Anesthesiology) Physician	$96.6K	$0
Donald Myears	MO	Interventional Cardiology Physician	$74.9K	$0
Ray Woodmansee	MO	Emergency Medicine Physician	$50K	$8K
Joshua Pead	FL	Emergency Medicine Physician	$37.2K	$11K

Nearby Providers

Other providers in the same ZIP code as Mercy Hospital Aurora, ranked by combined Medicare and Medicaid revenue.

Provider	State	Taxonomy	Medicare Revenue	Medicaid Revenue
Lawrence County Board For The Developmentally Disabled	MO	Case Management Agency	$0	$3.4M
Linda Long	MO	Family Nurse Practitioner	$670	$0

Mercy Hospital Aurora — Billing Profile & Reimbursement Data

Sign up for Mercy Hospital Aurora — Billing Profile & Reimbursement Data policy alerts

Mercy Hospital Aurora — Billing Profile & Reimbursement Data

Sign up for Mercy Hospital Aurora — Billing Profile & Reimbursement Data policy alerts

Medicaid: Total Revenue Breakdown by CPT/HCPCS Code

Medicaid: Complete Services Breakdown

Medicaid: Competitive Analysis & Benchmarks

Related Providers

Nearby Providers

Frequently Asked Questions

References