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

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

Walgreen Co (NPI 1366823114)

Field	Value
Entity Type	Organization
Organization	Walgreen Co
Address	615 Piikoi St Ste 105
City	Honolulu
State	HI
ZIP	96814
Taxonomy	Pharmacy
NPI Enumerated	June 17, 2015

Payer Source	Total Paid
Medicaid	$25.3M
Medicare	$0

Key Findings

This provider is effectively single-payer in its public claims footprint: there is no Medicare billing on file (no Medicare billing on file) while Medicaid revenue totals $25.3M, indicating the entirety of reported public-payer activity is Medicaid-driven. Analysts should treat Medicaid as the primary payer when assessing this entity’s public reimbursement exposure and network value.

Revenue concentration is extreme: the precomputed top-3 Medicaid codes account for 100.0% of this provider’s total Medicaid revenue, showing that a very small set of codes drives all reported Medicaid dollars. This level of concentration suggests the provider’s Medicaid business is dominated by a narrow set of services or product lines rather than a broad mix of reimbursable items.

The single largest revenue driver is J3490 (Unclassified drugs), with 7.3K claims, a $3312 avg paid/claim, and $24.2M revenue, representing 95.7% of the provider’s Medicaid revenue. Despite this outsized share, the provider ranks #11 of 49 in-state (79th percentile; typical, unremarkable volume for this code), implying that while J3490 dominates the provider’s book of business, its activity level for that code is not unusually high relative to other in-state pharmacies.

The second code, J3031 (injection, fremanezumab-vfrm), accounts for 1.5K claims, a $707 avg paid/claim, and $1M revenue (4.1% of Medicaid revenue). The provider ranks #1 of 2 in-state (100th percentile; typical, unremarkable volume for this code), meaning it is a top-ranked dispenser of this specific biologic in the state but the underlying volume is still characterized as typical for in-state peers rather than an extreme outlier.

Durable medical equipment activity exists but is a very small share of Medicaid revenue: E0603 (breast pump, electric) shows 261 claims, a $213 avg paid/claim, and $55.6K revenue (0.2% of Medicaid revenue), ranking #8 of 11 in-state (30th percentile; typical, unremarkable volume for this code). This supports a service-line mix that includes some DME dispensing in addition to drug dispensing, but DME is not a material revenue driver.

Operational profile implied by the code mix is consistent with a retail/dispensing pharmacy that also bills for high-cost drug administrations and certain DME items. Dominance of J3490 (an unclassified drug code often used for expensive or miscellaneous pharmaceuticals) combined with J3031 (a migraine biologic) points to substantial specialty drug handling or pharmacy distribution of high-cost injectables rather than primarily point-of-care procedures.

Several procedure codes in the submitted list (for example 0002A, 0004A, 0054A, 0001A) show claims but report $0 avg paid/claim and $0 revenue; these entries collectively contribute 0.0% of Medicaid revenue. These zero-paid claim lines are measurable in the claim counts and should be reviewed as administrative or non-revenue claim activity when reconciling utilization versus paid dollars.

Tenure is established but not long-standing: the NPI was enumerated on 2015-06-17 (~11 years ago), giving the provider about a decade of registered activity. Combine this tenure with the concentrated Medicaid footprint to infer that its public-payer presence has likely been stable for multiple years but concentrated in a narrow set of reimbursed products and codes.

Medicaid: Complete Services Breakdown

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

8 rows

CPT/HCPCS Code	Description	Claims	Avg Paid	Revenue
J3490	Unclassified drugs	7,320	$3,310	$24.2M
J3031	Injection, fremanezumab-vfrm, 1 mg (code may be used for medicare when drug administered under the direct supervision of a physician, not for use when drug is self-administered)	1,450	$710	$1M
E0603	Breast pump, electric (ac and/or dc), any type	260	$210	$55.6K
A9274	External ambulatory insulin delivery system, disposable, each, includes all supplies and accessories	20	$210	$3.2K
0001A	N/A	140	$0	$0
0002A	N/A	160	$0	$0
0004A	N/A	30	$0	$0
0054A	N/A	20	$0	$0

Medicaid: Competitive Analysis & Benchmarks

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

Claims Volume vs. Hawaii Distribution

Walgreen Co — 1 of 4 codes billed far more than typical (above p95)

p5–p95 (all providers)p25–p75MedianThis providerOutlier

Rank Distribution — Hawaii

Full comparison — all codes billed, vs. Hawaii median

8 rows

CPT/HCPCS Code	Description	Rank	Provider Count	Median Claims	Avg Paid	Average Revenue
J3490	Unclassified drugs	11	50	160	$200	$740.3K
J3031	Injection, fremanezumab-vfrm, 1 mg (code may be used for medicare when drug administered under the direct supervision of a physician, not for use when drug is self-administered)	1	10	750	$700	$525.5K
A9274	External ambulatory insulin delivery system, disposable, each, includes all supplies and accessories	3	10	500	$520	$402.8K
E0603	Breast pump, electric (ac and/or dc), any type	8	10	360	$100	$71.5K
0002A	N/A	37	70	160	$40	$20.8K
0001A	N/A	41	80	140	$30	$18.4K
0004A	N/A	41	50	50	$30	$5.6K
0054A	N/A	28	40	80	$30	$4.5K

Related Providers

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

Provider	State	Taxonomy	Medicare Revenue	Medicaid Revenue
Walgreen Co	HI	Pharmacy	$139.1K	$110
Walgreen Co	HI	Pharmacy	$105.3K	$200
Walgreen Co	HI	Pharmacy	$96.6K	$3.2K
Walgreen Co	HI	Pharmacy	$92.8K	$730
Walgreen Co	HI	Pharmacy	$91.5K	$0
Walgreen Co	HI	Pharmacy	$54.4K	$0

Nearby Providers

Other providers in the same ZIP code as Walgreen Co, ranked by combined Medicare and Medicaid revenue.

Provider	State	Taxonomy	Medicare Revenue	Medicaid Revenue
Mastercare Inc	HI	Nursing Care Agency	$0	$10.8M
Attention Plus Private Nursing, Inc.	HI	Nursing Care Agency	$0	$7.7M
Heaven's Helpers, Inc.	HI	In Home Supportive Care Agency	$0	$4.5M
Heaven's Helpers, Inc.	HI	Nursing Care Agency	$0	$4M
Honolulu Imaging Center, LLC	HI	Diagnostic Radiology Physician	$2.6M	$1.1M
Eugene W M Ng Md LLC	HI	Ophthalmology Physician	$0	$3.7M
Bayada Home Care	HI	In Home Supportive Care Agency	$0	$3.6M
B Homecare L.L.C.	HI	In Home Supportive Care Agency	$0	$3.5M
Hawaii Diagnostic Radiology Services LLC	HI	Diagnostic Radiology Physician	$0	$3.2M
Dean T. Sueda Dds.ms, Inc	HI	Pediatric Dentistry	$0	$3.1M

Walgreen Co — Billing Profile & Reimbursement Data

Sign up for Walgreen Co — Billing Profile & Reimbursement Data policy alerts

Walgreen Co — Billing Profile & Reimbursement Data

Sign up for Walgreen Co — Billing Profile & Reimbursement Data policy alerts

Key Findings

Medicaid: Total Revenue Breakdown by CPT/HCPCS Code

Medicaid: Complete Services Breakdown

Medicaid: Competitive Analysis & Benchmarks

Related Providers

Nearby Providers

Frequently Asked Questions

References