| Covered Recipient Profile Supplement | |
| 1 |
associated_covered_recipient_profile_id_1: Covered_Recipient_Profile_ID of first profile (with/without NPI) associated with the same physician/non-physician practitioner. |
| 2 |
associated_covered_recipient_profile_id_2: Covered_Recipient_Profile_ID of second profile (with/without NPI) associated with the same physician/non-physician practitioner. |
| 3 |
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). |
| 4 |
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. |
| 5 |
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. |
| 6 |
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. |
| 7 |
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. |
| 8 |
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 external physician/non-physician practitioner matching service, the alternate middle name is displayed blank. |
| 9 |
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. |
| 10 |
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. |
| 11 |
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 the physician/non-physician practitioner is reported. |
| 12 |
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. |
| 13 |
covered_recipient_profile_id: System generated unique identifier for physician/non- physician practitioner profile receiving the payment or other transfer of value. |
| 14 |
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. |
| 15 |
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. |
| 16 |
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. |
| 17 |
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. |
| 18 |
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. |
| 19 |
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. |
| 20 |
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. |
| 21 |
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. |
| 22 |
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. |
| 23 |
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. |
| 24 |
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. |
| 25 |
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. |
| 26 |
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. |
| 27 |
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. |
| 28 |
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 reported For 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. |
| 29 |
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. |
| 30 |
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. |
| 31 |
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) |
| 32 |
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. |
Open Payments
Dictionaries
| General Payment Data | |
| 1 |
applicable_manufacturer_or_applicable_gpo_making_payment_country: Country name of the Submitting Applicable Manufacturer or Submitting Applicable Group Purchasing Organization (GPO) as provided in Open Payments |
| 2 |
applicable_manufacturer_or_applicable_gpo_making_payment_id: System generated unique identifier of the Applicable Manufacturer or Applicable Group Purchasing Organization (GPO) Making a payment or other transfer of value |
| 3 |
applicable_manufacturer_or_applicable_gpo_making_payment_name: The textual proper name of the applicable manufacturer or applicable GPO making the payment or other transfer of value |
| 4 |
applicable_manufacturer_or_applicable_gpo_making_payment_state: State name of the submitting applicable manufacturer or submitting applicable GPO as provided in Open Payments |
| 5 |
associated_device_or_medical_supply_pdi_1: The Primary Device Identifier, if any, of the covered device or covered medical supply associated with the payment or other transfer of values (if applicable); the record may report up to 5 codes. Note: OP Program began collecting PDI information during PY 2021. |
| 6 |
associated_device_or_medical_supply_pdi_2: The Primary Device Identifier, if any, of the covered device or covered medical supply associated with the payment or other transfer of values (if applicable); the record may report up to 5 codes. Note: OP Program began collecting PDI information during PY 2021. |
| 7 |
associated_device_or_medical_supply_pdi_3: The Primary Device Identifier, if any, of the covered device or covered medical supply associated with the payment or other transfer of values (if applicable); the record may report up to 5 codes. Note: OP Program began collecting PDI information during PY 2021. |
| 8 |
associated_device_or_medical_supply_pdi_4: The Primary Device Identifier, if any, of the covered device or covered medical supply associated with the payment or other transfer of values (if applicable); the record may report up to 5 codes. Note: OP Program began collecting PDI information during PY 2021. |
| 9 |
associated_device_or_medical_supply_pdi_5: The Primary Device Identifier, if any, of the covered device or covered medical supply associated with the payment or other transfer of values (if applicable); the record may report up to 5 codes. Note: OP Program began collecting PDI information during PY 2021. |
| 10 |
associated_drug_or_biological_ndc_1: The National Drug Code, if any, of the drug or biological associated with the payment or other transfer of value (if applicable); the record may report up to 5 codes |
| 11 |
associated_drug_or_biological_ndc_2: The National Drug Code, if any, of the drug or biological associated with the payment or other transfer of value (if applicable); the record may report up to 5 codes |
| 12 |
associated_drug_or_biological_ndc_3: The National Drug Code, if any, of the drug or biological associated with the payment or other transfer of value (if applicable); the record may report up to 5 codes |
| 13 |
associated_drug_or_biological_ndc_4: The National Drug Code, if any, of the drug or biological associated with the payment or other transfer of value (if applicable); the record may report up to 5 codes |
| 14 |
associated_drug_or_biological_ndc_5: The National Drug Code, if any, of the drug or biological associated with the payment or other transfer of value (if applicable); the record may report up to 5 codes |
| 15 |
change_type: An indicator showing if the payment record is New, Added, Changed, or Unchanged in the current publication compared to the previous publication. NEW - To identify new records added from the end of the previous submission deadline until the current submission period deadline date ADDED - To identify records that were not eligible at the time of previous publication, which is eligible for current publication. CHANGED - To identify previously published records modified after the last publication. UNCHANGED - To identify previously published records that remain unchanged in current publication. |
| 16 |
charity_indicator: Indicates the third party entity that received the payment or other transfer of value is a charity. |
| 17 |
city_of_travel: For Travel and Lodging payments, destination city where covered recipient traveled. |
| 18 |
contextual_information: Any free String, which the reporting entity deems helpful or appropriate regarding this payment or other transfer of value. |
| 19 |
country_of_travel: For Travel and Lodging payments, the destination country where the covered recipient traveled. |
| 20 |
covered_or_noncovered_indicator_1: Each product listed in relation to the payment or other transfer of value, indicates if the product is a covered or non-covered product per the covered product definition in the Open Payments final rule. |
| 21 |
covered_or_noncovered_indicator_2: For each product listed in relation to the payment or other transfer of value, indicates if the product is a covered or non- covered product per the covered product definition in the Open Payments final rule. |
| 22 |
covered_or_noncovered_indicator_3: For each product listed in relation to the payment or other transfer of value, indicates if the product is a covered or non- covered product per the covered product definition in the Open Payments final rule. |
| 23 |
covered_or_noncovered_indicator_4: For each product listed in relation to the payment or other transfer of value, indicates if the product is a covered or non- covered product per the covered product definition in the Open Payments final rule. |
| 24 |
covered_or_noncovered_indicator_5: For each product listed in relation to the payment or other transfer of value, indicates if the product is a covered or non- covered product per the covered product definition in the Open Payments final rule. |
| 25 |
covered_recipient_first_name: First name of the covered recipient physician or covered recipient non-physician practitioner receiving the payment or transfer of value, as reported by the submitting entity. |
| 26 |
covered_recipient_last_name: Last name of the covered recipient physician or covered recipient non-physician practitioner receiving the payment or transfer of value, as reported by the submitting entity. |
| 27 |
covered_recipient_license_state_code1: The state license number of the covered recipient physician or covered recipient non-physician practitioner, which is a 2- letter state abbreviation; the record may include up to 5 license states, if a physician is licensed in multiple states. |
| 28 |
covered_recipient_license_state_code2: The state license number of the covered recipient physician or covered recipient non-physician practitioner, which is a 2- letter state abbreviation; the record may include up to 5 license states, if a physician is licensed in multiple states. |
| 29 |
covered_recipient_license_state_code3: The state license number of the covered recipient physician or covered recipient non-physician practitioner, which is a 2- letter state abbreviation; the record may include up to 5 license states, if a physician is licensed in multiple states. |
| 30 |
covered_recipient_license_state_code4: The state license number of the covered recipient physician or covered recipient non-physician practitioner, which is a 2- letter state abbreviation; the record may include up to 5 license states, if a physician is licensed in multiple states. |
| 31 |
covered_recipient_license_state_code5: The state license number of the covered recipient physician or covered recipient non-physician practitioner, which is a 2- letter state abbreviation; the record may include up to 5 license states, if a physician is licensed in multiple states. |
| 32 |
covered_recipient_middle_name: Middle name of the covered recipient physician or covered recipient non-physician practitioner receiving the payment or transfer of value, as reported by the submitting entity. |
| 33 |
covered_recipient_name_suffix: Name suffix of the covered recipient physician or covered recipient non-physician practitioner receiving the payment or transfer of value, as reported by the submitting entity. |
| 34 |
covered_recipient_npi: National Provider Identifier is a unique identification number for covered recipient physician or covered recipient non- physician practitioner (and not the NPI of a group the physician/non-physician practitioner belongs to). |
| 35 |
covered_recipient_primary_type_1: Primary type of medicine practiced by the physician or Non- Physician Practitioner (covered recipient). |
| 36 |
covered_recipient_primary_type_2: Primary type of medicine practiced by the physician or Non- Physician Practitioner (covered recipient). Note: OP began accepting this field in PY2021. |
| 37 |
covered_recipient_primary_type_3: Primary type of medicine practiced by the physician or Non- Physician Practitioner (covered recipient). Note: OP began accepting this field in PY2021. |
| 38 |
covered_recipient_primary_type_4: Primary type of medicine practiced by the physician or Non- Physician Practitioner (covered recipient). Note: OP began accepting this field in PY2021. |
| 39 |
covered_recipient_primary_type_5: Primary type of medicine practiced by the physician or Non- Physician Practitioner (covered recipient). Note: OP began accepting this field in PY2021. |
| 40 |
covered_recipient_primary_type_6: Primary type of medicine practiced by the physician or Non- Physician Practitioner (covered recipient). Note: OP began accepting this field in PY2021. |
| 41 |
covered_recipient_profile_id: System generated unique identifier for covered recipient physician or covered recipient non-physician practitioner profile receiving the payment or other transfer of value. |
| 42 |
covered_recipient_specialty_1: Physicians or non-physician practitioners specialty chosen from the standardized provider taxonomy code list. Note: OP began accepting this field in PY2021. |
| 43 |
covered_recipient_specialty_2: Physicians or non-physician practitioners specialty chosen from the standardized provider taxonomy code list. Note: OP began accepting this field in PY2021. |
| 44 |
covered_recipient_specialty_3: Physicians or non-physician practitioners specialty chosen from the standardized provider taxonomy code list. Note: OP began accepting this field in PY2021. |
| 45 |
covered_recipient_specialty_4: Physicians or non-physician practitioners specialty chosen from the standardized provider taxonomy code list. Note: OP began accepting this field in PY2021. |
| 46 |
covered_recipient_specialty_5: Physicians or non-physician practitioners specialty chosen from the standardized provider taxonomy code list. Note: OP began accepting this field in PY2021. |
| 47 |
covered_recipient_specialty_6: Physicians or non-physician practitioners specialty chosen from the standardized provider taxonomy code list. Note: OP began accepting this field in PY2021. |
| 48 |
covered_recipient_type: An indicator showing if the recipient of the payment or transfer of value is a physician-covered recipient or non- physician practitioner or a teaching hospital. |
| 49 |
date_of_payment: If a singular payment, then this is the actual date the payment was issued; if a series of payments or an aggregated set of payments, this is the date of the first payment to the covered recipient in this program year |
| 50 |
delay_in_publication_indicator: An indicator showing if an Applicable Manufacturer/GPO is requesting a delay in the publication of a payment or other transfer of value |
| 51 |
dispute_status_for_publication: Indicates whether the payment or other transfer of value is disputed by the covered recipient or not |
| 52 |
form_of_payment_or_transfer_of_value: The method of payment used to pay the covered recipient or to make the transfer of value. |
| 53 |
indicate_drug_or_biological_or_device_or_medical_supply_1: Each product listed in relation to the payment or other transfer of value, indicates if the product is a drug, device, biological, or medical supply. |
| 54 |
indicate_drug_or_biological_or_device_or_medical_supply_2: For each product listed in relation to the payment or other transfer of value, indicates if the product is a drug, device, biological, or medical supply. |
| 55 |
indicate_drug_or_biological_or_device_or_medical_supply_3: For each product listed in relation to the payment or other transfer of value, indicates if the product is a drug, device, biological, or medical supply. |
| 56 |
indicate_drug_or_biological_or_device_or_medical_supply_4: For each product listed in relation to the payment or other transfer of value, indicates if the product is a drug, device, biological, or medical supply. |
| 57 |
indicate_drug_or_biological_or_device_or_medical_supply_5: For each product listed in relation to the payment or other transfer of value, indicates if the product is a drug, device, biological, or medical supply. |
| 58 |
name_of_drug_or_biological_or_device_or_medical_supply_1: The marketed name of the drug, device, biological, or medical supply. May report the marketed name of up to five products (drugs, devices, biologicals, or medical supplies) associated with the payment or other transfer of value. |
| 59 |
name_of_drug_or_biological_or_device_or_medical_supply_2: The marketed name of the drug, device, biological, or medical supply. May report the marketed name of up to five products (drugs, devices, biologicals, or medical supplies) associated with the payment or other transfer of value. |
| 60 |
name_of_drug_or_biological_or_device_or_medical_supply_3: The marketed name of the drug, device, biological, or medical supply. May report the marketed name of up to five products (drugs, devices, biologicals, or medical supplies) associated with the payment or other transfer of value. |
| 61 |
name_of_drug_or_biological_or_device_or_medical_supply_4: The marketed name of the drug, device, biological, or medical supply. May report the marketed name of up to five products (drugs, devices, biologicals, or medical supplies) associated with the payment or other transfer of value. |
| 62 |
name_of_drug_or_biological_or_device_or_medical_supply_5: The marketed name of the drug, device, biological, or medical supply. May report the marketed name of up to five products (drugs, devices, biologicals, or medical supplies) associated with the payment or other transfer of value. |
| 63 |
name_of_third_party_entity_receiving_payment_or_transfer_of_ccfc: The name of the entity that received the payment or other transfer of value. |
| 64 |
nature_of_payment_or_transfer_of_value: The nature of payment used to pay the covered recipient or to make the transfer of value. |
| 65 |
number_of_payments_included_in_total_amount: The number of discrete payments being reported in the Total Amount of Payment. |
| 66 |
payment_publication_date: The predefined date when the payment or other transfer of value is scheduled to be published |
| 67 |
physician_ownership_indicator: Indicates whether the physician holds an ownership or investment interest in the applicable manufacturer; this indicator is limited to physicians ownership, not the physicians family members ownership |
| 68 |
product_category_or_therapeutic_area_1: Provide the product category or therapeutic area for the covered drug, device, biological, or medical supply listed in relation to the payment or other transfer of value. |
| 69 |
product_category_or_therapeutic_area_2: Provide the product category or therapeutic area for the covered drug, device, biological, or medical supply listed in relation to the payment or other transfer of value. |
| 70 |
product_category_or_therapeutic_area_3: Provide the product category or therapeutic area for the covered drug, device, biological, or medical supply listed in relation to the payment or other transfer of value. |
| 71 |
product_category_or_therapeutic_area_4: Provide the product category or therapeutic area for the covered drug, device, biological, or medical supply listed in relation to the payment or other transfer of value. |
| 72 |
product_category_or_therapeutic_area_5: Provide the product category or therapeutic area for the covered drug, device, biological, or medical supply listed in relation to the payment or other transfer of value. |
| 73 |
program_year: The year in which the payment occurred, as reported by submitting entity. |
| 74 |
recipient_city: The primary practice/business city of the physician or teaching hospital (covered recipient) receiving the payment or other transfer of value. |
| 75 |
recipient_country: The primary practice/business address country name of the physician or teaching hospital (covered recipient) receiving the payment or transfer of value. |
| 76 |
recipient_postal_code: The international postal code for the primary practice/business location of the physician (covered recipient) receiving the payment or other transfer of value, if the primary practice/business address is outside the United States |
| 77 |
recipient_primary_business_street_address_line1: The first line of the primary practice/business street address of the physician or teaching hospital (covered recipient) receiving the payment or other transfer of value. |
| 78 |
recipient_primary_business_street_address_line2: The second line of the primary practice/business street address of the physician or teaching hospital (covered recipient) receiving the payment or other transfer of value. |
| 79 |
recipient_province: The primary practice/business province name of the physician (covered recipient) receiving the payment or other transfer of value, if the primary practice/business address is outside the United States, and if applicable. |
| 80 |
recipient_state: The primary practice/business state or territory abbreviation of the physician or teaching hospital (covered recipient) receiving the payment or transfer of value, if the primary practice/business address is in United States. |
| 81 |
recipient_zip_code: The 9-digit zip code for the primary practice/business location of the physician or teaching hospital (covered recipient) receiving the payment or transfer of value. |
| 82 |
record_id: System-assigned identifier to the general transaction at the time of submission |
| 83 |
related_product_indicator: The indicator allows the applicable manufacturer or applicable GPO to select whether the payment or other transfer of value is related to one or more product(s) (drugs, devices, biologicals, or medical supplies). If the payment was not made in relation to a product, select No. If the payment was related to one or more products, select Yes. |
| 84 |
state_of_travel: For Travel and Lodging payments, the destination state where the covered recipient traveled. |
| 85 |
submitting_applicable_manufacturer_or_applicable_gpo_name: The textual proper name of the submitting applicable manufacturer or submitting applicable GPO. |
| 86 |
teaching_hospital_ccn: A unique identifying number (CMS Certification Number) of the Teaching Hospital receiving the payment or other transfer of value. |
| 87 |
teaching_hospital_id: The system generated a unique identifier of the Teaching Hospital receiving the payment or other transfer of value. |
| 88 |
teaching_hospital_name: The name of the Teaching Hospital receiving the payment or other transfer of value. The name displayed is as listed in CMS teaching hospital list under Hospital name. |
| 89 |
third_party_equals_covered_recipient_indicator: An indicator showing the Third Party that received the payment or other transfer of value is a Covered Recipient. |
| 90 |
third_party_payment_recipient_indicator: Indicates if a payment or transfer of value was paid to a third party entity or individual at the request of or on behalf of a covered recipient (physician or teaching hospital). |
| 91 |
total_amount_of_payment_usdollars: U.S. dollar amount of payment or other transfer of value to the recipient (manufacturer must convert to dollar currency if necessary) |
| Ownership Payment Data | |
| 1 |
applicable_manufacturer_or_applicable_gpo_making_payment_country: Country name of the submitting applicable manufacturer or applicable GPO |
| 2 |
applicable_manufacturer_or_applicable_gpo_making_payment_id: Open Payments ID of either the submitting applicable manufacturer or applicable GPO |
| 3 |
applicable_manufacturer_or_applicable_gpo_making_payment_name: The textual proper name of either the submitting applicable manufacturer or applicable GPO |
| 4 |
applicable_manufacturer_or_applicable_gpo_making_payment_state: State name of either the submitting applicable manufacturer or applicable GPO |
| 5 |
change_type: An indicator showing if the payment record is New, Added, Changed, or Unchanged in the current publication compared to the previous publication. NEW - To identify new records added from the end of the previous submission deadline until the current submission period deadline date ADDED - To identify records that were not eligible at the time of previous publication, which is eligible for current publication. CHANGED - To identify previously published records modified after the last publication. UNCHANGED - To identify previously published records that remain unchanged in current publication. |
| 6 |
dispute_status_for_publication: Indicates whether the ownership or investment interest is disputed by the physician |
| 7 |
interest_held_by_physician_or_an_immediate_family_member: An indicator showing if the ownership or investment interest is held by the physician or by an immediate family member |
| 8 |
payment_publication_date: The predefined date when the ownership or investment interest is scheduled to be published |
| 9 |
physician_first_name: First name of the physician (covered recipient) with the ownership or investment interest being reported |
| 10 |
physician_last_name: Last name of the physician (covered recipient) with the ownership or investment interest being reported |
| 11 |
physician_middle_name: Middle name of the physician (covered recipient) with the ownership or investment interest being reported |
| 12 |
physician_name_suffix: Name suffix of the physician (covered recipient) with the ownership or investment interest being reported |
| 13 |
physician_npi: National Provider Identifier is a unique identification number for covered recipient physician (and not the NPI of a group the physician belongs to). |
| 14 |
physician_primary_type: The primary type of medicine practiced by the physician covered recipient with the ownership or investment interest being reported |
| 15 |
physician_profile_id: Open Payments system-generated unique identifier for physician profile with the ownership or investment interest being reported |
| 16 |
physician_specialty: Physicians single-specialty chosen from the standardized provider taxonomy code list |
| 17 |
program_year: The year in which the ownership/investment interest occurred |
| 18 |
recipient_city: The primary practice city of the physician with the ownership or investment interest being reported |
| 19 |
recipient_country: The primary practice/business address country name of the physician with the ownership or investment interest being reported |
| 20 |
recipient_postal_code: The international postal code for the primary practice/business location of the physician with the ownership or investment interest being reported, if the primary practice/business address is outside the United States |
| 21 |
recipient_primary_business_street_address_line1: The first line of the primary practice street address of the physician with the ownership or investment interest being reported |
| 22 |
recipient_primary_business_street_address_line2: The second line of the primary practice street address of the physician with the ownership or investment interest being reported |
| 23 |
recipient_province: The primary practice/business province name of the physician with the ownership or investment interest being reported, if the primary practice/business address is outside the United States, and if applicable |
| 24 |
recipient_state: The primary practice/business state or territory abbreviation of the physician with the ownership or investment interest being reported, if the primary practice/business address is in the United States |
| 25 |
recipient_zip_code: The 9-digit zip code for the primary practice location of the physician with the ownership or investment interest being reported, if the primary practice address is in the United States |
| 26 |
record_id: Open Payments system-generated unique identifier for the ownership payment record |
| 27 |
submitting_applicable_manufacturer_or_applicable_gpo_name: The textual proper name of either the submitting applicable manufacturer or applicable GPO |
| 28 |
terms_of_interest: Description of any applicable terms of the ownership or investment interest |
| 29 |
total_amount_invested_usdollars: The dollar amount the physician or immediate family member has invested in the applicable manufacturer or applicable GPO during the program year, in US dollars |
| 30 |
value_of_interest: The cumulative value of ownership or investment interest held by the physician or immediate family member in the applicable manufacturer or applicable GPO, in US dollars |
| Research Payment Data | |
| 1 |
applicable_manufacturer_or_applicable_gpo_making_payment_country: Country name of the Submitting Applicable Manufacturer or Submitting Applicable Group Purchasing Organization (GPO) as provided in Open Payments |
| 2 |
applicable_manufacturer_or_applicable_gpo_making_payment_id: System generated unique identifier of the Applicable Manufacturer or Applicable Group Purchasing Organization (GPO) Making payment or other transfer of value |
| 3 |
applicable_manufacturer_or_applicable_gpo_making_payment_name: Textual proper name of the applicable manufacturer or applicable GPO making the payment or other transfer of value |
| 4 |
applicable_manufacturer_or_applicable_gpo_making_payment_state: State name of the submitting applicable manufacturer or submitting applicable GPO as provided in Open Payments |
| 5 |
associated_device_or_medical_supply_pdi_1: The Primary Device Identifier, if any, of the covered device or covered medical supply associated with the payment or other transfer of values (if applicable); the record may report up to 5 codes. Note: OP Program began collecting PDI information during PY 2021. |
| 6 |
associated_device_or_medical_supply_pdi_2: The Primary Device Identifier, if any, of the covered device or covered medical supply associated with the payment or other transfer of values (if applicable); the record may report up to 5 codes. Note: OP Program began collecting PDI information during PY 2021. |
| 7 |
associated_device_or_medical_supply_pdi_3: The Primary Device Identifier, if any, of the covered device or covered medical supply associated with the payment or other transfer of values (if applicable); the record may report up to 5 codes. Note: OP Program began collecting PDI information during PY 2021. |
| 8 |
associated_device_or_medical_supply_pdi_4: The Primary Device Identifier, if any, of the covered device or covered medical supply associated with the payment or other transfer of values (if applicable); the record may report up to 5 codes. Note: OP Program began collecting PDI information during PY 2021. |
| 9 |
associated_device_or_medical_supply_pdi_5: The Primary Device Identifier, if any, of the covered device or covered medical supply associated with the payment or other transfer of values (if applicable); the record may report up to 5 codes. Note: OP Program began collecting PDI information during PY 2021. |
| 10 |
associated_drug_or_biological_ndc_1: The National Drug Code, if any, of the drug or biological associated with the payment or other transfer of value (if applicable); the record may report up to 5 codes |
| 11 |
associated_drug_or_biological_ndc_2: The National Drug Code, if any, of the drug or biological associated with the payment or other transfer of value (if applicable); the record may report up to 5 codes |
| 12 |
associated_drug_or_biological_ndc_3: The National Drug Code, if any, of the drug or biological associated with the payment or other transfer of value (if applicable); the record may report up to 5 codes |
| 13 |
associated_drug_or_biological_ndc_4: The National Drug Code, if any, of the drug or biological associated with the payment or other transfer of value (if applicable); the record may report up to 5 codes |
| 14 |
associated_drug_or_biological_ndc_5: The National Drug Code, if any, of the drug or biological associated with the payment or other transfer of value (if applicable); the record may report up to 5 codes |
| 15 |
change_type: An indicator showing if the payment record is New, Added, Changed, or Unchanged in the current publication compared to the previous publication. · NEW - To identify new records added from the end of the previous submission deadline until the current submission period deadline date · ADDED - To identify records that were not eligible at the time of previous publication, which is eligible for current publication. · CHANGED - To identify previously published records modified after the last publication. · UNCHANGED - To identify previously published records that remain unchanged in current publication. |
| 16 |
clinicaltrials_gov_identifier: Identifier assigned if research study is registered on clinicaltrials.gov |
| 17 |
context_of_research: Textual description of research context or research objectives |
| 18 |
covered_or_noncovered_indicator_1: For each product listed in relation to the payment or other transfer of value, indicates if the product is a covered or non-covered product per the covered product definition in the Open Payments final rule. |
| 19 |
covered_or_noncovered_indicator_2: For each product listed in relation to the payment or other transfer of value, indicates if the product is a covered or non-covered product per the covered product definition in the Open Payments final rule. |
| 20 |
covered_or_noncovered_indicator_3: For each product listed in relation to the payment or other transfer of value, indicates if the product is a covered or non-covered product per the covered product definition in the Open Payments final rule. |
| 21 |
covered_or_noncovered_indicator_4: For each product listed in relation to the payment or other transfer of value, indicates if the product is a covered or non-covered product per the covered product definition in the Open Payments final rule. |
| 22 |
covered_or_noncovered_indicator_5: For each product listed in relation to the payment or other transfer of value, indicates if the product is a covered or non-covered product per the covered product definition in the Open Payments final rule. |
| 23 |
covered_recipient_first_name: First name of the physician (covered recipient) or covered recipient non-physician practitioner receiving the payment or transfer of value, as reported by the submitting entity. |
| 24 |
covered_recipient_last_name: Last name of the covered recipient physician or covered recipient non-physician practitioner receiving the payment or transfer of value, as reported by the submitting entity. |
| 25 |
covered_recipient_license_state_code1: The state license number of the covered recipient physician or covered recipient non-physician practitioner, which is a 2-letter state abbreviation; the record may include up to 5 physician license states, if a physician or non-physician practitioner is licensed in multiple states. |
| 26 |
covered_recipient_license_state_code2: The state license number of the covered recipient physician or covered recipient non-physician practitioner, which is a 2-letter state abbreviation; the record may include up to 5 physician license states, if a physician or non-physician practitioner is licensed in multiple states. |
| 27 |
covered_recipient_license_state_code3: The state license number of the covered recipient physician or covered recipient non-physician practitioner, which is a 2-letter state abbreviation; the record may include up to 5 physician license states, if a physician or non-physician practitioner is licensed in multiple states. |
| 28 |
covered_recipient_license_state_code4: The state license number of the covered recipient physician or covered recipient non-physician practitioner, which is a 2-letter state abbreviation; the record may include up to 5 physician license states, if a physician or non-physician practitioner is licensed in multiple states. |
| 29 |
covered_recipient_license_state_code5: The state license number of the covered recipient physician or covered recipient non-physician practitioner, which is a 2-letter state abbreviation; the record may include up to 5 physician license states, if a physician or non-physician practitioner is licensed in multiple states. |
| 30 |
covered_recipient_middle_name: Middle name of the covered recipient physician or covered recipient non-physician practitioner receiving the payment or transfer of value, as reported by the submitting entity. |
| 31 |
covered_recipient_name_suffix: Name suffix of the covered recipient physician or covered recipient non-physician practitioner receiving the payment or transfer of value, as reported by the submitting entity. |
| 32 |
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). |
| 33 |
covered_recipient_primary_type_1: Primary type of medicine practiced by the physician or Non-Physician Practitioner (covered recipient). |
| 34 |
covered_recipient_primary_type_2: Primary type of medicine practiced by the physician or Non-Physician Practitioner (covered recipient). Note: OP began accepting this field in PY2021. |
| 35 |
covered_recipient_primary_type_3: Primary type of medicine practiced by the physician or Non-Physician Practitioner (covered recipient). Note: OP began accepting this field in PY2021. |
| 36 |
covered_recipient_primary_type_4: Primary type of medicine practiced by the physician or Non-Physician Practitioner (covered recipient). Note: OP began accepting this field in PY2021. |
| 37 |
covered_recipient_primary_type_5: Primary type of medicine practiced by the physician or Non-Physician Practitioner (covered recipient). Note: OP began accepting this field in PY2021. |
| 38 |
covered_recipient_primary_type_6: Primary type of medicine practiced by the physician or Non-Physician Practitioner (covered recipient). |
| 39 |
covered_recipient_profile_id: System generated unique identifier for covered recipient physician profile or covered recipient non-physician practitioner profile receiving the payment or other transfer of value. |
| 40 |
covered_recipient_specialty_1: Physicians or non-physician practitioners specialty chosen from the standardized provider taxonomy code list. |
| 41 |
covered_recipient_specialty_2: Physicians or non-physician practitioners specialty chosen from the standardized provider taxonomy code list. Note: OP began accepting this field in PY2021. |
| 42 |
covered_recipient_specialty_3: Physicians or non-physician practitioners specialty chosen from the standardized provider taxonomy code list. Note: OP began accepting this field in PY2021. |
| 43 |
covered_recipient_specialty_4: Physicians or non-physician practitioners specialty chosen from the standardized provider taxonomy code list. Note: OP began accepting this field in PY2021. |
| 44 |
covered_recipient_specialty_5: Physicians or non-physician practitioners specialty chosen from the standardized provider taxonomy code list. Note: OP began accepting this field in PY2021. |
| 45 |
covered_recipient_specialty_6: Physicians or non-physician practitioners specialty chosen from the standardized provider taxonomy code list. Note: OP began accepting this field in PY2021. |
| 46 |
covered_recipient_type: An indicator showing if the recipient of the payment or other transfer of value is a physician covered recipient, or non-physician practitioner, teaching hospital covered recipient, non-covered recipient entity, or non-covered recipient individual |
| 47 |
date_of_payment: If a singular payment, then this is the actual date the payment was issued; if a series of payments or an aggregated set of payments, this is the date of the first payment to the covered recipient in this program year |
| 48 |
delay_in_publication_indicator: An indicator showing if an applicable manufacturer or applicable GPO is requesting a delay in publication of a payment or other transfer of value when the payment or other transfer of value is made in connection with: (1) research on or development of a new product (drug, device, biological, or medical supply) or (2) clinical investigation regarding a new product (drug, device, biological, or medical supply) |
| 49 |
dispute_status_for_publication: Indicates whether the payment or other transfer of value is disputed by the covered recipient or not |
| 50 |
expenditure_category1: Contextual category for this research payment or other transfer of value |
| 51 |
expenditure_category2: Contextual category for this research payment or other transfer of value |
| 52 |
expenditure_category3: Contextual category for this research payment or other transfer of value |
| 53 |
expenditure_category4: Contextual category for this research payment or other transfer of value |
| 54 |
expenditure_category5: Contextual category for this research payment or other transfer of value |
| 55 |
expenditure_category6: Contextual category for this research payment or other transfer of value |
| 56 |
form_of_payment_or_transfer_of_value: The method of payment used to pay the covered recipient or to make the transfer of value. |
| 57 |
indicate_drug_or_biological_or_device_or_medical_supply_1: For each product listed in relation to the payment or other transfer of value, indicates if the product is a drug, device, biological, or medical supply. |
| 58 |
indicate_drug_or_biological_or_device_or_medical_supply_2: For each product listed in relation to the payment or other transfer of value, indicates if the product is a drug, device, biological, or medical supply. |
| 59 |
indicate_drug_or_biological_or_device_or_medical_supply_3: For each product listed in relation to the payment or other transfer of value, indicates if the product is a drug, device, biological, or medical supply. |
| 60 |
indicate_drug_or_biological_or_device_or_medical_supply_4: For each product listed in relation to the payment or other transfer of value, indicates if the product is a drug, device, biological, or medical supply. |
| 61 |
indicate_drug_or_biological_or_device_or_medical_supply_5: For each product listed in relation to the payment or other transfer of value, indicates if the product is a drug, device, biological, or medical supply. |
| 62 |
name_of_drug_or_biological_or_device_or_medical_supply_1: The marketed name of the drug, device, biological, or medical supply. May report the marketed name of up to five products (drugs, devices, biologicals, or medical supplies) associated with the payment or other transfer of value. |
| 63 |
name_of_drug_or_biological_or_device_or_medical_supply_2: The marketed name of the drug, device, biological, or medical supply. May report the marketed name of up to five products (drugs, devices, biologicals, or medical supplies) associated with the payment or other transfer of value. |
| 64 |
name_of_drug_or_biological_or_device_or_medical_supply_3: The marketed name of the drug, device, biological, or medical supply. May report the marketed name of up to five products (drugs, devices, biologicals, or medical supplies) associated with the payment or other transfer of value. |
| 65 |
name_of_drug_or_biological_or_device_or_medical_supply_4: The marketed name of the drug, device, biological, or medical supply. May report the marketed name of up to five products (drugs, devices, biologicals, or medical supplies) associated with the payment or other transfer of value. |
| 66 |
name_of_drug_or_biological_or_device_or_medical_supply_5: The marketed name of the drug, device, biological, or medical supply. May report the marketed name of up to five products (drugs, devices, biologicals, or medical supplies) associated with the payment or other transfer of value. |
| 67 |
name_of_study: The textual name of the study for which the covered recipient is receiving this payment or other transfer of value. The textual name of the study for which the covered recipient is receiving this payment or other transfer of value |
| 68 |
noncovered_recipient_entity_name: The name of the non-covered recipient entity receiving the payment or other transfer of value |
| 69 |
payment_publication_date: The predefined date when the payment or other transfer of value is scheduled to be published |
| 70 |
preclinical_research_indicator: An indicator showing if payment or other transfer of value is related to research, which is pre-clinical |
| 71 |
principal_investigator_1_business_street_address_line1: The first line of the primary practice/business street address of the Principal Investigator associated with the payment or other transfer of value. |
| 72 |
principal_investigator_1_business_street_address_line2: The second line of the primary practice/business street address of the Principal Investigator associated with the payment or other transfer of value. |
| 73 |
principal_investigator_1_city: The primary practice/business city of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States. |
| 74 |
principal_investigator_1_country: The primary practice/business address country name of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States |
| 75 |
principal_investigator_1_covered_recipient_type: An indicator showing if the recipient of the payment or other transfer of value is a physician covered recipient, or non-physician practitioner, teaching hospital covered recipient, non-covered recipient entity, or non-covered recipient individual |
| 76 |
principal_investigator_1_first_name: The first name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
| 77 |
principal_investigator_1_last_name: Last name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
| 78 |
principal_investigator_1_license_state_code1: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 79 |
principal_investigator_1_license_state_code2: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 80 |
principal_investigator_1_license_state_code3: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 81 |
principal_investigator_1_license_state_code4: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 82 |
principal_investigator_1_license_state_code5: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 83 |
principal_investigator_1_middle_name: The middle name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
| 84 |
principal_investigator_1_name_suffix: Name suffix of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
| 85 |
principal_investigator_1_npi: National Provider Identifier is a unique identification number for principal investigator, if available. |
| 86 |
principal_investigator_1_postal_code: The international postal code for the primary practice/business location of the principal investigator associated with the payment or other transfer of value, if the primary practice/business address is outside the United States |
| 87 |
principal_investigator_1_primary_type_1: Primary type name of medicine practiced by the principal investigator |
| 88 |
principal_investigator_1_primary_type_2: Primary type name of medicine practiced by the principal investigator |
| 89 |
principal_investigator_1_primary_type_3: Primary type name of medicine practiced by the principal investigator |
| 90 |
principal_investigator_1_primary_type_4: Primary type name of medicine practiced by the principal investigator |
| 91 |
principal_investigator_1_primary_type_5: Primary type name of medicine practiced by the principal investigator |
| 92 |
principal_investigator_1_primary_type_6: Primary type name of medicine practiced by the principal investigator |
| 93 |
principal_investigator_1_profile_id: An identifier for Principal Investigator profile after validation |
| 94 |
principal_investigator_1_province: The primary practice/business province name of the Principal Investigator associated with the payment or other transfer of value, if the primary practice/business address is outside the United States, and if applicable. |
| 95 |
principal_investigator_1_specialty_1: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 96 |
principal_investigator_1_specialty_2: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 97 |
principal_investigator_1_specialty_3: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 98 |
principal_investigator_1_specialty_4: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 99 |
principal_investigator_1_specialty_5: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 100 |
principal_investigator_1_specialty_6: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 101 |
principal_investigator_1_state: The primary practice/business state or territory abbreviation of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States. |
| 102 |
principal_investigator_1_zip_code: The 9-digit zip code for the primary business location of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States |
| 103 |
principal_investigator_2_business_street_address_line1: The first line of the primary practice/business street address of the Principal Investigator associated with the payment or other transfer of value. |
| 104 |
principal_investigator_2_business_street_address_line2: The second line of the primary practice/business street address of the Principal Investigator associated with the payment or other transfer of value. |
| 105 |
principal_investigator_2_city: The primary practice/business city of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States. |
| 106 |
principal_investigator_2_country: The primary practice/business address country name of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States |
| 107 |
principal_investigator_2_covered_recipient_type: An indicator showing if the recipient of the payment or other transfer of value is a physician covered recipient, or non-physician practitioner, teaching hospital covered recipient, non-covered recipient entity, or non-covered recipient individual |
| 108 |
principal_investigator_2_first_name: The first name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
| 109 |
principal_investigator_2_last_name: The last name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
| 110 |
principal_investigator_2_license_state_code1: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 111 |
principal_investigator_2_license_state_code2: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 112 |
principal_investigator_2_license_state_code3: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 113 |
principal_investigator_2_license_state_code4: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 114 |
principal_investigator_2_license_state_code5: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 115 |
principal_investigator_2_middle_name: The middle name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
| 116 |
principal_investigator_2_name_suffix: Name suffix of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
| 117 |
principal_investigator_2_npi: National Provider Identifier is a unique identification number for principal investigator, if available. |
| 118 |
principal_investigator_2_postal_code: The international postal code for the primary practice/business location of the principal Investigator associated with the payment or other transfer of value if the primary practice/business address is outside the United States |
| 119 |
principal_investigator_2_primary_type_1: Primary type name of medicine practiced by the principal investigator |
| 120 |
principal_investigator_2_primary_type_2: Primary type name of medicine practiced by the principal investigator |
| 121 |
principal_investigator_2_primary_type_3: Primary type name of medicine practiced by the principal investigator |
| 122 |
principal_investigator_2_primary_type_4: Primary type name of medicine practiced by the principal investigator |
| 123 |
principal_investigator_2_primary_type_5: Primary type name of medicine practiced by the principal investigator |
| 124 |
principal_investigator_2_primary_type_6: Primary type name of medicine practiced by the principal investigator |
| 125 |
principal_investigator_2_profile_id: An identifier for Principal Investigator profile after validation |
| 126 |
principal_investigator_2_province: The primary practice/business province name of the Principal Investigator associated with the payment or other transfer of value, if the primary practice/business address is outside the United States, and if applicable. |
| 127 |
principal_investigator_2_specialty_1: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 128 |
principal_investigator_2_specialty_2: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 129 |
principal_investigator_2_specialty_3: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 130 |
principal_investigator_2_specialty_4: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 131 |
principal_investigator_2_specialty_5: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 132 |
principal_investigator_2_specialty_6: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 133 |
principal_investigator_2_state: The primary practice/business state or territory abbreviation of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States. |
| 134 |
principal_investigator_2_zip_code: The 9-digit zip code for the primary business location of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States |
| 135 |
principal_investigator_3_business_street_address_line1: The first line of the primary practice/business street address of the Principal Investigator associated with the payment or other transfer of value. |
| 136 |
principal_investigator_3_business_street_address_line2: The second line of the primary practice/business street address of the Principal Investigator associated with the payment or other transfer of value. |
| 137 |
principal_investigator_3_city: The primary practice/business city of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States. |
| 138 |
principal_investigator_3_country: The primary practice/business address country name of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States |
| 139 |
principal_investigator_3_covered_recipient_type: An indicator showing if the recipient of the payment or other transfer of value is a physician covered recipient, or non-physician practitioner, teaching hospital covered recipient, non-covered recipient entity, or non-covered recipient individual |
| 140 |
principal_investigator_3_first_name: The first name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
| 141 |
principal_investigator_3_last_name: The last name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
| 142 |
principal_investigator_3_license_state_code1: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 143 |
principal_investigator_3_license_state_code2: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 144 |
principal_investigator_3_license_state_code3: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 145 |
principal_investigator_3_license_state_code4: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 146 |
principal_investigator_3_license_state_code5: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 147 |
principal_investigator_3_middle_name: The middle name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
| 148 |
principal_investigator_3_name_suffix: Name suffix of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
| 149 |
principal_investigator_3_npi: National Provider Identifier is a unique identification number for principal investigator, if available. |
| 150 |
principal_investigator_3_postal_code: The international postal code for the primary practice/business location of the principal Investigator associated with the payment or other transfer of value, if the primary practice/business address is outside the United States |
| 151 |
principal_investigator_3_primary_type_1: Primary type name of medicine practiced by the principal investigator |
| 152 |
principal_investigator_3_primary_type_2: Primary type name of medicine practiced by the principal investigator |
| 153 |
principal_investigator_3_primary_type_3: Primary type name of medicine practiced by the principal investigator |
| 154 |
principal_investigator_3_primary_type_4: Primary type name of medicine practiced by the principal investigator |
| 155 |
principal_investigator_3_primary_type_5: Primary type name of medicine practiced by the principal investigator |
| 156 |
principal_investigator_3_primary_type_6: Primary type name of medicine practiced by the principal investigator |
| 157 |
principal_investigator_3_profile_id: An identifier for Principal Investigator profile after validation |
| 158 |
principal_investigator_3_province: The primary practice/business province name of the Principal Investigator associated with the payment or other transfer of value, if the primary practice/business address is outside the United States, and if applicable. |
| 159 |
principal_investigator_3_specialty_1: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 160 |
principal_investigator_3_specialty_2: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 161 |
principal_investigator_3_specialty_3: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 162 |
principal_investigator_3_specialty_4: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 163 |
principal_investigator_3_specialty_5: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 164 |
principal_investigator_3_specialty_6: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 165 |
principal_investigator_3_state: The primary practice/business state or territory abbreviation of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States. |
| 166 |
principal_investigator_3_zip_code: The 9-digit zip code for the primary business location of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States |
| 167 |
principal_investigator_4_business_street_address_line1: The first line of the primary practice/business street address of the Principal Investigator associated with the payment or other transfer of value. |
| 168 |
principal_investigator_4_business_street_address_line2: The second line of the primary practice/business street address of the Principal Investigator associated with the payment or other transfer of value. |
| 169 |
principal_investigator_4_city: The primary practice/business city of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States. |
| 170 |
principal_investigator_4_country: The primary practice/business address country name of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States |
| 171 |
principal_investigator_4_covered_recipient_type: An indicator showing if the recipient of the payment or other transfer of value is a physician covered recipient, or non-physician practitioner, teaching hospital covered recipient, non-covered recipient entity, or non-covered recipient individual |
| 172 |
principal_investigator_4_first_name: The first name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
| 173 |
principal_investigator_4_last_name: The last name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
| 174 |
principal_investigator_4_license_state_code1: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 175 |
principal_investigator_4_license_state_code2: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 176 |
principal_investigator_4_license_state_code3: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 177 |
principal_investigator_4_license_state_code4: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 178 |
principal_investigator_4_license_state_code5: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 179 |
principal_investigator_4_middle_name: The middle name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
| 180 |
principal_investigator_4_name_suffix: Name suffix of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
| 181 |
principal_investigator_4_npi: National Provider Identifier is a unique identification number for principal investigator, if available. |
| 182 |
principal_investigator_4_postal_code: The international postal code for the primary practice/business location of the principal Investigator associated with the payment or other transfer of value, if the primary practice/business address is outside the United States |
| 183 |
principal_investigator_4_primary_type_1: Primary type name of medicine practiced by the principal investigator |
| 184 |
principal_investigator_4_primary_type_2: Primary type name of medicine practiced by the principal investigator |
| 185 |
principal_investigator_4_primary_type_3: Primary type name of medicine practiced by the principal investigator |
| 186 |
principal_investigator_4_primary_type_4: Primary type name of medicine practiced by the principal investigator |
| 187 |
principal_investigator_4_primary_type_5: Primary type name of medicine practiced by the principal investigator |
| 188 |
principal_investigator_4_primary_type_6: Primary type name of medicine practiced by the principal investigator |
| 189 |
principal_investigator_4_profile_id: An identifier for Principal Investigator profile after validation |
| 190 |
principal_investigator_4_province: The primary practice/business province name of the Principal Investigator associated with the payment or other transfer of value, if the primary practice/business address is outside the United States, and if applicable. |
| 191 |
principal_investigator_4_specialty_1: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 192 |
principal_investigator_4_specialty_2: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 193 |
principal_investigator_4_specialty_3: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 194 |
principal_investigator_4_specialty_4: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 195 |
principal_investigator_4_specialty_5: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 196 |
principal_investigator_4_specialty_6: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 197 |
principal_investigator_4_state: The primary practice/business state or territory abbreviation of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States. |
| 198 |
principal_investigator_4_zip_code: The 9-digit zip code for the primary business location of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States |
| 199 |
principal_investigator_5_business_street_address_line1: The first line of the primary practice/business street address of the Principal Investigator associated with the payment or other transfer of value. |
| 200 |
principal_investigator_5_business_street_address_line2: The second line of the primary practice/business street address of the Principal Investigator associated with the payment or other transfer of value. |
| 201 |
principal_investigator_5_city: The primary practice/business city of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States. |
| 202 |
principal_investigator_5_country: The primary practice/business address country name of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States |
| 203 |
principal_investigator_5_covered_recipient_type: An indicator showing if the recipient of the payment or other transfer of value is a physician covered recipient, or non-physician practitioner, teaching hospital covered recipient, non-covered recipient entity, or non-covered recipient individual |
| 204 |
principal_investigator_5_first_name: The first name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
| 205 |
principal_investigator_5_last_name: Last name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
| 206 |
principal_investigator_5_license_state_code1: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 207 |
principal_investigator_5_license_state_code2: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 208 |
principal_investigator_5_license_state_code3: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 209 |
principal_investigator_5_license_state_code4: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 210 |
principal_investigator_5_license_state_code5: The state license number of the principal investigator, which is a 2-letter state abbreviation; the record may include up to 5 physician license states if a physician is licensed in multiple states. |
| 211 |
principal_investigator_5_middle_name: Middle name of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
| 212 |
principal_investigator_5_name_suffix: Name suffix of the Principal Investigator associated with the payment or transfer of value, as reported by the submitting entity. |
| 213 |
principal_investigator_5_npi: National Provider Identifier is a unique identification number for principal investigator, if available. |
| 214 |
principal_investigator_5_postal_code: The international postal code for the primary practice/business location of the principal Investigator associated with the payment or other transfer of value, if the primary practice/business address is outside the United States |
| 215 |
principal_investigator_5_primary_type_1: Primary type name of medicine practiced by the principal investigator |
| 216 |
principal_investigator_5_primary_type_2: Primary type name of medicine practiced by the principal investigator |
| 217 |
principal_investigator_5_primary_type_3: Primary type name of medicine practiced by the principal investigator |
| 218 |
principal_investigator_5_primary_type_4: Primary type name of medicine practiced by the principal investigator |
| 219 |
principal_investigator_5_primary_type_5: Primary type name of medicine practiced by the principal investigator |
| 220 |
principal_investigator_5_primary_type_6: Primary type name of medicine practiced by the principal investigator |
| 221 |
principal_investigator_5_profile_id: An identifier for Principal Investigator profile after validation |
| 222 |
principal_investigator_5_province: The primary practice/business province name of the Principal Investigator associated with the payment or other transfer of value, if the primary practice/business address is outside the United States, and if applicable. |
| 223 |
principal_investigator_5_specialty_1: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 224 |
principal_investigator_5_specialty_2: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 225 |
principal_investigator_5_specialty_3: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 226 |
principal_investigator_5_specialty_4: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 227 |
principal_investigator_5_specialty_5: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 228 |
principal_investigator_5_specialty_6: Principal Investigators single-specialty chosen from the standardized provider taxonomy code list. |
| 229 |
principal_investigator_5_state: The primary practice/business state or territory abbreviation of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States. |
| 230 |
principal_investigator_5_zip_code: The 9-digit zip code for the primary business location of the Principal Investigator associated with the payment or other transfer of value if the primary practice address is in the United States |
| 231 |
product_category_or_therapeutic_area_1: Provide the product category or therapeutic area for the covered drug, device, biological, or medical supply listed in relation to the payment or other transfer of value. |
| 232 |
product_category_or_therapeutic_area_2: Provide the product category or therapeutic area for the covered drug, device, biological, or medical supply listed in relation to the payment or other transfer of value. |
| 233 |
product_category_or_therapeutic_area_3: Provide the product category or therapeutic area for the covered drug, device, biological, or medical supply listed in relation to the payment or other transfer of value. |
| 234 |
product_category_or_therapeutic_area_4: Provide the product category or therapeutic area for the covered drug, device, biological, or medical supply listed in relation to the payment or other transfer of value. |
| 235 |
product_category_or_therapeutic_area_5: Provide the product category or therapeutic area for the covered drug, device, biological, or medical supply listed in relation to the payment or other transfer of value. |
| 236 |
program_year: The year in which the payment occurred, as reported by submitting entity. |
| 237 |
recipient_city: The primary practice/business address city of the physician or teaching hospital or non-covered recipient entity receiving the payment or other transfer of value |
| 238 |
recipient_country: The primary practice/business address country of the physician or teaching hospital or non-covered recipient entity receiving the payment or other transfer of value if the primary practice address is in the United States |
| 239 |
recipient_postal_code: The international postal code for the primary business location of the physician or teaching hospital or non- covered recipient entity receiving the payment or other transfer of value if the primary business address is outside the United States |
| 240 |
recipient_primary_business_street_address_line1: The first line of the primary business street address of the physician or non-physician practitioner or teaching hospital or non-covered recipient entity receiving the payment or other transfer of value |
| 241 |
recipient_primary_business_street_address_line2: The second line of the primary business street address of the physician or teaching hospital or non-covered recipient entity receiving the payment or other transfer of value |
| 242 |
recipient_province: The primary practice/business province name of the physician or teaching hospital or non-covered recipient entity receiving the payment or other transfer of value, if the primary practice/business address is outside the United States, and if applicable. |
| 243 |
recipient_state: The state or territory abbreviation of the primary business address of the physician or teaching hospital or non-covered recipient entity receiving the payment or other transfer of value if the primary business address is in the United States. |
| 244 |
recipient_zip_code: The 9-digit zip code for the primary business location of the physician or teaching hospital or non-covered recipient entity receiving the payment or other transfer of value if the primary practice address is in the United States |
| 245 |
record_id: System assigned identifier to the research transaction at the time of submission |
| 246 |
related_product_indicator: Indicator allows the applicable manufacturer or applicable GPO to select whether the payment or other transfer of value is related to one or more product(s) (drugs, devices, biologicals, or medical supplies). If the payment was not made in relation to a product, select No. If the payment was related to one or more product, select Yes. |
| 247 |
research_information_link: Optional link to information relevant to the research study for which this payment or other transfer of value is being reported (there can be a maximum of five links reported) |
| 248 |
submitting_applicable_manufacturer_or_applicable_gpo_name: Textual proper name of either the Submitting Applicable Manufacturer or Submitting Applicable Group Purchasing Organization (GPO). |
| 249 |
teaching_hospital_ccn: A unique identifying number (CMS Certification Number) of the Teaching Hospital receiving the payment or other transfer of value. |
| 250 |
teaching_hospital_id: System generated unique identifier of the Teaching Hospital receiving the payment or other transfer of value. |
| 251 |
teaching_hospital_name: The name of the Teaching Hospital receiving the payment or other transfer of value. The name displayed is as listed in CMS teaching hospital list under Hospital name. |
| 252 |
total_amount_of_payment_usdollars: U.S. dollar amount of payment or transfer of value to recipient (manufacturer must convert to dollar currency if necessary). |
Profiles
• Rows [1.5M] • Pages [3.1k] • Fields [32]
open_quick("profile_covered") |>
providertwo:::map_na_if() |>
slt(-associated_covered_recipient_profile_id_2,
-covered_recipient_profile_province_name) |>
fuimus::describe2() |>
slt(column, type, n, uniq, top) |>
gt_tab()| column | type | n | uniq | top |
|---|---|---|---|---|
| covered_recipient_profile_type | <chr> | 13517 | 2 | Covered Recipient Physician, Covered Recipient Non-Physician Practitioner |
| covered_recipient_profile_id | <chr> | 1401 | - | - |
| associated_covered_recipient_profile_id_1 | <chr> | 14 | 2 | 4217397, 8789778 |
| covered_recipient_npi | <chr> | 5000 | - | - |
| covered_recipient_profile_first_name | <chr> | 3011 | 328 | JOSEPH, JOHN, DAVID, RICHARD, MICHAEL, ROBERT, THOMAS, KENNETH, PAUL, RANDALL |
| covered_recipient_profile_middle_name | <chr> | 722 | 87 | M, A, S, J, C, D, E, W, L, K |
| covered_recipient_profile_last_name | <chr> | 3253 | 473 | PATEL, KIM, SCHUSTER, LEWIS, AHMED, NGUYEN, SHAH, HO, TOWNSEND, WILLIAMS |
| covered_recipient_profile_suffix | <chr> | 35 | 3 | JR., III, II |
| covered_recipient_profile_alternate_first_name | <chr> | 1471 | 184 | DAVID, JOHN, JOSEPH, RICHARD, MICHAEL, KENNETH, THOMAS, CHARLES, MATTHEW, KEVIN |
| covered_recipient_profile_alternate_middle_name | <chr> | 844 | 122 | A, J, R, E, JOHN, M, S, DAVID, D, C |
| covered_recipient_profile_alternate_last_name | <chr> | 1665 | 242 | KIM, WHITE, SIMMONS, GROBER, RACKLEY, DAVOL, MUMMADI, WIRTH-RISSMAN, POST, GIRARDI |
| covered_recipient_profile_alternate_suffix | <chr> | 31 | 3 | JR., III, I |
| covered_recipient_profile_address_line_1 | <chr> | 9180 | 495 | 1133 MEDICAL DR, 6700 W 9TH AVE, 9500 EUCLID AVE, 200 1ST ST SW, 10800 MAGNOLIA AVE, 847 SOUTH MILLEDGE AVE, 15 HEIDI LN, 1001 SAM PERRY BLVD, 100 MARKET ST STE 300, 1698 E MCANDREWS RD STE 280 |
| covered_recipient_profile_address_line_2 | <chr> | 2318 | 177 | SUITE 200, STE 100, SUITE 300, SUITE 400, SUITE 201, SUITE 203, STE 101, SUITE 205, SUITE A, SUITE 100 |
| covered_recipient_profile_city | <chr> | 4570 | 369 | NEW YORK, HOUSTON, BROOKLYN, LOS ANGELES, LOUISVILLE, MIAMI, PHOENIX, PHILADELPHIA, PEORIA, ALLENTOWN |
| covered_recipient_profile_state | <chr> | 1000 | 46 | CA, NY, FL, TX, PA, MI, NC, IL, NJ, AZ |
| covered_recipient_profile_zipcode | <chr> | 4715 | 495 | 75701-2130, 79106-1729, 44195-0001, 55905-0001, 92505-3043, 30605-1331, 11766-1428, 22401-4453, 19426-4927, 97504-5590 |
| covered_recipient_profile_country_name | <chr> | 6500 | 1 | UNITED STATES |
| covered_recipient_profile_primary_specialty | <chr> | 28209 | 85 | Allopathic & Osteopathic Physicians|Family Medicine, Allopathic & Osteopathic Physicians|Internal Medicine, Allopathic & Osteopathic Physicians|Psychiatry & Neurology|Psychiatry, Allopathic & Osteopathic Physicians|Pediatrics, Allopathic & Osteopathic Physicians|Ophthalmology, Dental Providers|Dentist|General Practice, Eye and Vision Services Providers|Optometrist, Allopathic & Osteopathic Physicians|Obstetrics & Gynecology, Allopathic & Osteopathic Physicians|Internal Medicine|Gastroenterology, Allopathic & Osteopathic Physicians|Psychiatry & Neurology|Neurology |
| covered_recipient_profile_ops_taxonomy_1 | <chr> | 5000 | 78 | 207R00000X, 207Q00000X, 208000000X, 2084P0800X, 207W00000X, 1223G0001X, 152W00000X, 207V00000X, 208600000X, 207RG0100X |
| covered_recipient_profile_ops_taxonomy_2 | <chr> | 980 | 61 | 208M00000X, 207R00000X, 207RP1001X, 207RC0000X, 207Q00000X, 207RC0200X, 207XX0005X, 207RI0011X, 2084N0400X, 2086S0129X |
| covered_recipient_profile_ops_taxonomy_3 | <chr> | 230 | 17 | 207RP1001X, 2084P0804X, 208M00000X, 207XX0801X, 208D00000X, 2081P0301X, 207R00000X, 2084P2900X, 2085R0204X, 207LP2900X |
| covered_recipient_profile_ops_taxonomy_4 | <chr> | 60 | 6 | 2081P2900X, 207RS0012X, 208C00000X, 208M00000X, 2084P2900X, 2084S0012X |
| covered_recipient_profile_ops_taxonomy_5 | <chr> | 30 | 2 | 208VP0014X, 208G00000X |
| covered_recipient_profile_ops_taxonomy_6 | <chr> | 20 | 2 | 2081S0010X, 208VP0000X |
| covered_recipient_profile_license_state_code_1 | <chr> | 1000 | 44 | CA, NY, FL, TX, PA, MI, IL, NC, OH, GA |
| covered_recipient_profile_license_state_code_2 | <chr> | 446 | 47 | PA, NY, CA, FL, TX, MI, NJ, NC, VA, MN |
| covered_recipient_profile_license_state_code_3 | <chr> | 178 | 33 | VA, MI, GA, OH, TX, FL, CA, OK, PA, WI |
| covered_recipient_profile_license_state_code_4 | <chr> | 90 | 29 | MI, TX, OH, IN, FL, IA, CO, PA, VA, CA |
| covered_recipient_profile_license_state_code_5 | <chr> | 30 | 13 | FL, CA, ME, PA, NM, OR, MS, MI, MD, AR |
• Rows [1.5M] • Pages [3.1k] • Fields [33]
open_quick("profile_physician") |>
providertwo:::map_na_if() |>
slt(-covered_recipient_profile_province_name,
-covered_recipient_profile_alternate_first_name5,
-covered_recipient_profile_alternate_last_name5
) |>
fuimus::describe2() |>
slt(column, type, n, uniq, top) |>
gt_tab()| column | type | n | uniq | top |
|---|---|---|---|---|
| covered_recipient_profile_type | <chr> | 13517 | 2 | Covered Recipient Physician, Covered Recipient Non-Physician Practitioner |
| covered_recipient_profile_id | <chr> | 1401 | - | - |
| covered_recipient_npi | <chr> | 5000 | - | - |
| covered_recipient_profile_first_name | <chr> | 3011 | 328 | JOSEPH, JOHN, DAVID, RICHARD, MICHAEL, ROBERT, THOMAS, KENNETH, PAUL, RANDALL |
| covered_recipient_profile_middle_name | <chr> | 722 | 87 | M, A, S, J, C, D, E, W, L, K |
| covered_recipient_profile_last_name | <chr> | 3253 | 473 | PATEL, KIM, SCHUSTER, LEWIS, AHMED, NGUYEN, SHAH, HO, TOWNSEND, WILLIAMS |
| covered_recipient_profile_suffix | <chr> | 35 | 3 | JR., III, II |
| covered_recipient_profile_alternate_first_name1 | <chr> | 1471 | 184 | DAVID, JOHN, JOSEPH, RICHARD, MICHAEL, KENNETH, THOMAS, CHARLES, MATTHEW, KEVIN |
| covered_recipient_profile_alternate_middle_name1 | <chr> | 844 | 122 | A, J, R, E, JOHN, M, S, DAVID, D, C |
| covered_recipient_profile_alternate_last_name1 | <chr> | 1665 | 242 | KIM, WHITE, SIMMONS, GROBER, RACKLEY, DAVOL, MUMMADI, WIRTH-RISSMAN, POST, GIRARDI |
| covered_recipient_profile_alternate_suffix1 | <chr> | 31 | 3 | JR., III, I |
| covered_recipient_profile_address_line_1 | <chr> | 9180 | 495 | 1133 MEDICAL DR, 6700 W 9TH AVE, 9500 EUCLID AVE, 200 1ST ST SW, 10800 MAGNOLIA AVE, 847 SOUTH MILLEDGE AVE, 15 HEIDI LN, 1001 SAM PERRY BLVD, 100 MARKET ST STE 300, 1698 E MCANDREWS RD STE 280 |
| covered_recipient_profile_address_line_2 | <chr> | 2318 | 177 | SUITE 200, STE 100, SUITE 300, SUITE 400, SUITE 201, SUITE 203, STE 101, SUITE 205, SUITE A, SUITE 100 |
| covered_recipient_profile_city | <chr> | 4570 | 369 | NEW YORK, HOUSTON, BROOKLYN, LOS ANGELES, LOUISVILLE, MIAMI, PHOENIX, PHILADELPHIA, PEORIA, ALLENTOWN |
| covered_recipient_profile_state | <chr> | 1000 | 46 | CA, NY, FL, TX, PA, MI, NC, IL, NJ, AZ |
| covered_recipient_profile_zipcode | <chr> | 4715 | 495 | 75701-2130, 79106-1729, 44195-0001, 55905-0001, 92505-3043, 30605-1331, 11766-1428, 22401-4453, 19426-4927, 97504-5590 |
| covered_recipient_profile_country_name | <chr> | 6500 | 1 | UNITED STATES |
| covered_recipient_profile_primary_specialty | <chr> | 28209 | 85 | Allopathic & Osteopathic Physicians|Family Medicine, Allopathic & Osteopathic Physicians|Internal Medicine, Allopathic & Osteopathic Physicians|Psychiatry & Neurology|Psychiatry, Allopathic & Osteopathic Physicians|Pediatrics, Allopathic & Osteopathic Physicians|Ophthalmology, Dental Providers|Dentist|General Practice, Eye and Vision Services Providers|Optometrist, Allopathic & Osteopathic Physicians|Obstetrics & Gynecology, Allopathic & Osteopathic Physicians|Internal Medicine|Gastroenterology, Allopathic & Osteopathic Physicians|Psychiatry & Neurology|Neurology |
| covered_recipient_profile_license_state_code_1 | <chr> | 1000 | 44 | CA, NY, FL, TX, PA, MI, IL, NC, OH, GA |
| covered_recipient_profile_license_state_code_2 | <chr> | 446 | 47 | PA, NY, CA, FL, TX, MI, NJ, NC, VA, MN |
| covered_recipient_profile_license_state_code_3 | <chr> | 178 | 33 | VA, MI, GA, OH, TX, FL, CA, OK, PA, WI |
| covered_recipient_profile_license_state_code_4 | <chr> | 90 | 29 | MI, TX, OH, IN, FL, IA, CO, PA, VA, CA |
| covered_recipient_profile_license_state_code_5 | <chr> | 30 | 13 | FL, CA, ME, PA, NM, OR, MS, MI, MD, AR |
| covered_recipient_profile_alternate_first_name2 | <chr> | 702 | 80 | DAVE, JOHN, RANDOLPH, ANN, KEN, ED, JAMIE, PAT, ANDY, SUE |
| covered_recipient_profile_alternate_last_name2 | <chr> | 950 | 133 | LOUIS, HENRY, HO, KIMBERLY, MILLER, GROBER, DAVOL, WIRTH, POST, GIRARDI |
| covered_recipient_profile_alternate_first_name3 | <chr> | 28 | 5 | RALPH, SUSAN, FRANCES, ABBY, ANTHONY |
| covered_recipient_profile_alternate_last_name3 | <chr> | 28 | 5 | RALPH, SUSAN, FRANCES, ABBY, ANTHONY |
| covered_recipient_profile_alternate_first_name4 | <chr> | 7 | 1 | ANTONIO |
| covered_recipient_profile_alternate_last_name4 | <chr> | 7 | 1 | ANTONIO |
| has_multiple_ids | <chr> | 2499 | 2 | false, true |
• Rows [1.5M] • Pages [3.1k] • Fields [20]
open_quick("profile_information") |>
providertwo:::map_na_if() |>
slt(-entity_alternate_name5,
-entity_address_line_2,
-entity_province_name,
-location
) |>
fuimus::describe2() |>
slt(column, type, n, uniq, top) |>
gt_tab()| column | type | n | uniq | top |
|---|---|---|---|---|
| entity_id | <chr> | 4418 | - | - |
| entity_provider_type | <chr> | 108 | 1 | Covered Recipient Physician |
| entity_npi | <chr> | 40 | 4 | 1003020595, 1003000407, 1225217094, 1215900089 |
| entity_alternate_id | <chr> | 2500 | 1 | false |
| entity_type | <chr> | 500 | 3 | h, c, p |
| entity_name | <chr> | 12311 | 499 | PROVIDENCE HOSPITAL, SOUTHEAST HEALTH MEDICAL CENTER, NORTH ALABAMA MEDICAL CENTER, ST. VINCENTS EAST, CALLAHAN EYE FOUNDATION HOSP, BAPTIST MEDICAL CENTER SOUTH, EAST ALABAMA MEDICAL CENTER, UNIVERSITY OF ALABAMA HOSPITAL, HUNTSVILLE HOSPITAL, ST VINCENTS BIRMINGHAM |
| entity_alternate_name1 | <chr> | 6710 | 186 | KAISER FOUNDATION HOSPITALS, DIGNITY HEALTH, HCA HEALTHONE LLC, COUNTY OF LOS ANGELES AUDITOR CONTROLLER, CATHOLIC HEALTH INITIATIVES COLORADO, UNIVERSITY OF SOUTH ALABAMA, SCOTTSDALE HEALTHCARE HOSPITALS, SUTTER WEST BAY HOSPITALS, SCRIPPS HEALTH, SUTTER HEALTH SACRAMENTO SIERRA REGION |
| entity_alternate_name2 | <chr> | 1276 | 48 | SUTTER WEST BAY HOSPITALS, ST. VINCENT'S EAST, ST VINCENTS HOSPITAL, UNIV OF SOUTH ALABAMA MEDICAL CENTER, TRINITY MEDICAL CENTER, USA CHILDREN S AND WOMEN S HOSPITAL, JOHN C LINCOLN HOSP-NORTH MOUNTAIN, MARICOPA MEDICAL CENTER, VHS OF PHOENIX INC, SCOTTSDALE HEALTHCARE - OSBORN |
| entity_alternate_name3 | <chr> | 323 | 10 | ST. VINCENT'S HOSPITAL, JOHN C LINCOLN MEDICAL CENTER, SCOTTSDALE HEALTHCARE-OSBORN, SCOTTSDALE SHEA MEDICAL CENTER, SCOTTSDALE THOMPSON PEAK MED CTR, UNIVERSITY OF ARKANSAS FOR MEDICAL SCIENCES, DOCTORS HOSPITAL OF WEST COVINA, INC., HANFORD COMMUNITY MEDICAL CENTER, PRESBYTERIAN INTERCOMMUNITY HOSPITAL, INC., PIH HEALTH HOSPITAL - DOWNEY |
| entity_alternate_name4 | <chr> | 114 | 4 | JOHN C. LINCOLN MEDICAL CENTER, SCOTTSDALE OSBORN MEDICAL CENTER, UNIV OF AR FOR MEDICAL SCIENCES, PIH HOSPITAL - DOWNEY |
| entity_address_line_1 | <chr> | 5163 | 261 | 2801 Atlantic Avenue, 1108 Ross Clark Circle, 1701 Veterans Drive, 50 Medical Park Drive East, 1720 University Boulevard, 2105 East South Boulevard, 2000 Pepperell Pkwy, 619 South 19th Street, 101 Sivley Road, 810 St Vincents Drive |
| entity_city | <chr> | 2368 | 156 | Los Angeles, San Francisco, Washington, Birmingham, Phoenix, Denver, Sacramento, Mobile, Little Rock, Long Beach |
| entity_state | <chr> | 962 | 33 | CA, NJ, MA, AZ, CO, AL, CT, AR, PA, FL |
| entity_zipcode | <chr> | 1324 | 230 | 35233, 72205, 90033, 20010, 72401, 94117, 92103, 95128, 94109, 94110 |
| entity_country_name | <chr> | 3055 | 10 | United States, Japan, Switzerland, UNITED STATES, Denmark, Hong Kong, Sweden, Great Britain (UK), Mexico, Singapore |
| entity_specialty | <chr> | 189 | 3 | Allopathic & Osteopathic Physicians|Family Medicine, Dental Providers|Dentist|General Practice, Allopathic & Osteopathic Physicians|Pediatrics |
• Rows [2.4k] • Pages [5] • Fields [2]
open_quick("profile_mapping") |>
providertwo:::map_na_if() |>
fuimus::describe2() |>
slt(column, type, n, uniq, distribution, min, max) |>
gt_tab()| column | type | n | uniq | distribution | min | max |
|---|---|---|---|---|---|---|
| primary_provider_profile_id | <chr> | 3382 | 499 | ▁▁▁▂▁▅▁▇▁▅ | 3 | 8 |
| secondary_provider_profile_id | <chr> | 3667 | - | ▇▁▁▁▁▁▁▁▁▃ | 7 | 8 |
• Rows [2.8k] • Pages [6] • Fields [9]
open_quick("profile_entity") |>
providertwo:::map_na_if() |>
slt(-amgpo_making_payment_alternate_name4,
-amgpo_making_payment_alternate_name5
) |>
fuimus::describe2() |>
slt(column, type, n, uniq, top, distribution, min:max) |>
gt_tab()| column | type | n | uniq | top | distribution | min | mean | med | max |
|---|---|---|---|---|---|---|---|---|---|
| amgpo_making_payment_id | <chr> | 6000 | - | - | ▇ | 12 | 12.0 | 12 | 12 |
| amgpo_making_payment_name | <chr> | 11446 | - | - | ▁▇▇▂▁▁▁▁ | 6 | 22.9 | 22 | 77 |
| amgpo_making_payment_state | <chr> | 918 | 39 | CA, NJ, MA, PA, FL, MN, TX, NY, IL, IN | ▇ | 2 | 2.0 | 2 | 2 |
| amgpo_making_payment_country | <chr> | 6297 | 14 | United States, Japan, Switzerland, Denmark, Germany, Great Britain (UK), Sweden, Hong Kong, Singapore, Spain | ▁▁▁▁▁▁▁▇▁▁▁▁▁ | 5 | 12.6 | 13 | 18 |
| amgpo_making_payment_alternate_name1 | <chr> | 2367 | 103 | DAVOL INC., MERCK SHARP & DOHME CORPORATION, 00604-HILL-ROM HOLDINGS, INC, NATIONAL DENTEX CORPORATION, MEDACTA USA, ENDOLOGIX, INC., ARIAD PHARMACEUTICALS, INC., BLOOD SYSTEMS, INC., STRECK, INC., ZIMMER HOLDING INC | ▅▇▇▃▂▁▁▁▁▁ | 10 | 22.8 | 22 | 57 |
| amgpo_making_payment_alternate_name2 | <chr> | 380 | 15 | ENDOLOGIX, LLC, KATENA PRODUCTS, INC., ORTHO KINEMATICS INC., KLS MARTIN L.P., GRIFOLS BIOLOGICALS, INC., PHARMA PHARMA, L.P., OLYMPUS CORPORATION OF THE AMERICAS, CARDINAL HEALTH PR 120 INC, GE GLOBAL RESEARCH AN UNINCORPORATED BUSINESS UNIT OF GENERAL ELECTRIC COMPANY, DJO , LLC | ▃▃▃▇▃▂▂▁▁▁▁▁▁▁▂ | 9 | 25.3 | 21 | 78 |
| amgpo_making_payment_alternate_name3 | <chr> | 18 | 1 | CHF SOLUTIONS, INC | ▇ | 18 | 18.0 | 18 | 18 |
• Rows [1.4k] • Pages [3] • Fields [12]
open_quick("profile_teaching") |>
providertwo:::map_na_if() |>
slt(-teaching_hospital_address2,
-teaching_hospital_alternate_name5
) |>
fuimus::describe2() |>
slt(column, type, n, uniq, top, distribution, min:max) |>
gt_tab()| column | type | n | uniq | top | distribution | min | mean | med | max |
|---|---|---|---|---|---|---|---|---|---|
| teaching_hospital_ccn | <chr> | 3000 | - | - | ▇ | 6 | 6.00 | 6.0 | 6 |
| teaching_hospital_name | <chr> | 13098 | 497 | PROVIDENCE HOSPITAL, MERCY MEDICAL CENTER, ST. FRANCIS HOSPITAL & HEALTH CENTER, SOUTHEAST HEALTH MEDICAL CENTER, NORTH ALABAMA MEDICAL CENTER, ST. VINCENTS EAST, CALLAHAN EYE FOUNDATION HOSP, BAPTIST MEDICAL CENTER SOUTH, EAST ALABAMA MEDICAL CENTER, UNIVERSITY OF ALABAMA HOSPITAL | ▁▂▂▃▅▇▇▇▇▇▇▇▇ | 10 | 26.20 | 27.0 | 36 |
| teaching_hospital_address1 | <chr> | 9916 | 499 | 2801 Atlantic Avenue, 1108 Ross Clark Circle, 1701 Veterans Drive, 50 Medical Park Drive East, 1720 University Boulevard, 2105 East South Boulevard, 2000 Pepperell Pkwy, 619 South 19th Street, 101 Sivley Road, 810 St Vincents Drive | ▁▁▂▅▇▇▇▃▂▁▁▁▁ | 8 | 19.83 | 20.0 | 34 |
| teaching_hospital_city | <chr> | 4439 | 296 | Chicago, Los Angeles, Miami, San Francisco, Washington, Atlanta, Indianapolis, Birmingham, Phoenix, Denver | ▅▇▇▃▂▁▁▁▁▁ | 4 | 8.88 | 8.5 | 23 |
| teaching_hospital_state | <chr> | 1000 | 17 | CA, FL, IL, GA, IN, CO, AL, AZ, CT, AR | ▇ | 2 | 2.00 | 2.0 | 2 |
| teaching_hospital_zip_code | <chr> | 2499 | 445 | 35233, 72205, 90033, 33136, 20010, 60612, 60611, 72401, 94117, 92103 | ▁▁▁▁▁▁▁▁▁▇ | 4 | 5.00 | 5.0 | 5 |
| teaching_hospital_alternate_name1 | <chr> | 10377 | 279 | KAISER FOUNDATION HOSPITALS, DIGNITY HEALTH, HCA HEALTHONE LLC, COUNTY OF LOS ANGELES AUDITOR CONTROLLER, CATHOLIC HEALTH INITIATIVES COLORADO, COOK COUNTY, FRANCISCAN ST. FRANCIS HEALTH, UNIVERSITY OF SOUTH ALABAMA, SCOTTSDALE HEALTHCARE HOSPITALS, SUTTER WEST BAY HOSPITALS | ▁▁▂▂▃▇▅▃▁▁▁▁▁▁ | 4 | 30.34 | 30.0 | 70 |
| teaching_hospital_alternate_name2 | <chr> | 2636 | 87 | SUTTER WEST BAY HOSPITALS, NORTH BROWARD HOSPITAL DISTRICT, COMMUNITY HOSPITALS OF INDIANA INC, ST. VINCENT'S EAST, ST VINCENTS HOSPITAL, UNIV OF SOUTH ALABAMA MEDICAL CENTER, TRINITY MEDICAL CENTER, USA CHILDREN S AND WOMEN S HOSPITAL, JOHN C LINCOLN HOSP-NORTH MOUNTAIN, MARICOPA MEDICAL CENTER | ▁▁▃▃▇▇▃▂▁▁▁ | 9 | 29.29 | 29.0 | 60 |
| teaching_hospital_alternate_name3 | <chr> | 569 | 19 | ST. VINCENT'S HOSPITAL, JOHN C LINCOLN MEDICAL CENTER, SCOTTSDALE HEALTHCARE-OSBORN, SCOTTSDALE SHEA MEDICAL CENTER, SCOTTSDALE THOMPSON PEAK MED CTR, UNIVERSITY OF ARKANSAS FOR MEDICAL SCIENCES, DOCTORS HOSPITAL OF WEST COVINA, INC., HANFORD COMMUNITY MEDICAL CENTER, PRESBYTERIAN INTERCOMMUNITY HOSPITAL, INC., PIH HEALTH HOSPITAL - DOWNEY | ▁▇▇▃▁▂▁▁ | 16 | 29.95 | 28.0 | 52 |
| teaching_hospital_alternate_name4 | <chr> | 173 | 6 | JOHN C. LINCOLN MEDICAL CENTER, SCOTTSDALE OSBORN MEDICAL CENTER, UNIV OF AR FOR MEDICAL SCIENCES, PIH HOSPITAL - DOWNEY, BETHESDA MEMORIAL HOSPITAL, MERCY MEDICAL CENTER - NORTH IOWA | ▇▁▁▁▇▁▁▁▇▇▇▇ | 21 | 28.83 | 30.5 | 33 |
Summaries
open_quick("dashboard") |>
providertwo:::map_na_if() |>
mtt(
py_2017 = as.numeric(py_2017),
py_2018 = as.numeric(py_2018),
py_2019 = as.numeric(py_2019),
py_2020 = as.numeric(py_2020),
py_2021 = as.numeric(py_2021),
py_2022 = as.numeric(py_2022),
py_2023 = as.numeric(py_2023),
total = as.numeric(total)
) |>
slt(-dashboard_row_number) |>
fuimus::describe2() |>
slt(column, type, n, uniq, top, distribution, min:max) |>
gt_tab()| column | type | n | uniq | top | distribution | min | mean | med | max |
|---|---|---|---|---|---|---|---|---|---|
| py_2017 | <dbl> | 67105633620 | 65 | 0, 4550167239.87, 268224163.55, 1073242791.31, 23232, 27902592, 268200931.55, 1045340199.31, 659929, 3323 | ▇▁▁▁▁▁▁▁▁▁ | 0 | 745618151.3 | 659929 | 9983443884 |
| py_2018 | <dbl> | 74498832456 | 65 | 0, 4665451392.04, 542424630.64, 1649375557.92, 64837.5, 265936, 542359793.14, 1649109621.92, 625509, 3599 | ▇▁▁▁▁▁▁▁▁▁▁ | 0 | 827764805.1 | 625509 | 10988256091 |
| py_2019 | <dbl> | 80099026122 | 59 | 0, 526403105.28, 1621023068.27, 3019, 4781996558.5, 628332, 11879437810.02, 3711163078.7, 748979.39, 3710414099.31 | ▇▁▁▁▁▁▁▁▁▁▁▁ | 0 | 889989179.1 | 513533 | 11879437810 |
| py_2020 | <dbl> | 68595568064 | 55 | 0, 420228142.68, 1383815859.42, 3539, 4789571898.53, 529349, 81518253.75, 29267, 10051904838.51, 2186720794.51 | ▇▁▁▁▁▁▁▁▁▁▁ | 0 | 762172978.5 | 509878 | 10051904839 |
| py_2021 | <dbl> | 84289664047 | 71 | 0, 416271283.34, 1548506879.01, 4162, 1, 424947.27, 183, 12467447334.16, 3254780104.85, 2371047.52 | ▇▁▁▁▁▁▁▁▁▁▁▁▁ | 0 | 936551822.7 | 840136 | 12467447334 |
| py_2022 | <dbl> | 85932755984 | 75 | 287661921.26, 0, 1, 1149881794.14, 99992.65, 1149781801.49, 4052, 4051, 413856.12, 281 | ▇▁▁▁▁▁▁▁▁▁▁▁▁ | 0 | 954808399.8 | 987677 | 12796535186 |
| py_2023 | <dbl> | 85248706600 | 77 | 2, 218848111.81, 1339780245.24, 11600, 160592.65, 218836511.81, 1339619652.59, 4013, 4011, 531520.22 | ▇▁▁▁▁▁▁▁▁▁▁▁▁ | 0 | 947207851.1 | 970752 | 12689034242 |
| total | <dbl> | 495211531878 | 78 | 2680061358.56, 1339780245.24, 99669.5, 160592.65, 2679961689.06, 1339619652.59, 4013, 2, 4011, 1370323.61 | ▇▁▁▁▁▁▁▁ | 0 | 5502350354.2 | 6133553 | 72430213437 |
| data_metrics | <chr> | 7246 | - | - | ▁▁▂▅▅▇▅▂▁ | 35 | 80.5 | 82 | 116 |
open_dashboard()$count
$count$entity
# A tibble: 32 × 3
year metric count
* <fct> <chr> <int>
1 ALL Companies [AM/GPO] Making Payments 2843
2 2023 Companies [AM/GPO] Making Payments 1776
3 2022 Companies [AM/GPO] Making Payments 1858
4 2021 Companies [AM/GPO] Making Payments 1855
5 2020 Companies [AM/GPO] Making Payments 1779
6 2019 Companies [AM/GPO] Making Payments 1797
7 2018 Companies [AM/GPO] Making Payments 1755
8 2017 Companies [AM/GPO] Making Payments 1678
9 ALL NPPs with Payment Records 414900
10 2023 NPPs with Payment Records 309427
# ℹ 22 more rows
$count$record
# A tibble: 320 × 5
year type entity status count
* <fct> <chr> <chr> <chr> <int>
1 ALL All <NA> <NA> 84035057
2 ALL All Physician <NA> 65341949
3 ALL All Non-Physician Practitioner <NA> 12787445
4 ALL All Teaching Hospital <NA> 1131236
5 2023 All <NA> <NA> 15639275
6 2023 All Physician <NA> 9630514
7 2023 All Non-Physician Practitioner <NA> 4976520
8 2023 All Teaching Hospital <NA> 143632
9 2022 All <NA> <NA> 14277900
10 2022 All Physician <NA> 9036995
# ℹ 310 more rows
$dollar
py_2017 py_2018 py_2019 py_2020 py_2021
1 9983443884.20 10988256091.29 11879437810.02 10051904838.51 12467447334.16
2 2964700222.32 3119803936.32 3711163078.70 2186720794.51 3254780104.85
3 1605102.03 2312465.96 748979.39 1846711.88 2371047.52
4 2963095120.29 3117491470.36 3710414099.31 2184874082.63 3252409057.33
5 5945500870.57 6219076597.05 6547251663.05 6481368184.58 7664160350.30
6 1395333630.70 1553625205.01 1765255104.55 1691796286.05 1746440892.30
7 4550167239.87 4665451392.04 4781996558.50 4789571898.53 5917719458.00
8 4661745514.93 4774115009.02 4881865703.11 4871090152.28 5997888265.40
9 4550167239.87 4665451392.04 4781996558.50 4789571898.53 5918144405.27
10 3627948.41 2757924.06 799696.03 4969542.66 14084579.48
11 5941872922.16 6216318672.99 6546451967.02 6476398641.92 7650075770.82
12 3378040924.89 4026803500.44 4152248318.02 3150507454.70 3785115290.98
13 2193219858.52 2268764325.54 2431356105.14 1685173341.53 2156439604.57
14 490299.63 1083558.67 261971.45 1586153.40 1737369.69
15 2192729558.89 2267680766.87 2431094133.69 1683587188.13 2154702234.88
16 111578275.06 108663616.98 99869144.61 81518253.75 80168807.40
17 154926.21 414854.72 14026.26 0.00 1250.00
18 111423348.85 108248762.26 99855118.35 81518253.75 80167557.40
19 268200931.55 542359793.14 526403105.28 420228142.68 416271283.34
20 0.00 0.00 0.00 0.00 122747788.11
21 0.00 0.00 0.00 0.00 122322840.84
22 0.00 0.00 0.00 0.00 18.52
23 0.00 0.00 0.00 0.00 122322822.32
24 0.00 0.00 0.00 0.00 424947.27
25 0.00 0.00 0.00 0.00 0.00
26 0.00 0.00 0.00 0.00 424947.27
27 2055235719.44 2296001198.81 2945192933.50 2111825485.28 2641864797.07
28 771480363.80 851039610.78 1279806973.56 501547452.98 976017659.44
29 1114802.40 1228907.29 487007.94 260558.48 633659.31
30 770365561.40 849810703.49 1279319965.62 501286894.50 975384000.13
31 1283755355.64 1444961588.03 1665385959.94 1610278032.30 1665847137.63
32 1982705.97 2131111.82 540057.58 4391941.84 13900429.89
33 1281772649.67 1442830476.21 1664845902.36 1605886090.46 1651946707.74
34 4546892261.48 4664795828.51 4781363988.97 4781213459.73 5916766223.83
35 3274978.39 655563.53 632569.53 8358438.80 953234.17
py_2022 py_2023 total
1 12796535186.43 12689034242.09 72430213436.63
2 3809735884.65 3277603855.21 22324507876.56
3 2069604.56 1225485.72 12179397.06
4 3807666280.09 3276378369.49 22312328479.50
5 7836917507.64 8071650141.64 48765925314.83
6 1716211299.85 1579336770.11 11447999188.57
7 6120706207.79 6492313371.53 37317926126.26
8 6198723322.61 6563407840.25 37948835807.60
9 6121120063.91 6492844891.75 37319296449.87
10 5714287.20 2087094.33 34041072.17
11 7831203220.44 8069563047.31 48731884242.66
12 3767114109.45 3685952691.22 17519936339.63
13 2539215200.49 2275077977.26 15549246413.05
14 277181.95 311954.60 5748489.39
15 2538938018.54 2274766022.66 15543497923.66
16 78017114.82 71094468.72 630909681.34
17 1000.00 4570.55 590627.74
18 78016114.82 71089898.17 630319053.60
19 287661921.26 218836511.81 2679961689.06
20 170988346.96 209667312.38 503403447.45
21 170574490.84 209135792.16 502033123.84
22 884.79 123.57 1026.88
23 170573606.05 209135668.59 502032096.96
24 413856.12 531520.22 1370323.61
25 0.00 0.00 0.00
26 413856.12 531520.22 1370323.61
27 2737726522.23 2301100866.96 17088947523.29
28 1099946193.32 793390085.79 6273228339.67
29 1791537.82 913407.55 6429880.79
30 1098154655.50 792476678.24 6266798458.88
31 1637780328.91 1507710781.17 10815719183.62
32 4823319.85 1618362.83 29387929.78
33 1632957009.06 1506092418.34 10786331253.84
34 6120240114.34 6491463753.23 37302735630.09
35 466093.45 849618.30 15190496.17
metric
1 Payment Records
2 Payment Records - General Payments
3 Payment Records - General Payments - Disputed
4 Payment Records - General Payments - Undisputed
5 Payment Records - Research Payments
6 Payment Records - Research Payments - Covered Recipient
7 Payment Records - Research Payments - Non-Covered Recipient
8 Payment Records - Research Payments - Physician or Non-Covered Recipient
9 Payment Records - Research Payments - Non-Physician Practitioner or Non-Covered Recipient
10 Payment Records - Research Payments - Disputed
11 Payment Records - Research Payments - Undisputed
12 Payment Records to Physicians
13 Payment Records to Physicians - General Payments
14 Payment Records to Physicians - General Payments - Disputed
15 Payment Records to Physicians - General Payments - Undisputed
16 Payment Records to Physicians - Research Payments
17 Payment Records to Physicians - Research Payments - Disputed
18 Payment Records to Physicians - Research Payments - Undisputed
19 Payment Records to Physicians - Ownership Payments - Undisputed
20 Payment Records to Non-Physician Practitioners
21 Payment Records to Non-Physician Practitioners - General Payments
22 Payment Records to Non-Physician Practitioners - General Payments - Disputed
23 Payment Records to Non-Physician Practitioners - General Payments - Undisputed
24 Payment Records to Non-Physician Practitioners - Research Payments
25 Payment Records to Non-Physician Practitioners - Research Payments - Disputed
26 Payment Records to Non-Physician Practitioners - Research Payments - Undisputed
27 Payment Records to Teaching Hospitals
28 Payment Records to Teaching Hospitals - General Payments
29 Payment Records to Teaching Hospitals - General Payments - Disputed
30 Payment Records to Teaching Hospitals - General Payments - Undisputed
31 Payment Records to Teaching Hospitals - Research Payments
32 Payment Records to Teaching Hospitals - Research Payments - Disputed
33 Payment Records to Teaching Hospitals - Research Payments - Undisputed
34 Payment Records - Research Payments - Non-Covered Recipient Entity
35 Payment Records - Research Payments - Non-Covered Recipient Individual
$invest
py_2017 py_2018 py_2019 py_2020 py_2021 py_2022
1 268224163.55 542424630.64 526403105.28 420228142.68 416271283.34 287661921.26
2 23232.00 64837.50 0.00 0.00 0.00 0.00
3 268200931.55 542359793.14 526403105.28 420228142.68 416271283.34 287661921.26
4 268224163.55 542424630.64 526403105.28 420228142.68 416271283.34 287661921.26
5 23232.00 64837.50 0.00 0.00 0.00 0.00
py_2023 total metric
1 218848111.81 2680061358.56 Ownership Payments
2 11600.00 99669.50 Ownership Payments- Disputed
3 218836511.81 2679961689.06 Ownership Payments- Undisputed
4 218848111.81 2680061358.56 to Physicians - Ownership Payments
5 11600.00 99669.50 to Physicians - Ownership Payments - Disputed
$value
py_2017 py_2018 py_2019 py_2020 py_2021
1 1073242791.31 1649375557.92 1621023068.27 1383815859.42 1548506879.01
2 27902592.00 265936.00 0.00 0.00 0.00
3 1045340199.31 1649109621.92 1621023068.27 1383815859.42 1548506879.01
4 1073242791.31 1649375557.92 1621023068.27 1383815859.42 1548506879.01
5 27902592.00 265936.00 0.00 0.00 0.00
6 1045340199.31 1649109621.92 1621023068.27 1383815859.42 1548506879.01
py_2022 py_2023 total
1 1149881794.14 1339780245.24 1339780245.24
2 99992.65 160592.65 160592.65
3 1149781801.49 1339619652.59 1339619652.59
4 1149881794.14 1339780245.24 1339780245.24
5 99992.65 160592.65 160592.65
6 1149781801.49 1339619652.59 1339619652.59
metric
1 Ownership Payments
2 Ownership Payments - Disputed
3 Ownership Payments - Undisputed
4 to Physician - Ownership Payments
5 to Physicians - Ownership Payments - Disputed
6 to Physicians - Ownership Payments - Undisputed• Rows [24] • Pages [1] • Fields [18]
# open_quick("national_total")
open_national() |>
fuimus::describe2() |>
gt_tab()| column | type | n | min | mean | med | max | iqr | sd | mad | distribution | uniq | top |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| recipient_n | <int> | 6556755 | 86 | 273198.12 | 129273.0 | 1117674 | 543896.00 | 317713.554 | 191502.253 | ▇▁▁▁▁▁▂▁▁▁▁▁ | - | - |
| payments_n | <int> | 156250762 | 183 | 6510448.42 | 1893609.5 | 65124632 | 9133595.25 | 13304794.553 | 2807121.481 | ▇▂▂▁▁▁▁▁▁▁▁▁▁▁ | - | - |
| year | <fct> | 92 | 1 | 3.83 | 3.5 | 8 | 3.25 | 2.239 | 2.224 | ▇▇▁▇▁▇▁▃▁▃▁▃▁▃ | 8 | 2021, 2022, 2023, ALL, 2017, 2018, 2019, 2020 |
| payment_type | <fct> | 36 | 1 | 1.50 | 1.5 | 2 | 1.00 | 0.511 | 0.741 | ▇▁▁▁▁▁▁▁▁▇ | 2 | General, Research |
| recipient_type | <fct> | 40 | 1 | 1.67 | 2.0 | 2 | 1.00 | 0.482 | 0.000 | ▃▁▁▁▁▁▁▁▁▇ | 2 | Physician, Non-Physician Practitioner |
| payment_sum | <dbl> | 33367119084 | 413856 | 1390296628.49 | 146448665.8 | 15549246413 | 2086003783.80 | 3170295766.438 | 216415762.624 | ▇▂▁▁▁▁▁▁ | - | - |
| payment_mean | <dbl> | 184090 | 520 | 7670.43 | 3960.8 | 27135 | 10293.85 | 6926.271 | 4473.983 | ▃▇▂▁▁▁▂▃▁▁▁▁▁▁ | - | - |
| payment_median | <dbl> | 25050 | 115 | 1043.76 | 757.6 | 2800 | 1742.29 | 980.419 | 926.143 | ▇▁▁▁▁▁▂▁▁▂▁▁▁▁ | - | - |
| payments_mean | <dbl> | 299 | 2 | 12.46 | 10.5 | 58 | 10.50 | 12.007 | 8.154 | ▇▁▃▂▁▁▁▁▁▁▁▁ | 12 | 15, 5, 4, 2, 17, 16, 31, 18, 12, 58 |
| payments_median | <dbl> | 76 | 1 | 3.17 | 3.0 | 9 | 2.00 | 1.659 | 1.483 | ▇▂▅▁▁▁▁▁ | 6 | 4, 2, 3, 1, 5, 9 |
• Rows [4.2k] • Pages [9] • Fields [21]
open_quick("national_group") |>
fuimus::describe2() |>
slt(column, type, n, uniq, top, distribution, min:max) |>
gt_tab()| column | type | n | uniq | top | distribution | min | mean | med | max |
|---|---|---|---|---|---|---|---|---|---|
| payment_type | <chr> | 3675 | 2 | General, Research | ▇▁▁▁▁▁▁▁▁▃ | 7 | 7.35 | 7 | 8 |
| recipient_type | <chr> | 13500 | 1 | Covered Recipient Physician | ▇ | 27 | 27.00 | 27 | 27 |
| program_year | <chr> | 2000 | 2 | 2017, 2018 | ▇ | 4 | 4.00 | 4 | 4 |
| taxonomy_code | <chr> | 4994 | 306 | 207K00000X, 207KA0200X, 207KI0005X, 207L00000X, 207LC0200X, 207LP2900X, 207LP3000X, 208U00000X, 208C00000X, 207N00000X | ▁▁▁▁▁▇ | 7 | 9.99 | 10 | 10 |
| provider_type_description | <chr> | 17192 | 8 | Allopathic & Osteopathic Physicians, Dental Providers, Physician Assistants & Advanced Practice Nursing Providers, Eye and Vision Services Providers, Chiropractic Providers, Podiatric Medicine & Surgery Service Providers, Nursing Service Providers, N/A | ▁▁▁▁▁▁▇▁▁▁▁▁ | 3 | 34.38 | 35 | 58 |
| classification | <chr> | 7828 | 58 | Internal Medicine, Pediatrics, Psychiatry & Neurology, Pathology, Dentist, Dermatology, Obstetrics & Gynecology, Radiology, Surgery, Anesthesiology | ▁▇▅▇▃▁▁▁▁▁ | 3 | 15.66 | 15 | 50 |
| specialization | <chr> | 9369 | 196 | N/A, Hospice and Palliative Medicine, Sports Medicine, Pain Medicine, Addiction Medicine, Obesity Medicine, Sleep Medicine, Critical Care Medicine, Adolescent Medicine, Clinical & Laboratory Immunology | ▅▂▃▇▅▂▂▂▁▁▁▁ | 3 | 18.74 | 18 | 56 |
| total_number_of_physicians | <chr> | 1158 | 263 | 1, 3, 2, 4, 6, 5, 9, 7, 8, 10 | ▇▇▁▇▁▂▁▁ | 1 | 2.32 | 2 | 5 |
| total_number_of_non_physician_practitioners | <chr> | 500 | 1 | 0 | ▇ | 1 | 1.00 | 1 | 1 |
| total_payment_amount_physician | <chr> | 4288 | - | - | ▁▂▃▅▇▅▂▁ | 4 | 8.58 | 9 | 12 |
| total_payment_amount_non_physician_practitioner | <chr> | 2000 | 1 | 0.00 | ▇ | 4 | 4.00 | 4 | 4 |
| mean_total_payment_amount_physician | <chr> | 3409 | 498 | 531.16, 1833.60, 3447.45, 3014.54, 4961.79, 922.25, 708.08, 3017.95, 116.23, 2882.99 | ▁▁▁▃▁▇▁▂▁▁ | 4 | 6.82 | 7 | 9 |
| mean_total_payment_amount_non_physician_practitioner | <chr> | 2000 | 1 | 0.00 | ▇ | 4 | 4.00 | 4 | 4 |
| median_total_payment_amount_physician | <chr> | 3024 | 494 | 350.00, 34.61, 68.34, 1500.00, 50.00, 281.53, 233.63, 798.53, 65.23, 107.43 | ▁▇▁▇▁▅▁▁ | 4 | 6.05 | 6 | 8 |
| median_total_payment_amount_non_physician_practitioner | <chr> | 2000 | 1 | 0.00 | ▇ | 4 | 4.00 | 4 | 4 |
| total_payment_count_physician | <chr> | 1483 | 344 | 2, 1, 5, 8, 3, 7, 4, 11, 13, 15 | ▅▇▁▅▁▅▁▃▁▁▁▁ | 1 | 2.97 | 3 | 7 |
| total_payment_count_non_physician_practitioner | <chr> | 500 | 1 | 0 | ▇ | 1 | 1.00 | 1 | 1 |
| mean_total_payment_count_physician | <chr> | 624 | 40 | 2, 3, 5, 4, 1, 6, 7, 9, 8, 12 | ▇▁▁▁▁▁▁▁▁▂ | 1 | 1.25 | 1 | 2 |
| mean_total_payment_count_non_physician_practitioner | <chr> | 500 | 1 | 0 | ▇ | 1 | 1.00 | 1 | 1 |
| median_total_payment_count_physician | <chr> | 530 | 18 | 2, 1, 3, 4, 5, 6, 7, 9, 8, 10 | ▇▁▁▁▁▁▁▁▁▁ | 1 | 1.06 | 1 | 2 |
| median_total_payment_count_non_physician_practitioner | <chr> | 500 | 1 | 0 | ▇ | 1 | 1.00 | 1 | 1 |
• Rows [2.8k] • Pages [6] • Fields [28]
open_quick("state_total") |>
fuimus::describe2() |>
slt(column, type, n, uniq, top, distribution, min:max) |>
gt_tab()| column | type | n | uniq | top | distribution | min | mean | med | max |
|---|---|---|---|---|---|---|---|---|---|
| country_code | <chr> | 1000 | 33 | US, AE, AG, AU, AX, CA, DE, GB, IL, IN | ▇ | 2 | 2.00 | 2 | 2 |
| country_name | <chr> | 6361 | 33 | United States, United Arab Emirates, Antigua And Barbuda, Australia, Aland Islands, Canada, Germany, Great Britain (UK), Israel, India | ▁▁▇▁▁▁▁▁ | 4 | 12.72 | 13 | 36 |
| state_code | <chr> | 902 | 62 | AA, AE, AK, AL, AP, AR, AS, AZ, CA, CO | ▇ | 2 | 2.00 | 2 | 2 |
| state_name | <chr> | 4818 | 62 | Armed Forces Americas, Armed Forces Europe / Canada / Middle East / Africa, Alaska, Alabama, Armed Forces Pacific, Arkansas, American Samoa, Arizona, California, Colorado | ▂▇▃▁▁▁▁▁▁▁▁ | 4 | 10.68 | 8 | 51 |
| payment_type | <chr> | 3748 | 2 | General, Research | ▇▁▁▁▁▁▁▁▁▇ | 7 | 7.50 | 7 | 8 |
| recipient_type | <chr> | 15124 | 2 | Covered Recipient Physician, Covered Recipient Teaching Hospital | ▇▁▁▁▁▁▁▅ | 27 | 30.25 | 27 | 35 |
| program_year | <chr> | 2000 | 2 | 2017, 2018 | ▇ | 4 | 4.00 | 4 | 4 |
| total_number_of_physicians | <chr> | 1012 | 203 | 0, 1, 2, 3, 5, 10, 35, 13, 24, 18 | ▇▂▁▁▁▁▁▁ | 1 | 2.02 | 1 | 5 |
| total_number_of_non_physician_practitioners | <chr> | 500 | 1 | 0 | ▇ | 1 | 1.00 | 1 | 1 |
| total_number_of_teaching_hospitals | <chr> | 597 | 53 | 0, 7, 3, 1, 5, 12, 4, 16, 8, 2 | ▇▁▁▁▂▁▁▁▁▁ | 1 | 1.19 | 1 | 3 |
| total_payment_amount_physician | <chr> | 3426 | 274 | 0.00, 2500.00, 62879.56, 1367916.59, 523930.96, 1229946.22, 16453127.47, 2982931.59, 1076063.18, 280507.53 | ▇▁▁▁▁▂▂▁ | 4 | 6.85 | 6 | 12 |
| total_payment_amount_non_physician_practitioner | <chr> | 2000 | 1 | 0.00 | ▇ | 4 | 4.00 | 4 | 4 |
| total_payment_amount_teaching_hospital | <chr> | 3018 | 168 | 0.00, 172755.97, 27006808.80, 3348399.66, 12173961.55, 194796658.42, 9754227.09, 6118013.88, 4846493.36, 2795962.06 | ▇▁▁▁▁▂▁▁ | 4 | 6.04 | 4 | 12 |
| mean_total_payment_amount_physician | <chr> | 2816 | 274 | 0.00, 2500.00, 12575.91, 14708.78, 14969.46, 7068.66, 17049.87, 17861.87, 9042.55, 8500.23 | ▇▁▁▁▁▅▁▂ | 4 | 5.63 | 6 | 8 |
| mean_total_payment_amount_non_physician_practitioner | <chr> | 2000 | 1 | 0.00 | ▇ | 4 | 4.00 | 4 | 4 |
| mean_total_payment_amount_teaching_hospital | <chr> | 2847 | 168 | 0.00, 172755.97, 3858115.54, 418549.96, 869568.68, 2497393.06, 750325.16, 509834.49, 807748.89, 1397981.03 | ▇▁▁▁▁▁▁▁▁▂▁▁ | 4 | 5.69 | 4 | 10 |
| median_total_payment_amount_physician | <chr> | 2604 | 265 | 0.00, 150.00, 3000.00, 2500.00, 1905.00, 1500.00, 1250.00, 143.57, 4230.00, 922.49 | ▇▂▁▃▁▃▁▁ | 4 | 5.21 | 5 | 8 |
| median_total_payment_amount_non_physician_practitioner | <chr> | 2000 | 1 | 0.00 | ▇ | 4 | 4.00 | 4 | 4 |
| median_total_payment_amount_teaching_hospital | <chr> | 2743 | 168 | 0.00, 172755.97, 30843.80, 329525.66, 166036.03, 150734.41, 96664.64, 216951.75, 246381.26, 1397981.03 | ▇▁▁▁▁▁▁▂▁▂▁▁ | 4 | 5.49 | 4 | 10 |
| total_payment_count_physician | <chr> | 1205 | 230 | 0, 1, 2, 3, 8, 6, 4, 5, 31, 75 | ▇▁▁▂▁▁▁▁▁▂▁▁ | 1 | 2.41 | 1 | 7 |
| total_payment_count_non_physician_practitioner | <chr> | 500 | 1 | 0 | ▇ | 1 | 1.00 | 1 | 1 |
| total_payment_count_teaching_hospital | <chr> | 896 | 162 | 0, 1022, 179, 356, 1049, 170, 150, 69, 3782, 349 | ▇▁▁▂▁▂▁▁ | 1 | 1.79 | 1 | 5 |
| mean_total_payment_count_physician | <chr> | 592 | 25 | 0, 4, 5, 1, 2, 3, 6, 18, 15, 20 | ▇▁▁▁▁▁▁▁▁▂ | 1 | 1.18 | 1 | 2 |
| mean_total_payment_count_non_physician_practitioner | <chr> | 500 | 1 | 0 | ▇ | 1 | 1.00 | 1 | 1 |
| mean_total_payment_count_teaching_hospital | <chr> | 727 | 119 | 0, 19, 44, 34, 20, 25, 21, 23, 50, 115 | ▇▁▁▁▂▁▁▁▁▁ | 1 | 1.45 | 1 | 3 |
| median_total_payment_count_physician | <chr> | 503 | 10 | 0, 2, 1, 3, 4, 5, 6, 47, 19, 13 | ▇▁▁▁▁▁▁▁▁▁ | 1 | 1.01 | 1 | 2 |
| median_total_payment_count_non_physician_practitioner | <chr> | 500 | 1 | 0 | ▇ | 1 | 1.00 | 1 | 1 |
| median_total_payment_count_teaching_hospital | <chr> | 664 | 76 | 0, 11, 19, 16, 23, 22, 17, 10, 15, 21 | ▇▁▁▁▂▁▁▁▁▁ | 1 | 1.33 | 1 | 3 |
• Rows [16.8k] • Pages [34] • Fields [28]
open_quick("state_group") |>
fuimus::describe2() |>
slt(column, type, n, uniq, top, distribution, min:max) |>
gt_tab()| column | type | n | uniq | top | distribution | min | mean | med | max |
|---|---|---|---|---|---|---|---|---|---|
| country_code | <chr> | 1000 | 1 | US | ▇ | 2 | 2.00 | 2 | 2 |
| country_name | <chr> | 6500 | 1 | United States | ▇ | 13 | 13.00 | 13 | 13 |
| state_code | <chr> | 1000 | 27 | AA, AE, AK, AL, AP, AR, AS, AZ, CA, CO | ▇ | 2 | 2.00 | 2 | 2 |
| state_name | <chr> | 5862 | 27 | Armed Forces Americas, Armed Forces Europe / Canada / Middle East / Africa, Alaska, Alabama, Armed Forces Pacific, Arkansas, American Samoa, Arizona, California, Colorado | ▁▇▁▁▁▁▁▁▁▁▁ | 4 | 11.72 | 8 | 51 |
| nature_of_payment | <chr> | 20357 | 19 | Acquisitions, Charitable Contribution, Compensation for services other than consulting, including serving as faculty or as a speaker at a venue other than a continuing education program, Compensation for serving as faculty or as a speaker for a medical education program, Compensation for serving as faculty or as a speaker for an accredited or certified continuing education program, Compensation for serving as faculty or as a speaker for a non-accredited and noncertified continuing education program, Consulting Fee, Current or prospective ownership or investment interest, Debt forgiveness, Education | ▇▁▁▁▁▁▁▁ | 4 | 40.71 | 18 | 146 |
| recipient_type | <chr> | 13500 | 1 | Covered Recipient Physician | ▇ | 27 | 27.00 | 27 | 27 |
| program_year | <chr> | 1500 | 1 | ALL | ▇ | 3 | 3.00 | 3 | 3 |
| total_number_of_physicians | <chr> | 1190 | 279 | 0, 1, 3, 2, 5, 15, 21, 32, 6, 26 | ▇▅▁▅▁▃▁▁▁▁ | 1 | 2.38 | 2 | 6 |
| total_number_of_non_physician_practitioners | <chr> | 500 | 1 | 0 | ▇ | 1 | 1.00 | 1 | 1 |
| total_number_of_teaching_hospitals | <chr> | 500 | 1 | 0 | ▇ | 1 | 1.00 | 1 | 1 |
| total_payment_amount_physician | <chr> | 4189 | 397 | 0.00, 12500.00, 2654.88, 421.00, 22378.57, 13519.70, 103808.30, 25853.05, 158.58, 61641.18 | ▇▁▁▃▇▇▅▁ | 4 | 8.38 | 9 | 12 |
| total_payment_amount_non_physician_practitioner | <chr> | 2000 | 1 | 0.00 | ▇ | 4 | 4.00 | 4 | 4 |
| total_payment_amount_teaching_hospital | <chr> | 2000 | 1 | 0.00 | ▇ | 4 | 4.00 | 4 | 4 |
| mean_total_payment_amount_physician | <chr> | 3320 | 397 | 0.00, 12500.00, 106.20, 421.00, 5594.64, 6759.85, 11534.26, 601.23, 52.86, 197.57 | ▅▁▁▅▁▇▁▇▁▂▁▁▁▁ | 4 | 6.64 | 7 | 11 |
| mean_total_payment_amount_non_physician_practitioner | <chr> | 2000 | 1 | 0.00 | ▇ | 4 | 4.00 | 4 | 4 |
| mean_total_payment_amount_teaching_hospital | <chr> | 2000 | 1 | 0.00 | ▇ | 4 | 4.00 | 4 | 4 |
| median_total_payment_amount_physician | <chr> | 3015 | 293 | 0.00, 90.00, 3000.00, 2000.00, 3500.00, 95.00, 1500.00, 2500.00, 5500.00, 99.00 | ▃▃▁▃▁▇▁▂▁▁▁▁ | 4 | 6.03 | 6 | 10 |
| median_total_payment_amount_non_physician_practitioner | <chr> | 2000 | 1 | 0.00 | ▇ | 4 | 4.00 | 4 | 4 |
| median_total_payment_amount_teaching_hospital | <chr> | 2000 | 1 | 0.00 | ▇ | 4 | 4.00 | 4 | 4 |
| total_payment_count_physician | <chr> | 1432 | 332 | 0, 1, 2, 19, 5, 3, 22, 28, 51, 93 | ▇▅▁▇▁▅▁▃▁▁▁▁ | 1 | 2.86 | 3 | 7 |
| total_payment_count_non_physician_practitioner | <chr> | 500 | 1 | 0 | ▇ | 1 | 1.00 | 1 | 1 |
| total_payment_count_teaching_hospital | <chr> | 500 | 1 | 0 | ▇ | 1 | 1.00 | 1 | 1 |
| mean_total_payment_count_physician | <chr> | 594 | 41 | 0, 1, 2, 3, 4, 5, 6, 10, 11, 7 | ▇▁▁▁▁▁▁▁▁▂ | 1 | 1.19 | 1 | 2 |
| mean_total_payment_count_non_physician_practitioner | <chr> | 500 | 1 | 0 | ▇ | 1 | 1.00 | 1 | 1 |
| mean_total_payment_count_teaching_hospital | <chr> | 500 | 1 | 0 | ▇ | 1 | 1.00 | 1 | 1 |
| median_total_payment_count_physician | <chr> | 517 | 18 | 1, 2, 0, 4, 3, 5, 8, 6, 14, 7 | ▇▁▁▁▁▁▁▁▁▁ | 1 | 1.03 | 1 | 2 |
| median_total_payment_count_non_physician_practitioner | <chr> | 500 | 1 | 0 | ▇ | 1 | 1.00 | 1 | 1 |
| median_total_payment_count_teaching_hospital | <chr> | 500 | 1 | 0 | ▇ | 1 | 1.00 | 1 | 1 |
Group Summaries
| column | type | n | uniq | top | distribution | min | mean | med | max |
|---|---|---|---|---|---|---|---|---|---|
| number_of_transaction | <int> | 10524 | 96 | 1, 2, 3, 4, 5, 8, 6, 12, 10, 11 | ▇▁▁▁▁▁ | 1.00 | 21.05 | 5 | 284 |
| total_amount | <dbl> | 2781459 | 489 | 99.99, 79.99, 750, 99, 28.92, 17.84, 330.01, 600, 6.65, 3000 | ▇▁▁▁▁▁▁ | 6.65 | 5562.92 | 373 | 348186 |
| recipient_id | <chr> | 1429 | 349 | 160, 295, 513, 529, 533, 136, 481, 81, 198, 359 | ▁▁▁▁▁▁▁▁▁▇ | 1.00 | 2.86 | 3 | 3 |
| recipient_type | <chr> | 13517 | 2 | Covered Recipient Physician, Covered Recipient Non-Physician Practitioner | ▇▁▁▁▁▁▁▁▁ | 27.00 | 27.03 | 27 | 44 |
| covered_recipient_npi | <chr> | 5000 | 349 | 1003836602, 1003891458, 1013029719, 1013055813, 1013059781, 1003809989, 1013007061, 1003132887, 1003832809, 1003901133 | ▇ | 10.00 | 10.00 | 10 | 10 |
| covered_recipient_profile_first_name | <chr> | 3015 | 243 | DAVID, JOHN, JOSEPH, RICHARD, EDWARD, STEVEN, PAUL, MICHAEL, ANDREW, ROBERT | ▃▃▇▅▂▁▁▁▁▁ | 3.00 | 6.03 | 6 | 13 |
| covered_recipient_profile_middle_name | <chr> | 804 | 77 | S, M, K, A, L, E, J, C, P, W | ▇▁▁▁▁▁▁▁▁ | 1.00 | 2.29 | 1 | 17 |
| covered_recipient_profile_last_name | <chr> | 3252 | 334 | RASTOGI, RAFEYAN, KIM, WHITE, HOFFMAN, KADING, SANTILLAN-GOMEZ, TANNER, SARWAR, GUPTA | ▂▇▅▁▁▁▁▁ | 2.00 | 6.50 | 6 | 17 |
| nature_of_payment_type_code | <chr> | 507 | 11 | 6, 8, 7, 1, 2, 4, 3, 10, 16, 5 | ▇▁▁▁▁▁▁▁▁▁ | 1.00 | 1.01 | 1 | 2 |
| column | type | n | uniq | top | distribution | min | mean | med | max |
|---|---|---|---|---|---|---|---|---|---|
| number_of_transaction | <int> | 2331 | 32 | 1, 2, 3, 4, 5, 7, 8, 6, 10, 14 | ▇▁▁▁▁▁▁▁▁▁▁▁▁ | 1.00 | 4.66 | 2.0 | 129 |
| total_amount | <dbl> | 657458 | 485 | 32.52, 88.53, 39.62, 16.52, 16.48, 135.32, 20.94, 37.58, 24.73, 50.51 | ▇▁▁▁▁▁▁▁ | 4.44 | 1314.92 | 45.4 | 153010 |
| recipient_id | <chr> | 1319 | 120 | 136, 201, 174, 58, 40, 110, 171, 24, 255, 18 | ▁▁▁▁▃▁▁▁▁▇ | 1.00 | 2.64 | 3.0 | 3 |
| recipient_type | <chr> | 13534 | 2 | Covered Recipient Physician, Covered Recipient Non-Physician Practitioner | ▇▁▁▁▁▁▁▁▁ | 27.00 | 27.07 | 27.0 | 44 |
| covered_recipient_npi | <chr> | 5000 | 120 | 1003809989, 1003857269, 1003819525, 1003070004, 1003042342, 1003801895, 1003818816, 1003014762, 1003859661, 1003009861 | ▇ | 10.00 | 10.00 | 10.0 | 10 |
| covered_recipient_profile_first_name | <chr> | 3068 | 94 | NIGHAT, JOSEPH, RITA, BARBARA, JOHN, MUKESHKUMAR, MOSTAFA, MARK, STUART, JOSHUA | ▃▃▇▃▁▁▁▁ | 3.00 | 6.14 | 6.0 | 11 |
| covered_recipient_profile_middle_name | <chr> | 869 | 40 | S, P, M, A, E, H, DEVSHIBHAI, B, K, C | ▇▁▁▁▁▁▁▁▁ | 1.00 | 2.71 | 1.0 | 10 |
| covered_recipient_profile_last_name | <chr> | 3108 | 120 | SARWAR, GUPTA, BENNETT, DELVADIYA, TABASSOMI, CRICK, SHAFER, WHARTON, DOAN, BANNA | ▁▇▃▁▁▁▁▁ | 2.00 | 6.22 | 6.0 | 17 |
| payment_type | <chr> | 3500 | 1 | General | ▇ | 7.00 | 7.00 | 7.0 | 7 |
| amgpo_name | <chr> | 11750 | 192 | AbbVie Inc., AstraZeneca Pharmaceuticals LP, Amgen Inc., Abbott Laboratories, NOVARTIS PHARMACEUTICALS CORPORATION, GlaxoSmithKline, LLC., Pfizer Inc., Lilly USA, LLC, Merck Sharp & Dohme LLC, Boehringer Ingelheim Pharmaceuticals, Inc. | ▁▇▇▅▇▂▂▁▁▁▁ | 7.00 | 23.50 | 22.0 | 59 |
| amgpo_id | <chr> | 6000 | 192 | 100000000204, 100000000146, 100000000203, 100000010680, 100000000228, 100000005449, 100000000286, 100000000066, 100000000053, 100000000234 | ▇ | 12.00 | 12.00 | 12.0 | 12 |
| column | type | n | uniq | top | distribution | min | mean | med | max |
|---|---|---|---|---|---|---|---|---|---|
| number_of_transaction | <int> | 5626318 | 281 | 1, 3, 2, 5, 4, 7, 11, 8, 6, 10 | ▇▁▁▁▁▁▁▁▁ | 1.0 | 11252.64 | 55 | 1684837 |
| nature_of_payment_type_code | <fct> | 4356 | 16 | 6, 1, 7, 2, 8, 14, 15, 10, 3, 4 | ▅▃▁▁▃▁▇▂ | 1.0 | 8.71 | 9 | 16 |
| total_amount | <dbl> | 883473734 | 492 | 2000, 20000, 2500, 7000, 1500, 60000, 7500, 5962881.84, 5625450.39, 4961797.99 | ▇▁▁▁▁▁▁▁▁▁▁ | 6.9 | 1766947.47 | 109066 | 109229530 |
| amgpo_id | <chr> | 6000 | 91 | 100000000106, 100000000103, 100000000146, 100000000198, 100000000204, 100000000076, 100000000102, 100000000135, 100000000185, 100000000069 | ▇ | 12.0 | 12.00 | 12 | 12 |
| amgpo_name | <chr> | 11534 | 91 | MEDTRONIC, INC., ZIMMER BIOMET HOLDINGS, INC., ASTRAZENECA PHARMACEUTICALS LP, PHILIPS ELECTRONICS NORTH AMERICA CORPORATION, ABBVIE INC., SANOFI-AVENTIS U.S. LLC, GLAUKOS CORPORATION, PACIRA PHARMACEUTICALS INCORPORATED, DENTSPLY SIRONA INC, REGENERON PHARMACEUTICALS, INC. | ▂▇▇▇▇▅▁▂ | 8.0 | 23.07 | 23 | 45 |
| column | n | uniq | top | distribution | min | mean | med | max |
|---|---|---|---|---|---|---|---|---|
| number_of_transaction | 1157 | 13 | 1, 2, 3, 4, 5, 10, 7, 6, 9, 8 | ▇▁▁▁▁▁▁▁▁▁▁▁▁ | 1.0 | 2.31 | 1.0 | 14 |
| nature_of_payment_type_code | 1012 | 4 | 6, 8, 1, 7 | ▁▇▁▁▁▁ | 1.0 | 2.02 | 2.0 | 4 |
| total_amount | 53569 | 457 | 19.81, 35.07, 20.06, 14.21, 13.06, 21.36, 15.66, 16.62, 49.55, 60.57 | ▇▁▁▁▁▁▁▁▁▁▁ | 10.8 | 107.14 | 29.8 | 10169 |
| amgpo_id | 6000 | 1 | 100000000053 | ▇ | 12.0 | 12.00 | 12.0 | 12 |
| recipient_id | 3397 | 492 | 1010770, 1001879, 1002923, 1003523, 100380, 1005961, 1008993, 1000030, 1000078, 1000131 | ▁▁▁▃▁▇▁▂ | 4.0 | 6.79 | 7.0 | 8 |
| recipient_type | 505 | 2 | 1, 10 | ▇▁▁▁▁▁▁▁▁▁ | 1.0 | 1.01 | 1.0 | 2 |
| recipient_name | 7813 | 492 | DAVID ROSMARIN, ROBERT T HUSFIELD, NICHOLAS R FOX, ANUPAMA SAIGAL, MOHAMMED FAISAL ALI, DAVID BING ZHEN, DAPHNE T HSU, RICHARD D FRANK, CARLOS M TEJEDA, LAUREN L MURRILL | ▁▁▃▇▇▅▂▂▁▁▁ | 6.0 | 15.63 | 15.0 | 28 |
| amgpo_name | 11500 | 1 | MERCK SHARP & DOHME LLC | ▇ | 23.0 | 23.00 | 23.0 | 23 |
Detailed Payment Data
• Rows [14.6M] • Pages [29k] • Fields [91] • Years [2017 - 2023]
| column | type | n | uniq | top | distribution | min | mean | med | max |
|---|---|---|---|---|---|---|---|---|---|
| number_of_payments_included_in_total_amount | <int> | 504 | 2 | 1, 3 | ▇▁▁▁▁▁▁▁▁▁ | 1.0 | 1.01 | 1.0 | 3 |
| total_amount_of_payment_usdollars | <dbl> | 341983 | 336 | 192.37, 62.5, 5000, 18.79, 18.37, 750, 21.04, 18.57, 33.08, 19.25 | ▇▁▁▁▁▁▁▁▁ | 2.5 | 683.97 | 21.3 | 40188 |
| change_type | <chr> | 4358 | 2 | UNCHANGED, CHANGED | ▁▁▁▁▁▁▁▁▁▇ | 7.0 | 8.72 | 9.0 | 9 |
| covered_recipient_type | <chr> | 14649 | 3 | Covered Recipient Physician, Covered Recipient Non-Physician Practitioner, Covered Recipient Teaching Hospital | ▇▁▁▁▁▁▁▁▁ | 27.0 | 29.30 | 27.0 | 44 |
| teaching_hospital_ccn | <chr> | 84 | 1 | 220162 | ▇ | 6.0 | 6.00 | 6.0 | 6 |
| teaching_hospital_id | <chr> | 56 | 1 | 9984 | ▇ | 4.0 | 4.00 | 4.0 | 4 |
| teaching_hospital_name | <chr> | 388 | 8 | Uc Davis Medical Center, St. Josephs Hospital & Medical Ctr, REGENTS OF THE UNIVERSITY OF MICHIGAN, UNIVERSITY OF WASHINGTON, Adventhealth Orlando, Carle Foundation Hospital, University Of Virginia Medical Cente, CARLE FOUNDATION HOSPITAL | ▁▇▂▁▁▁▂▁▂ | 20.0 | 27.71 | 24.5 | 37 |
| covered_recipient_profile_id | <chr> | 3074 | 334 | 261208, 23095, 272108, 10758798, 139518, 106575, 2785577, 125618, 3861, 10489506 | ▁▂▁▇▁▃▁▂ | 4.0 | 6.33 | 6.0 | 8 |
| covered_recipient_npi | <chr> | 4840 | 333 | 1740453620, 1508857491, 1992913685, 1316577737, 1063430023, 1346417086, 1235557166, 1760521579, 1083872410, 1801254149 | ▇ | 10.0 | 10.00 | 10.0 | 10 |
| covered_recipient_first_name | <chr> | 2993 | 260 | ELIZABETH, FARRELL, EDWARD, MICHAEL, DAVID, MATTHEW, JENNIFER, NICOLE, ANGELA, JACEY | ▁▁▃▇▇▇▂▂▁▁▁▁ | 1.0 | 6.16 | 6.0 | 13 |
| covered_recipient_middle_name | <chr> | 765 | 77 | CLIFTON, H, M, A, J, P, L, ELIZABETH, R, C | ▇▁▁▁▁▂▁▁▁▁ | 1.0 | 2.93 | 1.0 | 11 |
| covered_recipient_last_name | <chr> | 3068 | 319 | YEU-LIN, TYSON, HU, BYERS, SINGH, MILLER, BAUER, PADILLA, MARNIK SCALICI, MVUNDURA | ▃▇▅▂▁▁▁▁ | 2.0 | 6.31 | 6.0 | 18 |
| covered_recipient_name_suffix | <chr> | 60 | 4 | II, SR., JR., JR | ▇▁▁▁▁▁▁▁▁▁ | 2.0 | 2.07 | 2.0 | 3 |
| recipient_primary_business_street_address_line1 | <chr> | 9166 | 303 | 241 CORPORATE BLVD, 4120 DEL PRADO BLVD S, 1195 BOYSON RD STE 200, 1000 S SCHEUBER RD, 700 HAWES CT APT C, 2927 LYNDHURST AVE, 3805B SPRING ST, 662 YANKAKEE DR, 11571 VERANDAH BLVD, 68 S SERVICE RD | ▁▅▅▇▃▃▂▁▁▁▁▁▁ | 10.0 | 18.33 | 18.0 | 36 |
| recipient_primary_business_street_address_line2 | <chr> | 1582 | 89 | STE. 210, SUITE 140, SUITE 110, PMG SW WA CENTRALIA WOMEN CENTER, SUITE 100, SUITE 350, STE 101, STE A, SUITE 300, SUITE A | ▁▇▁▁▁▁▁ | 2.0 | 9.25 | 8.0 | 32 |
| recipient_city | <chr> | 4331 | 216 | NORFOLK, CAPE CORAL, NEW YORK, HIAWATHA, RALEIGH, CENTRALIA, LOS ANGELES, HOUSTON, WINSTON SALEM, CHICAGO | ▂▅▇▇▅▅▃▁▂▁▁▁▁ | 4.0 | 8.66 | 8.0 | 17 |
| recipient_state | <chr> | 1000 | 33 | FL, CA, TX, NC, NY, NJ, VA, IL, PA, WA | ▇ | 2.0 | 2.00 | 2.0 | 2 |
| recipient_zip_code | <chr> | 3520 | 277 | 23502, 33904-7165, 52233-2218, 98531-8877, 27103, 27608-1745, 17033-2360, 53405-1641, 60453, 33021 | ▇▁▁▁▁▁▁▁▁▅ | 5.0 | 7.04 | 5.0 | 10 |
| recipient_country | <chr> | 6500 | 1 | United States | ▇ | 13.0 | 13.00 | 13.0 | 13 |
| covered_recipient_primary_type_1 | <chr> | 7908 | 9 | Medical Doctor, Doctor of Optometry, Physician Assistant, Doctor of Osteopathy, Nurse Practitioner, Certified Registered Nurse Anesthetist, Certified Nurse-Midwife, Chiropractor, Doctor of Dentistry | ▇▁▁▂▁▁▁▁▁▁▁▁▁ | 12.0 | 16.27 | 14.0 | 38 |
| covered_recipient_specialty_1 | <chr> | 27557 | 36 | Allopathic & Osteopathic Physicians|Ophthalmology, Eye and Vision Services Providers|Optometrist, Allopathic & Osteopathic Physicians|Obstetrics & Gynecology, Physician Assistants & Advanced Practice Nursing Providers|Physician Assistant, Allopathic & Osteopathic Physicians|Urology, Physician Assistants & Advanced Practice Nursing Providers|Nurse Anesthetist, Certified Registered, Allopathic & Osteopathic Physicians|Obstetrics & Gynecology|Obstetrics, Allopathic & Osteopathic Physicians|Internal Medicine, Physician Assistants & Advanced Practice Nursing Providers|Nurse Practitioner|Family, Allopathic & Osteopathic Physicians|Pathology|Blood Banking & Transfusion Medicine | ▁▇▂▁▁▁▁▁ | 35.0 | 56.70 | 49.0 | 109 |
| covered_recipient_license_state_code1 | <chr> | 972 | 32 | FL, CA, TX, NC, NJ, VA, IL, NY, PA, DE | ▇ | 2.0 | 2.00 | 2.0 | 2 |
| covered_recipient_license_state_code2 | <chr> | 146 | 15 | PA, VA, IA, FL, NY, SC, CA, TX, WI, DE | ▇ | 2.0 | 2.00 | 2.0 | 2 |
| covered_recipient_license_state_code3 | <chr> | 82 | 11 | IA, NC, NV, VA, NY, FL, WI, DE, OH, MI | ▇ | 2.0 | 2.00 | 2.0 | 2 |
| covered_recipient_license_state_code4 | <chr> | 26 | 1 | IA | ▇ | 2.0 | 2.00 | 2.0 | 2 |
| covered_recipient_license_state_code5 | <chr> | 26 | 2 | DE, IA | ▇ | 2.0 | 2.00 | 2.0 | 2 |
| submitting_applicable_manufacturer_or_applicable_gpo_name | <chr> | 15292 | 13 | Carl Zeiss Meditec Cataract Technology Inc., EYEVANCE PHARMACEUTICALS LLC, Mission Pharmacal Company, Minerva Surgical, Inc, VisionCare Inc., Evofem Biosciences, Inc., Integra LifeSciences Corporation, Allergan, Inc., Eyevance Pharmaceuticals LLC, Boston Scientific Corporation | ▂▁▇▇▁▁▇ | 14.0 | 30.58 | 28.0 | 43 |
| applicable_manufacturer_or_applicable_gpo_making_payment_id | <chr> | 6000 | 12 | 100000501822, 100000501814, 100000000186, 100000151631, 100000010857, 100000781819, 100000010950, 100000000278, 100000005674, 100000826853 | ▇ | 12.0 | 12.00 | 12.0 | 12 |
| applicable_manufacturer_or_applicable_gpo_making_payment_name | <chr> | 15292 | 13 | Carl Zeiss Meditec Cataract Technology Inc., Eyevance Pharmaceuticals LLC, MISSION PHARMACAL COMPANY, Minerva Surgical, Inc, VisionCare Inc., Evofem Biosciences, Inc., Integra LifeSciences Corporation, Mission Pharmacal Company, Allergan, Inc., Boston Scientific Corporation | ▂▁▇▇▁▁▇ | 14.0 | 30.58 | 28.0 | 43 |
| applicable_manufacturer_or_applicable_gpo_making_payment_state | <chr> | 992 | 7 | TX, NV, CA, NJ, MA, NC, MI | ▇ | 2.0 | 2.00 | 2.0 | 2 |
| applicable_manufacturer_or_applicable_gpo_making_payment_country | <chr> | 6472 | 2 | United States, Canada | ▁▁▁▁▁▁▁▁▁▁▁▁▁▇ | 6.0 | 12.94 | 13.0 | 13 |
| date_of_payment | <chr> | 5000 | 184 | 11/13/2023, 02/01/2023, 01/17/2023, 02/07/2023, 03/01/2023, 12/19/2023, 01/30/2023, 01/26/2023, 12/07/2023, 02/16/2023 | ▇ | 10.0 | 10.00 | 10.0 | 10 |
| form_of_payment_or_transfer_of_value | <chr> | 12823 | 2 | In-kind items and services, Cash or cash equivalent | ▁▁▁▁▁▇ | 23.0 | 25.65 | 26.0 | 26 |
| nature_of_payment_or_transfer_of_value | <chr> | 8898 | 7 | Food and Beverage, Consulting Fee, Grant, Royalty or License, Compensation for services other than consulting, including serving as faculty or as a speaker at a venue other than a continuing education program, Honoraria, Education | ▇▁▁▁▁▁▁▁ | 5.0 | 17.80 | 17.0 | 146 |
| physician_ownership_indicator | <chr> | 868 | 1 | No | ▇ | 2.0 | 2.00 | 2.0 | 2 |
| third_party_payment_recipient_indicator | <chr> | 10568 | 2 | No Third Party Payment, Entity | ▁▁▁▁▁▁▁▇ | 6.0 | 21.14 | 22.0 | 22 |
| name_of_third_party_entity_receiving_payment_or_transfer_of_ccfc | <chr> | 566 | 3 | Jackson Reagan, LLC, Argus Research Center Inc, Jackson Reagan LLC | ▁▇▁▁▁▁▁▁▁▁▁▁▁▃ | 18.0 | 20.96 | 19.0 | 25 |
| charity_indicator | <chr> | 8 | 1 | No | ▇ | 2.0 | 2.00 | 2.0 | 2 |
| third_party_equals_covered_recipient_indicator | <chr> | 54 | 1 | No | ▇ | 2.0 | 2.00 | 2.0 | 2 |
| contextual_information | <chr> | 32697 | 87 | Carl Zeiss Meditec Cataract Technology provides modest meals during the course of business. Recipients may be attending or presenting at an educational presentation, a product training session or being invited for a meal to provide feedback on our products., Food and Beverages provided at the Zeiss Cataract Event held on 11132023 in New York NY., Carl Zeiss Meditec Cataract Technology provides modest meals during the course of business. Recipients may be attending or presenting at an educational presentation, a product training session on or being invited for a meal to provide feedback on our products., Carl Zeiss Meditec Cataract Technology has contractual agreements with physicians to consult, validate or participate in research activities. This record represents payment for June 2023 services., Carl Zeiss Meditec Cataract Technology provides modest meals during the course of business. This record represents food and beverage provided during an onsite product training session on 02012023., Carl Zeiss Meditec Cataract Technology provides modest meals during the course of business. This record represents food and beverage provided during an onsite product training session on 05242023., Carl Zeiss Meditec Cataract Technology provides modest meals during the course of business. This record represents food and beverage provided during an onsite product training session on 02092023., Carl Zeiss Meditec Cataract Technology provides modest meals during the course of business. This record represents food and beverage provided during an onsite product training session on 08172023., Carl Zeiss Meditec Cataract Technology provides modest meals during the course of business. This record represents food and beverage provided during an onsite product training session on 04122023., Carl Zeiss Meditec Cataract Technology provides modest meals during the course of business. This record represents a business dinner held on 05072023 in San Diego CA. | ▁▁▁▇▂▃▁ | 32.0 | 204.36 | 197.0 | 347 |
| delay_in_publication_indicator | <chr> | 1000 | 1 | No | ▇ | 2.0 | 2.00 | 2.0 | 2 |
| record_id | <chr> | 4514 | - | - | ▇▁▁▁▁▁▁▁▁▁ | 9.0 | 9.03 | 9.0 | 10 |
| dispute_status_for_publication | <chr> | 1000 | 1 | No | ▇ | 2.0 | 2.00 | 2.0 | 2 |
| related_product_indicator | <chr> | 1490 | 2 | Yes, No | ▁▁▁▁▁▁▁▁▁▇ | 2.0 | 2.98 | 3.0 | 3 |
| covered_or_noncovered_indicator_1 | <chr> | 4406 | 2 | Covered, Non-Covered | ▇▁▁▁▁▁▁▇ | 7.0 | 8.99 | 7.0 | 11 |
| indicate_drug_or_biological_or_device_or_medical_supply_1 | <chr> | 2446 | 2 | Drug, Device | ▇▁▁▁▁▁▁▁▁▇ | 4.0 | 4.99 | 4.0 | 6 |
| product_category_or_therapeutic_area_1 | <chr> | 6020 | 14 | OPHTHALMIC, Ablation System, ANALGESIC ANTISPASMODIC & ANTISEPTIC (URINARY), PRENATAL VITAMIN & MINERAL, Ophthalmology, Miscellaneous vaginal agent, Neuro Critical Care, General - Pelvic Organ Prolapse_URO, HEMATINIC, Urological | ▇▃▁▁▂▁▁▁▂ | 9.0 | 18.02 | 13.0 | 46 |
| name_of_drug_or_biological_or_device_or_medical_supply_1 | <chr> | 3567 | 15 | Flarex, URIBEL, CITRANATAL, Implantable Miniature Telescope (IMT by Dr. Isaac Lipshitz), TobraDex ST, Phexxi, CODMAN CERTAS, Zerviate, FERRALET 90, Lithostat | ▁▇▁▁▁▁▁▁▁▁▁▁ | 4.0 | 12.52 | 6.0 | 59 |
| associated_drug_or_biological_ndc_1 | <chr> | 2964 | 10 | 71776-100-05, 0178-0740-01, 0178-0866-30, 71776-035-05, 69751-100-12, 0178-0500-01, 71776-024-30, 0178-0089-90, 71376-201-03, 0178-0480-08 | ▇ | 12.0 | 12.00 | 12.0 | 12 |
| associated_device_or_medical_supply_pdi_1 | <chr> | 518 | 3 | M687PR00020000, 10381780529033, 10381780071136 | ▇ | 14.0 | 14.00 | 14.0 | 14 |
| covered_or_noncovered_indicator_2 | <chr> | 513 | 2 | Non-Covered, Covered | ▁▁▁▁▁▁▁▇ | 7.0 | 10.91 | 11.0 | 11 |
| indicate_drug_or_biological_or_device_or_medical_supply_2 | <chr> | 282 | 1 | Device | ▇ | 6.0 | 6.00 | 6.0 | 6 |
| product_category_or_therapeutic_area_2 | <chr> | 1684 | 2 | hysteroscopic thermal ablation device, Neuro Critical Care | ▁▁▁▁▁▁▁▁▁▇ | 19.0 | 36.61 | 37.0 | 37 |
| name_of_drug_or_biological_or_device_or_medical_supply_2 | <chr> | 12 | 1 | CUSA CLARITY | ▇ | 12.0 | 12.00 | 12.0 | 12 |
| associated_device_or_medical_supply_pdi_2 | <chr> | 14 | 1 | 10381780126232 | ▇ | 14.0 | 14.00 | 14.0 | 14 |
| covered_or_noncovered_indicator_3 | <chr> | 495 | 1 | Non-Covered | ▇ | 11.0 | 11.00 | 11.0 | 11 |
| indicate_drug_or_biological_or_device_or_medical_supply_3 | <chr> | 270 | 1 | Device | ▇ | 6.0 | 6.00 | 6.0 | 6 |
| product_category_or_therapeutic_area_3 | <chr> | 630 | 1 | Tissue Removal | ▇ | 14.0 | 14.00 | 14.0 | 14 |
| covered_or_noncovered_indicator_4 | <chr> | 495 | 1 | Non-Covered | ▇ | 11.0 | 11.00 | 11.0 | 11 |
| indicate_drug_or_biological_or_device_or_medical_supply_4 | <chr> | 270 | 1 | Device | ▇ | 6.0 | 6.00 | 6.0 | 6 |
| product_category_or_therapeutic_area_4 | <chr> | 1035 | 1 | Tissue Resection Device | ▇ | 23.0 | 23.00 | 23.0 | 23 |
| program_year | <chr> | 2000 | 1 | 2023 | ▇ | 4.0 | 4.00 | 4.0 | 4 |
| payment_publication_date | <chr> | 5000 | 1 | 01/30/2025 | ▇ | 10.0 | 10.00 | 10.0 | 10 |
• Rows [4k] • Pages [9] • Fields [30] • Years [2017 - 2023]
| column | type | n | uniq | top | distribution | min | mean | med | max |
|---|---|---|---|---|---|---|---|---|---|
| total_amount_invested_usdollars | <dbl> | 8074986 | 106 | 0, 8.01, 19439.88, 100000, 270.9, 1832.6, 1832.4, 50000, 400.35, 358 | ▇▁▁▁▁▁▁▁▁▁ | 0 | 16149.97 | 0 | 1000000 |
| value_of_interest | <dbl> | 188653113 | 308 | 1, 73894.61, 19439.88, 25816.06, 50000, 0.01, 0, 78612.01, 73895.26, 25000 | ▇▁▁▁▁▁▁▁▁▁▁ | 0 | 377306.23 | 20451 | 108388240 |
| change_type | <chr> | 4490 | 2 | UNCHANGED, CHANGED | ▁▁▁▁▁▁▁▁▁▇ | 7 | 8.98 | 9 | 9 |
| physician_profile_id | <chr> | 2978 | 494 | 250311, 1113491, 2786363, 122203, 355094, 268984, 329721, 4213213, 170314, 151386 | ▁▁▁▂▁▇▁▂▁▁ | 3 | 5.96 | 6 | 8 |
| physician_npi | <chr> | 5000 | 494 | 1528051018, 1346298916, 1063703270, 1699729244, 1811083553, 1922054998, 1275588246, 1952690257, 1750495099, 1336161561 | ▇ | 10 | 10.00 | 10 | 10 |
| physician_first_name | <chr> | 2907 | 343 | MICHAEL, John, David, William, Robert, Michael, ROBERT, JOHN, MATTHEW, Andrew | ▇▇▇▇▂▁▁▁ | 3 | 5.81 | 6 | 11 |
| physician_middle_name | <chr> | 492 | 94 | J, R, A, D, C, P, E, F, M, S | ▇▁▁▁▁▁▁▁▁▁ | 1 | 3.02 | 1 | 11 |
| physician_last_name | <chr> | 3246 | 480 | Wang, Kim, Brown, Kumar, Patel, Watson, POPEIL, NAYYAR, Cohen, ALBERT | ▂▇▅▂▁▁▁▁ | 2 | 6.49 | 6 | 18 |
| physician_name_suffix | <chr> | 27 | 6 | JR, MD, III, DPM, Jr, II | ▇▁▁▁▁▁▁▁▁▂ | 2 | 2.25 | 2 | 3 |
| recipient_primary_business_street_address_line1 | <chr> | 9358 | 433 | 10901 East 48th Street South, 724 NW 43rd Street, 1901 W. Lugonia Ave. Ste 120, 143 Asheland Avenue, 12109 County Road 103, 5330 North Oak Trafficway, 510 N Elam Ave, 3980 Sheridan Drive, 2439 CARE DR, 25 Crossroads Dr | ▁▂▅▇▇▅▃▂▂▂▁▁▁▁ | 8 | 18.72 | 18 | 35 |
| recipient_primary_business_street_address_line2 | <chr> | 2123 | 143 | Suite 200, Suite 101, Suite 100, Suite 210, Suite 203, SUITE 100, Suite 202, Suite A, SUITE 102, Suite 300 | ▁▇▁▁▁▁▁▁▁▁ | 4 | 9.27 | 9 | 46 |
| recipient_city | <chr> | 4489 | 343 | Gainesville, Tulsa, Dallas, Plano, San Antonio, Greensboro, Asheville, CHARLOTTE, Vero Beach, NEW YORK | ▅▇▇▃▂▁▁▁ | 4 | 8.98 | 9 | 20 |
| recipient_state | <chr> | 1000 | 45 | TX, FL, CA, IL, NC, NJ, NY, MD, CO, AZ | ▇ | 2 | 2.00 | 2 | 2 |
| recipient_zip_code | <chr> | 2950 | 399 | 28801, 74146, 75093, 10021, 32607, 92374, 76012, 07960, 34484, 21117 | ▇▁▁▁▁▁▁▁▁▂ | 5 | 5.90 | 5 | 10 |
| recipient_country | <chr> | 6500 | 1 | United States | ▇ | 13 | 13.00 | 13 | 13 |
| physician_primary_type | <chr> | 7258 | 6 | Medical Doctor, Doctor of Dentistry, Doctor of Osteopathy, Doctor of Podiatric Medicine, Chiropractor, Doctor of Optometry | ▇▁▁▁▁▁▁▁ | 12 | 14.52 | 14 | 28 |
| physician_specialty | <chr> | 30516 | 69 | Allopathic & Osteopathic Physicians|Internal Medicine|Gastroenterology, Allopathic & Osteopathic Physicians|Obstetrics & Gynecology, Allopathic & Osteopathic Physicians|Orthopaedic Surgery, Allopathic & Osteopathic Physicians|Urology, Allopathic & Osteopathic Physicians|Ophthalmology, Allopathic & Osteopathic Physicians|Neurological Surgery, Allopathic & Osteopathic Physicians|Orthopaedic Surgery|Orthopaedic Surgery of the Spine, Allopathic & Osteopathic Physicians|Anesthesiology, Allopathic & Osteopathic Physicians|Emergency Medicine, Allopathic & Osteopathic Physicians|Family Medicine | ▁▁▃▇▃▂▁▁▁▁ | 24 | 61.03 | 59 | 115 |
| record_id | <chr> | 4885 | - | - | ▂▁▁▁▁▁▁▁▁▇ | 9 | 9.77 | 10 | 10 |
| program_year | <chr> | 2000 | 1 | 2023 | ▇ | 4 | 4.00 | 4 | 4 |
| terms_of_interest | <chr> | 55650 | 109 | Common Stock, Physician holds an indirect ownership interest (Interest) in the GPO through his/her in equity interest in Unified Physician Management Holdings, LP (UPM Holdings). UPM Holdings and Unified Women's Healthcare, LP, the operator of the GPO, share a common general partner, Unified Physician Management, GP, LLC. The Interest is not freely transferable, remains subject to repurchase by UPM Holdings and physicians do not receive distributions of any kind related to the GPO., Stock, Membership Interest, Investment, Common Shares, Common and preferred stock, Limited Liability Company Interest, Common/Preferred Stock, ownership interest transferred to HCP as part of terms of acquisition | ▇▁▁▁▁▁▁▁▁▂ | 4 | 111.30 | 19 | 473 |
| submitting_applicable_manufacturer_or_applicable_gpo_name | <chr> | 11089 | 105 | Unified Women's Healthcare, LP, GastroGPO, LLC, SN Holdings, LLC, US Retina LLC, Spinal Simplicity, LLC, BrainScope Company, Inc., Innovation Technologies Inc, Zimmer Biomet Holdings, Inc., Valencia Technologies Corporation, Catalyst OrthoScience | ▁▇▃▃▇▂▁▁▁▁ | 8 | 22.18 | 22 | 52 |
| applicable_manufacturer_or_applicable_gpo_making_payment_id | <chr> | 6000 | 105 | 100000226819, 100000961861, 100000876822, 100000291811, 100000136573, 100000291819, 100000126370, 100000000103, 100001056883, 100000151617 | ▇ | 12 | 12.00 | 12 | 12 |
| applicable_manufacturer_or_applicable_gpo_making_payment_name | <chr> | 11089 | 105 | Unified Women's Healthcare, LP, GastroGPO, LLC, SN Holdings, LLC, US Retina LLC, Spinal Simplicity, LLC, BrainScope Company, Inc., Innovation Technologies Inc, Zimmer Biomet Holdings, Inc., Valencia Technologies Corporation, Catalyst OrthoScience | ▁▇▃▃▇▂▁▁▁▁ | 8 | 22.18 | 22 | 52 |
| applicable_manufacturer_or_applicable_gpo_making_payment_state | <chr> | 990 | 27 | OH, FL, CA, CO, MA, KS, TX, MD, IN, GA | ▇ | 2 | 2.00 | 2 | 2 |
| applicable_manufacturer_or_applicable_gpo_making_payment_country | <chr> | 6466 | 3 | United States, Israel, Ireland | ▁▁▁▁▁▁▁▁▁▁▁▁▁▇ | 6 | 12.93 | 13 | 13 |
| dispute_status_for_publication | <chr> | 1000 | 1 | No | ▇ | 2 | 2.00 | 2 | 2 |
| interest_held_by_physician_or_an_immediate_family_member | <chr> | 13428 | 2 | Physician Covered Recipient, Immediate family member | ▁▁▁▁▁▁▁▇ | 23 | 26.86 | 27 | 27 |
| payment_publication_date | <chr> | 5000 | 1 | 01/30/2025 | ▇ | 10 | 10.00 | 10 | 10 |
• Rows [1M] • Pages [9] • Fields [252] • Years [2017 - 2023]
| column | type | n | uniq | top | distribution | min | mean | med | max |
|---|---|---|---|---|---|---|---|---|---|
| total_amount_of_payment_usdollars | <dbl> | 3948174 | 317 | 2000, 300, 180, 85.24, 1081.08, 400, 116.66, 150, 1125, 3105.26 | ▇▁▁▁▁▁▁▁▁▁ | 5.38 | 7896.35 | 1004 | 500000 |
| change_type | <chr> | 4344 | 2 | UNCHANGED, CHANGED | ▁▁▁▁▁▁▁▁▁▇ | 7.00 | 8.69 | 9 | 9 |
| covered_recipient_type | <chr> | 14269 | 3 | Non-covered Recipient Entity, Covered Recipient Physician, Covered Recipient Teaching Hospital | ▇▁▁▁▁▁▁▁ | 27.00 | 28.54 | 28 | 35 |
| noncovered_recipient_entity_name | <chr> | 7324 | 60 | SARAH CANNON CANCER INSTITUTE AT HDH, AMR, LLC- MOBILE, Urgent Care Clinical Trials Llc, Research Your Health, Cognitive Clinical Trials, Translational Oncology Research Intl, Altus Research, University Of Pennsylvania Department Of Neurology, US ONCOLOGY RESEARCH LLC, J Lewis Research, Inc | ▁▂▃▅▂▃▇▁▂ | 9.00 | 29.41 | 31 | 50 |
| teaching_hospital_ccn | <chr> | 390 | 21 | 500008, 390111, 054144, 200009, 050262, 360137, 230053, 060022, 140150, 240010 | ▇ | 6.00 | 6.00 | 6 | 6 |
| teaching_hospital_id | <chr> | 325 | 21 | 13941, 12957, 14026, 12722, 14065, 13112, 13223, 13362, 13218, 13305 | ▇ | 5.00 | 5.00 | 5 | 5 |
| teaching_hospital_name | <chr> | 1895 | 21 | University Of Washington Med Ctr, Hospital Of The Univ Of Penna, Langley Porter Psychiatric Hospital, Maine Medical Center, Ronald Reagan Ucla, Uh Cleveland Medical Center, Henry Ford Hospital, Memorial Health System, Board Of Trustees Of The University, Mayo Clinic Hospital Rochester | ▁▂▁▁▂▁▅▇▁▃ | 17.00 | 29.15 | 30 | 36 |
| covered_recipient_profile_id | <chr> | 1132 | 44 | 804656, 137580, 321813, 1342407, 529508, 3105300, 359573, 553080, 336754, 247236 | ▁▁▁▇▁▁▁▁ | 4.00 | 6.09 | 6 | 8 |
| covered_recipient_npi | <chr> | 1860 | 44 | 1497881106, 1043226996, 1104853324, 1760614739, 1841227683, 1043502206, 1922218403, 1669621736, 1427214147, 1447249495 | ▇ | 10.00 | 10.00 | 10 | 10 |
| covered_recipient_first_name | <chr> | 1277 | 43 | NAGARAJ-SETTY, JONATHAN, SUZANNE, ZEYNEP, JAMES, LISA, JOSEPH, BHAGYALAKSHMI, PAOLA, ASHOK | ▇▂▂▂▁▁▁▁▂ | 4.00 | 6.87 | 6 | 13 |
| covered_recipient_middle_name | <chr> | 25 | 4 | J, K, S, SARA | ▇▁▁▁▁▁ | 1.00 | 1.32 | 1 | 4 |
| covered_recipient_last_name | <chr> | 1355 | 41 | HOLALKERE, SPERGEL, LENTZSCH, KIM, EROGLU, GUPTA, JONES, MALY, BOGGARAM, MANSILLA LETELIER | ▃▃▂▇▃▃▁▁▁▁▁▁▁▁ | 3.00 | 7.28 | 7 | 17 |
| recipient_primary_business_street_address_line1 | <chr> | 9441 | 123 | 7607 FOREST AVE STE 140, 801 NORTH WEISGARBER RD, 1959 NE PACIFIC ST, 840 HARRISON AVE, 3550 MARKET ST FL 3, 622 W 168TH ST, 6020 W Parker Rd, 3701 Market St, 3400 SPRUCE ST, 50 W Vaughn Ave | ▁▂▇▇▇▃▂▇▁▁▁▁▁▁ | 9.00 | 18.88 | 18 | 35 |
| recipient_primary_business_street_address_line2 | <chr> | 2237 | 30 | SUITE 100, CHILDREN'S HOSPITAL OF PHILADELPHIA - ALLERGY & IMMUN, Ste 305, Ste 201, GROUND FLOOR DULLES, VA CARIBBEAN HEALTHCARE SYSTEM, Ste 100, Ste 211, STE 800, STE 100 | ▇▁▁▁▁▁▁▁▁▁ | 6.00 | 15.11 | 9 | 53 |
| recipient_city | <chr> | 4368 | 91 | PHILADELPHIA, RICHMOND, NEW YORK, KNOXVILLE, SEATTLE, BOSTON, TAMPA, Los Angeles, PLANO, Phila | ▅▅▇▅▃▂▃▁▁▁▁ | 5.00 | 8.74 | 8 | 16 |
| recipient_state | <chr> | 1000 | 30 | PA, TN, VA, FL, TX, CA, NY, MA, WA, IL | ▇ | 2.00 | 2.00 | 2 | 2 |
| recipient_zip_code | <chr> | 3370 | 121 | 23229, 19104, 37909, 98195, 02118-2905, 19104-3365, 10032-3720, 75093, 19104-4206, 85234 | ▇▁▁▁▁▁▁▁▁▃ | 5.00 | 6.74 | 5 | 10 |
| recipient_country | <chr> | 6500 | 1 | United States | ▇ | 13.00 | 13.00 | 13 | 13 |
| covered_recipient_primary_type_1 | <chr> | 2609 | 2 | Medical Doctor, Doctor of Optometry | ▇▁▁▁▁▁▁▁▁▁ | 14.00 | 14.03 | 14 | 19 |
| covered_recipient_specialty_1 | <chr> | 12939 | 18 | Allopathic & Osteopathic Physicians|Radiology|Diagnostic Radiology, Allopathic & Osteopathic Physicians|Internal Medicine|Medical Oncology, Allopathic & Osteopathic Physicians|Internal Medicine|Hematology & Oncology, Allopathic & Osteopathic Physicians|Pediatrics|Pediatric Allergy/Immunology, Allopathic & Osteopathic Physicians|Psychiatry & Neurology|Neurology, Allopathic & Osteopathic Physicians|Internal Medicine|Endocrinology, Diabetes & Metabolism, Allopathic & Osteopathic Physicians|Internal Medicine, Allopathic & Osteopathic Physicians|Dermatology|MOHS-Micrographic Surgery, Allopathic & Osteopathic Physicians|Internal Medicine|Hepatology, Allopathic & Osteopathic Physicians|Radiology|Vascular & Interventional Radiology | ▁▁▁▁▇▃▁▁▁ | 45.00 | 69.56 | 70 | 90 |
| covered_recipient_license_state_code1 | <chr> | 372 | 20 | MA, NJ, NY, CA, TX, IN, FL, SC, PR, AZ | ▇ | 2.00 | 2.00 | 2 | 2 |
| principal_investigator_1_covered_recipient_type | <chr> | 8019 | 1 | Covered Recipient Physician | ▇ | 27.00 | 27.00 | 27 | 27 |
| principal_investigator_1_profile_id | <chr> | 1804 | 89 | 1309787, 1019558, 291623, 358643, 4824526, 232655, 868270, 1123863, 88583, 9369 | ▁▂▁▇▁▃ | 4.00 | 6.07 | 6 | 7 |
| principal_investigator_1_npi | <chr> | 2970 | 89 | 1124024054, 1043400567, 1427074210, 1891799169, 1124415062, 1124131230, 1750316030, 1710074828, 1962408047, 1215134978 | ▇ | 10.00 | 10.00 | 10 | 10 |
| principal_investigator_1_first_name | <chr> | 1744 | 76 | WILLIAM, DAVID, JEFFREY, MONA, ALEXANDER, SAMUEL, EDWARD, MARC, TODD, STEVEN | ▁▇▇▇▇▁▂▁▁ | 2.00 | 5.87 | 6 | 11 |
| principal_investigator_1_middle_name | <chr> | 157 | 6 | B, A., M, LARSON, N., J | ▇▅▁▁▁▁▁▁▁▂ | 1.00 | 2.15 | 1 | 6 |
| principal_investigator_1_last_name | <chr> | 2082 | 87 | SMITH, AL MUKADDAM, SPIGEL, ADELGLASS, GRENINGER, LEDERMAN, HSIAO, MICKIEWICZ, GERSTEN, HARRIS | ▁▂▇▇▃▇▃▁▃▁ | 2.00 | 7.01 | 7 | 12 |
| principal_investigator_1_business_street_address_line1 | <chr> | 5764 | 88 | 2820 CANAL STREET, 3400 CIVIC CENTER BLVD., 250 25TH AVE N, 6020 W PARKER RD, PO BOX 50095, 4671 S Congress Ave Ste 101, 4150 CLEMENT ST # 111N, 4608 INDIANA AVE, 1037 S STATE ROAD 7, 142 MILESTONE WAY | ▂▃▅▇▃▂▃▁▃▁▁▁▁ | 11.00 | 19.41 | 18 | 36 |
| principal_investigator_1_business_street_address_line2 | <chr> | 1597 | 31 | WEST PAVILION, 4TH FLOOR, STE 100, STE 400, SUITE 303, CHILDREN'S HOSPITAL OF PHILADELPHIA - ENDOCRINOLOG, SUITE 200, SUITE 201, STE 206, SUITE 400, MEDICAL ONCOLOGY ASSOCIATES PS. | ▇▁▁▂▁▁▁▁▁ | 7.00 | 15.50 | 9 | 50 |
| principal_investigator_1_city | <chr> | 2782 | 79 | PHILADELPHIA, NASHVILLE, NEW ORLEANS, SEATTLE, PLANO, LAKE WORTH, SAN FRANCISCO, WELLINGTON, GREENVILLE, TAVARES | ▂▂▅▂▇▅▅▃▂▁▁▁ | 4.00 | 9.37 | 9 | 16 |
| principal_investigator_1_state | <chr> | 594 | 28 | FL, TX, TN, LA, PA, CA, WA, OH, MO, SC | ▇ | 2.00 | 2.00 | 2 | 2 |
| principal_investigator_1_zip_code | <chr> | 2705 | 88 | 70119, 19104-5134, 37203-1632, 75093-7900, 98145-5095, 33461, 94121-1545, 37209-2328, 33414-6140, 29615-5065 | ▂▁▁▁▁▁▁▁▁▇ | 5.00 | 9.11 | 10 | 10 |
| principal_investigator_1_country | <chr> | 3861 | 1 | United States | ▇ | 13.00 | 13.00 | 13 | 13 |
| principal_investigator_1_primary_type_1 | <chr> | 4158 | 1 | Medical Doctor | ▇ | 14.00 | 14.00 | 14 | 14 |
| principal_investigator_1_specialty_1 | <chr> | 20327 | 20 | Allopathic & Osteopathic Physicians|Internal Medicine|Medical Oncology, Allopathic & Osteopathic Physicians|Internal Medicine|Hematology & Oncology, Allopathic & Osteopathic Physicians|Internal Medicine, Allopathic & Osteopathic Physicians|Family Medicine, Allopathic & Osteopathic Physicians|Internal Medicine|Endocrinology, Diabetes & Metabolism, Allopathic & Osteopathic Physicians|Obstetrics & Gynecology, Allopathic & Osteopathic Physicians|Psychiatry & Neurology|Neurology, Allopathic & Osteopathic Physicians|Otolaryngology|Otolaryngology/Facial Plastic Surgery, Allopathic & Osteopathic Physicians|Pathology|Clinical Pathology/Laboratory Medicine, Allopathic & Osteopathic Physicians|Internal Medicine|Gastroenterology | ▁▁▇▂▁▇▅▁▁▃ | 43.00 | 68.44 | 70 | 90 |
| principal_investigator_1_license_state_code1 | <chr> | 594 | 33 | FL, TX, LA, CA, TN, PA, WA, OH, SC, AZ | ▇ | 2.00 | 2.00 | 2 | 2 |
| principal_investigator_1_license_state_code2 | <chr> | 184 | 19 | CA, OH, WA, UT, PA, MO, IL, NY, FL, TN | ▇ | 2.00 | 2.00 | 2 | 2 |
| principal_investigator_1_license_state_code3 | <chr> | 74 | 15 | KY, IL, NY, TN, NC, IN, MO, GA, WI, PA | ▇ | 2.00 | 2.00 | 2 | 2 |
| principal_investigator_1_license_state_code4 | <chr> | 32 | 7 | IL, ME, MO, NY, TX, CO, TN | ▇ | 2.00 | 2.00 | 2 | 2 |
| principal_investigator_1_license_state_code5 | <chr> | 14 | 2 | IL, MN | ▇ | 2.00 | 2.00 | 2 | 2 |
| submitting_applicable_manufacturer_or_applicable_gpo_name | <chr> | 11492 | 7 | Regeneron Pharmaceuticals, Inc., Ipsen Bioscience Inc., HOLOGIC INC, Ipsen Innovation, VIVUS LLC, Siemens Medical Solutions USA, Inc., Evofem Biosciences, Inc. | ▁▂▁▂▁▁▇▁▁▁▁▇▁▁ | 9.00 | 22.98 | 21 | 35 |
| applicable_manufacturer_or_applicable_gpo_making_payment_id | <chr> | 6000 | 7 | 100000000069, 100000005526, 100000231815, 100000010514, 100000005620, 100000010755, 100000781819 | ▇ | 12.00 | 12.00 | 12 | 12 |
| applicable_manufacturer_or_applicable_gpo_making_payment_name | <chr> | 11716 | 7 | Regeneron Pharmaceuticals, Inc., Ipsen Bioscience Inc., Gen-Probe, Inc., Ipsen Innovation, VIVUS LLC, Siemens Medical Solutions USA, Inc., Evofem Biosciences, Inc. | ▁▁▁▃▁▁▇▁▁▁▁▇▁▁ | 9.00 | 23.43 | 21 | 35 |
| applicable_manufacturer_or_applicable_gpo_making_payment_state | <chr> | 908 | 4 | MA, NY, CA, PA | ▇ | 2.00 | 2.00 | 2 | 2 |
| applicable_manufacturer_or_applicable_gpo_making_payment_country | <chr> | 6178 | 2 | United States, France | ▁▁▁▁▁▁▁▁▁▁▁▁▁▇ | 6.00 | 12.36 | 13 | 13 |
| related_product_indicator | <chr> | 1423 | 2 | Yes, No | ▁▁▁▁▁▁▁▁▁▇ | 2.00 | 2.85 | 3 | 3 |
| covered_or_noncovered_indicator_1 | <chr> | 3261 | 2 | Covered, Non-Covered | ▇▁▁▁▁▁▁▂ | 7.00 | 7.71 | 7 | 11 |
| indicate_drug_or_biological_or_device_or_medical_supply_1 | <chr> | 2122 | 3 | Drug, Biological, Device | ▇▁▁▂▁▁▁▁▁▁▁▃ | 4.00 | 6.10 | 4 | 10 |
| product_category_or_therapeutic_area_1 | <chr> | 3974 | 11 | Oncology, ONCOLOGY, Diagnostics, Neurology, ENDOCRINOLOGY, INFLAMMATION AND IMMUNOLOGY, RARE DISEASES, MI - Nuclear Medicine (incl. PETNET & MIBR), AT - Fixed interventional x-ray/angiography fluoroscopy, DX - Diagnostics incl. all products and services | ▇▃▁▁▁▁▁▁▁▁ | 8.00 | 11.42 | 8 | 55 |
| name_of_drug_or_biological_or_device_or_medical_supply_1 | <chr> | 2516 | 18 | Onivyde, LIBTAYO, APTIMA, Dysport, QSYMIA, DUPIXENT, VEOPOZ, Artis Q floor, Automated Blood Coagulation Analyzer CS-2500, syngo.via | ▇▁▁▁▁▁▁▁ | 5.00 | 7.23 | 7 | 44 |
| associated_drug_or_biological_ndc_1 | <chr> | 3360 | 8 | 15054-0043-1, 61755-008-01, 15054-0500-1, 62541-202-30, 0024-5914-01, 61755-014-01, 61755-050-01, 61755-005-02 | ▇ | 12.00 | 12.00 | 12 | 12 |
| associated_device_or_medical_supply_pdi_1 | <chr> | 952 | 10 | 15420045500051, 04056869009971, 04987562433735, 04056869033679, 04056869001364, 04056869044798, 04056869046877, 00899475002004, 00899475002592, 00856100006141 | ▇ | 14.00 | 14.00 | 14 | 14 |
| covered_or_noncovered_indicator_2 | <chr> | 143 | 1 | Non-Covered | ▇ | 11.00 | 11.00 | 11 | 11 |
| date_of_payment | <chr> | 5000 | 141 | 02/16/2023, 01/19/2023, 02/24/2023, 11/30/2023, 01/12/2023, 12/08/2023, 12/12/2023, 07/02/2023, 12/01/2023, 12/31/2023 | ▇ | 10.00 | 10.00 | 10 | 10 |
| form_of_payment_or_transfer_of_value | <chr> | 11881 | 2 | Cash or cash equivalent, In-kind items and services | ▇▁▁▁▁▂ | 23.00 | 23.76 | 23 | 26 |
| expenditure_category1 | <chr> | 120 | 1 | Other | ▇ | 5.00 | 5.00 | 5 | 5 |
| preclinical_research_indicator | <chr> | 1002 | 2 | No, Yes | ▇▁▁▁▁▁▁▁▁▁ | 2.00 | 2.00 | 2 | 3 |
| delay_in_publication_indicator | <chr> | 1000 | 1 | No | ▇ | 2.00 | 2.00 | 2 | 2 |
| name_of_study | <chr> | 82600 | 55 | An Open-label, Randomised, Multicentre, Phase III Study of Irinotecan Liposome Injection, Oxaliplatin, 5-fluorouracil/Leucovorin Versus Nab-paclitaxel Plus Gemcitabine in Subjects Who Have Not Previously Received Chemotherapy for Metastatic Adenocarcinoma of the Pancreas, A10940-SC2/FluP-CSP-02, RESILIENT: A Randomized, Open Label Phase 3 Study of Irinotecan Liposome Injection (ONIVYDE) Versus Topotecan in Patients With Small Cell Lung Cancer Who Have Progressed on or After Platinum-based First-Line Therapy, A Phase 2, Two-part, Placebo-controlled, Parallel-group, Double-blind Study to Assess the Efficacy and Safety of 2 Dosage Regimens of Oral IPN60130 for the Treatment of Fibrodysplasia Ossificans Progressiva in Male and Female Participants 5 Years of Age and Older., PHASE 1/2 FIH STUDY OF REGN5458 (ANTI-BCMA X ANTI-CD3 BISPECIFIC ANTIBODY) IN PATIENTS WITH RELAPSED OR REFRACTORY MULTIPLE MYELOMA, LIBTAYO CLINICAL PUBLICATION PROGRAM, Phase III, Randomised, Double-blind, Placebo-controlled, Multicenter, Parallel-group Study with Extension Phase to Evaluate the Efficacy and Safety of Dysport for the Prevention of Chronic Migraine in Adult Participants, A Study of VI-0521 on Ambulatory Blood Pressure in Overweight or Obese Subject, A TWO-PART RANDOMIZED, PHASE 3 STUDY OF COMBINATIONS OF CEMIPLIMAB (ANTI-PD-1 ANTIBODY) AND PLATINUM-BASED DOUBLET CHEMOTHERAPY IN FIRST-LINE TREATMENT OF PATIENTS WITH ADVANCED OR METASTATIC NON-SMALL CELL LUNG CANCER, A Phase III, Randomised, Double-blind, Placebo-controlled, Multicenter, Parallel-group Study With Extension Phase to Evaluate the Efficacy and Safety of Dysport for the Prevention of Episodic Migraine in Adult Participants | ▇▁▂▁▁▃▂▁▁▇▂▁▇ | 22.00 | 165.86 | 198 | 273 |
| dispute_status_for_publication | <chr> | 1000 | 1 | No | ▇ | 2.00 | 2.00 | 2 | 2 |
| record_id | <chr> | 4500 | - | - | ▇ | 9.00 | 9.00 | 9 | 9 |
| program_year | <chr> | 2000 | 1 | 2023 | ▇ | 4.00 | 4.00 | 4 | 4 |
| payment_publication_date | <chr> | 5000 | 1 | 01/30/2025 | ▇ | 10.00 | 10.00 | 10 | 10 |
| clinicaltrials_gov_identifier | <chr> | 4103 | 39 | NCT04083235, NCT03088813, NCT03761108, NCT05039515, NCT06047444, NCT05215418, NCT03409614, NCT06047457, NCT05352672, NCT03888105 | ▇ | 11.00 | 11.00 | 11 | 11 |
| context_of_research | <chr> | 34846 | 11 | The transfer of value captured herein was not a distribution of cash or goods. Instead, this report captures the provision of editorial assistance provided to the authors of the underlying publication. The value of this assistance was divided among the authors of the publication., Panther Fusion SARS-CoV-2/Flu A/B/RSV on Panther Fusion (Nasal and RespDirect), Payment made to RADMD LLC, VIVUS OB-409 Trial, Validate the performance of Hologic ASR for detection of M. genitalium macrolide resistance-associated mutations, Payment made to GI REVIEWERS LLC, Payment made to CANCER THERAPY CONSULTING, Payment made to RHB CONSULTING INC, Aptima SARS-CoV-2 on Panther (Nasal and RespDirect), Mycoplasma genitalium surveillance project | ▂▂▁▃▁▁▁▁▁▁▁▁▁▇ | 18.00 | 158.39 | 95 | 280 |
Querying
format_query_open <- function(args, op = "=") {
args <- discard(args, is.null)
query <- glue(
"
'conditions[{i}][property]' = '{PROPERTY}',
'conditions[{i}][operator]' = '{OPERATOR}',
'conditions[{i}][value]' = '{VALUE}'
",
i = seq_along0(args),
PROPERTY = names(args),
OPERATOR = op,
VALUE = args) |>
glue_collapse(sep = ",\n")
glue("c({query})") |>
parse_expr() |>
eval_bare()
}
create_request_open <- function(id, args) {
id |>
open_uuid_url() |>
request() |>
req_url_query(
!!!format_query_open(args),
schema = "false",
keys = "false",
offset = 0
)
}
query_nresults_open <- function(req) {
req_url_query(
req,
results = "false",
count = "true",
offset = 0,
limit = 1) |>
perform_simple() |>
_[["count"]]
}
perform_request_open <- function(req) {
req_url_query(
req,
results = "true",
count = "false",
offset = 0,
limit = 500) |>
perform_simple()
}
format_query_open(
c(
covered_recipient_npi = 1023630738,
covered_recipient_profile_city = "Valdosta")
) |>
fuimus::print_ls()conditions[0][property] : covered_recipient_npi
conditions[0][operator] : =
conditions[0][value] : 1023630738
conditions[1][property] : covered_recipient_profile_city
conditions[1][operator] : =
conditions[1][value] : ValdostaQuery Format
SQL Format
tictoc::tic()
request("https://openpaymentsdata.cms.gov/api/1/datastore/sql") |>
req_url_query(
query = paste0(
'[SELECT * FROM 08e796b8-7108-561a-8430-bea3bd54e485]',
'[LIMIT 500 OFFSET 0]',
'[WHERE covered_recipient_last_name = "SMITH"]'
),
show_db_columns = "true"
) |>
perform_simple() |>
as_tbl() |>
map_na_if() |>
handle_na()
tictoc::toc()JSON:API Format
ex_url <- url_parse(
base_url = "https://openpaymentsdata.cms.gov/api/1/datastore/",
url = "query/fdc3c773-018a-412c-8a81-d7b8a13a037b/0") |>
url_modify_query(
`conditions[0][property]` = "covered_recipient_npi",
`conditions[0][value]` = "1093709297",
# `conditions[0][property]` = "covered_recipient_last_name",
# `conditions[0][value]` = "SMITH",
`conditions[0][operator]` = "=",
schema = "false",
keys = "true",
# results = "false",
offset = 0,
limit = 500) |>
url_build()
tictoc::tic()
ex_res <- fload(ex_url)
tictoc::toc()
as_tbl(ex_res$results) |>
map_na_if() |>
handle_na() |>
purse()tictoc::tic()
url_parse(
base_url = "https://openpaymentsdata.cms.gov/api/1/datastore/",
url = "query/fdc3c773-018a-412c-8a81-d7b8a13a037b/0") |>
url_modify_query(
# `conditions[0][property]` = "covered_recipient_npi",
# `conditions[0][value]` = "1093709297",
`conditions[0][property]` = "covered_recipient_last_name",
`conditions[0][value]` = "SMITH",
`conditions[0][operator]` = "=",
schema = "false",
keys = "false",
# results = "false",
offset = 0,
limit = 500) |>
url_build() |>
request() |>
perform_simple() |>
_[["count"]]
tictoc::toc()tictoc::tic()
request("https://openpaymentsdata.cms.gov/api/1/datastore/query/fdc3c773-018a-412c-8a81-d7b8a13a037b/0") |>
req_url_query(
`conditions[0][property]` = "covered_recipient_npi",
`conditions[0][value]` = "1093709297",
`conditions[0][operator]` = "=",
schema = "false",
keys = "false",
results = "false",
offset = 0) |>
perform_simple() |>
_[["count"]]
tictoc::toc()tictoc::tic()
url_parse(
base_url = "https://openpaymentsdata.cms.gov/api/1/datastore/",
url = "query/fdc3c773-018a-412c-8a81-d7b8a13a037b/0") |>
url_modify_query(
`conditions[0][property]` = "covered_recipient_first_name",
`conditions[0][value]` = "PATRICK",
`conditions[0][operator]` = "=",
`conditions[1][property]` = "covered_recipient_last_name",
`conditions[1][value]` = "WARD",
`conditions[1][operator]` = "=",
schema = "false",
keys = "true",
offset = 0) |>
url_build() |>
request() |>
perform_simple()
tictoc::toc()
Note 1: JSON Catalog
<list>
├─bureauCode: <list>
│ └─"009:38"
├─programCode: <list>
│ └─"009:000"
├─accessLevel: "public"
├─keyword: <list>
│ └─<list>
│ ├─identifier: "7a69eb60-9b96-52b9-a965-bc355eb1..."
│ └─data: "2017"
├─contactPoint: <list>
│ ├─fn: "Open Payments"
│ └─hasEmail: "mailto:openpayments@cms.hhs.gov"
├─dataQuality: TRUE
├─description: "Research Payment Data – Detailed..."
├─distribution: <list>
│ └─<list>
│ ├─identifier: "08e796b8-7108-561a-8430-bea3bd54..."
│ └─data: <list>
│ ├─title: "Research Payment Data – Detailed..."
│ ├─mediaType: "text/csv"
│ ├─format: "csv"
│ ├─downloadURL: "https://download.cms.gov/openpay..."
│ ├─describedBy: "https://openpaymentsdata.cms.gov..."
│ ├─describedByType: "application/vnd.tableschema+json"
│ └─%Ref:downloadURL: <list>
│ └─<list>
│ ├─identifier: "214bb946b2fd7e119e672f0eec1c9d1f..."
│ └─data: <list>
│ ├─filePath: "https://download.cms.gov/openpay..."
│ ├─identifier: "214bb946b2fd7e119e672f0eec1c9d1f"
│ ├─mimeType: "text/csv"
│ ├─perspective: "source"
│ ├─version: "1737569997"
│ └─checksum: <NULL>
├─identifier: "0e3977b9-a5d6-427e-bc02-480481ed..."
├─title: "2017 Research Payment Data"
├─issued: "2025-01-30"
├─modified: "2025-01-30"
├─temporal: "2017-01-01/2017-12-31"
├─publisher: <list>
│ ├─identifier: "11b41668-9929-5de3-b494-6464ac4f..."
│ └─data: <list>
│ └─name: "openpaymentsdata.cms.gov"
├─license: "https://www.usa.gov/government-w..."
├─theme: <list>
│ └─<list>
│ ├─identifier: "0dbaba68-b7d1-55b3-b5fd-03855791..."
│ └─data: "Research Payments"
├─%modified: "2025-01-22T18:19:56+0000"
├─bureauCode: <list>
│ └─"009:38"
├─programCode: <list>
│ └─"009:000"
├─accessLevel: "public"
├─keyword: <list>
│ └─<list>
│ ├─identifier: "7a69eb60-9b96-52b9-a965-bc355eb1..."
│ └─data: "2017"
├─contactPoint: <list>
│ ├─fn: "Open Payments"
│ └─hasEmail: "mailto:openpayments@cms.hhs.gov"
├─dataQuality: TRUE
├─description: "Ownership Payment Data - Detaile..."
├─distribution: <list>
│ └─<list>
│ ├─identifier: "962363db-b540-525b-8d92-1033285b..."
│ └─data: <list>
│ ├─title: "Ownership Payment Data - Detaile..."
│ ├─mediaType: "text/csv"
│ ├─format: "csv"
│ ├─downloadURL: "https://download.cms.gov/openpay..."
│ ├─describedBy: "https://openpaymentsdata.cms.gov..."
│ ├─describedByType: "application/vnd.tableschema+json"
│ └─%Ref:downloadURL: <list>
│ └─<list>
│ ├─identifier: "13b45d25df440dbc04141694e81c3b4d..."
│ └─data: <list>
│ ├─filePath: "https://download.cms.gov/openpay..."
│ ├─identifier: "13b45d25df440dbc04141694e81c3b4d"
│ ├─mimeType: "text/csv"
│ ├─perspective: "source"
│ ├─version: "1737569997"
│ └─checksum: <NULL>
├─identifier: "f90c33d1-cfd8-4b15-8cf5-b3db2f21..."
├─title: "2017 Ownership Payment Data"
├─issued: "2025-01-30"
├─modified: "2025-01-30"
├─temporal: "2017-01-01/2017-12-31"
├─publisher: <list>
│ ├─identifier: "11b41668-9929-5de3-b494-6464ac4f..."
│ └─data: <list>
│ └─name: "openpaymentsdata.cms.gov"
├─license: "https://www.usa.gov/government-w..."
├─theme: <list>
│ └─<list>
│ ├─identifier: "a5bc58c7-c55e-5a60-b540-4d2ff5cf..."
│ └─data: "Ownership Payments"
├─%modified: "2025-01-22T18:19:56+0000"
├─bureauCode: <list>
│ └─"009:38"
├─programCode: <list>
│ └─"009:000"
├─accessLevel: "public"
├─keyword: <list>
│ └─<list>
│ ├─identifier: "7a69eb60-9b96-52b9-a965-bc355eb1..."
│ └─data: "2017"
├─contactPoint: <list>
│ ├─fn: "Open Payments"
│ └─hasEmail: "mailto:openpayments@cms.hhs.gov"
├─dataQuality: TRUE
├─description: "All general (non-research, non-o..."
├─distribution: <list>
│ └─<list>
│ ├─identifier: "a3462800-1437-539d-a8ea-103fba87..."
│ └─data: <list>
│ ├─title: "General Payment Data – Detailed..."
│ ├─mediaType: "text/csv"
│ ├─format: "csv"
│ ├─downloadURL: "https://download.cms.gov/openpay..."
│ ├─describedBy: "https://openpaymentsdata.cms.gov..."
│ ├─describedByType: "application/vnd.tableschema+json"
│ └─%Ref:downloadURL: <list>
│ └─<list>
│ ├─identifier: "c4615e7eae65dc8dd19f7721d79fa8d5..."
│ └─data: <list>
│ ├─filePath: "https://download.cms.gov/openpay..."
│ ├─identifier: "c4615e7eae65dc8dd19f7721d79fa8d5"
│ ├─mimeType: "text/csv"
│ ├─perspective: "source"
│ ├─version: "1737569997"
│ └─checksum: <NULL>
├─identifier: "74e3a32c-e8f8-595c-899c-35f9bffa..."
├─title: "2017 General Payment Data"
├─issued: "2025-01-30"
├─modified: "2025-01-30"
├─temporal: "2017-01-01/2017-12-31"
├─publisher: <list>
│ ├─identifier: "11b41668-9929-5de3-b494-6464ac4f..."
│ └─data: <list>
│ └─name: "openpaymentsdata.cms.gov"
├─license: "https://www.usa.gov/government-w..."
├─theme: <list>
│ └─<list>
│ ├─identifier: "d2d239e8-05e9-515d-978c-69b34af2..."
│ └─data: "General Payments"
└─%modified: "2025-01-22T18:19:56+0000"