The table includes 8780 observations
==Employment Data==
Data on employment was obtained from American Communities Survey, US Census Bureau.
Raw Data is in:
E:\McNair\Projects\Hubs\Summer 2017\Employment Data by MSA
Cleaned files are in
Z:\Hubs\2017\merging_on_ID
They contain:
*MSA code
*MSA
*Year
*Employment rate of individuals 16 years or older
*Unemployment rate of individuals 16 years or older
Date from 2005-2015
The SQL file that merges employment data from ACS (by MSA - Year) with the MSA-City file is titled '''Employment.sql'''.
The file is located in:
Z:\Hubs\2017
The final table is in db '''cities''' titled '''merged_employment'''.
It includes:
*MSA
*City
*Year
*Employment rate
*Unemployment rate