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

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

John Mercado (NPI 1700548096)

Field	Value
Entity Type	Individual
Organization	John Mercado
Address	1200 S Cedar Crest Blvd Fl 2
City	Allentown
State	PA
ZIP	18103
Taxonomy	Certified Registered Nurse Anesthetist
NPI Enumerated	October 13, 2021

Payer Source	Total Paid
Medicare	$11K
Medicaid	$0

Medicare: Complete Services Breakdown

The CPT/HCPCS codes generating the most Medicare revenue for this provider.

7 rows

CPT/HCPCS Code	Description	Claims	Avg Paid	Revenue
00790	The provider performs anesthesia services for a patient undergoing intraperitoneal procedures in the upper abdomen, including laparoscopy, which are not specified by any other anesthesia code.	20	$160	$2.8K
00840	The provider performs anesthesia services for a patient undergoing intraperitoneal procedures in the lower abdomen, including laparoscopy, which are not specified by any other anesthesia code.	10	$130	$1.8K
00918	The provider performs anesthesia services for a patient undergoing fragmentation, manipulation, and/or removal of a ureteral calculus. The surgical provider accesses the ureter through the urethra,…	20	$80	$1.5K
01844	The provider performs anesthesia services for a patient undergoing a vascular shunt procedure, or shunt revision of any type, such as for dialysis.	10	$120	$1.5K
00731	The anesthesia provider performs anesthesia services for an unspecified type of upper gastrointestinal endoscopic procedure during which another provider introduces the endoscope to but not beyond…	20	$70	$1.4K
00813	The anesthesia provider performs anesthesia services for a patient undergoing both upper and lower intestinal endoscopy where the surgical provider introduces an endoscope into the intestines above…	20	$70	$1.2K
00811	The provider performs anesthesia services for a patient undergoing an unspecified lower intestinal endoscopic procedure where the surgical provider introduces an endoscope into the intestines up to…	10	$60	$840

Medicare: Competitive Analysis & Benchmarks

How this provider's Medicare billing volume and revenue compare to other providers nationally and within its state, across 7 CPT/HCPCS codes.

View: State1 / 2

Claims Volume vs. Pennsylvania Distribution

John Mercado — 0 of 7 codes billed far more than typical (above p95)

p5–p95 (all providers)p25–p75MedianThis providerOutlier

Rank Distribution — Pennsylvania

Full comparison — all codes billed, vs. state median

7 rows

CPT/HCPCS Code	Rank	Provider Count	Median Claims	Avg Paid	Average Revenue
01844	26	30	20	$140	$6.7K
00811	626	2,050	20	$70	$2.8K
00790	56	390	10	$160	$2.4K
00813	248	830	20	$80	$2.2K
00731	560	2,360	20	$70	$2.1K
00840	54	260	10	$140	$2.1K
00918	8	100	20	$90	$1.6K

John Mercado — Billing Profile & Reimbursement Data

Sign up for John Mercado — Billing Profile & Reimbursement Data policy alerts

John Mercado — Billing Profile & Reimbursement Data

Sign up for John Mercado — Billing Profile & Reimbursement Data policy alerts

Medicare: Total Revenue Breakdown by CPT/HCPCS Code

Medicare: Complete Services Breakdown

Medicare: Competitive Analysis & Benchmarks

Frequently Asked Questions

References