Authoritative Physician Database | CarePrecise
Update released    
December 19, 2019    
Compare All Healthcare Provider Database Products
  

 

Questions? Call now:
(877) 782-2294

 

EXPLORE:

Compare products Product Comparison Chart

Support Support Options

Contact us Contact Sales

Authoritative Physician Database™(Beta)

Best-in-Class database of US physicians and practice groups.

Current data update release December 19, 2019

 

1 million+ U.S. Physicians with their specialties, practice group affiliations and locations, hospital affiliations, graduation year, infraction status, procedures performed, address, phone, fax and more.

 

At a price made possible by advanced automation, this is the database that brings all of the available information on U.S. HIPAA-covered physicians, their medical practices and hospitals together into a single, off-the-shelf, up-to-date relational database on your desktop or laptop computer. CarePrecise mines the complete physician, group and hospital data acquired from the US Department of Health and Human Services and proprietary sources, including information extracted from multiple databases and hundreds of millions of health insurance claims, using our QoRelate™ data collection technology – merged into one easy-to-use physician database for Microsoft Access or other spreadsheet, database or CRM software on Windows PC, Mac or Linux, and is ready to use immediately.

 

PRICING

 The Authoritative Physician Database (Beta)
Single Download, single user

INTRODUCTORY BETA PRICING:
$999 Download the Authoritative Physician Database... BUY

You can apply the full amount paid
to a subscription purchase within 30 days.
1 Year Subscription**
12 monthly updates, single user.

One year access to updated data: $4,455 Download the Authoritative Physician Database... BUY

12 monthly updates.
Site License add-on for multiple users
Site License for multiple users: $475 per year add-on for single download or 1 year subscription,in addition to data package price.
Redistribution License add-on

Call Sales: (877)-782-2294

 

You cannot find a more complete database of US physician information.

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

The APD integrates directly with our other data products to bring you the deepest and most complete information available on U.S. providers.  

 


Advanced data collection and record linkage technology

With the last full update release date of December 19, 2019 our data is constantly being refreshed with updated source data, using our proprietary record collection and linking technology based on advanced automation, making CarePrecise the leading provider of the most comprehensive, up-to-date and affordable medical provider data.

 

 

Physician and Group Procedure Volumes

The APD contains the most recent information on performance of medical procedures by physicians, with service counts and numbers of patients per procedure, including the ability display top procedures performed per practice group.

 

Physician, Group, and Hospital Contacts

Business addresses, phone numbers, and fax numbers are provided, including more than 24,000 cabinet-level contacts for practice groups, and more than 4,000 for hospitals.

 

 

DATA STRUCTURE

CarePrecise data sets connect together into a single source of truth regarding physicians and other healthcare providers. For instance, by adding Gold, Platinum, or the CarePrecise Access Complete 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 Co-Location Code.

DATA FIELDS

Printer-friendly version of the AHD database fieldsClick for a printer-friendly version of the fields list.

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

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

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" indicares that no procedure data has been reported for this physician. Top five HCPCS procedures performed by physician are listed. 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.		 HCPS_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 255

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

Scroll in the box above to view all data fields ↑ Click for a printer-friendly version of the fields list.

 

 Authoritative Physician Database

DATA CONTENTS

  Physicians Affiliated Groups Affiliated Hospitals
All 1,047,686 51,831 4,671
Rural 93,100 7,943 2,199
Non-Urban 93,369 7,962 2,200
Urban 952,839 40,514 2,465
With Fax 65.12% 46.45% 70.63%
Cabinet-level contacts   26,577 3,794

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.

 

 

FILE FORMATS

The product comes with data in both of the following formats:

  • Microsoft Access (.mdb)
  • Comma Separated Values (.csv) - may be used with any database software that supports import of standard CSV files and large file sizes

 

SUPPORT

The Single Download option includes 30 days of free Telephone and Email Technical Support. Subscription options come with 90 days of free Telephone and Email Technical Support. Additional support options are available – see support details.

 

SYSTEM REQUIREMENTS

You should have 2 gigabytes of RAM (4GB recommended) on your laptop or desktop computer. To use the Microsoft Acces database version of the full relational database, you must have Microsoft Access 2007 or newer installed on the 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. Using the AuthoritativePhysicianDB.mdb file in Microsoft Access, files may be exported for use in Microsoft Excel.

 

LICENSING

CarePrecise data is licensed for use by the purchaser and may not be redistributed without separate licensing. Redistribution licensing is available. Unless a redistribution or multi-user/site 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 may not be installed on multiple computers for use by multiple simultaneous users unless a Site License has been purchased. 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 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.

The data contained in CarePrecise® products and services is compiled and processed on an ongoing basis, with monthly update releases, from public and proprietary sources, including the complete National Plan & Provider Enumeration System (NPPES) data submitted by the providers themselves, Medicare Provider Enrollment Chain and Ownership System (PECOS), List of Excluded Individuals/Entities (LEIE), Medicare claims data, 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 shareholders, 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 Federal 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 any change in that information. Data is provided "as is" and in accordance with the Freedom of Information Act (FOIA) and e-FOIA ammendments, and relevant data dissemination notices. While these sources are considered among the most reliable available, no warranty is expressed or implied as to the accuracy, completeness, timeliness, fitness for any purpose, or absence of processing errors 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. Nothing in the product descriptions, in writing or verbal, may be construed as a warranty, guarantee, or representation of deliverability, save the deliverability guarantee on email addresses. All data ages between updates, and it is reasonable to expect that a portion of records will contain contact information that is incorrect or for other reasons undeliverable. Not all fields are populated with data for every record except where indicated; some fields are not populated due to restrictions imposed by a data supplier even though a field may be present for later use. Where percent of records populated is quoted, the percent quoted is subject to slight differences upon delivery as data is continuously updated. 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 CarePrecise datasets, particularly regarding alleged fraudulent or infraction activity given as reason for listing in data on excluded providers (records carrying "sanction", "desanction", "warning" and/or "exclusion" identifiers or flags). Data which has been in-matched using algorithmic rather than direct means will include a percentage of error; such data is labeled as such in the documentation. Algorithmic in-matching logic and processes are proprietary trade secrets. Subscriptions are fullfilled with quarterly or monthly releases containing the most recently released data from all pertinent sources. CarePrecise is a registered trademark, 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 LLC. All CarePrecise products including data, data structures, code, and related materials are the property of CarePrecise LLC and protected by U.S. and international copyright. Other trademarks and copyrights are the property of their respective owners. CarePrecise reserves the right to cease services and/or communication with parties that abuse its services or its personnel, or fail to comply with its terms of service. 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 a single user. Any form of dissemination, sharing, making public, distribution, or derivative product, whether or not for profit, is strictly forbidden without an alternative licensing arrangement; such licensing arrangements are available - please contact CarePrecise Sales for terms and pricing.
Policies and Terms of Use