ACS Profiles: Variable Metadata

This table shows how MCDC derives the values used in the ACS Profile report for the corresponding period. The codes in the definition refer to the U.S. Census Bureau's ACS base tables and variables. Example: Our Age5_9 variable is created from the sum of lines 004 (males 5 to 9 years) and 028 (females 5 to 9 years) from the ACS base table B01001.

D1. AGE

Universe: Total population

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
TotPopB01001i001
Age0_4Children under 5 years of ageB01001i003 + B01001i027TotPop
Age5_9Children between 5 and 9 years of ageB01001i004 + B01001i028TotPop
Age10_14Children between 10 and 14 years of ageB01001i005 + B01001i029TotPop
Age15_19Children between 15 and 19 years of ageB01001i006 + B01001i007 + B01001i030 + B01001i031TotPop
Age20_24Persons 20 to 24 years of ageB01001i008 + B01001i009 + B01001i010 + B01001i032 + B01001i033 + B01001i034TotPop
Age25_34Persons 25 to 34 years of ageB01001i011 + B01001i012 + B01001i035 + B01001i036TotPop
Age35_44Persons 35 to 44 years of ageB01001i013 + B01001i014 + B01001i037 + B01001i038TotPop
Age45_54Persons 45 to 54 years of ageB01001i015 + B01001i016 + B01001i039 + B01001i040TotPop
Age55_59Persons 55 to 59 years of ageB01001i017 + B01001i041TotPop
Age60_64Persons 60 to 64 years of ageB01001i018 + B01001i019 + B01001i042 + B01001i043TotPop
Age65_74Persons 65 to 74 years of ageB01001i020 + B01001i021 + B01001i022 + B01001i044 + B01001i045 + B01001i046TotPop
Age75_84Persons 75 to 84 years of ageB01001i023 + B01001i024 + B01001i047 + B01001i048TotPop
Over85Persons 85 and olderB01001i025 + B01001i049TotPop
MedianAgeB01002i001TotPop
Over5Persons 5 years of age and olderB16001i001TotPop
Over15Persons 15 years of age and olderB12001i001TotPop
Under18Children under 18 years of ageB01001i003 + B01001i004 + B01001i005 + B01001i006 + B01001i027 + B01001i028 + B01001i029 + B01001i030TotPop
Over18Persons 18 years of age and olderB01001i007 + B01001i008 + B01001i009 + B01001i010 + B01001i011 + B01001i012 + B01001i013 + B01001i014 + B01001i015 + B01001i016 + B01001i017 + B01001i018 + B01001i019 + B01001i020 + B01001i021 + B01001i022 + B01001i023 + B01001i024 + B01001i025 + B01001i031 + B01001i032 + B01001i033 + B01001i034 + B01001i035 + B01001i036 + B01001i037 + B01001i038 + B01001i039 + B01001i040 + B01001i041 + B01001i042 + B01001i043 + B01001i044 + B01001i045 + B01001i046 + B01001i047 + B01001i048 + B01001i049TotPop
Over21Persons 21 years of age and olderB01001i009 + B01001i010 + B01001i011 + B01001i012 + B01001i013 + B01001i014 + B01001i015 + B01001i016 + B01001i017 + B01001i018 + B01001i019 + B01001i020 + B01001i021 + B01001i022 + B01001i023 + B01001i024 + B01001i025 + B01001i033 + B01001i034 + B01001i035 + B01001i036 + B01001i037 + B01001i038 + B01001i039 + B01001i040 + B01001i041 + B01001i042 + B01001i043 + B01001i044 + B01001i045 + B01001i046 + B01001i047 + B01001i048 + B01001i049TotPop
Over25Persons 25 years of age and olderB01001i011 + B01001i012 + B01001i013 + B01001i014 + B01001i015 + B01001i016 + B01001i017 + B01001i018 + B01001i019 + B01001i020 + B01001i021 + B01001i022 + B01001i023 + B01001i024 + B01001i025 + B01001i035 + B01001i036 + B01001i037 + B01001i038 + B01001i039 + B01001i040 + B01001i041 + B01001i042 + B01001i043 + B01001i044 + B01001i045 + B01001i046 + B01001i047 + B01001i048 + B01001i049TotPop
Over62Persons 62 years of age and olderB01001i019 + B01001i020 + B01001i021 + B01001i022 + B01001i023 + B01001i024 + B01001i025 + B01001i043 + B01001i044 + B01001i045 + B01001i046 + B01001i047 + B01001i048 + B01001i049TotPop
Over65Persons 65 years of age and olderB09020i001TotPop

D2. AGE AND SEX

Universe: Total population

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
TotPopB01001i001
MalesB01001i002TotPop
Over18MalesMales 18 years of age and olderB05003i008Males
Over65MalesMales 65 years of age and olderB01001i020 + B01001i021 + B01001i022 + B01001i023 + B01001i024 + B01001i025Males
FemalesB01001i026TotPop
Over18FemalesFemales 18 years of age and olderB05003i019Females
Over65FemalesFemales 65 years of age and olderB01001i044 + B01001i045 + B01001i046 + B01001i047 + B01001i048 + B01001i049Females

D3. RACE

Universe: Total population

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
TotPopB01001i001
OneRacePersons of one raceB02001i002 + B02001i003 + B02001i004 + B02001i005 + B02001i006 + B02001i007TotPop
White1Persons who are WhiteB02001i002TotPop
Black1Persons who are African AmericanB02001i003TotPop
Indian1Persons who are American Indian or Alaska NativeB02001i004TotPop
Asian1Persons who are AsainB02001i005TotPop
HawnPI1Persons who are Native Hawaiian or other Pacific IslanderB02001i006TotPop
Other1Persons of some other raceB02001i007TotPop
MultiRacePersons who are two or more racesB02001i008TotPop
White2B02008i001TotPop
Black2B02009i001TotPop
Indian2B02010i001TotPop
Asian2B02011i001TotPop
HawnPI2B02012i001TotPop
Other2B02013i001TotPop

D4. HISPANIC OR LATINO (ANY RACE)

Universe: Total population

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
TotPopB03002i001
HispanicPopPersons with a Hispanic ethnicityB03002i012TotPop
NonHispPopPersons without a Hispanic ethnicityB03002i002TotPop
NonHispWhiteB03002i003TotPop
NonHispBlackB03002i004TotPop
NonHispAmIndB03002i005TotPop
NonHispAsianB03002i006TotPop
NonHispHawnPIB03002i007TotPop