This database contains the data reported in the Annual Homeless Assessment Report to Congress (AHAR). It represents a point-In-time count (PIT) of homeless individuals, as well as a housing inventory count (HIC) conducted annually.
The data represent the most comprehensive national-level assessment of homelessness in America, including PIT and HIC estimates of homelessness, as well as estimates of chronically homeless persons, homeless veterans, and homeless children and youth.
These data can be trended over time and correlated with other metrics of housing availability and affordability, in order to better understand the particular type of housing resources that may be needed from a social determinants of health perspective.
HUD captures these data annually through the Continuum of Care (CoC) program. CoC-level reporting data have been crosswalked to county levels for purposes of analysis of this dataset.
You can use the BigQuery Python client library to query tables in this dataset in Kernels. Note that methods available in Kernels are limited to querying data. Tables are at bigquery-public-data.sdoh_hud_pit_homelessness
What has been the change in the number of homeless veterans in the state of New York’s CoC Regions since 2012? Determine how the patterns of homeless veterans have changes across the state of New York
homeless_2018 AS (
SELECT Homeless_Veterans AS Vet18, CoC_Name
FROM bigquery-public-data.sdoh_hud_pit_homelessness.hud_pit_by_coc
WHERE SUBSTR(CoC_Number,0,2) = "NY" AND Count_Year = 2018
),
veterans_change AS ( SELECT homeless_2012.COC_Name, Vet12, Vet18, Vet18 - Vet12 AS VetChange FROM homeless_2018 JOIN homeless_2012 ON homeless_2018.CoC_Name = homeless_2012.CoC_Name )
SELECT * FROM veterans_change
This dataset contains estimates of homelessness, as well as estimates of chronically homeless persons, homeless veterans, and homeless children and youth provided by The U.S. Department of Housing and Urban Development. The estimates cover the period of years 2007-2017 and are at national, state and Continuums of Care (CoC) Point-In-Time (PIT) level.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Note. ICD-9 codes V60.0 (lack of housing), V60.1 (inadequate housing), V60.89 (other specified housing or economic circumstance), V60.9 (unspecified housing or economic circumstances) and clinic stop codes 522 or 530 (Department of Housing and Urban Development VA shared housing program [HUD-VASH]), 528 (telephone/homeless mentally ill [HMI]), 529 (health care for homeless Veterans); 590 (community outreach to homeless Veterans), or inpatient homeless stays (28, homeless compensated mental health residential and rehab treatment program [(MH RRTP CWT/TR, treatment specialty]; 37, domiciliary care for homeless Veterans [DCHV, treatment specialty]).
Not seeing a result you expected?
Learn how you can add new datasets to our index.
This database contains the data reported in the Annual Homeless Assessment Report to Congress (AHAR). It represents a point-In-time count (PIT) of homeless individuals, as well as a housing inventory count (HIC) conducted annually.
The data represent the most comprehensive national-level assessment of homelessness in America, including PIT and HIC estimates of homelessness, as well as estimates of chronically homeless persons, homeless veterans, and homeless children and youth.
These data can be trended over time and correlated with other metrics of housing availability and affordability, in order to better understand the particular type of housing resources that may be needed from a social determinants of health perspective.
HUD captures these data annually through the Continuum of Care (CoC) program. CoC-level reporting data have been crosswalked to county levels for purposes of analysis of this dataset.
You can use the BigQuery Python client library to query tables in this dataset in Kernels. Note that methods available in Kernels are limited to querying data. Tables are at bigquery-public-data.sdoh_hud_pit_homelessness
What has been the change in the number of homeless veterans in the state of New York’s CoC Regions since 2012? Determine how the patterns of homeless veterans have changes across the state of New York
homeless_2018 AS (
SELECT Homeless_Veterans AS Vet18, CoC_Name
FROM bigquery-public-data.sdoh_hud_pit_homelessness.hud_pit_by_coc
WHERE SUBSTR(CoC_Number,0,2) = "NY" AND Count_Year = 2018
),
veterans_change AS ( SELECT homeless_2012.COC_Name, Vet12, Vet18, Vet18 - Vet12 AS VetChange FROM homeless_2018 JOIN homeless_2012 ON homeless_2018.CoC_Name = homeless_2012.CoC_Name )
SELECT * FROM veterans_change