I am looking for a list in ASCII or Excel format of all retail
pharmacies(name, address, state, zip code, phone number, fax) in the
United States.

Hi ljgordon,

It looks like you'll have to purchase a list of all pharmacies, and
that could be somewhat expensive (but possibly worth it, depending on
your purpose).  I am listing several options for you below:

Orthopedic Surgeons Mailing Lists
http://www.geocities.com/orthopedicslist/
This page (also found by jackburton, below) lists several datasets for
sale from the Doctor's Marketing Service.  The USA Pharmacies List
will cost you
$1,095 for 75,000 records (each includes name, address, and phone/fax
number).

U.S. Pharmacist
http://www.uspharmacist.com/
This trade magazine rents its subscriber list in units of 5,000 names.
 The pricing depends on the file format, transmission, sorting
options, and other options.  Go to the "rent list" link to get
information and a contact name for ordering.  You can choose to
purchase just the subscriber areas in which you are interested or the
entire list of 100,000+ names.

I found these two links by using a variety of Google searches using
the following keywords:

"USA pharmac*" or "US pharmac*"
list or directory
ascii or excel


If neither of the above lists work for you, you can also try
purchasing membership lists from the various associations to which
pharmacists belong.  They include:

The National Association of Chain Drug Stores
http://www.nacds.org/

American Pharmaceutical Association
http://www.aphanet.org/

National Association of Boards of Pharmacy
http://www.nabp.net/

I found these using the Google Directory level Health > Pharmacy >
Organizations (at http://directory.google.com/Top/Health/Pharmacy/Organizations/).

librariankt

---

Request for Answer Clarification by ljgordon-ga on 23 Oct 2002 19:14 PDT

This really didn't answer my question.

---

Clarification of Answer by librariankt-ga on 23 Oct 2002 21:13 PDT

I'm sorry that you feel I haven't answered your question.  You stated
that you were looking for a list in ASCII or Excel format of all US
pharmacies.  To the best of my abilities I have determined (as have,
from the comments below, other researchers) that such a list is not
available free on the web, but must rather be purchased.  Since the
purchase price of both lists that I found far exceed the amount you're
willing to pay, I cannot purchase them (neither would I be technically
able to attache the files to an answer, even were I able to purchase
them).  I found what I felt were the best (if not only) two sources to
purchase lists in ASCII or Excel format of US pharmacies.  I thought I
had answered the question - I've found you two sources of ASCII lists
of tens of thousands of US Pharmacies, with full contact information.

Please let me know where I missed the boat so that I can try to get
back on it.  :)

librariankt

My question was for someone to find a complete list of pharmacies in a
specific format.  The question was not answered, I was just pointed to
a place to get the answer that I had already.

My question wasn't answered.

A note for anybody tackling this question: according to the "National
Community Pharmacists Association", there are over 55,000 pharmacies
in the United States. So your number should be close to this.

You can obtain a ASCII list of 73,833 pharmacies in the USA from thius site:
http://www.geocities.com/orthopedicslist/

Price of full list is $1,095 (about 1.5¢ /Record).
You can also order lists from individual states at a rate of 10¢ /Record