ProPublica has compiled ready-to-use data on billions of dollars paid by pharmaceutical companies to medical providers and health care institutions between August 2013 and December 2018. Dollars for Docs, ProPublica's free, online lookup tool, now covers nearly $12 billion in medical industry payments made to more than 1 million physicians in the United States. This premium dataset is a downloadable version of the database that powers our tool.
As of November 2019, the data is provided in two separate tranches: January 2017-December 2018 and August 2013-December 2016. (You can purchase or download a sample of the 2017-2018 data here.) This page includes information about the 2013-2016 data.
The data included is based on the January 2018 release of the Open Payments data, and has been cleaned, analyzed, and matched with additional information. The data can be combined with our exclusive NPI-Open Payments ID crosswalk, which enables users to match this information to other provider-level data.
The data is provided as CSV files, with documentation, and your purchase includes:
- Documentation outlining our methodology, data sources, caveats for using the data, and a data dictionary for each of the included tables.
- A summary for each provider in the database, including their specialty, contact information, and aggregated payment information (number of payments received, total monetary value of payments received, and number of companies from which payments were received).
- A ready-to-use version of the federal Open Payments data, for which we have cleaned company names, drug names, and device names. We have standardized how each company, drug, and device is listed, and eliminated duplicates (meaning if a product was listed as both a drug and device, we figured out which was correct).
- An analysis-ready version of the payments file, with each drug or device associated with a payment represented on its own line. Open Payments records sometimes include multiple drugs and/or devices associated with each payment. (Each drug or device is assigned the full value of the payment.) Our flattened file makes it easier to identify the number of payments attributed to a drug or device or identify which providers received payments associated with particular products.
Please note: CMS updates the data every six months, with updates to the data, including corrections, additions, and removal of payments. Updates provided by CMS after January 2018 have not been included in this cleaned version of the data.
NPI-Open Payments ID Crosswalk
The NPI-Open Payments crosswalk, which matches providers Open Payment IDs to their National Provider Identifier (NPI) number, is available here. Last updated October 3, 2019. To request student or journalist discount pricing for the crosswalk, contact us.
Custom data segments are also available, with selections based on information such as provider specialty, location, NPI number, or hospital affiliation, as well as drug, device, and/or manufacturer. Submit a request here, being sure to include any information about your specific needs.
