Authoritative Physician Database | CarePrecise
Healthcare provider data

The Authoritative Physician Database

Current data update released November 16, 2020

1 million+ U.S. Physicians with their specialties, practice group affiliations and locations, hospital affiliations, graduation year, procedures performed, DME/POS orders, license, address, phone, fax and more.

 

This is the best-in-class physician database that brings all deep information on U.S. HIPAA-covered physicians, their medical practices and hospital affiliations together into a single up-to-date relational database on your desktop or laptop computer. It's available for immediate download in Microsoft Access format and CSV files, for use with spreadsheet, database or CRM software on Windows PC, Mac or Linux.

 

At pricing made possible by advanced data collection and record linkage technology.

CarePrecise updates more than 75 million records monthly against freshly released federal data, extracting data from federal records on more than 6.3 million U.S. healthcare providers, including more than a million M.D. and D.O. physicians, more than 50,000 practice groups and more than 6,000 hospitals. Our accuracy and pricing truly set us apart from other physician data suppliers.

 

Single Download: $1,099 Buy Now
Subscriptions:

1 Year Quarterly Updates: $2,473 Buy Now

1 Year Monthly Updates: $5,564 Buy Now

2 Years Quarterly: $4,451 Buy Now

2 Years Monthly: $10,015 Buy Now

 

The most complete database of US physician information.

Authoritative Physician Database

The Authoritative Physician Database (APD) contains records for all HIPAA-covered U.S. doctors. With this database of physicians we include their practice group and hospital affiliations, types of medical procedures performed, DME ordered, and more. The APD is the result of data extraction performed on millions of Medicare claims, and data sourced from multiple authoritative sources. Read about the accuracy of our data...

The APD is the only physician database with this deep pool of data:

  • 100% of U.S. HIPAA-covered MD and DO physicians
  • Their practice groups, with group size
  • Independent practice indicator
  • Sole proprietor indicator
  • Their hospital affiliations
  • Procedures they perform, DME and POS orders, and how many
  • All reported specialties, including the primary
  • Years in practice
  • Medical school attended
  • Phone and fax numbers
  • Rural/Urban practice indicator
  • Practice and Mailing addresses
  • Gender
  • Current LEIE sanctions
  • Multiple locations per doctor
  • License
  • Medicare practice PAC ID
  • C-suite and director-level contacts for physician groups and hospitals
  • Exclusive CoLoCode™ to find physicians practicing together

 

Physician and Group Procedure Volumes

The APD contains the most recent information on performance of medical procedures, and orders of durable medical equipment (DME) and prosthetics, orthotics and supplies (POS) by physicians, with service counts and numbers of patients per procedure and order, including the ability to display top procedures performed per practice group.

 

Physician, Group, and Hospital Contacts

Business addresses, phone numbers, and fax numbers are provided, with contact persons, including more than 24,000 cabinet-level contacts for practice groups, and more than 4,000 for hospitals. Look into our equivalent product with deep information for hospitals...

 

Product Details

CarePrecise data sets connect together into a single source of truth regarding physicians and their connected providers. For instance, by adding Gold, Platinum, or the Master Bundle data set to the Authoritative Physician Database, it is possible to see all of the providers who practice together, including physicians, nutritionists, RNs, and all other taxonomies of healthcare providers, as well as their organizations and employers, using CarePrecise's exclusive CoLoCode co-located provider identifier. By adding the Authoritative Hospital Database (AHD), you can view deep information on physicians' affiliated hospitals and health systems.

 

Touch diagram and rotate screen to view full size...

CarePrecise

 

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

Use scroll bar inside box to view all 136 APD data fields ¬   
Data Table/File Name Field Name Description Data Type Size

DB FILE: AuthoritativePhysicianDB.mdb

APD_Physician

All U.S. HIPAA-covered physicians.
NPI National Provider Identifier assigned by the federal government to every HIPAA-covered healthcare provider. All physicians are required to have one, and only one, Type 1 NPI number. Text 10
PhysPACID Unique Physician ID assigned by PECOS (Medicare ID) Text 20
LN Last name Text 35
FN First name Text 20
MN Middle name Text 20
PN Name Prefix (Dr, Ms, etc.) Text 5
SN Name Suffix (Jr, II, etc.) Text 5
Cred Credential(s) Text 20
Prac1stAddr Practice address line 1 Text 55
Prac2ndAddr Practice address line 2 Text 55
PracCity Practice address city Text 40
PracState Practice address state Text 40
PracZip Practice address Zip Code Text 20
County Practice address county Text 45
CoLoCode™ Practice co-location code; may be used to link providers practicing at the same location; derived algorithmically based on co-location data Text 40
Rural/Urban/Sub R = Rural, U = Urban, S = Suburban/other Text 1
PhysicianPracPhone Physician's Practice phone number Text 20
PhysicianFax Fax number Text 20
EnumDate Date provider registered with the federal NPI database Text 10
UpdateDate Date provider most recently updated their NPI record Text 10
Gender Provider's gender Text 1
IsSoleProp Y = sole proprietor business type Text 1
IndepProfile Y = physician's profile indicates independent practice or group of 2 or fewer physicians Text 1
InPECOS Y = enrolled to bill Medicare (may order and refer) Text 1
Warning Y = physician is barred from billing Medicare due to an infraction Text 1
ExclType Code of the infraction (see the ExclCode table for definitions) Text 10
PriSpec Primary medical specialty from NPI Type 1 record (NOTE: All specialties are listed in APD_Specialty) Text 50
School Physician's medical school Text 100
GradYear Physician's medical school graduation year Text 4
EstPracYears Number of years in practice, estimated based on medical school graduation year and/or NPI enumeration date post-2009 Text 3

APD_Physician_Type2

All U.S. HIPAA-covered physicians.
NPI National Provider Identifier (Type 2) assigned by the federal government to a physician's business entity. Every physician is required to have one and anly one Type 1 (individual) NPI registration, but may have additional Type 2 (organization) NPI registrations. Text 10
OrgName_LBN Legal Business Name of physician's business entity Text 255
LN Last name of authorized official for physician business entity Text 35
FN First name of authorized official for physician business entity Text 20
MN Middle name of authorized official for physician business entity Text 20
PN Name Prefix (Dr, Ms, etc.) of authorized official for physician business entity Text 5
SN Name Suffix (Jr, II, etc.) of authorized official for physician business entity Text 5
Cred Credential(s) of authorized official for physician business entity Text 20
Title Title of authorized official for physician business entity Text 100
Prac1stAddr Practice address line 1 Text 55
Prac2ndAddr Practice address line 2 Text 55
PracCity Practice address city Text 40
PracState Practice address state Text 40
PracZip Practice address Zip Code Text 20
County Practice address county Text 45
CoLoCode Business entity's co-location code, derived algorithmically based on co-location data Text 40
Rural/Urban/Sub R = Rural, U = Urban, S = Suburban/other Text 1
PhysicianPracPhone Business entity phone number Text 20
PhysicianFax Business entity fax number Text 20
EnumDate Date provider registered this Type 2 NPI enumeration with the federal NPI database Text 10
UpdateDate Date provider most recently updated this Type 2 NPI record Text 10
IsSoleProp Y = sole proprietor business type Text 1
InPECOS Y = enrolled to bill Medicare (may order and refer) Text 1
Warning Y = physician is barred from billing Medicare due to an infraction Text 1
ExclType Code of the infraction (see the ExclCode table for definitions) Text 10
PriSpec Primary medical specialty from business entity's NPI Type 1 record (NOTE: All specialties are listed in APD_Specialty) Text 50

APD_Specialty

All physicians' specialties. May be up to 15 per physician.
NPI National Provider Identifier Text 10
ReportedOrder Number of taxonomy field in which reported (1 - 15) Byte 1
Taxonomy Taxonomy code Text 10
License License number Text 20
LicenseState Licensing state Text 2
IsPrimary Y = primary taxonomy code (primary specialty) Text 6
Specialty Taxonomy description, i.e., specialty Text 255

APD_Group

Physicians' affiliated practice groups. May be up to five per physician. Ongoing extraction from Medicare claims data.

NOTE: Medical procedure performed per group can be viewed as a summary of procedures performed by each group's affiliated physicians. See example query in AuthoritativeHospDB.mdb.

PACID Unique Group Practice ID assigned by PECOS to the Group Practice that the individual professional works with Text 20
NPI Group National Provider Identifier; derived algorithmically from NPI registry data; groups may have additional NPI numbers Text 10
OrgLBN Legal name of the Group Practice Text 70
CountGroupPracMem Total number of individual professionals affiliated with the Group Practice based on Group Practice PAC ID Text 4
StreetAddr1 Group Practice line 1 address Text 55
StreetAddr2 Group Practice line 2 address Text 55
City Group Practice city Text 30
State Group Practice state Text 2
Zip Group Practice zip code (9 digits when available) Text 9
County Group Practice County Text 45
Rural/Urban/Sub R = Rural, U = Urban, S = Suburban/other Text 1
CoLoCode Group co-location code; may be used to link providers practicing at the same location; derived algorithmically based on co-location data Text 40
GroupPhone Phone Number Text 24
GroupFax Fax Number Text 24
AuthPN Contact name prefix Text 5
AuthFN Contact first name Text 20
AuthMN Contact middle name Text 20
AuthLN Contact last name Text 35
AuthSN Contact name suffix Text 5
AuthCred Contact credential Text 20
AuthTitle Contact title Text 35

APD_GroupAff

Linking table connects physicians with practice group affiliations. Collected from Medicare claims data during a moving window of twelve months prior to release date.
NPI Unique physician ID assigned by NPPES Text 11
PACID Unique Group Practice ID assigned by PECOS to the Group Practice that the individual professional works with Text 20
AcceptsMedicareAsmt Y = Professional accepts Medicare approved amount as payment in full at this group location. M = Professional may accept Medicare Assignment. Text 1

APD_Hospital

Physician's affiliated hospitals. May be up to five per physician. Ongoing extraction from Medicare claims data.
CCN CMS Certification Number Text 6
NPI Priority National Provider Identifier of hospital; derived as best NPI based on taxonomy hierarchy; hospitals may have additional NPI numbers Text 10
HospitalName Hospital name as reported by the hospital in its NPPES record Text 255
HospitalLBN Hospital legal business name as listed in the hospital quality data Text 70
Address1 Hospital line 1 address Text 100
Address2 Hospital line 2 address Text 100
City Hospital City Text 100
State Hospital State Text 2
ZIP Code Hospital Zip Code Text 5
County Hospital County Text 45
Rural/Urban/Sub R = Rural, U = Urban, S = Suburban/other Text 1
HospitalPhone Hospital Phone Text 10
HospitalFax Hospital Fax Number Text 24
HospitalType Hospital Type, as recorded in hospital quality data Text 50
HospitalOwnership Hospital ownership structure Text 100
EmergencyService Y= Hospital has emergency service Text 50
CoLoCode Hospital co-location code; may be used to link providers practicing at the same location; derived algorithmically based on co-location data Text 40
AuthPN Contact name prefix Text 5
AuthFN Contact first name Text 20
AuthMN Contact middle name Text 20
AuthLN Contact last name Text 35
AuthSN Contact name suffix Text 5
AuthCred Contact credential Text 20
AuthTitle Contact Official title Text 35

APD_HospitalAff

Linking table connects physicians with their hospital affiliations. Collected from Medicare claims data during a moving window of twelve months prior to data release date.
CCN CCN of hospital where individual professional provides service Text 6
NPI Unique physician ID assigned by NPPES Text 11

APD_PhysicianProcedure

Physician procedure volumes, listing top five procedures performed by physician, and counts of services and patients served, from CMS-collected HCPCS reporting.
NPI National Provider Identifier of clinician Text 10
HCPCS_Code Healthcare Common Procedure Coding System (HCPCS) procedural code billed by the clinician; "NR" indicates that no procedure data has been reported for this physician. Top five HCPCS procedures performed by physician are listed. HCPCS Level I codes are same as CPT codes. Text 24
ServiceCount Frequency of individual clinician's performance of the associated HCPCS code within the calendar year Text 10
BeneficiaryCount The number of beneficiaries that received the service or procedure identified by the HCPCS code Text 10
MeasureYear The most recent year of procedure data reported by CMS Text 4

APD_ProcedureDescriptions

Physician procedure volumes. Ongoing extraction from CMS-collected HCPCS reporting. Abbreviated descriptions. Click to view Procedure Codes...
HCPCS_Code Healthcare Common Procedure Coding System (HCPCS) procedural code billed by the clinician Text 24
ProcedureDescription Lay-friendly description of procedure associated with HCPS code Text Long Text

Lookup_ExclusionDescriptions

Describes the exclusion code for sanctions indicated in the APD_Physician table. Exclusion from billing Medicare or other federal programs due to a sanction of other infraction. Sourced from Centers for Medicare and Medicaid Services Office of Inspector General.
ExclType Exclusion type code Text 24
ExclDescr Description of exclusions imposed by the OIG expanded from Medicare and State health care programs to all Federal health care programs, federal code 1128B(f)(1). Text 255

DB FILE: AuthoritativePhysicianDB_DMEPOS.mdb

APD_PhysicianDMEPOS

Physician Durable Medical Equipment (DME) orders and Prosthetics, Orthotics and Supplies (POS) orders, listing DMEPOS ordered by physician, and counts of services, claims, suppliers and patients served, from CMS-collected HCPCS reporting.
NPI National Provider Identifier of clinician Text 10
HCPCS_Code Healthcare Common Procedure Coding System code for the specific product or service furnished by the Durable Medical Equipment, Prosthetics, Orthotics and Supplies (DMEPOS) supplier. Level II codes. Text 24
Rental Identifies whether the DMEPOS product/service submitted on the supplier's claim is rental or non-rental - Y = rental, N = non-rental Text 1
Suppliers Number of suppliers rendering DMEPOS products/services ordered by the referring provider Text 12
Beneficiaries Number of beneficiaries associated with the supplier DMEPOS products/services ordered by the referring provider. Beneficiary counts fewer than 11 have been suppressed to protect the privacy of Medicare beneficiaries. Text 12
Claims Number of DMEPOS claims submitted by the supplier, reflecting products/services ordered by the referring provider. Aggregated records based on claims fewer than 11 are not included. Text 12
Services Number of DMEPOS products/services rendered by the supplier Text 12
AvgSubmittedCharge Average of the charges that suppliers submit for DMEPOS products/services. Total submitted charges can be calculated by multiplying the AvgSubmittedCharge by the Services. Double  
AvgMedicareAllowAmount Average Medicare allowed amounts for the DMEPOS product/service rendered by suppliers. Allowed: amount Medicare pays, deductible and coinsurance the beneficiary pays, amounts that a third party pays. Total Medicare allowed amounts can be calculated by multiplying the AvgMedicareAllowAmount by the Services. Double  
AvgMedicarePaymentAmount Average amount Medicare paid suppliers after deductible and coinsurance amounts have been deducted for the line item DMEPOS product/service. Total Medicare payment amounts can be calculated by multiplying the AvgMedicarePaymentAmount by the Services. Double  
AvgMedicareStandardAmount Average amount Medicare paid suppliers after deductible and coinsurance amounts have been deducted for the line item DMEPOS product/service. Total Medicare payment amounts can be calculated by multiplying the AvgMedicarePaymentAmount by the Services. Double  
MeasureYear Year of care the data reflects (most recent CMS data release on this physician) Text 4

tAPD_DMEPOSDescriptions

Physician procedure volumes. Ongoing extraction from CMS-collected HCPCS reporting. Abbreviated descriptions. Click to view Procedure Codes...
HCPCS_Code Healthcare Common Procedure Coding System code for the specific product or service furnished by the Durable Medical Equipment, Prosthetics, Orthotics and Supplies (DMEPOS) supplier Text 24
DMEPOS Description Lay-friendly description of procedure associated with the DMEPOS HCPCS code Long Text 255

 

DATA CONTENTS

Approximate population in a selection of the 136 APD fields:

  Physicians Affiliated Groups Affiliated Hospitals
All 1,075,386 50,536 4,641
Rural 94,875 8,485 2,186
Non-Urban 95,155 8,505 2,187
Urban 978,766 42,011 2,452
With Fax 64.46% 46.44% 71.11%
Cabinet-level contacts   25,938 3,969

These numbers may be taken as approximate, as data is updated continuously. New updates are released twelve times per year. Not all records are populated with all data points. Records are unduplicated per NPI and/or CCN identifier.

DELIVERY

Immediate download from our online store. Optional shipping via mail on a DVD disk or thumb drive is also available. Optional secure, automation-friendly FTP push delivery is available for subscribers.

 

FILE FORMATS

The downloaded zip file contains the APD in three file formats, each containing identical data:

  • Comma Separated Values (.csv); normalized relational tables; may be used in Excel or imported into any spreadsheet or database software on Windows, Mac or Linux system.
  • Microsoft Access 2003/2007/2010/2013 (.mdb); normalized relational tables, with example queries.
  • Microsoft Excel spreadsheet (.xlsx).

 

SUPPORT

The Single Download option includes 30 days of free Telephone Technical Support. Subscription options come with 90 days of free Telephone Technical Support. Ongoing technical support via email. See support details.

 

SAMPLE DATA

Download sample data at this link.

 

PACKAGES

Single Download: $1,099 Buy Now
Subscriptions:

1 Year Quarterly Updates: $2,473 Buy Now

1 Year Monthly Updates: $5,564 Buy Now

2 Years Quarterly: $4,451 Buy Now

2 Years Monthly: $10,015 Buy Now

 

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

 

 


Not all records are populated with all data. See important information.

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.

* Not all records are populated with all data. See Data Contents, above.

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