spb/firc0001_uqo

1# N13 export reconciliation — 2026-11-05T14:43:24-05:00 on m3u96b, rc=0, 44 s23## Byte identity of the 29 baseline CSV (commit 678d233) vs the regenerated exports4```5identical amount_dist.csv6identical companies_by_sector.csv7identical companies_by_shard.csv8identical confidence_dist.csv9identical duration.csv10identical example_provenance.csv11identical factor_tables.csv12identical filings_by_form.csv13identical filings_by_year_form.csv14identical issuers_by_year.csv15identical issuers_without_filings.csv16identical kg.csv17identical ledger_10k_items.csv18identical ledger_10q_items.csv19identical ledger_by_form.csv20identical mentions_by_form.csv21identical mentions_by_year.csv22identical mentions_per_project.csv23identical parse_status.csv24identical projects_by_first_seen_year.csv25DIFFERS   projects_by_index.csv26identical projects_by_sector.csv27identical projects_by_status.csv28identical projects_by_type.csv29identical projects_per_issuer.csv30identical sections_10k_by_item.csv31identical sections_by_form.csv32DIFFERS   top_issuers.csv33identical=26 differs=2 missing=034```3536## Differences37```38--- projects_by_index.csv392d140< False,True,93333,1992414a442> False,True,93333,199243--- top_issuers.csv449d845< MUX,MCEWEN INC,Materials,1804610a1047> MUX,MCEWEN INC,Materials,1804812d1149< CWEN,CLEARWAY ENERGY INC CLASS C,Utilities,1685014c1351< PENN,PENN ENTERTAINMENT,Consumer Discretionary,15952---53> CWEN,CLEARWAY ENERGY INC CLASS C,Utilities,1685415a1555> PENN,PENN ENTERTAINMENT,Consumer Discretionary,15956```5758## New files59```60new: calls_by_form.csv (     118 bytes)61new: cohort_by_run.csv (     327 bytes)62new: ledger_collisions.csv (   19833 bytes)63new: projects_by_type_ci.csv (    1498 bytes)64```6566## stats.json: baseline keys vs regenerated keys67```68baseline keys: 17 | regenerated keys: 4169added keys: ['amount_ge_1t', 'amount_ge_50b', 'amount_le_zero', 'amount_max', 'amount_raw_deviations', 'amount_total_median_musd', 'annual_panel_firms', 'backfilled_mentions', 'backfilled_rows', 'backfilled_rows_under_30_words', 'calls_by_form', 'conf_exact_default_count', 'conf_min_by_run', 'filing_date_range', 'fiscal_year_null_mentions', 'gate_pass_total', 'iwv_equity_lines', 'iwv_holdings_file_archived', 'ledger_10k_mdna_median_words', 'ledger_backends', 'october_effective_sections_per_second', 'october_rows', 'october_wall_clock_hours', 'outage', 'sp500_ciks']70removed keys: ['example_project']71CHANGED spid_runs : {"sp500_run": "2026-06 (gpt-4o-mini, 16 workers, 153,894 sections)", "russell_run": "2026-10-27/28 (gpt-4o-mini-2024-07-18, 48 workers, 968,134 sections)"} -> {"sp500_run": {"log": "project-db/logs/extract.log", "date": null, "model": null, "workers": 16, "batch": 15, "ciks": 500, "sections_logged": 4271, "ledger_rows_backfilled": 154964, "mentions_backfill72```7374## Tail of the run log75```76  120240,77  118783,78  36740,79  81320,80  252469,81  30806582 ],83 "projects_fields": [84  56500,85  54583,86  17694,87  12109988 ],89 "fiscal_year_null_mentions": 6882790}91```92