Data Scrape - Dog Groomers and Veterinarians in SoCal

I need a complete, deduplicated list of the following businesses from Google My Business and Yelp.com for Los Angeles, Orange, San Bernardino and Riverside counties.

1. Mobile Groomers
2. Dog Groomers
3. Pet Shops / Pet Supply Stores
4. Pet Boarding / Daycare Facilities
5. Animal Shelters / Humane Societies / Rescues
6. Equine & Exotic Pet Services
7. Veterinarian
8. Pet Hospital

Deliver a clean spreadsheet with verified contact info and key attributes. This list will be used for marketing outreach.

Deliverables

1) Master Spreadsheet (Google Sheets or CSV):
Required columns (in this order):

Business Name

Category (Dog Groomer / Veterinarian)

Street Address

City

State

ZIP

County

Phone (main)

Email (public/business)

Website URL

Instagram URL

Facebook URL

Notes (e.g., “mobile-only”, “new patient waitlist”, “house-call vet”, etc.)

Source(s) (comma-separated: “Google Maps; Yelp; State board; Website”)

2) Duplicates Removed:

Merge same business across multiple sources/locations.

If multiple locations for the same brand, keep each location with its unique address.

3) Data Quality Report (1–2 pages):

Sources used & methodology

Known gaps/limitations

Count by county & category

De-dupe logic summary

Any emails obtained and method (site scrape, contact page, etc.)

Scope & Expectations

Coverage: Aim for 100% of active groomers & vets in the four counties. Include mobile groomers and house-call vets if they clearly serve those counties.

Verification: Visit official websites where possible to confirm phone, email, hours.

Accuracy: Minimum 95%+ accuracy on address/phone/website.

Freshness: Data captured during the engagement; no lists older than 90 days.

Compliance: Follow each source’s terms; no hacking/bypassing captchas/rate limits. Respect robots.txt and anti-abuse guidelines.

Suggested Sources (non-exhaustive)

Google Maps / Google Business Profiles

Yelp, Facebook Pages

Business websites and contact pages

Instagram bios (for groomers, mobile groomers)

Output Format

Primary: Google Sheet (shared)

Backup: CSV export

Clean text (no line breaks in cells unless in “Notes”)

Phone in (###) ###-#### format

State = “CA”

ZIP = 5 digits (leading zeros preserved)

Milestones

Sample & Approach (10%) — Provide a test sample of 50 rows (mix of all 4 counties; 25 groomers / 25 vets). I will review for format, accuracy, and de-duplication.

50% Delivery (40%) — Half of total rows, quality checked. Fix any issues.

Final Delivery (50%) — Full, cleaned dataset + Data Quality Report.

Acceptance Criteria

No obvious duplicates (same name+address+phone).

Emails valid/sane (no personal emails unless publicly listed as business contact).

All links clickable and working.

Counties correctly assigned.

At least 85% of entries include website OR a social link (Instagram/Facebook) if no website exists.

What to Include in Your Bid

Brief summary of your scraping method & tools (e.g., Python + requests/BeautifulSoup/Scrapy; Sheets API; your enrichment workflow).

A recent, relevant sample (local business scrape) with 10–20 rows (mask names if needed).

Estimated row count you expect (by county, rough numbers).

Confidentiality

Any acquired data is for my internal use. Please agree not to resell or republish.