Icon for Socrata external plugin
Open repository in Console
Updated 10 months ago
Indexed 3 hours ago

Cambridge Homeless Point-in-Time Count data: 2012-2019

This dataset includes Point-in-Time (PIT) data collected in Cambridge between 2012 and 2017. The PIT count is a count of sheltered and unsheltered homeless persons on a single night in January. The U.S. Department of Housing and Urban Development (HUD) requires that communities receiving funding through the Continuum of Care (CoC) Program conduct an annual count of homeless persons on a single night in the last 10 days of January, and these data contribute to national estimates of homelessness reported in the Annual Homeless Assessment Report to the U.S. Congress. This dataset is comprised of data submitted to, and stored in, HUD’s Homelessness Data Exchange (HDX).

This dataset includes basic counts and demographic information of persons experiencing homelessness on each PIT date from 2012-2017. The dataset contains four rows for each year, including one row for each housing type: Emergency Shelter, Transitional Housing, or Unsheltered. The dataset also includes housing inventory counts of the number of shelter and transitional housing units available on each of the PIT count dates.

Information about persons staying in emergency shelters and transitional housing units is exported from the Homeless Management Information System (HMIS), which is the primary database for recording client-level service records. Information about persons in unsheltered situations is compiled by first conducting an overnight street count of persons observed sleeping outdoors on the PIT night to establish the total number of unsheltered persons. Demographic information for unsheltered persons is then extrapolated by utilizing assessment data collected by street outreach workers during the 7 days following the PIT count.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"cambridgema-gov/cambridge-homeless-pointintime-count-data-20122019-ify2-i22z\".\"cambridge_homeless_pointintime_count_data_20122019\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • cambridge_homeless_pointintime_count_data_20122019
Upstream Metadata