7,649
edits
Changes
Jump to navigation
Jump to search
Ranking US Cities by Venture Capital (view source)
Revision as of 18:34, 13 September 2017
, 18:34, 13 September 2017→Files and data
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).
