Difference between revisions of "Talk:Houston Accelerators and Incubators (Report)"
Jump to navigation
Jump to search
BenBaldazo (talk | contribs) |
|||
| (18 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | '''Total Unique Startup Names: | + | =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: 1451''' | ||
'''Total Unique Accelerator Names: 13''' | '''Total Unique Accelerator Names: 13''' | ||
| Line 5: | Line 21: | ||
'''Houston Startup Sources:''' | '''Houston Startup Sources:''' | ||
| − | *AngelList | + | *AngelList 500 |
| − | **Joined | + | **Joined 393 |
| − | **Signal | + | **Signal 394 |
| − | **Total Raised | + | **Total Raised 204 |
| + | ***Total Raised is actually made Redundant by the other 2 Angel List Pulls | ||
*HoustonStartupsList 283 | *HoustonStartupsList 283 | ||
| − | *StartupBlinkMap | + | *StartupBlinkMap 379 |
*Startups-Accelerators 292 | *Startups-Accelerators 292 | ||
| − | *SDC VC Houston Port Cos | + | *SDC VC Houston Port Cos 493 |
| + | *CrunchBase 116 | ||
| + | *StartHouston 27 | ||
| Line 26: | Line 45: | ||
*Industry | *Industry | ||
| − | + | =To Do= | |
| + | |||
| + | Nexp Steps: | ||
*Standardize names | *Standardize names | ||
*Match up SQL tables | *Match up SQL tables | ||
*Use URLs to find missing addresses | *Use URLs to find missing addresses | ||
| + | **Does it matter if website now reroutes to new URL? | ||
*Remove non Houston Startups | *Remove non Houston Startups | ||
*Import into Individual Wiki Pages | *Import into Individual Wiki Pages | ||
| Line 42: | Line 64: | ||
**Co-Working Spaces | **Co-Working Spaces | ||
**Event Spaces | **Event Spaces | ||
| + | |||
| + | =Future= | ||
Possible Expansions: | Possible Expansions: | ||
| Line 47: | Line 71: | ||
*Proximity measures & Microgeography | *Proximity measures & Microgeography | ||
*Weak/Strong Areas in Houston for Entrepreneurship | *Weak/Strong Areas in Houston for Entrepreneurship | ||
| + | *Comparing accelerators based on funding | ||
| + | **https://www.propublica.org/ | ||
Latest revision as of 14:12, 29 June 2016
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: 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
