Physician ℞Plorer
Visualizing the relationship between pharmaceutical company payments and drug prescriptions

About


  • Motivation

    What about Hippocrates?

    Dr. Gavin Awerbuch, a Michigan neurologist who received $56,000 from Insys, was arrested this spring after federal prosecutors said he defrauded Medicare of $7 million and improperly prescribed Subsys to patients who did not need it. [New York Times Nov. 27,2014]
  • Monitoring the caregivers with data

    Open Payment Dataset

    The Centers for Medicare & Medicaid Services (CMS) released the Open Payment dataset recording all payments made by pharmaceutical companies to physicians. One could query information such as:

    • Company making payment
    • Physician receiving payment
    • Amount of payment
    • Nature of payment
    • Drug associated to payment

  • ...And correlate payments with prescriptions

    Prescription Dataset

    The CMS released a second dataset that details information on the prescription drugs that physicians prescribed in 2013 under the Medicare Part D Prescription Drug Program. The dataset describes the specific medications prescribed and statistics on their utilization and costs.

  • Our approach

    We merged the two datasets and build a tool to query relationships between physicians and pharmaceutical companies

    Some technologies that we used:

    • D3.js, plotly.js, leaflet.js
    • MariaDB
    • OpenRefine, ipython-sql
    • Softlayer Cloud
    • Want more geeky details? Check out our github
  • Disclaimer

    Some limitations

    Medicare Part D data will presumably primarily reflect 65+ population's prescription needs.

    Join quality is very difficult to achieve; do not draw conclusions without corroboration!

  • Try Out
    Our Viz!

Visualize


Our Awesome Team


Michael Marks

Natarajan Krishnaswami

Stéphane Truong