Affordable Housing Monitoring Data

Housing and Community Investment Department's (HCID) monitoring data from 2014. HCID’s inventory does not include all of the affordable units administered by the Housing Authority of the City of Los Angeles (HACLA) - HACLA’s portfolio includes 79,379 units, which consist of Public Housing Units, Housing Choice Vouchers, Project Based Section 8 properties and other housing assistance program units. Source: HACLA’s 2016 Final Agency Plan.

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 \"controllerdata-lacity/affordable-housing-monitoring-data-5gc4-smjq\".\"affordable_housing_monitoring_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.