Yellow Pages Scrape for Canada and/or US for Specific Categories

  • Status Closed
  • Budget N/A
  • Total Bids 18

Project Description

I have a new website that will offer a new shopping experience target towards local search. I am trying to create a directory/database of local business' in Canada and the US. I need a professional scraper who has experience capturing this information.

I need the following information and organized in this order:

Country | State/Province | City | Category | Sub Category | Business Name | Business Address | Phone Number | Street/Unit/Block | Postal Code (zip code) | Map coordinates (longitude and latitude) | Website URL | Email address | Business Description | Up to six descriptive keywords | Up to three alternate location descriptions.

The target websites to capture this information is [url removed, login to view] (Canada) and [url removed, login to view] (USA). [url removed, login to view] (Canada), [url removed, login to view] (USA), [url removed, login to view] (USA). [url removed, login to view] (Canada) and [url removed, login to view] (USA).

The Categories (as laid out by these sites) I need are:


Accessories, New and Used Dealers, Motorcycles, Motorized Vehicles, Parts and Supply, Repairs - Bodywork, Repairs - Mechanical, Trailers, Related Services, Detailing and Aesthetics

Business and Professional Services:

Administrative and Specialty Services, Consultants, Furniture and Office/Industrial Machines, Import and Export Services, Marketing and Sales, Printing/Publishing/Copying, Engineers Consulting

Computers, Communications, Electronics:

Communication Services and Equipment, Computer Equipment, Computer Services, Electronics Services and Equipment, Internet

Family and Community:

Children and Child Care, Pet Services

Finance and Legal:

Accounting Services, Banks and Financial Services, Investment Services, Loans and Credit Services, Retirement and Financial Planning, Taxes, and Legal

Personal Care:

Barbers Beauty Salons and Spas, Skin and Scalp Services and Products

Real Estate and Insurance:

Building Management, Real Estate, Insurance

Travel and Lodging:

Travel Agencies

Construction and Renovation:

Concrete Cement and Paving, Contractor Equipment and Services, Electrical Products and Services, Floors Ceilings and Roofs, Hardware Supplies and Services, Inspectors and Surveyors, Plumbing and Piping, Chimneys, Painting and Plastering, Foundations and Piling, Heavy Construction and Equipment

Home and Garden:

Appliances, Cabinets Racks and Organizers, Cleaning Supplies and Services, Cooling and Ventilating, Doors, Furniture, Garden and Lawn, General Supplies and Services, Heating, Interior Decorating, Kitchen and Bath Supplies and Services, Lighting, Moving and Storage, Outdoor Accessories and Equipment, Outdoor Services, Painting Floor and Wall Coverings, Safety and Security, Windows, Pest Control, Bedrooms and Linens

I expect there to be several 1,000,000+ records. If possible I would like them in mysql, if not in csv, or both. The data must be accurate and run through a deduplication software to weed out duplicate records. This Job is large and could be ongoing with the right person. Must speak english and must be an expert in this field. The job doesn't have to start immediately and can be set up to be convenient for both parties.

When submitting a bid please indicate whether its for Canada, USA, or Both.

Get free quotes for a project like this

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online