Data Dictionary: AHI Property List
Data Dictionary: Lost Properties Inventory
The Assisted Housing Inventory (AHI) is a database of subsidized developments that provide affordable rental housing in Florida. The AHI includes traditional public housing and properties subsidized by Florida Housing Finance Corporation, U.S. Department of Housing and Urban Development (HUD) multifamily programs, U.S. Department of Agriculture Rural Development (RD), and local housing finance authorities (LHFA). In exchange for subsidies, property owners provide affordable ("assisted") units with limits on tenant incomes and rents.
The AHI application provides four tables for the state, counties, and cities in Florida:
| Column Name | Definition | Notes | Data Source(s) |
|---|---|---|---|
| Shim ID | Unique property ID assigned by Shimberg Center | Shimberg Center | |
| FHFC Key | Unique ID assigned by Florida Housing Finance Corporation to its funded properties | Florida Housing Data Feed | |
| HUD REMS | Unique ID assigned by HUD Office of Multifamily Housing Programs to its portfolio of insured and assisted properties | HUD State Office Annual Data Feed | |
| Public Housing Development # | Unique ID assigned by HUD Office of Public and Indian Housing to public housing developments | HUD Public and Indian Housing Data Feed | |
| Florida DOR Parcel | Unique ID assigned to each land parcel by county property appraisers and submitted to Florida Department of Revenue | Florida Department of Revenue Name-Address-Legal File | |
| Development Name | Development name as reported by funding sources (former or alternative names provided in brackets) | Florida Housing Data Feed, HUD State Office Annual Data Feed, USDA RD State Office Annual Data Feed, LHFA Survey | |
| Street Address | Street address where development is located | Florida Housing Data Feed, HUD State Office Annual Data Feed, USDA RD State Office Annual Data Feed, LHFA Survey | |
| City | City where development is located | Florida Housing Data Feed, HUD State Office Annual Data Feed, USDA RD State Office Annual Data Feed, LHFA Survey | |
| Zip Code | Zip code where development is located | Florida Housing Data Feed, HUD State Office Annual Data Feed, USDA RD State Office Annual Data Feed, LHFA Survey | |
| County | County where development is located | Florida Housing Data Feed, HUD State Office Annual Data Feed, USDA RD State Office Annual Data Feed, LHFA Survey | |
| Housing Programs | Includes programs administered by the U.S. Dept. of Housing and Urban Development (HUD), U.S. Department of Agricultural and Rural Development (RD), Florida Housing Finance Corporation (Florida Housing), and Local Housing Finance Authorities (LHFA) | Inventory only reports programs that include income and/or rent restrictions. Programs without income/rent restrictions are also reported if they are combined with programs that include restrictions. | Florida Housing Data Feed, HUD State Office Annual Data Feed, USDA RD State Office Annual Data Feed, LHFA Survey |
| Total Units | Total number of units in development - includes property management units | Florida Housing Data Feed, HUD State Office Annual Data Feed, USDA RD State Office Annual Data Feed, LHFA Survey | |
| Assisted Units | Number of units with rent and/or income restrictions | Florida Housing Data Feed, HUD State Office Annual Data Feed, USDA RD State Office Annual Data Feed, LHFA Survey | |
| HUD/RD Rental Assistance Units | Number of units receiving monthly rental assistance from USDA RD or HUD. | HUD Multifamily Assistance and Section 8 Contracts Database; USDA RD State Office Annual Data Feed | |
| FHFC Funded | Property received funding from Florida Housing Finance Corporation | See below for specific programs administered by Florida Housing. | Florida Housing Data Feed |
| HUD Multifamily Funded | Property participates in program(s) funded by the US Dept. of Housing and Urban Development | See below for specific HUD programs. | HUD State Office Annual Data Feed |
| HUD Public Housing Funded | Property is part of the federal public housing program | HUD Picture of Subsidized Households | |
| RD Funded | Property was funded under a program by the US Dept. of Agriculture and Rural Development (RD) | See below for specific RD programs | USDA RD State Office Annual Data Feed |
| LHFA Funded | Property was funded by a Local Housing Finance Authority | Funding comes through locally administered bonds; see below. | LHFA Survey |
| Target Population | Population served by development (e.g. Family, Elderly, Persons with Disabilities) | "Link" designation refers to units funded by Florida Housing and set aside for extremely low income households with special needs (homeless, domestic violence survivors, persons with a disability, youth aging out of foster care). | Florida Housing Data Feed, HUD State Office Annual Data Feed, USDA RD State Office Annual Data Feed, LHFA Survey |
| Occupancy Status | Whether the property is ready for occupancy | Not Ready for Occupancy' means that construction is yet to commence or is underway. 'Ready for Occupancy' means that construction has been completed, a certificate of occupancy has been issued, or the property is being leased or is now fully occupied. | Florida Housing Data Feed, HUD State Office Annual Data Feed, USDA RD State Office Annual Data Feed, LHFA Survey |
| Affordability Start Date | Depending on housing program, earliest year of program funding, year loan started, or year property was first occupied | RD: year of loan closing; HUD: year of final mortgage endorsement, Section 8 contract, or occupancy; Florida Housing: funding year of earliest program, including currently inactive programs; public housing: occupancy date. LHFA information unavailable. | Florida Housing Data Feed, HUD State Office Annual Data Feed, USDA RD State Office Annual Data Feed |
| Year built (property appraiser) | Year that development was originally constructed | Florida Department of Revenue Name-Address-Legal File | |
| Owner Type | Owner corporation type (non-profit, for-profit, limited dividend) | Florida Housing Data Feed, HUD State Office Annual Data Feed, USDA RD State Office Annual Data Feed | |
| Overall year of subsidy expiration | Year of expiration of subsidy or period of affordability of funding layer with the latest expiration date. | Florida Housing Data Feed, HUD Multifamily Assistance and Section 8 Contracts Database, HUD Insured Multifamily Mortgages Database, USDA RD State Office Annual Data Feed | |
| Latitude/Longitude | Latitude & longitudinal coordinates of development | Shimberg Center | |
| Census Tract | 2010 U.S. Census tract in which development is located | U.S. Census Bureau | |
| Census Block Group | 2010 U.S. Census block group in which development is located | U.S. Census Bureau | |
| Number of 0 BR | Number of studio or efficency units | Florida Housing Data Feed, HUD Multifamily Assistance and Section 8 Contracts Database, USDA RD State Office Annual Data Feed, LHFA Survey | |
| Number of 1 BR | Number of units with 1 bedroom | Florida Housing Data Feed, HUD Multifamily Assistance and Section 8 Contracts Database, USDA RD State Office Annual Data Feed, LHFA Survey | |
| Number of 2 BR | Number of units with 2 bedroom | Florida Housing Data Feed, HUD Multifamily Assistance and Section 8 Contracts Database, USDA RD State Office Annual Data Feed, LHFA Survey | |
| Number of 3 BR | Number of units with 3 bedroom | Florida Housing Data Feed, HUD Multifamily Assistance and Section 8 Contracts Database, USDA RD State Office Annual Data Feed, LHFA Survey | |
| Number of 4 or more BR | Number of units with 4 or more bedroom | Florida Housing Data Feed, HUD Multifamily Assistance and Section 8 Contracts Database, USDA RD State Office Annual Data Feed, LHFA Survey | |
| Developer Name and Contact Information | Name, address and phone number of developer | Florida Housing properties only | Florida Housing Data Feed |
| Owner Name and Contact information | Name, address and phone number of owner | HUD developments only. | HUD State Office Annual Data Feed |
| Units <=35% AMI | Number of units restricting tenant income to greater than or equal to 35% Area Median Income | Florida Housing properties only | Florida Housing Data Feed |
| Units 40-50% AMI | Number of units restricting tenant income to 40-50% Area Median Income | Florida Housing properties only | Florida Housing Data Feed |
| Units 55-60% AMI | Number of units restricting tenant income to 55-60% Area Median Income | Florida Housing properties only | Florida Housing Data Feed |
| Units 65-80% AMI | Number of units restricting tenant income to 65-80% Area Median Income | Florida Housing properties only | Florida Housing Data Feed |
| Units >80% AMI | Number of units with tenant income restrictions above 80% Area Median Income | Florida Housing properties only | Florida Housing Data Feed |
| 0 BR Av. Rent | Average rent for units with 0 bedrooms | Not available for LHFA-only properties. | Florida Housing Data Feed, HUD Multifamily Portfolio Datasets--Contracts with Rent Amt and Utility Allowance Amt, USDA RD State Office Annual Data Feed |
| 1 BR Av. Rent | Average rent for units with 1 bedrooms | Not available for LHFA-only properties. | Florida Housing Data Feed, HUD Multifamily Portfolio Datasets--Contracts with Rent Amt and Utility Allowance Amt, USDA RD State Office Annual Data Feed |
| 2 BR Av. Rent | Average rent for units with 2 bedrooms | Not available for LHFA-only properties. | Florida Housing Data Feed, HUD Multifamily Portfolio Datasets--Contracts with Rent Amt and Utility Allowance Amt, USDA RD State Office Annual Data Feed |
| 3 BR Av. Rent | Average rent for units with 3 bedrooms | Not available for LHFA-only properties. | Florida Housing Data Feed, HUD Multifamily Portfolio Datasets--Contracts with Rent Amt and Utility Allowance Amt, USDA RD State Office Annual Data Feed |
| 4+ BR Av. Rent | Average rent for units with 4 or more bedrooms | Not available for LHFA-only properties. | Florida Housing Data Feed, HUD Multifamily Portfolio Datasets--Contracts with Rent Amt and Utility Allowance Amt, USDA RD State Office Annual Data Feed |
| Average Rent/FMR ratio | Ratio of property rent to HUD Fair Market Rent (FMR) for the Metropolitan Statistical Area (MSA) | HUD: reported in HUD's Section 8 contracts database; Florida Housing/RD: calculated using current property rent and corresponding MSA FMR's. Florida Housing ratios exclude units where tenants use Section 8 Vouchers. | Florida Housing Data Feed, HUD Multifamily Assistance and Section 8 Contracts Database, USDA RD State Office Annual Data Feed |
| 0 BR Utility Allowance | Average utility allowance (UA) for units with 0 bedrooms | Not available for RD or LHFA properties. | Florida Housing Data Feed, HUD Multifamily Portfolio Datasets--Contracts with Rent Amt and Utility Allowance Amt |
| 1 BR Utility Allowance | Average utility allowance (UA) for units with 1 bedrooms | Not available for RD or LHFA properties. | Florida Housing Data Feed, HUD Multifamily Portfolio Datasets--Contracts with Rent Amt and Utility Allowance Amt |
| 2 BR Utility Allowance | Average utility allowance (UA) for units with 2 bedrooms | Not available for RD or LHFA properties. | Florida Housing Data Feed, HUD Multifamily Portfolio Datasets--Contracts with Rent Amt and Utility Allowance Amt |
| 3 BR Utility Allowance | Average utility allowance (UA) for units with 3 bedrooms | Not available for RD or LHFA properties. | Florida Housing Data Feed, HUD Multifamily Portfolio Datasets--Contracts with Rent Amt and Utility Allowance Amt |
| 4+ BR Utility Allowance | Average utility allowance (UA) for units with 4 or more bedrooms | Not available for RD or LHFA properties. | Florida Housing Data Feed, HUD Multifamily Portfolio Datasets--Contracts with Rent Amt and Utility Allowance Amt |
| Occupancy Rate | Average monthly percentage of assisted units that are occupied | Florida Housing developments only. | Florida Housing Tenant Reporting Data System |
| Last Property Sale Price | Price for which the property last sold | Florida Department of Revenue Name-Address-Legal File | |
| Last Property Sale Date | Date on which the property was last sold | Florida Department of Revenue Name-Address-Legal File | |
| Just Value | Market value of property as determined by county property appraiser | Florida Department of Revenue Name-Address-Legal File | |
| Has Housing Credits 4% | Property received 4% Low Income Housing Tax Credits (LIHTC) | Federal dollar-for-dollar tax credits that are provided to for-profit and non-profit organizations in exchange for the construction or rehabilitation of affordable housing units. Imposes income and rent restrictions. | Florida Housing Data Feed |
| Has Housing Credits 9% | Property received 9% Low Income Housing Tax Credits (LIHTC) | Federal dollar-for-dollar tax credits that are provided to for-profit and non-profit organizations in exchange for the construction or rehabilitation of affordable housing units. Imposes income and rent restrictions. | Florida Housing Data Feed |
| Has SAIL | Property funded by State Apartment Incentive Loan (SAIL) | Provides low interest loans funded through the State Housing Trust Fund. Income restrictions only. However, SAIL is usually coupled with the LIHTC program, which also imposes rent restrictions. | Florida Housing Data Feed |
| Has Guarantee | Property funded by Florida Affordable Guarantee Program | Credit enhancement program that works with government funding sources and other lending institutions to lower the cost of borrowing capital for the construction or rehabilitation of affordable housing. | Florida Housing Data Feed |
| Has State Bonds | Property received Multifamily Mortgage Revenue Bonds (MMRB) | Both taxable and tax-exempt bonds to provide below market rate loans to non-profit and for-profit developers who set aside a certain percentage of units to low-income families. Income restrictions only. However, State bonds are frequently paired with LIHTC, which does impose rent restrictions. | Florida Housing Data Feed |
| Has State HOME | Property funded by State HOME Investment Partnerships Program | The HOME program provides non-amortized, low-interest loans to developers for construction or rehabilitation of affordable rental housing. Imposes income and rent restrictions. | Florida Housing Data Feed |
| Has EHCL | Property received Elderly Housing Community Loan Program (EHCL) | EHCL provides loans to developers making improvements to elderly housing (e.g. sanitation repairs, safety related improvements). This program has no income or rent restrictions and is therefore only reported in the AHI if a development is also funded under programs that do impose restrictions. | Florida Housing Data Feed |
| Has Demonstration | Property is designated a Demonstration Project | Provides funding for various special needs groups including persons with disabilities, farm workers, extremely low-income, homeless, and elderly. | Florida Housing Data Feed |
| Has PLP | Property funded by Predevelopment Loan Program (PLP) | Provides below-market interest rate financing and technical assistance to develop affordable housing. Imposes income and rent restrictions. | Florida Housing Data Feed |
| Has RRLP | Property funded by Rental Recovery Loan Program | The RRLP leverages available state and local bonds and private capital in order to address the hurricane recovery needs of affordable rental units. | Florida Housing Data Feed |
| Has FHSH | Property funded by Farmworker Housing Supportive Housing (FHSH) Program | FHSH consists of two different programs that provide flexible funding towards construction or rehabilitation of housing in areas affected by the 2004 and 2005 storms; (1) Farmworker Housing Recovery Program (FHRP), serving migrant farmworkers; and (2) Special Housing Assistance and Development Program (SHADP), serving hard-to-serve populations (e.g. persons with disabilities and frail elders). | Florida Housing Data Feed |
| Has FDIC | Property is under the Federal Deposit Insurance Corporation (FDIC) | Property was part of the remaining balance of real estate assets of the Resolution Trust Corporation, monitored by Florida Housing. Imposes rent and income restrictions. | Florida Housing Data Feed |
| Has Rental Assistance/HUD | Property receives project-based rental subsidies from HUD | Multifamily units receive monthly operating subsidy under programs such as Section 8 Loan Management Set-Aside and Section 8 New Construction and Substantial Rehabilitation Programs. Income-qualified tenants generally pay 30% of their income on rent and utilities, with subsidy covering remaining rent. | HUD Multifamily Assistance and Section 8 Contracts Database |
| Has Section 202 Capital Advance | Property participates in HUD's Section 202 Capital Advance Program for the Elderly | 40 year interest free capital advance to private, non-profit sponsors developing units for very low-income elderly populations. Includes HUD Rental Assistance component. | HUD State Office Annual Data Feed |
| Has Section 202 Direct Loan | Property participates in HUD's Section 202 Direct Loan Program for the Elderly | Direct loans to private developers for the construction of housing for the elderly or people with disabilities. Includes Rental Assistance component. Replaced by Capital Advance Programs in 1990 (see above). | HUD State Office Annual Data Feed |
| Has Section 811 | Property received a capital advance from HUD's Section 811 Supportive Housing for Persons with Disabilites | 40 year interest free capital advance to non-profit organizations for construction, rehabilitation, or acquisition of rental housing for adults with disabilities at or below 50% of area median income. Includes HUD Rental Assistance component. | HUD State Office Annual Data Feed |
| Has Section 236 | Property received HUD's Section 236 mortgage | 40 year mortgages provided at 1% interest rate offered to private for-profit and non-profit developers in the 1960's and 1970's that set income limits at 80% of area median income. Many properties also receive HUD Rental Assistance. | HUD State Office Annual Data Feed |
| Has HUD Use Agreement | Property has terminated HUD insured mortgage but may still be required to set income restrictions | HUD State Office Annual Data Feed | |
| Has Section 542 | Property participates in HUD's Section 542 risk sharing program | Provides credit enhancement through mortgage insurance for multifamily housing developments through state and local housing finance agencies. No income or rent restrictions, only reported if used with another program with restrictions. | HUD State Office Annual Data Feed |
| Has Refi Section 221(d)(3) MR | Property received a refinanced Section 221 (d) (3) Market rate mortgage (see above) | Can be refinanced under Section 223 (a) (7). No income or rent restrictions, only reported if used with another program with restrictions. | HUD State Office Annual Data Feed |
| Has Refi Section 221(d)(4) | Property received a refinanced Section 221 (d) (4) mortgage (see above) | Can be refinanced under Section 223 (a) (7). No income or rent restrictions, only reported if used with another program with restrictions. | HUD State Office Annual Data Feed |
| Has Section 207 | Property received HUD's Section 207 mortgage loan(s) (no longer used for new construction) | Financed the construction or rehabilitation of a broad range of rental housing. Now used as primary insurance vehicle for the Section 223 (f) (see above) refinancing program. No income or rent restrictions, only reported if used with another program with restrictions. | HUD State Office Annual Data Feed |
| Has Section 221(d)(3) MR | Property received HUD's Section 221 (d) (3) Market Rate mortgage loan(s) | Provided to non-profit developers in order to facilitate the new construction or substantial rehabilitation of multifamily rental developments. No income or rent restrictions, only reported if used with another program with restrictions. | HUD State Office Annual Data Feed |
| Has Section 221(d)(4) | Property received a HUD mortgage financed under Section 221 (d) (4) | Insures loans to for-profit developers to facilitate the new construction or substantial rehabilitation of multifamily rental developments. No income or rent restrictions, only reported if used with another program. | HUD State Office Annual Data Feed |
| Has Section 223(f) Refi/Purchase | Property received refinancing of conventional or Federal Housing Adminstration loan through HUD's Section 223 (f) mortgage loan(s) | Facilitates purchase or refinancing of existing multifamily rental housing. No income or rent restrictions, only reported if used with another program with restrictions. | HUD State Office Annual Data Feed |
| Has Section 231 | Property received HUD's Section 231 mortgage loan(s) | Facilitates the construction and substantial rehabilitation of multifamily rental housing for elderly and/or persons with disabilities. No income or rent restrictions, only reported if used with another program with restrictions. | HUD State Office Annual Data Feed |
| Has Public Housing | Property is part of the federal public housing program | Public housing developments are owned by local public housing authorities and funded by HUD. Income-qualified tenants generally pay 30% of income for rent and utilities. | HUD Picture of Subsidized Households |
| Has Rental Assistance/RD | Property receives RD Section 521 Rental Assistance subsidy | Monthly rental assistance used in conjuction with Section 515 and Section 514/516 (see below). Tenants pay 30% of income for rent and utilities. | USDA RD State Office Annual Data Feed |
| Has Section 515 | Program received mortgage from RD's Section 515 direct loan program | 30 year/50 year amortization loans at 1% interest rate to non-profit and for-profit developers to build rural multifamily rental housing for very low and low to moderate-income households. Priority for families living in substandard housing. | USDA RD State Office Annual Data Feed |
| Has Section 514/516 | Property received loan(s)/grant(s) from RD's Section 514/516 | Grants/loans provided to individuals, family farm organizations, public agencies and for-profit and non-profit agencies to finance on and off-farm rental housing for income-eligible farm workers. Can be combined with RD Section 521 rental assistance. | USDA RD State Office Annual Data Feed |
| Has Local Bonds | Property received Multifamily Mortgage Revenue Bonds administered by an LHFA | Tax-exempt bonds that provide financing at lower-than-market rates for affordable multifamily housing developments. Income restrictions only. Often paired with 4% LIHTC, which imposes both income and rent restrictions. | LHFA Survey |
| HC 4% Funding Year | Year 4% tax credits were awarded | Florida Housing Data Feed | |
| HC 9% Funding Year | Year 9% tax credits were awarded | Florida Housing Data Feed | |
| SAIL Funding Year | Year SAIL funds were awarded | Florida Housing Data Feed | |
| State Bonds Funding Year | Year MMRB funds were awarded | Florida Housing Data Feed | |
| State HOME Funding Year | Year MMRB funds were awarded | Florida Housing Data Feed | |
| HUD Rental Assistance Current Contract Start Date | Start date of currently active Rental Assistance contract | This is not equivalent to the first year of HUD Rental Assistance, as most developments have renewed these contracts at least once. If the property has more than one active contract, the earliest start date is shown. | HUD Multifamily Assistance and Section 8 Contracts Database |
| Section 202 Capital Advance Funding Date | Year of final mortgage endorsement or original construction | HUD State Office Annual Data Feed | |
| Section 202 Direct Loan Funding Date | Year of final mortgage endorsement or original construction | HUD State Office Annual Data Feed | |
| Section 811 Funding Date | Year of final mortgage endorsement or original construction | HUD State Office Annual Data Feed | |
| Section 236 Funding Date | Year of final mortgage endorsement or original construction | HUD State Office Annual Data Feed | |
| Rental Assistance/RD Funding Date | Funding year of Rental Assistance contract | USDA RD State Office Annual Data Feed | |
| Section 515 Funding Date | Year of RD Section 515 loan closing | USDA RD State Office Annual Data Feed | |
| Section 514/516 Funding Date | Year of RD Section 514/516 loan closing | USDA RD State Office Annual Data Feed | |
| HC 4% Expiration Date | Expiration year of income and rent restrictions associated with 4% LIHTC | Florida Housing Data Feed | |
| HC 9% Expiration Date | Expiration year of income and rent restrictions associated with 9% LIHTC | Florida Housing Data Feed | |
| SAIL Expiration Date | Expiration year of income restrictions associated with SAIL program | Florida Housing Data Feed | |
| State Bonds Expiration Date | Expiration year of income restrictions associated with State Bond program | Florida Housing Data Feed | |
| State HOME Expiration Date | Expiration year of income restrictions associated with State HOME program | Florida Housing Data Feed | |
| HUD Rental Assistance Expiration Date | Expiration year of the HUD rental assistance contract | If the property has more than one active contract, the latest end date is shown. Some HUD developments are shown in the AHI with past expiration dates. Most contracts are renewed on a 1-5 year basis and reporting of renewals in HUD's databases can lag for 2-8 months. | HUD Multifamily Assistance and Section 8 Contracts Database |
| HUD Use Agreement Expiration | Expiration year of HUD Use Agreement | HUD State Office Annual Data Feed | |
| Section 236 Maturity Date | Maturity date of the Section 236 mortgage | "Terminated" means that 40 year loan was prepaid after 20 years. | HUD State Office Annual Data Feed |
| Local Bonds Maturity Date | Maturity date of LHFA administered Multifamily Mortgage Revenue Bond | LHFA Survey | |
| Florida Housing Preservation Set-Aside | Property was financed through set-aside of LIHTC for preservation of assisted housing | Florida Housing Data Feed | |
| In QCT | Property is in a Qualified Census Tract (QCT) | Properties in QCTs may qualify for a boost in eligible basis under the Low Income Housing Tax Credit (LIHTC) program. QCTs generally are tracts with a 25% poverty rate or where 50% of population has income below 60% of area median income. | Shimberg Center geocoding, HUD Qualified Census Tracts Dataset |
| In DDA | Property is in a Difficult Development Area | Properties in DDAs may qualify for a boost in eligible basis under the Low Income Housing Tax Credit (LIHTC) program. DDAs are metropolitan areas and non-metropolitan counties with high construction, land, and utility costs, as measured by the ratio between HUD Fair Market Rents and median incomes. | Shimberg Center geocoding, HUD Difficult Development Areas Dataset |
| Average Household Size (persons) | Percentage of all reporting households that correspond to each household size | Codes for missing values: -1: missing data; -4: Suppressed (fewer than 11 households reporting); -5 Non-reporting (where reporting rates are less than 50%). | Florida Housing Tenant Data Reporting System; USDA RD State Office Annual Data Feed; 2015 HUD Picture of Subsidized Households |
| % of Households with Elderly Member | Florida Housing or RD: percentage of all reporting households that include at least one person age 62 or older; HUD: percentage of all reporting households where the head of household or spouse is age 62 or older | Codes for missing values: -1: missing data; -4: Suppressed (fewer than 11 households reporting); -5 Non-reporting (where reporting rates are less than 50%). | Florida Housing Tenant Data Reporting System; USDA RD State Office Annual Data Feed; 2015 HUD Picture of Subsidized Households |
| % of Households w/Children | Florida Housing: percentage of households with at least one member age 0-17; HUD: sum of percentage of 2 parent households with children and 1 parent households with children | Codes for missing values: -1: missing data; -4: Suppressed (fewer than 11 households reporting); -5 Non-reporting (where reporting rates are less than 50%). | Florida Housing Tenant Data Reporting System; USDA RD State Office Annual Data Feed; 2015 HUD Picture of Subsidized Households |
| % White (non-Hispanic) | Percentage of households reporting race as White | Available for HUD and RD developments only. Codes for missing values: -1: missing data; -4: Suppressed (fewer than 11 households reporting); -5 Non-reporting (where reporting rates are less than 50%). | Florida Housing Tenant Data Reporting System; USDA RD State Office Annual Data Feed; 2015 HUD Picture of Subsidized Households |
| % Asian (non-Hispanic) | Percentage of households reporting race as Asian | Available for HUD and RD developments only. Codes for missing values: -1: missing data; -4: Suppressed (fewer than 11 households reporting); -5 Non-reporting (where reporting rates are less than 50%). | Florida Housing Tenant Data Reporting System; USDA RD State Office Annual Data Feed; 2015 HUD Picture of Subsidized Households |
| % Black (non-Hispanic) | Percentage of households reporting race as Black | Available for HUD and RD developments only. Codes for missing values: -1: missing data; -4: Suppressed (fewer than 11 households reporting); -5 Non-reporting (where reporting rates are less than 50%). | Florida Housing Tenant Data Reporting System; USDA RD State Office Annual Data Feed; 2015 HUD Picture of Subsidized Households |
| % Hispanic | Percentage of households of any race reporting Hispanic/Latino ethnicity | Available for HUD and RD developments only. Codes for missing values: -1: missing data; -4: Suppressed (fewer than 11 households reporting); -5 Non-reporting (where reporting rates are less than 50%). | Florida Housing Tenant Data Reporting System; USDA RD State Office Annual Data Feed; 2015 HUD Picture of Subsidized Households |
| Average Annual Household Income ($) | Average annual household income in dollars for all reporting households | Based on actual tenant household incomes, not income eligibility limits for properties. Codes for missing values: -1: missing data; -4: Suppressed (fewer than 11 households reporting); -5 Non-reporting (where reporting rates are less than 50%). | Florida Housing Tenant Data Reporting System; USDA RD State Office Annual Data Feed; 2015 HUD Picture of Subsidized Households |
| % $0-4,999 | Percentage of households with annual income between $0 and $4,999 | Codes for missing values: -1: missing data; -4: Suppressed (fewer than 11 households reporting); -5 Non-reporting (where reporting rates are less than 50%). | Florida Housing Tenant Data Reporting System; USDA RD State Office Annual Data Feed; 2015 HUD Picture of Subsidized Households |
| % $5,000-9,999 | Percentage of households with annual income between $5,000 and $9,999 | Codes for missing values: -1: missing data; -4: Suppressed (fewer than 11 households reporting); -5 Non-reporting (where reporting rates are less than 50%). | Florida Housing Tenant Data Reporting System; USDA RD State Office Annual Data Feed; 2015 HUD Picture of Subsidized Households |
| % $10,000-14,999 | Percentage of households with annual income between $10,000 and $14,000 | Codes for missing values: -1: missing data; -4: Suppressed (fewer than 11 households reporting); -5 Non-reporting (where reporting rates are less than 50%). | Florida Housing Tenant Data Reporting System; USDA RD State Office Annual Data Feed; 2015 HUD Picture of Subsidized Households |
| % $15,000-19,999 | Percentage of households with annual income between $15,000 and $19,000 | Codes for missing values: -1: missing data; -4: Suppressed (fewer than 11 households reporting); -5 Non-reporting (where reporting rates are less than 50%). | Florida Housing Tenant Data Reporting System; USDA RD State Office Annual Data Feed; 2015 HUD Picture of Subsidized Households |
| % $20,000 and above | Percentage of households with annual income $20,000 and above | Codes for missing values: -1: missing data; -4: Suppressed (fewer than 11 households reporting); -5 Non-reporting (where reporting rates are less than 50%). | Florida Housing Tenant Data Reporting System; USDA RD State Office Annual Data Feed; 2015 HUD Picture of Subsidized Households |
| Average Annual Household Income (% AMI) | Average annual household income as a percentage of HUD area median family income. Adjusted for each household by household size | Based on actual tenant household incomes, not income eligibility limits for properties. Codes for missing values: -1: missing data; -4: Suppressed (fewer than 11 households reporting); -5 Non-reporting (where reporting rates are less than 50%). | Florida Housing Tenant Data Reporting System; USDA RD State Office Annual Data Feed; 2015 HUD Picture of Subsidized Households |
| % 0-30% AMI | Percentage of households with incomes between 0 and 30% of area median income | Based on actual tenant household incomes, not income eligibility limits for properties. Codes for missing values: -1: missing data; -4: Suppressed (fewer than 11 households reporting); -5 Non-reporting (where reporting rates are less than 50%). | Florida Housing Tenant Data Reporting System; USDA RD State Office Annual Data Feed; 2015 HUD Picture of Subsidized Households |
| % 30-50% AMI | Percentage of households with incomes between 30 and 50% of area median income | Based on actual tenant household incomes, not income eligibility limits for properties. Codes for missing values: -1: missing data; -4: Suppressed (fewer than 11 households reporting); -5 Non-reporting (where reporting rates are less than 50%). | Florida Housing Tenant Data Reporting System; USDA RD State Office Annual Data Feed; 2015 HUD Picture of Subsidized Households |
| % >50% AMI | Percentage of households with incomes above 50% of area median income | Based on actual tenant household incomes, not income eligibility limits for properties. Codes for missing values: -1: missing data; -4: Suppressed (fewer than 11 households reporting); -5 Non-reporting (where reporting rates are less than 50%). | Florida Housing Tenant Data Reporting System; USDA RD State Office Annual Data Feed; 2015 HUD Picture of Subsidized Households |
| # of Households Reporting | Number of households reporting tenant information | Florida Housing Tenant Data Reporting System; USDA RD State Office Annual Data Feed; 2015 HUD Picture of Subsidized Households | |
| Tenant Data Source | Source of tenant characteristics data | Florida Housing Tenant Data Reporting System; USDA RD State Office Annual Data Feed; 2015 HUD Picture of Subsidized Households | |
| Vacancy Rate, 2010 | The number of vacant housing units divided by the total number of housing units. its occupant or occupants are only temporarily absent. | Specified for Census block group and county surrounding the property. | U.S. Census Bureau, 2010 Census |
| Homeownership Rate, 2010 | Number of owner occupied units divided by total occupied units. | Specified for Census block group and county surrounding the property. | U.S. Census Bureau, 2010 Census |
| Renter Rate, 2010 | Number of renter occupied units divided by total occupied units. | Specified for Census block group and county surrounding the property. | U.S. Census Bureau, 2010 Census |
| Rental Vacancy Rate, 2010 | The rental vacancy rate is the proportion of the rental inventory that is vacant "for rent." It is computed by dividing the number of vacant units "for rent" by the sum of the renter-occupied units, vacant units that are "for rent," and vacant units that have been rented but not yet occupied. | Specified for Census block group and county surrounding the property. | U.S. Census Bureau, 2010 Census |
| % White, Non-Hispanic, 2010 | Percent of householders having origins in any of the original peoples of Europe, the Middle East, or North Africa. It includes people who indicate their race as "White" or report entries such as Irish, German, Italian, Lebanese, Arab, Moroccan, or Caucasian. | Specified for Census block group and county surrounding the property. | U.S. Census Bureau, 2010 Census |
| % African American, Non-Hispanic 2010 | Percent of householders having origins in any of the Black racial groups of Africa. It includes people who indicate their race as "Black, African Am., or Negro" or report entries such as African American, Kenyan, Nigerian, or Haitian. | Specified for Census block group and county surrounding the property. | U.S. Census Bureau, 2010 Census |
| % Hispanic, 2010 | Percent of householders who identify with the terms "Hispanic," "Latino," or "Spanish" are those who classify themselves in one of the specific Hispanic, Latino, or Spanish categories listed on the questionnaire ("Mexican," "Puerto Rican," or "Cuban") as well as those who indicate that they are "another Hispanic, Latino, or Spanish origin." | Specified for Census block group and county surrounding the property. | U.S. Census Bureau, 2010 Census |
| % Asian, Non-Hispanic, 2010 | Percent of householders having origins in any of the original peoples of the Far East, Southeast Asia, or the Indian subcontinent, including, for example, Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, the Philippine Islands, Thailand, and Vietnam. It includes people who indicate their race as "Asian Indian," "Chinese," "Filipino," "Korean," "Japanese," "Vietnamese," and "Other Asian" or provide other detailed Asian responses. | Specified for Census block group and county surrounding the property. | U.S. Census Bureau, 2010 Census |
| % Other Race Non-Hispanic, 2010 | Percent of householders who identify themselves as a race other than "White," "Black or African American," "American Indian or Alaska Native," "Asian," and "Native Hawaiian or Other Pacific Islander" race categories described above and also do not identify as "Hispanic" as described above. Respondents reporting entries such as multiracial, mixed, or interracial. | Specified for Census block group and county surrounding the property. | U.S. Census Bureau, 2010 Census |
| Median Single Family Sale Price, 2016 | Median of the sale price for single family homes. Sale price based on the sales transaction data as indicated by the documentary stamp tax on the deed. | Specified for Census block group and county surrounding the property. | Florida Department of Revenue, 2016 Sales Data File |
| Change in Median Single Family Sales Price, 2012 - 2016 | Percentage change in the median of the sale price for single family homes in 2016 compared to median sales price in 2012. Sale prices are based on the sales transaction data as indicated by the documentary stamp tax on the deed. | Specified for Census block group and county surrounding the property. | Florida Department of Revenue, 2012 and 2016 Sales Data File |
| Average Just Value/Sq. Ft., Single Family, 2017 | Just value as measured by the property appraiser's opinion of market value, divided by the total living area of the property | Specified for Census block group and county surrounding the property. | Florida Department of Revenue, 2017 Name-Address-Legal File |
| Average Just Value/Sq. Ft., Multifamily, 2017 | Just value as measured by the property appraiser's opinion of market value, divided by the total living area of the property | Specified for Census block group and county surrounding the property. | Florida Department of Revenue, 2017 Name-Address-Legal File |
| Median Condo Sale Price, 2016 | Median of the sale price for condominiums. Sale price based on the sales transaction data as indicated by the documentary stamp tax on the deed. | Specified for Census block group and county surrounding the property. Value of "-" means there is not a sufficient amount of data to provide an estimate. | Florida Department of Revenue, 2016 Sales Data File |
| % of households with at least one child age 0-17, 2010 | Percentage of occupied housing units where at least one person under the age of 17 lives. Indicates the presence of children. | Specified for Census block group and county surrounding the property. | U.S. Census Bureau, 2010 Census |
| % of households with at least one person age 65 or older, 2010 | Percentage of occupied housing units where at least one person over the age of 65 lives. Indicates the presence of elderly household members. | Specified for Census block group and county surrounding the property. | U.S. Census Bureau, 2010 Census |
| Total Living Area | Square footage of living area in all units in development | Florida Department of Revenue Name-Address-Legal File | |
| Number of Buildings | Number of buildings in the development; may include common areas as well as buildings with dwelling units. | Florida Department of Revenue Name-Address-Legal File | |
| REAC Score | Physical inspection score from HUD's Real Estate Assessment Center (REAC) | 60 or above: passing; <60: substandard conditions; a: no health and safety (H & S) deficiencies; b: one or more non-life threatening H & S deficiencies; c: one or more life-threatening H & S deficiencies; asterisk (*): smoke deterctor deficiency | HUD REAC Physical Inspection Scores |
| REAC Inspection Date | Date of last REAC inspection | HUD REAC Physical Inspection Scores | |
| Construction Type (Florida Housing Only) | Rehabilitation, new construction, acquisition/rehabilitation, or combination | Information only available for Florida Housing developments | Florida Housing Data Feed |
| Column Name | Definition | Notes | Data Source(s) |
|---|---|---|---|
| LPI ID | Unique ID for lost properties assigned by Shimberg Center | Shimberg Center | |
| Shim ID | Unique AHI property ID assigned by Shimberg Center | Shimberg Center | |
| FHFC HPP key | Unique ID assigned by Florida Housing Finance Corporation to its funded properties | Florida Housing Data Feed | |
| Name | Development name as reported by funding sources | Florida Housing Data Feed, HUD State Office Annual Data Feed, USDA RD State Office Annual Data Feed, LHFA Survey | |
| Address | Street address where development is located | Florida Housing Data Feed, HUD State Office Annual Data Feed, USDA RD State Office Annual Data Feed, LHFA Survey | |
| City | City where development is located | Florida Housing Data Feed, HUD State Office Annual Data Feed, USDA RD State Office Annual Data Feed, LHFA Survey | |
| Zip | Zip code where development is located | Florida Housing Data Feed, HUD State Office Annual Data Feed, USDA RD State Office Annual Data Feed, LHFA Survey | |
| County | County where development is located | Florida Housing Data Feed, HUD State Office Annual Data Feed, USDA RD State Office Annual Data Feed, LHFA Survey | |
| Total Units | Total number of units in development - includes property management units | Florida Housing Data Feed, HUD State Office Annual Data Feed, USDA RD State Office Annual Data Feed, LHFA Survey | |
| Estimated Assisted Units | Number of units with rent and/or income restrictions | For early Lost Properties Inventory developments, assisted units are estimated. If property appeared in the AHI previously, number of assisted units as last reported in the AHI. If not, this field consists of the minimum number of assisted units required for the property based on its funding sources. For properties funded by State or Local Bonds, Housing Credits 4% or 9%, and SAIL, this consists of 20% of total units. For FDIC properties, this consists of 35% of total units. Note that some of these properties likely had more assisted units than estimated here. | |
| HUD/RD Rental Assistance Units | Number of units receiving monthly rental assistance from USDA RD or HUD. | HUD Multifamily Assistance and Section 8 Contracts Database; USDA RD State Office Annual Data Feed | |
| Housing Program(s) | Includes programs administered by the U.S. Dept. of Housing and Urban Development (HUD), U.S. Department of Agricultural and Rural Development (RD), Florida Housing Finance Corporation (Florida Housing), and Local Housing Finance Authorities (LHFA) | Inventory only reports programs that include income and/or rent restrictions. Programs without income/rent restrictions are also reported if they are combined with programs that include restrictions. | Florida Housing Data Feed, HUD State Office Annual Data Feed, USDA RD State Office Annual Data Feed, LHFA Survey |
| FHFC Funded | Property received funding from Florida Housing Finance Corporation | See below for specific programs administered by Florida Housing. | Florida Housing Data Feed |
| RD Funded | Property was funded under a program by the US Dept. of Agriculture and Rural Development (RD) | See below for specific RD programs | USDA RD State Office Annual Data Feed |
| LHFA Funded | Property was funded by a Local Housing Finance Authority | Funding comes through locally administered bonds; see below. | LHFA Survey |
| HUD Funded | Property participates in program(s) funded by the US Dept. of Housing and Urban Development | See below for specific HUD programs. | HUD State Office Annual Data Feed |
| Year of Loss | If property appeared in the AHI previously, Year of Loss is the last year the property appeared in the AHI. Otherwise, Year of Loss is the latest of: date of last report to FHFC, year of opt-out from HUD project-based rental assistance, year of prepayment of HUD mortgage, or year of assignment of HUD mortgage. | ||
| Tax Credit or Bond Property No Longer Under Use Restrictions | Properties previously receiving bond financing from an LHFA or bonds, 4% Housing Credits, or 9% Housing Credits from Florida Housing. | ||
| HUD Section 8 Expired Contract/Opt-Out | Properties previously receiving project-based rental assistance from HUD. | ||
| HUD Prepaid Mortgage | Properties for which owner has prepaid a HUD multifamily insured mortgage. | ||
| HUD Assigned Mortgage | Properties for which mortgage has been assigned to HUD; i.e., transferred from original borrower to HUD. | ||
| RD Prepaid Mortgage | Properties for which owner has prepaid a Section 515 or Section 514/516 loan from RD. | ||
| Year Built/Funded | If property appeared in the AHI previously, Year Built/Funded is taken from the last year the property appeared in the AHI. It consists of the year built where available; otherwise, it consists of the earliest funding year. If the property did not appear in the AHI previously, Year Built/Funded is obtained from FHFC records. | ||
| Type of Ownership | Owner corporation type (non-profit, for-profit, limited dividend) | Florida Housing Data Feed, HUD State Office Annual Data Feed, USDA RD State Office Annual Data Feed | |
| Population Served | Population served by development (e.g. Family, Elderly, Persons with Disabilities) | Florida Housing Data Feed, HUD State Office Annual Data Feed, USDA RD State Office Annual Data Feed, LHFA Survey | |
| Latitude | Latitude coordinate of development | Shimberg Center | |
| Longitude | Longitudinal coordinate of development | Shimberg Center |
| Data set | Link if available | Last updated in AHI |
|---|---|---|
| Florida Department of Revenue Name-Address-Legal File | http://floridarevenue.com/property/Pages/DataPortal.aspx | April 2022 |
| Florida Housing Data Feed | March 2024 | |
| Florida Housing Inactive Properties List | March 2024 | |
| Florida Housing Tenant Reporting Data System | April 2024 | |
| HUD Qualified Census Tracts & Difficult Development Areas Dataset | http://www.huduser.org/portal/datasets/qct.html | 2024 |
| HUD Insured Multifamily Mortgages Database | https://www.hud.gov/program_offices/housing/comp/rpts/mfh/mf_f47 | May 2024 |
| HUD Multifamily Assistance and Section 8 Contracts Database | https://www.hud.gov/program_offices/housing/mfh/exp/mfhdiscl | September 2024 |
| HUD Multifamily Portfolio Datasets--Contracts with Rent Amt and Utility Allowance Amt | https://www.hud.gov/program_offices/housing/mfh/presrv/mfhpreservation | March 2024 |
| HUD Public Housing Developments | https://egis-hud.opendata.arcgis.com/datasets/5c96143f79c940a0a8cedae99a1ac562_0 | February 2024 |
| HUD REAC Physical Inspection Scores | https://www.hud.gov/program_offices/housing/mfh/rems/remsinspecscores/remsphysinspscores | February 2024 |
| HUD Section 8 Opt-Out Dataset | June 2007 | |
| HUD State Office Annual Data Feed | March 2022 | |
| HUD Terminated Multifamily Mortgages Database | https://www.hud.gov/program_offices/housing/comp/rpts/mfh/mf_f47t | February 2024 |
| HUD Picture of Subsidized Households | https://www.huduser.gov/portal/datasets/assthsg.html | December 2023 |
| LHFA Survey | March 2024 | |
| USDA RD State Office Annual Data Feed | March 2018 | |
| USDA RD Multifamily Housing Datasets | https://www.sc.egov.usda.gov/data/MFH.html | February 2024 |
Last updated May 2024
