Computers & Software Medicine

How to View Your Doctor’s Drug Company Payments

The CMS Open Payments database is up for the public to view, but the site is difficult to navigate.  Here is a step by step guide to using the site.

  1. Go to
  2. From the list of databases, click on the General Payment Data with Identifying Recipient Information – Detailed Dataset 2013 Reporting Year (or skip step one and just click on the link) as in the image.

    Click on the highlighted database link.
    Click on the highlighted database link.
  3. The page opens with a spreadsheet and a number of filter conditions.  Write in how you want to filter the spreadsheet (e.g. filter for last name and city/state).  You can add filters, such as the first name on the page too (see Add A New Filter Condition in lower right corner).

    Filter the spreadsheet data.
    Filter the spreadsheet data.
  4. Horizontally scroll the spreadsheet to see the columns you are interested in.  There are a lot of blank or useless columns.  You can remove unwanted columns by clicking on the Manage button (brown button with a gear).

    The money column.  You can exclude columns using the Manage button.
    The money column. You can exclude columns using the Manage button.
  5. Make sure you are looking at just one physician’s data.  In the figure below I have horizontally scrolled to the list of physician names.  Note that there is a Physician_Profile_ID with a unique ID number for each physician.  Pick out the physician you want to look at and add a filter for that ID number.  Remove other filters.  This should give you the data you want on an individual physician.

    Screen Shot 2014-10-08 at 12.05.46 PM
    Physician names and ID numbers. Filter on a specific ID number to get all that physician’s data.

And that’s it.  I haven’t explored the other databases.  I haven’t found any tool (other than a calculator) to sum the dollar amounts.   [ADDENDUM: Use the Export button to export the data in a form compatible with your spreadsheet.  Options include Excel and CSV formats.] This information should be enough to get you started with the Open Payments database.



The Approaching Sunshine Apocalypse

On September 30, a week from today as I write this, the US government will release the long-anticipated Sunshine Act Open Payments data to the general public. Or at least some of it, maybe two thirds. It’s not clear. What is clear is that Open Payments has gotten off to a rocky start, reminiscent of the snafu with the inauguration of last year.

Our story so far: Back in 2011 as part of the Affordable Care Act, aka ObamaCare, measures were put into place to shed light on the here-to-fore undisclosed direct financial dealings between Big Pharma and physicians. All payments, whether in the form of honoraria, ball-point pens, or bagels from Panera were to be accounted for, tallied up, and presented on a web site for the public to peruse starting this September 30. As a concession to the physicians and drug or device companies, there was a period of review this summer (45 days), during which payments could be viewed by physicians and potentially disputed.  Payments disputed after this time period would be marked as undisputed in the database.  Thus it was important for physicians to dispute these payments before the release to the general public (BTW it’s too late now).  I’m not sure how many physicians participated in the review process. Getting into the Open Payments website initially is onerous.  In order to register for the site, two separate processes of authentication are required, during which applicants are challenged to answer questions based on their credit report history (!), as well as answer a series of questions while a timer runs, including providing a subspecialty code which, if you are lucky and have a fast internet connection, you can google just in time before the buzzer runs out.

Having gotten into the system, one can laboriously go through each payment in a spreadsheet and try to ascertain whether or not various payments are legitimate. When I did this I found that, despite providing very specific information in the login process (such as my NPI number), my payment records were mixed in with another physician with my name who practiced in a different state (Florida vs Kentucky) in a different specialty (oncology vs cardiology). Via Charles Orstein and ProPublica this story was published.   This resulted in CMS shutting down the Open Payments website to fix this problem.  The site was shut down for 12 days, from August 3 to August 15. The time allotted for physicians to review their data was extended correspondingly, to September 11.  However, upon reopening the site not only were the mixed up payments gone, but most of the legitimate ones were also missing from the database. CMS then stated that some companies’ data was still being withheld due to data inconsistencies in company submissions. The companies dispute that the problem is theirs, instead blaming the government. The amount of data missing is supposed to be about a third, but, at least in my case, almost all the legitimate payments previously listed in database prior to the closure of the site are now missing.  For example there is no data listed at all from Medtronic, despite payments from them in the database before the “glitch.”  Meanwhile, further glitches shut down the Open Payments system intermittently between August 30 and September 5. Despite all this, the imperfect data is still planned to be released to the public on September 30.

What will the public make of this? Will some consider any payments at all to doctors in the form of food or honoraria a sign of corruption or at least conflict of interest? Will the trivial nature of some of these payments be reassuring to the public? Will the data reveal blockbuster damning revelations about the nature of the relationship between industry and physicians?   Or will the data be just ho-hum?  Who knows? My question is, why release the data now if it is incomplete or questionable? Why stick to this arbitrary timeline? If we are going to supply this data to public, shouldn’t it be as accurate as possible?

I just checked the Open Payments website. It is down again. Not reassuring.

Down again
Down again