Multifamily Assistance & Section 8 Database (zip file)

https://www.hud.gov/program_offices/housing/mfh/exp/mfhdiscl
The zipped file contains the following 3 files:

  • MF_Assistance_&_Sec8_Contracts.accdb
  • MF_Assistance_&_Sec8_Contracts1.xlsx. Data includes these columns:
    1. contract number
    2. property id
    3. property name text
    4. tracs effective date
    5. tracs overall expiration date
    6. tracs overall exp fiscal year
    7. tracs overall expire quarter
    8. tracs current expiration date
    9. tracs status name
    10. contract term months qty
    11. assisted units count
    12. is hud administered ind
    13. is acc old ind
    14. is acc performance based ind
    15. contract doc type code
    16. program type name
    17. program type group code
    18. program type group name
    19. rent to FMR ratio
    20. rent to FMR description
    21. 0BR count
    22. 1BR count
    23. 2BR count
    24. 3BR count
    25. 4BR count
    26. 5plusBR count
    27. 0BR FMR
    28. 1BR FMR
    29. 2BR FMR
    30. 3BR FMR
    31. 4BR FMR
  • MF_Properties_with_Assistance_&_Sec8_Contracts1.xlsx. Data includes these columns:
    1. hub name text
    2. servicing site name text
    3. property id
    4. property name text
    5. property phone number
    6. address line1 text
    7. address line2 text
    8. city name text
    9. state code
    10. zip code
    11. zip4 code
    12. county code
    13. county name text
    14. msa code
    15. msa name text
    16. congressional district code
    17. placed base city name text
    18. property total unit count
    19. property category name
    20. primary financing type
    21. associated financing Number
    22. is insured ind
    23. is 202 811 ind
    24. is hud held ind
    25. is hud owned ind
    26. is hospital ind
    27. is nursing home ind
    28. is board and care ind
    29. is assisted living ind
    30. is refinanced ind
    31. is 221d3 ind
    32. is 221d4 ind
    33. is 236 ind
    34. is non insured ind
    35. is bmir ind
    36. is risk sharing ind
    37. is mip ind
    38. is co insured ind
    39. is opportunity zone ind
    40. ownership effective date
    41. owner participant id
    42. owner company type
    43. owner individual first name
    44. owner individual middle name
    45. owner individual last name
    46. owner individual full name
    47. owner individual title text
    48. owner organization name
    49. owner address line1
    50. owner address line2
    51. owner city name
    52. owner state code
    53. owner zip code
    54. owner zip4 code
    55. owner main phone number text
    56. owner main fax number text
    57. owner contact email text
    58. mgmt agent participant id
    59. mgmt agent company type
    60. mgmt agent indv first name
    61. mgmt agent indv last name
    62. mgmt agent indv middle name
    63. mgmt agent full name
    64. mgmt agent indv title text
    65. mgmt agent org name
    66. mgmt agent address line1
    67. mgmt agent address line2
    68. mgmt agent city name
    69. mgmt agent state code
    70. mgmt agent zip code
    71. mgmt agent zip4 code
    72. mgmt agent main phone number
    73. mgmt agent main fax number
    74. mgmt contact email text
Download/View

RESOURCE DETAILS: