S0101 Age and Sex for All Places in State

The columns returned will be different for the most recent year versus other years.

Most Recent Year;

Delete D – Q

Delete M – MA

Delete V – AH

Delete AE – DA

Insert 2 Columns to the left of B

Truncate the MySQL staging table: “aa_co_mu_demographics”

Other Years:

Delete D – I

Delete I - FC

Delete N - T

Delete S – BC

Insert 2 columns to the left of B

Id,Year,FIPSCode,Id2,Geography,TotalUnder5,Skip1,MaleUnder5,Skip2,FemaleUnder5,Total65Over,Skip3,Male65Over,Skip4,Female65Over,TotalMedianAge,Skip5,MaleMedianAge,Skip6,FemaleMedianAge

Topic: Age

Geography: All Places in State

In CSV delete first row

Need to keep Under 5 columns and Median Age columns

Delete Column D:Q.

Delete Columns M:MW.

Delete columns V:CR (rest of the columns)

Insert 2 columns to left of B

Rename columns to: Id,Year,FIPSCode,Id2,Geography,TotalUnder5,Skip1,Skip2, Skip3,MaleUnder5,Skip4,Skip5, Skip6,FemaleUnder5,Total65Over,Skip3,Male65Over,Skip4,Female65Over,TotalMedianAge,Skip7,Skip8, Skip9,MaleMedianAge,Skip4,FemaleMedianAge

Enter the year in column B and copy down

Enter this FIPS formula in column C and copy down =RIGHT(D2,5)

Townships

Delete Column D:I (For 2017 D:Q)

Keep Columns: D:H.

Delete I:FC (For 2017 M:MA) This keeps 65 and over %

Keep Columns: D:M.

Delete N:T (For 2017 V:AH)

Delete S:BC (For 2017 AE:DA)

Rename Columns to: Id,Year,FIPSCode,Id2,Geography,TotalUnder5,Skip1,MaleUnder5,Skip2,FemaleUnder5,Total65Over,Skip3,Male65Over,Skip4, Female65Over,TotalMedianAge,Skip8,MaleMedianAge,Skip10,Skip11,Skip12,FemaleMedianAge

Counties

Delete Column D:Q

Keep Columns: D:L.

Delete M:MW

Keep Columns: M:U.

Delete V:CT

Rename Columns to: Id,Year,FIPSCode,Id2,Geography,TotalUnder5,Skip1,Skip2, Skip3,Skip4,Skip5,MaleUnder5,Skip6,Skip7,Skip8,FemaleUnder5,TotalMedianAge,Skip9,Skip10,Skip11,MaleMedianAge,Skip10,Skip11,Skip12,FemaleMedianAge