Seeing is believing.

There is a lot of publicly-available data on drug pricing, but it is complex and stuck in ugly tables. 46brooklyn’s interactive charts and graphs liberate this data so you can start answering questions you never knew you had.

 

Drug Pricing (NADAC) Dashboard

The concept for this viz (a.k.a. visualization) came from simply wanting historical trend charts to assess the change in drug costs over time.  Helpful... but we needed to take this a step further to be able to easily compare the price of brand name drugs with their generic equivalents.  That data lives in the FDA's databases, so we married that up with NADAC in Tableau and voilà - an interactive drug price trending tool.  Hover over the line and you can see all of the manufacturers and National Drug Codes (NDCs) each week as well.

 

Medicaid Drug pricing Heat Map

Once a quarter, the Centers for Medicare and Medicaid Services (CMS) publishes detailed Medicaid spending data down to the National Drug Code (NDC) level through what’s known as the State Utilization Database.  On its own, it’s somewhat challenging to use due to poor drug naming conventions and the lack of any reference pricing.  However, when merged with CMS's National Average Drug Acquisition Cost (NADAC) database, it comes to life! With this viz, you can see the average invoice prices pharmacies pay for every medication, and then compare it to what the state is being charged. Have fun exploring the madness that is Medicaid drug pricing.

 
Medicaid Utilization Dash.GIF

Medicaid Utilization Dashboard

Let's move away from price for a minute and find out what Medicaid is spending its prescription dollars on and where. That's the purpose of the 46brooklyn Medicaid Utilization Dashboard. We simply wanted to provide the means to poke around within Medicaid's utilization data to provide you with some helpful context on each state program.  So, grab a cup of coffee (or two) and dig in!

 
NADAC packed bubble pic.GIF

NADAC Change Packed Bubble Chart

Once a month (normally the 3rd or 4th week) CMS publishes the results of their monthly retail pharmacy survey.  The results of this survey reflect thousands of drug price changes. We wanted to be able to put some context around all of these changes, so we joined the survey results with Medicaid's latest dispensing data (Q1 2018) to better understand the aggregate impact of all of the latest generic pricing changes using a real life drug mix.    

 
cover picture.png

Medicaid Markup Universe

In traditional PBM “spread” contracts with payers, the payer pays one price for a generic claim, and the provider is paid some other amount for that claim. While calculating the precise spread in Medicaid is not possible given that PBM payments to pharmacies are not public, we can get a feel for how disconnected the price paid is from the ingredient cost by comparing CMS state utilization data to CMS NADAC data. From this comparison, we have derived “markup” and have created a celestial-feeling visualization for you to see where all of it is and is not.

 
top 20 over 20 logo.PNG

Top 20 over $20

Here’s yet another way to help find “markup” (payer cost less NADAC cost) within managed care Medicaid. Our Top 20 over $20 list provides you with an interactive way to view the 20 top drugs (ranked by absolute markup dollars) that sported a markup per prescription of $20 or more for any state that has managed care, and time period (going back to 2014).