Citywide Home Repair Task Force
Welcome to the Citywide Home Repair Task Force (CHRTF) Website. Here you will find details about the project and how to share your data. Fundamentally, the goal of the Citywide Home Repair Task Force is to better understand the Home Repair Ecosystem in Detroit.
In order to do this, we are collecting data from CHRTF members, cleaning that data, and analyzing it to provide answers to questions like:
What was the total number of homes improved during the reporting period?
What was the total amount of dollars spent on home repair?
What is the breakdown between the total amount of dollars spent on owner-occupied homes versus renter-occupied homes?
Our Mission
To provide accessible, high-quality information and analysis to drive informed decision-making.
Data enables us to more objectively understand our community. Using data, we can have informed conversations about the current state of our community, how to best deliver resources, and create the deepest impact.
We Value
Unbiased access to data.
We Exist
To provide equitable access to information and help our community make better decisions.
We Serve
Anyone seeking information to make more informed decisions, including nonprofit organizations, foundations, universities, governments, businesses, and individuals.
We Believe
That behind every data point is a living, breathing person.
Why is D3 Involved?
We are leading specialists in data management with expertise in data collection, data cleaning, and data analytics. Part of our mission is to help organizations, like yours, form data collaboratives. The reason organizations like ours are brought in is because public sector organizations often don’t have the time or funding to do in-depth data strategy and analysis work. We also represent a neutral third party organization that is here to help you develop your data collection strategy and to answer the questions most important to you.
Data collaboratives can be structured in many different ways. Typically, they begin with organizations signing an agreement that outlines what data is being collected and who has access to the data. The current CHRTF Data Stewardship Policy is available here:
TASK FORCE DATA STEWARDSHIP
The sharing of data is integral to the collaboration and vision this Task Force aims to achieve. While the Task Force is a voluntary initiative and this Compact creates no legally binding rights or obligations, Task Force partners are expected to abide by key data stewardship requirements to maintain Task Force membership.
For data provided by Task Force partners as a result of its data share responsibility, the Task Force commits to:
- Only use the data to further the mission of the Task Force, including:
- Reformat & synthesize the data for the creation of an aggregate data set
- Analyze and review the aggregate data set for service overlap and for trends
- Share the aggregate data set only with signed, active Task Force partners
- Report summarized home repair data for the entire Task Force.
For data received by Task Force partners as a result of the Task Force’s data share initiative, the Task Force and its partners commit to:
- Only use the data to further the mission of the Task Force, including:
- Collaborate with other Task Force partners to better serve home repair participants
- Collaborate with other Task Force partners to better implement our programs
- Limit access to Task Force data within partner organizations to staff actively participating in collaborative Task Force activities (Work Groups or program coordination),
- Never report or share Task Force data on behalf of an organization that is not their own, AND
- Never share Task Force data with an individual or organization that is not a signed and active Task Force partner.
What Data are We Collecting?
We are expecting that most organizations will send us an excel spreadsheet. You can send us whatever you have, in whatever format you have it, provided it has the data in the agreed upon data fields, listed below. If your data field names are different than the names listed out here, you can include that information on your spreadsheet or email it to D3 at szarb@datadrivendetroit.org
This is still a pilot phase of our project, and we encourage organizations to submit their data as it is, even if it’s not perfect. Please send us whatever data you have, in any format you have it. We are currently collecting data from Home Repairs completed between June 1st, 2024 and September 30th, 2024. If you have data from home repairs completed between January 1st, 2024 and May 31st, 2024 that you did not send in already, upload that data using the same link. However, if possible, please send it in a separate spreadsheet and ensure the file name indicates that it is for the earlier time period.
Please send in your data by October 31st, 2024.
These are the agreed upon data fields:
| Data Field | Required | Definition |
|---|---|---|
| Organization Name | Yes | Name of the organization providing the home repair (generally the organization who contracts with and compensates the construction provider). |
| Home Repair Program Name | Yes | Name of the home repair program the household was served by, e.g. Neighborhood Enhancement Program (NEP), Senior Emergency Home Repair, Detroit Home Repair Fund, etc. |
| Repair Types | Yes | Broad category of home repair service: Accessibility Building-Foundation Building-Roof Building-Siding Building-Structure Building-Windows Energy Waste Reduction Electrical Health Hazard Removal HVAC Plumbing Property Improvement (non-house) Weatherization Minor Home Repair Unspecified |
| Measures Completed | Optional | Optional data point for programs already capturing this information. More specific than repair type; multiple measures may fall within a single repair type category. |
| Date Completed | Yes | The date the home repair was completed, ideally corresponding to a contractor/resident approval. |
| Total Amount Spent | Yes | The total amount spent to complete all home repair services at the household, at the time of completion date. Does not include administrative costs. |
| Funding Source(s) | Yes | Provide the funding source or funding sources required to complete the home repair program administered at this home. |
| Address | Yes | The address of the structure that received home repair services. |
| Zip Code | Yes | The zip code of the structure that received home repair services. |
| Relationship to Property | Yes | The relationship to the property, owner-occupant/renter/landlord, of the participant who qualified for the home repair program. |
| Potential remaining repair needs | Optional | Outstanding home repair needs observed in the house after the home repair service was provided; recommended to capture at the repair type (trade) level. |
| Number people in household | Optional | The number of residents living in the home, generally used for determining household income level. |
| Vulnerable/Veteran population | Optional | If any of the residents living in the home are considered a vulnerable population, indicate which vulnerable population is present: Senior, Child under 6, Disabled, and/or Veteran. |
Have questions?
If you have questions or concerns let us know! If you need a little bit more help figuring out what to do, we’re ready to help!