135
edits
Changes
Jump to navigation
Jump to search
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
