CMS Medicare Part D Prescribers (county roll-up by Data Doughnut)
Medicare prescriptions by county and drug
Every Part D drug by state and nationally, 2013 on; all prescribing by county of the prescriber's office (claims, cost, opioids, antibiotics, low-income and Medicare Advantage shares); every drug by county; and drug groups by county (GLP-1s, SGLT2s, insulins, statins, blood thinners, ADHD stimulants, antidepressants, opioid-addiction treatment, dementia drugs). Totals only — no prescriber rows.
Published by CMS Medicare Part D Prescribers (county roll-up by Data Doughnut)
Finest detail county
Tables 4
How we use this · on 1 desk
“How many opioid prescriptions are written here?”
Where you'll see it
- Region Brief: County dossier
- AI & Spreadsheets: at Level 3, link it into Excel or Google Sheets, download it, or ask your AI assistant about it
What we added
- Matched to the same county codes as every other source, so it lines up cleanly with all of them
- Every year kept since 2013
- Checked every day for a new release, and loaded when there is one
All prescribing by county
Sample of 25 rows out of about 37,629
· 15 columns
| year | county_geoid | prescribers | claims | cost | people_sum | opioid_claims | opioid_cost | antibiotic_claims | antipsych_ge65_claims | lis_claims | mapd_claims | pdp_claims | brand_claims | generic_claims |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2013 | 01001 | 68 | 223476.0 | 13902240.99 | 12773.0 | 21883.0 | 992641.49 | 9579.0 | 1108.0 | 112400.0 | 109527.0 | 113810.0 | 43178.0 | 177368.0 |
| 2013 | 01003 | 412 | 908343.0 | 56535926.01 | 85252.0 | 84807.0 | 3238298.83 | 41370.0 | 5621.0 | 347254.0 | 371750.0 | 535729.0 | 157607.0 | 718614.0 |
| 2013 | 01005 | 33 | 142189.0 | 6860236.09 | 8056.0 | 8912.0 | 221440.72 | 5032.0 | 799.0 | 79257.0 | 27236.0 | 114788.0 | 30385.0 | 108198.0 |
| 2013 | 01007 | 16 | 39331.0 | 1499357.39 | 2123.0 | 1566.0 | 27594.35 | 1055.0 | 227.0 | 25444.0 | 12052.0 | 27016.0 | 6319.0 | 32145.0 |
| 2013 | 01009 | 28 | 159803.0 | 10425737.87 | 7282.0 | 9764.0 | 223520.42 | 6310.0 | 661.0 | 90317.0 | 75039.0 | 84688.0 | 30003.0 | 127975.0 |
| 2013 | 01011 | 10 | 45385.0 | 2051471.3 | 1938.0 | 1698.0 | 29766.28 | 1489.0 | 553.0 | 35096.0 | 10997.0 | 34314.0 | 9323.0 | 35449.0 |
| 2013 | 01013 | 35 | 116229.0 | 5473809.73 | 8298.0 | 9507.0 | 231223.36 | 6058.0 | 483.0 | 69816.0 | 15092.0 | 100954.0 | 20660.0 | 93329.0 |
| 2013 | 01015 | 276 | 684364.0 | 47333645.29 | 53662.0 | 54622.0 | 2443429.67 | 27976.0 | 3695.0 | 380154.0 | 126662.0 | 553761.0 | 126337.0 | 531841.0 |
| 2013 | 01017 | 36 | 172362.0 | 8039170.94 | 9762.0 | 13628.0 | 604075.2 | 6232.0 | 985.0 | 106873.0 | 32842.0 | 139520.0 | 30693.0 | 139057.0 |
| 2013 | 01019 | 27 | 167003.0 | 8220417.2 | 7560.0 | 13610.0 | 373189.81 | 5484.0 | 872.0 | 103218.0 | 37803.0 | 129200.0 | 31262.0 | 133907.0 |
| 2013 | 01021 | 41 | 190999.0 | 8814197.03 | 10997.0 | 12316.0 | 243953.44 | 9169.0 | 1306.0 | 99816.0 | 113152.0 | 77702.0 | 28913.0 | 157355.0 |
| 2013 | 01023 | 16 | 96460.0 | 4504801.33 | 3877.0 | 7822.0 | 281986.18 | 4527.0 | 538.0 | 59645.0 | 7320.0 | 88883.0 | 17983.0 | 77381.0 |
| 2013 | 01025 | 36 | 163531.0 | 7524012.82 | 11770.0 | 10794.0 | 230075.35 | 7974.0 | 683.0 | 90377.0 | 31938.0 | 131330.0 | 27306.0 | 133566.0 |
| 2013 | 01027 | 13 | 112869.0 | 5146177.74 | 3815.0 | 8940.0 | 267021.92 | 3779.0 | 638.0 | 68894.0 | 13493.0 | 99224.0 | 21486.0 | 90165.0 |
| 2013 | 01029 | 6 | 42439.0 | 2225827.96 | 2140.0 | 3740.0 | 87878.5 | 1396.0 | 296.0 | 29535.0 | 7011.0 | 35401.0 | 7980.0 | 34114.0 |
| 2013 | 01031 | 86 | 230333.0 | 11393963.41 | 16060.0 | 18772.0 | 434939.35 | 10720.0 | 1486.0 | 127860.0 | 27064.0 | 202375.0 | 45217.0 | 181385.0 |
| 2013 | 01033 | 162 | 516993.0 | 30026208.89 | 35401.0 | 38713.0 | 953635.48 | 21722.0 | 1513.0 | 254022.0 | 65605.0 | 449113.0 | 93399.0 | 409167.0 |
| 2013 | 01035 | 15 | 126937.0 | 5674754.15 | 4850.0 | 12746.0 | 322858.75 | 6560.0 | 689.0 | 87119.0 | 14716.0 | 112221.0 | 25692.0 | 99801.0 |
| 2013 | 01037 | 1 | 2645.0 | 181257.78 | 112.0 | 47.0 | 591.77 | 76.0 | 0.0 | 1985.0 | 522.0 | 2123.0 | 627.0 | 1970.0 |
| 2013 | 01039 | 81 | 311776.0 | 15100640.08 | 16850.0 | 25403.0 | 661330.77 | 13188.0 | 2192.0 | 182589.0 | 24665.0 | 286109.0 | 56841.0 | 249740.0 |
| 2013 | 01041 | 13 | 76768.0 | 3580831.44 | 3170.0 | 5186.0 | 154355.43 | 2573.0 | 859.0 | 51225.0 | 17308.0 | 59460.0 | 16465.0 | 59675.0 |
| 2013 | 01043 | 200 | 773492.0 | 51487931.47 | 49365.0 | 59059.0 | 1838329.14 | 30332.0 | 6536.0 | 407424.0 | 178679.0 | 594184.0 | 148482.0 | 607959.0 |
| 2013 | 01045 | 62 | 127644.0 | 8193860.52 | 9575.0 | 10717.0 | 234455.14 | 5516.0 | 997.0 | 83191.0 | 16772.0 | 110426.0 | 25700.0 | 99712.0 |
| 2013 | 01047 | 90 | 382320.0 | 19073499.36 | 25127.0 | 23586.0 | 982815.81 | 11671.0 | 2384.0 | 263111.0 | 82981.0 | 299135.0 | 62898.0 | 305632.0 |
| 2013 | 01049 | 88 | 334983.0 | 16276825.13 | 19554.0 | 21618.0 | 554558.34 | 14829.0 | 1423.0 | 185008.0 | 87084.0 | 246685.0 | 61031.0 | 268823.0 |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing