7,612
edits
Changes
Jump to navigation
Jump to search
Subsumed ProjectsTwo new files were generated from the '''crunchbase3''' dbase as follows:{{#show: Ecosystem Organization Classifier|?Does subsume}}
This project is dependent \COPY (SELECT uuid, company_name, short_description FROM Organizations WHERE country_code='USA' AND short_description LIKE '%incubat%') TO 'CrunchbaseShortOrgDescsUSAIncubat.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV --466 \COPY (SELECT A.uuid, A.company_name, B.description FROM Organizations AS A JOIN organization_descriptions AS B on:A.uuid=B.uuid WHERE country_code='USA' AND description LIKE '%incubat%') TO 'CrunchbaseLongOrgDescsUSAIncubat.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV{{#show: Ecosystem Organization Classifier|?Is dependent on}} --933
==Incubator Scores of Crunchbase Results==These files were put in E:\projects\crunchbase3.
==4. New Columns - 1. #; 2. Company with URL to page linked; 3. Self-Identified Incubator [Y/N]; 4. State; 5. City; 6. Region; 7. Lists Client Companies [Y/N] with URL linked; 8. Fixed Duration [Y - 0 /N - 1]: (Startups at an incubator generally do not all stay for the same fixed duration; Incubator does not have a fixed graduation date for its startups or has a program that lasts longer than one year); 9. Incubator Investment [Y - 0 /N - 1]: (Incubator does not invest directly in the company or take equity in its startups); 10. Cohorts [Y - 0 /N - 1]: Incubator does not have limited-duration programs that ventures enter and exit in groups, known as cohorts or batches.; 11. Formal Application Process Notes [Y - 0 /N - 1]: (Selective, competitive admissions process; Fixed, not rolling application process); 12. Incubator Score out of 4 (A score of 4 is most likely to be an incubator and a score of 0 is less likely to be an incubator based on our baseline attributes for Calculating Incubator Scores==an incubator [[Defining Incubators]])
15. New file Deleted Columns - Renamed E:\projects\crunchbase3\organizations as E:\projects\crunchbase3\organizations_OnlyIncubators_PlusIncubatorScoresfunding_rounds; roles; permalink; domain; funding rounds
26. Only US Delete Closed Incubators - CTRL+Fed for "US" and deleted non-US based organizationsFiltered 'status' column to exclude showing results that are 'closed'
37. Incubator Made A Table - CTRL+Fed for "incubator" and deleted organizations that didn't identify as an incubatorConverted entire worksheet into a table to filter more easily
4. New Columns - 1. #; 2. Company with URL to page linked; 38. Identified Self-Identified Incubator [Y/N]; 4. State; 5. City; 6. Region; 7. Fixed Duration [Y Incubators - 0 /N Created a custom- 1]: (Startups at an incubator generally do not all stay for auto filter that searched the same fixed duration; Incubator does not have a fixed graduation date 'short description' for its startups or has a program that lasts longer than one year); 8. Incubator Investment [Y - 0 /N - 1]: (Incubator does not invest directly in the company or take equity in its startups); 9. Cohorts [Y - 0 /N - 1]'contains: Incubator does not have limited-duration programs that ventures enter and exit in groups, known as cohorts or batches.; 10. Formal Application Process [Y - 0 /N - 1]: (Selective, competitive admissions process; Fixed, not rolling application process); 11. Incubator Score out of 4 (A score of 4 is most likely to be an incubator and a score of 0 is less likely to be an incubator based on our baseline attributes for an incubator [[Defining Incubators]])incubat'
Ecosystem Organization Classifier (view source)
Revision as of 13:41, 21 September 2020
, 13:41, 21 September 2020no edit summary
{{Project
|Has project output=Data
|Has sponsor=Kauffman Incubator Project
|Has title=Ecosystem Organization Classifier
|Has owner=Libby Bassini, Anne Freeman,
The purpose of this project is to build a classifier, which takes the description of an ecosystem organization (i.e., a startup, a venture capitalist, an incubator, etc.) and either correctly classifies the organization's type or correctly classifies incubators vs. non-incubators.
==Related Projects==
Subsumed Projects:
{{#show: Ecosystem Organization Classifier|?Does subsume}}
This project is dependent on:
{{#show: Ecosystem Organization Classifier|?Is dependent on}}
===Text Processing===
We can use [[The Matcher (Tool)]] to match organization names to portfolio companies and VC funds and firms taken from '''vcdb3''' (see [[VentureXpert Database]]). We will also search this data by hand for incubators to get an initial set. Later on, we'll match our early list of incubators to crunchbase organization names to expand our list.
==Related ProjectsIncubator Scores of Crunchbase Results== {| class="wikitable sortable" style="width:100%"|-! style="width: 2%" | # ! style="width: 9%" | Company! style="width: 2%" | Self Described [Y/N]! style="width: 9%" | State! style="width: 9%" | City! style="width: 7%" | Region! style="width: 7%" | Lists Client Companies [Y/N]! style="width: 9%" | Fixed Duration [Y - 0 /N - 1]! style="width: 5%" | Incubator Investment [Y - 0 /N - 1]! style="width: 9%" | Cohorts [Y - 0 /N - 1] ! style="width: 9%" | Formal Application Process [Y - 0 /N - 1]! style="width: 9%" | Incubator Score out of 4 ! style="width: 9%" | Notes (Foreign, Virtual, Social Impact, or other observations)|-||||||||||||-|} ==Process Notes for Calculating Incubator Scores==
1. New file - Renamed E:\projects\crunchbase3\organizations as E:\projects\crunchbase3\organizations_OnlyIncubators_PlusIncubatorScores
2. Only US - CTRL+Fed for "US", created a column filter for only USA companies, and deleted non-US based organizations
3. Incubator - CTRL+Fed for "incubator" and deleted organizations that didn't identify as an incubator
