Census Population by Race with Hispanic

American Fact Finder:

Geography (4 of them):

United States, States, All Counties in Michigan, Local Units

Topic: Race & Ethnicity: Hispanic or Latino

For all but Local Units:

Report: PEPSR5H Annual Estimates of the Resident Population…

For Local Units:

Geography: Name, Township/Census County Division

Within a State, Michigan

Check All

Add

Report: B03002 Hispanic or Latino Origin by Race

Download, Use, OK, Download

Save: name the file with year, Geography, Race (like “2018 Local Units Race.zip”)

In Excel

Delete first row

MySQL staging table: “aa_co_census_ethnicity”

Delete all the Margin Columns

Delete Columns M and N (these are parts of a subtotal)

Delete Columns U and V (these are parts of a subtotal)

Delete columns N – T

Rename Columns:

A: Skip1

B: FIPSCode

C: Geography

D: EstimateTotal

E: NotHispanicorLatino

F: NotHispanicorLatinoWhite

G: NotHispanicBlackorAfricanAmerican

H: NotHispanicAmericanIndianandAlaskaNative

I: NotHispanicAsian

J: NotHispanicNativeHawaiianandOtherPacificIslander

K: NotHispanicSomeotherrace

L: NotHispanicTwomoreraces

M: Hispanic

Run the MySQL scripts in: “CO Census Race LU”