Changes

Jump to navigation Jump to search
no edit summary
Create list of All Houston:-startups-accelerators-etc=Towards unique names=
Decide what categories to include 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 each & make a formmode 2 (rerun)#Clean that match file manually for idiosyncractic issues (rerun -Nameonly 2 problems)-Location#Load all 7 base files into a dbase#Load the matchfile into the dbase-Desc#Use SQL to get the unique names for each entry in a base file (7 queries)-contact info#Assemble all of the common variables together taking the best available (somewhat subjective) in SQL, and add the extra vars.-accelerator#Output the new master file to work with!
Create =Startup Map= '''Total Unique Startup Names: 1451''' '''Total Unique Accelerator Names: 13'''  '''Houston Startup Sources:'''*AngelList 500**Joined 393**Signal 394**Total Raised 204***Total Raised is actually made Redundant by the other 2 Angel List Pulls*HoustonStartupsList 283*StartupBlinkMap 379*Startups-Accelerators 292*SDC VC Houston Port Cos 493*CrunchBase 116*StartHouston 27  Necessary Categories to include in each individual Wiki page*Name*Location*Desc*accelerator (if available) Optional Categories*Contact info*Cohort of accelerator*Industry =To Do= Nexp Steps:*Standardize names*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*Import into Map*Repeat Process with:**Accelerators**Angels**Incubators**Angel Groups**Venture Capital**Service Firms**Co-Working Spaces**Event Spaces =Future= Possible Expansions:*Calendar that correlates with the map*Proximity measures & Microgeography*Weak/Strong Areas in Houston for Entrepreneurship*Comparing accelerators based on funding**https://www.propublica.org/
Anonymous user

Navigation menu