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 Michigan for Medicaid) — rank 1 means the highest claims volume for that code.

Why is the Medicaid comparison limited to Michigan 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. Michigan (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.

Sparrow Carson Hospital (NPI 1336103043)

Sparrow Carson Hospital is a general acute care hospital provider located in Carson City, Michigan. This profile covers 0 Medicare and 131 Medicaid CPT/HCPCS procedure codes, with claims volume, average reimbursement, and total revenue by code, benchmarked against other providers billing the same services.

Medicaid: Complete Services Breakdown

Field	Value
Entity Type	Organization
Organization	Sparrow Carson Hospital
Address	406 East Elm Street
City	Carson City
State	MI
ZIP	48811
Taxonomy	General Acute Care Hospital
NPI Enumerated	April 12, 2006

Payer Source	Total Paid
Medicaid	$5.5M
Medicare	$0

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

131 rows

CPT/HCPCS Code	Description	Claims	Avg Paid	Revenue
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.	4,070	$310	$1.3M
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.	9,120	$120	$1.1M
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.	4,670	$190	$882.6K
96374	The provider administers a single medication or other substance rapidly into a vein to treat, prevent, or diagnose a condition.	3,450	$100	$341.1K
62323	The provider injects a diagnostic or a therapeutic substance, such as pain medication or a steroid, into the space around the spinal nerves of the lumbar (lower back) or sacral (caudal, or tailbone)…	980	$300	$288.6K
99282	The provider sees a patient for an emergency department visit involving evaluation and management (E/M). The visit involves a straightforward level of medical decision making.	2,350	$70	$167K
U0003	Infectious agent detection by nucleic acid (dna or rna); severe acute respiratory syndrome coronavirus 2 (sars-cov-2) (coronavirus disease [covid-19]), amplified probe technique, making use of high…	2,720	$50	$124.9K
G0463	Hospital outpatient clinic visit for assessment and management of a patient	2,080	$60	$122.9K
74177	The provider performs computed tomography of the abdomen and pelvis with contrast material to diagnose the cause of abdominal or pelvic pain or other abnormalities of the internal organs.	740	$150	$107.4K
96375	Following the administration of a drug or other substance via intravenous, or IV, push, the provider sequentially infuses a different medication or medications, also via IV push. He administers the…	2,860	$30	$94.4K

Showing 1–10 of 131

Medicaid: Competitive Analysis & Benchmarks

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

Claims Volume vs. Michigan Distribution

Sparrow Carson Hospital — 0 of 25 codes billed far more than typical (above p95)

p5–p95 (all providers)p25–p75MedianThis providerOutlier

Rank Distribution — Michigan

Full comparison — all codes billed, vs. Michigan median

131 rows

CPT/HCPCS Code	Description	Rank	Provider Count	Median Claims	Avg Paid	Average Revenue
G0463	Hospital outpatient clinic visit for assessment and management of a patient	96	150	5,330	$50	$2.8M
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.	154	400	1,510	$190	$2.6M
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.	193	480	1,350	$110	$1.7M
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.	157	450	1,540	$90	$1.3M
96374	The provider administers a single medication or other substance rapidly into a vein to treat, prevent, or diagnose a condition.	100	150	7,610	$90	$1.2M
U0003	Infectious agent detection by nucleic acid (dna or rna); severe acute respiratory syndrome coronavirus 2 (sars-cov-2) (coronavirus disease [covid-19]), amplified probe technique, making use of high…	79	160	2,720	$60	$546.6K
74177	The provider performs computed tomography of the abdomen and pelvis with contrast material to diagnose the cause of abdominal or pelvic pain or other abnormalities of the internal organs.	150	230	2,380	$90	$490K
96361	The provider administers intravenous, or IV, fluids with electrolytes through an already established intravenous route for each additional hour to treat more severe dehydration.	101	140	5,720	$40	$381.8K
99282	The provider sees a patient for an emergency department visit involving evaluation and management (E/M). The visit involves a straightforward level of medical decision making.	140	260	2,670	$70	$348.7K
96365	The provider administers the initial intravenous infusion of a medication or other substance for a period up to one hour to prevent, treat, or diagnose a condition or disease.	121	170	2,390	$80	$345K

Showing 1–10 of 131

Provider	State	Taxonomy	Medicare Revenue	Medicaid Revenue
Vishal Saini	MI	Sleep Medicine (Family Medicine) Physician	$142.8K	$0
Roy Miller	MI	Urology Physician	$78.7K	$0
Asad Mehboob	AR	Gastroenterology Physician	$69.2K	$0
Joseph Rakowski	MI	Gynecologic Oncology Physician	$35.2K	$0
Rachel Seavolt	MI	Family Nurse Practitioner	$33.7K	$0
Eric Nelson	SC	Anesthesiology Physician	$17K	$0
Ashley Agerson	MI	Anesthesiology Physician	$2.7K	$0

Sparrow Carson Hospital — Billing Profile & Reimbursement Data

Sign up for Sparrow Carson Hospital — Billing Profile & Reimbursement Data policy alerts

Sparrow Carson Hospital — Billing Profile & Reimbursement Data

Sign up for Sparrow Carson Hospital — Billing Profile & Reimbursement Data policy alerts

Medicaid: Total Revenue Breakdown by CPT/HCPCS Code

Medicaid: Complete Services Breakdown

Medicaid: Competitive Analysis & Benchmarks

Related Providers

Frequently Asked Questions

References