Changes

Jump to navigation Jump to search
297 bytes added ,  17:50, 28 June 2017
E:\McNair\Projects\Hubs\Summer 2017\MSA Income_raw.zip
Cleaned files are in
EZ:\McNair\Projects\Hubs\Summer 2017\MSA_Income_cleaning merging_on_ID
They contain:
*MSA code
*MSA
*Year
Date from 2005-2015
 
The SQL file that merges income data from ACS (by MSA - Year) with the MSA-City file is titled '''income.sql'''. It is located here:
Z:\Hubs\2017
 
The final income table is in db '''cities''' titled '''merged_income'''.
 
It includes:
*MSA
*City
*Year
*Total Household Income
 
The table includes 8780 observations
76

edits

Navigation menu