Changes

Jump to navigation Jump to search
697 bytes added ,  09:39, 29 June 2017
no edit summary
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
135

edits

Navigation menu