Talk:Start-Ups of Houston (Map)

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

Towards unique names

Steps:

1. Put all the names in one text file (done)
2. Sort the file and removed exact dups using textpad (done)
3. Run the matcher on that file in mode 2 (rerun)
4. Clean that match file manually for idiosyncractic issues (rerun - only 2 problems)
5. Load all 7 base files into a dbase
6. Load the matchfile into the dbase
7. Use SQL to get the unique names for each entry in a base file (7 queries)
8. Assemble all of the common variables together taking the best available (somewhat subjective) in SQL, and add the extra vars.
9. Output the new master file to work with!

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/