# #1259 #1047 #1260 names + births (ppdata, 11 Oct)
## Token names (#1259)
/opt/sw/nm2.db (copy /opt/ppcopy/nm2.db), table nm2(tok, name_lc, symbol, decimals, supply, pool_t_first, name). 19,485 tokens = every token in radar pool_paths + radar_hist (13 Sep to 10 Oct), 19,479 with a name. supply = raw totalSupply string, pool_t_first = earliest pool t_first/cross t seen. Index nm2_n(name_lc, pool_t_first): clone order = count of rows with same name_lc and pool_t_first < this one.
Daily refresh: cron 03:47 UTC (nm2.py picks up new tokens; it refreshes pool_t_first). Free rpcpool only. Note tokmeta.db untouched (live feeds).
## Births (#1047, #1260)
/opt/sw/births.db (copy /opt/ppcopy/births.db), pool_births(pool, venue, quote, fee, hooks, token, created_t, first_swap_t, created_src, created_block, create_tx, launcher, creator, name, symbol, supply, decimals). ~410k pools.
- created_t from 20 Sep on = TRUE on-chain create block time (v4 Initialize / v3 PoolCreated, poolsnew + dataeng2 poolsx), created_src='chain_create'. 13-20 Sep: token_born (first pool per token only), created_src='token_born:*'.
- launcher = to-address of the create tx, creator = from-address (createtx.db). Filled for v3 and v4 (~98%); v2/pons mostly NULL (no create-tx data).
- name/symbol/supply: only where the token is in nm2 (radar tokens, 63k pools have none because they never reached the radar).
- Coverage ends: poolsnew 9 Oct 13:26; poolsx (dataeng2) 10 Oct 11:34 (v3/v4 only); createtx.db 9 Oct 18:12. first_swap_t from canon_pools (to 9 Oct 06:44). Refreshed daily 03:47 UTC with the same cron (daily.sh).
Example launcher novelty: select launcher, count(*), min(created_t) from pool_births where venue='v4' group by 1 order by 2 desc limit 20;