When you only need a portion of the U.S. healthcare provider database.
Our targeted lists deliver the provider's federal NPI number, contact information, including mailing address/phone/fax and practice address/phone/fax, provider names and AKA names, all reported taxonomy codes, plus other data contained in the NPI Registry for the targeted providers, updated monthly.
CarePrecise Select comes as both an Excel (.xlsx and .csv) file with properly-cased names and addresses, and intelligent, correctly genderized salutations (the name that comes at the beginning of a letter, as in "Dear Ms. Jones") for mailing – all in a simple flat file you can use immediately in Excel*, and as a Microsoft Access database (.mdb) with the full information available for all U.S. HIPAA-covered healthcare providers.
How to get a Count and a Quote
To get a count of the number of records that meet your criteria, send an email to ask@careprecise.com detailing your requirements (specialties, types of providers, geographic area such as zip codes, cities, states, or radius from central point, etc.). You will be notified of your count and price quote via email, usually within one business day. Please indicate whether you would like the quote to include email addresses (priced separately). We will process your first count at no charge. Subsequent counts before order may require a $25 deposit per count, applied to your order.
Additional selection criteria are available with varying pricing, including County, Sole Proprietorship, Practice Groups and Group Size, service area household income, minority population service areas, time zones... call
(877) 782-2294
to discuss your need.
Pricing
One-time order starts at $790*
Additional complexity and special formatting may cause additional cost, at $90 per processing loop. Call for details. Per-address geocoding and email addresses are available separately.
Subscriptions: 1-year Quarterly Subscription starts at $2,568
1-year Monthly Subscription starts at $7,900
*Pricing includes a properly cased/genderized Excel flat file as long as records are below Excel's row limit of 1,048,576; orders with more than that number will receive only the relational database format, or if a CSV formatted file as shown belowmust be created with more than 1,048,576 rows, there will be an additional charge of $90.
Additional charge may apply for custom data or format, with an $90 charge per additional processing loop. Above pricing does not include email addresses, which are quoted and priced separately. See the Email Address Pricing page.
NOTE: Leverage your skills – do the filtering yourself in Microsoft Access and save! You can purchase our complete, 9 million
-record US healthcare provider database for $599 at this link, or get the data PLUS the same tool we use to produce targeted lists for $859 at this link.
What's in the Excel file?
The standard Excel file contains the following columns.
Web address (URL) included only where available and the Web Address add-on option is ordered for additional charge
LinkedIn included only where available and the LinkedIn add-on option is ordered for additional charge
Cell phone numbers included only where available and the Cell Number add-on option is ordered for additional charge
BestFax included only where available and the BestFax add-on option is ordered for additional charge
*CompanyName is included for Type 2 (organization) records only, but be requested for Type 1 (individuals) at an additional charge, and will be appended algorithmically; for instance, if you order a list of physicians, CompanyName will not be included, but if you order a clinic list, CompanyName will be included. Title, Group, and IsOrgSubpart is reported only for Type 2 records. IsSoleProp is reported only for Type 1 records.
What's in the Relational Database?
The relational database contains hundreds of potential data points per provider record.
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;
MDB and CSV formats)
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
tEntity (Provider entity and record information; MDB and CSV formats)
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:
Code
Description
EntityType
1
Former Name
1
2
Professional Name
1
5
Other
1, 2
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 (Other identifiers, such as UPIN, OSCAR, PIN, Medicaid, etc., excluding NPI and taxonomy codes; MDB and CSV formats) One-to-many table.
NPI
National Provider Identifier
Relational Key
OtherID
Other Provider Identifier
Identifier relevant to external data
OtherIDType
Other Provider Identifier Type Code
Description
OtherIDType
Other
01
Medicaid
05
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
Code
Description
EntityType
3
DBA
2
4
Former LBN
2
5
Other
1, 2
ParentOrgLBN
Parent Organization LBN
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.
"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
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.
Group
Y= This NPI/CoLoCode record is a group entity.
Same as the Group field in the tEntity table. It means that the NPI has a record in the tTaxoGroup table.
CountType1
Number of individual practitioners found co-located with this group
To see the number of Type 2 providers (organizations), subtract CountType1 from Count.
* 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.
Most orders can be filled within one business day. Delivery is via a download link sent by email. We update our master data files monthly.
March 17, 2026
is the most recent update release date. Data delivered is subject to availability of provider-reported identifiers in the current release. For information about data accuracy, go here.
FILE FORMATS
Microsoft Excel® (xlsx) file with the basic data fields (if number of records is within Excel's limitation of 1,048,576 rows)
Text file for use on Linux, Mac
Microsoft Access® (.mdb); normalized relational database, 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, for use on Linux, Mac
OTHER FORMATS
If you need a different file format, we can probably accommodate. Contact ask@careprecise.com for assistance.
OTHER SERVICES
We can match your provider list of NPI numbers with their full NPPES record, or compile lists of specific specialties in specific zip codes. Call (877) 782-2294 or contact ask@careprecise.com for assistance.
LICENSING
CarePrecise data is licensed for use by the purchaser and may not be redistributed. Review the End User License Agreement. Redistribution licensing is also available. Unless a redistribution or multi-user license is obtained separately, the standard End User License Agreement permits the licensee to use the data in any way desired as long as it is within and for the buyer's own organization and is used by only one user at a time (may not be installed on multiple computers for use by multiple simultaneous users). Alternative licensing options are available for uses that involve distribution of the data or use of the data by more than one user and/or for public viewing, and are purchased separately.
Click for a printer-friendly version of the complete data fields listing...
