7,658
edits
Changes
Jump to navigation
Jump to search
no edit summary
|Has owner=Ed Egan
}}
<onlyinclude>The [[VCDB20]] project documents a build of my VCDB -- '''V'''enture '''C'''apital '''D'''ata'''B'''ase -- covering until the end of 2020. 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 were partial builds. See also: [[SDC Normalizer]].</onlyinclude>
==Data design==
2010 Census data (2020 isn't available but the mappings are fairly static):
*https://www.census.gov/geographies/reference-files/time-series/geo/relationship-files.2010.html
*https://www2.census.gov/geo/pdfs/maps-data/data/rel/explanation_zcta_place_rel_10.pdf
*https://www2.census.gov/geo/docs/maps-data/data/rel/zcta_place_rel_10.txt
I also load up the 2010 ANSI codes for places (i.e., statefp, statecode, placename, placefp, etc.):
* Source: https://www.census.gov/library/reference/code-lists/ansi.html
* Data: national_places.txt -> national_places_processed.txt (regexes)
* Pop the last word off the placename!
Note that the postprocessing of these two tables is done at the end of Load.sql. The final table is '''zctaplaceinfo''' which takes zcta, statecode and provides back placename and geoid (of the place).
===Load the Additions===
