CarePrecise Complete^™
The Standard Data on All U.S. Healthcare Providers

Now you can work with all of the U.S. healthcare
providers right on your own computer.

Affordably.

CarePrecise Complete (CPAC) makes basic data on the complete U.S. healthcare provider records accessible on your desktop. CPAC contains the basic demographic information on all U.S. HIPAA-covered healthcare providers, including the full NPI Registry.

Download all 7.1 million U.S. healthcare providers — physicians, dentists, hospitals, practice groups, pharmacies — and access them in ordinary office software.

Used across the industry by health plans, governments, research programs, and law enforcement, CarePrecise Complete (CPAC) is the complete list of all HIPAA-covered U.S. physicians, hospitals, nurses, dentists, laboratories, pharmacists and every other kind of healthcare provider in the United States, with specialty and contact information – including practice and mailing addresses, phone and fax numbers – updated every month. (Email addresses may be purchased separately.)

To build CPAC each month with freshly updated information, we start with the NPPES database (National Plan provider and Enumeration System) from the Centers for Medicare and Medicaid Services (CMS) - also known as the NPI Registry. We merge this data with information from the PECOS database (Provider, Enrollment, Chain and Ownership System), the LEIE database (List of Excluded Individuals and Entities), our own CarePrecise-derived data, and other sources to create one of the most robust healthcare provider databases available.

Up-to-date, authoritative information

CPAC is comprehensive and authoritative, sourced from the information reported and updated as required by law by the providers themselves in their federal National Provider Identifier (NPI) record, and is the most accurate source of detailed information on the nation's 7.1 million doctors, dentists, nurses, clinics, hospitals, laboratories, pharmacies and all other provider types.

Why is CPAC better than an API?

CarePrecise database products reside on your desktop or laptop computer, ready to use as a complete - and fast - dataset. You can create your own queries without relying on an Internet connection or complex programming. With CarePrecise Gold, you add the convenience of software that makes getting into the data easy, with features that save your queries, and make updating a snap. By contrast, an Application Programming Interface (API) will have restrictions on the number of records you can access per search, and severely limit the criteria you can include. With CPAC, you have all of the data, and you can create complex queries. For example, you can pull a list of Family Medicine physicians who have been in practice longer than 10 years, who are enrolled to bill Medicare, and who practice within a 35-mile radius of downtown Baltimore, Maryland. Not possible with any of the currently available API solutions.

Historical data back 10+ years

Our separate database of rich data on deactivated providers since 2005 includes the date of deactivation, name, address, specialties - all of the same fields as the standard data on current providers. Updated and included with each month's release.

Multiple practice locations and alternative names

CPAC now includes two new tables:

• Other Practice Locations - multiple practice locations per provider
• Other Organization Names - alternative organization names per organization provider

Applications

CarePrecise Complete (CPAC) is designed to be used on standard desktop and laptop computers, overcoming the file size and maximum row and column issues posed by oversized data files, using a process that organizes the data into separate tables for name information, address information, etc., plus data from other federal sources. This allows queries to act on the full dataset (over 5 gigabytes) on a normal PC, either using the Microsoft database, or by importing into other database applications such as FileMaker, SalesForce, MySQL, MS-SQL, Postgre, Oracle, FoxPro, Caché, etc. using the provided CSV files. (Special licensing may be required for certain applications.)

CPAC can be used to:

Exclusive CarePrecise-derived Data

Find practitioners who work together, and the organizations they work for

With CarePrecise Complete you can identify all providers working at the same practice site using the CarePrecise exclusive CoLoCode™ location matching field. You can use the CoLoCode and the provider taxonomy codes to identify physicians who work in hospitals, dentists who work in specific practice locations, and much more. The powerful CoLoCode is an exclusive CarePrecise feature.

Estimated Years in Practice

CarePrecise uses multiple data sources to establish an estimated number of years that providers have been in practice. This data point is another exclusive CarePrecise feature, and it is included with the basic CPAC product.

Find Providers Within a Miles-Radius

With CarePrecise Gold, you can use the Geographic Radius tool to find any of the 7.1 million U.S. healthcare providers within a radius of any central Zip Code. Pick the central zip, set the number of miles, and click the Find Matches button. You'll see them all displayed and ready for immediate export, without any API restrictions. Gold also contains the geocoding for providers' practice location zip codes, for use in finding nearby specialists, clinics, hospitals, and all the rest.

Providers' Historical Records

For all of the 7.1 million HCPs and HCOs, CarePrecise not only keeps archives of their information long after they cease serving patients, and it is included in the basic CPAC database, including their name, last practice address and telephone, specialties and licenses, and more, looking back more than a decade. In addition to these deactivated records, CarePrecise includes a table of newly-added records that our customers use to easily update their in-house databases.

FILE FORMATS

The product is delivered in two formats as downloadable files, each containing identical data:

• Microsoft Access (.mdb); normalized relational tables, plus a control database with query examples
• Comma Separated Values (.csv); normalized relational tables for import into other database software

DELIVERY

Delivered via download link sent by email. Data DVD and flash drive options.

SUPPORT

The Single Purchase option includes 30 days of free technical support, and subscription options come with 90 days of free technical support. See support details.

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 7 or later, 4GB RAM, Microsoft Office Pro/365 or standalone Microsoft Access 2007 or later for use in Access. CSV files are provided for use in other environments, including iOS and Linux.

DATA STRUCTURE

CarePrecise Complete is a normalized relational database ready to use on ordinary office computers in Microsoft Office Pro or Office 365 with Access, each record keyed by the National Provider Identifier (NPI) number. Download a sample here.

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

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. 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.)   tOtherPracticeLocations Additional (secondary) practice locations for Type 2 providers; MDB and CSV formats One-to-many table. 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   tEntity (Provider entity and record information; MDB and CSV formats) CHANGE NOTE: Beginning with the July 2022 release, the fields marked with a † symbol will be moved to a new table named tEntity-C, with the NPI as relational key, to accommodate the growing dataset. 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), indicating 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 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 location New 5-digit format for the MSA, also known as the CBSA. The field name will remains MSA for backward compatibility PMSA † Primary Metropolitan Statistical Area of practice location   Population †   Zip Code population Zip5   First five digits of practice address Zip Code 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 New with the July 2022 release: Placekey is a universal standard identifier for the physical practice location. Visit Placekey.io for details. Beginning with the July 2022 release: Placekey is a universal standard identifier for any physical place, so that the data pertaining to those places to facilitate sharing across organizations and separate data silos. Placekey provides geospatial data gathered from different sources. CarePrecise is a contributor. 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   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)   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   tOtherOrgNames Alternative org names beyond those listed in tOrgNames; MDB and CSV formats. One-to-many table. NPI National Provider Identifier Relational Key (composite) OtherOrgName Other Organization Name Relational Key (composite) OtherOrgNameType Other Organization Name Type Relational Key (composite) Code Description EntityType 3 DBA 2 4 Former LBN 2 5 Other 1, 2 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     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)   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   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 provider records 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. Includes both Type 1 and Type 2 records.   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. tAdded (CPAC records only) (MDB and CSV formats) 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.   tDropped (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   tExcluded (MDB and CSV formats) 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)   tDeact (MDB and CSV formats; CPAC records only) 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. Delta tables in NPPES_Delta.mdb (MDB format; CPAC records only) 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. * 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.

LICENSING

CarePrecise data is licensed for use by the purchaser on a single computer and may not be redistributed. Review the End User License Agreement. Site licensing and redistribution licensing is also available. Unless a redistribution or site 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.

MORE INFORMATION

Contact CarePrecise Sales at (877) 782-2294, sales@careprecise.com

Pricing and Ordering

Longer subscription plans are available with substantial savings.