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