Healthcare provider data and medical marketing lists

CarePrecise SelectPlus™
Advanced Custom Healthcare Provider Database

When you only want a portion of the U.S. healthcare provider database, tailored to your use case, with practice group and hospital affiliations

 

For the specific zip codes or miles-radius from a single zip code, and/or specialties and subspecialties you submit, and even additional criteria such as medical school graduation year, practice group and hospital affiliations, our SelectPlus 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 and other identifiers for the targeted providers, updated monthly. CarePrecise SelectPlus also incorporates data from other databases to facilitate tightly filtered lists, and offer complex selects and deeper data. For details on the full breadth of data available, see the data description page.

CarePrecise also offers optional historical data on healthcare providers of all types. For example, you can order the history of selected physicians' Medicare sanctions, and NPI number deactivations and reactivations, going back to 2005.

The CarePrecise SelectPlus custome database 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 sales@careprecise.com detailing your requirements – specialties, types of providers, geographic area such as zip codes, cities, states, or radius from central point, etc. – as well as the types of information, such as practice group name, hospitals with which a clinician is affiliated, counts of clinicians in the group, etc. (CarePrecise always includes name fields, practice addresses, mailing address, phones, fax numbers, specialties, and other standard data.) 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, refundable with your order.

 

Select by these criteria:

Additional selection criteria are available with varying pricing, including independent practitioner status, pharmacy chain vs independent, service area household income, minority population service areas, time zones... call (877) 782-2294 to discuss your need.

 

Geocoding

The standard Excel data file contains latitude and longitude for the Zip Code of the practitioner. But your records can be geocoded with latitude and longitude for each practice address. See more about CarePrecise Select Geocode...

 

Pricing

One-time order starts at starts at $660
Additional complexity may cause additional cost, at $80 per processing loop. Call for details.
Per-address geocoding and email addresses are available separately.

Subscriptions:

1-year quarterly subscription to data updates, starts at starts at $1,840
1-year monthly, starts at starts at $4,950

*Pricing includes a properly cased/genderized Excel flat file as long as records are below Excel's row limit of 1,048,576. To include the relational database format with additional data as shown below, add $80.

Additional charge may apply for custom data or format, with an $80 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, 7.4 million -record US healthcare provider CarePrecise Advanced™ database for $649 at this link, or get the data PLUS the tool we use to produce targeted lists for $874 at this link.

 

What's in the Excel file?

The standard Excel file contains the following columns. Note that Excel can only view 1,048,576 rows, so files with too many rows will have to be viewed in a different program.

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 Relational Database?

Click to view the healthcare provider database data model

The relational database contained hundreds of potential data points per provider record. In addition to these data points, CarePrecise can offer data included in our Authoritative Physician Database (APD) and Authoritative Hospital Database (AHD).

 

Printer-friendly version of the AHD database fields Click for a printer-friendly version of the complete data fields listing...

[an error occurred while processing this directive]
CPAC (CarePrecise 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)

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), 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 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
PMSA † Primary Metropolitan Statistical Area of practice location  
Population †   Zip Code population
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 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.
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.
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.

 
Additional Data Included with CarePrecise Advanced™and CarePrecise Platinum. Data is sourced from PECOS, Physician Compare, Hospital Compare and other CMS data, and is updated monthly. Providers in the EPGH are a subset of the CPAC records, approximately 900,000 providers plus their practice groups and affiliated hospitals.
EPGH tExtended_Professional
(The EPGH is available optionally as a bundle with CarePrecise Complete (CPAC) that provides additional information on healthcare professionals (particularly physicians), practice groups and hospitals, and reveals the affiliation links between all three. MDB and CSV formats.)

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 640,000 physicians, and 650,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 Placekey is a universal standard identifier for the physical practice location. Visit Placekey.io for details. 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.
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.

 

 Deprecated. CMS has ended this program for reporting.
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. Deprecated. CMS has ended this program for reporting.
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. Deprecated. CMS has ended this program for reporting.
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)

NEW: Now includes more affiliated healthcare facility data for all types of clinicians/professionals as reported by CMS. See tExtended_HospAff below.

 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 Type 2 National Provider Identifier (hospitals only) 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 Placekey is a universal standard identifier for the physical practice location. Visit Placekey.io for details. 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.
MSA MSA/CBSA of location  
FacilityType Temporarily used internally by CarePrecise and should not be relied upon to provide relevant data. This was necessary in the transition from CMS' previous data files to their current ones as of November 2022. To prevent future issues when this field is removed, please do not add to your import routine.
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.

NEW: Now includes more affiliated healthcare facility data for all types of clinicians/professionals as reported by CMS. This includes not only hospitals per se, but also Skilled Nursing Facilities (SNF/nursing homes), long term care facilities, rehabilitation facilities, dialysis centers, hospices, and home health care agencies that have affiliated professionals.

 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.

 

 

DELIVERY and DATA FRESHNESS

Most orders can be filled within one business day. Delivery is via a download link sent by email. Data files are fully updated monthly. March 20, 2023 is the most recent update. 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 sales@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 sales@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.

 

MORE INFORMATION

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