VCDB24 - Revision history

Ed at 19:37, 13 June 2024

2024-06-13T19:37:03Z

2024-06-13T19:00:26Z

Industry

2024-06-10T21:30:44Z

Industry

2024-06-10T21:29:48Z

Industry

2024-06-10T21:29:24Z

2024-06-07T20:29:53Z

2024-06-04T19:26:21Z

Geocoding

2024-06-04T17:04:23Z

Geocoding

2024-06-04T17:03:54Z

Geocoding

2024-06-04T16:02:40Z

Geocoding

@@ Line 67: / Line 67: @@
 * The IPO records also contain listings on junior and foreign exchanges, as well as some OTC - I left these in and flagged them.
-==Industry==
+===Industry===
 The industry coding is in IndustryCodes.txt. Note that:
@@ Line 124: / Line 124: @@
 I also tried some keyword industry coding from both short and long descriptions. The source code is at the top of BuildBaseTables.sql. The results are in sheets in the IndustryCodes.xlsx file.

← Older revision		Revision as of 19:00, 13 June 2024
Line 122:		Line 122:
	\| 14246		\| 14246
	\|}		\|}
		+
		+	I also tried some keyword industry coding from both short and long descriptions. The source code is at the top of BuildBaseTables.sql. The results are in sheets in the IndustryCodes.xlsx file.

@@ Line 75: / Line 75: @@
 * The codes are 1,2,4 but not 3dg hierarchical.
 * 1dg codes are IT, LS, and Other.
+* Note that code is the full 4dg industry identifier, where as code20 and code100 are name-based aggregates with at least 20 or 100 observations in them.
 {| class="wikitable"
 |-

@@ Line 82: / Line 82: @@
 ! No. of PortCos
 |-
-! 11
+| 11
-! Communications and Media
+| Communications and Media
-! 3930
+| 3930
 |-
 | 12

@@ Line 1: / Line 1: @@
-[[VCDB24]] is the 2024 and final iteration of my [[VentureXpert]] based '''V'''enture '''C'''apital '''D'''ata'''B'''ase. Thomson-Reuters discontinued access to VentureXpert through [[SDC Platinum]] on December 31st, 2023 (see also: [[SDC Normalizer]]). This iteration contains data up until then. Each VCDB includes investments, funds, startups, executives, exits, locations, and more. The previous build was [[VCDB23]], but the best previous instructions are from [[VCDB20]].
+[[VCDB24]] is the 2024 and final iteration of my [[VentureXpert]] based '''V'''enture '''C'''apital '''D'''ata'''B'''ase. Thomson-Reuters discontinued access to VentureXpert through [[SDC Platinum]] on December 31st, 2023 (see also: [[SDC Normalizer]]). This iteration contains data up until then. Each VCDB includes investments, funds, startups, executives, exits, locations, and more. The previous build was [[VCDB23]], but the best previous instructions are from [[VCDB20]] or the [[McNair Center]] build, which was called [[VentureXpert Data]].
 == Processing Steps ==
@@ Line 66: / Line 66: @@
 * 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.

← Older revision		Revision as of 20:29, 7 June 2024
Line 57:		Line 57:
	* Get the latest Gazetteer file(s): https://www.census.gov/geographies/reference-files/time-series/geo/gazetteer-files.html		* 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		* 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.

@@ Line 42: / Line 42: @@
 ===Geocoding===
-Part of Load.sql requires that we update the Geocoding - adding new long and lat for PortCos and firm offices that we haven't seen before.
+Part of Load.sql requires we update the Geocoding - adding new long and lat for PortCos and firm offices that we haven't seen before.
 The last time this was run was vcdb20. Accordingly:
@@ Line 55: / Line 55: @@
 ** Strip the header line out of the input file(s)
 ** python Geocode.py portcogrowthneedsgeo-NoHeader.txt

@@ Line 54: / Line 54: @@
 * In E:/tools/Geocode run the script(s): Geocode.py for portcos and GeocodeOneKey.py for everything else.
 ** Strip the header line out of the input file(s)
-** ```python Geocode.py portcogrowthneedsgeo-NoHeader.txt```
+** python Geocode.py portcogrowthneedsgeo-NoHeader.txt

← Older revision		Revision as of 16:02, 4 June 2024
Line 48:		Line 48:
	* Import them as portcogeo_vcdb20, firmgeo_vcdb20, and bogeo_vcdb20		* Import them as portcogeo_vcdb20, firmgeo_vcdb20, and bogeo_vcdb20
	* Build portcogrowthneedsgeo, firmneedsgeo, firmboneedsgeo files for geocoding		* Build portcogrowthneedsgeo, firmneedsgeo, firmboneedsgeo files for geocoding
		+	* Log into [https://console.cloud.google.com/ Google Console] and set up an API key. Note that:
		+	** Up to $200/month should be free
		+	** $5.00 USD per 1000 lookups.
		+	** 3,000 QPM max
		+	* In E:/tools/Geocode run the script(s): Geocode.py for portcos and GeocodeOneKey.py for everything else.
		+	** Strip the header line out of the input file(s)
		+	** python Geocode.py portcogrowthneedsgeo-NoHeader-10.txt