Adjudication Enforcement Fines and Fees Data for the Office of Business and External Services

A dataset of fines and fees levied in Adjudication hearings for cases in Code Enforcement, Alcohol Beverage Outlets (ABO), Historic District and Landmarks Commission (HDLC), Vieux Carré Commission (VCC), Short Term Rentals (STR) and Zoning from January 1st, 2018 to current day.

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 \"nola-gov/adjudication-enforcement-fines-and-fees-data-for-f5zm-xkyr\".\"adjudication_enforcement_fines_and_fees_data_for\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.