US Incubators - Revision history

Ed at 17:43, 21 September 2020

2020-09-21T17:43:35Z

Ed at 17:34, 21 September 2020

2020-09-21T17:34:23Z

Ed at 16:29, 20 September 2020

2020-09-20T16:29:16Z

Ed: /* Extract incubator data from data on regional resources */

2019-10-03T23:36:07Z

Extract incubator data from data on regional resources

Ed: /* Extract incubator data from data on regional resources */

2019-10-03T18:13:46Z

Extract incubator data from data on regional resources

YiMa: /* Extract incubator data from data on regional resources */

2019-06-24T22:33:05Z

Extract incubator data from data on regional resources

YiMa: /* Extract incubator data from data on regional resources */

2019-06-06T17:37:03Z

Extract incubator data from data on regional resources

YiMa: /* Extract incubator data from data on regional resources */

2019-06-06T17:22:42Z

Extract incubator data from data on regional resources

YiMa: /* Extract incubator data from data on regional resources */

2019-06-06T17:22:07Z

Extract incubator data from data on regional resources

YiMa: /* Extract incubator data from data on regional resources */

2019-06-06T17:20:45Z

Extract incubator data from data on regional resources

@@ Line 1: / Line 1: @@
 {{Project
-|Has project output=
+|Has project output=Data,How-to
 |Has sponsor=Kauffman Incubator Project
 |Has title=US Incubators

@@ Line 1: / Line 1: @@
 {{Project
 |Has sponsor=Kauffman Incubator Project
 |Has title=US Incubators

@@ Line 1: / Line 1: @@
 {{Project
 |Has title=US Incubators
 |Has owner=Yi Ma,

← Older revision		Revision as of 23:36, 3 October 2019
Line 420:		Line 420:

	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).		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==		==Retrieving Incubators from Crunchbase Database==

@@ Line 418: / Line 418: @@
 *Nevada includes incubators, accelerators and coworking space
 *Clustermapping contains non-US data. They have been highlighted in the spreadsheet
 ==Retrieving Incubators from Crunchbase Database==

@@ Line 353: / Line 353: @@
 | ND
 | Company Name, URL, Address, City, State Code, Description
 | Manual
 |-

@@ Line 346: / Line 346: @@
 | NC
 | Company Name, Address, City, State Code, Contact Person, Title, Phone Number, URL, email
 | Manual
 |-

@@ Line 341: / Line 341: @@
 | Regular Exes
 |-
-| {http://www.ncincubation.org/NCIncubators.aspx North Carolina Business Incubation Association]
+| [http://www.ncincubation.org/NCIncubators.aspx North Carolina Business Incubation Association]
 | Done
 | 33

@@ Line 341: / Line 341: @@
 | Regular Exes
 |-
-||
+| {http://www.ncincubation.org/NCIncubators.aspx North Carolina Business Incubation Association]
-[http://startup.choosewashingtonstate.com/resources/work-spaces/ Washington State Department of Commerce]
+| Done
 | Done
 | 25
@@ Line 362: / Line 368: @@
 | Company name, description
 | regular expression
 |-
 | [https://www.oregon4biz.com/Innovate-&-Create/R&D-Business/Incubators/ Business Oregon]