The Intrepid Data Nerd

Just in time for Thanksgiving and the collapse of the bipartisan deficit reduction panel, here's a fresh slice of the biggest turkey ever--
the Data Nerd's breakdown of the FY2010 Consolidated Federal Funds Report by Congressional District and Party! 
The IDN crunched over half a million expenditure records to create this summary of federal spending by Congressional district so that you can see with your very own eyeballs who's raiding the Treasury!

The district-level summary ranks all 435 Congressional districts by total FY2010 federal spending per capita.  Some of the highlights (or lowlights) are presented in this nifty "Party On!" poster featuring the 50 biggest budget hogs in Congress:

  • The 50 top-spending districts accounted for 25% of all FY2010 federal spending. 
  • 39 of the 50 top-spending districts are represented by Republicans. 
  • 17 of the 50 top-spending districts are represented by "Tea Party" Republicans in the 62-member House Tea Party caucus. 
  • Florida's 20th, 22nd and 23rd Congressional districts each spent over $65,000 per capita in federal funds!

To provide a different perspective, Nerd combined CFFR and IRS tax data in a state-level analysis of the 2010 federal deficit
These data are also presented in a "You Fix Your Deficit, We'll Fix Ours!" poster

  • The states with the highest federal expenditures per tax dollar are Mississippi ($9.09), South Carolina ($8.49) and Florida ($8.27). 
    The states with the lowest federal expenditures per tax dollar are Minnesota ($1.11), Delaware ($1.31) and Ohio ($1.44).
  • Florida alone accounts for 19.3% of the total federal deficit.  Texas accounts for 8.7%.  California accounts for 7.8%.
    Social Security and Medicare payments to Florida's elderly are only a minor contributor to Florida's status as the #1 deficit monster.
  • The states with the highest per-capita federal spending are Louisiana ($36,602), Florida ($36,461) and North Dakota ($25,911).
    The states with the lowest per-capita spending are Vermont ($10,924), Michigan ($11,045) and Illinois ($11,242).
  • The states with the lowest per-capita federal tax payments are Mississippi ($1,929), West Virginia ($2,212) and New Mexico ($2,538).
    The states with the highest per-capita tax payments are Delaware ($13,844), New Jersey ($11,563) and Minnesota ($10,948).
  • The states with the biggest per-capita federal deficits are Florida ($32,051), Louisiana ($30,283), Hawaii ($21,598) and North Dakota ($20,668).  The states with the smallesst per-capita federal deficits are Minnesota ($1,255), Ohio ($3,496), Illinois ($4,221) and Delaware ($4,234).

In case you want to wallow in the numbers yourself, here is the entire FY2010 Consolidated Federal Funds Report (31MB) including pivot-table summaries by Congressional District and State, and gross federal tax collections and tax refunds by state obtained from Tables 5 and 8 of the 2010 IRS Data Book.


The IDN has created an updated shapefile of 3,143 US counties including population and housing profile data from the 2010 Census. While the Census's 2010 TIGER files include territorial waters and fine detail (making for flabby-looking coastal counties and very large file sizes), this shapefile represents land areas only, and its polygons have been generalized for file compactness.

I tried to create intelligible field names. Here are the field definitions.

I also compiled a series of spreadsheets from recent US Census Bureau data releases, including the Census's USA Counties Data File Downloads website. These tables are readily joined to the GIS counties shapefile via the "FIPS" field. Except where the field names are self-explanatory, each spreadsheet includes two worksheets: a data sheet and a listing of variable definitions.


US Zip Code centroids--Excel file (42,961 records)
Includes ArcGIS spatial join of zip codes to Congressional districts.
GIS shapefile of US zipcode centroids (3MB)
GIS shapefile of US zipcode (Census ZCTA) polygons (65MB)

Federal Taxation and Spending by State, 2006, 2007, 2008 and 2009
These indices are derived from the same data sources as the Tax Foundation's well-known series for 1981-2005.  This analysis also includes gross and per-capita contributions of each state to recent federal deficits.  Note that while the Tax Foundation's ratios of federal receipts to taxes were adjusted to reflect a balanced-budget scenario, the ratios that I have calculated for the years 2006-2009 are not.

Summaries of the FY2009 Consolidated Federal Funds Report
by state, county and Congressional District, and by object code, agency and program (2.7MB). Source CFFR data are available from the Census Bureau's website.

2010 Census: Delaware Population and Housing Units by Census Block.
Excel file including DE State Plane centroids (24,115 records; 3MB).