7,612
edits
Changes
Jump to navigation
Jump to search
| regular expression
|-
| [https://www.louisianaincubation.org/current-members Louisiana Business Incubation Association]
| Done
| 25
| Louisiana
|
* incubator name
* contact name
* address and phone number
* link to website
| regular expression
|-
| [http://incubatemaryland.org/incubators/ 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
|-
| [https://www.massincubators.org/ Massachusetts Association of Business Incubators]
| Done
| 21
| Massachusetts
| incubator name, short description, and link to incubator home page
| regular expression
|-
| [https://www.viethconsulting.com/members/googlemaps/google_maps.php?mode=normal&orgcode=MBIA Michigan Business Innovation Association]
| Done
| 15
| Michigan
| company name, ulr, address, url, city, state, zip code
| [https://livefreeandstart.com/resources/incubators-makerspaces/ NH Tech Alliance ]
| Done
| 10
| New Hampshire
| company name, city, url, brief description
| regular expression
|-
| regular expression
|-
| [https://dmped.dc.gov/page/incubators-accelerators-and-co-working-spaces Incubators/Accelerators In DC]
| Done
| 55*
| DC
| Incubator name and link to it and brief description
| regular expression
|-
| [https://commerce.idaho.gov/business-climate/entrepreneurial-culture/ Idaho Commerce]
| Done
| 14
| Idaho
| URL, company name, city
no edit summary
{{Project
|Has project output=Data,How-to
|Has sponsor=Kauffman Incubator Project
|Has title=US Incubators
|Has owner=Yi Ma,
=Progress=
==Extract incubator data from the following sourcesdata on national resources==
*National Data
| Done
| 21
| * url, Company Name, City, State* company name* city* state
| regular expression
|-
* low equity, high offer, high value
* high equity, low offer, low value
|regular expression|-| [http://www.gaebler.com/Business-Incubator-Lists-By-State.htm Gaebler]| Done| 360 Results|* incubator name* url| regular expression
|}
:*Regional DataGaebler incubator list is in E:\projects\Kauffman Incubator Project\01 Classify entrepreneurship ecosystem organizations\Gaebler\Results.txt and the script to retrieve the results is in the same director and called Gaebler.py. ==Extract incubator data from data on regional resources==
{| class="wikitable"
|-
| Florida
| incubator name, address, city, state, phone number and url
| regular expression
|-
* Capital Provided & equity taken
* Application Process
| regular expression
|-
| [http://www.ncincubation.org/NCIncubators.aspx NC Business Incubation Association]
| Done
| Oklahoma
| Incubator name and link to it
| regular expression
|-
| regular expression
|-
| [https://ideagist.com/list-of-startup-accelerators-and-incubators-in-colorado-usa/ IdeaGist- Colorado]
| Done
| 8
| Colorado
| Company name, url, location
| Manual collection
|-
| [https://ideagist.com/list-of-startup-accelerators-and-incubators-in-connecticut-usa/ IdeaGist - Connecticut]| Done| 7| Connecticut| Company name, url, location| Manual collection|-| [https://www.delawarebusinesstimes.com/coworking-incubators/ Delaware Business Times]| Done| 11| DE| URL, company name, address, city, state code, phone number, email, description| Regular expression|-| [https://dmped.dc.gov/page/incubators-accelerators-and-co-working-spaces Incubators/Accelerators In DC]| Done| 55*| DC| Incubator name and link to it and brief description| regular expression|-| [http://www.fbiaonline.org/Incubators/incubators.htm Florida Business Incubation Association]| Done| 72| FL| Company name, address, city, state code, zip code, phone number, URL| regular expression|- | [https://www.georgia.org/business-incubators Georgia Department of Economic Development]| Done| 12| GA| URL, company name, address, city, state code, zip code, phone number, contact person| regular expression|-| [https://ideagist.com/list-of-startup-accelerators-and-incubators-in-hawaii-usa/ IdeaGist - Hawaii] [http://www.buzgate.org/8.0/hi/fh_incubators.html?cb=none Business Utility Zone Gateway]| Done| 3| HI| Company name, url, city, state code| manual collection|-| [https://commerce.idaho.gov/business-climate/entrepreneurial-culture/ Idaho Commerce]| Done| 14| IO| URL, company name, city| regular expression|-| [https://ideagist.com/list-of-startup-accelerators-and-incubators-in-illinois-usa/ IdeaGist - Illinois]| Done| 18| IL| Company name, url, city, state code| manual collection|-| [https://ideagist.com/list-of-startup-accelerators-and-incubators-in-indiana-usa/ IdeaGist - Indiana]| Done| 3| IN| Company name, url, city, state code| manual collection|-| [https://www.iasourcelink.com/resources/business-incubators-accelerators-and-coworks IA SourceLink] [https://ideagist.com/list-of-startup-accelerators-and-incubators-in-iowa-usa/ IdeaGist - Iowa]| Done| 10| IA| Company name, city, state code, url, description, email, contact person, phone number| manual collection|-| [https://ideagist.com/list-of-startup-accelerators-and-incubators-in-kansas-usa/ IdeaGist - Kansas] [https://innovatekansas.org/innovation-resources/ InnovateKansas]| Done| 3| KS| Company name, url, city, state code| manual collection|-| [https://www.thinkkentucky.com/Entrepreneurship/Accelerators_Incubators.aspx ThinkKentucky]| Done| 10| KY| Company name, address, city, state code, zip code, url, description| regular expression|-| [https://www.louisianaincubation.org/current-members Louisiana Business Incubation Association]| Done| 25| LA| Company name, contact person, title, address, city, state code, zip code, phone number, email, url| regular expression|-| [http://www.innovatorsguide.org/incubators/maine_business_incubators.htm Innovators Guide - Maine]| Done| 4| ME| URL, company name, city, state code| regular expression|-| [http://incubatemaryland.org/incubators/ Maryland Business Incubation Association]| Done| 35| MD| URL, company name, state code, description| regular expression|-| [https://www.massincubators.org/ Massachusetts Association of Business Incubators]| Done| 21| MA| Company Name, URL, State Code, Description| regular expression|-| [https://www.viethconsulting.com/members/googlemaps/google_maps.php?mode=normal&orgcode=MBIA Michigan Business Innovation Association]| Done| 15| MI| Company Name, URL, Address, City, State Code, Zip Code| regular expression|-| [https://www.americaninno.com/minne/guides-minne/everything-you-need-to-know-about-minnesotas-startup-incubators-and-accelerators/ MinneInno] [https://ideagist.com/list-of-accelerators-and-incubators-in-minnesota/ IdeaGist - Minnesota]| Done| 7| MN| URL, Company Name, City, State Code, Description| Regular Exes|-| [https://www.mississippi.org/home-page/business-services/entrepreneurs-small-business/mississippi-business-incubators/ Mississippi Delevlopment Authority]| Done| 26| MS| Company Name, Address, City, State Code, Zip Code, Phone Number, Contact Person, Title, Email, URL| Regular Exes|-|-| [https://www.mosourcelink.com/guides/innovation-led/wet-labs-and-technology-incubators SourceLink - MO] [https://ideagist.com/list-of-startup-accelerators-and-incubators-in-missouri-usa/ IdeaGist - Missouri]| Done| 23| MO| Company Name, URL, City, State Code, Description| Regular Exes|-| [https://ideagist.com/list-of-startup-accelerators-and-incubators-in-montana-usa/ IdeaGist - Montana]| Done| 2| MT| Company Name, URL, City, State Code| Manual|-| [https://www.omaha.com/special_sections/outlook/accelerators-incubators-help-boost-startups/article_97005ca0-1949-57e6-87bc-21fc4df9adba.html Omaha World Herald]| Done| 9| NE| Company Name, Address, City, State Code, Phone Number, URL, Description| Regular Exes|-| [http://business.nv.gov/Resource_Center/Coworking/_Incubator/_Accelerator_Spaces/ Department of Business and Industry - Nevada]| Done| 25| NV| URL, Company Name, State Code, Description| Regular Exes|-| [https://livefreeandstart.com/resources/incubators-makerspaces/ NH Tech Alliance ]| Done| 10| NH| Company Name, City, State Code, URL, Description| Regular Exes|-| [https://libguides.rutgers.edu/c.php?g=336746&p=2267151 Rutgers University Libraries]| Done| 15| NJ| URL, Company Name, City, State Code| Regular Exes|-| [https://gonm.biz/business-development/start/small-business-incubators-accelerators New Mexico Economic Development]| Done| 8| NM| Company Name, State Code, URL, Description| Regular Exes|-| [https://fuzehub.com/fuzehub-blog/fuzehub-report-new-york-state-incubators-and-innovation-hot-spots/ FuzeHub]| Done| 33| NY| URL, Company Name, Type, Manufacturing Sector, Services, Description| Regular Exes|-| [http://www.ncincubation.org/NCIncubators.aspx North Carolina Business Incubation Association]| Done| 33| NC| Company Name, Address, City, State Code, Contact Person, Title, Phone Number, URL, email| Manual|-| [https://www.business.nd.gov/aviation/TechnologyParksandIncubators/ Economic Development and Finance of North Dakota]| Done| 2| ND| Company Name, URL, Address, City, State Code, Description| Manual|-| [https://ideagist.com/list-of-startup-accelerators-and-incubators-in-ohio-usa/ IdeaGist - Ohio]| Done| 7| OH| Company Name, URL, Ciry, State Code| Manual|-|[http://startup.choosewashingtonstate.com/resources/work-spaces/ Washington State Department of Commerce]
| Done
| 25
| NYC
| Company name, description
| regular expression
|-
| Arkansas
| URL, Company name, description
| Regular Expressionregular expression|-| [https://www.creativeportland.com/resources/incubators-business-counseling CreativePortland]| Done| 11| Portland| Company name, url, description| regular expression
|}
*Oregon includes both incubators and accelerators
*Arizona includes both incubators and accelerators
*Nevada includes incubators, accelerators and coworking space
*Clustermapping contains non-US data. They have been highlighted in the spreadsheet
DC, Oregon, Arizona and Nevada where all reprocessed in '''US Incubators - Reviewed By Ed.xlsx''' and files named statename-incubators.txt were created for import. For these 4 states, organizations were excluded by default and only included if they self-identified as an incubator in some fashion (name, description, etc.). Note that the US incubators data contains social impact incubators (though it does not appear to contain virtual ones as it is location based).
The SQL script LoadTables.sql, in E:\projects\Kauffman Incubator Project\01 Classify entrepreneurship ecosystem organizations\YiMaResearch\US Incubators, loads all of the tables in the '''incubators''' dbase and does the basic manipulation of the data. This code is also in Incubators.sql in E:\projects\Kauffman Incubator Project -- and this file's version was the last one updated.
The resulting assembly of the state data, which also includes cities like Los Angeles, Boston, NYC, and others, results in the '''USIncubators''' table and corresponding '''USIncubators.txt''' text file, which has 707 records and the following fields with the following coverage:
*orgname --707
*statecode --707
*url --609
*description --343
*city --524
*address --252
*zip --235
==Retrieving Incubators from Crunchbase Database==
==Loading/Unloading Data==
Always load/unload data using the PostgreSQL specific copy function below. Always load tab-delimited data that is UTF-8 encoded, with PC or UNIX line endings, and that has a header row. NEVER DEVIATE FROM THIS(unless there is a VERY good reason, like the source data is huge and comes preformatted differently).
Load using:
<nowiki>\COPY tablename FROM 'filename.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV</nowiki>
Unload (copy to txt file) using:
<nowiki>\COPY tablename TO 'filename.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV</nowiki>
==Creating Tables==
