FY2019 MMR Spending and Budget

NYC agency spending and budget information by units of appropriation from the

Mayor's Management Report (MMR). For information related to the ‘Applicable MMR Goals’ column, refer to <a href="https://data.cityofnewyork.us/City-Government/FY19-MMR-Goals-and-Services/qe6k-pu9t">FY19 MMR Goals and Services</a>.

Use ‘CSV for Excel’ when downloading this dataset and then sort in alphabetical order by Agency.

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/fy2019-mmr-spending-and-budget-sa5w-dn2t\".\"fy2019_mmr_spending_and_budget\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.