Census Single Parent

Topic: People: Marital & Fertility Status: Marital Status

Table: S1101 Households & Families

MySQL Staging Table: aa_co_census_household

SQL Scruipts: CO Census Family Status

MS Excel Steps

Delete 1^st Row

Delete Columns E

Delete Columns F

Delete Columns G

Delete Columns H

Delete Columns I

Delet Column I – GP

Insert 4 columns to the left of B

Column Names: ID, MunID, StateFIPS, FIPSCode, SchoolYear, ID2, Geography, TotalHouseholds, MarriedCouple, MaleHouseholder, FemaleHouseholder, NonfamilyHouseholder

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_census_household

Tableau Public chart name: Municipal Demographics