US Incubators

Project

US Incubators
Project Information
Has title	US Incubators
Has owner	Yi Ma
Has start date
Has deadline date
Has project status	Active
Copyright © 2019 edegan.com. All Rights Reserved.

Objective

The objective of this project is to assemble a near-population dataset on U.S. incubators! This project uses the Incubator Seed Data.

File Location

E:\projects\Kauffman Incubator Project\01 Classify entrepreneurship ecosystem organizations\YiMaResearch\US Incubators

Notes:

• Highlighted rows need to be deleted
• The format of zip code field is text

Progress

Extract incubator data from the following sources

• National Data

Source	Progress	How many?	Data	Method
Whartoneclub Incubators	Done	21	url, Company Name, City, State	regular expression
InterNational Business Incubation Association or see our INBIA page	Done	415	Company Name, address, ,city, state, zip code, country, url and contact person	regular expression
Clustermapping	Done	292	Company name, description, address 1, address 2, city, state, zip code	regular expression
The MBA Is Dead	Link doesn't work	186 Results	City and Country low equity, high offer, high value high equity, low offer, low value	regular expression

• Regional Data

Source	Progress	How many?	Region	Data	Method
Alabama Business Incubation Network	Done	12	Alabama	Incubator Name, URL, and Brief Description	regular expression
Florida Business Incubation Association	Done	72	Florida	incubator name, address, city, state, phone number and url	regular expression
Louisiana Business Incubation Association	Done	25	Louisiana	incubator name contact name address and phone number link to website	regular expression
Maryland Business Incubation Association	Done	35	Maryland	Incubator name, short description, and link to another page within main site with contains a link to the incubator home page	regular expression
Massachusetts Association of Business Incubators	Done	21	Massachusetts	incubator name, short description, and link to incubator home page	regular expression
Boston Startup Guide	Done	10	Boston	Company Name and URL Capital Provided & equity taken Application Process	regular expression
Michigan Business Innovation Association	Done	15	Michigan	company name, ulr, address, url, city, state, zip code	regular expression
NH Tech Alliance	Done	10	New Hampshire	company name, city, url, brief description	regular expression
NC Business Incubation Association	Done	33	North Carolina	Incubator name, address, contact, title, phone number, url and email	Manual Data Collection
Oklahoma Business Incubator Association	Done	34	Oklahoma	Incubator name and link to it	regular expression
Incubators/Accelerators In DC	Done	55*	DC	Incubator name and link to it and brief description	regular expression
High Tech News and Information for South California	Done	34	California	Url, company name, description, city, state	regular expression
Leagal Counsel to Entrepreneurs and Emerging Growth Companies	Done	25	Los Angeles	Url, company name, city, state, description	regular expression
Washington State Department of Commerce	Not Done	25	WA	Url, company name, address, city, state, zipcode	manual collection
Seattle Incubators	Done	10	Seattle	Company name, url, description	regular expression
Digital NYC	Done	25	NYC	Company name, description	regular expression

Notes:

• 55* includes both incubators and accelerators
• Clustermapping contains non-US data. They have been highlighted in the spreadsheet

Useful Regular Exes

1. Replace “\s+$” with [leave blank] to remove all the empty lines

2. Replace "s+$" with [leave blank] to removes all the whitespaces

3. <.*> finds everything that starts with < and ends with >

4. Replace href=" with "\n" to start a new line for each url

5. Replace "\s\s+" with [leave blank] to remove more than one white spaces

6. Replace "(?-s)^(.+)\R(.+)\R(.+)\R(.+)\R(.+)\R(.+)\R" with "\1\2\3\4\5\6\r\n" to merge every six lines

7. Replace "[ ]{2,}" with [leave blank] removes more than one spaces between two words