7,625
edits
Changes
Jump to navigation
Jump to search
no edit summary
* Get the latest Gazetteer file(s): https://www.census.gov/geographies/reference-files/time-series/geo/gazetteer-files.html
* Check the coverage of portcogeo and create firmbogeoplus
===Exits===
Another part of Load.sql does the matching to IPOs and MAs and their precedence. Note that:
* Issuer and target names are matched against themselves using the [[Matcher.pl]] script in mode 2
* PortCo stdnames are matched to issuerstd and targetstd (separately) in mode 0
* The state and date matching requirements are in the load.sql.
* There seems to have been duplicate issue records in the IPO data for vcdb2020 (and perhaps earlier). Some of the duplicates are often identical, except that the date is a day apart.
* The IPO records also contain listings on junior and foreign exchanges, as well as some OTC - I left these in and flagged them.
