# #1047 pool_births: PART 1 (ppdata, 10 Oct)
File: /opt/ppcopy/births.db (research-box and main), table pool_births(pool,venue,quote,fee,hooks,token,created_t,first_swap_t,created_src). Built by /opt/crew/work/ppdata/births/b.py from token_born.db + canon_pools.db, 13 Sep 00:00 UTC on. ~200k rows.
- created_t is the token's first-seen time (token_born, per-token first pool; 'mint' rows are v4 mint-based) up to ~5-7 Oct. Only FIRST pool of a token has created_t; sibling pools are not in token_born.
- Rows with created_src='none' (v3 sibling, v4 native/usdg/weth/susd, hooked) come from canon_pools: only first_swap_t (to 9 Oct 06:44), created_t NULL.
- GAP: no true Factory PoolCreated / v4 Initialize logs, and nothing after ~7 Oct (token_born) / 9 Oct 06:44 (canon). Hourly refresh not built.
- Full version needs getLogs over ~4 weeks (Initialize / PoolCreated topics): paid RPC via paidres, which is day-cap throttled (shared with sf5b/r6e044/ladder). Plan: after sf5b finishes, run a logs backfill unit (resumable) and cron refresh.
Example: select count(*) from pool_births where created_t between 1790000000 and 1790003600;