US Department of Housing & Urban Development (HUD)

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 Coverage	United States
Entity Level	State, Continuum of Care
Release Frequency	Released annually in December; survey is conducted in January of that year.
History	2007 onwards

As with all Public Domain datasets, Cybersyn aims to release data on Snowflake Marketplace as soon as the underlying source releases new data. We check periodically for changes to the underlying source and, upon detecting a change, propagate the data to Snowflake Marketplace immediately. See our release process for more details.

Description

EAV Model: All Cybersyn products follow the EAV (entity, attributes, value) model with a unified schema. Entities are tangible objects (e.g. geography, company) that Cybersyn provides data on. Index tables contain all entities of a certain type. Timeseries tables contain all timeseries' dates and values that refer to an entity type. Additional tables, such as the relationships table and attributes table, are used to describe the entities and timeseries. Data is joinable across all Cybersyn products that have a GEO_ID. Refer to Cybersyn Concepts for more details

Tables & Sources

Tables	Sources
HOUSING_URBAN_DEVELOPMENT_ATTRIBUTES HOUSING_URBAN_DEVELOPMENT_TIMESERIES	HUD

Cybersyn Products

Tables above are available in the following Cybersyn data products:

• Government Essentials

• Enterprise

Examples & 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 cybersyn.housing_urban_development_timeseries ts
LEFT JOIN cybersyn.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 cybersyn.housing_urban_development_timeseries)
ORDER BY yoy_change DESC;

Disclaimers

The data in this product is sourced from US Department of Housing & Urban Development. Cybersyn is not endorsed by or affiliated with any of these providers. Contact [e-mail] for questions.