# Deployer per pool (#250)
- Where: research-box /opt/sw/deployer/deployer.db, table `deployer(pool, deployer, nonce, created_tx, created_t, got_t)`. Service `deployer` (polls v3live.db read-only every 5 s, fills new pools within seconds; guard entry in feedguard.py). v3live.db itself is NOT modified (side table; `pools.creator` stays empty).
- Coverage: all 8,720 pools in v3live.db (created_t 1791265315..1791570038, ~6 Oct on) filled 9 Oct 18:26 UTC; 6,590 distinct deployers; top deployer 161 pools. deployer = tx.from of created_tx, lowercase; nonce = that tx's nonce.
- Snapshot CSV: http://159.223.88.168/hx-c9ois/ppfeeds/deployer-250.csv (live data only in the db).
- Query: `sqlite3 /opt/sw/deployer/deployer.db "select d.deployer,count(*) from deployer d group by 1 having count(*)>1"`; join with v3live.db via ATTACH on pool.
- v4: v4tape pools.jsonl already has tx_from + nonce for pools from 18:15 UTC 9 Oct (no backfill).
- NOT done: backfill of v3 creations 12 Sep-6 Oct (v3live.db has no pools before 6 Oct; needs a PP Data log scan); liq `add` events with signer (v3live.py liq logging gap, only 78 adds) - separate item if wanted.