7,612
edits
Changes
Jump to navigation
Jump to search
==Progress Report==This project was initially undertaken in the summer of 2017 and resulted in a full report on 2016.
==Project Overview==
===Main SQL file location===
===Population data location===
Ranking US Cities by Venture Capital (view source)
Revision as of 14:18, 13 March 2019
, 14:18, 13 March 2019no edit summary
==Project Description==
The data was then updated for 2017 and 2018 (Q1 and Q2), which resulted in a ranking spreadsheet and document, but not a full report. ==2017 and 2018 Q1/2 updates== The final files are in E:\mcnair\Projects\VentureXpert Database They include:*US and TX SEL Amount - Done.xlsx*Master Tables Sheet.docx*Top 15 States (Based on All Time SELAmnt) SEL vs Year - Done.xlsx*TX Cities Graphs and Data - Done.xlsx*Top 100 Cities 2017 - Done.xlsx*All States 2018 (Q1 and Q2) - Done.xlsx*All States 2017 - Done.xlsx*Top 100 Cities 2018 (Q1 And 2) - Done.xlsx The database is '''vcdb3''' and the SQL scripts are in E:\mcnair\Projects\VentureXpert Database\vcdb3\LoadingScripts The database build is documented in [[VentureXpert Data#Ranking Tables and Graphs]] ==2016 Report== ===Project Location===
E:\McNair\Projects\Ecosystem\Ranking
The report is available from that directory====Main SQL file location==Dependencies==
Ranking.sql
roundleveloutput2.txt is imported into cities as '''roundleveloutput2''', and then left joined with '''populationtablecorrected'''.
====Last Population SQL file location====
Z:\Hubs\2017\sql scripts
Z:\Hubs\2017\clean data\Population
'''populationtablecorrected''' is loaded from files 'population1.txt' and 'population2.txt'. Dups are removed with a max.
Their construction notes are on [[Hubs#Population_Data]]
