1 / 25

U.S. Census Bureau

Any views expressed related to procedural or explanatory material are those of the author and not necessarily those of the U.S. Census Bureau. U.S. Census Bureau. Demystifying the Consolidated Federal Funds Report Kenneth Beatty New Jersey State Data Center Network Meeting Rutgers University

mildredk
Download Presentation

U.S. Census Bureau

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Any views expressed related to procedural or explanatory material are those of the author and not necessarily those of the U.S. Census Bureau.

  2. U.S. Census Bureau Demystifying the Consolidated Federal Funds Report Kenneth Beatty New Jersey State Data Center Network Meeting Rutgers University New Brunswick, NJ June 2, 2009

  3. Agenda • Overview of programs: FAADS, CFFR, and FAS • Get acquainted with the CFFR and FAADS web pages • CFFR Query System examples

  4. Federal Assistance Award Data System (FAADS) • Project was initiated by Office of Management and budget in 1981. • FAADS is the central collection point for submissions from various Federal agencies. • Data are released on a quarterly basis.

  5. Consolidated Federal Funds Report (CFFR) • Statistics reported on the geographic distribution of Federal expenditures. • Report is released on an annual basis. • Query system and data downloads available online.

  6. Federal Aid to States (FAS) • Actual expenditures reported. • Assistance reported only on State and local governments. • Annual report released with CFFR.

  7. The Flow of Data Department of Homeland Security FAADS Department of Commerce Department of Agriculture CFFR Procurement Contracts Salaries and Wages Retirement and Disability FAS Various Federal Agencies

  8. FAADS/CFFR Assistance Crosswalk

  9. What Happens Between FAADS and CFFR CFFR Example FAADS Example

  10. FAADS Excerpt

  11. CFFR Excerpt

  12. THE CONSOLIDATED FEDERAL FUNDS REPORT (CFFR) ONLINE QUERY SYSTEM HOW TO GET THERE • Start at the website, URL: http://www.census.gov/govs/index.html • In the center of the page, under Business & Industry, select GOVERNMENTS • The following webpage is displayed • Select the Consolidated Federal Funds Report link in the top right of the page.

  13. For the CFFR online query system, select the On-Line Query System (1993-2007) link located above the Years Available menu Note: For all other CFFR files and information, select a year. The user will be directed to the CFFR web page with all available data files, reference materials, and related links for that particular year. The link for the query system will still be available.

  14. USING THE QUERY SYSTEM Once you have selected the online query system, the following page will be displayed. Choose Geography to see a summary of Federal expenditures for a particular state or county area, or for the entire United States. This summary can be narrowed down to a single object category. Choose Agency if you are interested in seeing a display that has been filtered to include only expenditures of a particular Federal agency or sub-agency. You will be prompted to choose a level of geography AND an agency. Choose Program if you are interested in data for a single Federal program. You will choose a level of geography AND a Federal program. The geography choices include one for "multi-state" or "multi-county." Also different from Geography and Agency searches, you are permitted to specify a "multi-year" time span.

  15. After choosing geography and the year of interest, using the various pull down menus, continue to build your custom report. Select: STATE = New Jersey COUNTY = Yes (Choosing “No” would produce state totals) FUNDING TYPES = All Types (Choices include Grants, Direct Payments, Loans, etc) Click Submit……. Geography Example

  16. This screen will appear, prompting you to select a county. Click submit to view the requested output.

  17. Return to the main query system page and choose Agency in the search drop down box. Agency Example

  18. Choose the following options: State = New Jersey County = No Agency = Commerce Department Sub-Agency = No Click submit….

  19. Program Example • Return to the main CFFR Query page. • Select: • Year = 2007 • Search = Program

  20. Continue by Choosing: • State = New Jersey • County = Multi • Programs = 96.002 Social Security Retirement Insurance • Click submit…. Note: With all selections in the program category, output is displayed in Excel.

  21. Questions?

  22. Contact Federal Programs Branch Governments Division U.S. Census Bureau (301) 763-1565 Email: govs.cffr@census.gov

More Related