Update release    
September 18, 2017    
Compare All Healthcare Provider Database Products

Contact information and deeper data on healthcare vproviders by specialty and location.

Many other selection criteria are available, such as providers in areas with a given household income, high or low minority populations, serving particular minority populations, rural areas, and more.
Click here for details.

 
Click here to privately send this page (no email addresses are revealed to us).
Who are your competitors in your specialty and geographic area?
Potential referral partners, marketing targets
Subscription plans designed to fit your needs
24-hour turnaround
Call (877) 782-2294 to inquire

CarePrecise Select Targets
Targeted Healthcare Provider Data

When you only need a portion of the U.S. healthcare provider database.

For the specific zip codes or mile-radius from a single zip code, and/or specialties and subspecialties you submit, our targeted product delivers provider NPI, contact information, including mailing address/phone/fax and practice address/phone/fax, provider names and AKA names, all reported taxonomy codes, UPINs and other identifiers, plus all other data contained in the National Plan & Provider Enumeration System (NPPES) for the targeted providers, updated monthly by the Centers for Medicare and Medicaid Services (CMS).
Click for full criteria details

Our targeted provider data now comes with an Excel file of properly-cased name and address, and correctly genderized salutation (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.*

 

HOW TO GET A COUNT: To get a count of the number of records that meet your criteria, use one of the options below to submit your criteria to our processing center. You will be notified of your count via email, usually within one business day. We will provide your first count at no charge. Subsequent counts before order will be charged at $25 per count, refundable with your order.

  • Go here for a detailed description of the criteria.
  • Go here to download a criteria worksheet.
  • Go here to submit the online criteria form, requesting your count.
  • Call (877) 782-2294 for personal assistance.

SELECT BY:

 

NOTE: Additional selection criteria and output data are available at varying prices. Custom data layout and processing are available. Call (877) 782-2294 for assistance.

PRICING
One Time (single download)
$400
1-year Quarterly Subscription (4 issues)
$1,200
1-year Monthly Subscription (12 issues)
$3,449
Includes properly cased/genderized Excel flat file, as long as records are below Excel's row limit of 1,048,576. Additional charge may apply for custom data or format.

 

IMPORTANT NOTE: Alternatively, you can purchase our complete, -record US healthcare provider database for $399 at this link, or get the data PLUS the same tool we use to produce targeted lists for $599 at this link.

APPLICATION: Used to locate providers of particular types or specialties, or all providers, within particular geographic areas. Geography can be defined by zip codes, or as a distance radius from a particular location. Providers can also be targeted by wealth level of their service areas, and urban/rural status. Individual providers may be targeted by gender and eligibility to bill Medicare.

FILE FORMATS:

  • Microsoft Excel file with the most important data fields
  • Text file for use on Linux, Mac
  • Microsoft Access (.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, for use on Linux, Mac

DELIVERY and DATA FRESHNESS: Most orders can be filled within one business day. Depending on the size of the enriched file and customer preference, delivery may be via email, FTP download. See the Date Structure table below for the specific files and fields that will be delivered. Data delivered is subject to availability of provider-reported identifiers in the current release, dated September 18, 2017 . Our processing center updates master data files monthly.

PAYMENT OPTIONS: Invoice is payable with placement of order (exception: government entities and nonprofit organizations are eligible for payment by Purchase Order). Pay by check, Visa, Mastercard, American Express or Discover. After you place your order by phone or email, an electronic payment invoice is sent to you, which may be paid online with a credit card, or by check via mail.

INQUIRE: Call (877) 782-2294 or email sales@careprecise.com

ORDER : Go here to submit your criteria using our online form. You will receive a count of the number of records and a quote by email. You may wish to download the criteria worksheet in advance at this link.

DATA STRUCTURE: CarePrecise Select is distributed as eleven normalized relational database tables in CSV format, ready to import into Microsoft Access or other database or spreadsheet software, each keyed by the National Provider Identifier (NPI) number.

Click for a printer-friendly version of the fields list.

CarePrecise Data Tables & Fields Use scrollbar at right of box to view all tables and fields ¬
TABLE CarePrecise fieldname Description of field, and/or source fieldname Additional information
tAddresses 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).

 

(Provider addresses; MDB and CSV formats) 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 Name

The federal data contains variations on state codes, abbreviations and full state names; we conform this field to standard 2-character state codes where possible.

 

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 Name

The federal data contains variations on state codes, abbreviations and full state names; we conform this field to standard 2-character state codes where possible.

 

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.)

 

 
tEntity NPI National Provider Identifier Relational Key
(Provider entity and record information; MDB and CSV formats) 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.)

 

ReplacementNPI Replacement NPI  
EIN Employer Identification Number (EIN) CMS is not yet providing tax numbers of this type
EnumDate Provider Enumeration Date  
UpdateDate Last Update Date Date this provider NPI record was last updated
DeactReason NPI Deactivation Reason Code Not currently populated
DeactDate NPI Deactivation Date Not populated because records in the current dataset are not deactivated. This field IS populated in the separate delta table tEntity_DEACT, described below.
ReactDate NPI Reactivation Date Not currently popluated
Gender Provider Gender Code M or F for Type 1 providers
IsSoleProp Is Sole Proprietor Y indicates provider operates as a sole proprietor business form.
IsOrgSubpart Is Organization Subpart

For Type 2 providers, may be one of several organizational units, each with its own NPI number

 

ParentOrgTIN Parent Organization TIN

CMS is not yet providing tax numbers of this type

 

InPECOS From monthly CMS PECOS distributions of PECOS-enrolled providers. Source: PECOS file distribution, linkage derived algorithmically* beginning with December 2011 release.

Y= provider is enrolled in PECOS (eligible to bill Medicare); N = not enrolled. Uppercase Y indicates exact NPI match in PECOS history; lowercase y indicates algorithmic match without historical verification.

 

Warning

From the Office of Inspector General's excluded providers database (LEIE). 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. (Algorithmically derived*).

 

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.

 

This field will be populated starting with the November 2016 release.

 

UPIN Obsolete physician identifier, still used in some legacy systems. Sources: NPPES and LEIE.

 

Where available

 

Group From NPPES group taxonomy data. Y= this provider reported that it operates as either a multi-specialty group or single-specialty group.

 

County   Practice county
CountyFIPS   Practice county FIPS code
StateFIPS   Practice state FIPS code
TimeZone   Practice time zone
DLSTime   Daylight saving time; Y= Yes
MSA   Metropolitan Statistical Area of practice
PMSA   Primary Metropolitan Statistical Area of practice
Population   Zip Code population
Zip5   First five digits of practice address Zip Code
tHumanNames NPI National Provider Identifier Relational Key
(Provider person names or contact person names; MDB and CSV formats) LN Provider Last Name (Legal Name) The enumerated provider's name
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 "AKA" name: Nee name, nickname, etc.
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, 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

 

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) OtherID Other Provider Identifier_[1 through 50]  
OtherIDType Other Provider Identifier Type Code_ [1 through 50]
Description OtherIDType
Other
01
Medicare UPIN
02
Medicare ID-Type Unspecified
04
Medicaid
05
Medicare OSCAR/CERTIFICATION
06
Medicare NSC
07
Medicare PIN
08
OtherIDState Other Provider Identifier State_ [1 through 50] In the case of a state license code, this is the licensing state
OtherIDIssuer Other Provider Identifier Issuer_ [1 through 50]  
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)

 

tOrgNames NPI National Provider Identifier Relational Key

(Provider organization names, esp. Type 2 providers; MDB and CSV formats)

 

OrgName_LBN Provider Organization Name (Legal Business Name) LBN
OthOrgName Provider Other Organization Name Other
OthOrgNameType Provider Other Organization Name Type Code  
ParentOrgLBN Parent Organization LBN

 

 
tPhoneFax NPI National Provider Identifier Relational Key

(Provider phone and fax numbers; MDB and CSV formats)

 

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

 

 
tTaxo NPI National Provider Identifier Relational Key

(Provider Taxonomy codes indicating specialties and subspecialties for Type 1/individual providers, and facility types for Type 2/organization providers; MDB and CSV formats)

 

Taxo Healthcare Provider Taxonomy Code_[1 through 15]  
Lic Provider License Number_[1 through 15]  
LicState Provider License Number State Code_[1 through 15]  
TaxoSwitch Healthcare Provider Primary Taxonomy Switch_[1 through 15]  
Tnum  

The number of the NPPES taxonomy field (1 through 15)

 

TaxoDescr   Taxonomy code description (the specialty/subspecialty in English)

 

tTaxoGroups NPI National Provider Identifier Relational Key
(Provider Taxonomy codes indicating group practices; MDB and CSV formats) Gnum

The source data (NPPES) permits group codes to be reported in up to 15 fields in this section. CarePrecise creates a 1-to-many table, listing each of a provider's reported txonomy 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.

 

This is the newest of the data released by CMS in the NPPES file. This is where the group taxonomy codes are reported. CMS does not report the 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

 

tCoLoCode NPI National Provider Identifier Relational Key
(MDB and CSV formats) CoLoCode

Provider co-location code (algorithmically derived*). The NPI and CoLoCode comprise the dual relational key for this table. The NPI identifies the provider record, and the CoLoCode identifies the co-located group. 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.

 

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.

Although each provider should have only one primary practice location in our database, technically, the tCoLoCode table is 1-to-many, because our system may not be able to resolve a single practice location per provider. There may be up to two distinct CoLoCodes for some providers.

 

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 co-location.

 

 
tAdded NPI National Provider Identifier Relational Key

(MDB and CSV formats)

DateDiscovered   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.

 

tDropped NPI National Provider Identifier Relational Key

(MDB and CSV formats)

DateDiscovered  

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.

 

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

 

tExcluded

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.

 

(MDB and CSV formats) 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 (currently unpopulated)
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)

 

* Algorithmically derived data in the CPAC dataset 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, the 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. In like manner, the available federal data does not provide information on an individual provider's practice group(s); using record-linkage technology, we extract the group information by matching providers sharing the same practice location, and these group data can be corroborated or enriched with the group practice codes provided by CMS.

 

 

SYSTEM REQUIREMENTS: For the CSV files: Any operating system and software that supports relatively large comma separated values files. For the MDB files: Microsoft Windows 10 or later, 4GB RAM, Microsoft Access 2007 or later.

OTHER FORMATS: If you need a different file format, we can probably accommodate. Contact sales@careprecise.com.

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 sales@careprecise.com for personal assistance.

 

* Proper case flat files are delivered in Excel format. Excel users: Some versions of Excel may cause Excel to limit the number of records (rows). Refer to your Microsoft Excel documentation. Excel 2007 and later can handle up to 1,035,000 rrecords.

 

NOTICE: The data contained in CarePrecise® products and services is compiled and processed on an ongoing basis, with monthly update releases, from free and fee-based sources, including the National Plan & Provider Enumeration System (NPPES) submitted by the providers themselves; Medicare Provider Enrollment Chain and Ownership System (PECOS); List of Excluded Individuals/Entities (LEIE) and other US federal sources obtainable under the Freedom of Information Act (FOIA) and provided monthly by the U.S. Department of Health and Human Services Services and Office of Inspector General of the U.S. Department of Health and Human Services, and from the U.S. Census Bureau, a division of the U.S. Department of Commerce, agencies of the U.S. federal government, and the United States Postal Service (USPS). Neither CarePrecise nor its investors, partners and affiliates are responsible for data maintained by these or other source providers. All HIPAA covered entity healthcare providers in the U.S. are required under the NPI regulation to provide their information to the NPI Registry, a federal database of healthcare providers and to update their records within thirty days of information changes. Not all fields in all records are populated with data. Data is provided "as is" and in accordance with the Freedom of Information Act (FOIA) and e-FOIA ammendments, and relevant data dissemination notices. No warranty is expressed or implied as to the accuracy, completeness, timeliness, or fitness for any purpose of the information presented here or in any CarePrecise product or service, nor that the data structure will not be changed in the future as necessitated by source data, beyond the diligent effort to include all released data. Nothing in the product descriptions, in writing or verbal, may be construed as a warranty, guarantee, or representation of deliverability. Not all fields are populated with data for every record; some fields are not populated due to restrictions imposed by a data supplier. To determine a provider's eligibility to practice and/or to bill Medicare or other health plans and carriers, or to in any other way perform professional activities, users should not rely solely on data included in the CarePrecise dataset, particularly regarding alleged criminal and/or fraudulent activity given as reason for listing in data on excluded providers (records carrying "sanction", "desanction", "warning" and/or "exclusion" identifiers). Data which has been in-matched using algorithmic rather than direct means will include a percentage of error; such data is labled as such in the documentation. Algorithmic in-matching logic is proprietary and a trade secret. Subscriptions are fullfilled with quarterly or monthly releases containing the most recently released data from all pertinent sources. CarePrecise is a registered service mark, and CarePrecise Access, CarePrecise Select, CarePrecise Gold, CarePrecise Platinum, CP ListMaker, CP ChangeMaker, SharpMail, Authoritative Physician Database and Authoritative Hospital Database are trademarks of CarePrecise Technology LLC. All CarePrecise products including data, data structures, code and related materials are the property of CarePrecise Technology LLC in the year of their release and protected by U.S. and international copyright. Other trademarks and copyrights are the property of their respective owners. For additional information on CarePrecise policies see the Policies page. Purchase of a CarePrecise product affirms understanding and acceptance of these policies and this information, and affirms that use will conform to the product's license agreement. Pricing for CarePrecise products published on its website are licensed for single user. Any form of dissemination, sharing, making public, distribution, or derivative product, whether or not for profit, is strictly forbidden. Additional licensing arrangements are available; contact CarePrecise Sales for terms and pricing.

To view on your mobile device, scan the barcode To call from your mobile device, click or scan

Click to dial from
your mobile device
(877) 782-2294

Policies and Terms of Use