School Census Race

American Fact Finder:

Race & Ethnicity à Race/Ethnicity of Individual à B03002

 

There is an Excel Macron to do these changes: CensusMacros.xlsm

 

Delete 1st row

Delete all columns that begin with Margin

Id, FIPSCode, Geography, ImpYear, Total, Skip1, White, BlackorAfricanAmerican, AmericanIndianandAlaskaNative, Asian, NativeHawaiianandOtherPacificIslander, Someotherracealone, Twoormoreraces, Skip2, Skip3, HispanicOrigin

 

Delet Columns Q:Y

 

Staging: aa_co_census_race

 

Run: CO Census Race à School Section at bottom