NYCHA Resident Data Book Summary

Contains resident demographic data at a summary level as of January 1, 2019. The Resident Data Book is compiled to serve as an information source for queries involving resident demographic as well as a source of data for internal analysis. Statistics are compiled via HUD mandated annual income reviews involving NYCHA Staff and residents. Data is then aggregated and compiled by development. Each record pertains to a single public housing development.

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 \"cityofnewyork-us/nycha-resident-data-book-summary-5r5y-pvs3\".\"nycha_resident_data_book_summary\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.