
Delaware Healthcare Provider Database
Counts as of the September 15, 2025 update.

The CarePrecise Delaware healthcare provider list delivers data on Delaware healthcare providers from the CarePrecise Access Complete U.S. Healthcare Provider Database — all 22,388
Delaware provider records — including federal NPI registry data, enhanced with data from the federal PECOS (Medicare) database and other public and proprietary sources. All providers in Wilmington, Dover, Newark, Middletown, Smyrna, and all other locations in Delaware are included. This is similar to our CarePrecise Access Complete data set, but for an individual state, with the added bonus of an easy-to-use Excel® file with basic information on all HIPAA-covered healthcare practitioners and organizations in Delaware, including physicians, hospitals, etc. See the CarePrecise Access Complete page for additional description, or to review purchasing the full U.S. database instead.
Get personal with providers: CarePrecise Preferred Email can put you in touch!
PRICING & ORDER FORM
Single download. If you'd like to order a subscription, please call (877) 782-2294
Every HIPAA-covered healthcare provider in the state is included:
|
|
What's in the Microsoft Excel HCP file?
With CarePrecise State, you get both an Excel file with the most important data columns for healthcare providers in Delaware, plus a Microsoft Access database. The Excel file is a bonus available only with CarePrecise State and CarePrecise Select products, because there are more than 8.8 million records in the full U.S. database, and Excel can handle only about 1 million records.
The Excel file is a single flat file containing all of the medical providers' demographic information and primary specialty for the approximately 22,388 Delaware state healthcare provider records. Name and address columns are in proper case, ready for professional communications and upload to direct mail services. The phone and fax columns are ready for upload to telemarketing and fax marketing services. Email addresses are not included in state databases. See our verified email custom list pricing here.
ADVANCED data sample: Click to download
CarePrecise also offers specialized data packages, including the ScribeFax Clinician Fax Database, with deeply-mined and verified fax numbers for U.S. prescribing clinicians, and ScriptFax, deeply-mined and verified pharmacy fax numbers. CP Preferred Email offers email addresses for U.S. healthcare providers with a 95% deliverability guarantee.
Excel Healthcare Provider Data Layout
Swipe left to view all...
NPI | EntityType | Salutation | AttnName | Title | CompanyName | Addr1 | Addr2 | City | State | Zip | Country | Zip5 | County | RuralUrban | Wealth | Latitude | Longitude | Gender | PracPhone | PracFax | MailPhone | MailFax | EnumDate | UpdateDate | IsOrgSubpart | IsSoleProp | InPECOS | Warning | Group | NamePrefix | NameLast | NameFirst | NameMiddle | NameSuffix | Credential | Taxo | TaxoDescr | CoLoCode |
National Provider Identifier number | 1=Indiv, 2=Org | Salutation | Full Name | Title | Company name* | Practice Address Line 1 | Practice Address Line 2 | City | State | Zip+4 | Country | 5-digit Zip Code | County | Rural, urban or other area | Wealth level of service area | Practice Zip Latitude | Practice Zip Longitude | M, F or unknown | Practice Address Phone | Practice Address Fax | Mailing Address Phone | Mailing Address Fax | Date NPI was received | Date record was last updated | Is part of another org?* | Sole Proprietor?* | Enrolled to bill Medicare? | May have infraction | Is this a practice group record? | Mr., Ms., etc. | Last Name | First Name | Middle Name | Jr., III, etc. | Credential | Taxonomy Code | Taxonomy Description (Specialty) | CoLoCode™: hyper-conformed practice location |
*Company name is included for Type 2 (organization) records, and may be requested for Type 1 (individuals) at an additional charge, and will be found algorithmically. IsOrgSubpart is found only for Type 2 records. IsSoleProp is found only for Type 1 records. |
What's in the Basic database?
In addition to the easy-to-use Excel file, we include an Access database with data from our CarePrecise Access Complete database, with comprehensive information on Delaware's approximately 22,388 HIPAA-covered healthcare providers.
The CarePrecise Delaware Microsoft Access database is structured as separate normalized relational database tables, each keyed by the National Provider Identifier (NPI) number, plus a core Access database that links the files together and includes query examples. CSV versions of the data files are included for use with other platforms and database software. Email addresses are not included in state databases. See our verified email custom list pricing here.
Scroll vertically to view all...
|
What's in the Advanced database?
Like the Basic state database, the Advanced version includes the Excel file with basic data on the entire state's HIPAA-covered healthcare providers, plus Group Practice affiliations, Hospital Affiliations, Graduation Year, and other extended data for actively-billing clinicians (physicians and others whose services are billed to Medicare). Here's the data included in the Advanced version (scroll down in the box to see the additional data tables, highlighted in blue):
CPAC (CarePrecise Access Complete) data is sourced and merged from the NPPES, PECOS and LEIE databases, keyed on the NPI. Every record has a unique NPI, and the NPI is used to link the relational tables together. The CPAC dataset is updated monthly. | ||||||||||||||
CPAC | tAddresses
(Provider addresses; |
NPI | National Provider Identifier (unique National Provider Identifier assigned to healthcare providers by the US Department of Health and Human Services) | Relational Key
The NPI is a unique 10-digit numerical code assigned to every HIPAA-covered healthcare provider, including individuals and organizations, by the U.S. Department of Human Services, Centers for Medicare and Medicaid Services (CMS). |
||||||||||
Mail1stAddr | Provider First Line Business Mailing Address | |||||||||||||
Mail2ndAddr | Provider Second Line Business Mailing Address | |||||||||||||
MailCity | Provider Business Mailing Address City Name |
|||||||||||||
MailState | Provider Business Mailing Address State Code | |||||||||||||
MailZip | Provider Business Mailing Address Postal Code (most are 9-digit Zip Codes) | |||||||||||||
MailCountry | Provider Business Mailing Address Country Code (If outside U.S.) | |||||||||||||
Prac1stAddr | Provider First Line Business Practice Location Address | |||||||||||||
Prac2ndAddr | Provider Second Line Business Practice Location Address | |||||||||||||
PracCity | Provider Business Practice Location Address City Name | |||||||||||||
PracState | Provider Business Practice Location Address State Code | |||||||||||||
PracZip | Provider Business Practice Location Address Postal Code (most are 9-digit Zip Codes) | |||||||||||||
PracCountry | Provider Business Practice Location Address Country Code (If outside U.S.) | |||||||||||||
CPAC | tOtherPracticeLocations
Additional (secondary) practice locations for Type 2 providers; Table is not provided in custom data pulls (CarePrecise Select services). |
NPI | National Provider Identifier | Relational Key (composite) | ||||||||||
SecondaryPracAddr1 | First line of street address | Relational Key (composite) | ||||||||||||
SecondaryPracAddr2 | Second line of street address | |||||||||||||
SecondaryPracCity | City Name |
|||||||||||||
SecondaryPracState | State Code | |||||||||||||
SecondaryPracZip | Postal Code (most are 9-digit Zip Codes) | |||||||||||||
SecondaryPracCountry | Country Code (If outside U.S.) | |||||||||||||
SecondaryPracPhone | Location Phone Number | |||||||||||||
SecondaryPracPhoneExt | Location Phone Extension | |||||||||||||
SecondaryPracFax | Location Fax Number | |||||||||||||
SecondaryLocationDate | Location Date |
|
||||||||||||
CPAC | tEntity |
NPI | National Provider Identifier | Relational Key | ||||||||||
EntityType | Entity Type Code | Type 1 indicates an individual provider (i.e., physician, psychologist, etc.); Type 2 indicates an organizational provider (i.e., hospital, lab, pharmacy, etc.). Type1 entities (individuals) may have only one NPI number and so only one record, but Type 2 entities (organizations) may have multiple NPI numbers and thus multiple records. Click here to download the Exclusion Type Code description document...
|
||||||||||||
ReplacementNPI | Replacement NPI | Not currently populated | ||||||||||||
EIN | Employer Identification Number (EIN) | Not currently populated. CMS is not yet providing tax numbers of this type. | ||||||||||||
EnumDate | Provider Enumeration Date | Date the record was first added to the NPI registry | ||||||||||||
UpdateDate | Last Update Date | Date this provider NPI record was last updated | ||||||||||||
DeactReason | NPI Deactivation Reason Code | Not populated because records in the current dataset are not deactivated. Not currently disclosed by CMS. | ||||||||||||
DeactDate | NPI Deactivation Date | Not populated because records in this table are not deactivated. This field IS populated in the separate delta table tEntity_DEACT, described below. | ||||||||||||
ReactDate | NPI Reactivation Date | Date record was reactivated following a deactivation. | ||||||||||||
Gender | Provider Gender Code | M or F for Type 1 providers | ||||||||||||
IsSoleProp | Is Sole Proprietor | Y = provider operates as a sole proprietor. No = not a sole proprietorship. X = question not answered by provider. | ||||||||||||
IsOrgSubpart | Is Organization Subpart | For Type 2 providers, may be one of several organizational units, each with its own NPI number. Y = provider is a subpart. No = not a subpart. X = question not answered.
|
||||||||||||
ParentOrgTIN | Parent Organization TIN | Not currently populated. CMS is not currently providing tax numbers at this time.
|
||||||||||||
InPECOS | From monthly CMS PECOS distributions of PECOS-enrolled providers. Source: PECOS Ordering and Referring Report file distribution. | Y = Physicians and non-physician practitioners who are of a type/specialty that is legally eligible to order and refer in the Medicare program and who have current enrollment records in Medicare (i.e., they have enrollment records in PECOS)
|
||||||||||||
Warning | From the Office of Inspector General's excluded providers database (LEIE), indicatying a sanction prevents the provider from billing Medicare. A warning in this field should not be taken as definitive; the user should check the tExcluded table and consider other sources of provider fraud and exclusion information. Up until the May 2017 release, this field was algorithmically derived for some records.*
|
Y= elements in the providers record indicated a match with a listing in the federal excluded providers database (see the table tExcluded below)
|
||||||||||||
ExclType | The exclusion type from the LEIE database, explaining the reason that a provider was barred from billing Medicare. Fields with a Y in the Warning field will display this code.
|
The code's definition can be found at this link. A CSV file listing these exclusion descriptions is included in the CarePrecise Access Complete CSV download file.
|
||||||||||||
ExclDate | The date of the exclusion from the LEIE database, where reported.
|
|
||||||||||||
UPIN | UPIN is a deprecated identifier, no longer used. CMS has stopped disseminating this data. The field remains here for purposes of backward-compatibility.
|
|
||||||||||||
Group | From NPPES group taxonomy data | Y= this provider reported that it operates as either a multi-specialty group or single-specialty group.
|
||||||||||||
County | Name of county primarily associated with the practice Zip Code | |||||||||||||
Zip5 | First five digits of practice address Zip Code | |||||||||||||
CPAC | tEntity-B (Provider entity and record information; MDB and CSV formats) |
NPI | National Provider Identifier | Relational Key | ||||||||||
CertDate | Date of certification of provider's NPI number | New field added with December 9, 2019 data release, refers to the date the NPI record was officially certified. | ||||||||||||
EstPracYears | Estimated years provider has been in practice | Algorithmically derived* from EPGH tExtendedPhysician.GradYear and/or CPAC tEntity.EnumDate 2009 forward. |
||||||||||||
Placekey | Deprecated field | As announced in the December 2025 and January 2025 releases, this is a deprecated field. It will remain in the file to maintain compatibility. The CarePrecise CoLoCode provides the same functionality in matching records, and is less prone to compatibility issues. | ||||||||||||
CPAC | tEntity-C (Market data; MDB and CSV formats) |
NPI | National Provider Identifier | Relational Key | ||||||||||
CountyFIPS | Practice county FIPS code | |||||||||||||
StateFIPS | Practice state FIPS code | |||||||||||||
TimeZone | Practice time zone | |||||||||||||
DLSTime | Observes daylight saving time; Y= Yes | |||||||||||||
MSA | Metropolitan Statistical Area of practice location | |||||||||||||
PMSA | Primary Metropolitan Statistical Area of practice location | |||||||||||||
Population | Practice Zip Code population | |||||||||||||
CPAC | tHumanNames (Provider person names or contact person names; MDB and CSV formats) |
NPI | National Provider Identifier | Relational Key | ||||||||||
LN | Provider Last Name (Legal Name) | The enumerated individual provider's name (for Entity Type 1 records) | ||||||||||||
FN | Provider First Name | |||||||||||||
MN | Provider Middle Name | |||||||||||||
PN | Provider Name Prefix Text | |||||||||||||
SN | Provider Name Suffix Text | |||||||||||||
Cred | Provider Credential Text | |||||||||||||
OthLN | Provider Other Last Name | Other name Type Codes:
|
||||||||||||
OthFN | Provider Other First Name | |||||||||||||
OthMN | Provider Other Middle Name | |||||||||||||
OthPN | Provider Other Name Prefix Text | |||||||||||||
OthSN | Provider Other Name Suffix Text | |||||||||||||
OthCred | Provider Other Credential Text | |||||||||||||
OthLNType | Provider Other Last Name Type Code | |||||||||||||
AuthLN | Authorized Official Last Name (Contact person for a Type 2 organization record) | Name of the provider's authorizing official, if other than the listed individual provider. For organizations (Entity Type 2 records), this is the contact name.
|
||||||||||||
AuthFN | Authorized Official First Name | |||||||||||||
AuthMN | Authorized Official Middle Name | |||||||||||||
AuthTitle | Authorized Official Title or Position | |||||||||||||
AuthPN | Authorized Official Name Prefix Text | |||||||||||||
AuthSN | Authorized Official Name Suffix Text | |||||||||||||
AuthCred | Authorized Official Credential Text
|
|||||||||||||
CPAC | tOID | NPI | National Provider Identifier | Relational Key | ||||||||||
(Other identifiers, such as UPIN, OSCAR, PIN, Medicaid, etc., excluding NPI and taxonomy codes; MDB and CSV formats) One-to-many table. | OtherID | Other Provider Identifier | Identifier relevant to external data | |||||||||||
OtherIDType | Other Provider Identifier Type Code |
|
||||||||||||
OtherIDState | Other Provider Identifier State | In the case of a state license code, this is the licensing state | ||||||||||||
OtherIDIssuer | Other Provider Identifier Issuer | |||||||||||||
OIDnum | Source: Added by CarePrecise to indicate the original NPPES flat file Other Identifiers field number. | The number of the NPPES Other Identifier field (1 through 50)
|
||||||||||||
CPAC | tOrgNames
(Provider organization names for Type 2 providers; MDB and CSV formats)
|
NPI | National Provider Identifier | Relational Key | ||||||||||
OrgName_LBN | Provider Organization Name (Legal Business Name) | LBN (for Entity Type 2 records) | ||||||||||||
OthOrgName | Provider Other Organization Name | Other | ||||||||||||
OthOrgNameType | Provider Other Organization Name Type Code |
|
||||||||||||
ParentOrgLBN | Parent Organization LBN | |||||||||||||
CPAC | tOtherOrgNames
Alternative org names beyond those lited in tOrgNames; MDB and CSV formats. One-to-many table. Table is not provided in custom data pulls (CarePrecise Select services). |
NPI | National Provider Identifier | Relational Key (composite) | ||||||||||
OtherOrgName | Other Organization Aame | Relational Key (composite) | ||||||||||||
OtherOrgNameType | Other Organization Name Type | Relational Key (composite)
|
||||||||||||
CPAC | tPhoneFax
(Provider phone and fax numbers; fax numbers for approx. 65% of records; MDB and CSV formats)
|
NPI | National Provider Identifier | Relational Key | ||||||||||
MailPhone | Provider Business Mailing Address Telephone Number | |||||||||||||
MailFax | Provider Business Mailing Address Fax Number | |||||||||||||
PracPhone | Provider Business Practice Location Address Telephone Number | |||||||||||||
PracFax | Provider Business Practice Location Address Fax Number | |||||||||||||
AuthPhone | Authorized Official Telephone Number
|
|||||||||||||
CPAC | tTaxo
(Provider Taxonomy codes indicating specialties and subspecialties for Type 1/individual providers, and facility types for Type 2/organization providers; MDB and CSV formats). One-to-many table.
|
NPI | National Provider Identifier | Relational Key | ||||||||||
Taxo | Healthcare Provider Taxonomy Code (Specialties and Facilty Types) | Providers may have multiple taxonomies reported here, and thus multiple records in this one-to-many table. The Taxonomy Code indicates the provider's specialty; i.e., Pediatrician, Optometrist, etc.; or facility type; i.e., Hospital, Clinic, Nursing Facility, etc. | ||||||||||||
Lic | Provider License Number | For Type 2 (organization) providers, License is no longer collected as of 9/10/2018. | ||||||||||||
LicState | Provider License Number State Code | For Type 2 (organization) providers, License is no longer collected as of 9/10/2018. | ||||||||||||
TaxoSwitch | Healthcare Provider Primary Taxonomy Switch (Primary specialty indicator) | "Y" means this is the provider's primary specialty or facility code. | ||||||||||||
Tnum | Source: Added by CarePrecise to indicate the original NPPES flat file Taxonomy Code (specialty) field number. | The number of the NPPES taxonomy field (1 through 15). If a primary taxonomy is not indicated, it may be useful to assume that the first-listed code (1) is primary.
|
||||||||||||
TaxoDescr | Taxonomy code description (the specialty/subspecialty in English)
|
|||||||||||||
CPAC | tTaxoGroups(Provider Taxonomy codes indicating group practices; MDB and CSV formats). One-to-many table. | NPI | National Provider Identifier | Relational Key | ||||||||||
Gnum | The source data (NPPES) permits group codes to be reported in up to 15 fields in this section. CarePrecise creates a one-to-many table, listing each of a provider's reported taxonomy group codes in a separate record. The Gnum is the NPPES Group Taxonomy field number in which the code was reported, allowing the code be matched with the specific group specialty in the tTaxo table. For instance, a code in tTaxoGroup field Gnum 3 indicates a group practice of the specialty reported in Tnum 3 in the tTaxo table.
|
CMS does not report the group codes in the taxonomy section (which appear in our tTaxo table) because they represent an additional layer of information on any one or more of the tTaxo codes.
|
||||||||||||
TaxoGroup | Healthcare Provider Taxonomy Group_[1 through 15] | 193200000X for a multi-specialty practice 193400000X for a single-specialty practice
|
||||||||||||
CPAC | tCoLoCode(MDB and CSV formats) | NPI | National Provider Identifier | Relational Key (composite) | ||||||||||
CoLoCode™ | Provider CoLoCode™ (co-location code, a CarePrecise algorithmically derived* exclusive). The NPI and CoLoCode comprise the dual relational key for this table. The NPI identifies the provider record, and the CoLoCode identifies the physical location. The CoLoCode is an up to 40-character string that stands in for detailed location data, and is not intended to be sensical to the human viewer.
|
Relational Key (composite) This code is an algorithmically derived conformation of the provider's practice location, permitting identification of providers who practice at the same location, for instance, physician groups, dental groups, radiology groups, etc. By using this table in conjunction with the tTaxoGroups table, it is possible to visualize the group entity (generally an organization) and its provider members. CoLoCodes are created for Practice addresses in the United States (US) and US Minor Islands (UM).
|
||||||||||||
Count | Count of providers matching this co-location (algorithmically derived* conformation of the provider's practice location; see tCoLoCodes above). Indicates the number of providers practicing at this location. |
|||||||||||||
CPAC | tAdded (CPAC records only) (MDB and CSV formats)Table is not provided in custom data pulls (CarePrecise Select services) |
NPI | National Provider Identifier | Relational Key (composite) | ||||||||||
DateDiscovered | Relational Key (composite) The CarePrecise processing date on which the added provider record was discovered. Corresponds to the most recent previous CMS update date on which the added provider data was included in the NPPES database. Unduplicative index key is dual; NPI and DateDiscovered.
|
|||||||||||||
CPAC | tDropped
(CPAC records only) Table is not provided in custom data pulls (CarePrecise Select services) (MDB and CSV formats) |
NPI | National Provider Identifier | Relational Key (composite) | ||||||||||
DateDiscovered | Relational Key (composite) The CarePrecise processing date on which it was discovered that the provider record was dropped from the NPPES database. Corresponds to the most recent previous CMS update date on which the provider data was dropped from the NPPES database. Unduplicative index key is dual; NPI and DateDiscovered.
|
|||||||||||||
EntityType | Entity Type Code | Type 1 is individual providers (i.e., physicians, psychologists, etc.); Type 2 is organizational providers (i.e., hospitals, labs, etc.)
|
||||||||||||
ProvName | This is a generated field based on EntityType.
|
|||||||||||||
Prac1stAddr | Provider First Line Business Practice Location Address | |||||||||||||
Prac2ndAddr | Provider Second Line Business Practice Location Address | |||||||||||||
PracCity | Provider Business Practice Location Address City Name | |||||||||||||
PracState | Provider Business Practice Location Address State Name | The federal data contains variations on state codes, abbreviations and full state names; we conform this field to standard 2-character state codes. A small number of non-US postal addresses remain nonconforming.
|
||||||||||||
PracZip | Provider Business Practice Location Address Postal Code | |||||||||||||
PracCountry | Provider Business Practice Location Address Country Code (If outside U.S.) | |||||||||||||
PracPhone | Provider Business Practice Location Address Telephone Number | |||||||||||||
EnumDate | Provider Enumeration Date | |||||||||||||
UpdateDate | Last Update Date | Date this provider NPI record was last updated
|
||||||||||||
CPAC | tExcluded
(MDB and CSV formats) Table is not provided in custom data pulls (CarePrecise Select services) |
LN | Last name (Type 1 providers) | This table, sourced from the LEIE, lists all provider records in the federal excluded providers database. A provider may be excluded (barred from billing Medicare) for reasons of a criminal nature, among other reasons. This table contains no relational key; however, it is used to produce the Warning field in the tEntity table, which does include the provider's NPI. This table should be referenced for backup information.
|
||||||||||
FN | First name (Type 1 providers) | |||||||||||||
MN | Middle Name (Type 1 providers) | |||||||||||||
OrgName | Organization name (Type 2 providers) | |||||||||||||
Addr | Street address | |||||||||||||
City | City | |||||||||||||
State | State | |||||||||||||
Zip | Zip Code | |||||||||||||
DOB | Date of Birth. Not currently populated. CMS is not providing tax numbers at this time. | |||||||||||||
General | Provider category | |||||||||||||
Specialty | Provider specialty | |||||||||||||
UPIN | Federal physician identifier code (legacy) | |||||||||||||
ExclType | Exclusion type (why provider was excluded) | |||||||||||||
ExclDesc | Exclusion Description | |||||||||||||
ExclDate | Date provider was excluded (YYYYMMDD)
|
|||||||||||||
CPAC | tDeact
(MDB and CSV formats; CPAC records only) Table is not provided in custom data pulls (CarePrecise Select services)
|
NPI | National Provider Identifier | Relational Key (composite) This data is provided by CMS, listing all NPI records that have been deactivated and the deactivation date. Unduplicative index key is dual; NPI and DeactDate. Please note that a record may be added to the Deactivated tables, but then later be reactivated. Also note that Type 2 records (organizations) may have multiple records; some may be deactivated while others are active. When a record is reactivated it will appear in the tAdded table.
|
||||||||||
DeactDate | Date CMS deactivated the provider's NPI record | Relational Key (composite) | ||||||||||||
DeactFound | Date deactivation was processed by CarePrecise | |||||||||||||
DeactReason | Reason for deactivation. | Not currently populated. Not disclosed by CMS. | ||||||||||||
CPAC | Delta tables in NPPES_Delta.mdb
(MDB format; CPAC records only) Table is not provided in custom data pulls (CarePrecise Select services) |
tAddresses_DEACT tEntity_DEACT tHumanNames_DEACT tOID_DEACT tOrgNames_DEACT tPhoneFax_DEACT tTaxo_DEACT tTaxoGroups_DEACT tCoLoCode_DEACT
|
The Delta tables are contained in a separate database included in the CarePrecise Access Complete dataset, named NPPES_Delta. They contain near-complete data on those providers whose records have been deactivated by CMS for various reasons, including retirement, death, or for any of several infractions. These tables contain the same fields as the standard provider data tables as defined above for their namesakes, and are populated with the data from previous data releases, with the deactivation date populated in the tEntity_DEACT table's DeactDate field. Please note that a record may be added to the Deactivated tables, but then later be reactivated. Also note that Type 2 records (organizations) may have multiple records; some may be deactivated while others are active. When a record is reactivated it will appear in the tAdded table. | |||||||||||
Additional Data Included with Advanced databases and CarePrecise Platinum. Data is sourced from PECOS, Physician Compare, Hospital Compare and other CMS data, and is updated monthly. Provider records are a subset of the CPAC records, with approximately 650,000 physician records and 500,000 other providers. | ||||||||||||||
EPGH (Extended Professional, Group and Hospital data) |
tExtended_Professional
Only active providers (defined as having appeared on a Medicare claim in the past twelve months) are included in the EPGH dataset (unlike the CPAC dataset, which includes all US HIPAA-covered providers). EPGH data is available for approximately 615,000 physicians, and 300,000 other professionals, and is growing. The hospital data in EPGH provides an unduplicated listing of hospitals and their highest priority NPI number, and is linked to each hospital's affiliated professionals/physicians and practice groups. EPGH practice group data makes it possible to see the multiple locations at which an individual provider practices. |
NPI | National Provider Identifier of Individual Professional | Relational Key (composite and to CPAC)
Link to professional's data in the CPAC databases above. This ID is unique per professional (physician, PA, etc.).
|
||||||||||
PACID | Individual's unique PAC ID (PECOS Associate Control ID). Unique individual professional ID assigned by Medicare PECOS system | Relational Key (composite)
Link to practice group affiliations through the tExtended_GroupProfessional table, and is a link to upcoming practice group quality data.
|
||||||||||||
ProfEnrollID | Professional Enrollment ID | Relational Key (composite)
Unique ID for the individual professional enrollment that is the source for the data in the record. One professional may have multiple records in this table as a result of multiple PECOS enrollments, each of which may have its own hospital and practice group affiliations.
|
||||||||||||
LN | Last Name | In most cases the name fields here will be duplicative of the fields in tHumanNames, but these are sourced from the PECOS system rather than the NPPES. | ||||||||||||
FN | First Name | |||||||||||||
MN | Middle Name | |||||||||||||
Suffix | Name Suffix (Jr, III, etc.) | |||||||||||||
Gender | M (male) or F (female) | |||||||||||||
Cred | Credential | Medical credential such as MD, DO, DPM, etc. | ||||||||||||
School | Professional's medical school | |||||||||||||
GradYear | Professional's medical school graduation year | |||||||||||||
PriSpec | Primary medical specialty reported by the individual professional in this PECOS enrollment record | |||||||||||||
AllSecSpec | All four secondary specialties reported by the individual professional in this PECOS enrollment record, separated by commas |
|||||||||||||
EPGH | tExtended_Group
(Extended Practice Group information; MDB and CSV formats) |
GroupPracPACID | Unique Group Practice PAC ID (PECOS Associate Control ID) assigned by PECOS to the Group Practice | Relational Key
Links Group and Individual records within Extended tables. This ID is unique to each practice group. This key will link to group practice quality data soon to be released. |
||||||||||
NPI | National Provider Identifier of the Practice Group | Relational Key
(to CPAC)
Links practice groups in Extended tables to CPAC data above. Algorithmically derived*; not available for all group records. Use the GroupPracPACID to link individuals with their groups through the tExtended_GroupProfessional table. |
||||||||||||
OrgLBN | Legal name of the Group Practice | |||||||||||||
CountGroupPracMem | Number of Individual Professionals affiliated with Group Practice | This count is limited to individuals within the Extended domain; others may be found within the standard CPAC tables via CoLoCode. | ||||||||||||
StreetAddr1 | Group Practice line 1 address | |||||||||||||
StreetAddr2 | Group Practice line 2 address | |||||||||||||
Line2Suppress | Marker that address as reported may be incomplete | A peculiarity of the federal source data. | ||||||||||||
City | Group Practice city | |||||||||||||
State | Group Practice state | |||||||||||||
Zip | Group Practice zip code (9 digits when available) | |||||||||||||
CoLoCode | Derived algorithmically* based on location data | May be used to identify additional affiliated individuals within the NPPES data above. See description of CoLoCode in the CPAC table tCoLoCode above.
|
||||||||||||
HlthSysID | RESERVED FOR LATER USE | This is reserved for inclusion of the group's health system ID number. | ||||||||||||
HlthSysName | RESERVED FOR LATER USE | This is reserved for inclusion of the group's health system name. | ||||||||||||
Placekey | Deprecated field | As announced in the December 2025 and January 2025 releases, this is a deprecated field. It will remain in the file to maintain compatibility. The CarePrecise CoLoCode provides the same functionality in matching records, and is less prone to compatibility issues. | ||||||||||||
MSA | MSA/CBSA of the location | |||||||||||||
EPGH | tExtended_ GroupProfessional (Many-to-Many table linking group practices with individual professionals. One or more individuals per group, and may be one or more groups per individual. Extended information on group practices' individual providers, incl. whether accepts Medicare assignment, participates in various federal medical quality programs. MDB and CSV formats). Many-to-many table. |
NPI | National Provider Identifier of the Individual Professional. | Relational Key (composite and to CPAC)
Link to individual's data in CPAC tables above and in tExtended_Professional table. This ID is unique to the individual professional. |
||||||||||
GroupPracPACID | Unique Group Practice PAC ID (PECOS Associate Control ID) assigned by PECOS to the Group Practice that the individual professional works with. | Relational Key (composite)
Link between practice groups and their members in the tExtended_Professional table. This ID is unique to the practice group. |
||||||||||||
AcceptsMedicareAsmt | Y = Accepts Medicare approved amount as payment in full. M = May accept Medicare Assignment. | All providers in this table are enrolled to bill Medicare, and have done so within the past 9 months, but may not still be accepting new Medicare patients, and may not accept Medicare amount as payment in full. | ||||||||||||
eRx | Participates in the eRx Incentive Program, a pay-for-reporting program to encourage physicians, other providers to use electronic prescribing of medications.
|
|||||||||||||
PQRS | Participates in the Medicare Physician Quality Reporting System (PQRS) Incentive Program - a pay-for-reporting program that gives eligible professionals incentives and payment adjustments if they report quality measures satisfactorily. | Quality data on individual professionals is not yet available in this product, but using the relational keys in this table, you will be able to access it when it is released. | ||||||||||||
EHR | Participates in the Medicare Electronic Health Record (EHR) Incentive Program - provides incentives and payment adjustments to eligible professionals who use certified EHR technology in ways that may improve healthcare. | Y in this field means provider is participating in federal EHR incentive program, though may use an EHR system even if not affirmative in this field. | ||||||||||||
EPGH | tExtended_Hospital (Extended information on all U.S. acute care, VA and children's hospitals. Data provides a single unique NPI number per hospital facilitating deduplication of hospital record. MDB and CSV formats) |
CCN | Medicare Hospital Provider Number (CMS Certification Number assigned by CMS) | Relational Key
Link between hospitals and their affiliated individual physicians, etc. This ID is unique to each hospital recognized in the CMS PECOS system. If a hospital is eligible to bill Medicare (whether or not sanctioned), and is a general hospital (Acute Care, VA, Critical Access or Children's hospital), it is in this table. This key links to the exhaustive federal hospital quality data, optionally available for download at no cost to EPGH users. |
||||||||||
NPI | Priority National Provider Identifier. | Relational Key
(to CPAC)
Link to one of the hospital's records in CPAC tables above. Hospitals may have as many NPI numbers as they believe they need for their particular business circumstances, and tend to have many. We have listed here the Priority NPI, based on the hierarchical Taxonomy coding system, selecting first the NPI of the record containing the top (parent) taxonomy code for the hospital type, and, if not present, the NPI from the first-listed record for the hospital. Algorithmically derived*; not available for all hospital records. |
||||||||||||
HospitalName | Hospital name as reported by the hospital in its NPPES record | From the PECOS database | ||||||||||||
HospitalLBN | Hospital legal business name as listed in hospital quality data | From the Hospital Compare database | ||||||||||||
Address1 | Hospital line 1 address | |||||||||||||
Address2 | Hospital line 2 address | |||||||||||||
City | Hospital City | |||||||||||||
State | Hospital State | |||||||||||||
Zip Code | Hospital Zip Code | |||||||||||||
County | Hospital County | |||||||||||||
Phone | Phone | |||||||||||||
HospitalType | Hospital Type, as recorded in hospital quality data | |||||||||||||
HospitalOwnership | Hospital ownership structure | |||||||||||||
EmergencyService | Y= Hospital has emergency service | |||||||||||||
CoLoCode | Derived algorithmically* based on location data | May be used to identify additional data within NPPES tables above. See description of CoLoCode in the CPAC table tCoLoCode above. | ||||||||||||
HlthSysID | RESERVED FOR LATER USE | This is reserved for inclusion of the group's health system ID number. | ||||||||||||
HlthSysName | RESERVED FOR LATER USE | This is reserved for inclusion of the group's health system name. | ||||||||||||
Placekey | Deprecated field | As announced in the December 2025 and January 2025 releases, this is a deprecated field. It will remain in the file to maintain compatibility. The CarePrecise CoLoCode provides the same functionality in matching records, and is less prone to compatibility issues. | ||||||||||||
MSA | MSA/CBSA of the location | |||||||||||||
EPGH | tExtended_HospAff
(1-to-Many table linking Hospitals with physicians and other providers; up to five hospitals per individual; MDB and CSV formats.) Many-to-many table. |
HospAffCCN | Medicare CCN (CMS Certification Number assigned by CMS) of hospital where individual professional provides service | Relational Key (composite)
Link to hospital details in tExtended_Hospital via CCN, and to the CarePrecise Authoritative Hospital Database (APD) |
||||||||||
NPI | Unique professional ID assigned by NPPES to Individual Professional affiliated with hospital | Relational Key (composite)
Link to Individual Professionals affiliated with hospital |
||||||||||||
HospAffLBN |
Legal business name of hospital where individual professional provides service |
From the Hospital Compare database | ||||||||||||
* Marked above by an asterisk, algorithmically derived data in the datasets includes data that is extracted/mined from the source databases, but which has a margin of error and should not be relied upon as conclusive. Record linking algorithms are used to enrich our data when direct correlation (via a unique identifier field) is not available, using available information in name, address, phone, taxonomy, and other fields. In particular, some of the older data on providers excluded from billing Medicare (from the HHS Office of Inspector General's excluded providers database) can only be linked to NPI records by this means. Please note that when matches are found, there may be instances where an individual or firm has the same or similar name and location information as an excluded provider but is actually a different party. Therefore, it is important that you verify a potential match with the debarring agency identified in the record information. See the disclaimer appearing at the bottom of the documentation page. Not all fields in all records are populated with data. Healthcare providers may update data in their record using the federal NPI registry website, and are required to do so within 30 days of a change in their information. CarePrecise LLC reserves the right to make changes in the data and data structure as it deems necessary to preserve the quality of the product. Please read the Notice at the bottom of the page https://www.careprecise.com/help/ for additional information about the data.
|
FILE FORMATS: Every order is delivered in all of the following formats:
- Microsoft Excel file (.xlsx) with the most important data fields
- Microsoft Access 2003 or later, or Microsoft Office 365 Pro (.mdb); normalized relational tables, plus an application database that links them for use. A free alternative to Microsoft Access is Open Office.
- Comma Separated Values (.csv); normalized relational tables; identical data as in the Microsoft Access format.
ORDERING: Use the Order Form above on this page.
DELIVERY: Most orders can be delivered within one business day via a download link sent by email.
MORE INFORMATION: Contact sales at ask@careprecise.com

Authoritative Provider Data Since 2008