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.

 
Photo by  Miriam Espacio  from  Pexels

Photo by Miriam Espacio from Pexels

Medicaid Markup Galaxies

Looking to drill deeper into a state’s markup universe? Then this viz is for you. Medicaid Markup Galaxies separates each universe into three different groups (or celestially-speaking, “galaxies”). We call them the High-Cost, In-Range, and Low-Cost galaxies. The goal in doing so is to better quantify the nature of generic pricing distortions within state Medicaid programs.

 
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).

 
Photo by  Hugo Aitken  on  Unsplash

Photo by Hugo Aitken on Unsplash

Drugmaker Market Share Dashboard

If we want to understand drug pricing, we need to understand supply and demand. And any study of supply and demand inevitably is going to lead to the hunt for market share data. Market share is an easy and convenient place to start to try to make sense of all of the generic drug pricing nonsense. Market share analysis shows lots of competitors, each with with a relatively small slice of the pie? That’s a signal of healthy competition among generic manufacturers, which should result in lower prices. Market share concentrated with one manufacturer? That’s not great for competition, and could explain pricing oddities for the drug. Our Drugmaker Market Share Dashboard is designed to help answer these questions.

 
IMG_7094.jpg

Brand Drug Price Change Box Score

Much like a box score in baseball tallies up each player’s stats for a game, our Brand Drug Price Change Box Score tallies up all price changes by manufacturer and drug – for any period you want to see. The tool also allows you to place two different periods side by side to quickly absorb what is driving changes from one year to the next. Be careful though – the most significant limitation to this data is that it does not include manufacturer rebates. But the discussion on list price increases rages nonetheless – now at least you have better facts to contribute!