Skip to main content

US Department of Housing & Urban Development (HUD)

Overview​

The US Department of Housing & Urban Development is mandated by the McKinney-Vento Homeless Assistance Act to conduct the Annual Homeless Assessment Report (AHAR). It is conducted by coordinating with local Continuums of Care (CoCs) to perform Point-in-Time (PIT) counts of sheltered and unsheltered homeless persons, typically conducted on a single night in January, along with Housing Inventory Counts (HIC) to collect data on available housing resources.

A Continuum of Care (CoC) is a local or regional planning body that coordinates housing and services funding locally for homeless families and individuals. The Continuum of Care (CoC) program is managed by HUD.

Key Attributes​

Geographic CoverageUnited States
Entity LevelState, Continuum of Care
Release FrequencyReleased annually in December; survey is conducted in January of that year.
History2007 onwards

Snowflake Products​

Tables above are available in the following Snowflake data products:

Sample Queries​

Change in state-level homelessness

Evaluate the annual change in overall homelessness per state.

SELECT
    geo.geo_name,
    ts.variable_name,
    ts.date,
    ts.value,
    ts.unit,
    ROUND((ts.value / LAG(ts.value, 1) OVER (PARTITION BY ts.geo_id, ts.variable_name ORDER BY ts.date) - 1) * 100, 2) AS yoy_change
FROM public_data.housing_urban_development_timeseries ts
LEFT JOIN public_data.geography_index geo
ON ts.geo_id = geo.geo_id
WHERE 
    geo.level = 'State'
    AND variable_name = 'Overall Homeless'
QUALIFY date = (SELECT MAX(date) FROM public_data.housing_urban_development_timeseries)
ORDER BY yoy_change DESC;

Disclaimers​

The data in this product is sourced from US Department of Housing & Urban Development.

Snowflake is not endorsed by or affiliated with any of these providers. Contact https://snowforce.my.site.com/s/consumer-reporting for questions.