Point in Time Estimates of Homelessness in the US by State
2007 - 2018. Annual Point in Time (PIT) Estimates of Homelessness by State. Data compiled from Annual Homeless Assessment Report (AHAR) findings conducted by HUD. From HUD: "The Annual Homeless Assessment Report (AHAR) is a HUD report to the U.S. Congress that provides nationwide estimates of homelessness, including information about the demographic characteristics of homeless persons, service use patterns, and the capacity to house homeless persons. The report is based on Homeless Management Information Systems (HMIS) data about persons who experience homelessness during a 12-month period, point-in-time counts of people experiencing homelessness on one day in January, and data about the inventory of shelter and housing available in a community." NOTE: To understand measure acronyms and collection methods, please refer to the 2018 Annual Homeless Assessment Report to Congress: https://files.hudexchange.info/resources/documents/2018-AHAR-Part-1.pdf
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 \"michigan-gov/point-in-time-estimates-of-homelessness-in-the-us-tgxm-urpt\".\"point_in_time_estimates_of_homelessness_in_the_us\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.