Quiet group today, I think we were all feeling a little subdued about this week's news from down south. Still, we had some good discussion:

• PIT Count - people are using HIFIS Lite but it's really challenging because it's a shared database. So data analysts can't directly access their data via SQL queries, and there are some limitations with the data export feature.

• Multiple meetings - there was some discussion about how there might be too many community meetings out there - community of practice calls, monthly check-ins, etc. I'm sure it's a lot! But those in our call said they liked coming, so 😊!

• Conference - shout outs to the homelessness mortality data seminar, and the "When You Find Yourself Captain of the Javelin Catching Team" one

So long, Ottawa! Here are my highlights for the year:

1. @Geoffrey Messier, as always, had a really accessible presentation about why you shouldn't spend lots of money on a fancy AI model, when humans are awesome, and it's not that hard to do the same thing in an Excel spreadsheet. You can actually watch a recording of his presentation, and he recorded a tutorial about building a spreadsheet that would predict who will become chronically homeless, too.

2. Blue Door, a homeless-serving organization in York Region, started a social enterprise called Construct to provide people experiencing homelessness with job skills and experience in the construction industry. There's a similar organization called Community Builders in Sudbury and Simcoe County. Isn't that beautiful? We're always advocating for more housing, and I think there's something poetic about training homeless people to build houses. Something like "teaching a man to fish..."

3. The newly announced $50M Homelessness Reduction Innovation Fund. More federal funding is always welcome!

4. Food for thought: how many people die from homelessness? According to the coroner's office, people die of cancer, exposure, overdose, organ failure, blood loss, whatever. But homelessness isn't a cause of death on its own. The coroner only investigates sudden and suspicious deaths, and they don't know the housing status of every John Doe that gets brought in. The homeless community might know that someone passed away, but might only know a person by their nickname. And shelters might report deaths that happen in the shelter, but not know about deaths that happen outside of shelters. So nobody has a clear picture of the mortality rates among the homeless population, although Toronto Public Health is trying to build one. If you're interested about this topic, I made a report that examines your deceased clients in HIFIS.

5. @Mike Perry had some great tips about developing a public narrative. People like stories, so give them a story about a person who faced a challenge. People respond better to stories that are authentic, that emotionally resonate. And some of those emotional states drive action. States like anger, urgency, and hope. Great session, but unfortunately, character-based storytelling is kind of the opposite of data, so I don’t think we can agree on everything!

6. The CAEH has done polling and focus groups on what Canadians think about homelessness, which has important insights for how we should communicate with regular people. For example, a statment like “every Canadian deserves a place to call home” will get a better reaction than “homeless people need affordable housing.“

7. Guy Felicella, a harm reduction and recovery advocate who spent 30 years living in Vancouver's downtown east side when he wasn't in jail, made pretty much everyone cry. His message? Don't give up on people. Be there for them. If you're wondering what you missed, you can watch a TED talk he did or another TED talk.

8. Looking to develop a training program? @Katherine Hale in Ottawa has developed over 200 different training programs, on topics like "What is the Residential Tenancies Act" or "Circles of Grief Support: A Guided Approach on How to Comfort Others in their Grief" or "The Sustainable Helper: Strategies for Navigating Compassion Fatigue and Burnout in Frontline Work." She's so excited to share all these resources with other communities and help you build your own training offerings.

9. @Connie Walker is doing amazing work covering the stories of missing and murdered indigenous women and girls. Check out her podcasts: Who Killed Alberta Williams, Finding Cleo, and The Search for Jermain. And Brandon, MB presented about how they're using HIFIS data to reduce the number of MMIW2S, a project I helped with!

10. Finland!

And if you weren't able to attend, here are my presentations for this year:

• You're probably lying about homelessness - yes this is a replay from last year, but the slides have been updated

• Training for front line staff

I noticed when looking through Look-up Tables in my recent version of HIFIS (I'm on 60.4) that there's a whole bunch of new Look-up Table Values that previously did not exist in HIFIS, and when they were added (perhaps in 60?), they did not automatically get subscribed to any service providers. They might be interesting to check out.

There's new values in the following tables:

• Activities (Services) (for example, Hoarding Assistance, Rent Subsidy)

• At Risk Status (for example, Hidden Homelessness, Crisis Sheltered)

• Country (for examle, Aruba, Kiribati, Montenegro)

• Document Types (for example Last Pay Slip, Proof of Identity, Last Notice of Assessment)

• Employer (for example, Public Servant, Customer Service, Agriculture)

• Family Relationship (for example, Son-in-law, Professional Relationship)

• Identification (for example, Provincial Photo [ID], Hospital Card)

• Income (for example, Continued Care and Support for Youth, Other Canada Pension Plan Benefits)

• Language (for example, Bavarian, Nepali, Turkish)

• Life Events (for example, Engaged in Volunteer Work, Experienced Positive Changes in Social Participation)

• People Role (for example, Maintenance Contractor, Caregiver)

• Service Provider Type (for example, Recovery & Reintegration, Food Services)

• Services Offered (for example, Holiday Event, Youth Programs & Services)

Big group today! It was great to welcome some new members like @Alysia Woelbern. Today we talked about:

• Housing Placements, in particular what to do when clients need to be re-housed as a continuation of the same service. Technically you're supposed to start a new Housing Placement, but then there's some confusion about whether that would count as multiple move-ins or not (since HIFIS would count it as a new, distinct service).

• Data wrangling, in which you can arrange your data to be more useful when you're analyzing it. For example, if a client has 3 one-day shelter stays in a row, you could "wrangle" your data to make it look like that was a single 3-day shelter stay. You could do the same for multiple related Housing Placements.

• How many communities grant users secondary rights in order to access case notes belonging to a different service provider? We did a poll and found out that it was 83% (small sample size though).