Icon for Socrata external plugin
Open repository in Console
Updated 21 days ago
Indexed 20 hours ago

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: and

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/preliminary-mayors-management-report-agency-nvzu-6t9y\".\"preliminary_mayors_management_report_agency\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • preliminary_mayors_management_report_agency
Upstream Metadata