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

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

Childrens Dentistry James F Collette Dds & David N. Hamilton Dds (NPI 1376869248)

Field	Value
Entity Type	Organization
Organization	Childrens Dentistry James F Collette Dds & David N. Hamilton Dds
Address	3911 W 27th Ave
City	Kennewick
State	WA
ZIP	99337
Taxonomy	Pediatric Dentistry
NPI Enumerated	April 15, 2010

Payer Source	Total Paid
Medicaid	$3.2M
Medicare	$0

Medicaid: Complete Services Breakdown

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

25 rows

CPT/HCPCS Code	Description	Claims	Avg Paid	Revenue
D2930	N/A	12,370	$140	$1.7M
D2929	N/A	1,330	$200	$268.7K
D0120	Periodic oral evaluation - established patient	7,550	$30	$188.8K
D1206	Topical Fluoride Treatment – Except Varnish; Therapeutic application for moderate to high caries risk patients	9,880	$20	$187.7K
D1120	Prophylaxis–child	9,540	$20	$181.2K
D9999	N/A	5,120	$30	$138.3K
D3220	N/A	1,160	$80	$93K
D0150	Comprehensive oral evaluation – new or established patient	2,680	$30	$91.2K
D1351	Sealant - per tooth	4,120	$20	$82.3K
D2392	Post 2 surface resin‑based composite	940	$70	$60.9K

Showing 1–10 of 25

Medicaid: Competitive Analysis & Benchmarks

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

Claims Volume vs. Washington Distribution

Childrens Dentistry James F Collette Dds & David N. Hamilton Dds — 0 of 25 codes billed far more than typical (above p95)

p5–p95 (all providers)p25–p75MedianThis providerOutlier

Rank Distribution — Washington

Full comparison — all codes billed, vs. Washington median

25 rows

CPT/HCPCS Code	Description	Rank	Provider Count	Median Claims	Avg Paid	Average Revenue
D2930	N/A	13	160	1,710	$140	$531.8K
D2929	N/A	10	30	620	$240	$350.5K
D2392	Post 2 surface resin‑based composite	282	540	990	$60	$188.6K
D0120	Periodic oral evaluation - established patient	156	920	690	$20	$131.3K
D2391	Resin‑based composite – one surface, posterior	362	480	670	$50	$119.5K
D1120	Prophylaxis–child	105	730	690	$20	$112.8K
D1351	Sealant - per tooth	110	400	1,120	$20	$103.9K
D7140	Extraction, erupted tooth or exposed root (elevation and/or forceps removal)	171	390	640	$50	$98.8K
D1206	Topical Fluoride Treatment – Except Varnish; Therapeutic application for moderate to high caries risk patients	112	730	730	$20	$98.5K
D3220	N/A	24	100	560	$80	$90.7K

Showing 1–10 of 25

Nearby Providers

Other providers in the same ZIP code as Childrens Dentistry James F Collette Dds & David N. Hamilton Dds, ranked by combined Medicare and Medicaid revenue.

Provider	State	Taxonomy	Medicare Revenue	Medicaid Revenue
Total Renal Care Inc	WA	End-Stage Renal Disease (ESRD) Treatment Clinic/Center	$0	$2.8M
Anja Rasmussen	WA	Physical Therapist	$280.4K	$0
Zachary Mcnair	WA	Physician Assistant	$51.1K	$0

Childrens Dentistry James F Collette Dds & David N. Hamilton Dds — Billing Profile & Reimbursement Data

Sign up for Childrens Dentistry James F Collette Dds & David N. Hamilton Dds — Billing Profile & Reimbursement Data policy alerts

Childrens Dentistry James F Collette Dds & David N. Hamilton Dds — Billing Profile & Reimbursement Data

Sign up for Childrens Dentistry James F Collette Dds & David N. Hamilton Dds — Billing Profile & Reimbursement Data policy alerts

Medicaid: Total Revenue Breakdown by CPT/HCPCS Code

Medicaid: Complete Services Breakdown

Medicaid: Competitive Analysis & Benchmarks

Nearby Providers

Frequently Asked Questions

References