Housing and Community Development Program Activities

Summary of all Housing & Community Development (HCD) program activities compiled from individual program tracking excel-based sheets that includes fund utilization and persons served associated by fund year, expenditure dates, activity, agency, type of services, city council priorities that it supports and if program crosses multiple fiscal years. Also included are links to source documentation that are not tied to any visualizations.

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 \"citydata-mesaaz-gov/housing-and-community-development-program-ddti-m4jd\".\"housing_and_community_development_program\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.