Update release    
July 16, 2017    
Compare All Healthcare Provider Database Products

Why no email addresses?

 
 

Questions? Call now:
(877) 782-2294

Click here to privately send this page (no email addresses are revealed to us).

 

 

 

 

EXPLORE:

Product Comparison Chart

Complete Online Documentation

Provider Counts by Specialty

Support Options

License Options

Download Sample Data

Contact Sales

 

 

 

 

CarePrecise Deep Healthcare Provider Data

NPPES, PECOS, LEIE, Physician Compare and Hospital Compare in one relational database.The CPAC + EPGH Bundle: Best-in-Class
Database of Physicians, Dentists, Pharmacy,
Clinic, Hospital and All Other US Healthcare Providers

 

Get the most complete data available anywhere on the 5.1 million + U.S. Healthcare Providers.

 

Physicians, hospitals, clinics, nurses, technicians, pharmacies, pharmacists, dentists, optometrists – every type of healthcare provider in America is here. This is the database that brings all of the available information on U.S. HIPAA-covered healthcare providers together in one relational database on your desktop or laptop computer. The CPAC+EPGH bundle contains complete NPPES, The Centers for Medicare and Medicaid Services (CMS) maintains this database. All healthcare providers who are HIPAA covered entities must obtain a National Provider Identifier (NPI) by reporting their information via the NPPES, and updating it when it changes. This represents virtually all of U.S. physicians, hospitals, and other providers who accept insurance or are associated with a hospital. LEIE List of Excluded Individuals/Entities (LEIE): The federal database maintained by the HHS Office of Inspector General containing information on providers who have been barred from billing Medicare due to fraud or controlled substance conviction, patient neglect or abuse, and other reasons. CarePrecise uses a proprietary record-linking system to attach active NPI numbers. and PECOS The federal database containing information on healthcare providers who are eligible to bill Medicare (Provider Enrollment, Chain and Ownership System). information on all of the 5.1 million + U.S. healthcare provider records*, plus data extracted from millions of Medicare health insurance claims – all merged into one easy-to-use relational database for Microsoft Access, SQL, FileMaker, or any other PC, Mac or Linux database or CRM software, and ready to use immediately.

Try the CPAC + EPGH BundleExtended Professional, Group and Hospital database

$598

Complete NPI database and more...

 

You just can't find a more complete database of U.S. healthcare providers.

The bundle includes our Extended Professional, Group and Hospital (EPGH) dataset, and our CarePrecise Access Complete (CPAC) dataset, giving you the most comprehensive view of the U.S. healthcare provider landscape available anywhere. The basic information, including practice and mailing addresses, phone numbers, fax numbers, specialties/taxonomy codes, license numbers, Medicare numbers and more, is enhanced with information on individuals (medical school, graduation year, multiple practice locations, practice group affiliations, hospital affiliations), plus information on practice groups, and deep hospital data, putting the full 360 degree view of U.S. healthcare providers right on your desk.

TIP: Add the Authoritative Hospital Database, and you'll have patient satisfaction data, medical procedure volumes, bed counts, and much more.

And at a price made possible by advanced data collection technology.

Click to see counts of each type of healthcare provider in the database...

Our data is constantly being refreshed with new source data, using our proprietary advanced record collection and linking technology, QoRelate™, making CarePrecise the leading provider of the most comprehensive, up-to-date and affordable medical provider database.

The pricing below is for the single-user edition. If you want to use CarePrecise data within a product such as a website, additional licensing options are available; contact Sales at (877) 782-2294 extension 9.

The current release is dated July 16, 2017 .

Continuous Updates for Accurate Applications

If you produce mobile or other web-based applications that need accurate healthcare provider data, CarePrecise has the data package and redistribution license to fit your app, your business model, and your traffic level. Contact Sales at 877-782-2294 extension 9 for information about our CarePrecise Developer Kit (CPDK) and redistribution licensing.

Historical data back 10+ years

Our separate file 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.

 

Click to review the complete field listing...

 

PRICING

U.S. Healthcare CPAC + EPGH Database
Our most complete and in-depth data on U.S. healthcare providers
CarePrecise Platinum
(CPAC, EPGH, ProCase +
CP ListMaker software)
DETAILS...
Single Download

Try a single download, with the option to apply the full price to a subscription ordfer within 30 days.
Try the CPAC/EPGH Bundle single download
:
$598 BUY

You can apply the full price you paid
to a subscription purchase within 30 days.

Get the data plus our CP ListMaker software to make it easy to create lists and Excel spreadsheets of specific provider types and locations for your particular needs.

1 Year Subscription
Description CPAC includes all U.S. healthcarte providers.* EPGH adds extended data on physicians, practice groups and healthcare professionals, and hospitals.

(See field list below, the gray section for CPAC fields,
the blue section for EPGH fields)
CPAC database plus EPGH extended data, plus ProCase properly cased names and addresses, with our powerful list-building software. Requires Microsoft Access.

For additional options, see the full CarePrecise Access Complete/CarePrecise Platinum and Gold lines in our online store.

Compare all of our major products on the Product Comparison page.

 

PRODUCT DESCRIPTION

360 degree view on U.S. healthcare providersThe CPAC+EPGH Bundle and CarePrecise Platinum offer the ability to easily pull an accurate list of medical providers of any specialty in any zip code, city or state, a list of hospitals and their affiliated physicians or practice groups, or a list of practice groups and view a verified list of medical professionals affiliated with the groups – or many other specialized lists as your need requires.

Hospital data includes the Medicare CCN number used to link to federal hospital quality and patient satisfaction data. The physicians data includes links to physician quality data soon to be released by CMS.

Addresses and other data are verified and in regular use in the healthcare industry for provider insurance reimbursements, research, and federal and state incentive programs.

 

Product Comparison Chart

View the Product Comparison page for pricing of the full range of CarePrecise healthcare provider databases and subscriptions.

 

You get both of the CarePrecise healthcare provider datasets as a single database...

The Standard CPAC provider data contains:
  • All 5.1 million U.S. HIPAA-covered healthcare providers
  • Names, AKAs, practice and mailing addresses on 100% of records
  • Phone numbers on 100% of records
  • Fax numbers on approximately 65% of records
  • Specialties and facility types, including all primary and secondary specialties
  • Legacy identifiers, including UPIN, and other identifiers, including Medicare PIN, NSC, OSCAR.
  • State licenses
  • Credentials
  • Co-located provider coding, a CarePrecise exclusive, allows connection of providers by practice location
  • Tables that list new records and when they were added, dropped records, and deactivated records

 

The Extended Professional, Group and Hospital (EPGH) healthcare provider data contains:
  • Deeper data on physicians and other healthcare professionals, their practice groups, and hospital affiliations
  • All providers are verified as having active Medicare billings
  • Hospital affiliations, medical school, graduation year
  • Unduplicated hospitals table with a single NPI master record per hospital, with affiliated physicians and practice groups
  • Additional practice locations and providers at those locations
  • Medicare payment acceptance
  • EMR/EHR incentive participation
  • ePrescription participation
  • Federal PACID and CCN numbers for linking to the new physician and practice quality, patient satisfaction and fee data, coming in 2015
  • The CPAC+EPGH data bundle is the most comprehensive healthcare provider data available anywhere

 

Who Uses CarePrecise Databases?

The data contained in the CarePrecise combined NPPES, PECOS, LEIE, PhysicianCompare and HospitalCompare database is used throughout the healthcare industry. Standing as the only fully NPI-keyed, complete dataset on U.S. healthcare providers, our users include health plans, healthcare product and service vendors, healthcare standards and quality organizations (such as NCQA), law enforcement, government agencies, medical software makers, and marketers. State RHIOs, health information exchanges, state medicaids and the Federal Bureau of Investigation are among CarePrecise data users.

A few of our customers:

  • slide010
  • slide020
  • slide030
  • slide040
  • slide050
  • slide060
  • slide070
  • slide080
  • slide090
  • slide100
  • slide110
  • slide120
  • slide130
  • slide140
  • slide150
  • slide160
  • slide170
  • slide180
  • slide190
  • slide200
  • slide210
  • slide220
  • slide230
  • slide240
  • slide250
  • slide260
  • slide270
  • slide280
  • slide290
  • slide300
  • slide310
  • slide320
  • slide330
  • slide340
  • slide350
  • slide360
  • slide370
  • slide380
  • slide400
  • slide410
  • slide500

Product Details

FILE FORMATS

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

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

 

DELIVERY

Customers receive a link via email to download the files. Optional shipping via mail on a DVD disk or thumb drive is also available.

 

MONTHLY OR QUARTERLY UPDATES

Purchase a quarterly or monthly subscription to receive the completely updated database. We provide features to let you know which records have been dropped, which have been added, and which have had changes in the data.

 

SUPPORT

The Single Download option includes 30 days of free Phone Technical Support. Subscription options come with 90 days of free Phone Technical Support. See support details.

 

SYSTEM REQUIREMENTS

For operation as a Microsoft Access database, Access 2007 or later is required. CSV files can be imported into any ordinary database system such as FileMaker, MS-SQL, MySQL or SQL Server, SalesForce, SugarCRM or other CRM. You should have 2 gigabytes of RAM (4GB recommended) on your laptop or desktop computer. The CSV files may be imported into any application that supports comma separated value files and supports large file sizes, on Windows, MAC and Linux computers.

 

Click to view the healthcare provider database data model

DATA STRUCTURE

The CPAC+EPGH Bundle and CarePrecise Platinum products are distributed as normalized relational database tables (MDB files), each keyed by the National Provider Identifier (NPI) number, plus a core Microsoft Access database that links the files together and includes query examples, tables that identify added, dropped and deactivated provider records, and CSV versions of the files. Through data normalization, CarePrecise reduces more than 380 highly redundant flat-file fields in the multiple databases to less than 90 unique fields, removing large volumes of unused space while preserving every character of the data and all of the original granularity. The data is in no other way abridged, but is ready to access at a fraction of the original file sizes, and in a form that can readily be searched, manipulated and imported into applications, all relationally linked by the unique NPI number.

Printer-friendly version of the medical provider database fieldsClick 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 ¬
Product Key: 
CPAC: CarePrecise Access Complete (standard dataset)
EPGH: Extended Physician, Group and Hospital data

 

ProCase: Properly-cased names and addresses
AHD: Authoritative Hospital Database
CPLM: CP ListMaker
Product Table CarePrecise fieldname Description of field, and/or source fieldname Additional information
CPAC (CarePrecise Access Complete) data is sourced and cross-matched 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 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.)

 

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

 

ReplacementNPI Replacement NPI  
EIN Employer Identification Number (EIN) Not currently populated. 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 populated
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 Ordering and Referring Report file distribution. 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), 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. . NOTE: Beginning with the May 2017 release, only those LEIE-listed providers tagged with an NPI number in the LEIE source data are flagged in the Warning field, and the algorithmically-derived flags will be discontinued. This is consistent with the now-ubiquitous adoption of the National Provider Identifier. Up until the May 2017 release, this field was 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
CPAC 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 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 "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 (Entity Type 2 records), this is the contact name.

 

AuthFN Authorized Official First Name
AuthMN Authorized Official Middle Name
AuthTitle Authorized Official Title or Position
AuthPN Authorized Official Name Prefix Text
AuthSN Authorized Official Name Suffix Text
AuthCred Authorized Official Credential Text

 

CPAC tOID NPI National Provider Identifier Relational Key
  (Other identifiers, such as UPIN, OSCAR, PIN, Medicaid, etc., excluding NPI and taxonomy codes; MDB and CSV formats) Many-to-many table. 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)

 

CPAC 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 (for Entity Type 2 records)
OthOrgName Provider Other Organization Name Other
OthOrgNameType Provider Other Organization Name Type Code  
ParentOrgLBN Parent Organization LBN

 

 
CPAC tPhoneFax NPI National Provider Identifier Relational Key
 

(Provider phone and fax numbers; fax numbers for approx. 65% of records; 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

 

 
CPAC 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). Many-to-many table.

 

Taxo Healthcare Provider Taxonomy Code_[1 through 15] Providers may have multiple taxonomies reported here, and thus multiple records in this many-to-many table
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)

 

CPAC tTaxoGroups NPI National Provider Identifier Relational Key
  (Provider Taxonomy codes indicating group practices; MDB and CSV formats). Many-to-many table. 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 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.

 

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

 

CPAC tCoLoCode
(CPAC records only)
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 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.

 

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.

 

 
CPAC tAdded
(CPAC records only)
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. Unduplicative index key is dual; NPI and DateDiscovered.

 

CPAC tDropped
(CPAC records only)
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. Unduplicative index key is dual; NPI and DateDiscovered.

 

EntityType Entity Type Code Type 1 is individual providers (i.e., physicians, psychologists, etc.); Type 2 is organizational providers (i.e., hospitals, labs, etc.)

 

ProvName   This is a generated field based on EntityType.

 

Prac1stAddr Provider First Line Business Practice Location Address  
Prac2ndAddr Provider Second Line Business Practice Location Address  
PracCity Provider Business Practice Location Address City Name  
PracState Provider Business Practice Location Address State Name The federal data contains variations on state codes, abbreviations and full state names; we conform this field to standard 2-character state codes. A small number of non-US postal addresses remain nonconforming.

 

PracZip Provider Business Practice Location Address Postal Code  
PracCountry Provider Business Practice Location Address Country Code (If outside U.S.)  
PracPhone Provider Business Practice Location Address Telephone Number  
EnumDate Provider Enumeration Date  
UpdateDate Last Update Date Date this provider NPI record was last updated

 

CPAC tExcluded

(MDB and CSV formats)

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

 

CPAC tDeact

(MDB and CSV formats; CPAC records only)

 

NPI National Provider Identifier This table is provided by CMS, listing all NPI records that have been deactivated and the deactivation date. Unduplicative index key is dual; NPI and DeactDate.

 

  DeactDate Date CMS deactivated the provider's NPI record
DeactFound Date deactivation was processed by CarePrecise
CPAC 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 the complete data on 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.
Additional Data Included with Extended Professional, Group and Hospital (EPGH)/CPAC Master Bundleand CarePrecise Platinum. Data is sourced from PECOS, Physician Compare and Hospital Compare databases, and is updated monthly. Provioder records are a subset of the CPAC records, with approximately 550,000 physician records and 400,000 other providers. The EPGH is not sold separately, and is available only as a bundle. No time stamp is provided for EPGH updates, and no historical data is included.
EPGH tExtended_Professional

(The EPGH is available optionally as a bundle with CarePrecise Access 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 (have 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 560,000 physicians, and 300,000 other professionals, and is growing. The hospital data in EPGH provides an unduplicated listing of hospitals and their highest priority NPI number, and is linked to each hospital's affiliated professionals/physicians and practice groups. EPGH practice group data makes it possible to see the multiple locations at which an individual provider practices.

NPI National Provider Identifier of Individual Professional Relational Key

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. Unique individual professional ID assigned by Medicare PECOS system

Relational Key

Link to practice group affiliations through the tExtended_GroupProfessional table, and is a link to upcoming practice group quality data.

 

ProfEnrollID Professional Enrollment ID 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 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

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.

 

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

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 ID assigned by PECOS to the Group Practice that the individual professional works with. Relational Key

Link between practice groups and their members in the tExtended_Professional table. This ID is unique to the practice group.

 

AcceptsMedicareAsmt Y = Accepts Medicare approved amount as payment in full. M = May accept Medicare Assignment. All providers in this table are enrolled to bill Medicare, and have done so within the past 9 months, but may not still be accepting new Medicare patients, and may not accept Medicare amount as payment in full.

 

eRx

Participates in the eRx Incentive Program, a pay-for-reporting program to encourage physicians, other providers to use electronic prescribing of medications.

 

 
PQRS Participates in the Medicare Physician Quality Reporting System (PQRS) Incentive Program - a pay-for-reporting program that gives eligible professionals incentives and payment adjustments if they report quality measures satisfactorily. Quality data on individual professionals is not yet available in this product, but using the relational keys in this table, you will be able to access it when it is released.

 

EHR Participates in the Medicare Electronic Health Record (EHR) Incentive Program - provides incentives and payment adjustments to eligible professionals who use certified EHR technology in ways that may improve healthcare. Y in this field means provider is participating in federal EHR incentive program, though may use an EHR system even if not affirmative in this field.

 

EPGH tExtended_Hospital

(Extended information on all U.S. acute care, VA and children's hospitals. Data provides a single unique NPI number per hospital facilitating deduplication of hospital record. MDB and CSV formats)

CCN Medicare Hospital Provider Number (CMS Certification Number assigned by CMS) Relational Key

Link between hospitals and their affiliated individual physicians, etc. This ID is unique to each hospital recognized in the CMS PECOS system. If a hospital is eligible to bill Medicare (whether or not sanctioned), and is a general hospital (Acute Care, VA, Critical Access or Children's hospital), it is in this table.

This key links to the exhaustive federal hospital quality data, optionally available for download at no cost to EPGH users.

 

NPI Priority National Provider Identifier. Relational Key

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.

 

EPGH tExtended_HospAff

(1-to-Many table linking Hospitals with physicians and other providers; up to five hospitals per individual; MDB and CSV formats). Many-to-many table.

HospAffCCN Medicare CCN (CMS Certification Number assigned by CMS) of hospital where individual professional provides service Relational Key

Link to hospital details in tExtended_Hospital via CCN, and to full hospital quality data soon to be added.

 

NPI Unique professional ID assigned by NPPES to Individual Professional affiliated with hospital Relational Key

Link to Individual Professionals affiliated with hospital

 

HospAffLBN

 

Legal business name of hospital where individual professional provides service

 

From the Hospital Compare database
The CP ProCase dataset contains the same name and address data as the CPAC dataset, but it is in properly-cased form. I.e., DR. MARY MACRAE is cased to Dr. Mary MacRae. ProCase is not sold separately and is available only in the CPAC+ProCase bundle and CarePrecise Platinum.
ProCase tProCase_Names

(Properly-cased names)

NPI National Provider Identifier Relational Key

Link to data in the CPAC and EPGH databases above.

 

CompanyName Organization name Properly cased form of OrgName_LBN in tOrgNames
PN Prefix Ms., Dr., etc.
LN Last Name  
FN First Name  
MN Middle Name  
SN Suffix Jr., III, etc.
Cred Credential Medical credential such as MD, DO, DPM, etc.
Gender M (male) or F (female)  
EntityType  

 

ProCase tProCase_
Addresses_Mail

(Properly-cased mailing addresses)

NPI National Provider Identifier Relational Key

Link to data in the CPAC and EPGH databases above.

Addr1 Provider First Line Business Mailing Address  
Addr2 Provider Second Line Business Mailing Address  
City Provider Business Mailing Address City Name  
State Provider Business Mailing Address State Name  
Zip Provider Business Mailing Address Postal Code (most are 9-digit Zip Codes)  
Country Provider Business Mailing Address Country Code (If outside U.S.)  
The Authoritative Hospital Database™ (AHD) contains detailed data on US hospitals, including bed counts, procedure volumes, medicare billings, patient satisfaction rankings, etc. The Authoritative Hospital Database is available separately, but can be linked to EPGH and CPAC data above keing on the CCN and NPI fields, respectively. Note that neither CarePrecise Platinum, CarePrecise Gold, or the Master Bundle include the AHD. No time stamp for data updates is provided in the AHD, nor is historical data available.
AHD AuthoritativeHospital
DB.mdb

(Properly-cased names)

CCN Unique federal hospital identifier Relational Key

Link to data in the EPGH databases above.

 

NPI National Provider Identifier Relational Key

Link to data in the CPAC and EPGH databases above. Algorithmically derived*; not available for all hospital records.

 

HospitalName Hospital’s name  
Address1 Hospital’s address, line 1  
Address2 Hospital’s address, line 2  
City Hospital’s city  
State Hospital’s state  
ZipCode Hospital’s Zip Code  
County Hospital’s county  
Phone Hospital’s phone  
Fax Hospital’s fax  
Beds Number of beds  
BedDaysAvail Number of bed days available  
InternsAndResidents Number of interns and residents  
PayrollEmployees Number of employees on payroll  
NonPaidWorkers Number of non-paid workers  
TotalDischarges Number of discharges/year  
MedicareDischarges Number of Medicare discharges/year  
MedicaidDischarges Number of Medicaid discharges/year  
Vol_Gastrointestinal Procedure volume: Gastrointestinal  
Vol_Eye Procedure volume: Eye  
Vol_Nervous_system Procedure volume: Nervous system  
Vol_Musculoskeletal Procedure volume: Musculoskeletal  
Vol_Skin Procedure volume: Skin  
Vol_Genitourinary Procedure volume: Genitourinary  
Vol_Cardiovascular Procedure volume: Cardiovascular  
PN Contact name prefix  
FN Contact first name  
MN Contact middle name  
LN Contact last name  
SN Contact name suffix  
Title Contact title  
Cred Contact credentials  
HospitalType Type of hospital (general acute, children's, etc.)  
HospitalOwnership Type of hospital ownership  
ParentOrgLBN Name of parent system  
EmergencyService Does have emergency service?  
CoLoCode Algorithmically derived* from location data. Used to match records.  
Bathroom cleanliness Patient satisfaction 1-5 stars  
Communication from Nurses Patient satisfaction 1-5 stars  
Communication from Doctors Patient satisfaction 1-5 stars  
Patient received help quickly on request Patient satisfaction 1-5 stars  
Quality of pain control Patient satisfaction 1-5 stars  
Medications were explained before giving Patient satisfaction 1-5 stars  
Patient received instruction on at-home recovery Patient satisfaction 1-5 stars  
Patient understood care when leaving hospital Patient satisfaction 1-5 stars  
Patient’s overall hospital rating Patient satisfaction 1-5 stars  
Area around room was quiet at night Patient satisfaction 1-5 stars  
Patient would recommend hospital Patient satisfaction 1-5 stars  
Hospital summary star rating Patient satisfaction 1-5 stars  
Additional data included in the CP ListMaker software component of CarePrecise Gold, and CarePrecise Platinum, sourced from USPS and U.S. Department of Commerce, and independent CarePrecise research. Data is updated monthly. These data are available only as part of the CP ListMaker and CarePrecise Gold/Platinum products, and are not sold separately. Note that neither the CP ListMaker application, nor data contained therein, is included in special licensing for Derivative Products or Redistribution.
CPLM tZips

Economic and social segmentation data for providers' service areas

ZipCode 5-digit Zip Code  
Wealth Numerical indicator of the relative wealth/poverty of the provider's immediate service area (zip). Wealth/poverty level is show as a percentage of the Federal Poverty Level (FPL) for the particular geographic area. Currently up to 12 levels are present in the data; additional levels will be included when data for those more extreme wealth levels are present.
Description Wealth Level
=<50% FPL 1
50% to 100% FPL 2
100% to 150% FPL 3
150% to 200% FPL 4
200% to 300% FPL 5
300% to 500% FPL 6
500% to 700% FPL 7
700% to 1000% FPL 8
1000% to 1500% FPL 9
1500% to 2000% FPL 10
2000% to 3000% FPL 11
Greater than 3000% FPL 12

 

RuralUrban Indicates Rural (R), Urban (U) or Other (O) status for the provider's immediate service area (zip). Other indicates suburban or small city status.  
City City associated with Zip Code  
County County primarily associated with Zip Code  
State State associated with Zip Code  
Latitude Geographic latitude to 5-digit zip accuracy  
Longitude

Geographic longitude to 5-digit zip accuracy

 
CPLM Additional Gold data tables:

- Names
- Names_Company
- Names_Cred
- Names_Genderize
- Names_Prefices
- Names_Suffices
- StateNameVariants

 

 

Additional data tables included in CarePrecise Gold are used by the included SharpMail™ tool to produce correctly-cased names and addresses and correctly-genderized and -prefixed salutations.

* Marked above by an asterisk (*), 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, 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. Providers may update data in their record using the federal NPI registry website.

CarePrecise Technology LLC reserves the right to make changes in the data and data structure as necessary for its purposes.

 

 

Try the CPAC/EPGH Bundle single download

CarePrecise Access Complete - the full national healthcare provider database

$598

Complete NPI database and more...

LICENSING

CarePrecise data is licensed for use by the purchaser and may not be redistributed. Review the End User License Agreement. Special redistribution licensing is also available. Unless a redistribution or multi-user license is obtained separately, the standard End User License Agreement permits the licesee 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. For information on licensing CarePrecise data for use in your web applications, products or services, phone 1 (877) 782-2294 extension 9.

MORE INFORMATION

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

 

 

 


* Includes 100% of current U.S. HIPAA-covered healthcare providers, including physicians, dentists, nurses, technicians, clinics, hospitals, and every other type of medical provider. 100% of records are updated monthly. 100% of records include address, phone and specialties. Approximately 65% of records include fax numbers. View current counts on our Provider Counts page.

** Subscription plans include the listed release schedule for the listed time period, with releases approximately monthly or approximately quarterly as indicated. Each release is based on the most recent dissemination from the data sources currently available at the time of the release.

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