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.

S1. HOUSEHOLDS BY TYPE

Universe: Total households

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
TotHHsB11001i001
FamiliesB11003i001TotHHs
FamsWithKidsB11003i003 + B11003i010 + B11003i016TotHHs
MarriedCouplesB11003i002TotHHs
CouplesWithKidsB11003i003TotHHs
SingleMaleFamiliesB11005i006 + B11005i015TotHHs
SingleFathersB11003i010TotHHs
SingleFemaleFamiliesB11005i007 + B11005i016TotHHs
SingleMothersB11003i016TotHHs
NonFamHHsB11010i001TotHHs
LivingAloneB11010i003 + B11010i010NonFamHHs
Over65AloneB11010i005 + B11010i012NonFamHHs
HHsWithKidsB11005i002TotHHs
HHsWithEldersB11007i002TotHHs
AvgHHSizeB11002i001 / B19001i001TotHHs
AvgFamSize(B11002i004 + B11002i007 + B11002i010) / B11001i002Families

S2. PERSONS BY HOUSEHOLD TYPE / GROUP QUARTERS

Universe: Total population

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
TotPopB09019i001
HHPopB09019i002TotPop
FamHHpopB09019i003HHPop
NonFamHHpopB09019i024HHPop
LivingAloneB09019i027 + B09019i030HHPop
GrpQuartersB09019i038TotPop

S3. RELATIONSHIP

Universe: Household population

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
HHPopB09019i002HHPop
HouseholderB09019i004 + B09019i025HHPop
SpouseB09019i007HHPop
ChildB09019i008HHPop
OtherRelativeB09019i012 + B09019i013 + B09019i014 + B09019i015 + B09019i016 + B09019i017HHPop
NonRelativeB09019i018 + B09019i032HHPop
UnmarriedPartnerB09019i021 + B09019i035HHPop
UMPartnerHHsPerK1000*(B09019i021 + B09019i035) / B19001i001TotHHs

S4. MARITAL STATUS

Universe: Population 15 years and over

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
Over15B12001i001
NeverMarriedB12001i003 + B12001i012Over15
MarriedB12001i005 + B12001i008 + B12001i014 + B12001i017Over15
SeparatedB12001i007 + B12001i016Over15
WidowedB12001i009 + B12001i018Over15
DivorcedB12001i010 + B12001i019Over15

S5. FERTILITY

Universe: Women 15 to 50 years old who gave birth in the past 12 months

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
Women15to50B13002i001
UnmarriedWomen15to50B13002i007 + B13002i016Women15to50
WomenGivingBirthB13002i002Women15to50
UnmarriedGivingBirthB13002i007Women15to50
Women15to19B13002i004 + B13002i008Women15to50
Women20to34B13002i005 + B13002i009Women15to50
Women35to50B13002i006 + B13002i010Women15to50
UnmarriedGivingBirthPerk1000 * B13002i007 / (B13002i007 + B13002i016)UnmarriedWomen15to50
GivingBirthPerk1000 * B13002i002 / B13002i001Women15to50
BirthRate15_191000 * B13016i003 / (B13016i003 + B13016i011)Women15to19
BirthRate20_341000 * (B13002i005 + B13002i009) / (B13002i005 + B13002i009 + B13002i014 + B13002i018)Women20to34
BirthRate35_501000 * (B13002i006 + B13002i010) / (B13002i006 + B13002i010 + B13002i015 + B13002i019)Women35to50

S6. GRANDPARENTS AS CAREGIVERS

Universe: Population 30 years and over

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
GrandPrntsLvngWithGrndkidB10050i002
GrandPrntsCaringB10050i003GrandPrntsLvngWithGrndkid
GrandPrntsCaringLT1B10050i004 + B10050i005GrandPrntsCaring
GrandPrntsCaring1or2B10050i006GrandPrntsCaring
GrandPrntsCaring3or4B10050i007GrandPrntsCaring
GrandPrntsCaring5orMoreB10050i008GrandPrntsCaring

S7. SCHOOL ENROLLMENT

Universe: Population 3 years and over

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
Over3B14002i001
EnrolledOver3B14002i003 + B14002i027Over3
InNurseryB14002i004 + B14002i028EnrolledOver3
InKindergartenB14002i007 + B14002i031EnrolledOver3
InElementaryB14002i010 + B14002i013 + B14002i034 + B14002i037EnrolledOver3
InHighSchoolB14002i016 + B14002i040EnrolledOver3
InCollegeB14002i019 + B14002i022 + B14002i043 + B14002i046EnrolledOver3

S8. EDUCATIONAL ATTAINMENT

Universe: Population 25 years and over

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
Over25B15002i001
LessThan9thB15002i003 + B15002i004 + B15002i005 + B15002i006 + B15002i020 + B15002i021 + B15002i022 + B15002i023Over25
SomeHighSchoolB15002i007 + B15002i008 + B15002i009 + B15002i010 + B15002i024 + B15002i025 + B15002i026 + B15002i027Over25
HighSchoolB15002i011 + B15002i028Over25
SomeCollegeB15002i012 + B15002i013 + B15002i029 + B15002i030Over25
AssociatesB15003i021Over25
BachelorsB15003i022Over25
GradProfB15003i023 + B15003i024 + B15003i025Over25
HighSchoolOrMoreB15003i017 + B15003i018 + B15003i019 + B15003i020 + B15003i021 + B15003i022 + B15003i023 + B15003i024 + B15003i025Over25
BachelorsormoreB15003i022 + B15003i023 + B15003i024 + B15003i025Over25

S9. VETERAN STATUS

Universe: Civilian population 18 years and over

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
CivilianB21001i001Over18
VeteranB21001i002Civilian

S10a. DISABLED BY AGE

Universe: Civilian noninstitutionalized population

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
TotPopNonInstB18135i001
DisabledB18135i003 + B18135i014 + B18135i025TotPopNonInst
NonInstUnder18B18135i002TotPopNonInst
DisabledUnder18B18135i003NonInstUnder18
NonInst18_64B18135i013TotPopNonInst
Disabled18_64B18135i014NonInst18_64
NonInstOver65B18135i024TotPopNonInst
DisabledElderB18135i025NonInstOver65

S11. RESIDENCE 1 YEAR AGO

Universe: Population 1 year and over

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
Over1B07204i001
SameHouseB07204i002Over1
DiffHouseB07204i003Over1
DiffHouseSameCountyB07204i005 + B07204i008DiffHouse
DiffCountyB07204i006 + B07204i009DiffHouse
DiffCntySameStateB07204i006 + B07204i010DiffHouse
DiffStateB07204i011DiffHouse
LivedAbroadB07204i016Over1

S12. PLACE OF BIRTH AND CITIZENSHIP STATUS

Universe: Total population

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
TotPopB05002i001
USNativeB05002i002TotPop
BornInUSB05002i003 + B05002i004USNative
BornInCurrStateB05002i003BornInUS
BornInDiffStateB05002i004BornInUS
BornAbroadB05002i009USNative
ForeignBornB05002i013TotPop
NaturalizedB05002i014ForeignBorn
NonCitizenB05002i021ForeignBorn

S13. YEAR OF ENTRY

Universe: Population born outside the United States

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
BornOutsideUSB05005i001TotPop
BornOutsideUSNativeB05005i003 + B05005i008 + B05005i013 + B05005i018BornOutsideUS
NativeEnteredGE2000B05005i003 + B05005i006BornOutsideUSNative
NativeEnteredLT2000B05005i013 + B05005i018BornOutsideUSNative
ForeignBornB05005i004 + B05005i009 + B05005i014 + B05005i019BornOutsideUS
FBEnteredGE2000B05005i004 + B05005i009ForeignBorn
FBEnteredLT2000B05005i014 + B05005i019ForeignBorn

S14. WORLD REGION OF BIRTH OF FOREIGN BORN

Universe: Foreign-born population, excluding population born at sea

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
FBMinusSeaB05006i001TotPop
FBEuropeB05006i002FBMinusSea
FBAsiaB05006i047FBMinusSea
FBAfricaB05006i091FBMinusSea
FBOceaniaB05006i117FBMinusSea
FBLatinAmericaB05006i124FBMinusSea
FBNorthAmericaB05006i160FBMinusSea

S15. LANGUAGE SPOKEN AT HOME

Universe: Population 5 years and over

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
Over5B06007i001TotPop
EnglishOnlyB06007i002Over5
OthLangB06007i003 + B06007i006Over5
OthLangEnglishLTDB06007i005 + B06007i008OthLang
SpanishB06007i003Over5
SpanishEnglishLTDB06007i005Spanish

S16. COMPUTER OWNERSHIP AND INTERNET USE

Universe: Total households

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
TotHHsB28003i001
NoComputerB28003i006TotHHs
ComputerB28003i002TotHHs
DialupInternetB28003i003Computer
BroadbandInternetB28003i004Computer
NoInternetB28003i005Computer