Changes
Jump to navigation
Jump to search
Talk:Houston Accelerators and Incubators (Report) (view source)
Revision as of 15:12, 29 June 2016
, 15:12, 29 June 2016no edit summary
=Towards unique names=
Steps:
#Put all the names in one text file (done)
#Sort the file and removed exact dups using textpad (done)
#Run the matcher on that file in mode 2 (rerun)
#Clean that match file manually for idiosyncractic issues (rerun - only 2 problems)
#Load all 7 base files into a dbase
#Load the matchfile into the dbase
#Use SQL to get the unique names for each entry in a base file (7 queries)
#Assemble all of the common variables together taking the best available (somewhat subjective) in SQL, and add the extra vars.
#Output the new master file to work with!
=Startup Map=
'''Total Unique Startup Names: 14181451'''
'''Total Unique Accelerator Names: 13'''
'''Houston Startup Sources:'''
*AngelList500**Joined 396393**Signal 437394**Total Raised 207204***Total Raised is actually made Redundant by the other 2 Angel List Pulls
*HoustonStartupsList 283
*StartupBlinkMap 381379
*Startups-Accelerators 292
*SDC VC Houston Port Cos 494493*CrunchBase 116*StartHouston 27
*Match up SQL tables
*Use URLs to find missing addresses
**Does it matter if website now reroutes to new URL?
*Remove non Houston Startups
*Import into Individual Wiki Pages
*Proximity measures & Microgeography
*Weak/Strong Areas in Houston for Entrepreneurship
*Comparing accelerators based on funding
**https://www.propublica.org/
