Consolidated Federal Funds Reports


Source The U.S. Census Bureau
File Size 76.7MB
Dates Covered 1983-2007
Cost Snapshot

  • Nonmembers $75
  • Members $25
Categories: ,


The Consolidated Federal Funds database shows how much money the federal government has spent. It covers federal expenditures or obligations for the following categories: grants, salaries and wages, procurement contracts, direct payments for individuals, other direct payments, direct loans, guaranteed or insured loans, and insurance. The data can be analyzed by the state, county, congressional district, city, or the federal program involved. CFFR also includes the District of Columbia and U.S. outlying areas. The data is based on the fiscal year that ends September 30.

Record layouts and samples of this database

Schema (cffr2006.pdf) 141.5 KB
Main documentation (readme.txt) 12.5 KB
Record layout (CFFRLAY.XLS) 26.5 KB
Sample data (CFFR06.xls) 29.5 KB

Related Tipsheets

  • Using CAR for Homeland Security on the Local Beat
    Nancy Amons takes reporters through the process of finding a story on local government spending of federal allocated grant money for Homeland Security. Amons did this story in Tennessee and found examples of misspending and not-spending in general.
  • Infastructure CAR
    The authors list and explain sources for infrastructure data, such as the National Bridge Inventory, Consolidated Federal Funds Reports, and the Highway Safety Information System. For each source, the authors describe what sort of data is available and how it can be used for CAR stories. The authors also list additional resources and other tipsheets on the same topic.

Related Stories

  • Homeland security spending leaps to $110 million a year in Pennsylvania
    This story shows how homeland security spending in Pennsylvania increased 100-fold over four years, transferring disaster preparedness from an afterthought of county government to big-budget, high-tech operations.
  • Slow track of progress
    The Fresno Bee looks at dangerous crossings in California, which need improvements. The story depicts fatalities, which could have been avoided, were there gates and lights at the spots. The reporter reveals that railroad crossings in California have been neglected “due to chronic funding shortfalls and bureaucratic inertia.” Some major findings are that Fresno city lacks funding to match grants for improving the hazardous crossings, and that the neighboring city of Selma has missed multiple opportunities to go after state and federal funding. Even though numbers of accidents, injuries and fatalities have dropped sharply since the 1970s, the decline is attributed mostly to industry consolidation and track abandonment, the Bee reports. The article includes a map of a four-county area with locations of accidents recorded on railroad crossings from 1996 to 2000.
  • The Delta Initiatives: a threadbare legacy
    Since 1991 the government has poured more than $200 billion into the impovrished Mississippi River Delta, but programs have “failed to acheive their ambition goals,” Jeff Porter reports. Goals set for reducing teen pregnancy to match the national average, providing accesss to adequate water, sewage disposal, fire protection and economically stabilizing minority and small family farms, were not met. The articles examine successes and faliures in small towns in the Delta.
  • “Millions Pledged to Fight Terrorism Unused” “Cities Grumble About Terror Money.” “Report Questions Terror Spending.”
    “Federal homeland-security grants to first-responders are being spread so thinly that many small cities don’t know how to spend it, while larger cities are going woefully underfunded. Our analysis showed that Des Moines, which is larger than any of Iowa’s 98 outlying counties, got just $250,000 out of the first $28 million provided to the state. Some of the state’s smallest counties – with the fewest critically important resources – are spending thousands of dollars on traffic cones and are getting equipment like ballistic helmets that Des Moines can’t afford.”