Difference between revisions of "Start Up Address Finder Algorithm (Tool)"
Jump to navigation
Jump to search
| (16 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | {{McNair | + | {{Project |
| − | | | + | |Has project output=Tool |
| − | + | |Has sponsor=McNair Center | |
| − | | | + | |Has title=Start Up Address Finder Algorithm (Tool) |
| − | | | + | |Has owner=Jake Floyd |
| − | | | + | |Has start date=Summer 2016 |
| + | |Has notes= | ||
| + | |Is dependent on= | ||
| + | |Depends upon it= | ||
| + | |Has project status=Complete | ||
| + | |Has keywords=Tool | ||
}} | }} | ||
==Description== | ==Description== | ||
| Line 11: | Line 16: | ||
'''Input''': | '''Input''': | ||
| − | Crunchbase company list | + | Crunchbase company list (which includes large amounts of information about the company, including some funding information and founding information) |
'''Output''': | '''Output''': | ||
| Line 22: | Line 27: | ||
==Development Notes== | ==Development Notes== | ||
| − | '''7/7''': Project development | + | '''7/7''': Project development Notes: Beginning |
:Company list downloaded from Crunchbase. | :Company list downloaded from Crunchbase. | ||
| − | :Important information provided | + | :Important information provided from list including company name, url, country, state, region and city. |
:Data was analyzed to determine total number of companies as well as percentage of fields in which country, state, region, and city were not complete. This data was recorded in the image below. | :Data was analyzed to determine total number of companies as well as percentage of fields in which country, state, region, and city were not complete. This data was recorded in the image below. | ||
| Line 46: | Line 51: | ||
:::[[File:Correl_7-7-16.png]] | :::[[File:Correl_7-7-16.png]] | ||
| − | ::These values | + | ::These values made us confident that the order of the list was randomized |
:Following this the company name was entered into google in order to determine if the street level address could be found | :Following this the company name was entered into google in order to determine if the street level address could be found | ||
| Line 54: | Line 59: | ||
::A total of 160 companies were tested: | ::A total of 160 companies were tested: | ||
| − | :::140 Had | + | :::140 Had addresses on crunchbase |
:::Of the 20 that were not on crunch base 4 had address on both linkedin and bloomberg, while 1 had an address on only linkedin, and 3 had an address only listed on bloomberg | :::Of the 20 that were not on crunch base 4 had address on both linkedin and bloomberg, while 1 had an address on only linkedin, and 3 had an address only listed on bloomberg | ||
| Line 61: | Line 66: | ||
::The remaining 12 companies were checked to see if they could be found using a whois search | ::The remaining 12 companies were checked to see if they could be found using a whois search | ||
| + | |||
| + | :::Of these 11 contained a url | ||
| + | |||
| + | ::::Of these 11: 3 address were retrievable with a who is search will 8 were not | ||
| + | |||
| + | :::::Of the 8 within the category unable to retrieve; 4 were protected by godaddy.com; and could possibly be retrieved from there, also one had a .io url that could not be found | ||
| + | |||
| + | '''7/?''': Project development Notes (cont'd) | ||
| + | |||
| + | :To be filled for next section | ||
| + | |||
| + | [[Category: Internal]] | ||
| + | [[Internal Classification: Software| ]] | ||
Latest revision as of 12:47, 21 September 2020
| Start Up Address Finder Algorithm (Tool) | |
|---|---|
| Project Information | |
| Has title | Start Up Address Finder Algorithm (Tool) |
| Has owner | Jake Floyd |
| Has start date | Summer 2016 |
| Has deadline date | |
| Has keywords | Tool |
| Has project status | Complete |
| Has sponsor | McNair Center |
| Has project output | Tool |
| Copyright © 2019 edegan.com. All Rights Reserved. | |
Description
Notes: The Start Up Address Finder Algorithm aims to provide street level address for start ups contained within the Crunchbase database.
Input: Crunchbase company list (which includes large amounts of information about the company, including some funding information and founding information)
Output: Addresses (specific to street address) for every company known.
Algorithm
To be filled once project is completed
Development Notes
7/7: Project development Notes: Beginning
- Company list downloaded from Crunchbase.
- Important information provided from list including company name, url, country, state, region and city.
- Data was analyzed to determine total number of companies as well as percentage of fields in which country, state, region, and city were not complete. This data was recorded in the image below.
- Following this it was determined that the Seattle region would be used as a test region.
- 1070 Companies were contained within the Seattle region.
- Each company was assigned a random number using the randombetween() excel function.
- These companies were then sorted based upon this number (and assigned a new number based upon their new order for identification purposes)
- The function CORREL was then applied to find the relationship between random and assigned number (expected to be around 1 as this was an assigned number)
- Then the same function was used to determine the correlation between these numbers and funding total and funding date. The results are displayed below:
- These values made us confident that the order of the list was randomized
- Following this the company name was entered into google in order to determine if the street level address could be found
- After a short test it was noted that Crunchbase contained a significant amount of street level addresses, and this hypothesis was to be tested in order to see if this was a common trend
- A total of 160 companies were tested:
- 140 Had addresses on crunchbase
- Of the 20 that were not on crunch base 4 had address on both linkedin and bloomberg, while 1 had an address on only linkedin, and 3 had an address only listed on bloomberg
- This meant that 8 of the 20 companies could be found using linkedin and bloomberg
- The remaining 12 companies were checked to see if they could be found using a whois search
- Of these 11 contained a url
- Of these 11: 3 address were retrievable with a who is search will 8 were not
- Of the 8 within the category unable to retrieve; 4 were protected by godaddy.com; and could possibly be retrieved from there, also one had a .io url that could not be found
7/?: Project development Notes (cont'd)
- To be filled for next section
