Source: pharmacy locations are retail pharmacies listed in Medicare Part D plan networks (CMS, October 2026), matched to the federal NPI registry (November 2026) and deduplicated by address. Population comes from the Census Bureau's ACS 2019 to 2023 five-year estimates. Tools: Python for the data and D3 for the map, built with an AI coding assistant (Claude).
The map shows residents divided by community pharmacies in each county, in five bands that each hold a fifth of counties. Nationally there is one community pharmacy for about every 5,700 residents. The darkest fifth of counties is home to 78 million people. The lightest fifth is home to 20 million.
Among counties of 250,000 residents or more, the highest ratios are all in California: Alameda, San Mateo, Solano, San Joaquin and Merced, each above 10,900 residents per pharmacy. The lowest are Queens (2,624), Brooklyn, Hudson County NJ, Manhattan and Wayne County MI.
Caveats. The count ran 3% to 13% below state license lists in the three states I checked, so neighbors in the ranking are roughly tied. Health systems that run their own pharmacies, common in California, can make a county look darker than the access its residents have. Gray counties have no community pharmacy in this data. That can be a real gap or a data gap, because Indian Health Service and military pharmacies are counted separately.
Methodology and limits: https://headless-izjfcjqvfnv-professionaltempla-1412.wix-site-host.com/methodology
Interactive version with a page for each county: https://headless-izjfcjqvfnv-professionaltempla-1412.wix-site-host.com