Homeless Census 2007 - 2010

Results from the one day point in time census of homeless individuals in San Mateo County from 2007 - 2010. The Census and Survey was designed to meet two related sets of data needs. The first is the requirement of the U.S. Department of Housing and Urban Development (HUD) that communities applying for McKinney-Vento Homelessness Assistance funds (also known as Continuum of Care or “CoC” funds) must conduct a point-in-time count of homeless people a minimum of every two years. These counts are required to take place in the last ten days of January.

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 \"datahub-smcgov/homeless-census-2007-2010-7yim-wx2k\".\"homeless_census_2007_2010\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.