Centers for Medicare & Medicaid Services (CMS) Data.

Source

The dataset is available to download here:

data.cms.gov/provider-summary-by-type-of-service/medicare-part-d-prescribers/medicare-part-d-prescribers-by-provider-and-drug/data?query=%7B%22filters%22%3A%7B%22rootConjunction%22%3A%7B%22label%22%3A%22And%22%2C%22value%22%3A%22AND%22%7D%2C%22list%22%3A%5B%5D%7D%2C%22keywords%22%3A%22methylphenidate%22%2C%22offset%22%3A0%2C%22limit%22%3A10%2C%22sort%22%3A%7B%22sortBy%22%3Anull%2C%22sortOrder%22%3Anull%7D%2C%22columns%22%3A%5B%5D%7D

Description of the Data

This dataset comes from the Centers for Medicare and Medicaid Services (CMS) and includes prescription-level records for diabetes medications. Each row represents a unique prescriber writing a prescription for a specific brand-name drug.

Below are the columns in the data:

Column Name Description

Prscrbr_State_Abrvtn

Two-letter state abbreviation for the prescriber location.

Prscrbr_Type

Detailed medical specialty of the prescriber (e.g. Family Practice, Endocrinology).

Brnd_Name

Brand name of the prescribed drug (e.g. Ozempic).

Gnrc_Name

Generic name of the prescribed drug (e.g. Semaglutide).

Tot_Clms

Total number of prescription claims for that drug by this prescriber.

Tot_30day_Fills

Approximate number of 30-day prescription fills.

Tot_Day_Suply

Total number of days of medication supplied.

Tot_Drug_Cst

Total cost of the drug across all claims (in dollars).

Total_Patients

Total number of unique patients who received the drug.

Prscrbr_Type_Grouped

A simplified grouping of Prscrbr_Type into broader categories (e.g. Primary Care, Cardiology).

Transformations to the original data source

The data was pulled using an API from CMS. The API was adjusted to ensure semaglutide prescription claims and non-semaglutide prescription claims were pulled.