Changes

Jump to navigation Jump to search
809 bytes added ,  11:01, 29 June 2017
no edit summary
*Employment rate
*Unemployment rate
 
==Schooling Data==
 
Data on schooling was obtained from American Communities Survey, US Census Bureau.
 
Raw Data is in:
E:\McNair\Projects\Hubs\Summer 2017\School Enrollment Data by MSA
Cleaned files are in
Z:\Hubs\2017\merging_on_ID
They contain:
*MSA code
*MSA
*Year
*Total population 3 years and over enrolled in school
*Percent of population 3 years and over enrolled in public school
*Percent of population 3 years and over enrolled in private school
 
Date from 2005-2015
 
The SQL file that merges schooling data from ACS (by MSA - Year) with the MSA-City file is titled '''schooling.sql'''.
The file is located in:
Z:\Hubs\2017
 
The final table is in db '''cities''' titled '''merged_schooling'''.
 
It includes:
*MSA
*City
*Year
*Total
*Percent_public_schooling
*Percent_private_schooling
135

edits

Navigation menu