By-Name Data
The information and resources here are intended to answer questions and support your community to develop and sustain quality By-Name Data on your journey to ending chronic and veteran homelessness.
Keep checking back here as we will be regularly updating materials and adding further resources.
By-Name Data is real-time data of all known people experiencing homelessness in your community. It includes a robust set of data points that support coordinated access and prioritization at a household level and an understanding of homeless inflow and outflow at a system level. This real-time actionable data supports triage to services, system performance evaluation and advocacy (for the policies and resources necessary to end homelessness).
By-Name Data is a subtle but important shift away from the term By-Name List – where a By-Name List was sometimes interpreted as stand-alone data. By-Name Data refers to the dynamic universe of person-specific homelessness data contained within your overall community-wide homelessness database or data system. Materials and information on this website will be updated over time to align with the term By-Name Data (BND). Communities are encouraged to continue to use whatever terms make the most sense within your local context.
For further background information about By-Name Data:
- By-Name Data – an overview blog by Community Solutions
- How By-Name Data Helps Communities to End Homelessness – 3 minute video
- Introduction to By-Name Data – a free 30 minute online course
Click on the box below to access the three-page 10 Steps to Create and Use By-Name Data that provides you with the overall steps and links to further resources to help you develop, maintain and use a quality By-Name List. The webinar series below will walk you through the further details of the “10 Steps” and the community of practice presentations provide examples of how communities have created and use By-Name Data.
Getting Started with By-Name Data – Webinar Series
- Introduction to By-Name Lists (a 40 minute on-line course) – access here and use the key: BNLIntro
- By-Name Lists – What and Why? – Recording (25 min) and Presentation
- 10 Steps to Create and Use a BNL – Recording (50 min) and Presentation
- Leadership and Governance – Recording (15 min) and Presentation
- Engaging Partners – Recording (29 minutes) and Presentation
- Outreach Coverage and Coordination – Recording (10 min) and Presentation
- Privacy, Consent and Data Sharing – Recording (30 min) and Presentation
- Adding to and Updating a By-Name List – Recording (37 min) and Presentation
- Leveraging a Point-in-Time Count to Kickstart or Strengthen your By-Name List – Recording (18 min) and Presentation
- Inactivity Policy – Recording (15 min) and Presentation
- Completing the BNL Scorecard – Recording (14 min) and Presentation
- Provider Participation Tool – Recording (33 min) and Presentation
- By-Name List Excel Workbook Series:
- 01 – About the Excel Workbook – Recording (4 min) and Presentation
- 02 – Overview – Recording (14 min) and Presentation
- 03 – Workbook Setup – Recording (5 min) and Presentation
- 04 – Adding, Updating and Storing Client Data – Recording (35 min) and Presentation
- 05 – Capturing Monthly Data – Recording (5 min) and Presentation
- 06 – Troubleshooting Data Balancing – Recording (6 min) and Presentation
- System Level Data and Data Reliability – Recording (14 min) and Presentation
- How to Use BNL Data – Part 1 – Person-Level – Recording (25 min) and Presentation
- How to Use BNL Data – Part 2 – System-Level – Recording (21 min) and Presentation
- Ontario BNL 2022 Requirements – Recording (12 min) and Presentation
The By-Name Data Scorecard sets out an ambitious framework with 13 key elements for building the necessary data management and systems coordination practices to understand the movement of everyone experiencing homelessness in your community (those identified and consenting). The By-Name Data Scorecard is part of the Scorecards and Tools Workbook. The Scorecards and Tools Workbook version 4.0 was released November 2024. For an overview, see the Scorecards and Tools Workbook 4.0 Launch – Recording and PDF or review the By-Name Data Scorecard Guide below.
By-Name Data Scorecard Guide
Start by reviewing the By-Name Data Scorecard Guide. The Guide explains what the BND Scorecard is and walks you through each question (including a full explanation along with tips and resources).
Complete the By-Name Data Scorecard
The By-Name Data (BND) Scorecard is part of the Scorecards & Tools Workbook (a Google Worksheet). This is a view only version – you can make a copy to use for your community. If your community is connected to Built for Zero, you can find your Scorecards and Tools Workbook in your Change Package. The first tab of the Workbook provides an overview of all the tools, including the BND Scorecard. Each question in the BND Scorecard has links to the appropriate supporting information in the By-Name Data Scorecard Guide. Record your answers in the BND Scorecard tab to receive your score for Foundations, Veteran, and Sustain and Continuous Improvement. Use the notes section to explain your answer and identify your next steps. Remember, your score is for improvement, not judgement!
Scorecard Tools:
- BND Scorecard Group Exercises – ideas you can use with your community when you review the BND Scorecard together
- By-Name Data Reliability Tool – this interactive tool allows communities to enter By-Name Data and determine if it is balanced and reliable. It also provides definitions, samples and calculations for each of the BND key aggregate data points.
When we collect sensitive and personal information we have an obligation to protect the privacy, safety and dignity of the individuals whose information is collected.
canadian alliance to end homelessness resources:
- Privacy, Consent and Data Sharing (2022) – Recording (30 min) and Presentation
- Privacy Legislation in Canada – A Primer for Homeless Serving Systems (2019)
- Common Consent Template – a Word document with two customizable common consent examples
- 20,000 Homes Campaign guidelines for dealing with personal information (2015)
HIFIS 4 Guidance:
- Control and Protect Client Information (INFC, 2023) – an 8 page guide for HIFIS leads that provides a list of the HIFIS functions and settings that can be leveraged to control and protect the information entered into the system. It also provides details on who can manage the function or setting, how it can be turned on and off and its impact when activated.
- HIFIS Implementation Guide V.1 (ESCD, 2019) – see pages 21-23 for privacy and legal compliance information
- Data Sharing and Privacy in HIFIS 4 (ACRE Consulting, 2018) – a 30-page document outlining what is shared and what isn’t. The introduction is a must read in order to support understanding of the full document.
Sample Consent and Data Sharing Agreements, Forms, & Materials from Communities:
Multiple Sample Documents on ACRE Website:
- Sample Community Documents on ACRE Website – including Privacy Impact Assessments, data sharing agreements, consent forms and more
Brantford:
- Procedures for Managing Users on HIFIS – includes consent form with scripts and job aid, how to create user accounts, how to handle FOI requests, HIFIS Training checklist
- HIFIS Confidentiality and User Agreement
Dufferin County:
- Privacy and Confidentiality Considerations
- Client Consent Form
- HIFIS Confidentiality & User Agreement
- Data Sharing Agreement for Service Providers
Guelph-Wellington:
- Guelph-Wellington By-Name List Ethics Review
- Guelph-Wellington Coordinated Entry Guide
- Oath of Confidentiality (see Appendix B)
- HIFIS Data Sharing Agreement (see Appendix C)
- HIFIS Collection and Release of Information (see Appendix E)
Kawartha-Haliburton:
- Coordinated Entry System Process Guide:
- Multi-Agency Consent Form (see Appendix C)
- By-Name List Identity Protection Process (see Appendix D)
- By-Name List Addition and Consent Form (see Appendix H)
St. John’s:
- End Homelessness St. John’s Coordinated Access Consent Form (2021)
- Privacy Impact Assessment (PIA) for HIFIS (2019)
Waterloo Region:
- Privacy and Consent Training Video
- HIFIS 4 Protocol: Privacy and Consent (for Service Providers)
- HIFIS 4 Consent Cheat Sheet
- Sample Housing Stability System Shared Consent Script
Windsor-Essex:
HIFIS is a Homeless Management Information System (HMIS) that can be used to collect, hold, manage and report on your By-Name List. This section is intended to serve as a one-stop for all things HIFIS related.
- By-Name Data and Coordinated Access in HIFIS
- HIFIS added increased By-Name Data and Coordinated Access functionality with the December 2020 release of HIFIS version 59 and the October 2023 release of version 60.
- INFC’s Coordinated Access in HIFIS Guide (May 2024) – explains CA and then offers suggestions for HIFIS system configuration and using the customizable features in HIFIS.
- Here is ACRE Consulting’s Guide to BNLs in HIFIS (May 2023, 20 pages) – this document is intended for local service provision coordinators who want to know exactly how a BNL relates to their HIFIS system.
- Here is the CAEH HIFIS Monthly Inflow/Outflow Report that can support you to pull your aggregate BND. Includes a Guide explaining how it works and a sample output report.
- Here is an ACRE webinar (April 2023) reviewing the similarities and differences in the HIFIS Reports for the Reaching Home Community Homelessness Report (CHR) 2022/2023, the CAEH Monthly Inflow/Outflow Report, and Ontario Homelessness Prevention Program (HPP).
- HIFIS General Information
- HIFIS on the Office of Infrastructure Canada (INFC) website
- Most recent HIFIS Overview Information:
- HIFIS: A Tool for Ending Homelessness – one page overview
- About HIFIS: Canada’s Homelessness Management Information System – Homelessness Learning Hub (2023) – a PowerPoint slide deck you can download and review
- HIFIS Overview and Coordinated Access Course (ACRE, 2024) – a free one-hour course with 6 modules for those not directly using HIFIS to help understand the big picture of HIFIS.
- HIFIS Client Support Centre – e-mail support@hifis.ca or phone 1-866-324-2375 (open Monday to Friday 7:00 am – 5:00 pm ET)
- HIFIS General Inquiry e-mail – for general inquiries about HIFIS, including information on planning for HIFIS implementation: HPD.HIFIS.DEV-DEV.SISA.DPMI@infc.gc.ca
- HIFIS Support Resources – HIFIS Library of Resources on the Homelessness Learning Hub – get access to all HIFIS information from INFC including guides, webinars, courses, newsletters, release notes, and more
- Other HIFIS Information not included in the HIFIS Library of Resources (above):
- HIFIS 4 Demo site – for a hands on look at what HIFIS can do
- HIFIS Look Up Tables – the list of data fields and drop-downs in HIFIS version 4.0.60
- HIFIS Readiness Checklist – complete this prior to receiving a HIFIS license to ensure you are prepared for HIFIS
- HIFIS Known Issues Log – to see if an issue affecting you has already been reported to the HIFIS Client Support Centre
- HIFIS SQL Database Schema – additional information on the HIFIS database
- Reaching Home Directives on HIFIS (see end of Section #4 – Coordinated Access) – requirements for Reaching Home Designated Communities
- Sign-up for Reaching Home Newsletters:
- Reaching Home Newsletter – to subscribe to the Reaching Home Newsletter, send your consent to hpd.rh.info-info.vcs.dpmi@infc.gc.ca
- HIFIS Newsletter – to subscribe to the HIFIS Newsletter, send your consent to HPD.HIFIS.DEV-DEV.SISA.DPMI@infc.gc.ca
- See past issues of HIFIS Newsletters,
- ACRE Consulting – HIFIS 4 resources including a collection of 60+ reports available for free. ACRE also occasionally posts advice about best practices, new features, and tutorials. They also offer fee-for-service training, report development and other supports to implement HIFIS 4.
- Sign-up for ACRE Consulting mailing list to stay up to date about new resources
- Need help with launching HIFIS? Check out the HIFIS 4 Implementation Masterclass
- Online training is available for you and your front line staff
- Download some free and premium reports
- Struggling with data quality? You might be interested in the Audit Boot Camp
- Guide to Client Information in HIFIS (June 2023, 20 pages) – covers all the modules in Client Information and provides an overview on the coverage, necessity and utility of each as well as guidance in deciding what modules to use
- Data Sharing and Privacy in HIFIS 4 (2018, 30 pages) – outlines what is and isn’t shared in HIFIS.
- Read previous recommendations reports and get involved with current projects
- Slack HIFIS Community:
- All are welcome to join the Slack HIFIS Community and anyone from the community can invite new members. Anyone interested in joining can also contact Erin Forrest at Erin.Forrest-miller@infc.gc.ca or Ali Ryder at ali@acreconsulting.ca.
- Extracting Data from HIFIS:
- How to Extract Data from HIFIS – Webinar Recording (1 hour) or PowerPoint PDF. See also this January 2019 blog from ACRE on Understanding Volume of Data in Reports.
- The HIFIS Report Writing and Data Mapping Guide explains how to use Crystal Reports in HIFIS, and provides database maps of HIFIS data tables. Report writers can refer to these maps to understand how data fields in HIFIS interact. The guide also provides guidance on how to create custom reports for analysis and reporting purposes. For additional details on the HIFIS database, please see the HIFIS SQL Database Schema.
- Here is a Building Crystal Reports Webinar from the HIFIS 2021 Virtual Workshop.
- Where to find existing reports:
- Here is the CAEH HIFIS Monthly Inflow/Outflow Report (and accompanying Report Guide) that can support you to pull your BNL key aggregate data points.
- When you are in HIFIS, you can go to the Market to find reports created by INFC
- ACRE website – download some free and premium reports
CAEH BNL Excel Workbook
See CAEH BNL Excel Workbook and CAEH BNL Excel Workbook Guide.
For Ontario Only – See the CAEH BNL Excel Workbook – ON HPP edition. See also short instructions for Changing Year in the ON HPP BNL Excel Workbook to help you close 2023/2024 and start 2024/2025.
The CAEH By-Name List Excel Workbook is a customizable interim approach for storing and using BNL data to end homelessness. It can be used until communities are able to fully implement a more sophisticated real-time Homelessness Management Information System (HMIS) like HIFIS 4 (the Homelessness Individual and Family Information System). The workbook is intended to be customized by communities for their unique needs. As is, the workbook meets the basic quality requirements for both the CAEH chronic and veteran BNL Scorecards. It is also designed to collect monthly inflow and outflow data.
To learn how to use this workbook, please consult the CAEH By-Name List Excel Workbook Guide. For further information and instructions, please refer to our By-Name List Excel Workbook Series and tips and tricks below.
- By-Name List Excel Workbook Series:
- 01 – About the Excel Workbook – Recording (4 min) and Presentation
- 02 – Overview – Recording (14 min) and Presentation
- 03 – Workbook Setup – Recording (5 min) and Presentation
- 04 – Adding, Updating and Storing Client Data – Recording (35 min) and Presentation
- 05 – Capturing Monthly Data – Recording (5 min) and Presentation
- 06 – Troubleshooting Data Balancing – Recording (6 min) and Presentation
- CAEH BNL Excel Workbook Important Tips – CoP Call March 11, 2022 – Recording and Presentation
Using excel – Tips
- Excel skills are considered essential for managing BNLs in Excel and generally for further analysis of data, regardless of what database you use to hold your BNL
- While BFZ-C does not provide Excel training, we have pulled together some recommendations for familiarizing yourself with Excel:
- Learn what makes sense – Excel has so many functions that it’s impossible to learn them all. Fun fact: there are over 450 functions! Don’t focus on learning everything about Excel, or complex formulas, but learn what you need from Excel.
- Learn by doing – After orienting yourself to some of the basics of Excel, just get started. Most people learn it best by playing around in Excel.
- Use it frequently – The more often you use it and devote time to it, the better you will be at remembering functions and learning new things. Use it for everything and anything that makes sense so that your regular work tasks became Excel learning opportunities.
- Excel training options you can consider
- Day Training – take a basic and intermediate half-day or full-day training in Excel that may be offered through your organization, local college, library, or on-line. This can provide a general overall orientation to general functions.
- YouTube – use if you learn best by watching videos, just search for whatever you are looking for.
- On-Line Search – whenever you get stuck or have a question, do a quick on-line search e.g., “Google it”.
- Dedicated websites – Here are some websites you might find helpful:
Its not just about having By-Name Data – its about how you display it for further analysis to help make data-driven decisions in your community. Below are sample data dashboards from a number of communities.
Canada
- Built for Zero Canada Community Dashboards – tracks monthly progress toward functional zero for chronic and veteran homelessness
- Edmonton Howard Trust – real-time updates through Tableau on emergency shelter usage, By-Name List chronic data, and overall housing and homelessness data by gender, Indigenous identity, location, and age
- Hamilton Affordable Housing & Homelessness Dashboard – this dashboard provides annualized affordable housing data and monthly homelessness data. The dashboard uses ArcGIS and is updated on a quarterly basis
- Lambton County – Individual Current on a By-Name List – released in 2024 through Power BI.
- New Brunswick – see dashboards for Fredericton and Moncton and Saint John (monthly HIFIS and BNL data through Human Development Council) and Emergency Shelter Dashboard (nightly HIFIS data through Social Supports NB)
- Niagara Region – monthly total chronic homelessness – part of their larger community dashboard project.
- Peterborough Report Card – updated monthly to show inflow and outflow changes
- Simcoe County – two Power BI dashboards with data from Jan 2023. The Shelter Utilization dashboard provides shelter data for nightly occupancy and capacity. The Shelter System Flow dashboard provides data about the number of people experiencing homelessness in Simcoe County and tracks who is entering and leaving the shelter system each month.
- Toronto Shelter System Flow Data Dashboard – a Tableau dashboard showing monthly inflow, outflow and total active homeless data from the City of Toronto shelter system
- Toronto Daily Shelter Usage and Overnight Service Usage – daily reporting includes occupancy, vacancy, and capacity data based on a snapshot at 4:00 AM
Australia
- Australian Institute for Health and Welfare – Housing Data – Find the latest data on housing in Australia, from 31 key national datasets. Choose from 74 dashboard tiles and use the interactive displays to dig deeper into the data.
- Brisbane Zero
- Logan Zero
- Melbourne Zero
- South Australian Alliance to End Homelessness – The Adelaide Zero Project Monthly Dashboard and Ending Homelessness Dashboard each track our progress towards achieving and sustaining functional zero street homelessness in the inner city.
- Western Australia Alliance to End Homelessness – This WAAEH Dashboard is an evolving, accessible, and visual platform designed to present and report on outcomes relevant to answering the question: Are we are ‘on track’ to end homelessness in Western Australia?
United States
- National Alliance to End Homelessness (NAEH, USA) – State of Homelessness: State and Continuums of Care dashboards – up to 10 years of data visualized through Tableau
- Charlotte-Mecklenburg – This data snapshot provides information on progress in the work to end and prevent homelessness. Three sections are included that illustrate housing needs and successes. In addition to data, each section provides an overview and detailed explanations to describe what the numbers mean and why it matters.
- Chicago – HMIS data that is updated weekly and includes active client list data, coordinated entry client list data, and timeframe to housing data
- King County Regional Homelessness Authority – using a combination of HMIS and PiT data, a number of dashboards that explore households served (updated monthly), system performance (updated quarterly/annually), overall inflow and outflow data (updated annually), and data examining system equity
- Los Angeles County Homelessness Initiative – Using Tableau, this interactive tool provides a snapshot of how many people have been helped, and how, by Los Angeles County’s homeless services system, starting in July 2017. The dashboard tracks progress across the system over time, and also for specific populations.
- South Central Indiana – using Tableau, a US BFZ Performance Management Tracker light displaying basic By-Name Data.
- St. Louis (Continuum of Care) – includes housing inventory data, PiT data, local performance dashboard, and Coordinated Entry dashboard
By-Name Data is the crown jewel of a strong Coordinated Access system (CA). A CA is a way for communities to design, streamline and bring consistency to the process by which people experiencing homelessness access housing and services. A strong CA uses a housing first approach along with a standardized and coordinated process for access, assessment, prioritization and referral for housing and other services across all the agencies and organizations in a local area.
This short 3 minute OrgCode video explains the difference between a By-Name List, Coordinated Access List and Prioritization List (and how they work together).
Further information and resources to support your work in developing and improving coordinated access and prioritization processes can be found on the Coordinated Access page of this website.
Webinars and Videos
- How to Use By-Name Data – Part 1 – Person-Level – Recording (25 min) and Presentation
- How to Use By-Name Data – Part 2 – System-Level – Recording (21 min) and Presentation
- How Communities are Using By-Name Data To End Homelessness (CAEH webinar, 2021) – Recording and PDF
- Using and Sharing Data to Improve Outcomes For Homeless Veterans (US) (10 min) – Video
Community Reports and Presentations
- Moncton Councillors Offered Hopeful Outlook on Tackling Homelessness (news article, September 2021)
- Wellington-Guelph Fact Sheet to Support Permanent Supportive Housing (June 2020)
- Landlord Engagement Business Case Example Using BNL Data (2021)