FIELD GUIDE / MODERATE

Duplicate NPI detection for provider-directory teams

The same NPI may repeat legitimately or may be tied to conflicting names, entities, or locations. This guide applies the work to directory refresh files and recurring refreshes.

CHECK YOUR ROSTER

Upload your directory refresh file to deduplicate lookups while preserving every source row.

The same validator used on the homepage: local checksum checks, live public NPPES lookup, cautious differences, and clean export.

Go to upload

What the check needs to separate

Directories accumulate stale locations, taxonomy drift, duplicate profiles, and Type 1/Type 2 confusion. For duplicate npi detection, The same NPI may repeat legitimately or may be tied to conflicting names, entities, or locations.

In duplicate npi detection for provider-directory teams, recurring refreshes changes how a result should be interpreted. A public location does not prove that a provider currently accepts patients there.

Roster input to retainPublic NPPES evidence to append
directory_npipractice address
location_idprimary taxonomy
row IDpublic name
location IDentity type

FICTIONAL OPERATIONAL EXAMPLE

duplicate NPI detection in a fictional directory refresh file

Situation

During a fictional duplicate npi detection review, a directory refresh file contains 4,200 clinician and facility listings. One row for Morgan Rivera, DDS / North Mesa Dental reaches review because mailing address published as a practice location.

Input evidence

For this duplicate npi detection review, the source retains directory_npi, location_id, directory_npi for traceability.

Review action

Distinguish duplicate lookup keys from duplicate business records. The reviewer also checks recurring refreshes.

Common errors in this workflow

  1. 01source rows deleted
  2. 02format variants counted separately
  3. 03mailing address published as a practice location
  4. 04facility brand matched to an individual NPI

A defensible workflow

  1. 01

    Group normalized identifiers without deleting rows.

  2. 02

    Count source contexts.

  3. 03

    Fetch each valid NPI once. Retain display_name as operational context.

  4. 04

    Compare conflicting names and types.

  5. 05

    Rejoin evidence to every row.

REVIEW GUIDANCE

Use the result as evidence, not a verdict.

Distinguish duplicate lookup keys from duplicate business records. Preserve recurring refreshes as a separate consideration for provider-directory teams.

Limitations

Deduplication does not decide whether operational records should be merged. A public location does not prove that a provider currently accepts patients there.

QUESTIONS

What reviewers usually need to know

What should provider-directory teams do first?

Preserve the source row, normalize locally, and keep directory_npi before comparing public fields.

Should a difference be corrected automatically?

Usually not. Distinguish duplicate lookup keys from duplicate business records.

What does an NPPES match establish?

It confirms public fields returned at lookup time. A public location does not prove that a provider currently accepts patients there.

NEW VALIDATION01 / UPLOAD

Drop a provider roster here

CSV up to 10 MB · NPI is the only required field

NPIPROVIDERRESULT1861498248Jordan Lee, DO Fictional sample✓ MATCH1043297120North Shore Clinic Fictional sample! REVIEW
50providers free each month
No card required.
Do not upload patient information or PHI.

Primary references: CMS National Provider Identifiers and the NPI Registry API documentation. Public provider-reported data should be read with its source date and limitations.