# N13 export reconciliation — 2026-11-05T14:43:24-05:00 on m3u96b, rc=0, 44 s

## Byte identity of the 29 baseline CSV (commit 678d233) vs the regenerated exports
```
identical amount_dist.csv
identical companies_by_sector.csv
identical companies_by_shard.csv
identical confidence_dist.csv
identical duration.csv
identical example_provenance.csv
identical factor_tables.csv
identical filings_by_form.csv
identical filings_by_year_form.csv
identical issuers_by_year.csv
identical issuers_without_filings.csv
identical kg.csv
identical ledger_10k_items.csv
identical ledger_10q_items.csv
identical ledger_by_form.csv
identical mentions_by_form.csv
identical mentions_by_year.csv
identical mentions_per_project.csv
identical parse_status.csv
identical projects_by_first_seen_year.csv
DIFFERS   projects_by_index.csv
identical projects_by_sector.csv
identical projects_by_status.csv
identical projects_by_type.csv
identical projects_per_issuer.csv
identical sections_10k_by_item.csv
identical sections_by_form.csv
DIFFERS   top_issuers.csv
identical=26 differs=2 missing=0
```

## Differences
```
--- projects_by_index.csv
2d1
< False,True,93333,1992
4a4
> False,True,93333,1992
--- top_issuers.csv
9d8
< MUX,MCEWEN INC,Materials,180
10a10
> MUX,MCEWEN INC,Materials,180
12d11
< CWEN,CLEARWAY ENERGY INC CLASS C,Utilities,168
14c13
< PENN,PENN ENTERTAINMENT,Consumer Discretionary,159
---
> CWEN,CLEARWAY ENERGY INC CLASS C,Utilities,168
15a15
> PENN,PENN ENTERTAINMENT,Consumer Discretionary,159
```

## New files
```
new: calls_by_form.csv (     118 bytes)
new: cohort_by_run.csv (     327 bytes)
new: ledger_collisions.csv (   19833 bytes)
new: projects_by_type_ci.csv (    1498 bytes)
```

## stats.json: baseline keys vs regenerated keys
```
baseline keys: 17 | regenerated keys: 41
added 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']
removed keys: ['example_project']
CHANGED 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_backfill
```

## Tail of the run log
```
  120240,
  118783,
  36740,
  81320,
  252469,
  308065
 ],
 "projects_fields": [
  56500,
  54583,
  17694,
  121099
 ],
 "fiscal_year_null_mentions": 68827
}
```