Housing Owner-occupied & Rentals

Census Advanced Search: https://factfinder.census.gov/faces/nav/jsf/pages/index.xhtml

Topic: Housing:Basic Count/Estimate: Housing Units

Dataset: DP04 SELECTED HOUSING CHARACTERISTICS

Product Type: Subject Table

People: Income & Earnings – Income/Earnings (Households)

All Places within Michigan

In Select Geographies click Name and you can select Townships

MS Excel Steps

Delete 1^st Row

Delete Columns E - K

Delet Column F – FT

Delet Column G - I

Delete Columns H - OD

Insert 4 columns to the left of B

Column Names: ID, MunID, StateFIPS, FIPSCode, SchoolYear, ID2, Geography, TotalHousingUnits, VacantHousingUnits, OwnerOccupied, RenterOccupied

In C2 enter: “=LEFT(F2,2)” and copy down

In D2 enter: "=RIGHT(F2,5)" and copy down

Populate Column E with the Fiscal Year Downloaded

Import into MySQL stagig table: aa_co_mu_demographics

Tableau Public chart name: Municipal Demographics