← Blog archive

Open Data · May 12, 2016

Granular Budget Data for NYC

Here's some granular data on the NYC operating budget.

First, take a look at this supporting schedules publication for the Fiscal Year 2017 Executive Budget (the executive budget is the mayor's proposed budget for the upcoming fiscal year, it has not been approved and adopted yet):

http://www1.nyc.gov/assets/omb/downloads/pdf/ss4-16.pdf

You'll see that it's about 4000 pages, and drills down to the very lowest level of detail.  There is a strict hierarchy that looks like this:

Agency > Unit of Appropriation > Responsibility Center > Budget Code > Object Class > Object and Dollar Amount

For example:

002 Mayoralty > 020 Office of the Mayor > 0006 Counsel to the Mayor > 0230 Mayor's Judiciary Committee > 01 F/T Salaried > 001 Full Year Positions $202,774

Here's a scraper you can run in node.js (built with help from the great John Krauss) to pull out each granular budget amount along with its parent hierarchy.

https://github.com/chriswhong/budgetscrape

Here's the same data in that 4000 page pdf as CSV:

https://github.com/chriswhong/budgetScrape/blob/master/csv/ss4-16-executive17.csv?raw=true

With the right queries, you can aggregate, slice, and dice the budget however you like.

How much does each agency have allotted for "Data Processing Supplies"?

SELECT sum(amount::int), agencyname FROM executive17 WHERE oName ILIKE '%DATA PROCESSING SUPPLIES%' GROUP BY agencyname ORDER BY sum DESC

sumagencyname
$29,928,295DEPARTMENT OF EDUCATION
$7,211,227DEPARTMENT OF SANITATION
$6,290,343DEPARTMENT OF HEALTH AND MENTAL HYGIENE
$4,897,592POLICE DEPARTMENT
$3,112,730DEPARTMENT OF BUILDINGS
$2,096,665DEPARTMENT OF ENVIRONMENTAL PROTECT.
$1,629,200DEPARTMENT OF SOCIAL SERVICES
$1,433,486HOUSING PRESERVATION AND DEVELOPMENT
$1,261,945DEPARTMENT OF INFO TECH & TELECOMM
$1,216,986DEPARTMENT OF TRANSPORTATION
$848,230DEPARTMENT OF HOMELESS SERVICES
$690,636CITY UNIVERSITY OF NEW YORK
$667,400FIRE DEPARTMENT
$529,679DEPARTMENT OF FINANCE
$426,000BOARD OF ELECTIONS
$381,572OFFICE OF ADMIN TRIALS & HEARINGS
$337,799ADMIN FOR CHILDREN'S SERVICES
$300,000CAMPAIGN FINANCE BOARD
$296,336DEPARTMENT OF PROBATION
$286,196DEPARTMENT OF SMALL BUSINESS SERVICES
$260,000CITY COUNCIL
$208,579DEPARTMENT OF PARKS AND RECREATION
$185,046OFFICE OF THE COMPTROLLER
$146,616LAW DEPARTMENT
$144,102DEPARTMENT FOR THE AGING
$140,000DEPARTMENT OF DESIGN & CONSTRUCTION
$138,000DISTRICT ATTORNEY QUEENS COUNTY
$90,155MAYORALTY
$71,896INDEPENDENT BUDGET OFFICE
$64,087DEPARTMENT OF CITYWIDE ADMIN SERVICE
$63,616FINANCIAL INFORMATION SERVICE AGENCY
$58,000DEPARTMENT OF EMERGENCY MANAGEMENT
$40,930DEPARTMENT OF INVESTIGATION
$36,814DEPARTMENT OF CITY PLANNING
$30,000OFFICE OF THE ACTUARY
$28,000BOROUGH PRESIDENT STATEN ISLAND
$27,000DISTRICT ATTORNEY KINGS COUNTY
$22,700DISTRICT ATTORNEY NEW YORK COUNTY
$22,500OFFICE OF PAYROLL ADMINISTRATION
$20,000CIVILIAN COMPLAINT REVIEW BOARD
$18,200DEPARTMENT OF YOUTH & COMMUNITY DEV
$18,000BOROUGH PRESIDENT - QUEENS
$12,050COMMISSION ON HUMAN RIGHTS
$12,000OFFICE OF PROSECUTION SPEC NARCO
$10,000BOROUGH PRESIDENT BRONX
$9,168LANDMARKS PRESERVATION COMM.
$6,000BOROUGH PRESIDENT - BROOKLYN
$6,000OFFICE OF ADMINISTRATIVE TAX APPEALS
$4,662NYC TAXI AND LIMOUSINE COMM
$4,591OFFICE OF COLLECTIVE BARGAINING
$4,020DEPARTMENT OF RECORDS & INFORMATION SVS
$4,000CIVIL SERVICE COMMISSION
$3,625CITY CLERK
$3,200QUEENS COMMUNITY BOARD #4
$3,000BRONX COMMUNITY BOARD #1
$3,000BROOKLYN COMMUNITY BOARD #3
$2,500BRONX COMMUNITY BOARD #12
$2,000BROOKLYN COMMUNITY BOARD #9
$2,000BUSINESS INTEGRITY COMMISSION
$2,000CONFLICTS OF INTEREST BOARD
$1,600QUEENS COMMUNITY BOARD #10
$1,500QUEENS COMMUNITY BOARD #1
$1,000BROOKLYN COMMUNITY BOARD #8
$1,000BROOKLYN COMMUNITY BOARD #11
$1,000BROOKLYN COMMUNITY BOARD #16
$691MANHATTAN COMMUNITY BOARD #11
$500QUEENS COMMUNITY BOARD #11
$463BROOKLYN COMMUNITY BOARD #5
$450STATEN ISLAND COMMUNITY BOARD #1
$400BROOKLYN COMMUNITY BOARD #2
$340QUEENS COMMUNITY BOARD #5
$300BRONX COMMUNITY BOARD #3
$259BROOKLYN COMMUNITY BOARD #1
$250QUEENS COMMUNITY BOARD #2
$200BROOKLYN COMMUNITY BOARD #18
$199BROOKLYN COMMUNITY BOARD #4
$100EQUAL EMPLOYMENT PRACTICES COMMISSION

Happy querying!

This post was migrated from my old WordPress blog. Embedded maps and links to third-party sites may no longer work.