A Picture of Subsidized Households Detailed Explanation of the Variables
The file is delimited ASCII, with double quotes around text fields (i.e., the fields "name" and "code"), and commas separating all fields, so they can be read directly by most programs. At the same time, the file is in fixed format, so it can be read by programs that need fixed formats. We have kept the record length under 240 characters (which is a limit in Lotus) since we expect some users will use Lotus.
Layout of Report and Computer File
Name in This Report | Computer File | General Notes: 99 = 99% or more; blank or -1 = low reporting or unknown | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Name | Start | Width | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Program | pgm | 1 | 2 | Summary level is in the first column:
Programs are in the second column. Key values differ between file and report:
* Note that programs 6–9, (S–L) are not included in housing agency summaries, since they are independently managed. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Address & City | name | 5 | 32 | Name of the project, agency, state, or size class. For summary level 5, part of an agency this item gives a cross-reference to another record where one can find the total of the agency. For example the level 5 record for MD 902 shows "IN MD901" since both are run by the Maryland state housing agency and the total data are given in the level 4 record for MD 901. The total and the part may be identical, when two codes have been assigned to the agency, but only one is in use. For summary level 6, projects: name is in the first 12 characters of this item, a brief address is in the second 12 characters and city is in the last 8. For summary level 7 in program 4 (C), Census tracts in Certificates+Vouchers this item shows: county and tract, in the format: "Cert+Vch:county123 1234.67tract" For summary level 7 in program 1 (A), Census tract summaries across all programs, this item shows: population, renter households, and percent in various programs, in the format: "12345pop 2345ren 12P 12C 12H 12L". The abbreviations are as ab ove, except H is a total of programs 6, 7 and 8 (S, T and F).
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Code | code | 40 | 11 | Project code or number: This always starts with a 2–letter state abbreviation (RQ for Puerto Rico, as used in most HUD project numbers). In summary levels 1–3, this code has a very brief label, like AL for Alabama. For other summary levels, the meaning varies by program: In program 1 (A: i.e., for tract summaries that include all programs present in the tract), this code shows: state, tilde (~), HUD units as % of housing units in the tract in 1990, and number of housing units in the tract in 1990, like "AL~12% 1234 " In programs 2–5 (B, P, C, K) this code shows: state abbreviation, then blank and agency#, then blank and project# if any, like: "AK 001 001" In program 2 or B, an M after the project# (in the 11th character) means Mutual Ownership. In program 6 or S this code shows: state, 2–digit HUD office, and project number, like "AK01R123456" In programs 7–8, (T, F) this code shows: state, underline, 3–digit HUD office and project number, like "AK_11144666" For this group, if state was unknown, we generated it from the HUD field office code. There may be some errors where offices cross state l ines. In program 9 or L this code shows: state, curly bracket ({), then state-defined project ID, if any, like "AK{87–123"
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Units Available | units | 53 | 7 | Number of units: Units under contract and available for occupancy. This count is not as recent as the tenant data: it is as of 9/30/95, except in Tax Credits it is 12/94. If an agency overall has more Certificates+Vouchers than it reports on, we assume each tract has extra Certificates+Vouchers in the same proportion (but we assume no more than twice as many in a tract as the number reported). The number of units was missing and had to be estimated for a few projects. In Tax Credits, when we show 35 units we had no data (and used 35 since it is the national average); projects which truly had 35 or 36 units are shown as 36. In Ofc. of Housing (programs 6–8 or S–F), 66 units mean we had no data (and used 66, the national average); 67 means actually 66 or 67. In Public & Indian Housing, zero units are shown for 95 projects. It is believed most are not active project numbers.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%Occupied | occ | 61 | 2 | Occupied units as % of available. This is valid in program 3 (P: Public Housing). Elsewhere no data are actually available, and numbers are assumed, purely for calculating reporting rates: In program 6 (S) occupancy rates are stipulated at 98%, and in programs 7–8 (T, F) at 96% (Wallace 1993, page 2–27, though his figures are based on rent revenue, and occupancy is less). In other programs we stipulate 99%, since almost all units are assumed occupied.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%Reported | rep | 64 | 2 | Reported units, as % of occupied | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%<1Yr | mover | 67 | 2 | % in program less than a year. If it is 100% or 0%, the project has reported only admissions, or no admissions, either of which is usually a data quality problem | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Fam.Size | size | 70 | 3 | Average size of household, with decimal point & decimal place (for example 2.5). To find the number of people served by the agency, multiply this size by units available and % occupied. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Av.Rent | rent | 74 | 3 | Average gross household rent per month. This includes rent the household pays to the agency or landlord, and an estimate of any separately metered utilities they pay (and also ownership costs in Indian ownership programs). Based on households with rent in the range $1–$2,498; other rents are considered errors. This is item 14 on form HUD–50058 (highest of: 10% of gross income, 30% of adjusted income, or welfare rent), except in vouchers, where it is item 22k (total family contribution), and Indian Mutual, where it is item 17h (family cost).
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Av.Income | incom | 78 | 3 | Average total household income. This is shown in thousands of dollars per year, with decimal point. This is basically total income before adjustments, but it does exclude some types of income which HUD regulations do not count at all, such as earnings of minors, and scholarships. Averages below $1,000 are shown as .00–.99 thousand dollars. Averages below $10,000 are shown as 1.0–9.9 thousand dollars. Higher averages are shown as 10. to 99. thousand dollars. (All software that we are familiar with can handle this floating decimal p oint; normally declare the maximum width: 3 and maximum decimal positions: 2.) Based on households with income in the range $1–99000.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%<$5000 | i5 | 82 | 2 | % Below $5,000 (part of line below) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%<10000 | i10 | 85 | 2 | % Below $10,000 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%$20000+ | i20 | 88 | 2 | % $20,000 or more (you can get the category $10–19,999 by subtraction) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%Wages | wage | 91 | 2 | % Majority of household's income comes from wages and/or business | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%Welf | welf | 94 | 2 | % Majority of household's income comes from welfare (AFDC or General Assistance, not Supplemental Security Income). Note that remaining households have majority of income from another source, such as pensions, Social Security, SSI, unemployment benefits or child support, or have a mixture, with no type giving a majority of income
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Incm.Mix | mix | 97 | 2 | Income mix as percent of average income. The larger the number, the more income mix. This is the coefficient of variation, which is the standard deviation of income, as a percent of the average income. The standard deviation measures how far each household's income is from the average income. Incomes that are far above or be low average have large effects, since the differences are squared before being averaged.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%Age<25 | a24 | 100 | 2 | % Under age 25: age of head or spouse, whichever is older | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%Age25–44 | a44 | 103 | 2 | % Age 25–44 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%Age45–61 | a61 | 106 | 2 | % Age 45–61 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%Age62+ | a62 | 109 | 2 | % Age 62+ | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%Age85+ | a85 | 112 | 2 | % Age 85+ (part of line above) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%Disab<62 | d61 | 115 | 2 | % With disability, as % of households below age 62 (includes households where either head or spouse has handicap or disability) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%Disab62+ | d62 | 118 | 2 | % With disability, as % of households age 62 or more | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%Minority | min | 121 | 2 | % Minority | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%Black | blac | 124 | 2 | % Black, not Hispanic | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%Hispanic | hisp | 127 | 2 | % Hispanic (of any race) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%Nat.Amer | indn | 130 | 2 | % Native American | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%Asin-Pac | asia | 133 | 2 | % Asian or Pacific Islander | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Dif PR-HA | dif | 136 | 2 | Difference between project & agency in % Minority: measures extent to which subsidized minorities live in different places from subsidized whites. Scale is 0–50. The larger the number, the more separately whites & minorities live. For Public Housing projects, this is the difference between: % minority for the project, and overall % minority for Public Housing at the agency. Difference is shown for each project (in absolute value). Average of these differences i s shown for each agency. For Certificates+Vouchers (which do not have projects), difference is based on Census tracts with more than 10 households reported: average difference between: % minority among Certificates+Vouchers in the tract, and overall % minority among Certif icates+Vouchers at the agency. Summaries of this item exclude agencies that are under 5% or over 95% minority, and agencies with only one project or tract, since there cannot be much difference there.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%0Bedroom | bed0 | 139 | 2 | % 0 Bedrooms | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%1Bedroom | bed1 | 142 | 2 | % 1 Bedroom | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%2Bedroom | bed2 | 145 | 2 | % 2 Bedrooms | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%3+Bedrms | bed3 | 148 | 2 | % 3 Bedrooms or more | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%2Sp+Chil | sp2 | 151 | 2 | % Both spouses: married couple with 1 or more children under 18 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%1Sp+Chil | sp1 | 154 | 2 | % Spouse not present; but 1 or more children under 18 are present | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%Female | fem | 157 | 2 | % Female head. This is bigger than single parents, since many elderly women are female heads, but have no children present. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%Br>Peopl | bedx | 160 | 2 | % Overhoused, with more bedrooms than people | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%w/Assets | as | 163 | 2 | % With assets over $5,000. The denominator excludes households with assets over $200,000 (errors), but includes zeros, some of which may be errors. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Av.Assets | asav | 166 | 2 | Average assets, in thousands of dollars, among households with assets $5,000–$200,000 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
%w/Utilty | ut | 169 | 2 | % With valid utility allowance ($1–$1,000 are considered valid) This is an estimate of the utilities the household needs to pay to the utility company. It is zero if all utilities are included in rent. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Av.Utilty | utav | 172 | 3 | Average utility allowance, among households with it, in dollars per month | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Yrs.Stay | stay | 176 | 2 | Average years since moved in. Excludes programs 4–5 (C, K), since move-in dates before 1993 are not known | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Mos.Wait | wait | 179 | 2 | Average months on waiting list, among admissions. Excludes programs 6–9 (S, T, F, L), which do not report waiting list dates | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Latitude | lat | 182 | 6.3 | Average latitude. Data file includes decimal point and 3 decimal places | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Longitude | long | 189 | 8.3 | Average longitude. Data file includes decimal point and 3 decimal places. Negative means West longitude, which covers most of the United States. Zero is in Britain; negative numbers go to -180 in the Aleutians; positive numbers go to +180, also in the Aleutians. Distances in miles between points a and b can be calculated (where f=.0174532925 and converts from degrees to radians):
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Zip | zip | 198 | 5 | Zip code, assigned by the postal service, unique within United States. 88888 means more than one Zip code applies | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
County | cnty | 204 | 3 | County: 3–digit code, unique within state. 888 means more than one county applies | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Tract | tract | 208 | 7.2 | Census tract surrounding the project, code unique within county, including decimal point and 2 decimal places. 8888.00 means more than one tract applies | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
T%Poverty | tpov | 216 | 2 | Tract % Poor: Poor as % of population, in Census tract that surrounds project This, like other items, is averaged for all projects, weighted by number of units in each project | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
T%Minrty | tmin | 219 | 2 | Tract % Minority: Minorities as % of population, in Census tract that surrounds project. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
T%OwnSFD | tow1 | 222 | 2 | Tract Single Family Owners: Households that are owner-occupants of single family detached homes, as % of households in Census tract that surrounds project. This counts owner-occupants in buildings with 1 unit, not townhouses, condominiums, or mobile h omes | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
MSA | msa | 225 | 4 | Metropolitan Statistical Area (MSA or PMSA). Code is unique within the United States. 0 means not in any metropolitan area (blank or -1 means status unknown) 8888 means more than one metro area applies. MSA and PMSA (Primary Metropolitan Statistical Area) codes form one consistent series; the distinction is minor: PMSAs are pieces of even larger "Consolidated" areas (CMSAs), while MSAs are free-standing. These are statistical areas established by the Office of Management and Budget. HUD has subdivided some for setting Fair Market Rents and Income Limits, and HUD's areas are not reflected here. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Place | place | 230 | 4 | Code for the city, town, or Census-defined place (such as a well-known locality that is not legally incorporated). Unique within state. 8888 means that more than one code applies. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Cong.Dist | cd | 235 | 2 | Congressional District, for the Congress elected in 1994. 88 means more than one district applies. Unique within state. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
HA.Size | cl | 238 | 1 | Size class of housing agency.
|