Skip to content
NYC All Federal Grants, FY2010 to FY2018 CAFR
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
All Federal Grants, CAFR 10-18.xlsx
README.md

README.md

All-Federal-Grants-10to18-CAFR-

Data Scrape Steps

1) Data on federal grant revenues are sourced from NYC's Comprehensive Annual Financial Reports (CAFR), FY 10-18

  • Used Tabula to extract data from "Part II-F – General Fund – Schedule G3 Revenues vs. Budget by Agency"

2) Used OMB's "Revenue Budget & Financial Plan -- Exec\Adpt\Prel" to match RSCs and Agency Codes with Revenue Source Names (RSN) and Agency Names

3) Used OMB's Revenue Financial Plan (RFP) to match RSCs with Catalog of Federal Domestic Assistance numbers (CFDA)

  • Grants where we could not find matching CFDA3s are labeled as "CFDA not found"
  • Most CFDA#s have multiple RSCs, but each RSC has one unique CFDA#
  • Some CFDA#s documented when looked up cannot be found on the U.S. Government's Assistance Listings despite being documented in the RFP
  • What is a CFDA number?

4) Determined the following RSCs are categorized as federal grants

  • #900 – 16163; #50000 - #50008; #57000

5) Master table is found in tab 'CAFR 10-18'

Attribution

Please consider atrributing data citations to FPWA

You can’t perform that action at this time.