# #1247 LP add/remove with owner (ppdata, 11 Oct) PART 1
File: /opt/ppcopy/liq_owner.db (research-box; copy /opt/sw/ppdata/liq_owner.db), rebuilt daily 03:47 cron. Table liq_owner(b,li,pool,tx,sender,dl,kind add|remove,salt,tid,owner,first_owner,owner_after,hooks,fee), v4 pools fee=100 hooks=0 only: 17,211 adds, 14,890 removes (10.8k pools), b = block (use liqlock.db btime for time).
Owner = holder of the position NFT (tid via salt) at that block, from nft Transfer log = the real LP owner behind position-manager 'sender'. Resolved for 85% of rows (rest: salt not mapped, e.g. direct/other routers). NOT tx.from: tx.from needs one RPC per tx (~15k removes), queued behind paid cap; owner is usually the same EOA or its contract wallet.
Example: select owner,count(*) from liq_owner where kind='remove' group by 1 order by 2 desc limit 20;