The Authoritative Physician Database^™

Current data update released July 19, 2021

1 million+ U.S. Physicians with specialties, practice group & hospital affiliations, grad year, HCPCS/CPT procedures & orders, phone, fax and more.

This is the best-in-class U.S. physician database that brings all of our 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
Subscriptions:

1 Year Quarterly Updates: $2,473

1 Year Monthly Updates: $5,564

2 Years Quarterly: $4,451

2 Years Monthly: $10,015

The most complete database of US physician information.

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
Medical procedures, DME/POS orders, by HCPCS/CPT code
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...

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

Use scroll bar inside box to view all 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
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_Procedures.mdb
APD_PhysicianProcedure Physician procedure volumes 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. HCPCS procedures performed by physician are listed. HCPCS Level I codes are same as CPT codes.	Text	24
	HCPCSDrugIndic	HCPCS Drug Indicator.	Text	255
	PlaceOfService	Place where service was rendered.
	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
	AvgMedicarePayment	Average Medicare Payment Amount.	Double
	AvgSubmittedCharge	Average Submitted Charge Amount.	Double
	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
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
	Classification	BETOS Classification Group. High level grouping of the BETOS Classifications into three groups including Durable Medical Equipment, Prosthetic and Orthotic Devices, and Drugs and Nutritional Products.	Text	255
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

Touch here for a mobile-friendly PDF version of the full listing of the data fields in the APD...

DATA CONTENTS

Approximate population in a selection of the APD fields:

	Physicians	Affiliated Groups	Affiliated Hospitals
All	1,093,088	50,877	4,620
Rural	96,072	8,596	2,174
Non-Urban	96,357	8,623	2,175
Urban	995,303	42,235	2,445
With Fax	63.78%	45.96%	71.10%
Cabinet-level contacts		26,110	3,915

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
Subscriptions:

1 Year Quarterly Updates: $2,473

1 Year Monthly Updates: $5,564

2 Years Quarterly: $4,451

2 Years Monthly: $10,015

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