About NYC budget data
We publish New York City's budget as data you can search and check, in two halves. City agency budgets: every City agency's adopted and modified budget, FY2017–FY2027, from NYC Open Data. Council discretionary funding: which organizations the Council funds, for how much, from the Council's own spreadsheets, its budget PDFs, and NYC Open Data. Every number comes from the City's own data, and we never change one by hand.
Which tool answers my question?
| Your question | Where to look |
|---|---|
| How much does my community board get? | Community board budgets, all 59 in one table, with a CSV download. Each of the 59 boards is its own agency (Manhattan 341–352, Bronx 381–392, Brooklyn 471–488, Queens 431–444, Staten Island 491–493). |
| How did an agency's budget change, year to year or during the year? | City agency budgets: Adopted and Modified, by year. |
| Which groups did my Council member fund? Did this nonprofit get Council money? | Council discretionary funding: the expense awards (search by name or EIN). |
| What did the Council change after the budget was adopted? Which capital projects did it fund? | Council discretionary funding: transparency resolutions; capital and the capital book. |
| Was the money actually spent? Did an award become a contract? | Checkbook NYC (the Comptroller). Use its Spending tab for payments and its Contracts tab for contracts. This site has budgets, not spending. |
| Revenue, debt, or spending over decades? | The Independent Budget Office's Data Center. |
The words used here are explained in the glossary below.
Glossary
- Fiscal year (FY)
- New York City's budget year runs July 1 to June 30 and is named for the year it ends. FY2026 is July 1, 2025 to June 30, 2026. Every year on this site is a fiscal year.
- Adopted budget
- The budget the Mayor and Council agree in June, before the fiscal year starts.
- Modified budget
- The adopted budget as changed during the year. In the City agency budgets half, "Modified" is the figure as of June, near the year's end; Checkbook NYC's year-end figure can differ slightly. The newest year's Modified is "Not yet published": the City publishes it in the release that adopts the next year's budget.
- Preliminary, Executive and Adopted releases
- OMB publishes each year's budget up to three times: Preliminary (January), Executive (April or May) and Adopted (June). Each restates the whole budget, so they must never be added together. The City agency budgets half uses only the June release.
- Which year a figure belongs to
- NYC Open Data's Expense Budget labels each June release with the coming fiscal year, but two of the three amounts in it describe the year before. So we take a year's adopted budget from the release labeled with that year, and its modified budget from the next year's release. Until November 9, 2026, the City agency budgets page got this wrong and showed every year one year late.
- Agency
- A City department or office with its own budget, such as the Department of Education. Each community board is its own agency.
- Community board
- One of New York City's 59 community boards. In the City's budget, each board is its own agency, with its own agency number. The numbers come from OMB's budget data on NYC Open Data (the Expense Budget's agency number): Manhattan 341–352, Bronx 381–392, Brooklyn 471–488, Queens 431–444, and Staten Island 491–493. Board n in a borough is the first number plus n−1: Brooklyn Community Board 6 is 476. See every board's budget on the Community boards page.
- Unit of appropriation
- The lines the expense budget is adopted by. An agency has one or more, often split into Personal Services and Other Than Personal Services.
- Personal Services (PS) and Other Than Personal Services (OTPS)
- PS is pay for the agency's staff. OTPS is everything else, such as supplies, contracts, and rent.
- Intra-city
- Money one City agency pays another for services it buys from it. The same dollars appear in both agencies' budgets.
- Net and gross
- OMB's headline "net total budget" leaves intra-city money out, so it is not counted twice. NYC Open Data rows include it, so a total added up from Open Data is gross. FY2026 adopted: $115.9 billion net, $117,791,473,676 gross as counted in Open Data, of which $1,884,163,949 is intra-city.
- Expense and capital budgets
- The expense budget pays for running the City each year: staff, services, supplies. The capital budget pays for things that last: buildings, parks, equipment. The City agency budgets half is the expense budget. The Council half has both.
- Council discretionary funding
- Money in the budget that the Council, not the Mayor, directs to particular organizations and programs. It is a small part of the budget.
- Schedule C
- The list, printed with the adopted budget, of the Council's discretionary awards, with each award's initiative and category.
- Initiative
- In Schedule C, the program a discretionary award is funded under.
- Transparency resolution
- A Council resolution, after the budget is adopted, that adds, removes or changes discretionary awards.
- Expense funding disclosure
- The Council's spreadsheet of discretionary awards, with each grantee's EIN, amount and clearance status. It is a later list than Schedule C, with awards added during the year.
- Clearance status
- The status the disclosure gives each award, such as Cleared or Pending. An early snapshot (FY2009, FY2013) has many awards still Pending, so its Cleared total is not the year's outcome.
- Capital designation
- Capital money the Council directs to a particular project, from the Council's capital lists.
- Capital book (§254 supporting detail)
- The detail behind the capital changes the Council adopts under Section 254 of the City Charter: the Council's capital additions, project by project.
- Budget line
- A line of the City's capital budget. The Council explorer compares the Council's capital money with OMB's, budget line by budget line.
- Terms and Conditions
- The reports the adopted budget requires agencies to make.
- EIN
- An organization's federal tax ID number.
- MOCS ID
- The Mayor's Office of Contract Services' ID for an award, which NYC Open Data adds to matching disclosure rows (FY2009–FY2021).
- OMB
- The Mayor's Office of Management and Budget. It prepares the budget and publishes the agency data in
mwzb-yiwb. - NYC Open Data
- The City's open data portal, data.cityofnewyork.us. Each dataset has a short ID, such as
mwzb-yiwb. - MCP server
- A tool an AI assistant can use. BetaNYC's budget MCP server lets an assistant search the Council data and answer with the source of each row.
Data sources
Every source the site and its data use. Each Council row says which one it came from.
| Source | What it gives | Years |
|---|---|---|
NYC Open Data, Expense Budget mwzb-yiwb, published for OMB | City agency budgets: every agency's adopted and modified budget, by unit of appropriation. The June release of each year. | FY2017–FY2027 |
| OMB's printed Adopted Budget (OMB publications) | A check: the City agency budgets data build stops unless it matches OMB's printed FY2026 Adopted Budget to the dollar. | FY2026 |
| The Council's expense funding disclosure (Council Research & Data) | Each discretionary award: grantee, EIN, amount, clearance status, mailing address. | FY2013–FY2027 |
| The Council's own workbooks, saved by the Internet Archive | The disclosure for the early years, and other files the Council once published on council.nyc.gov. | FY2009, FY2011, FY2012 |
| The Council's capital workbooks | Capital designations. | FY2015–FY2017, FY2026, FY2027 |
NYC Open Data, City Council Capital Budget t474-a92g, published by the Council | Capital designations. | FY2019–FY2025 |
| The Council's budget PDFs (Council budget pages) | Read twice and checked: Schedule C (FY2018–FY2027), transparency resolutions (FY2018–FY2026), the capital book (FY2018–FY2020, FY2022–FY2027) and Terms and Conditions (FY2018, FY2021–FY2027). | FY2018–FY2027 |
| The City's Government Publications Portal (DORIS) | Copies of budget PDFs City agencies filed there, mostly OMB's copies of the Council's capital supporting detail books. | FY2009–FY2027 |
NYC Open Data, Capital Budget 46m8-77gv and Capital Commitment Plan 2cmn-uidm, OMB's | To compare the Council's capital money with OMB's, by budget line. | FY2019–FY2027 |
NYC Open Data, Capital Projects Database (CPDB) – Commitments djxg-kcfi | Whether a Council capital line has a planned commitment now. | FY2026 on |
NYC Open Data, City Council Discretionary Funding 4d7f-74pe | A cross-check of the disclosure, and the MOCS ID. It stopped updating in April 2021. | FY2009–FY2021 |
NYC Open Data, Discretionary Award Tracker ujre-m2tj | A cross-check of the disclosure: each award's latest posting. | FY2019–FY2021 |
NYC Open Data, City Council Members (1999 to Present) uvw5-9znb | Council member IDs and terms. | 1999 on |
| U.S. Census Bureau, 2020 ZCTA-to-County relationship file | To check the ZIP codes in the disclosure's mailing addresses. ZIP codes are flagged, never rewritten. | 2020 |
How current the data is. City agency budgets: NYC Open Data's Expense Budget, through the release of June 30, 2026 (the FY2027 adopted budget); FY2027's modified budget is not yet published. Council discretionary funding: the Council's PDF tables are from the data release pdf-tables-2026-10-24-260d16e, and the Council explorer's own footer gives the date of its data build. The old explorer (legacy.html) is frozen as of October 16, 2026; do not cite it.
More detail on every column: the data dictionary. Known problems in the sources: data anomalies.
How the Council's PDF tables are checked
We read every row of the Council's FY2018–FY2027 budget PDFs twice, once from the PDF's text and once from a picture of the page, and tied the rows to every total the PDFs print. Where the two readings or the totals disagree, a person reviews it. We never change a number. Values are shown exactly as printed.
- 141,456 rows in 36 tables: Schedule C, the transparency resolutions, the capital book and Terms and Conditions.
- Schedule C: 76,216 of 76,272 rows read the same both ways. The other 56 went to a person.
- 515 of 519 printed totals tie exactly. The other 4 are totals the PDF itself gets wrong, and they are flagged, not fixed.
- The review is still going. Every row is labeled "checked, review in progress" until a person has decided every flagged item for its year. No year is finished yet.
Figures as of the pdf-tables-2026-10-24-260d16e data release. FY2017 and earlier are not re-read yet.
The Council's spreadsheets and NYC Open Data
- Discretionary expense designations: the Council's own expense funding disclosure spreadsheets, FY2009 and FY2011 through FY2027, one row per published designation, with clearance status and the grantee's mailing address. FY2010 is not included, because the Council's saved file for that year is missing rows that NYC Open Data has. FY2009 and FY2013 are early snapshots, frozen while many designations were still pending.
- Capital designations: the Council's own capital workbooks and NYC Open Data, FY2015 through FY2017 and FY2019 through FY2027. FY2018 is missing from every source found.
Download the data
- City agency budgets: one CSV, every agency and unit of appropriation, FY2017–FY2027 (what each column means).
- Community boards: one CSV, all 59 boards, FY2017–FY2027, with the source of each figure.
- Council discretionary funding: the CSVs in the repository's data folder, described in the data dictionary; the checked tables from the Council's budget PDFs in the data releases.
- Ask an AI assistant: the budget MCP server (@betanyc/nyc-budget-mcp). Its README covers setup and what each tool answers.
- What changed and why: the changelog.
How we use AI
We use AI tools openly, and people stay accountable for the result. AI agents (Anthropic's Claude) wrote much of the code, directed and reviewed by BetaNYC staff. This follows our AI policy.
The numbers are not made by AI. Agency figures come from NYC Open Data and are added up by a script. Council spreadsheet values are copied cell by cell. The Council's PDF tables are read from each PDF's own text, then checked against a picture of the page with ordinary image processing, not an AI model. Every row keeps its source.
One exception: the FY2009 transparency resolutions are scanned pages with no text, so an AI model read them. That data is not on this site; it stays in the repository for research.