158
edits
Changes
Jump to navigation
Jump to search
Merging Existing Data with Crunchbase (view source)
Revision as of 12:07, 17 July 2018
, 12:07, 17 July 2018→Step Two: Pulling Data
/bulk/McNair/Software/Database Scripts/Crunchbase2/'''LoadTables.sql'''
We then pulled the relevant data from Crunchbase based on unique UUID matches. In the crunchbase2 database, we used the table ''organizations''.The table looks like this:
We pull based on the unique UUIDs found by Maxine, which can be found in the file: /bulk/McNair/Projects/Accelerators/Summer 2018/'''The File to Rule Them All.xlsx''', in column W. The table we get most Crunchbase data from looks like this: DROP TABLE organizations; CREATE TABLE organizations (
company_name varchar(100),
role varchar(255),
*employee_count,
*linkedin_url,
*uuid-- our primary key'''
We also want to get more information on organization descriptions. To do so, we can pull ''description'' from the table ''organization_descriptions'', matching based on UUID.
