*Replaced AllRealMatchKeysC20Code with ComboKeys_Code20, also renamed realmatch variable to isreal.
**Note that ComboKeys_Code20 (591,299 with 554,561 synths) is much smaller AllRealMatchKeysC20Code (1,631,896 with 1,599,427 synths), which allowed (almost) any other firm from RLJoinerFF that had done a deal in that code20-year. ComboKeys_Code20 only allows another real match from the same code20-year.
*Rebuilt Super tables (PortCoSuper, DealSuper, FirmSuper). Note that FirmSuper is now restricted to US firms only (matches were already US-USbecause MatchMostNumerous was constrained to US firms and portcos only. However, it is not clear that this was true in the past.).*Rebuilt the AllMatchc20 tables. New names are Combo..._Code20. **Crucial difference: Only investments within ComboKeys_Code20 are included in the history counts. Before anything in RLJoinerFF or even RoundlineBase were included, which created the impression of overcounts.**The vast majority of missing distances are caused by missing firm addresses for just 391 VCs. However, we have zip codes for almost all (?) of them. SELECT hasgeo, COUNT(*) FROM ComboDist_Code20 WHERE bodist IS NULL GROUP BY hasgeo; /* firm 52 none 4 pc 10444 */
Note: The following are available in firmbasecore but unused in firmvars: