spb/firc0001_uqo

1% Generated by code/make_tables.py — inline numbers of the paper. Do not edit; use \SPID<name> in the text.2% Source and formula of every macro: results/inline_numbers.json3\newcommand{\SPIDiwvEquityLines}{2{,}587}4\newcommand{\SPIDuniverseN}{2{,}564}5\newcommand{\SPIDrussellDistinctCiks}{2{,}555}6\newcommand{\SPIDrussellMappedLines}{2{,}573}7\newcommand{\SPIDrussellUnmatched}{7}8\newcommand{\SPIDrussellIndexConstituents}{2{,}996}9\newcommand{\SPIDrussellProxyCoveragePct}{85.3}10\newcommand{\SPIDiwvHoldingsCount}{2{,}588}11\newcommand{\SPIDiwvReplicationMethod}{representative sampling}12\newcommand{\SPIDfilingDateFirst}{2010-01-04}13\newcommand{\SPIDfilingDateLast}{2026-10-27}14\newcommand{\SPIDfilingsTotal}{527{,}548}15\newcommand{\SPIDfilingsNotParsed}{16}16\newcommand{\SPIDfilingsMissingOnDisk}{2}17\newcommand{\SPIDrawGb}{254.5}18\newcommand{\SPIDfirstSeenYearMin}{2011}19\newcommand{\SPIDfirstSeenYearMax}{2025}20\newcommand{\SPIDfirstSeenRangeInner}{6{,}240--8{,}216}21\newcommand{\SPIDfirstSeenFirstYear}{7{,}835}22\newcommand{\SPIDfirstSeenInnerMean}{7{,}105}23\newcommand{\SPIDmentionsFirstYear}{11{,}908}24\newcommand{\SPIDmentionsLastFullYear}{23{,}220}25\newcommand{\SPIDissuersWithMentionsFirstYear}{1{,}224}26\newcommand{\SPIDissuersWithMentionsLastFullYear}{2{,}280}27\newcommand{\SPIDmentionsPerIssuerFirstYear}{9.7}28\newcommand{\SPIDmentionsPerIssuerLastFullYear}{10.2}29\newcommand{\SPIDlastYear}{2026}30\newcommand{\SPIDcallsOneZeroK}{135{,}310}31\newcommand{\SPIDcallsOneZeroQ}{363{,}973}32\newcommand{\SPIDcallsEightK}{204{,}442}33\newcommand{\SPIDledgerTotal}{1{,}123{,}098}34\newcommand{\SPIDledgerMentionsReturned}{308{,}477}35\newcommand{\SPIDledgerGap}{412}36\newcommand{\SPIDledgerGapByForm}{10-K 127, 10-Q 257, 8-K 28}37\newcommand{\SPIDmentionsStoredEightK}{74{,}566}38\newcommand{\SPIDmentionsLedgerEightK}{74{,}594}39\newcommand{\SPIDledgerSectionsEightK}{400{,}601}40\newcommand{\SPIDmentionsStoredOneZeroK}{81{,}495}41\newcommand{\SPIDmentionsLedgerOneZeroK}{81{,}622}42\newcommand{\SPIDledgerSectionsOneZeroK}{143{,}704}43\newcommand{\SPIDmentionsStoredOneZeroQ}{152{,}004}44\newcommand{\SPIDmentionsLedgerOneZeroQ}{152{,}261}45\newcommand{\SPIDledgerSectionsOneZeroQ}{578{,}793}46\newcommand{\SPIDproductiveSections}{168{,}230}47\newcommand{\SPIDproductiveShareLedger}{15.0}48\newcommand{\SPIDmentionsPerLedgerSection}{0.27}49\newcommand{\SPIDmentionsPerProductiveSection}{1.83}50\newcommand{\SPIDgatePassTotal}{703{,}725}51\newcommand{\SPIDproductiveShareCalls}{23.9}52\newcommand{\SPIDmentionsPerCall}{0.44}53\newcommand{\SPIDtenKmdnaMentions}{39{,}099}54\newcommand{\SPIDtenQmdnaMentions}{99{,}305}55\newcommand{\SPIDtenKbusinessMentions}{30{,}492}56\newcommand{\SPIDtenQfinancialStatementsMentions}{30{,}159}57\newcommand{\SPIDtenKfullBodyRows}{1{,}230}58\newcommand{\SPIDtypesPctSum}{100.1}59\newcommand{\SPIDamountMedianMusd}{128.5}60\newcommand{\SPIDsmallNThreshold}{50}61\newcommand{\SPIDsmallNCategories}{ai_initiative, automation, cloud_migration}62\newcommand{\SPIDshareDataCenter}{0.4}63\newcommand{\SPIDnDataCenter}{449}64\newcommand{\SPIDwithAmountDataCenter}{129}65\newcommand{\SPIDmedianAmountDataCenter}{166.0}66\newcommand{\SPIDshareAiInitiative}{0.3}67\newcommand{\SPIDnAiInitiative}{376}68\newcommand{\SPIDwithAmountAiInitiative}{20}69\newcommand{\SPIDmedianAmountAiInitiative}{127.5}70\newcommand{\SPIDshareCloudMigration}{0.2}71\newcommand{\SPIDnCloudMigration}{264}72\newcommand{\SPIDwithAmountCloudMigration}{35}73\newcommand{\SPIDmedianAmountCloudMigration}{50.0}74\newcommand{\SPIDshareAutomation}{0.3}75\newcommand{\SPIDnAutomation}{374}76\newcommand{\SPIDwithAmountAutomation}{25}77\newcommand{\SPIDmedianAmountAutomation}{13.7}78\newcommand{\SPIDshareMaIntegration}{34.5}79\newcommand{\SPIDnMaIntegration}{41{,}742}80\newcommand{\SPIDwithAmountMaIntegration}{28{,}044}81\newcommand{\SPIDmedianAmountMaIntegration}{155.0}82\newcommand{\SPIDshareCapexProgram}{8.9}83\newcommand{\SPIDnCapexProgram}{10{,}720}84\newcommand{\SPIDwithAmountCapexProgram}{9{,}452}85\newcommand{\SPIDmedianAmountCapexProgram}{300.0}86\newcommand{\SPIDsharePartnership}{8.2}87\newcommand{\SPIDnPartnership}{9{,}909}88\newcommand{\SPIDwithAmountPartnership}{2{,}943}89\newcommand{\SPIDmedianAmountPartnership}{75.0}90\newcommand{\SPIDshareGeographicExpansion}{6.5}91\newcommand{\SPIDnGeographicExpansion}{7{,}868}92\newcommand{\SPIDwithAmountGeographicExpansion}{1{,}431}93\newcommand{\SPIDmedianAmountGeographicExpansion}{36.7}94\newcommand{\SPIDsharePlantConstruction}{6.3}95\newcommand{\SPIDnPlantConstruction}{7{,}590}96\newcommand{\SPIDwithAmountPlantConstruction}{2{,}511}97\newcommand{\SPIDmedianAmountPlantConstruction}{56.0}98\newcommand{\SPIDtechCategoriesCountRange}{264--449}99\newcommand{\SPIDsectorTopFourPerIssuerRange}{62--75}100\newcommand{\SPIDsectorTopFourNames}{utilities, materials, energy, real estate}101\newcommand{\SPIDsectorFinancialsPerIssuer}{32}102\newcommand{\SPIDsectorProjectsHealthCare}{23{,}679}103\newcommand{\SPIDsectorIssuersHealthCare}{429}104\newcommand{\SPIDsectorProjectsIndustrials}{17{,}890}105\newcommand{\SPIDsectorIssuersIndustrials}{386}106\newcommand{\SPIDspanKnownN}{103{,}500}107\newcommand{\SPIDspanUnknownN}{17{,}599}108\newcommand{\SPIDspanUnknownShareAll}{14.5}109\newcommand{\SPIDspanZeroShareAll}{55.5}110\newcommand{\SPIDspanZeroShareKnown}{64.9}111\newcommand{\SPIDspanOverFiveShareAll}{8.5}112\newcommand{\SPIDspanOverFiveShareKnown}{10.0}113\newcommand{\SPIDstatusShareInProgress}{41.6}114\newcommand{\SPIDstatusShareCompleted}{41.0}115\newcommand{\SPIDstatusSharePlanned}{15.1}116\newcommand{\SPIDstatusShareMentioned}{2.3}117\newcommand{\SPIDsingleMentionShare}{60.2}118\newcommand{\SPIDoverTenMentionShare}{3.1}119\newcommand{\SPIDconfShareOne}{35.2}120\newcommand{\SPIDconfShareNine}{32.7}121\newcommand{\SPIDconfShareLeSix}{1.6}122\newcommand{\SPIDamountMentions}{120{,}240}123\newcommand{\SPIDamountMentionsShare}{39.0}124\newcommand{\SPIDamountProjects}{56{,}500}125\newcommand{\SPIDamountProjectsShare}{46.7}126\newcommand{\SPIDamountPTwoFiveMusd}{23}127\newcommand{\SPIDamountPSevenFiveMusd}{500}128\newcommand{\SPIDamountPNineNineBusd}{12.5}129\newcommand{\SPIDamountSumTusd}{55.9}130\newcommand{\SPIDkgNodes}{183{,}472}131\newcommand{\SPIDkgEdges}{204{,}456}132\newcommand{\SPIDkgNodesProject}{121{,}099}133\newcommand{\SPIDkgNodesPartner}{36{,}822}134\newcommand{\SPIDkgNodesLocation}{14{,}508}135\newcommand{\SPIDkgNodesTechnology}{8{,}551}136\newcommand{\SPIDkgNodesCompany}{2{,}492}137\newcommand{\SPIDprovenanceForms}{8-K}138\newcommand{\SPIDprovenanceN}{8}139\newcommand{\SPIDprovenanceFirst}{2014-04-08}140\newcommand{\SPIDprovenanceLast}{2022-03-07}141\newcommand{\SPIDprovenanceMaxAmountBusd}{11.5}142\newcommand{\SPIDprovenanceNameYear}{2022}143\newcommand{\SPIDgateRegexFlags}{re.IGNORECASE}144\newcommand{\SPIDgateRegexLength}{215}145\newcommand{\SPIDgateRegexAlternatives}{25}146\newcommand{\SPIDtaxonomyN}{21}147\newcommand{\SPIDcallsTotal}{703{,}725}148\newcommand{\SPIDgatePassSections}{703{,}737}149\newcommand{\SPIDgateRejectedSections}{419{,}361}150\newcommand{\SPIDledgerUnderThirtyWords}{1{,}070}151\newcommand{\SPIDusdPerCall}{0.0013}152\newcommand{\SPIDoctoberCalls}{608{,}439}153\newcommand{\SPIDoctoberRows}{968{,}134}154\newcommand{\SPIDoctoberWallClockHours}{13.7}155\newcommand{\SPIDoutageHours}{5.3}156\newcommand{\SPIDoctoberEffectiveHours}{8.4}157\newcommand{\SPIDoctoberRowsPerSecondEffective}{31.9}158\newcommand{\SPIDoctoberCallsPerSecondEffective}{20.1}159\newcommand{\SPIDoctoberFirstFlush}{2026-10-27 21:35}160\newcommand{\SPIDoctoberLastFlush}{2026-10-28 11:15}161\newcommand{\SPIDbackfilledRows}{154{,}964}162\newcommand{\SPIDjuneLogSections}{153{,}894}163\newcommand{\SPIDbackfilledUnderThirtyWords}{1{,}070}164\newcommand{\SPIDbackfilledMentions}{39{,}930}165\newcommand{\SPIDbackfilledCiks}{500}166\newcommand{\SPIDbackfilledGateFail}{59{,}666}167\newcommand{\SPIDoutageWindowStart}{2026-10-28 01:10}168\newcommand{\SPIDoutageWindowEnd}{2026-10-28 06:22}169\newcommand{\SPIDllmCallFailedTotal}{94{,}609}170\newcommand{\SPIDllmCallFailedInsideOutage}{94{,}467}171\newcommand{\SPIDllmCallFailedOutsideOutage}{142}172\newcommand{\SPIDllmFailedJsonDecodeError}{14}173\newcommand{\SPIDllmFailedRetryableHttpFourTwoNineFivexx}{94{,}593}174\newcommand{\SPIDllmFailedConnectionError}{2}175\newcommand{\SPIDjuneLlmCallFailed}{3}176\newcommand{\SPIDcollisionSections}{304}177\newcommand{\SPIDcollisionMentions}{412}178\newcommand{\SPIDprojectsKeyedGeneral}{229}179\newcommand{\SPIDmentionsKeyedGeneral}{2{,}152}180\newcommand{\SPIDprojectsKeyedNameToken}{66{,}405}181\newcommand{\SPIDprojectsKeyedNameTokenPct}{54.8}182\newcommand{\SPIDprojectsKeyedLocation}{54{,}658}183\newcommand{\SPIDprojectsKeyedLocationPct}{45.1}184\newcommand{\SPIDprojectsKeyedGeneralPct}{0.2}185\newcommand{\SPIDprojectsTieMaxConfidence}{33{,}820}186\newcommand{\SPIDprojectsTieDistinctNames}{20{,}118}187\newcommand{\SPIDprojectsStatusTie}{972}188\newcommand{\SPIDmentionsAtConfidenceOne}{108{,}023}189\newcommand{\SPIDprojectCountRangeKeys}{21{,}027--308{,}065}190\newcommand{\SPIDprojectCountRangeKeysN}{9}191\newcommand{\SPIDprojectCountRangeAll}{16{,}562--308{,}065}192\newcommand{\SPIDprojectCountCurrentKey}{121{,}099}193\newcommand{\SPIDtopNameTokens}{\texttt{acquisition} (3.4\%), \texttt{share} (3.1\%), \texttt{expansion} (1.8\%), \texttt{stock} (1.7\%), \texttt{investment} (1.6\%), \texttt{merger} (1.3\%), \texttt{sale} (1.3\%), \texttt{development} (1.2\%), \texttt{strategic} (0.9\%), \texttt{capital} (0.8\%)}194\newcommand{\SPIDtopNameTokensProjectsPct}{17.2}195\newcommand{\SPIDprojects}{121{,}099}196\newcommand{\SPIDmentions}{308{,}065}197\newcommand{\SPIDissuersWithProjects}{2{,}492}198\newcommand{\SPIDissuersWithFilings}{2{,}499}199\newcommand{\SPIDsectionsTotal}{1{,}342{,}283}200\newcommand{\SPIDchunks}{10{,}720{,}890}201\newcommand{\SPIDprojectsWithLocation}{54{,}583}202\newcommand{\SPIDprojectsTokenKeyedShare}{54.9}203\newcommand{\SPIDprojectsPerIssuerMean}{48.6}204\newcommand{\SPIDprojectsPerIssuerMedian}{42}205\newcommand{\SPIDextractedAtFirst}{2026-10-27 13:12:32}206\newcommand{\SPIDextractedAtLast}{2026-10-28 11:15:49}207\newcommand{\SPIDbrief}{the research-design brief, i.e. the specification of required tables, keys and validation gates against which \texttt{docs/implementation\_audit.md} audits the build}208\newcommand{\SPIDnewProjectsPerIssuerFirstYear}{6.4}209\newcommand{\SPIDnewProjectsPerIssuerLastFullYear}{3.5}210