Census Population by Race

American Fact Finder:

Race & Ethnicity à Race/Ethnicity of Individual à B02001

For States and Counties Only:

In Excel

Delete first row

MySQL staging table: “aa_co_census_race”

Rename Columns:

A: Skip1

B: Year

C: Skip2

D: Gender

E: Skip3

F: HispanicOrigin

G: Skip4

F: TotalWhite

H: FIPSCode

J: White

K: BlackorAfricanAmerican

L: AmericanIndianandAlaska Native

M: Asian

N: NativeHawaiianandOtherPacificIslander

Run the MySQL scripts in: “CO Census Race”