7,649
edits
Changes
Jump to navigation
Jump to search
Estimating Unobserved Complementarities between Entrepreneurs and Venture Capitalists (view source)
Revision as of 16:14, 18 July 2021
, 16:14, 18 July 2021→Review of Changes
==== Review of Changes ====
In BuildBaseTables.sql:* Fixed PortCoGeoid to use zipcodes too to determine placename (and geoid)* Pushed changes through PortCoMaster* Added new vars to PortCoPeople and pushed them through. Added restrictions to MatchMostNumerous (34604):* Firm and portco nation code='US'* Firm and portco statecode code!='UN'* Code is not null* placename is not null* hqdistkm is not null In BuildDataset.sql. * SynthKeys_Code20: Pushed changes through. 488065* ComboKeys_Code20: 522669 = 488065 + 34604* PortCoSuper (not restricted) - uses lastest version of PortCoMaster. Placename from PortCoGeoid, which uses zipcodes too. DealSuper (restricted to MatchKeys!), FirmSuper (now US only, but not restricted)* Combodist, ComboIndu, and ComboMeasures tables (all based on ComboKeys_Code20) much as before but with new base sets* ComboStats_Code20 added to provide market info.* MasterCode20Year. Rerun with new feeders. New variables added. Also joins in PlaceYearRanking - need to fix this.HERE
==== pccitydollarsrankm1 ====
