OHSH Dashboard Data

This dataset contains sum values of the total clients or households engaged in each area of the Office of Homelessness and Supportive Housing: outreach, intake, housing navigation, and post-housing service coordination.

**Note: The OHSH Intake team is currently transitioning to Downtown Street Outreach. Therefore, data collection of referrals received and waitlist exits ended June 30, 2024. This change is due to the ending of federal pandemic rental assistance programs. Contact homelessinfo@chattanooga.gov with questions.

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 \"internal-chattadata/ohsh-dashboard-data-8fai-rkxz\".\"ohsh_dashboard_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.