Difference between revisions of "Ranking US Cities by Venture Capital"
Jump to navigation
Jump to search
| Line 22: | Line 22: | ||
roundleveloutput2.txt is imported into cities as '''roundleveloutput2''', and then left joined with '''populationtablecorrected'''. This is done in last.population.sql, which is in | roundleveloutput2.txt is imported into cities as '''roundleveloutput2''', and then left joined with '''populationtablecorrected'''. This is done in last.population.sql, which is in | ||
Z:\Hubs\2017\sql scripts | Z:\Hubs\2017\sql scripts | ||
| + | |||
| + | ==Population issue== | ||
| + | |||
| + | One issue is that cities without populations in populationtablecorrected but in roundleveloutput2 get dropped later. For example, roundleveloutput2 contains Brooklyn, NY but populationtablecorrected doesn't (its New York count is therefore suspect too). | ||
Revision as of 19:34, 13 September 2017
| Ranking US Cities by Venture Capital | |
|---|---|
| Project Information | |
| Project Title | Ranking US Cities by Venture Capital |
| Owner | Ed Egan |
| Start Date | Summer 2017 |
| Deadline | |
| Primary Billing | |
| Notes | |
| Has project status | Active |
| Copyright © 2016 edegan.com. All Rights Reserved. | |
Files and data
The files are in:
E:\McNair\Projects\Ecosystem\Ranking
The main SQL file is:
Ranking.sql
This file works on the database cities.
However, the cities database takes vc data from vcdb2. See VC Database Rebuild for information on the build.
The output from vcdb2 is roundleveloutput2, which is exported as roundleveloutput2.txt
roundleveloutput2.txt is imported into cities as roundleveloutput2, and then left joined with populationtablecorrected. This is done in last.population.sql, which is in
Z:\Hubs\2017\sql scripts
Population issue
One issue is that cities without populations in populationtablecorrected but in roundleveloutput2 get dropped later. For example, roundleveloutput2 contains Brooklyn, NY but populationtablecorrected doesn't (its New York count is therefore suspect too).
