FY2020 MMR Spending and Budget

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

Mayor's Management Report (MMR)

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/fy2020-mmr-spending-and-budget-bxv9-8f4e\".\"fy2020_mmr_spending_and_budget\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.