Metadata for the stf903x2 Filetype (Partial listing of Variables dataset)

Table=1. Total Population Universe=Total Population

Variable Name Label Definition - Code used
to derive		 Comment Universe Variable Weight Variable
TotPop Total Persons (Sample Est) p1i1      
SampCount Unweighted Sample Count of Persons p2i1      
TotPop100 Total Persons (100% Count) p3i1      
PctSample Pct Persons Sampled p3ai1     TotPop100
Urban Urban Population p6i1 + p6i2   TotPop  
InUAs In Urbanized Areas p6i1   TotPop  
InUCs In Urban Clusters Urban - INUAs   TotPop  
OnFarms Persons on Farms p6i3   TotPop  
Rural Rural Population p6i3 + p6i4   TotPop  
LandSQMI Land Area Sq Miles AREALAND*.3860342 Arealand was in sq kilometers    
PopPerSQM Persons Per Sq Mile TotPop/LandSQMI Note that we use land area as denominator thus excluding major bodies of water   LandSQMI

Table=2. Age Universe=Total Population

Variable Name Label Definition - Code used to
derive		 Comment Universe Variable Weight
Variable
Age0_4 Under 5 sum(of p13i1-p13i3)   TotPop  
Age5_9 Age 5 to 9 sum(of p13i4-p13i6)   TotPop  
Age10_14 10 to 14 sum(of p13i7-p13i9)   TotPop  
Age15_17 15 to 17 sum(of p13i10-p13i12)   TotPop  
Age18_19 18 to 19 sum(of p13i13-p13i14)   TotPop  
Age20_24 20 to 24 sum(of p13i15-p13i17)   TotPop  
Age25_34 25 to 34 sum(of p13i18-p13i19)   TotPop  
Age35_44 35 to 44 sum(of p13i20-p13i21)   TotPop  
Age45_54 45 to 54 sum(of p13i22-p13i23)   TotPop  
Age55_59 55 to 59 p13i24   TotPop  
Age60_64 60 to 64 sum(of p13i25-p13i26)   TotPop  
Age65_74 65 to 74 sum(of p13i27-p13i28)   TotPop  
Age75_84 75 to 84 sum(of p13i29-p13i30)   TotPop  
Over85 Over 85 p13i31   TotPop  
Under18 Under 18 sum(of p13i1-p13i12)   TotPop  
Over18 Over 18 sum(of p13i13-p13i31)   TotPop  
Age18_64 18 to 64 sum(of p13i13-p13i26)   TotPop  
Over21 Over 21 sum(of p13i16-p13i31)   TotPop  
Over62 Over 62 sum(of p13i26-p13i31)   TotPop  
Over65 Over 65 sum(of p13i27-p13i31)   TotPop  

Table=3. Race/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  

Table=4. 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 in family household p17i2   HHpop  
Child Child in family houshold sum(of p17i3-p17i4)   HHpop  
Other_relative Other Relative sum(of p17i5-p17i6)   HHpop  
NonRelative Nonrelatives p17i7   HHpop  

Table=5. Households by Type Universe=Households

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight
Variable
TotHHs Total Households p5i1      
Families Families p4i1   TotHHs  
MarriedCouples Married Couples sum(of p19i1-p19i2)   TotHHs  
CouplesWithKids Married Couples w Own Children < 18 p19i1   TotHHs  
SinglePaRenters Single PaRenter Families P19i3 + P19i5   TotHHs  
SingleMothers Single Mothers P19i5   TotHHs  
OtherFamilies Other Families Families - (MarriedCouples + SinglePaRenters)   TotHHs  
NonFamHHs Non-Family HHs P19i7   TotHHs  
LivingAlone Persons Living Alone P16i1   TotHHs  

Table=6. Marital Status Universe=Persons Over 15

Variable Name Label Definition - Code used to
derive		 Comment Universe Variable Weight
Variable
Over15 Persons Over 15 Yrs of Age sum(of p27i1-p27i12)   TotPop  
NeverMarried Never Married p27i1 + p27i7   Over15  
Married Now Married Not Separated p27i2 + p27i8   Over15  
Separated Separated p27i3 + p27i9   Over15  
Widowed Widowed p27i5 + p27i11   Over15  
Divorced Divorced p27i6 + p27i12   Over15  

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

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight
Variable
Over5 Over 5 Yrs of Age 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  
NoEnglish Do Not Speak English sum(of p28i4 p28i14 p28i24 p28i7 p28i17 p28i27 p28i10 p28i20 p28i30)   Over5  

Table=8. Foreign Born Persons Universe=Foreign Born Persons

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight
Variable
ForeignBorn Foreign Born, exc native sum(of p37i2-p37i3 p37i5-p37i6)   TotPop  
Naturalized Naturalized US Citizen p37i2+p37i5   TotPop  
NonCitizen Not a Citizen p37i3 + p37i6   TotPop  
EnteredLast10Yrs Foreign Born Entered US in last 10 yrs. sum(of p36i1-p36i4)   TotPop  

Table=9. Residence in 1985 Universe=Persons Over 5

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  

Table=10. Place of Work Universe=Persons over 16

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  
WorkersInaPlace Worker Living in a Place p46i2   Worker16  
WorkInPlace Work in Place of Residence P46i1   WorkersInaPlace  

Table=11. Commuting Universe=Workers Over 16

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 Cycled or Walked to Work sum(of P49i9-p49i11)   Worker16  
WorkAtHome Work at Home P49i13   Worker16  
Commuters Commuters sum(of p50i1-p50i12) Excludes those who work at home    
AvgCommute Mean Travel Time to Work p51i1 / Commuters     Commuters

Table=12. School Enrollment, Persons Age 3+ Universe=Persons Age 3 and Over

Variable Name Label Definition - Code used to
derive		 Comment Universe Variable Weight
Variable
Over3 Over 3 Yrs of Age sum(of p54i1-p54i7)   TotPop  
EnrolledK12 Enrolled in grades K-12 sum(of p54i3 p54i4)   Over3  
InPvtSchools Enrolled in Private Schools K-12 p54i4   EnrolledK12  
InCollege Enrolled in college p54i5 + p54i6   Over3  

Table=13. 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  

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

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

Table=15. Disability Universe=Civilian Non-Institutionalized Persons

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight
Variable
DisabledUniv Civilian Non-Institutionalized Persons sum(of p66i1-p66i28) Universe not compatible between census years. 1990 equals persons age 16 and over instead of 5 and over as in 2000 Over16  
DisabledUniv65 Civilian 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 Civilian NonInstitutionalized Pop.Age 16-64 sum(of p66i1-p66i14)   DisabledUniv65  
WorkDisability Persons 16-64 w employment disability sum(of p66i1-p66i4 p66i8-p66i11)   DisabledUniv16  

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

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

Table=17. Industry Universe=Persons 16 and Over

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight
Variable
EmployedCLF Employed Civilian Labor Force p70i2 + p70i6   CivLabForce  
Manufacturing Employed in a manufacturing industry p77i4   EmployedCLF  
RetailTrade Employed in Retail Trade p77i9   EmployedCLF  
Education Employed in Educational Services p77i15   EmployedCLF  
HealthSA Employed in Health care and social assistance p77i14   EmployedCLF  
OtherIndustry Employed in Other Industries EmployedCLF - Manufacturing - RetailTrade - Education - HealthSA   EmployedCLF  
Unemployed Unemployed CivLabForce - EmployedCLF   CivLabForce  

Table=18. 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  
ServiceOccs Service Occupations p78i6 + p78i7 +p78i8   EmployedCLF  
SalesOffOccs Sales and Office Occupations p78i4 + p78i5   EmployedCLF  
FarmFishOccs Farming, Fishing and Forestry p78i9   EmployedCLF  
TransOccs Production Transportation and Material Moving p78i12   EmployedCLF  

Table=19. Household Income Universe=Households

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight Variable
TotHHs Total Households p5i1      
HHInc0 Less than $10,000 sum(of p80i1-p80i2)   TotHHs  
HHInc10 $10,000 to $14,999 sum(of p80i3-p80i4)   TotHHs  
HHInc15 $15,000 to $24,999 sum(of p80i5-p80i8)   TotHHs  
HHInc25 $25,000 to $34,999 sum(of p80i9-p80i12)   TotHHs  
HHInc35 $35,000 to $49,999 sum(of p80i13-p80i18)   TotHHs  
HHInc50 $50,000 to $74,999 sum(of p80i19-p80i21)   TotHHs  
HHInc75 $75,000 to $99,999 p80i22   TotHHs  
HHInc100 $100,000 to $149,999 sum(of p80i23-p80i24)   TotHHs  
HHInc150 $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 adjusted using cpi factors for 1989 and 1999 used 187.1 and 244.1 resp   TotHHs

Table=20. Income Percentages by Source Universe=Households

Variable Name Label Definition - Code used to derive Comment Universe
Variable		 Weight Variable
TotalIncome Total Aggregate Household Income p81i1+p81i2*1.304650 adjusted using cpi factors for 1989 and 1999 used 187.1 and 244.1 resp fmt=dollar13.    
PctWages Portion of Income from Wages and Salaries p98i1 / TotalIncome * 100     TotalIncome
PctSocSec Portion of Income from Social Security p102i1 / TotalIncome * 100     TotalIncome
PctPubAssist Portion of Income from Public Assistance p103i1 / TotalIncome * 100     TotalIncome
PctRetirement Portion of Income From Retirement Income p104i1 / TotalIncome * 100     TotalIncome

Table=21. Other Income Measures Universe=Families or Persons

Variable Name Label Definition - Code used to derive Comment Universe
Variable		 Weight Variable
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=22. 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)   TotPop  
Poor Poor Persons sum(of p117i13-p117i24)   PovUniverse  
VeryPoor Persons below 50% of poverty level p121i1   PovUniverse  
Under185Poor Under185Poor PovUniverse - p121i8 - p121i9   PovUniverse  
NearlyPoor Not poor but not well off PovUniverse - Poor - P121i9 Persons with poverty ratio between 1 and 2 PovUniverse  
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=23. Miscellaneous Population Universe=Total Population

Variable Name Label Definition - Code used to
derive		 Comment Universe Variable Weight
Variable
Female Female Population p7i2   TotPop  
GQPop In Group Qtrs Pop sum(of p40i1-p40i10)   TotPop  
InInstitutions Institutionalized Population sum(of p40i1-p40i5)   TotPop  

Table=24. Housing Units Universe=Housing Units

Variable Name Label Definition - Code used
to derive		 Comment Universe Variable Weight
Variable
TotHUs Total Housing Units h1i1      
SampHUs Unweighted Sample HU Count h2i1      
TotHUs100 Total Housing Units 100% Count h3i1      
UrbanHUs HUs in urban areas sum(of h5i1-h5i2)   TotHUs  
RuralHUs HUs in rural areas sum(of h5i3-h5i4)   TotHUs  
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  

Table=25. Select Housing Characteristics Universe=Occupied housing units

Variable Name Label Definition - Code used
to derive		 Comment Universe Variable Weight
Variable
Plumbing Lacking complete plumbing facilities h71i5-h71i8   Occupied  
NoPhone Lacking telephone service h35i2 + h35i4   Occupied  
NoCars No vehicles available h37i1 + h37i7   Occupied  
AvgHHSize Average Persons per household TotPop / TotHHs      
MovedIn5 Moved in within last 5 years h29i1 + h29i2   Occupied  

Table=26. Units in Structure Universe=Housing Units

Variable Name Label Definition - Code used to
derive		 Comment Universe Variable Weight
Variable
Units1 Single Family Housing Units sum(of h20i1-h20i2)   TotHUs  
Units2 2 to 4-unit Housing Units sum(of h20i3-h20i4)   TotHUs  
Units5 5 to 19-unit Housing Units sum(of h20i5-h20i6)   TotHUs  
Units20up Housing Units with 20+ Units sum(of h20i7-h20i8)   TotHUs  
MobileHomes Mobile Homes h20i9   TotHUs  
BoatRV Boat RV van etc. h20i10   TotHUs  

Table=27. Age of Structure Universe=Housing Units

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 This is same as BuiltBefore1940 TotHUs  
BuiltBefore1940 Built before 1940 h25i8   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=28. Gross Renters Universe=Specified Renter Occupied

Variable Name Label Definition - Code used to derive Comment Universe Variable Weight Variable
SpecRenter Specified Renter-occupied units sum(of h43i1-h43i17)   RenterOcc  
CashRenter With cash Renter sum(of h43i1-h43i16)   SpecRenter  
MedianGrossRent Median Gross Renter h43ai1*1.304650 cpi factors for 1989 and 1999 used 187.1 and 244.1 resp    
AvgGrossRenter Average Gross Renter h44i1 / CashRenter*1.304650 cpi factors for 1989 and 1999 used 187.1 and 244.1 resp   CashRenter
NoCashRenter No cash Renter h43i17   SpecRenter  

Table=29. 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  
MedianHValue Median Value of Occupied Housing Unit h61ai1*1.304650     SpecOwner
AvgHValue Average House Value 1.304650*(h62i1+h62i2)/SpecOwner     SpecOwner

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