7,612
edits
Changes
Jump to navigation
Jump to search
no edit summary
{{Project
|Has project output=Data,How-to
|Has sponsor=Kauffman Incubator Project
|Has title=US Incubators
|Has owner=Yi Ma,
| 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]
*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==
