Open data

Open Data

We believe that democratizing the Tracker’s data and making it easy to analyze is a means by which to build power to protect critical federal funding that supports the City’s social services budget and sector. Watch our training video for a demonstration of the Tracker’s open data features.

The following data will be updated frequently as federal budget proposals are released and city data are updated. Sign up for data updates. 

  1. Federal Budget Analyzer: Analyze and visualize the impact of federal budget proposals
  2. Inflation Adjuster: Contextualize budget proposals to show inflation-adjusted trends since FY 2010
  3. Current Year Funding: Explore federal revenue data for ACS, DSS, DYCD, and DFTA
  4. All Federal Grants: Explore all federal grants to NYC dating back to 2010
  5. FPWA’s Tableau Public Profile: Share charts on social and embed them into digital media

Please contact FPWA’s Fiscal Policy team for technical assistance or personalized training that is tailored to your specific needs.

Methodology

The Federal Funds Tracker relies on a number of data sources, requires certain assumptions, normalizes data to reflect intent, and categorizes grant data for uniformity and analysis.

  • Current Year Data: For FY 2019 figures, we rely on the New York City’s Office of Management and Budget’s Budget Function Analysis (BFA) report from the FY 2019 Adopted Budget. The BFA details the expense budget of certain agencies by major functional areas and are updated for the Preliminary, Executive, and Adopted Budgets. Each year, we will update the Federal Funds Tracker with data from the Preliminary Budget, which reflects the most up to date estimates of the current fiscal year. The disadvantage of the BFA is that expenses are estimates. The advantage is that the BFA provides a level of detail not available elsewhere by detailing federal grants by program area, which is simply a way to categorize an agency’s spending into program areas.
  • Historical Data: For FY 2010 through FY 2018 trend analyses, we rely on data from the New York City Comptroller’s Comprehensive Annual Financial Report (CAFR). These reports are published in October of each year and report on “actual” spending during the previous fiscal year — that is, what the city actually  spent versus the estimated spending in current year budget documents. These data are adjusted for inflation. Each year, we will update the trends in actual spending when the CAFR is released. We use 2010 as a baseline for our analysis because that is the year before the Budget Control Act passed Congress that called for automatic cuts in spending if Congress could not curtail spending on its own.
  • Exclusions: Historical data excludes one-time funding sources from the economic stimulus provided by American Recovery and Reinvestment Act (ARRA) following the Great Recession, and Disaster Relief aid, such as for Hurricane Sandy. ARRA was effective in creating jobs, and keeping families out of poverty keeping families out of poverty in the aftermath of the Great Recession, and Disaster Recovery funds are critical for emergency-preparedness and infrastructure investments, but one-time fiscal boosts do not reflect Congresses longer-term spending intent.
  • Primary Federal Grants and City-Wide Federal Grants: Because city officials have discretion in how grants are allocated among agencies, and do not have the same flexibility in other cases, we categorize agency grants asprimary” grants if they exclusively and consistently supported an agency since FY 2010 (24 percent of the four agencies’ federal grants) or “city-wide” grants if they have consistently but not exclusively supported one or more of the Federal Funds Tracker’s four agencies since FY 2010 (76 percent of the four agencies’ federal grants).