Address-level dataset of of properties receiving HCD services from July 1, 2009 - March 31, 2023 (FY10-Q1 23). Data was combined in June-July 2020 from multiple sources, including IDIS (HUD data and reimbursement system), tracking spreadsheets maintained by HCD managers, and WAPez (weatherization data system).
This dataset has the following 20 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
100 Block Address | address_rounded | text | Rounded address to the nearest 100 block. (E.g., 340 Main St becomes 300 Main, 370 Main St becomes 400 Main). This is to protect privacy while allowing for detailed spatial analysis. | view top 100 |
City | city | text | Memphis Cordova Bartlett New York view top 100 | |
State | state | text | TN NY view top 100 | |
Zip code | zip_code | text | 38109 38114 38127 38106 38107 view top 100 | |
Project Name | project_name | text | Project name from IDIS or manager spreadsheets | Down Payment Assistance (DPA) Lead hazard remediation The Works, Inc HARP Minor Home Repair Aging In Place Douglass, Bungalow & Crump CDC HARP Minor Home Repair view top 100 |
Project Type | project_type | text | Specific project type and/or program | HARP Minor Home Repair Lead hazard remediation CHDO Aging In Place HARP Major Rehab view top 100 |
Status | status | text | Activity status (Complete, Open, etc.) | Complete In Progress Cancelled In Process Underway view top 100 |
Completion Date | completion_date | calendar_date | Approximate completion date for activities, based on completion date in the relevant reporting system (e.g. IDIS completion date). In some cases activity may have been "completed" in the system some time after real-world project completion, though typically closeout occurs in the same fiscal year. | 2022-10-21T00:00:00.000 2019-02-12T00:00:00.000 2017-06-30T00:00:00.000 2009-11-09T00:00:00.000 2023-03-16T00:00:00.000 view top 100 |
Units | units_hhs | number | Number of housing units completed for each row | 1 4 10 8 2 view top 100 |
Property Type | property_type | text | Type of property receiving services (single family, multifamily, commercial, etc.) | Single Family Multifamily Duplex single Public/Community Spaces, Facilities & Infrastructure view top 100 |
Tenure Type | tenure_type | text | Type of occupant for which the project was intended (owner or renter) | Owner Renter Vacant view top 100 |
Activity/Dev. Type | activity_type_simple | text | Simplified activity/development type category, indicating whether project was Acquisition, New Construction, Rehab, Demolition, etc. | Rehab Down Payment Assistance Lead New Construction Weatherization view top 100 |
Funding Type | funding_type | text | Source of funding | CDBG HOME Lead Hazard Reduction Demonstration Grant (LHRD) City DOE WAP Grant view top 100 |
Organization | organization | text | Organization receiving funding to carry out this project | HCD Lead Habitat for Humanity The Works, Inc Douglas, Bungalow, Crump CDC view top 100 |
Total Budgeted | total_funds_committed | number | Total project funds administered from/via HCD | 5625 10000 40000 634518 50000 view top 100 |
Lat | lat | number | 35.106 35.165 35.169 35.088 35.111 view top 100 | |
Long | long | number | -90.039 -90.038 -89.978 -89.977 -89.972 view top 100 | |
New Georeferenced Column | geocoded_column | point | Geo coordinates | {"coordinates":[-90.025,35.148],"type":"Point"} {"coordinates":[-90.038,35.165],"type":"Point"} {"coordinates":[-89.947,35.226],"type":"Point"} {"coordinates":[-90.038,35.128],"type":"Point"} {"coordinates":[-90.039,35.168],"type":"Point"} view top 100 |
Accelerate Memphis | accelerate_memphis | text | Designates programs funded through the Accelerate Memphis program | 2000000 2500000 10000000 6000000 632276 view top 100 |
Award Number | award_number | text | 12970 12400 64051 12910 12341 view top 100 |