76
edits
Changes
Jump to navigation
Jump to search
Seed Accelerator Data Assembly (view source)
Revision as of 02:46, 2 August 2018
, 02:46, 2 August 2018→Accelerator Data Assembly Progress (Hira)
*All data files are in Z:/accelerator
*The SQL file LoadAccData.sql. It is located in E:\McNair\Projects\Accelerators\Summer 2018.
=== Data assembly details ===
The SQL file LoadAccData.sql currently loads data on Cohorts final and Founders from:
E:\McNair\Projects\Accelerators\Summer 2018\The File To Rule Them All.xlsx
It creates the following tables:
1) cohorts final - This table loads all information in the sheet Cohorts Final in The File to Rule Them All.
2) CohortCompany - this uses data in cohorts final and creates a table with the following:
*conamestd
*conameorg
*colocation
*city
*state_code
*country_code
*address
*codescription
*short_desc
*long_desc
*cosectors
*costatus
*cofundingstage
*courl
*uuid
*category_list
*category_group_list
*founded_on
*employee_count
*emp_count_scale
*linkedin_url
*gotvc
