Physician and Physician Practice Research Database (3P-RD)
The Physician and Physician Practice Research Database (3P-RD) captures characteristics of physicians and physician practices in 13 states. The database describes the supply of physician services available across selected states for data year 2019-2020. AHRQ created 3P-RD as a resource to address existing data gaps in physician health services information at the state and market levels.
3P-RD consists of both public use and restricted use data files. The public use file (PUF) version of 3P-RD is currently available for download. Go to data files and documentation below.
The Restricted Use File (RUF) version of 3P-RD will be available for each state. Once the data are released, a data use agreement (DUA) will be required for access to the data files.
- The Agency for Healthcare Research and Quality (AHRQ) created the 3P-RD core files by linking state medical board licensure data to the National Plan & Provider Enumeration System (NPPES) and the Medicare Provider Enrollment, Chain, and Ownership System (PECOS) for data year 2019-2020. The database was supplemented and enhanced using available state and national claims files.
- 3P-RD contains harmonized data elements related to physician and physician practice data characteristics for 13 states: Arkansas, Arizona, California, Colorado, Florida, Massachusetts, Maryland, Minnesota, Missouri, Montana, New York, Texas, and Washington.
- 3P-RD was designed as a resource to address supply-side policy questions and to support policy-relevant health services research.
- 3P-RD contains linkable files for physicians and physician practices in each of 13 states, focused on the current roles of actively practicing physicians and corresponding relationships within practices and facilities.
Data Files
- PUF - The PUF versions of 3P-RD consist of 52 individual data files from 13 states.
- RUF – The RUF versions of 3P- RD consist of 52 individual data files from 13 states and include all PUF data elements with enhancements.
The PUF versions of 3P-RD consist of 52 individual data files as each of the 13 states included in the database has four data files:
- Physician Practice Directory.
- Physician Geographic.
- Physician Practice Geographic.
- Physician Directory.
Physician Practice files provide characteristics of physician practices in each participating state. Physician Geographic and Physician Practice Geographic files provide summaries of data at the 3-digit ZIP Code level.
The Physician Practice, Physician Geographic, and Physician Practice Geographic files are available for download below. The data are available in CSV, SAS, and Stata formats.
AHRQ requests that users cite AHRQ and the 3P-RD as the data source in any publications or research based on these data.
Note: Each zip file contains four data files for the state: one Physician Practice Directory file, one Physician Directory file, one Physician Geographic file, and one Physician Practice Geographic file.
| State | Comma-Separated Values (.csv) | SAS Datasets (.sas7bdat) | Stata Datasets (.dta) |
|---|---|---|---|
| AR-Arkansas | AR_PUF_cvs (zip, 563 KB) | AR_PUF_sas (zip, 767 KB) | AR_PUF_stata (zip, 1.3 MB) |
| AZ-Arizona | AZ_PUF_csv (zip, 1 MB) | AZ_PUF_sas (zip, 1.2 MB) | AZ_PUF_stata (zip, 1.8 MB) |
| CA-California | CA_PUF_csv (zip, 6 MB) | CA_PUF_sas (zip, 7.3 MB) | CA_PUF_stata (zip, 11 MB) |
| CO-Colorado | CO_PUF_csv (zip, 1.3 MB) | CO_PUF_sas (zip, 1.7 MB) | CO_PUF_stata (zip, 3.4 MB) |
| FL-Florida | FL_PUF_csv (zip, 3.5 MB) | FL_PUF_sas (zip, 4.5 MB) | FL_PUF_stata (zip, 6.5 MB) |
| MA-Massachusetts | MA_PUF_csv (zip, 2 MB) | MA_PUF_sas (zip, 2.4 MB) | MA_PUF_stata (zip, 3.3 MB) |
| MD-Maryland | MD_PUF_csv (zip, 1.8 MB) | MD_PUF_sas (zip, 2.4 MB) | MD_PUF_stata (zip, 4.6 MB) |
| MN-Minnesota | MN_PUF_csv (zip, 962 KB) | MN_PUF_sas (zip, 1.2 MB) | MN_PUF_stata (zip, 1.7 MB) |
| MO-Missouri | MO_PUF_csv (zip, 855 KB) | MO_PUF_sas (zip, 1 MB) | MO_PUF_stata (zip, 1.5 MB) |
| MT-Montana | MT_PUF_csv (zip, 144 KB) | MT_PUF_sas (zip, 200 KB) | MT_PUF_stata (zip, 257 KB) |
| NY-New York | NY_PUF_csv (zip, 3 MB) | NY_PUF_sas (zip, 3.7 MB) | NY_PUF_stata (zip, 5.4 MB) |
| TX-Texas | TX_PUF_csv (zip, 4 MB) | TX_PUF_sas (zip, 5 MB) | TX_PUF_stata (zip, 7 MB) |
| WA-Washington | WA_PUF_csv (zip, 1.5 MB) | WA_PUF_sas (zip, 1.8 MB) | WA_PUF_stata (zip, 3 MB) |
The RUF versions of 3P-RD consist of 52 individual data files as each of the 13 states included in the database has four data files:
- Physician Directory.
- Physician Practice Directory.
- Physician Geographic.
- Physician Practice Geographic.
Physician Directory and Physician Practice Directory RUF files provide characteristics of physician and physician practices in each participating state. The files include all the PUF data elements with enhancements. Physician Directory additionally includes physician insurance billing flags (Medicare, Medicaid) and may include a flag for active practicing status. Physician Practice Directory additionally includes specialty flags (hospitalist specialty, hospital-based specialty). Physician Geographic and Physician Practice Geographic files provide summaries of data at the 5-digit ZIP Code level.
The Restricted Use File (RUF) version of 3P-RD requires a data use agreement (in progress) for access to the data files.
Download the following 3P-RD documentation along with the data:
- AHRQ Physician and Physician Practice Research Database Feasibility Report, (PDF, 1.5 MB)
- AHRQ Physician and Physician Practice Research Database Methodology Report (PDF, 6 MB).
- AHRQ Physician and Physician Practice Research Database Data Dictionary - Geographic Level (XLSX, 26 KB).
- AHRQ Physician and Physician Practice Research Database Physician Geographic - Public Use File Codebook (PDF, 758 KB).
- AHRQ Physician and Physician Practice Research Database Physician Practice Geographic - Public Use File Codebook (PDF, 5 MB).
- AHRQ Physician and Physician Practice Research Database Data Dictionary (NEW) (XLSX, 22 KB).
- AHRQ Physician and Physician Practice Research Database Physician Practice Directory Public Use File Codebook (PDF, 599 KB).
- AHRQ Physician and Physician Practice Research Database Physician Directory Public Use File Codebook (PDF, 302 KB).
Email any questions about 3P-RD to datainnovations@ahrq.hhs.gov.
