US Physician Payments 2018–2024 (OpenPayments)

What’s in the listing

Civly compiles public records into analytics-ready datasets. This product is the CMS OpenPayments record of pharmaceutical and device-maker payments to US physicians for program years 2018 through 2024, cleaned and deduplicated. Every payment record is joined to the physician’s National Provider Identifier (NPI) and a normalized recipient name, with payer, amount, date, form and nature of payment, and the associated drug or device product with NDC where reported.

Common uses: compliance screening, conflict-of-interest checks, life-sciences market research, and investigative work. Data refreshes weekly, and every record carries source attribution and a refresh date.

Payment volume by program year

Data dictionary — PAYMENTS.PAYMENTS_2024 (trial) / PAYMENTS.PAYMENTS (full)

The trial view and the full table share the same 35 columns. Column names are uppercase.

Sample queries

After installing, set your worksheet’s database selector to the installed database and these run as written.

-- Payment volume by program year (trial returns 2024 only)
SELECT PROGRAM_YEAR, COUNT(*) AS PAYMENT_RECORDS, SUM(TOTAL_AMOUNT_USD) AS TOTAL_USD
FROM PAYMENTS.PAYMENTS_2024
GROUP BY PROGRAM_YEAR ORDER BY PROGRAM_YEAR;

-- Top 10 highest-paid physicians in 2024
SELECT RECIPIENT_NORM_NAME, COVERED_RECIPIENT_NPI, RECIPIENT_SPECIALTY,
       SUM(TOTAL_AMOUNT_USD) AS TOTAL_USD
FROM PAYMENTS.PAYMENTS_2024
WHERE RECIPIENT_NORM_NAME IS NOT NULL
GROUP BY 1, 2, 3 ORDER BY TOTAL_USD DESC LIMIT 10;

-- All payments to one physician by NPI (replace with any NPI you care about)
SELECT PAYMENT_DATE, PAYER_NAME, TOTAL_AMOUNT_USD, NATURE_OF_PAYMENT, PRODUCT_NAME
FROM PAYMENTS.PAYMENTS_2024
WHERE COVERED_RECIPIENT_NPI = '1821157041'
ORDER BY PAYMENT_DATE DESC;

Sourcing and attribution

Source data is the CMS OpenPayments program, published by the United States Centers for Medicare & Medicaid Services. Civly cleans, deduplicates, and normalizes the records and joins them to physician NPIs. Underlying OpenPayments data is published under CMS’ open-data terms; when you publish analysis based on this dataset, credit CMS OpenPayments and Civly as compiler.

Questions about this dataset: [email protected]