Skip to content

CMS Open Payments

Jump to bottom Edit New page
CourtneyEpstein edited this page Nov 3, 2015 · 2 revisions

CMS Open Payments Data

Information reported by manufactures and group purchasing organizations (GPOs, see here and here) about payments to physicians and teaching hospitals. Useful links:

  1. OP_DTL_OWNRSHP_PGYR2014_P06302015.csv - value of ownership and investment interest of physician in Manu/GPO
  2. OP_DTL_GNRL_PGYR2014_P06302015.csv - general payments
  3. OP_DTL_RSRCH_PGYR2014_P06302015.csv -research payments

OP_DTL_OWNRSHP_PGYR2014_P06302015.csv

Columns

  • Physician_Profile_ID
  • Physician_First_Name
  • Physician_Middle_Name
  • Physician_Last_Name
  • Physician_Name_Suffix
  • Recipient_Primary_Business_Street_Address_Line1
  • Recipient_Primary_Business_Street_Address_Line2
  • Recipient_City
  • Recipient_State
  • Recipient_Zip_Code
  • Recipient_Country
  • Recipient_Province
  • Recipient_Postal_Code
  • Physician_Primary_Type
  • Physician_Specialty
  • Record_ID
  • Program_Year
  • Total_Amount_Invested_USDollars
  • Value_of_Interest
  • Terms_of_Interest
  • Submitting_Applicable_Manufacturer_or_Applicable_GPO_Name
  • Applicable_Manufacturer_or_Applicable_GPO_Making_Payment_ID
  • Applicable_Manufacturer_or_Applicable_GPO_Making_Payment_Name
  • Applicable_Manufacturer_or_Applicable_GPO_Making_Payment_State
  • Applicable_Manufacturer_or_Applicable_GPO_Making_Payment_Country
  • Dispute_Status_for_Publication
  • Interest_Held_by_Physician_or_an_Immediate_Family_Member
  • Payment_Publication_Date

OP_DTL_GNRL_PGYR2014_P06302015.csv

Columns

(color codes: black = looked at, pink = long text field, not looked at)

  • Covered_Recipient_Type

  • Teaching_Hospital_ID

  • Teaching_Hospital_Name

  • Physician_Profile_ID

  • Physician_First_Name

  • Physician_Middle_Name

  • Physician_Last_Name

  • Physician_Name_Suffix

  • Recipient_Primary_Business_Street_Address_Line1

  • Recipient_Primary_Business_Street_Address_Line2

  • Recipient_City

  • Recipient_State

  • Recipient_Zip_Code

  • Recipient_Country: 23 countries

  • Recipient_Province

  • Recipient_Postal_Code

  • Physician_Primary_Type:

  • Chiropractor

  • Doctor of Dentistry

  • Doctor of Optometry

  • Doctor of Osteopathy

  • Doctor of Podiatric Medicine

  • Medical Doctor

  • Physician_Specialty

  • Physician_License_State_code1

  • Physician_License_State_code2

  • Physician_License_State_code3

  • Physician_License_State_code4

  • Physician_License_State_code5

  • Submitting_Applicable_Manufacturer_or_Applicable_GPO_Name

  • Applicable_Manufacturer_or_Applicable_GPO_Making_Payment_ID

  • Applicable_Manufacturer_or_Applicable_GPO_Making_Payment_Name

  • Applicable_Manufacturer_or_Applicable_GPO_Making_Payment_State

  • Applicable_Manufacturer_or_Applicable_GPO_Making_Payment_Country

  • Total_Amount_of_Payment_USDollars

  • Date_of_Payment

  • Number_of_Payments_Included_in_Total_Amount

  • Form_of_Payment_or_Transfer_of_Value

  • Cash or cash equivalent

  • Dividend, profit or other return on investment

  • In-kind items and services

  • Stock, stock option, or any other ownership interest

  • Nature_of_Payment_or_Transfer_of_Value

  • City_of_Travel

  • State_of_Travel

  • Country_of_Travel: 96 countries

  • Physician_Ownership_Indicator

  • Third_Party_Payment_Recipient_Indicator

  • Name_of_Third_Party_Entity_Receiving_Payment_or_Transfer_of_Value

  • Charity_Indicator

  • Third_Party_Equals_Covered_Recipient_Indicator

  • Contextual_Information

  • Delay_in_Publication_Indicator

  • Record_ID

  • Dispute_Status_for_Publication

  • Product_Indicator

  • Name_of_Associated_Covered_Drug_or_Biological1

  • Name_of_Associated_Covered_Drug_or_Biological2

  • Name_of_Associated_Covered_Drug_or_Biological3

  • Name_of_Associated_Covered_Drug_or_Biological4

  • Name_of_Associated_Covered_Drug_or_Biological5

  • NDC_of_Associated_Covered_Drug_or_Biological1

  • NDC_of_Associated_Covered_Drug_or_Biological2

  • NDC_of_Associated_Covered_Drug_or_Biological3

  • NDC_of_Associated_Covered_Drug_or_Biological4

  • NDC_of_Associated_Covered_Drug_or_Biological5

  • Name_of_Associated_Covered_Device_or_Medical_Supply1

  • Name_of_Associated_Covered_Device_or_Medical_Supply2

  • Name_of_Associated_Covered_Device_or_Medical_Supply3

  • Name_of_Associated_Covered_Device_or_Medical_Supply4

  • Name_of_Associated_Covered_Device_or_Medical_Supply5

  • Program_Year: 2014 only

####Suggested Columns:

  • general: Teaching_Hospital_ID, Teaching_Hospital_Name, Physician_Profile_ID, Recipient_Country, Physician_License_State_code1
  • Submitting_Applicable_Manufacturer_or_Applicable_GPO_Name
  • Applicable_Manufacturer_or_Applicable_GPO_Making_Payment_Name
  • Applicable_Manufacturer_or_Applicable_GPO_Making_Payment_Country
  • Total_Amount_of_Payment_USDollars, Date_of_Payment
  • Number_of_Payments_Included_in_Total_Amount
  • Form_of_Payment_or_Transfer_of_Value, Nature_of_Payment_or_Transfer_of_Value

####Categorical Variables:

  • Covered_Recipient_Type
  • Physician_Primary_Type
  • Form_of_Payment_or_Transfer_of_Value
  • Nature_of_Payment_or_Transfer_of_Value
  • Country_of_Travel
  • Physician_Ownership_Indicator
  • Third_Party_Payment_Recipient_Indicator
  • Charity_Indicator
  • Third_Party_Equals_Covered_Recipient_Indicator
  • Delay_in_Publication_Indicator
  • Dispute_Status_for_Publication
  • Product_Indicator

keys: Record_ID, Applicable_Manufacturer_or_Applicable_GPO_Making_Payment_ID

OP_DTL_RSRCH_PGYR2014_P06302015.csv

Columns

  • Covered_Recipient_Type
  • Noncovered_Recipient_Entity_Name
  • Teaching_Hospital_ID
  • Teaching_Hospital_Name
  • Physician_Profile_ID
  • Physician_First_Name
  • Physician_Middle_Name
  • Physician_Last_Name
  • Physician_Name_Suffix
  • Recipient_Primary_Business_Street_Address_Line1
  • Recipient_Primary_Business_Street_Address_Line2
  • Recipient_City
  • Recipient_State
  • Recipient_Zip_Code
  • Recipient_Country
  • Recipient_Province
  • Recipient_Postal_Code
  • Physician_Primary_Type
  • Physician_Specialty
  • Physician_License_State_code1
  • Physician_License_State_code2
  • Physician_License_State_code3
  • Physician_License_State_code4
  • Physician_License_State_code5
  • Principal_Investigator_1_Profile_ID
  • Principal_Investigator_1_First_Name
  • Principal_Investigator_1_Middle_Name
  • Principal_Investigator_1_Last_Name
  • Principal_Investigator_1_Name_Suffix
  • Principal_Investigator_1_Business_Street_Address_Line1
  • Principal_Investigator_1_Business_Street_Address_Line2
  • Principal_Investigator_1_City
  • Principal_Investigator_1_State
  • Principal_Investigator_1_Zip_Code
  • Principal_Investigator_1_Country
  • Principal_Investigator_1_Province
  • Principal_Investigator_1_Postal_Code
  • Principal_Investigator_1_Primary_Type
  • Principal_Investigator_1_Specialty
  • Principal_Investigator_1_License_State_code1
  • Principal_Investigator_1_License_State_code2
  • Principal_Investigator_1_License_State_code3
  • Principal_Investigator_1_License_State_code4
  • Principal_Investigator_1_License_State_code5
  • Principal_Investigator_2_Profile_ID
  • Principal_Investigator_2_First_Name
  • Principal_Investigator_2_Middle_Name
  • Principal_Investigator_2_Last_Name
  • Principal_Investigator_2_Name_Suffix
  • Principal_Investigator_2_Business_Street_Address_Line1
  • Principal_Investigator_2_Business_Street_Address_Line2
  • Principal_Investigator_2_City
  • Principal_Investigator_2_State
  • Principal_Investigator_2_Zip_Code
  • Principal_Investigator_2_Country
  • Principal_Investigator_2_Province
  • Principal_Investigator_2_Postal_Code
  • Principal_Investigator_2_Primary_Type
  • Principal_Investigator_2_Specialty
  • Principal_Investigator_2_License_State_code1
  • Principal_Investigator_2_License_State_code2
  • Principal_Investigator_2_License_State_code3
  • Principal_Investigator_2_License_State_code4
  • Principal_Investigator_2_License_State_code5
  • Principal_Investigator_3_Profile_ID
  • Principal_Investigator_3_First_Name
  • Principal_Investigator_3_Middle_Name
  • Principal_Investigator_3_Last_Name
  • Principal_Investigator_3_Name_Suffix
  • Principal_Investigator_3_Business_Street_Address_Line1
  • Principal_Investigator_3_Business_Street_Address_Line2
  • Principal_Investigator_3_City
  • Principal_Investigator_3_State
  • Principal_Investigator_3_Zip_Code
  • Principal_Investigator_3_Country
  • Principal_Investigator_3_Province
  • Principal_Investigator_3_Postal_Code
  • Principal_Investigator_3_Primary_Type
  • Principal_Investigator_3_Specialty
  • Principal_Investigator_3_License_State_code1
  • Principal_Investigator_3_License_State_code2
  • Principal_Investigator_3_License_State_code3
  • Principal_Investigator_3_License_State_code4
  • Principal_Investigator_3_License_State_code5
  • Principal_Investigator_4_Profile_ID
  • Principal_Investigator_4_First_Name
  • Principal_Investigator_4_Middle_Name
  • Principal_Investigator_4_Last_Name
  • Principal_Investigator_4_Name_Suffix
  • Principal_Investigator_4_Business_Street_Address_Line1
  • Principal_Investigator_4_Business_Street_Address_Line2
  • Principal_Investigator_4_City
  • Principal_Investigator_4_State
  • Principal_Investigator_4_Zip_Code
  • Principal_Investigator_4_Country
  • Principal_Investigator_4_Province
  • Principal_Investigator_4_Postal_Code
  • Principal_Investigator_4_Primary_Type
  • Principal_Investigator_4_Specialty
  • Principal_Investigator_4_License_State_code1
  • Principal_Investigator_4_License_State_code2
  • Principal_Investigator_4_License_State_code3
  • Principal_Investigator_4_License_State_code4
  • Principal_Investigator_4_License_State_code5
  • Principal_Investigator_5_Profile_ID
  • Principal_Investigator_5_First_Name
  • Principal_Investigator_5_Middle_Name
  • Principal_Investigator_5_Last_Name
  • Principal_Investigator_5_Name_Suffix
  • Principal_Investigator_5_Business_Street_Address_Line1
  • Principal_Investigator_5_Business_Street_Address_Line2
  • Principal_Investigator_5_City
  • Principal_Investigator_5_State
  • Principal_Investigator_5_Zip_Code
  • Principal_Investigator_5_Country
  • Principal_Investigator_5_Province
  • Principal_Investigator_5_Postal_Code
  • Principal_Investigator_5_Primary_Type
  • Principal_Investigator_5_Specialty
  • Principal_Investigator_5_License_State_code1
  • Principal_Investigator_5_License_State_code2
  • Principal_Investigator_5_License_State_code3
  • Principal_Investigator_5_License_State_code4
  • Principal_Investigator_5_License_State_code5
  • Submitting_Applicable_Manufacturer_or_Applicable_GPO_Name
  • Applicable_Manufacturer_or_Applicable_GPO_Making_Payment_ID
  • Applicable_Manufacturer_or_Applicable_GPO_Making_Payment_Name
  • Applicable_Manufacturer_or_Applicable_GPO_Making_Payment_State
  • Applicable_Manufacturer_or_Applicable_GPO_Making_Payment_Country
  • Product_Indicator
  • Name_of_Associated_Covered_Drug_or_Biological1
  • Name_of_Associated_Covered_Drug_or_Biological2
  • Name_of_Associated_Covered_Drug_or_Biological3
  • Name_of_Associated_Covered_Drug_or_Biological4
  • Name_of_Associated_Covered_Drug_or_Biological5
  • NDC_of_Associated_Covered_Drug_or_Biological1
  • NDC_of_Associated_Covered_Drug_or_Biological2
  • NDC_of_Associated_Covered_Drug_or_Biological3
  • NDC_of_Associated_Covered_Drug_or_Biological4
  • NDC_of_Associated_Covered_Drug_or_Biological5
  • Name_of_Associated_Covered_Device_or_Medical_Supply1
  • Name_of_Associated_Covered_Device_or_Medical_Supply2
  • Name_of_Associated_Covered_Device_or_Medical_Supply3
  • Name_of_Associated_Covered_Device_or_Medical_Supply4
  • Name_of_Associated_Covered_Device_or_Medical_Supply5
  • Total_Amount_of_Payment_USDollars
  • Date_of_Payment
  • Form_of_Payment_or_Transfer_of_Value
  • Expenditure_Category1
  • Expenditure_Category2
  • Expenditure_Category3
  • Expenditure_Category4
  • Expenditure_Category5
  • Expenditure_Category6
  • Preclinical_Research_Indicator
  • Delay_in_Publication_Indicator
  • Name_of_Study
  • Dispute_Status_for_Publication
  • Record_ID
  • Program_Year
  • Payment_Publication_Date
  • ClinicalTrials_Gov_Identifier
  • Research_Information_Link
  • Context_of_Research
Add a custom footer
Add a custom sidebar

Clone this wiki locally