[ROWS] 1530412
[PAGES] 3061
[FIELDS] 32
[MODIFIED] 2025-01-30
[DOWNLOAD] https://download.cms.gov/openpayments/PHPRFL_P01302025_01212025/OP_CVRD_RCPNT_PRFL_SPLMTL_P01302025_01212025.csv
26 Covered Recipient Profile Supplement
The Covered Recipient Profile Supplement file contains information about physicians and non-physician practitioners who have been indicated as recipients of payments, other transfers of value, or ownership and investment interest in payment records, as well as physicians and non-physician practitioners who have been identified as principal investigators associated with research payment records published by Open Payments.
This file contains only those physicians that have at least one published payment record in this cycle of the publication as of January 30, 2025. The criteria used by the Centers for Medicare & Medicaid Services (CMS) to determine which payment records are eligible for publication is available in the Open Payments Methodology and Data Dictionary Document.
This document can be found on the Resources page of the Open Payments website (https://www.cms.gov/OpenPayments/Resources). The Methodology and Data Dictionary Document also includes information on the data collection and reporting methodology, data fields included in the files, and any notes or special considerations that users should be aware of.
Metadata
Dictionary
covered_recipient_profile_type
Indicator showing if recipient of the payment or
other transfer of value is a covered recipient
physician or covered recipient non-physician
practitioner. Example values: Covered Recipient
Physician (If the profile is a Physician profile)
Covered Recipient Non-Physician Practitioner(If
the profile is a Non-Physician Practitioner
profile), Covered Recipient Physician/Covered
Recipient Non-Physician Practitioner (If the
profile is identified as both Physician and a
Non-Physician Practitioner)
covered_recipient_profile_id
System generated unique identifier for
physician/non- physician practitioner profile
receiving the payment or other transfer of value.
associated_covered_recipient_profile_id_1
Covered_Recipient_Profile_ID of first profile
(with/without NPI) associated with the same
physician/non-physician practitioner.
associated_covered_recipient_profile_id_2
Covered_Recipient_Profile_ID of second profile
(with/without NPI) associated with the same
physician/non-physician practitioner.
covered_recipient_npi
National Provider Identifier is a unique
identification number for covered recipient
physician or non-physician practitioner (and not
the NPI of a group the physician/non- physician
practitioner belongs to).
covered_recipient_profile_first_name
The first name as available in the CMS-provided
Master Profile List (MPL) for Physician-NPPs and
non-physician practitioner that were successfully
matched on the list. For physicians/non-physician
practitioner who are not on the CMS-provided MPL
and were matched against the external physician/
non-physician practitioner matching service, the
name as verified against the external physician/
non- physician practitioner matching service is
displayed.
covered_recipient_profile_middle_name
The middle name as available in the CMS-provided
MPL for physician/ non-physician practitioners
that were successfully matched on the list. For
physician/non- physician practitioner s who are
not on the CMS-provided MPL and were matched
against the external physician/ non-physician
practitioner matching service, the middle name
is determined by the most frequently reported
by AM/GPOs through the record submission in the
latest year when the physician/ non-physician
practitioner is reported.
covered_recipient_profile_last_name
The last name as available in the CMS-provided
MPL provided by CMS for physician/ non-physician
practitioners that were successfully matched
on the list. For physician/ non-physician
practitioners who are not on the CMS- provided MPL
and were matched against the external physician/
non-physician practitioner matching service, the
name as verified against the external physician/
non- physician practitioner matching service is
displayed.
covered_recipient_profile_suffix
The suffix as available in the CMS-provided
MPL for physician/non-physician practitioners
that were successfully matched on the list. For
physician/non- physician practitioners who are not
on the CMS-provided MPL and were matched against
the external physician/non-physician practitioner
matching service, the suffix is determined by
the most frequently reported by AM/GPOs through
the record submission in the latest year when the
physician/non-physician practitioner is reported.
covered_recipient_profile_alternate_first_name
The alternate first name as available in the
CMS-provided MPL for physician/non-physician
practitioner that were successfully matched
on the list. For physician/non- physician
practitioner who are not on the CMS-provided
MPL and were matched against the external
physician/non-physician practitioner matching
service, the alternate first name is displayed
blank.
covered_recipient_profile_alternate_middle_name
The alternate middle name as available in the
CMS- provided MPL for physician/non-physician
practitioner that were successfully
matched on the list. For physician/non-
physician practitioner r who are not on the
CMS-provided MPL and were matched against the
externalphysician/non-physician practitioner
matching service, the alternate middle name is
displayed blank.
covered_recipient_profile_alternate_last_name
The alternate last name as available in the
CMS-provided MPL for physician/non-physician
practitioners that were successfully matched
on the list. For physician/non- physician
practitioner who are not on the CMS-provided
MPL and were matched against the external
physician/non-physician practitioner matching
service, the alternate last name is displayed
blank.
covered_recipient_profile_alternate_suffix
The alternate suffix as available in the
CMS-provided MPL for physician/non-physician
practitioner that were successfully matched
on the list. For physician/non- physician
practitioner who are not on the CMS-provided
MPL and were matched against the external
physician/non-physician practitioner matching
service, the alternate suffix is displayed blank.
covered_recipient_profile_address_line_1
The first line of latest Provider
Business Practice Location Address for all
physician/non-physician practitioner that
matched as listed in the CMS-provided MPL.
If address information is blank in MPL, the
first line of latest Provider Business Practice
Location Address will be determined by the most
frequently reported address by AM/GPOs through
the records submission in the latest year when
the physician/non-physician practitioner is
reported.For physician/non-physician practitioner
not on the CMS- provided MPL and matched against
the external physician/non-physician practitioner
matching service, the second line of latest
Provider Business Practice Location Address will
be determined by the most frequently reported
address by AM/GPOs through the records submission
in the latest year when the physician/non-
physician practitioner is reported. AM/GPOs
through the records submission in the latest year
when the physician/non-physician practitioner is
reported.
covered_recipient_profile_address_line_2
The second line of latest Provider
Business Practice Location Address for all
physician/non-physician practitioner that
matched as listed in the CMS-provided MPL. If
address information is blank in MPL, the second
line of latest Provider Business Practice
Location Address will be determined by the most
frequently reported address by AM/GPOs through
the records submission in the latest year when
the physician/non-physician practitioner is
reported.For physician/non-physician practitioner
not on the CMS- provided MPL and matched against
the external physician/non-physician practitioner
matching service, the second line of latest
Provider Business Practice Location Address will
be determined by the most frequently reported
address by AM/GPOs through the records submission
in the latest year when the physician/non-
physician practitioner is reported. AM/GPOs
through the records submission in the latest year
when the physician/non-physician practitioner is
reported.
covered_recipient_profile_city
The city of the latest Provider Business Practice
Location Address for all physician/non-physician
practitioner that matched as listed in the
CMS-provided MPL. If Address information is blank
in MPL, the city of the latest Provider Business
Practice Location Address will be determined by
the most frequently reported address by AM/GPOs
through the records submission in the latest year
when the physician/non-physician practitioner is
reported.For physician/non-physician practitioner
not on the CMS- provided MPL and matched against
the external physician/non-physician practitioner
matching service, the city of the latest Provider
Business Practice Location Address will be
determined by the most frequently reported address
by AM/GPOs through the records submission in the
latest year when the physician/non- physician
practitioner is reported.
covered_recipient_profile_state
The state of latest Provider Business Practice
Location Address for all physician/non-physician
practitioners that matched as listed in the
CMS-provided MPL. If Address information is blank
in MPL, the state of latest Provider Business
Practice Location Address will be determined by
the most frequently reported address by AM/GPOs
through the records submission in the latest year
when the physician/non-physician practitioner is
reported.For physician/non-physician practitioners
not on the CMS- provided MPL and matched against
the external physician/non-physician practitioner
matching service, the state of latest Provider
Business Practice Location Address will be
determined by the most frequently reported address
by AM/GPOs through the records submission in the
latest year when the physician/non- physician
practitioner is reported.
covered_recipient_profile_zipcode
The zip code of latest Provider Business Practice
Location Address for all physician/non-physician
practitioners that matched as listed in the
CMS-provided MPL. If Address information is blank
in MPL, the zip code of latest Provider Business
Practice Location Address will be determined by
the most frequently reported address by AM/GPOs
through the records submission in the latest year
when the physician/non-physician practitioner is
reported.For physician/non-physician practitioners
not on the CMS- provided MPL and matched against
the external physician/non-physician practitioner
matching service, the zip code of latest Provider
Business Practice Location Address will be
determined by the most frequently reported address
by AM/GPOs through the records submission in the
latest year when the physician/non- physician
practitioner is reported. AM/GPOs through the
records submission in the latest year when the
physician/non-physician practitioner is reported.
covered_recipient_profile_country_name
The country of latest Provider Business Practice
Location Address provided as listed in the
CMS-provided MPL for all physician/non-physician
practitioners that were successfully matched
on the list. If Address information is blank in
MPL, the country name of latest Provider Business
Practice Location Address will be determined by
the most frequently reported address by AM/GPOs
through the records submission in the latest year
when the physician/non-physician practitioner
is reported.For physician/non-physician
practitioners who are not on the CMS-provided
MPL and were matched against the external
physician/non-physician practitioner matching
service, the country of latest Provider Business
Practice Location Address will be determined by
the most frequently reported address by AM/GPOs
through the record submission in the latest year
when thephysician/non-physician practitioner is
reported.
covered_recipient_profile_province_name
The state of latest Provider Business Practice
Location Address for all physician/non-physician
practitioners that matched as listed in CMS
provided Master Profile List (MPL), if the
primary practice/business address is outside
the United States and if applicable. If Address
information is blank in MPL, the province
name of latest Provider Business Practice
Location Address will be determined by the most
frequently reported address by AM/GPOs through
the records submission in the latest year
when the physician/non-physician practitioner
is reportedFor physician/non-physician
practitioners not on the CMS provided Master
physician/non-physician practitioner List (MPL)
and matched against external physician/non-
physician practitioner matching service, the
province name of latest Provider Business Practice
Location Address will be determined by the most
frequently reported address by AM/GPOs through
the records submission in the latest year when the
physician/non-physician practitioner is reported,
if the primary practice/business address is
outside the United States and if applicable.
covered_recipient_profile_primary_specialty
The primary specialty as listed in the
CMS-provided MPL for physician/non-physician
practitioners that were successfully matched
on the list and have a valid Open Payments
primary taxonomy. For physician/non-physician
practitioners on the list and any other primary
taxonomy than the valid Open Payments primary
taxonomy and for physician/non-physician
practitioners who are not on the CMS-provided
MPL and were matched against the external
physician/non-physician practitioner matching
service, the primary specialty displayed as blank.
covered_recipient_profile_ops_taxonomy_1
The primary or secondary Open Payments valid
taxonomy code as listed in the CMS-provided
MPL for physician/non- physician practitioners
that were successfully matched on the list
and have a valid Open Payments taxonomy.For
physician/non-physician practitioners on the list
with Primary or Secondary Taxonomy other than a
valid Open Payments taxonomy, it will be displayed
as the most frequently reported valid taxonomy
by AM/GPOs in the published records across all
Program Years in all payment categories where the
physician/non-physician practitioner was reported.
If no valid taxonomy is reported, it should remain
blank.For physician/non-physician practitioners
who are not on the CMS provided MPL and were
matched against external data source, the Open
Payments Taxonomy will be displayed as the most
frequently reported by AM/GPOs, assuming that it
corresponds to a valid OP Taxonomy code.
covered_recipient_profile_ops_taxonomy_2
The secondary Open Payments valid taxonomy code as
listed in the CMS-provided MPL for physician/non-
physician practitioners that were successfully
matched on the list and have a valid Open Payments
taxonomy.For physician/non-physician practitioners
on the list with Primary or Secondary Taxonomy
other than a valid Open Payments taxonomy, it
will be displayed as the most frequently reported
valid taxonomy by AM/GPOs in the published records
across all Program Years in all payment categories
where the physician/non-physician practitioner
was reported. If no valid taxonomy is reported,
it should remain blank.For physician/non-physician
practitioners who are not on the CMS provided MPL
and were matched against external data source, the
Open Payments Taxonomy will be displayed as the
most frequently reported by AM/GPOs, assuming that
it corresponds to a valid OP Taxonomy code.
covered_recipient_profile_ops_taxonomy_3
The secondary Open Payments valid taxonomy code as
listed in the CMS-provided MPL for physician/non-
physician practitioners that were successfully
matched on the list and have a valid Open Payments
taxonomy.For physician/non-physician practitioners
on the list with Primary or Secondary Taxonomy
other than a valid Open Payments taxonomy, it
will be displayed as the most frequently reported
valid taxonomy by AM/GPOs in the published records
across all Program Years in all payment categories
where the physician/non-physician practitioner
was reported. If no valid taxonomy is reported,
it should remain blank.For physician/non-physician
practitioners who are not on the CMS provided MPL
and were matched against external data source, the
Open Payments Taxonomy will be displayed as the
most frequently reported by AM/GPOs, assuming that
it corresponds to a valid OP Taxonomy code.
covered_recipient_profile_ops_taxonomy_4
The secondary Open Payments valid taxonomy code as
listed in the CMS-provided MPL for physician/non-
physician practitioners that were successfully
matched on the list and have a valid Open Payments
taxonomy.For physician/non-physician practitioners
on the list with Primary or Secondary Taxonomy
other than a valid Open Payments taxonomy, it
will be displayed as the most frequently reported
valid taxonomy by AM/GPOs in the published records
across all Program Years in all payment categories
where the physician/non-physician practitioner
was reported. If no valid taxonomy is reported,
it should remain blank.For physician/non-physician
practitioners who are not on the CMS provided MPL
and were matched against external data source, the
Open Payments Taxonomy will be displayed as the
most frequently reported by AM/GPOs, assuming that
it corresponds to a valid OP Taxonomy code.
covered_recipient_profile_ops_taxonomy_5
The secondary Open Payments valid taxonomy code as
listed in the CMS-provided MPL for physician/non-
physician practitioners that were successfully
matched on the list and have a valid Open Payments
taxonomy.For physician/non-physician practitioners
on the list with Primary or Secondary Taxonomy
other than a valid Open Payments taxonomy, it
will be displayed as the most frequently reported
valid taxonomy by AM/GPOs in the published records
across all Program Years in all payment categories
where the physician/non-physician practitioner
was reported. If no valid taxonomy is reported,
it should remain blank.For physician/non-physician
practitioners who are not on the CMS provided MPL
and were matched against external data source, the
Open Payments Taxonomy will be displayed as the
most frequently reported by AM/GPOs, assuming that
it corresponds to a valid OP Taxonomy code.
covered_recipient_profile_ops_taxonomy_6
The secondary Open Payments valid taxonomy code as
listed in the CMS-provided MPL for physician/non-
physician practitioners that were successfully
matched on the list and have a valid Open Payments
taxonomy.For physician/non-physician practitioners
on the list with Primary or Secondary Taxonomy
other than a valid Open Payments taxonomy, it
will be displayed as the most frequently reported
valid taxonomy by AM/GPOs in the published records
across all Program Years in all payment categories
where the physician/non-physician practitioner
was reported. If no valid taxonomy is reported,
it should remain blank.For physician/non-physician
practitioners who are not on the CMS provided MPL
and were matched against external data source, the
Open Payments Taxonomy will be displayed as the
most frequently reported by AM/GPOs, assuming that
it corresponds to a valid OP Taxonomy code.
covered_recipient_profile_license_state_code_1
The license state code of the
physician/non-physician practitioner profile
in Open Payments system, which is a 2- letter
state abbreviation. The physician/non-physician
practitioner may have up to 5 license states, if
a physician/non-physician practitioner is licensed
in multiple states.
covered_recipient_profile_license_state_code_2
The license state code of the physician
profile/Non- Physician Practitioner in Open
Payments system, which is a 2-letter state
abbreviation. The physician/non-physician
practitioner may have up to 5 license states, if
a physician/non-physician practitioner is licensed
in multiple states.
covered_recipient_profile_license_state_code_3
The license state code of the
physician/non-physician practitioner profile
in Open Payments system, which is a 2- letter
state abbreviation. The physician/non-physician
practitioner may have up to 5 license states, if
a physician/non-physician practitioner is licensed
in multiple states.
covered_recipient_profile_license_state_code_4
The license state code of the
physician/non-physician practitioner profile
in Open Payments system, which is a 2- letter
state abbreviation. The physician/non-physician
practitioner may have up to 5 license states, if
a physician/non-physician practitioner is licensed
in multiple states.
covered_recipient_profile_license_state_code_5
The license state code of the
physician/non-physician practitioner profile
in Open Payments system, which is a 2- letter
state abbreviation. The physician/non-physician
practitioner may have up to 5 license states, if
a physician/non-physician practitioner is licensed
in multiple states.
Data
tibble [500 × 32] (S3: tbl_df/tbl/data.frame)
$ covered_recipient_profile_type : chr [1:500] "Covered Recipient Physician" "Covered Recipient Physician" "Covered Recipient Physician" "Covered Recipient Physician" ...
$ covered_recipient_profile_id : chr [1:500] "1" "2" "3" "4" ...
$ associated_covered_recipient_profile_id_1 : chr [1:500] NA NA NA NA ...
$ associated_covered_recipient_profile_id_2 : chr [1:500] NA NA NA NA ...
$ covered_recipient_npi : chr [1:500] "1003020595" "1003022823" "1003023359" "1003024811" ...
$ covered_recipient_profile_first_name : chr [1:500] "BARRY" "LINDSEY" "JUSTIN" "LISA" ...
$ covered_recipient_profile_middle_name : chr [1:500] "D" "R" "H" "L" ...
$ covered_recipient_profile_last_name : chr [1:500] "SIMMONS" "SCHUSTER" "RACKLEY" "HAMAKER" ...
$ covered_recipient_profile_suffix : chr [1:500] NA NA NA NA ...
$ covered_recipient_profile_alternate_first_name : chr [1:500] "BARRON" "LINDSEY" "JUSTIN" NA ...
$ covered_recipient_profile_alternate_middle_name: chr [1:500] "DAVID" "R" "HAMWAY" NA ...
$ covered_recipient_profile_alternate_last_name : chr [1:500] "SIMMONS" "GROBER" "RACKLEY" NA ...
$ covered_recipient_profile_alternate_suffix : chr [1:500] NA NA NA NA ...
$ covered_recipient_profile_address_line_1 : chr [1:500] "847 SOUTH MILLEDGE AVE" "15 HEIDI LN" "1001 SAM PERRY BLVD" "100 MARKET ST STE 300" ...
$ covered_recipient_profile_address_line_2 : chr [1:500] NA NA NA NA ...
$ covered_recipient_profile_city : chr [1:500] "ATHENS" "MOUNT SINAI" "FREDERICKSBURG" "COLLEGEVILLE" ...
$ covered_recipient_profile_state : chr [1:500] "GA" "NY" "VA" "PA" ...
$ covered_recipient_profile_zipcode : chr [1:500] "30605-1331" "11766-1428" "22401-4453" "19426-4927" ...
$ covered_recipient_profile_country_name : chr [1:500] "UNITED STATES" "UNITED STATES" "UNITED STATES" "UNITED STATES" ...
$ covered_recipient_profile_province_name : chr [1:500] NA NA NA NA ...
$ covered_recipient_profile_primary_specialty : chr [1:500] "Dental Providers|Dentist|General Practice" "Allopathic & Osteopathic Physicians|Emergency Medicine" "Allopathic & Osteopathic Physicians|Anesthesiology" "Allopathic & Osteopathic Physicians|Internal Medicine|Endocrinology, Diabetes & Metabolism" ...
$ covered_recipient_profile_ops_taxonomy_1 : chr [1:500] "1223G0001X" "207P00000X" "207L00000X" "207RE0101X" ...
$ covered_recipient_profile_ops_taxonomy_2 : chr [1:500] NA NA NA NA ...
$ covered_recipient_profile_ops_taxonomy_3 : chr [1:500] NA NA NA NA ...
$ covered_recipient_profile_ops_taxonomy_4 : chr [1:500] NA NA NA NA ...
$ covered_recipient_profile_ops_taxonomy_5 : chr [1:500] NA NA NA NA ...
$ covered_recipient_profile_ops_taxonomy_6 : chr [1:500] NA NA NA NA ...
$ covered_recipient_profile_license_state_code_1 : chr [1:500] "GA" "NY" "VA" "PA" ...
$ covered_recipient_profile_license_state_code_2 : chr [1:500] NA "PA" "OH" NA ...
$ covered_recipient_profile_license_state_code_3 : chr [1:500] NA NA NA NA ...
$ covered_recipient_profile_license_state_code_4 : chr [1:500] NA NA NA NA ...
$ covered_recipient_profile_license_state_code_5 : chr [1:500] NA NA NA NA ...
Tidyup
x <- cheapr::overview(resp, hist = TRUE)
x$categorical |> slt(col, n_missing, n_unique) col n_missing n_unique
1 covered_recipient_profile_type 0 2
2 covered_recipient_profile_id 0 500
3 associated_covered_recipient_profile_id_1 498 2
4 associated_covered_recipient_profile_id_2 500 0
5 covered_recipient_npi 0 500
6 covered_recipient_profile_first_name 0 328
7 covered_recipient_profile_middle_name 136 87
8 covered_recipient_profile_last_name 0 473
9 covered_recipient_profile_suffix 488 3
10 covered_recipient_profile_alternate_first_name 256 184
11 covered_recipient_profile_alternate_middle_name 296 122
12 covered_recipient_profile_alternate_last_name 256 242
13 covered_recipient_profile_alternate_suffix 489 3
14 covered_recipient_profile_address_line_1 0 495
15 covered_recipient_profile_address_line_2 274 177
16 covered_recipient_profile_city 0 369
17 covered_recipient_profile_state 0 46
18 covered_recipient_profile_zipcode 0 495
19 covered_recipient_profile_country_name 0 1
20 covered_recipient_profile_province_name 500 0
21 covered_recipient_profile_primary_specialty 14 85
22 covered_recipient_profile_ops_taxonomy_1 0 78
23 covered_recipient_profile_ops_taxonomy_2 402 61
24 covered_recipient_profile_ops_taxonomy_3 477 17
25 covered_recipient_profile_ops_taxonomy_4 494 6
26 covered_recipient_profile_ops_taxonomy_5 497 2
27 covered_recipient_profile_ops_taxonomy_6 498 2
28 covered_recipient_profile_license_state_code_1 0 44
29 covered_recipient_profile_license_state_code_2 277 47
30 covered_recipient_profile_license_state_code_3 411 33
31 covered_recipient_profile_license_state_code_4 455 29
32 covered_recipient_profile_license_state_code_5 485 13