Homelessness Point in Time Count

Each year, homeless coalitions across the country conduct a Point in Time Count (PIT) during the same 24-hour period in January to estimate the number of persons experiencing homelessness living in their region. The PIT count includes those living in emergency shelters, transitional housing programs, and those living unsheltered on the street. The PIT count does not include homeless families and youth who are doubled up with family or friends, or those at imminent risk of becoming homeless. The numbers are a “snapshot” on a single day rather than a definitive count. Despite these limitations, the count helps communities plan for programs and services, identifies gaps in the homeless system, and provides

demographic information about populations who experience homelessness.

This dataset includes key measures that have been counted during each PIT since 2019. This dataset will be updated annually.

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 https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"norfolk-gov/homelessness-point-in-time-count-4crf-zrb8\".\"homelessness_point_in_time_count\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.