Metadata for the modotx Filetype (Partial listing of Variables90 dataset)

Table=1. Total Population and Population by Age Universe=Total Population

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight
Variable
TotPop Total Pop 1990 (Sample Est) P1i1      
FarmPop Rural Farm Population P6i3   TotPop  
NonFarmPop Rural Nonfarm Population P6i4   TotPop  
Age0_4 Under 5 sum(of p13i1-p13i3)   TotPop  
Age5_17 Age 5 to 17 sum(of p13i4-p13i12)   TotPop  
Age18_24 18 to 24 sum(of p13i13-p13i17)   TotPop  
Age25_34 25 to 34 sum(of p13i18-p13i19)   TotPop  
Age35_54 35 to 54 sum(of p13i20-p13i23)   TotPop  
Age55_64 55 to 64 sum(of p13i24-p13i26)   TotPop  
Age65_84 65 to 84 sum(of p13i27-p13i30)   TotPop  
Over85 85 and Over p13i31   TotPop  
Under18 Under 18 sum(of Age0_4 Age5_17)   TotPop  
Age18_64 18 to 64 sum(of Age18_24 Age25_34 Age35_54 Age55_64)   TotPop  
Over18 18 Years and Over TotPop - Under18   TotPop  
Over65 65 and Over sum(of Age65_84 Over85)   TotPop  

Table=2. Race and Hispanic Universe=Total Population

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight
Variable
White1 White p9i1   TotPop  
Black1 Black p9i2   TotPop  
Indian1 Amer Indian, Alaska Native sum(of p9i3-p9i5)   TotPop  
Asian1 Asian sum(of p9i6-p9i16)   TotPop  
HawnPI1 Hawaiian and Other PI sum(of p9i17-p9i24)   TotPop  
Other1 Other race p9i25   TotPop  
HispPop Hispanic p10i1   TotPop  
White1NH White Not Hispanic p12i1   TotPop  
Minority Minority Pop TotPop - White1NH   TotPop  
RacMinority Racial Minority Pop sum(of P12i2 P12i3 P12i4 P12i5)   TotPop  

Table=3. Relationship of Persons in Households Universe=Persons in Households

Variable Name Label Definition - Code used to
derive		 Comment Universe Variable Weight Variable
HHPop Persons in Households sum(of p17i1-p17i12) Formula was corrected 13Jul03 TotPop  
Householder Householder in Family household p17i1   HHpop  
Spouse Spouse p17i2   HHpop  
Child Child of Householder sum(of p17i3-p17i4)   HHpop  
Other_relative Other Relative sum(of p17i5-p17i6)   HHpop  
NonRelative NonRelative p17i7   HHpop  
TotHHs Total Households p5i1   HHpop  
AvgHHSize Average Household Size HHPop / TotHHs     TotHHs
Families Families P4i1 Family Households are those with 2 or more persons related by blood, marriage or adoption TotHHs  
FamPop Persons in Family Households sum(of p17i1-p17i7)   TotPop  
AvgFamSize Average Family Size FamPop / Families     Families

Table=4. Language Spoken at Home Universe=Persons 5 and Over

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight
Variable
Over5 5 Yrs of Age and Over sum(of p13i4-p13i31)   TotPop  
EnglishOnly Speak English Only sum(of p28i1 p28i11 p28i21)   Over5  
EnglishLimited Speak Eng less than "very well" sum(of p28i3 p28i13 p28i23 p28i6 p28i16 p28i26 p28i9 p28i19 p28i29)   Over5  
Spanish Speaks Spanish sum(of p28i2-p28i4 p28i12-p28i14 p28i22-p28i24)   Over5  
Spanishless Speak Spanish but English less than well sum(of p28i4 p28i14 p28i24)   Spanish  

Table=5. Residence in 1985 Universe=Persons 5 Yrs and Over

Variable Name Label Definition - Code used to
derive		 Comment Universe Variable Weight
Variable
SameHouse Lived in Same House 5 Yrs Ago p43i1   Over5  
SameCounty Lived in Same County 5 Yrs Ago p43i1 + p43i2   Over5  
SameState Lived in Same State 5 Yrs Ago sum(of p43i1-p43i3)   Over5  
DiffState Lived in Different State in the U.S. 5 Yrs Ago sum(of p43i4-p43i7)   Over5  
Elsewhere Lived Abroad 5 Years Ago sum(of p43i9-p43i10)   Over5  

Table=6. Place of Work Universe=Persons 16 Yrs and Over

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight
Variable
Worker16 Workers 16 and Over sum(of p45i1-p45i3)      
WorkInCounty Work in County of Residence P45i1   Worker16  
WorkOutCounty Work Outside County of Residence sum(Worker16-WorkInCounty)   Worker16  
WorkersInaPlace Worker Living in a Place P45i2   Worker16  
WorkInPlace Work in Place of Residence P46i1   Worker16  

Table=7. Commuting Universe=Persons 16 Yrs and Over

Variable Name Label Definition - Code used to
derive		 Comment Universe Variable Weight Variable
DriveAlone Drive Alone to Work P49i1   Worker16  
Carpool Carpool P49i2   Worker16  
PublicTrans Public Transportation or Taxi to Work sum(of p49i3-p49i8)   Worker16  
CycleWalk Cycle or Walk to Work sum(of P49i9-p49i11)   Worker16  
WorkAtHome Work at Home P49i13   Worker16  
Commuters All Persons that Commute to Work sum(of p50i1-p50i12) Excludes those who work at home Worker16  
AvgCommute Mean Travel Time to Work p51i1 / Commuters   Worker16 Commuters

Table=8. Educational Attainment Universe=Persons 25 and Over

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight
Variable
Over25 Persons Age 25 Yrs and Over sum(of p57i1-p57i7)   TotPop  
LessThan9th Less than 9th Grade p57i1   Over25  
SomeHighSchool 9th thru 12th grade no diploma p57i2   Over25  
HighSchool High School Graduate or GED P57i3   Over25  
NoCollege Did Not Attend College LessThan9th + SomeHighSchool + HighSchool   Over25  
SomeCollege Some college no degree p57i4 + p57i5   Over25  
Bachelors Bachelors p57i6   Over25  
GradProf Graduate or Professional Degree p57i7   Over25  
NoHSDiploma Less than a H.S. Diploma sum(of LessThan9th SomeHighSchool)   Over25  
HSPlus H.S. Grad or Some College sum(of HighSchool SomeCollege)   Over25  
CollGrad College or Professional Degree sum(of Bachelors GradProf)   Over25  

Table=9. Veteran and Armed Forces Status Universe=Persons 16 and over

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight
Variable
Over16 16 Yrs of Age and Over sum(of p64i1-p64i12) persons 16+ in 1990 instead of 18+ in 2000 TotPop  
ArmedForces Currently in Armed Forces sum(of p64i1 p64i4 p64i7 p64i10)   Over16  
Civilian Civilian Population Ages 16 and Over sum(of p64i2 p64i3 p64i5 p64i6 p64i8 p64i9 p64i11 p64i12) Age range is different in 2000 Over16  
Veteran Veteran sum(of p64i2 p64i5 p64i8 p64i11)   Over16  

Table=10. Disability Universe=Civilian Non-Inst. Persons 16 and Over

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight
Variable
DisabledUniv65 Civ Noninstitutionalized Pop. 65 Yrs and Over sum(of p66i8-p66i14 p66i22-p66i28)   Over16  
Disabled65 Persons 65 and Over with disability sum(of p66i15-p66i18 p66i22-p66i25)   DisabledUniv65  
DisabledUniv16 Civ Noninstitutionalized Pop.Age 16-64 sum(of p66i1-p66i7 p66i15-p66i21)   DisabledUniv65  
WorkDisability Persons 16-64 with a Work Disability sum(of p66i1-p66i4 p66i15-p66i18)   DisabledUniv16  
EmplDisabled Employed Persons 16-64 with a Work Disabilty sum(of p66i1 p66i8)   DisabledUniv16  

Table=11. Employment Status Universe=Persons 16 Years and Over

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight
Variable
Over16 16 Years of Age and Over sum(of p70i1-p70i8)   TotPop  
CivLabForce Civilian Labor Force sum(of p70i2-p70i3 p70i6-p70i7)   Over16  
Unemployed Unemployed Persons in Civilian Labor Force p70i3 + p70i7   CivLabForce  
CivLabForceFem Civ Labor Force, Female p70i6 + p70i7   CivLabForce  
UnemployedFem Unemployed Females in Civ Labor Force p70i7   CivLabForceFem  
NotInLF Not in Labor Force p70i4 + p70i8   Over16  

Table=12. Work Force by Industry Universe=Employed Civilian Labor Force

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight
Variable
EmployedCLF Employed Persons in Civilian Labor Force p70i2 + p70i6   CivLabForce  
Manufacturing Manufacturing p77i4 + p77i5   EmployedCLF  
RetailTrade Retail Trade p77i9   EmployedCLF  
Education Educational Services p77i15   EmployedCLF  
HealthSA Health Care and Social Assistance p77i14   EmployedCLF  
OtherIndustry Other Industries EmployedCLF - Manufacturing - RetailTrade - Education - HealthSA   EmployedCLF  

Table=13. Work Force by Occupation Universe=Employed Civilian Labor Force

Variable Name Label Definition - Code used to
derive		 Comment Universe Variable Weight
Variable
ManProfOccs Management professional and related occupations p78i1 + p78i2   EmployedCLF  
TechOccs Technical, Sales and Administrative Occupations p78i3 + p78i4 + p78i5   EmployedCLF  
ServiceOccs Service Occupations p78i6 + p78i7 +p78i8   EmployedCLF  
FarmFishOccs Farming, Fishing and Forestry p78i9   EmployedCLF  
PrecOccs Precision Production, Craft and Repair Occupations p78i10   EmployedCLF  
OperOccs Operators, Fabricators and Laborers sum(of p78i11-p78i13)   EmployedCLF  

Table=14. Household Income Universe=Households

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight Variable
TotHHs Total Households p5i1      
HHldInc0 Households with Income less than $10,000 sum(of p80i1-p80i2)   TotHHs  
HHldInc10 $10,000 to $14,999 sum(of p80i3-p80i4)   TotHHs  
HHldInc15 $15,000 to $24,999 sum(of p80i5-p80i8)   TotHHs  
HHldInc25 $25,000 to $49,999 sum(of p80i9-p80i18)   TotHHs  
HHldInc50 $50,000 to $99,999 sum(of p80i19-p80i22)   TotHHs  
HHldInc100 $100,000 to $149,999 sum(of p80i23-p80i24)   TotHHs  
HHldInc150ov $150,000 or More p80i25   TotHHs  
MedianHHInc Median Household Income p80Ai1*1.304650 cpi factors for 1989 and 1999 used 187.1 and 244.1 resp   TotHHs
AvgHHInc Average Household Income (p81i1 + p81i2) / p5i1*1.304650 cpi factors for 1989 and 1999 used 187.1 and 244.1 resp   TotHHs

Table=15. Other Income Measures Universe=Families

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight Variable
Families Total Families p4i1      
FmIncUnd15 Less than $15,000 [Families With Incomes] p107i1 + p107i2 + p107i3 + p107i4   Families  
FmInc25 $15,000 and $25,000 [Families With Incomes] p107i5 + p107i6 + p107i7 + p107i8   Families  
FmInc50 $25,000 and $50,000 [Families With Incomes] sum(of p107i9-p107i18)   Families  
FmInc75 $50,000 and $75,000 [Families With Incomes] p107i19 + p107i20 + P107i21   Families  
FmIncOv75 $75,000 or More [Families With Incomes] p107i22 + p107i23 + p107i24 + p107i25   Families  
MedianFamInc Median Family Income p107Ai1*1.304650 cpi factors for 1989 and 1999 used (187.1 and 244.1, resp)   Families
AvgFamInc Average Family Income sum(of p108i1-p108i2) / p4i1*1.304650 cpi factors for 1989 and 1999 used (187.1 and 244.1, resp)   Families
PCI Per Capita Income p114Ai1*1.304650 cpi factors for 1989 and 1999 used (187.1 and 244.1, resp)   TotPop

Table=16. Poverty Universe=Persons for whom poverty status is determined

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight Variable
PovUniverse Persons for whom poverty status determined sum(of p121i1-p121i9)      
Poor Poor Persons sum(of p117i13-p117i24)   PovUniverse  
VeryPoor Persons below 50% of poverty level p121i1   PovUniverse  
Under185Poor Persons below 185% of Poverty Level PovUniverse - p121i8 - p121i9   PovUniverse  
NearlyPoor Persons Between 100 and 200% of poverty level PovUniverse - Poor - P121i9 Persons with poverty ratio between 1 and 2 PovUniverse  
PovUnivKidsU5 Persons Under 5 for Whom Poverty Status is determined sum(of p117i1 p117i13)      
PoorKidsU5 Below Poverty Status [Persons Under 5] p117i13   PovUnivKidsU5  
PovUnivKids Persons Under 18 for Whom Poverty Status is determined sum(of p117i1-p117i4 p117i13-p117i16)   PovUniverse  
PoorKids Below Poverty Status [Persons Under 18] p117i13+p117i14+p117i15+p117i16   PovUnivKids  
PovUnivAdults Adults 18 to 64 Poverty Universe sum(of p117i5-p117i10 p117i17-p117i22)      
PoorAdults Below Poverty Status [Persons 18 to 64] p117i17+p117i18+p117i19+p117i20+p117i21+p117i22   PovUnivAdults  
PovUniv65 Persons 65 and Older Poverty Universe sum(of p117i11-p117i12 p117i23-p117i24)      
PoorElderly Below Poverty Status [Persons 65 or Older] p117i23+p117i24   PovUniv65  
MeanPovRatio Mean Poverty Ratio (P121i1*.25 + P121i2*.625 + P121i3*.875+P121i4*1.125+P121i5*1.375+P121i6*1.625+P121i7*1.800+P121i8*1.925+P121i9*3.0)/PovUniverse Our own statistical invention which attempts to create a measure of the degree of poverty by estimating the average poverty ratio for persons   PovUniverse

Table=17. Group Quarters Universe=Persons in Group Quarters

Variable Name Label Definition - Code used to
derive		 Comment Universe Variable Weight
Variable
GQPop Group Quarters Population sum(of p40i1-p40i10)   TotPop  
InInstitutions Institutionalized Population sum(of p40i1-p40i5)   TotPop  
NonInstPop Noninstitutionalized Population sum(of p40i6-p40i10)   TotPop  

Table=18. Housing Unit Basics Universe=Housing Units

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight Variable
TotHUs Total Housing Units h1i1      
Occupied Occupied housing units h4i1   TotHUs  
OwnerOcc Owner Occupied Housing units h8i1   Occupied  
RenterOcc Renter Occupied housing units h8i2   Occupied  
Vacant Vacant housing units h4I2   TotHUs  
VacForRent Vacant Housing Units for Rent h6i1 + h6i5   TotHUs  
VacForSale Vacant Housing Units for Sale h6i2 + h6i6   TotHUs  
RenterTot Total Rental Units, incl Vacant for rent VacForRent + RenterOcc   TotHUs  
OwnerTot Total Owner Units, incl Vacant for sale VacForSale + OwnerOcc   TotHUs  
RentalVacRate Rental Unit Vacancy Rate VacForRent/RenterTot*100     RenterTot
OwnerVacRate Owner Unit Vacancy Rate VacForSale/OwnerTot*100     OwnerTot

Table=19. Select Household Characteristics Universe=Households

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight
Variable
NoCars No vehicles available sum(of h37i1 h37i7)   Occupied  
OneCar Units with 1 car available h37i2 + h37i8   Occupied  
TwoCars Units with 2 cars available h37i3 + h37i9   Occupied  
ThreeCars Units with 3 or more cars available sum(of h37i4-h37i6 h37i10-h37i12)   Occupied  

Table=20. Selected Housing Unit Characteristics Universe=Housing Units

Variable Name Label Definition - Code
used to derive		 Comment Universe Variable Weight
Variable
MobileHomes Mobile Homes h20i9   TotHUs  
BoatRVhomeless Boat, RV, Van, etc. h20i10 Includes essentially homeless people and is not compatible to 2000 TotHUs  
MovedIn5 Moved in last 5 Yrs h29i1 + h29i2   Occupied  

Table=21. Age of Structure Universe=Housing Unit Characteristics

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight Variable
AgeUnit5 Units < 5 Yrs Old h25i1 + h25i2 Units built between 1985 and March 1990 TotHUs  
AgeUnit50 Units > 50 Yrs Old h25i8 Housing Units Built Before 1940 TotHUs  
AvgAgeUnit Average Age of Units (H25i1*.625 + H25i2*3.75 + H25i3*8.25 + H25i4*15.75 + H25i5*25.75 + H25i6*35.75 + H25i7*45.75 + h25i8*72)/TotHUs Our own statistic. Estimates ages within intervals using midpoints and assigns arbitrary age of 70 yrs for homes built 1939 and earlier   TotHUs

Table=22. Gross Rents Universe=Specified Renter Occupied Units

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight Variable
SpecRenter Specified renter-occupied units sum(of h43i1-h43i17)   RenterOcc  
CashRenter Units paying with cash sum(of h43i1-h43i16)   SpecRenter  
RntUnder300 Less than $300 sum(of h43i1-h43i6)   SpecRenter  
Rnter300 Rent $300 to $599 sum(of h43i7-h43i11)   SpecRenter  
Rnter600 Rent $600 to $999 sum(of h43i12-h43i15)   SpecRenter  
RntOver1000 Rent $1000 or more sum(of h43i16)   SpecRenter  
MedianGrossRent Median Gross Rent h43ai1*1.304650 cpi factors for 1989 and 1999 used 187.1 and 244.1 resp   CashRenter
AvgGrossRent Average Gross Rent h44i1 / CashRenter*1.304650 cpi factors for 1989 and 1999 used 187.1 and 244.1 resp   CashRenter
NoCashRent No Cash Rent h43i17      

Table=23. Gross Rent as a Percentage of Household Income Universe=Specified Renter Occupied Housing Units

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight
Variable
RentCost_Und20 Less than 20 percent h50i1+h50i7+h50i13+h50i19+h50i25   Renterocc  
RentCost_25 20 to 25 percent h50i2+h50i8+h50i14+h50i20+h50i26   Renterocc  
RentCost_30 25 to 30 percent h50i3+h50i9+h50i15+h50i21+h50i27   Renterocc  
RentCost_30Ov 30 percent or more h50i4+h50i5+h50i10+h50i11+h50i16+h50i17+h50i22+h50i23+h50i28+h50i29   Renterocc  
RentCost_NC Not computed h50i6+h50i12+h50i18+h50i24+h50i30   Renterocc  

Table=24. Housing Values Universe=Specified Owner Occupied Housing Unit

Variable Name Label Definition - Code used to
derive		 Comment Universe Variable Weight Variable
SpecOwner Specified owner-occupied units sum(of h61i1-h61i20)   OwnerOcc  
HouvalUnd50 Housing Value: Less than $50,000 sum(of h61i1-h61i8)   SpecOwner  
Houval50 Housing Value: $50,000 - $99,999 sum(of h61i9-h61i11)   SpecOwner  
Houval100 Housing Value: $100,000 - $149,999 sum(of h61i12-h61i13)   SpecOwner  
Houval150 Housing Value: $150,000 - $199,999 sum(of h61i14-h61i15)   SpecOwner  
Houval200 Housing Value: $200,000 - $299,999 sum(of h61i16-h61i17)   SpecOwner  
Houval300 Housing Value: $300,000 - $499,999 sum(of h61i18-h61i19)   SpecOwner  
Houval500 Housing Value: $500,000 or more h61i20   SpecOwner  
MedianHValue Median House Value h61ai1*1.304650 Adjusted for inflation   SpecOwner

Table=25. Owner Costs as a Percentage of Household Income Universe=All Specified Owner Occupied Housing Units

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight
Variable
OwnCost_Und20 Less than 20 percent h58i1+h58i7   SpecOwner  
OwnCost_25 20 to 25 percent h58i2+h58i8   SpecOwner  
OwnCost_30 25 to 30 percent h58i3+h58i9   SpecOwner  
OwnCost_30Ov 30 percent or more h58i4+h58i5+h58i10+h58i11   SpecOwner  
OwnCost_35 30 to 35 percent h58i4+h58i10   SpecOwner  
OwnCost_35Ov 35 percent or more h58i5+p58i11   SpecOwner  
OwnCost_NC Not computed h58i6+h58i12   SpecOwner  

Note: If Universe Variable has a value then there is a corresponding Pct Variable
Example: PctWhite is defined and is 100*White/TotPop