Changes

|Has title=VCDB20Q3VCDB20

<onlyinclude>The [[VCDB20Q3VCDB20]] project documents a build of my VCDB -- '''V'''enture '''C'''apital '''D'''ata'''B'''ase -- covering until the end of 2020 Q3. Each VCDB includes investments, funds, startups, executives, exits, locations, and more, derived from data from [[VentureXpert]]. This project updates [[vcdb4]], which covered (almost) to the of Q3 2019, and replaces [[VCDB20H1]] and [[VCDB20Q3], which was a were partial buildbuilds. See also: [[SDC Normalizer]].</onlyinclude>

I followed the same data design as in [[VCDB20H1]]. Essentially the specification pulls everything, even things that aren't needed like incomplete M&As or withdrawn IPOs, or funds or investments that aren't venture capital, all the way to the present (the pull was done on 11/17/2020-01-04), and then place restrictions on the data later. Crucially, the pulls no longer use the venture-related flag, so the data contains private equity and other deals, as well as secondaries and purchases. Note that the M&As are pulled separately for public and private acquirers, and in chunks by year to keep the request sizes manageable.

createdb vcdb20q3vcdb20

Move the files to //mother/bulk/vcdb20q3 vcdb20 and run the load script: E:\projects\vcdb20q3vcdb20\Load.sql