Difference between revisions of "Talk:Houston Accelerators and Incubators (Report)"
Jump to navigation
Jump to search
BenBaldazo (talk | contribs) (Created page with "Create list of All Houston: -startups -accelerators -etc Decide what categories to include in each & make a form -Name -Location -Desc -contact info -accelerator Create Map") |
|||
| (22 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | =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 | ||
| + | **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
