Neighborhood Council Checking Account Expenditures For Fiscal Year 2017

For expenditures prior to July 1, 2014, please visit this dataset: http://controllerdata.lacity.org/resource/f2ec-m4t9

Beginning in 2014, each Neighborhood Council has been given a checking account as part of a new funding model for NC's. This dataset contains the information about each Neighborhood Council's expenditures from those checking accounts. For more information, see the User Guide here: http://empowerla.org/wp-content/uploads/2012/10/NC-Checking-Account-Core-Guide-7-1-14-1.pdf

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/neighborhood-council-checking-account-expenditures-tbey-u44x\".\"neighborhood_council_checking_account_expenditures\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.