FY2019 PMMR Spending and Budget

NYC agency spending and budget information by units of appropriation from the Preliminary Mayor's Management Report (PMMR).

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-pmmr-spending-and-budget-brga-xeqy\".\"fy2019_pmmr_spending_and_budget\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.