LIHTC Database Access: Select Variables

Select the variables you want to extract from the database.
You do not need to select here the variables you will use to refine your selection of projects.

Project Identification
HUD ID Number
Project Name and Address
State ID
Project Contact Information
Geocoding Information
Latitude and Longitude
Metropolitan Area Code
1990 Complete Census Tract Code
1990 State FIPS Code
1990 County FIPS Code
1990 Census Tract Number
1990 Census Place Code
2000 Complete Census Tract Code
2000 State FIPS Code
2000 County FIPS Code
2000 Census Tract Number
2000 Census Place Code
Project Characteristics
Total Units
Low-Income Units
Unit Bedroom Distribution
Year Project Placed in Service
Year Credits Allocated
New Const./Rehab. Code
Financial Characteristics Codes
For-profit/non-profit Sponsor
DDA/QCT Increased Basis
Tax-Exempt Bond
FmHA/RHS 515 Loan
70%/30% Credit
NEW VARIABLES
(Primarily available for projects placed in service since 2003)
Project no longer monitored for compliance
HUD Subsidies in addition to LIHTC
Target Population Services or Facilities
(Primarily available for projects placed in service since 2006)
Annual LIHTC Allocation Amount
Elected Set-Aside (50 Percent of AMGI)
Are Units Set-Aside of Units with Rents Below the Elected Set-Aside
Number of Units Set-Aside with rents lower than elected rent/income celing
Dollar Amount of HUD Subsidies
Federal or state project-based rental assistance contract
Handle Missing Data
Replace Missing Total Units with Low-Income Units
Replace Missing Low-Income Units with Total Units