Project 06 / The BarberGame

Washington Shop Directory.

A statewide discovery and Bronze-data effort: identifying barber shops, assembling source-backed business records, reconciling duplicates, and making them usable across BarberGame.

Checkpoint: November 10, 2026 · Rudy's candidate batch in dry-run review · No import applied

351WA records scanned in active database
187Imported locations in three completed chain batches
14Rudy's candidate records researched
12Potential new Rudy's records, not yet inserted

What we're building

The Washington directory is the reference dataset for customer shop discovery and later booking experiences. Our Bronze standard captures the shop name, type, address, phone, website, published hours when confirmed, a short description, highlights, source URL, provenance, status, and coordinates when available.

Public business facts are kept distinct from verified operating status. New corporate-directory imports are staged as entered / awaiting confirmation rather than treated as verified shops.

Completed work

  • Established Washington shop intake and review workflows, with a separate editable original-corpus database.
  • Imported 113 Great Clips, 37 Supercuts, and 37 Sport Clips Washington locations in the confirmed three-chain checkpoint.
  • Preserved corporate source links and planned duplicate checks and verification status for imported records.
  • Researched a 14-location Rudy's Barbershop Washington candidate batch, and prepared WA-RUDYS-001 CSV plus a read-only-first Python duplicate checker.
  • Located the working SQLite database after an earlier test pointed at an empty file outside the data/ folder.
  • Ran the Rudy's dry-run against 351 current WA records: 12 proposed new, 2 held as existing/possible duplicates (Ballard and Tacoma–Proctor).

The 187 imported chain locations are a historical checkpoint count, not an assertion that the other 164 records are all independently verified.

Latest checkpoint

WA-RUDYS-001 — research and duplicate-check stage. The two existing Rudy's entries are preserved. The 12 new candidates span Seattle, Redmond, and Kirkland. No live insert has been performed.

CategoryCountDisposition
Rudy's researched candidates14Review
Already present / possible duplicates2Hold, reconcile
Not matched by current duplicate rules12Verify before import

One former Bellevue Rudy's location was identified as closed and excluded from this candidate batch. A duplicate-check pass does not itself establish business activity, completeness, rights to reuse source material, or readiness for publication.

Where the work lives

Development repository: jcricedesign/barber-directory

Designworks local project:

~/designworks/projects/barber-directory/

Working WA corpus database:

~/designworks/projects/barber-directory/data/barbergame-original.sqlite3

Historic chain-import checkpoint: v0.6.5-three-chain-imports
Checkpoint backup: backups/v065-three-chain-imports/barbergame-original.sqlite3

Rudy's staging package on Designworks:

~/Downloads/rudys-bronze/
  README.md
  rudys_wa_bronze_candidates.csv
  review_and_import.py

Website project index: ai-website-test/barber-game

Next steps

  1. Validate the 12 proposed Rudy's additions for current activity, street addresses, phone numbers and source provenance; leave missing hours or coordinates blank until independently established.
  2. Resolve business-data use permissions or verify the needed facts through independently permissible sources before publishing a commercial directory based on corporate-site material.
  3. Back up the active SQLite database. Re-run the read-only comparison, review possible duplicates manually, and only then approve eligible inserts.
  4. Apply, audit and checkpoint: run the import only after validation; verify counts and records, then tag or commit a new reproducible checkpoint.
  5. Continue chain coverage: Roosters, Floyd's 99, HairMasters, followed by other regional chains and broader verification work.

Do not use --apply until validation and rights review are complete.

Resume from here

On Designworks, run the existing safe dry-run against the active database:

cd ~/Downloads/rudys-bronze
python3 review_and_import.py \
  --db ~/designworks/projects/barber-directory/data/barbergame-original.sqlite3

The last output was: “Scanned 351 WA shops; candidates=14, proposed_new=12, held=2.” This is the handoff point for the next work session.