76
edits
Changes
Jump to navigation
Jump to search
Seed Accelerator Data Assembly (view source)
Revision as of 03:01, 2 August 2018
, 03:01, 2 August 2018→Data assembly details
It creates the following tables:
1) cohorts final cohortsfinal - This table loads all information in the sheet source file: Cohorts Final sheet in "The File to Rule Them All".
2) CohortCompany - this uses data in cohorts final cohortsfinal and creates a table with the following:
*conamestd
*conameorg
*linkedin_url
*gotvc
3)CohortParticipation - uses table cohortsfinal
*cohort
*year
*quarter
*accelerator
*conamestd
4) timing_final - This table is based on the most updated information on timing compiled in source file: Z:/accelerator/Formatted Timing Info.txt (by Grace). It includes:
*coname
*acceleratorname
*keyword
*url
*webpage
*predicted
*gooddata
*page_details
*full_date
*month
*year
*cohort_name
*notes
*prog_duration_wks
*actual_date
*actual_month
*actual_year
*season
5) Founders - source file: "The File to Rule Them All - Founders main sheet"
*Accelerator
*First_Name
*Last_Name
*Full_Name
*Current_Job
*Current_Location
6) founders_experience - source file: "The File to Rule Them All - Founders experience sheet"
Accelerator text,
*First_Name text,
*Last_Name text,
*Full_Name text,
*Employer text,
*VC varchar(5),
*VC_backed_startup varchar(5),
*OLD_Job_Title text,
*NEW_Job_Title text,
*Dates_Employed text,
*Time_Employed text,
*Location text,
*Extra_Description text
