US Physician Payments 2018–2025 (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 2025, 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.PHYSICIAN_PAYMENTS

One view serves the trial and the subscription. During the free trial it returns the 2024 program year only; subscribers see every year. 35 columns, uppercase names.

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.PHYSICIAN_PAYMENTS
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.PHYSICIAN_PAYMENTS
WHERE PROGRAM_YEAR = 2024 AND 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 PROGRAM_YEAR, PAYMENT_DATE, PAYER_NAME, TOTAL_AMOUNT_USD, NATURE_OF_PAYMENT, PRODUCT_NAME
FROM PAYMENTS.PHYSICIAN_PAYMENTS
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: matthew@civly.ai