Module 02Source and score real firms3 min
Merge to one row per firm and score it
Raw pulls overlap: one firm can appear in the SEC file and a state list under two spellings. The team merges every pull into one row per firm, keyed on firm_slug plus crd_or_license, then scores each against your scorecard. You settle doubtful matches and define "close" before any ranking exists.
Run it
show me the scoring rubric and help me fill in what close means for each criterion
list-dedupe writes sourcing/master-list.csv and stops on name-only matches in sourcing/dedupe-review.md for you to mark merge or keep separate; then target-score drops must-have failures with the reason and marks the top firms to-signals. The team stops again for you to strike firms you do not want (drop_reason = user) and approve the list.
You get
pipeline/targets.csv (score, stage, drop reason) and sourcing/target-summary.md (the ranking explained, with the scorecard version used).
Watch out
- Filling the rubric after you see a ranking drifts it toward firms you already like.
- A good firm dropped for an unknown value is a scoring bug: unknown scores 1, so look for a must-have reading a blank column.
- If one must-have drops far more firms than expected, fix the rule in Step 1, not here.
Not legal, tax or investment advice. Confirm with your attorney, CPA and lender.