Preliminary Mayor's Management Report Agency Resources

Includes NYC agency resources from the Preliminary Mayor's Management Report (PMMR), such as expenditures (includes all funds), personnel, revenue and paid overtime. This data is an overview of the financial and workforce resources used by an agency and the planned resources available to the agency in a given reporting fiscal year or future fiscal years.

The PMMR, archived reports, and additional information is available at: https://www1.nyc.gov/site/operations/performance/mmr.page and https://dmmr.nyc.gov/

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/preliminary-mayors-management-report-agency-nvzu-6t9y\".\"preliminary_mayors_management_report_agency\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.