all pharmacy listings sorted by country

Looking to get pharmacy listings sorted by country in a particular format. I will give you the cities and states with particular ID and you will give me a list of pharmacies that are linked to those ID's. We currently have a list for USA, Germany, and someone working on Australia, NZ, and UK. So, that leaves the ret of the world for you guys to choose from. We want to eventually have the entire world and will tackle the project one country at a time. You choose a country, and we will place a private bid for you with that country. Basically you will just have to parse the various online telephone books etc. More details on the format etc below: Table Name - tblCity ------------------------ 3 UID int 4 0 0 Country_Code varchar 255 1 0 State_Code varchar 255 1 0 City_Name varchar 255 1 0 Disabled int 4 1 Table Name - tblCountry --------------------------- 3 UID int 4 0 0 Country_Code varchar 255 0 0 Country_Name varchar 255 0 0 Disabled int 4 0 Table Name - tblAdressListings ------------------------- 3 UID int 4 0 0 CityID int 4 0 0 ListingTitle varchar 255 0 0 ListingNumber varchar 50 1 0 ListingAddress varchar 255 1 0 Disabled int 4 0 Your best bet would be to parse through some yellow pages sites to get the data. We would like in a format whereby we can import into MS SQL. We will then display the results in a format similar to this: Westbriar > Virginia > United States Westbriar Pharmacy Sam's Club Pharmacy 9440 W Broad St Richmond, VA (804) 747-9160 Ukrop's Pharmacy Shoppes At Crossridge Richmond, VA (804) 755-6207 Costco Pharmacy 9650 W Broad St Glen Allen, VA (804) 273-9276 ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform data parsing