Easy Step-by-Step Instructions for FPWA’s Federal Funds Tracker’s Open Data Features
We at FPWA believe that democratizing the data we scraped, organized, and analyzed for two years to build the Federal Funds Tracker is a means to build power among advocates – both FPWA members and nonmembers – to protect critical federal funding that supports the City’s social services budget and sector.
Follow the instructions below or watch our training video to learn how to build charts and tables related to the federal grants you care about in just a few clicks of the mouse. And check out this blog post from the Chinese American Planning Council (CPC) which puts into action our open data tools.
These are the three charts we’ll show you how to build:
- A tree map to visualize current year funding (for FPWA member organizations)
- Bar charts to illustrate the impact of federal budget proposals
- Bar charts to visualize inflation-adjusted trends dating back to 2010
Visualize Current Year Funding (for FPWA member organizations)
- Download the Federal Budget Analyzer
- Select your organization from the drop-down menu called ‘Select FPWA Member Organization’.
- View the tree map to the right in the ‘FPWA Member Grants Dashboard’ tab.
- These data rely on an FPWA member’s 2018 audit data. Audit data for federal grants that nonprofit service providers rely on is only available if they rely on more than $750,000 in federal support.
- If your organization is not listed in the drop-down menu, please contact us.
Illustrate the Impact of Federal Budget Proposals
- Download the Federal Budget Analyzer
- For FPWA members, select your organization from the drop-down menu called ‘Select FPWA Member Organization’. Two tables will populate. The ‘Impact Table’ shows the impact to individual grants an FPWA member relies on and the ‘Summary Table’ show the collective impact.
- View corresponding charts in the ‘FPWA Member Grants Dashboard’ tab. The two ‘Impact Charts’ illustrate the impact to individual grants an FPWA member relies on by percent and dollars, and the ‘Summary Charts’ illustrate the collective impact.
- For members and nonmembers alike, illustrate the impact of individual grants in the ‘Individual Grants’ tab by selecting a federal grant from the drop-down menu.
- Currently, the spreadsheets examine the impact of Trump’s FY 2020 budget proposal. Soon, these charts will compare Trump’s budget to the House budget. We’ll update these during each budget cycle. to stay up to date.
- Because audit data run a year behind, our analysis currently examines FY 2020 federal budget proposals on FY 2018 federal awards which may or may not have changed during the one-year lapse in data.
- This analysis assumes the City would distribute federal budget cuts evenly among nonprofit service providers, which isn’t necessarily the case. Rather, the City would make decisions about how to apportion the remainder based on its priorities.
Visualize Inflation-Adjusted Funding Trends
- Download the Inflation Adjuster
- Select your organization from the drop-down menu called ‘Select FPWA Member Organization’. Two tables and a chart will populate. Column C in the ‘Inflation Table’ shows how much the individual grants an FPWA member relies on have increased or decreased since FY 2010 after adjusting for inflation (the chart illustrates this analysis). The ‘Summary Table’ show the collective impact.
- For members and nonmembers alike, illustrate the inflation-adjusted change to individual grants in the ‘Individual Grants’ tab by selecting a grant from the ‘Select Federal Grant’ drop-down menu.
- New York City’s social service grants have declined by more than $300 million since FY 2010 after adjusting for inflation due in large part to the 2011 Budget Control Act (BCA), which set caps on defense and nondefense discretionary funding through 2021 and further reduced funding over time through across-the-board spending cuts known as sequestration. These charts, therefore, add important context to show how many grants have suffered from a decade of historical disinvestment. We adjust for inflation to meaningfully compare dollar amounts over time.
- If your organization relies on Temporary Assistance for Needy Families (TANF), please see the footnote beneath the chart and reach out to FPWA for further clarification.
All Federal Grants – FY 2010 to FY 2018 Trend Data: From the Open Data page on the Tracker, users can download data FPWA scraped from the New York City Comptroller’s Comprehensive Annual Financial Report (CAFR) to view all New York City federal grants – such as transportation, environmental protection, education, health – arranged by category and agency. These data exclude American Recovery and Reinvestment Act (ARRA) spending and Disaster Relief, such as for Hurricane Sandy, to reflect longer-term spending intent. Excluded data is made transparent in this spreadsheet as well.
Current Funding – FY 2019 Adopted Budget: From the Open Data page on the Tracker, users can download data FPWA scraped from the New York City Office of Management and Budget’s Budget Function Analysis report from the FY 2019 Adopted Budget. These data are currently arranged by agency, and currently feature the City’s Administration for Children’s Services (ACS), Department for the Aging DFTA), Department for Youth and Community Development (DYCD), and Department of Social Services (DSS). In 2019, we will data for the Department of Health and Mental Hygiene, Housing Preservation and Development, Small Business Services, and Department of Homeless Services. The disadvantage of the BFA is that expenses are estimates. The advantage is that the BFA provides federal data for an agency’s program areas – a level of detail not included in the Comptroller’s report.
Interactive Charts on Tableau: FPWA’s Tableau page features interactive data visualization for deeper dives into the data and can be embedded into your digital media (see Chinese American Planning Council’s (CPC) blog post for an example). To embed these charts, simply copy and paste the embed code form the share button at the bottom right of any workbook.