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
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.
| Category | Count | Disposition |
|---|---|---|
| Rudy's researched candidates | 14 | Review |
| Already present / possible duplicates | 2 | Hold, reconcile |
| Not matched by current duplicate rules | 12 | Verify 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
- 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.
- Resolve business-data use permissions or verify the needed facts through independently permissible sources before publishing a commercial directory based on corporate-site material.
- Back up the active SQLite database. Re-run the read-only comparison, review possible duplicates manually, and only then approve eligible inserts.
- Apply, audit and checkpoint: run the import only after validation; verify counts and records, then tag or commit a new reproducible checkpoint.
- 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.