Prospect List Builder

v20

NPI Registry · CMS Medicare PUF · QPP/MIPS · Open Payments · Ownership · 22 specialties · 26 states · I/DD vertical · NPPES Taxonomy Browser · Apollo + Supabase export · API Inspector

Target States (3 selected)

📍 Metro / Zip Search ACTIVE — overrides state

Specialty Taxonomy

Ad-hoc

🚫 Exclude Non-ICP (PE/Systems/Govt)

👥 Provider count

🏛 CMS Medicare PUF (2022/2023)

🧾 HCPCS by Service

💰 PPP (unavailable)

💊 Open Payments (2024)

🏆 QPP/MIPS

Min score: 0

💾

Previous build available

Initializing…

Total

PE Excl.

Medicare Hit

PPP Signal

MIPS Elig.

Open Pay

Showing

🔍

GradePracticeSTProvs Revenue Est.SpecialtyMedicare PaidSignalsActions

🔍

NPIProvider NameSpecialtyParent OrgSTZip

🔎 Quick Practice Search

Look up any practice by name — no build required. Good for checking a specific client, referral, or prospect in seconds. Pulls live from the NPI Registry.

🔍

📖 Field Guide — What Are You Looking At?

Every number and label on the Prospects table, explained in plain English. No healthcare finance background needed.

🔘 Button Guide — What Does Each Button Do?

Every button and link in the tool explained — including what works today and what's coming in a future version.

—

Total Medicare Allowed

—

Median per Org

—

Orgs w/ HCPCS Data

—

Top Org by Allowed $

🏢

🧾

↕ Grade ↕ Practice ↕ # Codes Top Code ↕ Svcs ↓ Total Allowed ↕ vs Median

↕ Grade ↕ Practice ↕ Code Description ↓ Services ↕ Allowed ($) ↕ Rank in Org

🎯 Intelligence

All orgs from this build — classified into Excluded, Watchlist, and Fast Track. Run a build to populate.

PracticeStateSpecialtyProvidersMedicare AllowedBucket ReasonSignal

Run a build to populate Intelligence.

🗄️ Data Sources

Live row counts + load timestamps from Supabase. Refresh cadence and next expected update.

Current Aging (>75% of cycle) Overdue Static (no refresh needed) Not yet loaded

TableStatusDescriptionRowsLast LoadedNext ExpectedSource

Click the tab to load data source status…

Download Links

NPPES Monthly Bulk ↗ Medicare PUF — By Provider ↗ Medicare PUF — By Service ↗ SBA PPP FOIA ↗ Open Payments ↗ Medicare PUF — By Geography ↗

Grading

A (≥68) — top ~12% of build

B (≥48) — next ~25%

C (≥28) — next ~30%

Revenue Methodology

CMS Medicare PUF (primary): Medicare allowed ÷ specialty Medicare ratio (12–38%) = total practice revenue range.

PPP 2021 (fallback): Loan ÷ 2.5 = avg monthly payroll × 12 ÷ 30–38% payroll/revenue ratio.

Provider est. (last resort): $280K–$420K per provider.

🔍 API Response Inspector

Run a build first, then open this panel. Each API call is captured here — paste into Claude to diagnose 0-hit issues without using F12.

No build run yet — click Build Prospect List first, then re-open this panel.

Ready for Outbound Generator

Copy this into the Outbound Message Generator to personalize your sequence.

🤖 Outreach Generator

Copy the prompt below into Claude or your AI outreach tool to generate personalized outreach for this practice.