Crunchbase Data - Revision history

Ed at 17:41, 21 September 2020

2020-09-21T17:41:42Z

2020-09-21T17:34:17Z

2020-09-20T17:19:56Z

2020-09-20T17:12:10Z

2018-07-27T20:07:37Z

New Work

2018-07-12T20:28:31Z

Collecting Company Information

2018-07-11T21:24:24Z

2018-07-11T20:32:41Z

Collecting Company Information

2018-07-11T20:28:12Z

2018-07-10T22:16:11Z

Collecting Company Information

@@ Line 1: / Line 1: @@
 {{Project
-|Has project output=
+|Has project output=Data
 |Has sponsor=McNair Center
 |Has title=Crunchbase Data

@@ Line 1: / Line 1: @@
 {{Project
 |Has sponsor=McNair Center
 |Has title=Crunchbase Data

@@ Line 1: / Line 1: @@
 {{Project
 |Has title=Crunchbase Data
 |Has owner=Adrian Smart, Grace Tan, Maxine Tao, Connor Rothschild,

@@ Line 1: / Line 1: @@
-{{McNair Projects
+{{Project
 |Has title=Crunchbase Data
 |Has owner=Adrian Smart, Grace Tan, Maxine Tao, Connor Rothschild,

@@ Line 21: / Line 21: @@
 Use this key:
 e263576fe3e4ea5991edfbcfb9883
 ===Commands===
@@ Line 36: / Line 55: @@
   E:\McNair\Software\DatabaseScripts\Crunchbase2
 In making a table of accelerators and their UUIDs, some match multiple times if you match only on accelerator name. The file(Accelerator Multiple Matches) of those that match multiple times is in:

@@ Line 61: / Line 61: @@
 A list of UUIDs for the companies we are interested in can be found in the same place as above. It is called 'Our Company UUID matches'. SQL code to get matches is in the CompanyMatchScript mentioned above. The perl matches were done using Matcher.pl. The single match sheet for SQl contains companies that do not have multiple entries in crunchbase. This is also the case for the Perl single match sheet, and it has also been filtered to remove those that were flagged as multiple matches by Matcher.pl
-The final list for companies, UUIDs, and all other informations is also in the Summer 2018 folder. It is called 'FINAL LIST'.
+A list for companies, UUIDs, and all other informations is also in the Summer 2018 folder. It is called 'FINAL LIST'. THIS SHEET HAS DUPLICATES THAT ARE IN THE SHEET 'DUPLICATE COMPANIES'.
 ==Old Notes from previous work==

@@ Line 50: / Line 50: @@
 Code to build tables is here:
   E:\McNair\Software\Database Scripts\Crunchbase2\CompanyMatchScript
 Crunchbase may have blanks and random quotation marks as entries. I had to clean this on textpad.

← Older revision		Revision as of 20:32, 11 July 2018
Line 55:		Line 55:
	E:\McNair\Projects\Accelerators\Summer 2018\CB Company UUIDs		E:\McNair\Projects\Accelerators\Summer 2018\CB Company UUIDs

		+	A list of UUIDs for the companies we are interested in can be found in the same place as above. It is called 'Our Company UUID matches'. SQL code to get matches is in the CompanyMatchScript mentioned above. The perl matches were done using Matcher.pl. The single match sheet for SQl contains companies that do not have multiple entries in crunchbase. This is also the case for the Perl single match sheet, and it has also been filtered to remove those that were flagged as multiple matches by Matcher.pl
		+
		+	The final list for companies, UUIDs, and all other informations is also in the Summer 2018 folder. It is called 'FINAL LIST'.

	==Old Notes from previous work==		==Old Notes from previous work==

@@ Line 51: / Line 51: @@
   E:\McNair\Software\Database Scripts\Crunchbase2\CompanyMatchScript
 Crunchbase may have blanks and random quotation marks as entries. I had to clean this on textpad.
 All crunchbase companies and their UUIDs are here:
-  E:\McNair\Projects\Accelerators\CB Company UUIDs
+<br>All crunchbase companies and their UUIDs are here:
 ==Old Notes from previous work==