Housing Habitability Complaints

This Indicator measures housing habitability complaints as a percent of total housing units by zip code as reported to the Oakland Code Enforcement Division. This Indicator compares zip codes in which more than 60% of the population is non-White to those in which more than 60% of the population is White. The third category of zip codes is those in which the population is racially and ethnically mixed.

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 \"oaklandca-gov/housing-habitability-complaints-xkux-ga3a\".\"housing_habitability_complaints\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.