Census 2010 Profile Report

This table shows how MCDC derives the values used in the MCDC 2010 Summary File 1 Profiles reports. The codes in the definition refer to the U.S. Census Bureau's 2010 SF1 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 SF1 base table P12.

D1. TOTAL POPULATION TRENDS, ETC.

Universe: Total population

Variable nameLabelDefinition (formula used to derive)Universe variableWeight variable
TotPopTotal populationP1i1
TotPop2kTotal population, 2000TotPop2000
PopChangeChange in population, 2000-2010TotPop - TotPop2k
MaleMalesp12i2TotPop
FemaleFemalesp12i26TotPop
PopSqmiPopulation densityTotPop / landsqmi
LandSqmiLand area (square miles)landsqmi

D2. AGE

Universe: Total population

Variable nameLabelDefinition (formula used to derive)Universe variableWeight variable
Age0_4Persons under 5 years oldp12i3 + p12i27TotPop
Age5_9Persons 5 to 9 years oldp12i4 + p12i28TotPop
Age10_14Persons 10 to 14 years oldp12i5 + p12i29TotPop
Age15_17Persons 15 to 17 years oldp12i6 + p12i30TotPop
Age18_19Persons 18 to 19 years oldp12i7 + p12i31TotPop
Age20_24Persons 20 to 24 years oldp12i8 + p12i9 + p12i10 + p12i32 + p12i33 + p12i34TotPop
Age25_34Persons 25 to 34 years oldp12i11 + p12i12 + p12i35 + p12i36TotPop
Age35_44Persons 35 to 44 years oldp12i13 + p12i14 + p12i37 + p12i38TotPop
Age45_54Persons 45 to 54 years oldp12i15 + p12i16 + p12i39 + p12i40TotPop
Age55_59Persons 55 to 59 years oldp12i17 + p12i41TotPop
Age60_64Persons 60 to 64 years oldp12i18 + p12i19 + p12i42 + p12i43TotPop
Age65_74Persons 65 to 74 years oldp12i20 + p12i21 + p12i22 + p12i44 + p12i45 + p12i46TotPop
Age75_84Persons 75 to 84 years oldp12i23 + p12i24 + p12i47 + p12i48TotPop
Over85Persons 85 and olderp12i25 + p12i49TotPop
MedianAgeMedian agep13i1TotPop
Under18Children under 18 years oldAge0_4 + Age5_9 + Age10_14 + Age15_17TotPop
Age15_19Persons 15 to 19 years oldp12i6 + p12i7 + p12i30 + p12i31TotPop
Age18_24Persons 18 to 24 years oldAge18_19 + Age20_24TotPop
Age25_44Persons 25 to 44 years oldAge25_34 + Age35_44TotPop
Age45_64Persons 45 to 64 years oldAge45_54 + Age55_59 + Age60_64TotPop
Over18Persons 18 and olderp12i7 + p12i8 + p12i9 + p12i10 + p12i11 + p12i12 + p12i13 + p12i14 + p12i15 + p12i16 + p12i17 + p12i18 + p12i19 + p12i20 + p12i21 + p12i22 + p12i23 + p12i24 + p12i25 + p12i31 + p12i32 + p12i33 + p12i34 + p12i35 + p12i36 + p12i36 + p12i37 + p12i38 + p12i39 + p12i40 + p12i41 + p12i42 + p12i43 + p12i44 + p12i45 + p12i46 + p12i47 + p12i48 + p12i49TotPop
Over18_maleMales 18 and olderp12i7 + p12i8 + p12i9 + p12i10 + p12i11 + p12i12 + p12i13 + p12i14 + p12i15 + p12i16 + p12i17 + p12i18 + p12i19 + p12i20 + p12i21 + p12i22 + p12i23 + p12i24 + p12i25TotPop
Over18_femaleFemales 18 and olderp12i31 + p12i32 + p12i33 + p12i34 + p12i35 + p12i36 + p12i37 + p12i38 + p12i39 + p12i40 + p12i41 + p12i42 + p12i43 + p12i44 + p12i45 + p12i46 + p12i47 + p12i48 + p12i49TotPop
Over21Persons 21 and olderp12i9 + p12i10 + p12i11 + p12i12 + p12i13 + p12i14 + p12i15 + p12i16 + p12i17 + p12i18 + p12i19 + p12i20 + p12i21 + p12i22 + p12i23 + p12i24 + p12i25 + p12i33 + p12i34 + p12i35 + p12i36 + p12i37 + p12i38 + p12i39 + p12i40 + p12i41 + p12i42 + p12i43 + p12i44 + p12i45 + p12i46 + p12i47 + p12i48 + p12i49TotPop
Over62Persons 62 and olderp12i19 + p12i20 + p12i21 + p12i22 + p12i23 + p12i24 + p12i25 + p12i43 + p12i44 + p12i45 + p12i46 + p12i47 + p12i48 + p12i49TotPop
Over65Persons 65 and olderAge65_74 + Age75_84 + Over85TotPop
Over65_maleMales 65 and olderp12i20 + p12i21 + p12i22 + p12i23 + p12i24 + p12i25TotPop
Over65_femaleFemales 65 and olderp12i44 + p12i45 + p12i46 + p12i47 + p12i48 + p12i49TotPop

D3. RACE

Universe: Total population

Variable nameLabelDefinition (formula used to derive)Universe variableWeight variable
One_Race_totalOne racep3i2 + p3i3 + p3i4 + p3i5 + p3i6 + p3i7TotPop
White1Whitep3i2TotPop
Black1Black or African Americanp3i3TotPop
IndianAmerican Indian / Alaska Nativep3i4TotPop
Asian1Asianp3i5TotPop
HawnPI1Native Hawaiian / Other Pacific Islanderp3i6TotPop
Other1Some other racep3i7TotPop
MultRaceTwo or more racesp3i8TotPop
White2White (alone or in combination)p6i2TotPop
Black2Black (alone or in combination)p6i3TotPop
Indian2American Indian / Alaska Native (alone or in combination)p6i4TotPop
Asian2Asian (alone or in combination)p6i5TotPop
Hawnpi2Native Hawaiian / Other Pacific Islander (alone or in combination)p6i6TotPop
Other2Some other race (alone or in combination)p6i7TotPop
HawaiianNative Hawaiianpct8i3TotPop
Guam_or_ChamGuamanian or Chamorropct8i8TotPop
SamoanSamoanpct8i4TotPop
Other_Pac_IslndrOther Pacific Islanderpct8i1 - (pct8i3 + pct8i8 + pct8i4)TotPop
Asian_indianAsian Indianpct5i2TotPop
ChineseChinesepct5i7TotPop
FilipinoFilipinopct5i8TotPop
JapaneseJapanesepct5i11TotPop
KoreanKoreanpct5i12TotPop
VietnameseVietnamesepct5i20TotPop
OtherAsianOther Asianpct5i1 - (pct5i2 + pct5i17 + pct5i8 + pct5i11 + pct5i12 + pct5i20)TotPop

D4. HISPANIC OR LATINO AND RACE

Universe: Total population

Variable nameLabelDefinition (formula used to derive)Universe variableWeight variable
HispPopHispanic or Latino (of any race)p4i3TotPop
MexicanMexicanpct11i4TotPop
PuertoRicanPuerto Ricanpct11i5TotPop
CubanCubanpct11i6TotPop
OtherHispanicOther Hispanic or Latinopct11i3 - (pct11i4 + pct11i5 + pct11i6)TotPop
Non_HispanicNot Hispanic or Latinop4i2TotPop
White_Non_HispWhite alone, not Hispanicp5i3TotPop

H1. HOUSEHOLD COMPOSITION

Universe: Total population

Variable nameLabelDefinition (formula used to derive)Universe variableWeight variable
HHpopTotal persons in householdsp29i2TotPop
HouseholderHouseholderp29i4 + p29i19 + p29i22TotPop
SpouseSpousep29i7TotPop
ChildChildp29i8 + p29i9 + p29i10TotPop
OwnChild_under18Own child under 18p31i5TotPop
Other_RelativesOther relativesp29i11 + p29i12 + p29i13 + p29i14 + p29i15 + p29i16TotPop
NonrelativesNonrelativesp29i17 + p29i25TotPop
NonreltvUnder18Nonrelatives under 18p31i13TotPop
NonreltvOver65Nonrelatives over 65p34i11 + p34i19TotPop
UnmarriedPartnerUnmarried partnerpct19i5 + pct19i10TotPop

H2. HOUSEHOLDS BY TYPE

Universe: Households

Variable nameLabelDefinition (formula used to derive)Universe variableWeight variable
TotHHsTotal householdsp15i1
FamiliesFamily householdsp18i2TotHHs
FamilyKidsLT18With own children under 18p19i8 + p19i12 + p19i15TotHHs
Married_CoupleMarried-couple familyp19i7TotHHs
MarrdCplKidsLT18With own children under 18p19i8TotHHs
FemaleHhldrFemale householder, no husband presentp19i14TotHHs
SingleMomsWith own children under 18p19i15TotHHs
NonFamily_HHsNonfamily householdsp18i7TotHHs
UnmPartnerHHsUnmarried-partner householdspct15i13TotHHs
SameSexPrtnrHHsSame-sex unmarried-partner householdspct15i14 + pct15i24TotHHs
LivingAloneHouseholder living alonep29i20 + p29i23TotHHs
HousehldrOver65Householder 65 years and olderp21i17TotHHs
HHsIndvLT18Households with individuals under 18p20i2TotHHs
HHsIndvOvr65Households with individuals 65 and olderp25i2TotHHs
AvgHHoldSizeAverage household sizep17i1TotHHs
AvgFamilySizeAverage family sizep37i1

H3. GROUP QUARTERS

Universe: Total population

Variable nameLabelDefinition (formula used to derive)Universe variableWeight variable
GQpopPopulation in group quartersp42i1TotPop
Institution_popInstitutionalized populationp42i2TotPop
CorrectionalPopPopulation In correctional institutionsp42i3 + p42i4TotPop
NursingHomePopPopulation in nursing homesp42i5TotPop
OtherInstPopPopulation in other institutionsp42i6TotPop
NonInstGQPopNoninstitutionalized group quarters population p42i7TotPop
CollegeDormsCollege dormitories, including off-campus college quartersp42i8TotPop
MilitaryQtrsMilitary quartersp42i9TotPop
OthrNoninstGQPopOther noninstitutional group quarters populationp42i10TotPop

H4. HOUSING OCCUPANCY AND TENURE

Universe: Housing units

Variable nameLabelDefinition (formula used to derive)Universe variableWeight variable
Tot_UnitsTotal housing unitsh1i1
Occupied_UnitsOccupied housing unitsh3i2Tot_Units
OwnerOccupiedOwner-occupied housing unitsh4i2 + h4i3Occupied_Units
RenterOccupiedRenter-occupied housing unitsh4i4Occupied_Units
VacantUnitsVacant housing unitsh5i1Tot_Units
VacantForRentVacant for renth5i2Tot_Units
VacantForSaleVacant for saleh5i4Tot_Units
SeasonalVacant for seasonal, recreational or occasional useh5i6Tot_Units
OwnerTotTotal owner units, including units for saleOwnerOccupied + VacantForSaleTot_Units
RenterTotTotal rental units, including units vacant for rentRenterOccupied + VacantForRentTot_Units
OwnerVacrateHomeowner vacancy rate(VacantForSale / OwnerTot) * 100OwnerTot
RentalVacrateRental vacancy rate(VacantForRent / RenterTot) * 100RenterTot
PopInOwnerUnitsPopulation in owner-occupied unitsh11i2 + h11i3TotPop
PopInRentedUnitsPopulation in rented unitsh11i4TotPop
AvgSizeOwnerAverage size of owner-occupied unitsh12i2OwnerOccupied