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.

E1. HOUSEHOLD INCOME AND BENEFITS

Universe: Total households

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
TotHHsB19001i001
HHInc0Household income less than $10,000B19001i002TotHHs
HHInc10Household income between $10,000 and $14,999B19001i003TotHHs
HHInc15Household income between $15,000 and $24,999B19001i004 + B19001i005TotHHs
HHInc25Household income between $25,000 and $34,999B19001i006 + B19001i007TotHHs
HHInc35Household income between $35,000 and $49,999B19001i008 + B19001i009 + B19001i010TotHHs
HHInc50Household income between $50,000 and $74,999B19001i011 + B19001i012TotHHs
HHInc75Household income between $75,000 and $99,999B19001i013TotHHs
HHInc100Household income between $100,000 and $149,999B19001i014 + B19001i015TotHHs
HHInc150Household income between $150,000 and $199,999B19001i016TotHHs
HHInc200Household income greater than $200,000B19001i017TotHHs
NumHHEarningsHouseholds with earningsB19051i002TotHHs
NumHHSocSecHouseholds with social security incomeB19055i002TotHHs
NumHHRetIncHouseholds with retirement incomeB19059i002TotHHs
NumHHSuppSecIncHouseholds with supplemental security incomeB19056i002TotHHs
NumHHPubAssistHouseholds with cash public assistance incomeB19057i002TotHHs
NumHHFoodStmpHouseholds with food stamp benefits in the past 12 monthsB22001i002TotHHs
MedianHHIncB19013i001TotHHs
AvgHHIncB19025i001 / B19001i001TotHHs
AvgHHEarningsB19061i001 / B19051i002NumHHEarnings
AvgHHSocSecB19065i001 / B19055i002NumHHSocSec
AvgHHRetIncB19069i001 / B19059i002NumHHRetInc
AvgHHSuppSecIncB19066i001 / B19056i002NumHHSuppSecInc
AvgHHPubAssistB19067i001 / B19057i002NumHHPubAssist

E2. FAMILY INCOME AND BENEFITS

Universe: Family households

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
FamHHsB19101i001TotHHs
FamHHInc0Family households with income less than $10,000B19101i002FamHHs
FamHHInc10Family households with income between $10,000 and $14,999B19101i003FamHHs
FamHHInc15Family households with income between $15,000 and $24,999B19101i004 + B19101i005FamHHs
FamHHInc25Family households with income between $25,000 and $34,999B19101i006 + B19101i007FamHHs
FamHHInc35Family households with income between $35,000 and $49,999B19101i008 + B19101i009 + B19101i010FamHHs
FamHHInc50Family households with income between $50,000 and $74,999B19101i011 + B19101i012FamHHs
FamHHInc75Family households with income between $75,000 and $99,999B19101i013FamHHs
FamHHInc100Family households with income between $100,000 and $149,999B19101i014 + B19101i015FamHHs
FamHHInc150Family households with income between $150,000 and $199,999B19101i016FamHHs
FamHHInc200Family households with income of $200,000 or moreB19101i017FamHHs
MedianFamIncB19113i001FamHHs
AvgFamIncB19127i001 / B19101i001FamHHs

E3. OTHER INCOME MEASURES

Universe: Various

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
PCIB19301i001TotPop
NonFamHHsB11001i007TotHHs
MedianNonFamIncB19202i001NonFamHHs
AvgNonFamIncB19214i001 / B11001i007NonFamHHs
FullTimeWorkersB19325i003 + B19325i050
FullTimeWorkersMaleB19325i003FullTimeWorkers
FullTimeWorkersFemaleB19325i050FullTimeWorkers
MedianEarningsB20017i001FullTimeWorkers
MedianEarningsMaleB20017i003FullTimeWorkersMale
MedianEarningsFemaleB20017i006FullTimeWorkersFemale

E4. POVERTY STATUS OVER THE LAST 12 MONTHS

Universe: Persons for whom poverty status is determined

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
PovUniverseB17001i001
PoorB17001i002PovUniverse
PovRatioUnderHalfC17002i002PovUniverse
PovRatiov5tov99C17002i003PovUniverse
PovRatio1to2C17002i004 + C17002i005 + C17002i006 + C17002i007PovUniverse
PovRatioOver2C17002i008PovUniverse
PovUniverseUnder18B17001i004 + B17001i005 + B17001i006 + B17001i007 + B17001i008 + B17001i009 + B17001i018 + B17001i019 + B17001i020 + B17001i021 + B17001i022 + B17001i023 + B17001i033 + B17001i034 + B17001i035 + B17001i036 + B17001i037 + B17001i038 + B17001i047 + B17001i048 + B17001i049 + B17001i050 + B17001i051 + B17001i052
PoorUnder18B17001i004 + B17001i005 + B17001i006 + B17001i007 + B17001i008 + B17001i009 + B17001i018 + B17001i019 + B17001i020 + B17001i021 + B17001i022 + B17001i023PovUniverseUnder18
PovUniverse18_64B17001i010 + B17001i011 + B17001i012 + B17001i013 + B17001i014 + B17001i024 + B17001i025 + B17001i026 + B17001i027 + B17001i028 + B17001i039 + B17001i040 + B17001i041 + B17001i042 + B17001i043 + B17001i053 + B17001i054 + B17001i055 + B17001i056 + B17001i057
Poor18to64B17001i010 + B17001i011 + B17001i012 + B17001i013 + B17001i014 + B17001i024 + B17001i025 + B17001i026 + B17001i027 + B17001i028PovUniverse18_64
PovUniverseOver65B17001i015 + B17001i016 + B17001i029 + B17001i030 + B17001i044 + B17001i045 + B17001i058 + B17001i059
PoorOver65B17001i015 + B17001i016 + B17001i029 + B17001i030PovUniverseOver65
PovUniverseFamilyPop(B17021i003 - B17021i006 - B17021i010 - B17021i013 + B17021i020 - B17021i023 -B17021i027 -B17021i030)PovUniverse
PovUniverseUnrelatedB17007i001
PoorInFamily(B17021i003 - B17021i006 - B17021i010 - B17021i013)PovUniverseFamilyPop
PoorFamiliesB17010i002Families
PoorUnrelatedB17007i002PovUniverseUnrelated

E5. EMPLOYMENT STATUS

Universe: Population 16 years and over

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
Over16B23025i001
LaborForceB23025i002Over16
CivLabForceB23025i003Over16
EmployedCLFB23025i004CivLabForce
UnemployedCLFB23025i005CivLabForce
MilitaryB23025i006Over16
NotInLFB23025i007Over16
Over16FemalesB23001i088Over16
LaborForceFemalesB23001i090 + B23001i097 + B23001i104 + B23001i111 + B23001i118 + B23001i125 + B23001i132 + B23001i139 + B23001i146 + B23001i153 + B23001i160 + B23001i165 + B23001i170Over16
CivLabForceFemalesB23001i092 + B23001i099 + B23001i106 + B23001i113 + B23001i120 + B23001i127 + B23001i134 + B23001i141 + B23001i148 + B23001i155 + B23001i160 + B23001i165 + B23001i170Over16
EmployedFemalesB23001i093 + B23001i100 + B23001i107 + B23001i114 + B23001i121 + B23001i128 + B23001i135 + B23001i142 + B23001i149 + B23001i156 + B23001i161 + B23001i166 + B23001i171CivLabForceFemales

E6. CHILDREN WITH ALL PARENTS WORKING

Universe: Own children under 18 years in families and subfamilies

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
OwnKidsUnder6B23008i002
OwnKidsU6AllPrntsWkB23008i004 + B23008i010 + B23008i013OwnKidsUnder6
OwnKidsOver6B23008i015
OwnKidsO6AllPrntsWkB23008i017 + B23008i023 + B23008i026OwnKidsOver6

E7. COMMUTING TO WORK

Universe: Workers 16 years and over

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
Worker16B08301i001
CommutersB08301i002 + B08301i010 + B08301i016 + B08301i017 + B08301i018 + B08301i019 + B08301i020Worker16
DriveAloneB08301i003Worker16
CarpoolB08301i004Worker16
PublicTransB08301i010Worker16
WalkToWorkB08301i019Worker16
OtherCommuteB08301i016 + B08301i017 + B08301i018 + B08301i020Worker16
WorkAtHomeB08301i021Worker16
AvgCommuteB08013i001 / B08302i001Commuters

E8. WORKERS BY OCCUPATION

Universe: Civilian employed population 16 years and over

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
EmployedCLFC24010i001
ManProfOccsC24010i003 + C24010i039EmployedCLF
ServiceOccsC24010i019 + C24010i055EmployedCLF
SalesOffOccsC24010i027 + C24010i063EmployedCLF
FarmFishOccsC24010i031 + C24010i067EmployedCLF
ConsOccsC24010i032 + C24010i033 + C24010i068 + C24010i069EmployedCLF
TransOccsC24010i034 + C24010i070EmployedCLF

E9. WORKERS BY INDUSTRY

Universe: Civilian employed population 16 years and over

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
EmployedCLFC24030i001
AgricultureC24030i003 + C24030i030EmployedCLF
ConstructionC24030i006 + C24030i033EmployedCLF
ManufacturingC24030i007 + C24030i034EmployedCLF
WholesaleTradeC24030i008 + C24030i035EmployedCLF
RetailTradeC24030i009 + C24030i036EmployedCLF
TransportationC24030i010 + C24030i037EmployedCLF
InformationC24030i013 + C24030i040EmployedCLF
Finance_InsC24030i014 + C24030i041EmployedCLF
ProfessionalC24030i017 + C24030i044EmployedCLF
Educ_Health_SocSvcsC24030i021 + C24030i048EmployedCLF
RecreationEtcC24030i024 + C24030i051EmployedCLF
OtherIndustriesC24030i027 + C24030i054EmployedCLF
PublicAdminC24030i028 + C24030i055EmployedCLF

E10. CLASS OF WORKER

Universe: Civilian employed population 16 years and over

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
EmployedCLFB24080i001
PrivWageWorkersB24080i003 + B24080i006 + B24080i013 + B24080i016EmployedCLF
GovWorkersB24080i007 + B24080i008 + B24080i009 + B24080i017 + B24080i018 + B24080i019EmployedCLF
SelfEmpWorkersB24080i010 + B24080i020EmployedCLF
UnpaidFamWorkersB24080i011 + B24080i021EmployedCLF

E11. INSURANCE COVERAGE

Universe: Civilian noninstitutionalized population

Variable nameLabelDefinition (formula used to derive)DenominatorWeight variable
TotPopNonInstB18135i001
NonInstUnder65B18135i002 + B18135i013TotPopNonInst
NotInsuredUnder65B18135i007 + B18135i012 + B18135i018 + B18135i023NonInstUnder65
PublicInsuranceUnder65B18135i006 + B18135i011 + B18135i017 + B18135i022NonInstUnder65
PrivateInsuranceOnlyUnder65B18135i005 + B18135i010 + B18135i016 + B18135i021NonInstUnder65
NonInstUnder18B18135i002TotPopNonInst
NotInsuredUnder18B18135i007 + B18135i012NonInstUnder18