Embedded Files
Low Unsheltered Homelessness Map (2018)
This visualization highlights U.S. regions where fewer than 2% of people experiencing homelessness are unsheltered. These areas stand out for their strong shelter coverage, effective service coordination, and consistent access to emergency housing options.
Despite having sizable homeless populations, Springfield/Hampden County, MA and Nassau & Suffolk Counties, NY maintain some of the lowest unsheltered rates in the country, signaling well-implemented local policies and community support systems.
By identifying these best-performing regions, the map helps surface potential best-practice models that other communities could learn from when working to reduce unsheltered homelessness.
Big Query Homelessness Project
Description: This project examines homelessness trends in the United States from 2018 using Google Big Query's public dataset. The goal was to understand how homelessness changed over time, identify states with the highest needs, and highlight places that were successful in reducing homelessness, especially among youth and veterans.
Dataset Source:
Big Query Public Dataset: HUD Annual Homeless Assessment Report (AHAR)
Data collected by the U.S. Department of Housing and Urban Development (HUD)
Includes state-level counts for youth, veterans, and total homeless populations
Tools:
Big Query (SQL)
Google Cloud Big Query Console
SQL Functions (JOINS, GROUP BY, ORDER BY, aggregations, temporary tables, calculated fields)
Tableau – Developed geospatial map and bar charts for homelessness insights.
Page updated
Google Sites
Report abuse