|
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.
-
2010 Census: Population and Housing Profiles
of US counties. SF1 5/26/11 release
(Note: these data are already included
in the counties shapefile attribute table.)
-
County-level housing data from the 2009
5-year American Community Survey
-
Decennial Census population counts of US
Counties,
1900-1990 (Source:
US Census Population Division)
-
2010 Poverty, by County (SAIPE 11/29/11 release)
-
US counties:
Vital Statistics--Births, Deaths and Infant Deaths
-
US counties: Populations
(1980, 1990, 2000
and 2010) and Age Distributions (2000 through 2010).
-
US counties:
Populations, various years
-
US counties:
Incomes, 1979, 1989 and 1999
-
US counties:
Poverty, 1995-2009
-
US counties:
Social Security and SSI, 1990-2010
-
US counties:
Civilian Employment, 1981-2008
-
US counties:
Education, 1986-2009
-
US counties:
Crime, 1981-2008
-
US counties:
Federal Spending, 1983-2009
-
US counties:
IRS income tax data 2004-08
-
US counties:
Agriculture, 1992, 1997, 2002 and 2007
-
US counties:
Water Uses
-
US counties:
Voting in Presidential Elections, 1980-2008
-
US counties:
Health Insurance and Physicians
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).
|