U.S. Pharmacies Database

57,986 pharmacy location records for research and integration Search pharmacy business names, compare local coverage, organize outreach records, and build address-based directories with the ...

Ready for your workflow

Flexible data delivery

Delivered files
UTF-8 CSV, JSON, SQLite, schemas, samples, statistics, documentation, and tier-specific ZIP bundles.
Updates
Current release 2.0.0 dated September 5, 2026. Update eligibility follows the selected license.
Preview sample data
Choose your licensePurchase once. Download immediately.
Secure checkout
UsagePharmacy location names, addresses, phone and fax details, NPIs, and retail/mail indicators.
$60.00
MasterEverything in Publication plus reported license references and separately dated historical contacts.Current update offer$15.00For eligible earlier Master purchases
$220.00
Records
57,986
Version
2.0.0
Release date
Sep 5, 2026
Before you choose
Explore the samples
U.S. Pharmacies Database List

U.S. Pharmacies Database v.2.0.0

57,986 Pharmacies

U.S. Pharmacies Database catalog icon U.S. Pharmacies Database Download
U.S. Pharmacies Database artwork

57,986 pharmacy location records for research and integration

Search pharmacy business names, compare local coverage, organize outreach records, and build address-based directories with the U.S. Pharmacies Database. The release covers all 50 states, Washington, DC, Puerto Rico, Guam, the Northern Mariana Islands, and the U.S. Virgin Islands.

Practical location and business details

Each location includes a stable pharmacy ID, business name, legal name, primary organization NPI, street address, city, state, postal code, telephone, fax when reported, and retail or mail-order network indicators. Related tables preserve additional identifiers and reported names without inflating the location count.

Choose the data depth you need

  • Usage, $60: 57,986 pharmacy location records.
  • Publication, $110: all Usage data plus 58,002 provider identifier records, 52,293 reported names, and 58,002 network profiles.
  • Master, $220: all Publication data plus 39,451 reported license references and 22 separately dated historical contact records.

Matching formats in every tier

Each tier includes UTF-8 CSV, JSON, SQLite, schema files and documentation. Related records join through pharmacy_id. Text identifiers preserve leading zeroes, and blanks identify unreported values. Review a separate sample for every table before choosing your tier.

Understand coverage before use

This is a dated directory snapshot, not an exhaustive list of U.S. pharmacies. A record does not certify current opening hours, operation, professional licensure, accreditation, clinical quality, or insurance acceptance. Network presence and preferred indicators refer to one or more plans in the stated period and can change. Specialty and institutional pharmacy coverage varies. No qualifying American Samoa record is included. Contact details are reported business details, not tested contactability. License references are reported identifiers unless expressly marked with an active board match; they are not nationwide credential verification. Historical contacts are explicitly dated 2014 and unverified.

57,986 Pharmacies Records
SAMPLE DATA TABLE STRUCTURE RECORD INFO
Hospitals Nursing Homes Retirement Homes Home Care Agencies

License Database Purchase Options

MASTER

Master

$220.00

Client dataset handoff

All Publication rights, plus raw or transformed dataset handoff within a genuine client project. Standalone dataset resale requires a separate addendum.

Current Master update offer$15.00For an eligible earlier Master purchase. The fee is checked again when a new release is available.

Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.

Read the complete Oddity Software Master License

Choose this package above

Table Schema Database Field Statistics

Release structure

U.S. Pharmacies Database

Review the published tables, record coverage, and field names included with release 2.0.0.

Database
#17
Version
2.0.0
Format
XML schema

Data dictionary

Tables and fields

Release-defined structure
TableRecordsFields
pharmacies57986pharmacy_id, pharmacy_name, legal_business_name, primary_npi, address_line_1, address_line_2, city, state_code, postal_code, telephone, fax, retail_network_reported, mail_order_network_reported
pharmacy_identifiers58002identifier_id, pharmacy_id, npi, registered_name, registration_updated_date
pharmacy_names52293name_id, pharmacy_id, npi, reported_name, name_type, reported_created_date
network_profiles58002profile_id, pharmacy_id, npi, listed_plan_count, retail_reported, mail_order_reported, preferred_retail_in_one_or_more_plans, preferred_mail_in_one_or_more_plans, network_period
license_references39451license_reference_id, pharmacy_id, npi, state_code, reported_license_number, reference_status, expiration_date
historical_contacts22contact_id, pharmacy_id, contact_type, contact_value, information_date, information_status

Release at a glance

What is inside this database

57,986 pharmacy location records with business names, addresses, telephone numbers, retail and mail-order indicators, and related provider details.

57,986Pharmacy locations
55States and territories
58,002Provider identifiers
52,293Reported names
pharmacy_id
Distinct
57,986
Missing
0.0%
pharmacy_name
Distinct
50,298
Missing
0.0%
legal_business_name
Distinct
20,792
Missing
0.0%
primary_npi
Distinct
57,986
Missing
0.0%
address_line_1
Distinct
57,343
Missing
0.0%
address_line_2
Distinct
1,852
Missing
93.4%
city
Distinct
7,754
Missing
0.0%
state_code
Distinct
55
Missing
0.0%
postal_code
Distinct
54,572
Missing
0.0%
telephone
Distinct
56,412
Missing
0.0%
fax
Distinct
38,404
Missing
31.7%
retail_network_reported
Distinct
2
Missing
0.0%
mail_order_network_reported
Distinct
2
Missing
0.0%

Geographic coverage

This release represents 55 state or territory codes. The 12 largest totals are shown below.

  • CA5,045
  • TX4,666
  • NY4,469
  • FL4,422
  • PA2,055
  • MI2,022
  • OH1,976
  • GA1,968
  • IL1,898
  • NC1,847
  • NJ1,784
  • TN1,395

Table and column statistics

Select a table to review its own schema, record total, fields, distinct values, and missing-value coverage.

pharmacies57,986 records · 13 fields
pharmacy_id
Distinct
57,986
Missing
0 (0.0%)
pharmacy_name
Distinct
50,298
Missing
0 (0.0%)
legal_business_name
Distinct
20,792
Missing
0 (0.0%)
primary_npi
Distinct
57,986
Missing
0 (0.0%)
address_line_1
Distinct
57,343
Missing
0 (0.0%)
address_line_2
Distinct
1,852
Missing
54,173 (93.4%)
city
Distinct
7,754
Missing
0 (0.0%)
state_code
Distinct
55
Missing
0 (0.0%)
postal_code
Distinct
54,572
Missing
0 (0.0%)
telephone
Distinct
56,412
Missing
0 (0.0%)
fax
Distinct
38,404
Missing
18,407 (31.7%)
retail_network_reported
Distinct
2
Missing
0 (0.0%)
mail_order_network_reported
Distinct
2
Missing
0 (0.0%)

Inspect the data

Representative sample data

Switch tables to review representative fields and rows from every table advertised for this release.

pharmaciesDownload this sample CSV
pharmacy_idpharmacy_namelegal_business_nameprimary_npiaddress_line_1address_line_2citystate_codepostal_codetelephonefaxretail_network_reportedmail_order_network_reported
USPH-1003001934LINS PHARMACYYI RUI INTERNATIONAL CORP10030019344307 8TH AVEBROOKLYNNY11232390934722109143412210915yesno
USPH-1003002254Walgreens #11113WALGREEN CO10030022545104 BOBBY HICKS HWYGRAYTN37615621742347733724234778533yesno
USPH-1003004904TEXAS ROAD PHARMACYTEXAS ROAD OLD BRIDGE LLC10030049041183 ENGLISHTOWN RDOLD BRIDGENJ08857131973272311017327231141yesno
USPH-1003004938CVS Pharmacy #00273CVS STATE CAPITAL LLC1003004938446 SABATTUS STLEWISTONME042402077833784yesno
USPH-1003007386Giant Pharmacy #6443THE GIANT COMPANY, LLC1003007386925 NORLAND AVECHAMBERSBURGPA17201420471726733047176570613yesno
USPH-1003010208Publix Pharmacy #1152PUBLIX SUPER MARKETS INC100301020811245 US HIGHWAY 301 NPARRISHFL34219867594177608909417768015yesno
USPH-1003022203TOWN & COUNTRY COMPOUNDING AND CONSULTATION SERVICES LLCTOWN & COUNTRY COMPOUNDING AND CONSULTATION SERVICES LLC1003022203535 E CRESCENT AVERAMSEYNJ07446292220144720202014473253yesno
USPH-1003024357WAL-MART PHARMACY 10-3337WAL-MART STORES EAST LP10030243573159 ROUTE 9 SRIO GRANDENJ0824210126094654497yesno
USPH-1003030602MOUNTAIN VIEW HOSPITAL PHARMACYMOUNTAIN VIEW HOSPITAL PHARMACY10030306021000 E 100 NPAYSONUT8465180146570978014657410yesno
USPH-1003030636HEB Pharmacy #094H-E-B, LP10030306362409 E INTERSTATE HIGHWAY 2MISSIONTX78572100795620567559562056781yesno
USPH-1003033101CLIFTON G. ELLIOTT, LLCCLIFTON G. ELLIOTT, LLC100303310177395 LANDRY DRMARINGOUINLA70757320822562523532256253144yesno
USPH-1003034844OJAI VALLEY COMMUNITY HOSPITAL PHARMACYOJAI VALLEY COM HOSPITAL PHCY10030348441306 MARICOPA HWYOJAICA93023313180564022448056462498yesno
USPH-1003036385Big Y Pharmacy #31BIG Y FOODS, INC.100303638570 WAUREGAN RDDANIELSONCT06239371286077474378607740391yesno
USPH-1003037219Publix Pharmacy #1158PUBLIX SUPER MARKETS INC100303721915502 STONEYBROOK WEST PKWYSTE 100WINTER GARDENFL34787476740765466034076546650yesno
USPH-1003038324WALGREENS #12689WALGREEN CO1003038324902 S GLOSTER STTUPELOMS38801631266284413186628412097yesno
USPH-1003041674WALGREENS #12744WALGREEN CO1003041674108 S POPLAR STPANAIL62557140421756227702175622778yesno
USPH-1003047846WALGREENS #12168WALGREEN CO10030478463929 KITSAP WAYBREMERTONWA98312245136091710413609171047yesno
USPH-1003048505WALGREENS #12053WALGREEN CO10030485056400 W NOB HILL BLVDYAKIMAWA98908192950996505415099650895yesno
USPH-1003051129Family Care Specialty PharmacyFCRX SC INC10030511292760 CELANESE RDROCK HILLSC29732940680398153308039815333yesno
USPH-1003051145CVS Pharmacy #00912GARFIELD BEACH CVS, L.L.C.10030511452175 E BARDSLEY AVETULARECA9327461455596850123yesno

57,986 location records across 55 states and territories. Usage contains pharmacies. Publication adds pharmacy_identifiers, pharmacy_names and network_profiles. Master adds license_references and historical_contacts. All tiers contain matching CSV, JSON and SQLite files.

Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.

Need a closer fit?

Data shaped around your project.

Tell us your topic, geography, and required fields. We can help find a match or scope a custom package.
Discuss your data needs Explore the catalog

A clear path from download to project

Get more from your data

Understand the files, check the sample coverage, and choose the license that fits your use.

Database guides and examples Working with file formats Samples and record counts Licenses and permitted use Ask about this database

Oddity Support

How can we help?

Browse all Help topics

Oddity Data Updates

Know when fresh data arrives.

Receive occasional notices about new and substantially updated database releases. No third-party mailing list.

Oddity Software

Details