7,612
edits
Changes
Jump to navigation
Jump to search
Estimating Unobserved Complementarities between Entrepreneurs and Venture Capitalists (view source)
Revision as of 22:45, 16 May 2021
, 22:45, 16 May 2021→Dataset Rebuild
*Replaced SynRealSetc20 with SynthKeys_Code20.
*Replaced AllRealMatchKeysC20Code with ComboKeys_Code20, also renamed realmatch variable to isreal.
*Rebuilt Super tables (PortCoSuper, DealSuper, FirmSuper). Note that FirmSuper contains some nonis now restricted to US firms only (matches were already US-US firms). Note: The following are available in firmbasecore but unused in firmvars: SELECT invstatus, rolepref, geogpref, indpref, stagepref FROM firmbasecore; SELECT invstatus, count(*) FROM firmbasecore group by invstatus ORDER BY invstatus; Actively seeking new investments 10856 Inactive / Unknown 1625 Making few if any new investments 68 Reducing investment activity 48 1257 SELECT rolepref, count(*) FROM firmbasecore group by rolepref ORDER BY rolepref; BO 965 DO 340 EI 757 OH 10 OT 131 11651 SELECT COUNT(*) FROM ( SELECT geogpref, count(*) FROM firmbasecore group by geogpref ORDER BY geogpref) AS T; --181 --Includes, states, nations, continents, etc. SELECT COUNT(*Need to check that matching is to US firms only) FROM ( SELECT indpref, count(*) FROM firmbasecore group by indpref ORDER BY indpref) AS T; --112 --COULD MAYBE BE CODED IN TERMS OF CODE20, etc.
===Review===
