ABSTRACT
The US continues to battle an opioid crisis, substantially influenced by prescription opioids, with nearly 80 000 opioid‐related deaths in 2023. This study aims to characterize oxycodone's distribution in the United States (US) from 2000 to 2023 using three data sources. Morphine Milligram Equivalents (MME) of oxycodone were calculated from the Drug Enforcement Administration annual summary reports from the Automation of Reports and Consolidated Orders System (ARCOS); the number of units and prescriptions of oxycodone per enrollee were calculated using the Medicaid State Drug Utilization Data (M‐SDUD); and the number of claims and 30‐day fills per enrollee and per beneficiary with a claim for oxycodone were calculated from the Medicare Part D Prescribers (M‐PDP) dataset. Oxycodone MME per person in ARCOS rose +280% from 2000 to 2010 before declining, ending at +56% over the full period. At the 2010 peak, Florida, Delaware, and Tennessee showed high distributions of oxycodone, while Texas and Illinois had lower amounts compared to most states. Delaware again stood out in the Medicaid data with higher numbers of units and prescriptions, along with Alaska, Arizona, Maine, and Maryland. This data also had some anomalies in the number of prescriptions in the 2000s. The Medicare data covered 2013–2022, with the District of Columbia and North Dakota standing out with lower numbers of claims and 30‐day fills per beneficiary compared to other states. Oxycodone distribution varied substantially between states over time. Each dataset provided complementary insights, highlighting the importance of multi‐source monitoring for assessing opioid distribution trends and informing public policy.
Keywords: medical informatics, opioid epidemic, opioid‐related disorders, pain, pharmacoepidemiology
Abbreviations
- ARCOS
Automation of Reports and Consolidated Orders System
- MME
Morphine Milligram Equivalents
- M‐PDP
Medicare Part D Prescribers
- M‐SDUD
Medicaid State Drug Utilization Data
1. Introduction
The United States (US) has been battling an opioid crisis for decades and in 2023 a staggering 96.4% of opioid misusers were using prescription pain relievers (not including illegally made fentanyl) [1]. Prescription opioids account for the vast majority of opioid misuse, with oxycodone standing out as a major contributor due to marketing practices and high abuse liability [2, 3, 4]. The US healthcare system plays a central role in both perpetuating and combating the epidemic, which claimed 79 358 lives in 2023 as reported by the National Center for Health Statistics [5]. This study aims to characterize the distribution of the widely used prescription opioid oxycodone throughout the US by leveraging three data sources that provide state‐level data: the US Drug Enforcement Administration Automated Reports and Consolidated Ordering System (ARCOS), the Medicaid State Drug Utilization Data (M‐SDUD), and the Medicare Part D Prescribers dataset (M‐PDP). ARCOS is a comprehensive database that covers the entire US population. Medicaid is responsible for 12%–28% of the US population while Medicare Part D covers 12%–16% of the US population. Each data source provides different, but possibly complementary, information that can be utilized to monitor prescription drug distribution.
Studies examining global consumption of opioids using International Narcotics Control Board (INCB) data and the IQVIA Midas database have revealed the US as the third highest consumer of opioids in 2015–2017 and 2019 [6, 7]. These reports also show that oxycodone is the most heavily consumed opioid. Within the US, 31.3% of people who misused prescription opioids were misusing oxycodone products (including generic oxycodone and brand name formulations such as OxyContin, Percocet, Percodan, and Roxicodone), second to only hydrocodone at 42.8% [1]. Oxycodone's abuse liability is distinguished from other opioids by its markedly higher desirability and milder side‐effect profile, supported by studies of its unique pharmacologic properties [2, 3].
ARCOS is an infrequently utilized database in the literature, particularly at the level of individual drugs. Previous studies have used ARCOS to characterize oxycodone distribution from 2000 to 2021, showing a substantial increase in distribution to a peak in 2010, followed by a slower decline until 2021 [8, 9]. Another report looked at the subset of ARCOS data released by the Washington Post in the context of commuting zones which showed a superlinear scaling relationship between population size and amount of oxycodone, as well as regions of higher distribution in the Appalachians, Ozarks, and the west coast [10]. Other investigations have examined ARCOS oxycodone distribution in specific states and territories, including Florida, Delaware, Maryland, Virginia, and Puerto Rico [11, 12, 13].
The Medicaid and Medicare programs started in 1965 to provide health insurance to Americans [14]. Medicaid is a government program, administered by states according to federal guidelines, that provides health coverage for people with low income or limited resources [15]. Medicaid services can vary by state but must fall within the parameters set by the federal government. Medicare is a federal program that provides health coverage for individuals over age 65, with certain disabilities or with end‐stage renal disease [16]. Both programs together offer health insurance for millions of Americans who otherwise may not have the resources to get coverage.
M‐SDUD and M‐PDP datasets have been underutilized for studying oxycodone‐specific trends, though they may offer valuable insights into opioid prescription patterns. Some reports have examined opioids broadly and medications for opioid use disorder, including buprenorphine and naltrexone, using the M‐SDUD [17, 18, 19, 20, 21, 22, 23, 24, 25]. The M‐PDP has been used to evaluate opioid prescribing trends by medical oncologists [26]. Both databases have been just as infrequently used to examine drugs in other classes. There is a wealth of information included in these databases that can be used to characterize trends in opioids as well as a broad range of other drugs. However, prior reports employing the M‐SDUD have also noted some anomalous data points which needed to be addressed prior to analysis [17, 27, 28].
This report investigates oxycodone distribution using the ARCOS, M‐SDUD, and M‐PDP data with the most recent information available. ARCOS overcomes limitations in the frequently used IQVIA database, which has gaps in Veteran's Affairs, Indian Health Services facilities, hospitals, and independent pharmacies [29]. All three sources provide data at the state level, allowing for a more complete picture of oxycodone distribution trends and identifying geographic disparities and potential regulatory impacts.
2. Methods
2.1. Procedures
Data was collected from the ARCOS Report 5, the M‐SDUD database, and the M‐PDP dataset. Informed consent was not required as all data used is publicly available and deidentified. The Python package pandas (version 2.2.3, RRID:SCR_018214) was used to organize and consolidate the raw data for analysis [30].
ARCOS is reported by the US Drug Enforcement Administration and includes distribution of Schedule II–IV controlled substances [31]. The weights for oxycodone were reported annually from 2000 to 2023 for each state. Amounts were provided in grams grouped by business type (hospitals, pharmacies, practitioners, mid‐level practitioners, narcotic treatment programs, teaching institutions). Pharmacies, hospitals, practitioners, and the sum of all business types were examined in this report. Data was read from the PDF reports using the Python package tabula‐py (version 2.10.0) and filtered for oxycodone [32].
M‐SDUD is provided by the Centers for Medicare and Medicaid Services (CMS) and includes all drugs provided by manufacturers who participate in the Medicaid Drug Rebate program [33]. Drug utilization data were reported quarterly per state and grouped by the NDC code for each drug from 2000 to 2023. Units reimbursed (based on the unit type of the NDC code), number of prescriptions, and reimbursement amounts are all provided. Counts under 11 are suppressed to protect individual privacy. Data were filtered for oxycodone using the NDC codes, brand names, and generic names provided in the NDC directory [34]. Data were also searched for text stems specific for oxycodone or its brand names (e.g., “oxyco”, “percoc”, “endoce”, etc.) to account for misspellings or truncations present in the data.
M‐PDP data is provided by the CMS and includes a dataset reporting the geography and the drug [35]. The data was reported per state from 2013 (i.e., the earliest year available) to 2022 by the brand and generic names for oxycodone formulations. Data included the number of prescribers, total claims, total 30‐day fills, total drug cost, and number of beneficiaries. The same fields were also provided for beneficiaries over 65 years old, as well as the cost share for beneficiaries with and without low‐income subsidies. Claims fewer than 11 were suppressed to protect individual privacy. Data was filtered for oxycodone similarly to the Medicaid data as follows:
2.2. Data Analysis
Microsoft Excel was used to analyze the data after aggregation and formatting. RStudio (version 2024.12.0 + 467, RRID:SCR_000432) was used to visualize the data using the tidyverse (version 2.0.0, RRID:SCR_019186) collection of packages [36].
A standard oral conversion factor of 1.5 was used to convert grams of oxycodone to morphine milligram equivalents (MME) for the weights provided in ARCOS [9]. MMEs were then used to calculate MME per buyer and MME per person by dividing the values by the number of businesses that made purchases and the state population reported by the U.S. Census Bureau American Community Survey, respectively.
Units and prescriptions per enrollee were calculated for the Medicaid data by dividing each value by the reported number of enrollees for each state. Similarly, the number of Medicare Part D enrollees was used to calculate claims, 30‐day fills, and cost per enrollee. Each field was also divided by the number of beneficiaries with claims for each particular drug to get claims, 30‐day fills, and cost per beneficiary.
Values were plotted across the time for each state to characterize the distribution of oxycodone per population unit. The five states with the highest average distribution and the five states with the lowest average distribution were plotted for pharmacies, hospitals, and the total of all business types in ARCOS; units and prescriptions per enrollee for Medicaid; and claims and 30‐day fills both per enrollee and per beneficiary for Medicare. Data for ARCOS practitioners varied widely, and the ten states with the highest distribution were plotted. Extreme values in the Medicaid data (greater than 5 × IQR + Q3) are shown separately.
For each set of values, the range of ± standard deviations was identified and included as a shaded region on each plot. A scatter plot was created, and a Pearson correlation coefficient was calculated for each unique combination of ARCOS MME/Person, Medicaid Units/Enrollee, Medicare Claims/Enrollee, and Medicare Claims/Beneficiary. Choropleth maps of the U.S. states were created for 2013, the earliest common year between the datasets.
3. Results
3.1. Total (i.e., National) Oxycodone Distribution
There were 1491.16 metric tons (in MME) of oxycodone distributed throughout the US from 2000 to 2023, for an average of 71.0 metric tons per year. The total MME per person increased by +280% from 2000 to a peak in 2010, then gradually fell until 2023 for an overall increase of +56% over the whole time period. Stratifying the data into business types reveals pharmacies as the largest contributing group (more than 94% of total weight from 2000 to 2023). MME per person of oxycodone distributed by pharmacies increased by +293% from 2000 to a peak in 2010, before falling to +63% of the original value by 2023. Practitioners account for only 0.4% of the total weight of oxycodone distributed in the US and follow a similar trend to pharmacies. There was a sharp increase of +15 565% to a peak in 2010, due to a small number of states, before a decrease to 63.4% of the original value by 2023. Hospitals account for 5.3% of the total weight of oxycodone distributed in the US, and MME per person was substantially less variable between years. MME per person of oxycodone distributed by hospitals increased by +89% from 2000 to a later peak in 2012 and decreased to −13% of the original value by 2023 (Figures 1 and 2).
FIGURE 1.

Choropleth maps of the US states ranked by oxycodone distribution in 2013 for (a) ARCOS MME per person, (b) Medicare Part D Prescribers claims per beneficiary, (c) Medicaid SDUD units per enrollee, and (d) Medicare Part D Prescribers claims per enrollee.
FIGURE 2.

Oxycodone distribution for the top 5 and bottom 5 states (a–c) and top 10 states (c) as reported by the Drug Enforcement Administration's Automated Reports and Consolidated Ordering System in (a) total, (b) by pharmacies, (c) by hospitals, (d) and by practitioners. The shaded regions indicate ±1.96 standard deviations from the mean.
The M‐SDUD provides amounts in prescriptions and units (e.g., grams, milliliters, pills, etc.). Earlier data shows some discrepancies in the number of prescriptions, likely contributing to reporting errors in South Dakota, Tennessee, and Washington (Table 1). Inspection of the year‐to‐year changes in prescriptions (e.g., Washington in 2006 was 141.5 fold higher than the prior year and 208.2 fold elevated relative to the subsequent year) reveals pronounced temporal instability. Further, the changes in prescriptions did not correspond with the number of units. After removing these extreme values, more than 142 million prescriptions and 9.7 billion units of oxycodone were distributed throughout the US from 2000 to 2023. The average number of units per prescription was 66.0. The number of prescriptions and units of oxycodone peaked in 2012, with an increase of +218% and +183% respectively. The number of prescriptions decreased by −8% and the number of units by −17% from 2000 to 2023 (Figures 1 and 3).
TABLE 1.
Medicaid State Drug Utilization Data prescriptions, units, and total amount reimbursed for oxycodone from 2000 to 2010 for states with outliers likely due to reporting error.
| State | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Number of prescriptions | |||||||||||
| SD | 3380 | 5127 | 6673 | 9996 | 11 643 | 11 877 | 7190 | 24 092 023 | 8122 | 8169 | 8732 |
| TN | 27 131 | 78 053 | 110 227 | 253 252 | 2 914 201 | 1 535 862 | 2 871 497 | 144 252 | 166 723 | 189 800 | 205 960 |
| WA | 97 497 | 133 616 | 165 291 | 875 085 | 183 119 | 198 804 | 28 080 166 | 134 845 | 150 971 | 146 891 | 166 467 |
| Number of units | |||||||||||
| SD | 174 109.00 | 270 852.00 | 366 071.00 | 588 262.00 | 672 352.00 | 713 270.00 | 465 628.00 | 249 553.00 | 539 571.00 | 535 938.00 | 576 888.00 |
| TN | 1 566 506.00 | 4 841 937.00 | 7 341 791.00 | 15 337 106.00 | 24 211 205.41 | 23 318 946.23 | 8 851 886.27 | 8 929 437.50 | 10 318 129.00 | 11 179 524.20 | 12 426 276.90 |
| WA | 6 342 380.00 | 8 737 138.47 | 10 665 915.44 | 12 647 823.56 | 12 992 987.00 | 14 709 182.50 | 8 983 049.00 | 9 878 594.07 | 11 346 947.50 | 10 485 891.00 | 12 238 654.80 |
| Total amount reimbursed | |||||||||||
| SD | 219 196.63 | 373 871.86 | 577 058.43 | 1 053 401.37 | 1 281 405.12 | 1 195 741.96 | 556 759.99 | 189 168 999.90 | 752 673.22 | 926 947.58 | 858 609.49 |
| TN | 2 044 642.01 | 8 143 864.66 | 13 851 081.67 | 28 355 311.77 | 70 892 324.64 | 105 243 425.11 | 285 308 844.46 | 9 019 127.10 | 10 378 039.61 | 11 748 616.63 | 11 694 600.21 |
| WA | 8 405 275.63 | 13 557 922.78 | 15 115 700.99 | 97 392 968.04 | 12 814 617.21 | 11 931 547.11 | 556 164 185.10 | 6 203 743.15 | 8 332 585.25 | 8 009 244.37 | 8 748 213.00 |
Note: Concerning values for prescriptions are highlighted.
Abbreviations: SD = South Dakota, TN = Tennessee, WA = Washington.
FIGURE 3.

Oxycodone distribution for the top 5 and bottom 5 states as reported by the Medicaid State Drug Utilization Data in (a) units per enrollee and (b) prescriptions per enrollee. The shaded regions indicate ±1.96 standard deviations from the mean. “USA (without outliers)” for Prescriptions per Enrollee does not include the outlier values from South Dakota, Tennessee, and Washington from 2003 to 2007.
The M‐PDP dataset provides the number of claims and 30‐day fills for oxycodone from 2013 to 2022. There were 182.2 million claims in total over these years. The number of beneficiaries with claims for the drug is also reported, allowing for a more accurate measure of per capita utilization. The pattern based on total enrollees (available for 2013–2021) versus beneficiaries, which are available from the same dataset, differs greatly. Claims and 30‐day fills per enrollee, which are more comparable to the above measures in ARCOS and Medicaid data, both peaked in 2015 with a +5% increase since 2013. Claims per enrollee decreased by −25%, and 30‐day fills per enrollee decreased by −26% between 2013 and 2021. Claims and 30‐day fills per beneficiary peaked in 2020, increasing by +18% and +17%, respectively. They decreased by 2022, ending at +5% and +4% of their values from 2013 (Figures 1 and 4).
FIGURE 4.

Oxycodone distribution for the top 5 and bottom 5 states as reported by the Medicare Part D Prescribers dataset in (a) units per total enrollees, (b) 30‐day fills per total enrollees, (c) claims per beneficiaries with claims for oxycodone, (d) and 30‐day fills per beneficiaries with claims for oxycodone. The shaded regions indicate ±1.96 standard deviations from the mean.
3.2. Oxycodone Distribution by State
MME per person calculated using ARCOS data varied greatly between states in total and for each business type. The top and bottom states had an 8‐fold difference in 2000 (Alaska = 177.7, Illinois = 23.4), a 15‐fold difference at the peak in 2010 (Florida = 993.7, Texas = 66.7), and a fivefold difference in 2023 (Tennessee = 223.3, Illinois = 42.6). Florida (2007–2011), Delaware (2003–2020), Tennessee (2012–2021), Alaska (2000–2002), and Missouri (2002–2005) were distributing amounts of oxycodone greater than 1.96 standard deviations above the mean for persistent periods of time. Illinois (2012–2023) and Texas (2012–2023) were the only two states that were less than 1.96 standard deviations below the mean (Figures 1 and 2).
Pharmacies, being the largest contributor to the overall trend, showed largely similar patterns between states. Florida (2007–2011), Delaware (2003–2020), Tennessee (2012–2014, 2017–2020), Alaska (2000–2003), and Missouri (2001–2005) were distributing substantially larger amounts of oxycodone per person than other states. Illinois (2013–2018) and Texas (2013–2018) were considerably lower than most states. State‐level distribution patterns for hospitals differed greatly from the total and pharmacy groups. The District of Columbia (DC; 2000–2011), Colorado (2008–2023), Alaska (2000–2001, 2008, 2010–2023), and Montana (2000–2003) had consistently high distribution per person compared to other states. Only Illinois (2000–2002) ever fell below 1.96 standard deviations from the mean. The pattern for practitioners varied widely between states, but Florida (2000–2010) stood in stark contrast from the others, peaking at more than 26 000 times greater MME per person in 2010 than the lowest state (Florida = 85.27, West Virginia = 0.0033). Similarly to the other business types, Alaska (2000–2004) was elevated in the earlier years. Hawaii (2014–2015, 2017–2023) and Maryland (2014, 2018–2019, 2021–2023) have been distributing more oxycodone than other states more recently (Figures 1 and 2).
Claims and prescriptions per enrollee in the M‐SDUD also differed substantially between states. The top and bottom states by claims per enrollee had a 22‐fold difference in 2000 (Alaska = 23.9, Illinois = 1.1), a 114‐fold difference at the peak in 2012 (Delaware = 59.8, Texas = 0.5), and a 30‐fold difference in 2023 (Maryland = 9.7, Texas = 0.3). Delaware (units: 2006–2012; prescriptions: 2008–2013) and Alaska (both units and prescriptions: 2000–2002) were the only states to show a similar elevation as the ARCOS trends in both units and prescriptions per enrollee. Arizona (units: 2013–2018; prescriptions: 2016), Maine (units: 2000–2009; prescriptions: 2000–2002), and Maryland (units: 2018–2023; prescriptions: 2014–2015, 2017–2023) showed consistent elevations above 1.96 standard deviations from the mean. Texas (units: 2018, 2021–2023; prescriptions: 2016–2023) was the only state that fell below 1.96 standard deviations from the mean. The three states with abnormal prescription values (i.e., greater than 5 × IQR + Q3) in the early years–South Dakota (2007), Tennessee (2004–2006), and Washington (2003, 2006)–otherwise were similar to most states in their trends. Arizona was missing all data for oxycodone from 2000 to 2009 because it did not participate in the Medicaid Drug Rebate Program until the Affordable Care Act was passed in 2010 [37] (Figures 1 and 3).
The Medicare data spans a smaller timeframe, 2013–2022, but has an interesting advantage in providing the number of beneficiaries that have claims for oxycodone. When looking at claims and 30‐day fills per total Medicare Part D enrollees, Illinois and Texas have substantially lower amounts for 2013–2021 (2022 enrollment data is not yet available when data analysis was completed) while Alaska (2014–2025), North Carolina (2020–2021), and Tennessee (2015–2021) have elevated amounts. However, when corrected by the number of beneficiaries, this effect disappears. The number of claims per beneficiary in DC is lower than 1.96 standard deviations from the mean for 2013–2022, along with North Dakota (2017–2021) and Hawaii (2016). When adjusting for the number of beneficiaries, only Maine (2013) and Vermont (2017) ever go above 1.96 standard deviations from the mean for either claims or 30‐day fills. For all states, the number of 30‐day fills never differed from the number of claims by more than +2.18% (California in 2013; Figures 1 and 4).
3.3. Monetary Cost of Oxycodone
The Medicaid and Medicare data also offer the advantage of examining the cost associated with oxycodone. There was more than 8.7 billion dollars in reimbursement for oxycodone from 2000 to 2023, more than 6.5 billion (74.7%) of which was paid by Medicaid. The total drug cost for Medicare was 14.75 billion dollars from 2013 to 2022. Having the number of beneficiaries with claims for oxycodone allows a calculation of individual cost, which showed a peak of 384.56 dollars in 2014, with a gradual decline to 263.25 dollars per beneficiary in 2022.
3.4. Correlations
ARCOS MME per person and M‐SDUD claims per enrollee had a moderate positive correlation (r = 0.647, p < 0.001). ARCOS MME per person had a weak positive correlation with M‐PDP claims per enrollee (r = 0.13, p = 0.005) and M‐PDP claims per beneficiary (r = 0.271, p < 0.001). M‐SDUD claims per enrollee were not associated with M‐PDP claims per enrollee (r = 0.051, p = 0.275) and M‐PDP claims per beneficiary (r = 0.029, p = 0.509). M‐PDP claims per enrollee and claims per beneficiary had a non‐significant positive correlation (r = 0.065, p = 0.116; Figure 5).
FIGURE 5.

Scatter plots showing the relationships between (a) ARCOS MME/Person and Medicaid Units/Enrollee, (b) ARCOS MME/Person and Medicare Claims/Enrollee, (c) ARCOS MME/Person and Medicare Claims/Beneficiary, (d) Medicaid Units/Enrollee and Medicare Claims/Enrollee, (e) Medicaid Units/Enrollee and Medicare Claims/Beneficiary, and (f) Medicare Claims/Enrollee and Claims/Beneficiary. The Pearson correlation coefficient (r) and p‐values are displayed on the respective plot.
4. Discussion
This study employed three complementary data sources–ARCOS, M‐SDUD, and Medicare‐PDP–to characterize oxycodone distribution throughout the US. ARCOS offers a comprehensive overview of national distribution, while Medicaid and Medicare datasets provide insights into prescribing trends among vulnerable populations. ARCOS provides weights of oxycodone distributed, Medicaid provides units and prescriptions, and Medicare provides claims and 30‐day fills. Each source has advantages and disadvantages in ease of access/use and the type of information encompassed. ARCOS reports on distribution to 100% of the US population while in 2023 Medicaid covered 26% and Medicare covered 16%. Understanding these subtle differences can help healthcare professionals and policymakers refine opioid stewardship programs and enhance regulatory frameworks to curb misuse.
The ARCOS database revealed a notable increase in total oxycodone distribution from 2000 to 2010, largely driven by pharmacies. Since the 2010 peak, oxycodone distribution has been on the decline, most likely due to regulatory actions including prescription drug monitoring programs and opioid prescribing limits. Differences between states were striking; Florida and Delaware had sharp increases with equally swift declines after the 2010 peak [11, 12, 38]. Texas and Illinois had consistently lower distributions than other states [39]. From 2000 to 2023, the difference between the top and bottom states never dropped below fivefold, extending a prior report [40]. State‐level disparities underscore regional differences in prescribing practices, healthcare infrastructure, and the effectiveness of policy interventions.
The M‐SDUD showed a similarly large increase in oxycodone distribution but a later peak in 2012. Delaware stood out again with persistently elevated units and prescriptions in all years. New Hampshire, Massachusetts, and Maine also showed high numbers across many years but were not unusually elevated compared to other states in ARCOS. Texas and Illinois were again distributing considerably lower amounts of oxycodone. Notably, disproportionate and massive increases in prescription numbers in South Dakota, Tennessee, and Washington in the early 2000s are implausible, were removed, and call into question the integrity of the data in those earlier years. Although prior reports with M‐SDUH have also identified occasional anomalous data, this is concerning for the veracity of reports that make use of this freely available dataset for a large portion of the US population [17, 27, 28].
The M‐PDP data showed a much different trend, possibly due to the population (individuals 65+ or with certain disabilities) or the timeframe covered by the data. From 2013 to 2023, there was a decrease across most states in ARCOS and the M‐SDUD with substantially less disparity between states. The Medicare database highlights the importance of the population being used to correct the data; trends across time for some states were considerably different depending on whether the claims/30‐day fills were corrected by total enrollees or beneficiaries with claims for oxycodone. Both Illinois and Texas showed low claims and 30‐day fills per enrollee, while Alaska, North Carolina, and Tennessee showed high numbers, but this was no longer the case when correcting for number of beneficiaries instead.
Correlations between the measures in each data source show that only ARCOS MME per person and M‐SDUD units per enrollee had a moderate positive linear correlation (r = 0.647, p < 0.001). There may be more common factors driving the trends seen in these two measures compared with those influencing the changes in the M‐PDP. The Medicare population is likely to have a higher comorbidity burden that can impact prescribing practices. The non‐significant correlation within the M‐PDP data between claims per enrollee and claims per beneficiary (r = 0.065, p = 0.166) highlights disparities when using a general vs. specific population.
The peaks and sharp declines in oxycodone distribution around 2010 are possibly due to a combination of regulatory programs, governmental interventions, and generally enhanced awareness of the risk of opioid dependence in healthcare by both patients and providers. Prescription monitoring programs and laws limiting the quantity dispensed for acute pain may have contributed to the decline we have seen. There is, however, mixed information about the effectiveness of laws in decreasing opioid prescriptions, and further work may better delineate factors that account for changes in oxycodone distribution [41, 42]. In 2010, there was a reformulation of OxyContin, a prominent brand name formulation, which made crushing the pill for nasal insufflation and dissolving the pill for intravenous injection more difficult [43]. Some research shows that this change may in turn decrease the misuse potential of, and demand for, oxycodone [44, 45]. However, it is important to appreciate that according to the Treatment Episode Data Set, the predominant route of administration for those that were admitted to treatment programs for prescription opioids was oral [46]. Around the same time, there was increasing legal action against physicians who inappropriately prescribe controlled medications. These legal efforts were prominent in Florida and extended to other states in following years [47].
All three databases share some strengths and weaknesses. They are all publicly accessible (unlike IQVIA) and deidentified for examination. However, all reported values pertain to licit distribution and any diversion of drugs to a third party cannot be determined. Similarly, information about whether or how much of the drug was used by recipients is unavailable.
ARCOS is a comprehensive data source that has data over a large time frame and is the only source that readily quantifies the amount of oxycodone distributed. It has advantages over the less complete IQVIA database, as ARCOS covers Veteran's Affairs, Indian Health Services facilities, hospitals, and independent pharmacies. The data includes all transactions and shipments between distributors and may result in overestimation. Some amount of the oxycodone reported in pharmacy, practitioners, and teaching institutions' business activities may be used by veterinarians [48]. The American Community Survey data used to normalize for population is limited by counting of undocumented individuals and may be an underestimate [49].
The data is also difficult to transform into an analyzable format. The ARCOS data released by the Washington Post is easy to work with but initially only covered 2006–2014 [50]. The reports are provided as PDF files with inconsistent formats across years. Transferring the tables into a filetype that is conducive to analytic work (i.e., .csv) is most easily accomplished with an online conversion website, which can lead to errors. Utilizing the packages tabula‐py and pandas (RRID:SCR_018214) for Python allows for a more reproducible approach with manual accuracy checks.
The M‐SDUD is easily accessible online with the ability to filter and download data. Providing the number of prescriptions is useful to put the distribution in a clinical context. It additionally provides the associated financial costs, which is important for pharmacoeconomists. The study population is large but limited compared to ARCOS. The Medicaid data has a lower spatial resolution, providing state‐level data compared to ARCOS data, which can be grouped by zip code. It is also not possible to easily quantify the amount of oxycodone since there are a multitude of different formulations reported, and the NDC units code is less easily conducive to a systematic conversion to weight or volume.
The broad range of the provided drug names within and across the generic and brand names (i.e., oxycodone, oxycodone hcl, oxycodone hydrochloride; Percocet, Percocet 5, Percocet|oxycodone) makes it difficult to effectively filter the data to capture all formulations. Additionally, it is difficult to get a list of all NDC codes for oxycodone products over the entire range of data as they can change between years. Although some small amounts may still be missed, using the NDC code directory and searching the data for known patterns using regular expressions (character sequences that define a match pattern) provides a more comprehensive extraction of data.
The M‐PDP data is also easily accessible online and the most user friendly. It is simple to filter the data based on either generic or brand names. There are also flags for opioids and long‐acting opioids (as well as antipsychotics and antibiotics) for the study of these classes of drugs. Data on how many beneficiaries had claims for each drug allows the calculation of the most accurate measure of oxycodone distribution per person. Uniquely, the M‐PDP data can also provide information about individual providers, though data is broadly grouped into categories like opioids. Like Medicaid, this dataset also reveals the financial costs but has a spatial resolution limited to states and a population that only includes those enrolled in Medicare Part D, an optional benefit that covers prescription drugs. The specific amounts of oxycodone are also not quantifiable as there is no information about each formulation. This dataset is the smallest and spans only 2013–2022, which misses the peak years based on the other data sources.
By analyzing multi‐source data, clinicians and policy makers can develop more effective interventions to mitigate opioid misuse while ensuring appropriate access to pain relief. As data collection and sharing continues to improve, ARCOS, M‐SDUD, and M‐PDP data can be valuable resources for monitoring drug utilization across the US. Interpreting trends in prescription opioid use at the state level can provide insight into the effectiveness of guidelines and regulations or reveal utilization trends that require intervention. The results of this report can aid efforts to limit prescription opioid misuse, and it also lays the foundation for future works to leverage these data sources to look closely at states of interest. The findings reported here may also be valuable internationally for other countries looking to avoid the opioid excesses of the US.
Author Contributions
Jay P. Solgama: conceptualization (equal), data curation (equal), formal analysis (equal), methodology (equal), software (lead), visualization (equal), writing – original draft (equal), writing – review and editing (equal). Apoorva Pradhan: supervision (equal), methodology (equal), formal analysis (equal), writing – review and editing (equal). Kenneth L. McCall: supervision (equal), methodology (equal), writing – review and editing (equal). Brian J. Piper: conceptualization (equal), data curation (equal), formal analysis (equal), methodology (equal), visualization, writing – original draft (equal), writing – review and editing (equal).
Conflicts of Interest
B.J.P. was (2019–2021) part of an osteoarthritis research team supported by Pfizer and Eli Lilly and was supported by HRSA (D34HP31025) and the Pennsylvania Academic Clinical Research Center (01, 03, and 05).
Acknowledgments
Jove Graham, PhD and Mellar Davis, MD, are appreciated for their mentorship during the project. The Geisinger Commonwealth School of Medicine Summer Research Immersion Program is appreciated for providing a stipend and supporting the project during the summer of 2022.
Solgama J. P., Pradhan A., McCall K. L., and Piper B. J., “Pharmacoepidemiology of Oxycodone in the USA: An Observational Study of ARCOS, Medicaid, and Medicare Drug Databases,” Pharmacology Research & Perspectives 14, no. 1 (2026): e70210, 10.1002/prp2.70210.
Data Availability Statement
ARCOS data is publicly accessible at https://www.deadiversion.usdoj.gov/arcos/retail_drug_summary/arcos‐drug‐summary‐reports.html. Medicaid State Drug Utilization Data is publicly accessible at https://www.medicaid.gov/medicaid/prescription‐drugs/state‐drug‐utilization‐data/index.html. Medicare Part D Prescribers data is publicly accessible at https://data.cms.gov/provider‐summary‐by‐type‐of‐service/medicare‐part‐d‐prescribers. Scripts and data used for this study can be found at https://github.com/solgamaj/ARCOS‐MEDICAID‐MEDICARE.
References
- 1. “Key Substance Use and Mental Health Indicators in the United States: Results From the 2023 National Survey on Drug Use and Health,” 2023, https://www.samhsa.gov/data/sites/default/files/reports/rpt47095/National%20Report/National%20Report/2023‐nsduh‐annual‐national.pdf.
- 2. Remillard D., Kaye A. D., and McAnally H., “Oxycodone's Unparalleled Addictive Potential: Is It Time for a Moratorium?,” Current Pain and Headache Reports 23, no. 2 (2019): 15, 10.1007/s11916-019-0751-7. [DOI] [PubMed] [Google Scholar]
- 3. Kibaly C., Alderete J. A., Liu S. H., et al., “Oxycodone in the Opioid Epidemic: High ‘Liking’, ‘Wanting’, and Abuse Liability,” Cellular and Molecular Neurobiology 41, no. 5 (2021): 899–926, 10.1007/s10571-020-01013-y. [DOI] [PMC free article] [PubMed] [Google Scholar]
- 4. Office of Public Affairs | Justice Department , “Announces Global Resolution of Criminal and Civil Investigations With Opioid Manufacturer Purdue Pharma and Civil Settlement With Members of the Sackler Family | United States Department of Justice,” 2020, https://www.justice.gov/archives/opa/pr/justice‐department‐announces‐global‐resolution‐criminal‐and‐civil‐investigations‐opioid.
- 5. Garnett M. F., “Drug Overdose Deaths in the United States, 2003–2023,” 2024, https://www.cdc.gov/nchs/data/databriefs/db522.pdf. [DOI] [PMC free article] [PubMed]
- 6. Jayawardana S., Forman R., Johnston‐Webber C., et al., “Global Consumption of Prescription Opioid Analgesics Between 2009‐2019: A Country‐Level Observational Study,” EClinicalMedicine 42 (2021): 101198, 10.1016/j.eclinm.2021.101198. [DOI] [PMC free article] [PubMed] [Google Scholar]
- 7. Richards G. C., Aronson J. K., Mahtani K. R., and Heneghan C., “Global, Regional, and National Consumption of Controlled Opioids: A Cross‐Sectional Study of 214 Countries and Non‐Metropolitan Territories,” British Journal of Pain 16, no. 1 (2022): 34–40, 10.1177/20494637211013052. [DOI] [PMC free article] [PubMed] [Google Scholar]
- 8. Kenan K., Mack K., and Paulozzi L., “Trends in Prescriptions for Oxycodone and Other Commonly Used Opioids in the United States, 2000–2010,” Open Medicine 6, no. 2 (2012): e41–e47. [PMC free article] [PubMed] [Google Scholar]
- 9. Solgama J. P., Liu E., Davis M., Graham J., McCall K. L., and Piper B. J., “State‐Level Variation in Distribution of Oxycodone and Opioid‐Related Deaths From 2000 to 2021: An Ecological Study of ARCOS and CDC WONDER Data in the USA,” BMJ Open 14, no. 3 (2024): e073765, 10.1136/bmjopen-2023-073765. [DOI] [PMC free article] [PubMed] [Google Scholar]
- 10. Mullachery P. H. and Bilal U., “Urban Scaling of Opioid Analgesic Sales in the United States,” PLoS One 16, no. 10 (2021): e0258526, 10.1371/journal.pone.0258526. [DOI] [PMC free article] [PubMed] [Google Scholar]
- 11. Stains E. L., Patel A. C., Solgama J. P., Hagedorn J. D., McCall K. L., and Piper B. J., “Dynamic Changes in the Distribution of Hydrocodone and Oxycodone in Florida From 2006 to 2021,” Pharmacy (Basel) 12, no. 4 (2024): 102, 10.3390/pharmacy12040102. [DOI] [PMC free article] [PubMed] [Google Scholar]
- 12. Eufemio C. M., Hagedorn J. D., McCall K. L., and Piper B. J., “An Analysis of Oxycodone and Hydrocodone Distribution Trends in Delaware, Maryland, and Virginia Between 2006‐2014,” Cureus 15, no. 4 (2023): e38211, 10.7759/cureus.38211. [DOI] [PMC free article] [PubMed] [Google Scholar]
- 13. El Burai Félix S., Mack K. A., and Jones C. M., “Trends in the Distribution of Opioids in Puerto Rico, 1999‐2013,” Puerto Rico Health Sciences Journal 35, no. 3 (2016): 165–169. [PMC free article] [PubMed] [Google Scholar]
- 14. “History | CMS,” accessed February 12, 2025, https://www.cms.gov/about‐cms/who‐we‐are/history.
- 15. “Eligibility Policy | Medicaid,” accessed February 12, 2025, https://www.medicaid.gov/medicaid/eligibility‐policy/index.html.
- 16. “Overview of Medicare | CMS,” accessed February 12, 2025, https://www.cms.gov/cms‐guide‐medical‐technology‐companies‐and‐other‐interested‐parties/getting‐started/overview‐medicare.
- 17. Liang D., Bao Y., Wallace M., Grant I., and Shi Y., “Medical Cannabis Legalization and Opioid Prescriptions: Evidence on US Medicaid Enrollees During 1993‐2014,” Addiction 113, no. 11 (2018): 2060–2070, 10.1111/add.14382. [DOI] [PMC free article] [PubMed] [Google Scholar]
- 18. Shi Y., Liang D., Bao Y., An R., Wallace M. S., and Grant I., “Recreational Marijuana Legalization and Prescription Opioids Received by Medicaid Enrollees,” Drug and Alcohol Dependence 194 (2019): 13–19, 10.1016/j.drugalcdep.2018.09.016. [DOI] [PMC free article] [PubMed] [Google Scholar]
- 19. Cher B. A. Y., Morden N. E., and Meara E., “Medicaid Expansion and Prescription Trends: Opioids, Addiction Therapies, and Other Drugs,” Medical Care 57, no. 3 (2019): 208–212, 10.1097/MLR.0000000000001054. [DOI] [PMC free article] [PubMed] [Google Scholar]
- 20. Zhang H., Tallavajhala S., Kapadia S. N., et al., “State Opioid Limits and Volume of Opioid Prescriptions Received by Medicaid Patients,” Medical Care 58, no. 12 (2020): 1111–1115, 10.1097/MLR.0000000000001411. [DOI] [PMC free article] [PubMed] [Google Scholar]
- 21. Barenie R. E., Sinha M. S., and Kesselheim A. S., “Factors Affecting Buprenorphine Utilization and Spending in Medicaid, 2002‐2018,” Value in Health 24, no. 2 (2021): 182–187, 10.1016/j.jval.2020.04.1840. [DOI] [PubMed] [Google Scholar]
- 22. Barenie R. E., Kesselheim A. S., Tsacogianis T., and Fischer M. A., “Associations Between Copays, Coverage Limits for Opioid Use Disorder Medications, and Prescribing in Medicaid, 2018,” Medical Care 59, no. 3 (2021): 266–272, 10.1097/MLR.0000000000001494. [DOI] [PubMed] [Google Scholar]
- 23. Keshwani S., Maguire M., Goodin A., Lo‐Ciganic W. H., Wilson D. L., and Hincapie‐Castillo J. M., “Buprenorphine Use Trends Following Removal of Prior Authorization Policies for the Treatment of Opioid Use Disorder in 2 State Medicaid Programs,” JAMA Health Forum 3, no. 6 (2022): e221757, 10.1001/jamahealthforum.2022.1757. [DOI] [PMC free article] [PubMed] [Google Scholar]
- 24. Qian J., Khatiwada A. P., and Xue X., “Did the 2021 Federal Change in the Practice Guidelines for the Administration of Buprenorphine for Treating Opioid Use Disorder Increase Buprenorphine Prescription Dispensing in Medicaid Population?,” American Journal on Addictions 33, no. 3 (2024): 335–338, 10.1111/ajad.13505. [DOI] [PubMed] [Google Scholar]
- 25. Besaw R. J. and Fry C. E., “State Drug Caps Associated With Fewer Medicaid‐Covered Prescriptions for Opioid Use Disorder, 2017‐2022,” Health Affairs Scholar 2, no. 12 (2024): qxae165, 10.1093/haschl/qxae165. [DOI] [PMC free article] [PubMed] [Google Scholar]
- 26. Korst M. R., Santos Teles M., Choudhry H. S., et al., “Characterizing Opioid Prescribing Trends of Medical Oncologists From 2013 to 2019: Analysis From the Centers for Medicare & Medicaid Services Medicare Part D Prescribers Database,” JCO Oncology Practice 20, no. 2 (2024): 268–277, 10.1200/OP.23.00285. [DOI] [PubMed] [Google Scholar]
- 27. Alsultan M. M. and Guo J. J., “Utilization, Spending, and Price of Opioid Medications in the US Medicaid Programs Between 1991 and 2019,” Am Health Drug Benefits 15, no. 1 (2022): 31–37. [PMC free article] [PubMed] [Google Scholar]
- 28. Bradford A. C. and Bradford W. D., “Medical Marijuana Laws Reduce Prescription Medication Use in Medicare Part D,” Health Affairs (Project Hope) 35, no. 7 (2016): 1230–1236, 10.1377/hlthaff.2015.1661. [DOI] [PubMed] [Google Scholar]
- 29. Aitken M., Kleinrock M., Campbell A., and Muñoz E., Prescription Opioid Trends in the United States (IQVIA Institute, 2020), 24, https://www.iqvia.com/‐/media/iqvia/pdfs/institute‐reports/prescription‐opioid‐trends‐in‐the‐united‐states/iqi‐prescription‐opioid‐trends‐in‐the‐us‐1220‐forweb.pdf?_=1664160974509. [Google Scholar]
- 30. The Pandas Development Team , “pandas‐dev/pandas: Pandas,” 2024, 10.5281/ZENODO.10957263. [DOI]
- 31. U.S. Department of Justice Drug Enforcement Administration, Diversion Control Division , Data From: Automation of Reports and Consolidated Orders System (ARCOS Retail Drug Summary Reports, 2025), https://www.deadiversion.usdoj.gov/arcos/retail_drug_summary/arcos‐drug‐summary‐reports.html. [Google Scholar]
- 32. “Tabula — Tabula‐Py Documentation,” accessed February 3, 2025, https://tabula‐py.readthedocs.io/en/latest/tabula.html.
- 33. “State Drug Utilization Data | Medicaid,” accessed February 3, 2025, https://www.medicaid.gov/medicaid/prescription‐drugs/state‐drug‐utilization‐data/index.html.
- 34. U.S. Food and Drug Administration , “National Drug Code Directory,” accessed January 20, 2025, https://dps.fda.gov/ndc.
- 35. Centers for Medicare and Medicaid Services , “Medicare Part D Prescribers,” accessed January 20, 2025, https://data.cms.gov/provider‐summary‐by‐type‐of‐service/medicare‐part‐d‐prescribers.
- 36. Wickham H., Averick M., Bryan J., et al., “Welcome to the Tidyverse,” Journal of Open Source Software 4, no. 43 (2019): 1686, 10.21105/joss.01686. [DOI] [Google Scholar]
- 37. AHCCCS , “Arizona's Medicaid Reform Plan,” 2012, https://www.azahcccs.gov/shared/Downloads/News/AZReformProgressoverview.pdf.
- 38. Cabrera F. F., Gamarra E. R., Garcia T. E., et al., “Opioid Distribution Trends (2006–2017) in the US Territories,” PeerJ 7 (2019): e6272, 10.7717/peerj.6272. [DOI] [PMC free article] [PubMed] [Google Scholar]
- 39. Ighodaro E. O., McCall K. L., Chung D. Y., Nichols S. D., and Piper B. J., “Dynamic Changes in Prescription Opioids From 2006 to 2017 in Texas,” PeerJ 7 (2019): e8108, 10.7717/peerj.8108. [DOI] [PMC free article] [PubMed] [Google Scholar]
- 40. Madera J. D., Ruffino A. E., Feliz A., McCall K. L., Davis C. S., and Piper B. J., “Declining but Pronounced State‐Level Disparities in Prescription Opioid Distribution in the United States,” Pharmacy 12, no. 1 (2024): 14, 10.3390/pharmacy12010014. [DOI] [PMC free article] [PubMed] [Google Scholar]
- 41. Davis C. S., Piper B. J., Gertner A. K., and Rotter J. S., “Opioid Prescribing Laws Are Not Associated With Short‐Term Declines in Prescription Opioid Distribution,” Pain Medicine 21, no. 3 (2020): 532–537, 10.1093/pm/pnz159. [DOI] [PMC free article] [PubMed] [Google Scholar]
- 42. Collins L. K., Pande L. J., Chung D. Y., Nichols S. D., McCall K. L., and Piper B. J., “Trends in the Medical Supply of Fentanyl and Fentanyl Analogues: United States, 2006 to 2017,” Preventive Medicine 123 (2019): 95–100, 10.1016/j.ypmed.2019.02.017. [DOI] [PMC free article] [PubMed] [Google Scholar]
- 43. U.S. Food and Drug Administration , “Timeline of Selected FDA Activities and Significant Events Addressing Opioid Misuse and Abuse,” 2022, accessed August 9, 2022, https://www.fda.gov/drugs/information‐drug‐class/timeline‐selected‐fda‐activities‐and‐significant‐events‐addressing‐opioid‐misuse‐and‐abuse.
- 44. Larochelle M. R., Zhang F., Ross‐Degnan D., and Wharam J. F., “Rates of Opioid Dispensing and Overdose After Introduction of Abuse‐Deterrent Extended‐Release Oxycodone and Withdrawal of Propoxyphene,” JAMA Internal Medicine 175, no. 6 (2015): 978–987, 10.1001/jamainternmed.2015.0914. [DOI] [PubMed] [Google Scholar]
- 45. Harris S. C., Perrino P. J., Smith I., et al., “Abuse Potential, Pharmacokinetics, Pharmacodynamics, and Safety of Intranasally Administered Crushed Oxycodone HCl Abuse‐Deterrent Controlled‐Release Tablets in Recreational Opioid Users,” Journal of Clinical Pharmacology 54, no. 4 (2014): 468–477, 10.1002/jcph.235. [DOI] [PMC free article] [PubMed] [Google Scholar]
- 46. Jones C. M., Christensen A., and Gladden R. M., “Increases in Prescription Opioid Injection Abuse Among Treatment Admissions in the United States, 2004–2013,” Drug and Alcohol Dependence 176 (2017): 89–95, 10.1016/j.drugalcdep.2017.03.011. [DOI] [PMC free article] [PubMed] [Google Scholar]
- 47. “2009 Florida Statues Title XLVI Chapter 893 Section 055,” http://www.leg.state.fl.us/statutes/index.cfm?mode=View%20Statutes&SubMenu=1&App_mode=Display_Statute&Search_String=Prescription+drug+monitoring+program&URL=CH0893/Sec055.HTM.
- 48. Piper B. J., McCall K. L., Kogan L. R., and Hellyer P., “Assessment of Controlled Substance Distribution to U.S. Veterinary Teaching Institutions From 2006 to 2019,” Frontiers in Veterinary Science 7 (2020): 615646, 10.3389/fvets.2020.615646. [DOI] [PMC free article] [PubMed] [Google Scholar]
- 49. Fazel‐Zarandi M. M., Feinstein J. S., and Kaplan E. H., “The Number of Undocumented Immigrants in the United States: Estimates Based on Demographic Modeling With Data From 1990 to 2016,” PLoS One 13, no. 9 (2018): e0201193, 10.1371/journal.pone.0201193. [DOI] [PMC free article] [PubMed] [Google Scholar]
- 50. Rich S., Díez M. S., and Vongkiatkajorn K., How to Download and Use the DEA Pain Pills Database (Washington Post, 2019), https://www.washingtonpost.com/national/2019/07/18/how‐download‐use‐dea‐pain‐pills‐database/. [Google Scholar]
Associated Data
This section collects any data citations, data availability statements, or supplementary materials included in this article.
Data Availability Statement
ARCOS data is publicly accessible at https://www.deadiversion.usdoj.gov/arcos/retail_drug_summary/arcos‐drug‐summary‐reports.html. Medicaid State Drug Utilization Data is publicly accessible at https://www.medicaid.gov/medicaid/prescription‐drugs/state‐drug‐utilization‐data/index.html. Medicare Part D Prescribers data is publicly accessible at https://data.cms.gov/provider‐summary‐by‐type‐of‐service/medicare‐part‐d‐prescribers. Scripts and data used for this study can be found at https://github.com/solgamaj/ARCOS‐MEDICAID‐MEDICARE.
