spb/firc0001_uqo

1% Generated by code/make_tables.py from data/stats.json (universe), data/documented\_inputs.json, results/russell\_coverage.json, results/universe/universe\_artefacts.json. Do not edit by hand.2\begin{table}[H]3\centering\small4\caption{Universe-to-dataset reconciliation: from the two constituent lists to issuers with resolved projects}\label{tab:reconciliation}5\begin{threeparttable}6\begin{tabular}{p{11.6cm}r}7\toprule8Step & Count \\9\midrule10iShares IWV holdings file, equity lines with a ticker (as of Oct 23, 2026); count reported by the build log, source file not archived & 2{,}587 \\11\quad of which mapped to an SEC CIK (CVRs, escrow lines and FDIC-only banks excluded) & 2{,}573 \\12\quad distinct CIKs (share classes collapsed) & 2{,}555 \\13S\&P~500 constituents, cached snapshot of 2026-05-25 (500 CIKs) & 503 \\14\midrule15Merged issuer universe (distinct CIKs) & 2{,}564 \\16\quad in both lists & 491 \\17\quad S\&P~500 only & 9 \\18\quad Russell proxy only & 2{,}064 \\19\midrule20Russell~3000 index constituents, FTSE Russell factsheet as of 2026-09-30 & 2{,}996 \\21\quad coverage of the index by the proxy (distinct CIKs / constituents, \%) & 85.3 \\22\midrule23Issuers with at least one 10-K, 10-Q or 8-K since 2010 & 2{,}499 \\24Issuers without any such filing (foreign private issuers filing 20-F/40-F, FDIC-only banks) & 65 \\25Issuers with at least one resolved project & 2{,}492 \\26\bottomrule27\end{tabular}28\begin{tablenotes}\footnotesize29\item Sources: \texttt{data/metadata/universe.json}, \texttt{russell3000\_constituents.json}, \texttt{sp500\_constituents.json} (SHA-256 prefixes: \texttt{universe.json} 3967b29b378e\ldots; \texttt{russell3000\_constituents.json} 758cbebf5854\ldots; \texttt{sp500\_constituents.json} 508407526069\ldots; full digests in Table~\ref{tab:universe_artefacts}) and the merged DuckDB database. The first row is the count reported by the build log of \texttt{scripts/build\_universe.py}; the iShares holdings file and the SEC \texttt{company\_tickers.json} used by the build were not archived, so this count and the dropped non-company lines are not reconstructible (Section~\ref{sec:sample}). The mapped lines collapse to fewer CIKs because 18 dual-class registrants appear twice; 7 tickers have no CIK in the SEC map (TOWN, FRBA, NBN, HIFS, ADRO, THRD, HOLX). The index count is the ``Number of Holdings'' of the FTSE Russell factsheet (SHA-256 281e92643781\ldots); the fund tracks the index by representative sampling, so the omitted constituents cannot be identified without the licensed constituent list. The 65 issuers without filings are listed in \texttt{data/issuers\_without\_filings.csv} (foreign private issuers filing Forms 20-F/40-F and banks filing with the FDIC); 7 issuers have filings but no resolved project.30\end{tablenotes}31\end{threeparttable}32\end{table}33