# Research log — Russell 3000 strategic project database

| Date | Decision / event | Owner | Status |
|---|---|---|---|
| 2026-05-25 | S&P 500 universe cached (Wikipedia table) | team | done |
| 2026-06 | SPID release 1: 500 issuers, 153,894 sections, 39,930 mentions, 19,227 projects (gpt-4o-mini) | team | done |
| 2026-10-27 | Extension to Russell 3000 requested; universe = iShares IWV holdings (23 Oct 2026) as proxy — **decision: snapshot estimand, no historical membership** | SPB | done |
| 2026-10-27 | Distributed build (10 cluster nodes + 1 external gateway); contiguous CIK shards rebalanced after 1 h (interleaving) | SPB | done |
| 2026-10-27/28 | Full LLM extraction of 968,134 new sections (48 workers), ≈ 775 USD total | SPB (authorised by SPB) | done |
| 2026-10-28 01:10–06:22 | OpenAI credit exhaustion → 149,352 ledger rows with 0 mentions removed and re-run; **decision: add `call_status` to the ledger** | SPB | rows fixed; schema change proposed |
| 2026-10-28 | Merge, factors, pdb-api redeploy, French methodological report updated, WP 28 draft (English) | SPB | done |
| open | Author order and CRediT confirmation | all | **pending** |
| open | Annotation study (sample design in WP 28 §8) | all | **pending** |
| open | Linkage audit; probabilistic linker | to assign | pending |
| open | Amount typing pass; 8-K exhibit ingestion; recall test on long MD&A | to assign | pending |
| open | Licensed Russell constituent history? | to assign | pending |