Difference between revisions of "Start-Ups of Houston (Map)"

From edegan.com
Jump to navigation Jump to search
 
(36 intermediate revisions by 5 users not shown)
Line 1: Line 1:
{{McNair Projects
+
{{Project
|[[File:HoustonSkyline.jpg]]
+
|Has project output=Content
|Project Title=Start-Ups of Houston (Map)
+
|Has title=Start-Ups of Houston (Map)
|Topic Area=Entrepreneurship Ecosystems
+
|Has owner=Ben Baldazo
|Owner=Ben Baldazo
+
|Has start date=Summer 2016
|Start Term=Summer 2016
+
||Has keywords=Hubs, Houston, Venture, Capital, Startups, Crowding-out,Data
|End Term=
+
|Has sponsor=McNair Center
|Status=Active
+
|Has notes=
|Deliverable=Other
+
|Is dependent on=
|Audience=Academics, Entrepreneurs, General Public
+
|Depends upon it=
 +
|Has project status=Subsume
 +
}}
 +
Under [[Houston Entrepreneurship]] umbrella.
 +
 
 +
Linked in [[Houston Accelerators and Incubators (Report)]]
  
|Keywords=Hubs, Houston, Venture, Capital, Startups, Crowding-out
 
|Primary Billing=AccKauffman01
 
}}
 
 
==Abstract==
 
==Abstract==
 
Using lists mined from websites, weblists, and databases, this map will be precisely locating and diagraming the Startups of Houston, TX. Later incorporations will include corresponding wiki pages for individual companies as well as maps of startup resources (including: accelerators, incubators, Angels and VC firms).
 
Using lists mined from websites, weblists, and databases, this map will be precisely locating and diagraming the Startups of Houston, TX. Later incorporations will include corresponding wiki pages for individual companies as well as maps of startup resources (including: accelerators, incubators, Angels and VC firms).
Line 18: Line 20:
 
=Report=
 
=Report=
  
{| class="wikitable collapsible collapsed"
+
From File [[File:HStartupMaster7.xlsx]]
 +
 
 +
1454 rows (Company Names), 11 data columns (including name)
 +
Column Names: normname, industry, website, descr, street, city, zip, totraised, founddate, accelerator, accelerator2
 +
 
 +
11 accelerators, 6 companies with 2
 +
 
 +
{| class="wikitable collapsible collapsed sortable"
 
! colspan="11"|Startups in Houston
 
! colspan="11"|Startups in Houston
 
|-
 
|-
Line 2,945: Line 2,954:
 
| Will 2 Love||||https://cancer-sexuality.com/||Will 2 Love provides mobile online counseling for sexual or fertility problems related to cancer or other chronic illness.||4225 Executive Square, Suite 420||La Jolla, CA||92037||||||TMCx||
 
| Will 2 Love||||https://cancer-sexuality.com/||Will 2 Love provides mobile online counseling for sexual or fertility problems related to cancer or other chronic illness.||4225 Executive Square, Suite 420||La Jolla, CA||92037||||||TMCx||
 
|}
 
|}
 +
 +
==Processes==
 +
 +
'''Steps taken'''
 +
#Mined websites like AngelList, Cruchbase, StartupBlink, Houston Startups List, etc.
 +
#Cleaned data
 +
##Columns align with headers all the way down
 +
##Websites actually belong to the company (Not youtube or angellist)
 +
##There are no "new lines" in individual cells
 +
##There are no open quotes (or really just no quotes in general is best)
 +
#Uploaded into the Houston psql database
 +
##Saved as UTF-8 encoding
 +
#Used Matcher to Match compiled names against itself
 +
##Used this matched file to standardize/normalize names for future data consolidating
 +
#Made distinct list of Houston Startups using file above
 +
#Made a priority list for importing data into the Masterfile
 +
#Using priority list populated empty columns in Masterfile with each of the mined tables
 +
##had to go back separate some things out like addresses or multiple accelerators
 +
#exported MasterFile into excel
 +
 +
'''Future Steps'''
 +
#Use who is parser to fill gaps (addresses and founding dates)
 +
#upload individual startups into their own wiki
 +
#repeat these steps with Venture firms, Angels (& Groups), Accelerators, Incubators, Service Firms, Flex & Co-working spaces, Event Spaces, etc.
  
 
==References==
 
==References==
Line 2,962: Line 2,995:
 
<includeonly>
 
<includeonly>
 
[[Category: McNair Projects]]
 
[[Category: McNair Projects]]
</includeonly><!-- flush -->
+
[[Internal Classification: Houston| ]]
 +
</includeonly><!-- flush flush --><!-- flush flush --><!-- flush flush -->
 +
[[Category:Internal]]

Latest revision as of 13:39, 21 September 2020


Project
Start-Ups of Houston (Map)
Project logo 02.png
Project Information
Has title Start-Ups of Houston (Map)
Has owner Ben Baldazo
Has start date Summer 2016
Has deadline date
Has keywords Hubs, Houston, Venture, Capital, Startups, Crowding-out, Data
Has project status Subsume
Subsumed by: Houston Entrepreneurship
Has sponsor McNair Center
Has project output Content
Copyright © 2019 edegan.com. All Rights Reserved.

Under Houston Entrepreneurship umbrella.

Linked in Houston Accelerators and Incubators (Report)

Abstract

Using lists mined from websites, weblists, and databases, this map will be precisely locating and diagraming the Startups of Houston, TX. Later incorporations will include corresponding wiki pages for individual companies as well as maps of startup resources (including: accelerators, incubators, Angels and VC firms).

Report

From File File:HStartupMaster7.xlsx

1454 rows (Company Names), 11 data columns (including name) Column Names: normname, industry, website, descr, street, city, zip, totraised, founddate, accelerator, accelerator2

11 accelerators, 6 companies with 2

Processes

Steps taken

  1. Mined websites like AngelList, Cruchbase, StartupBlink, Houston Startups List, etc.
  2. Cleaned data
    1. Columns align with headers all the way down
    2. Websites actually belong to the company (Not youtube or angellist)
    3. There are no "new lines" in individual cells
    4. There are no open quotes (or really just no quotes in general is best)
  3. Uploaded into the Houston psql database
    1. Saved as UTF-8 encoding
  4. Used Matcher to Match compiled names against itself
    1. Used this matched file to standardize/normalize names for future data consolidating
  5. Made distinct list of Houston Startups using file above
  6. Made a priority list for importing data into the Masterfile
  7. Using priority list populated empty columns in Masterfile with each of the mined tables
    1. had to go back separate some things out like addresses or multiple accelerators
  8. exported MasterFile into excel

Future Steps

  1. Use who is parser to fill gaps (addresses and founding dates)
  2. upload individual startups into their own wiki
  3. repeat these steps with Venture firms, Angels (& Groups), Accelerators, Incubators, Service Firms, Flex & Co-working spaces, Event Spaces, etc.

References

https://angel.co/

http://www.startupblink.com/Houston-startups

http://houston.startups-list.com/

https://www.crunchbase.com/#/home/index

SDC Platinum

Ed Egan