The views of boborojo.

Wednesday, May 2, 2007

FedSpending.org: why does Virginia(8) get the most grants?

Cool site I found recently: FedSpending.org. This is set up by the OMB to provide information in two databases: contracts and grants. At the time of this writing, charts show data from fiscal year 2000 through FY2005, plus partial-year data for FY2006. Let's dive in and see what we find at random.

Federal Contracts Paid
Among Federal contracts awarded by state in FY2005, top piggy Virginia takes 12.7% of Federal contract awards paid in FY2004, 16.1% in FY2005. In those same years California takes 16.5% and 14.4% respectively. Texas ranks third, taking 9.9% and 7.0% respectively. Since the top 10 contractors appar to be industrial and defense manufacturers, the nature of the top awards appears to be for defense/military spending.

It can be further broken down by looking at districts, and it seems the lion's share in the state goes to a particular district:

  • Virginia 8 (James P. Moran) takes 6.33% in FY2004, 9.59% in FY2005.
  • Virginia district 10 () takes 2.92% and 2.87% in thosee same years respectively.
  • California district 8 (Nancy Pelosi) takes 0.76% and 1.63 in those years.
  • Texas district 12 (Kay Granger) takes 2.58% and 1.56% respectively.
Federal Grants Paid
Loads more stuff. Under Grants, you can see "grants to individuals" assistance details. Interesting to see that the "Top 5 Known Congressional Districts where Recipients are Located" lists Florida (district 14), Texas (9), New Jersay (2), Puerto Rico nonvoting, and Louisiana (3). Very bizare, seeing Puerto Rico ranked #4 ahead of, say, any district in California or hurricane-ravaged Louisiana.

However, when you look at the top payouts (to individuals), the states that ranked at the top were:

  • Florida, $315 billion
  • California, $146 billion
  • Texas, $145 billion
  • New York, $85 billion
  • Louisiana $71.5 billion
  • Pennsylvania, 60.7 billion
  • New Jersay, $59.8 billion
  • Illinois, $52.9 billion
  • Ohio, $47.2 billion
  • North Carolina, 47.1 billion
  • Michigan, 42.2 billion

And Puerto Rico was way down on the list with $12 billion.

The top-five 2005 programs over all were:

  • Flood Insurance ($608 billion),
  • Social Security Retirement Insurance ($331 billion),
  • Medicare hospital insurance ($184 billion),
  • Medicare supplementary medical insurance ($151 billion), and
  • Social Security survivors insurance ($101 billion).

In Flood Insurance for 2005, payouts by recipient were

  • $51.4 billion to Florida,
  • $42.2 billion to California,
  • $75.5 billion to Texas,
  • $15 billion to New York,
  • $51.4 billion to Louisiana,
  • $4.8 billion to Missisippi,
  • $3.43 billion to Puerto Rico.

The order of ranking I am presenting above is in order of top payouts of total grants; for each state/protectorate the flood insurance is a varying percentage of total paid to the state.

It is surprising to see a huge number (hundreds or thousands, I stopped the search after a few minutes) of corporations getting grants paid out on the order of $2 million. This is obtained using the "low level of detail" which is the least detailed information, which produces the first 500 out of 175,602 records! Even the first 500 take minutes for the info to come back. You can get the full data set faster if you select "tab-delimited ASCII" report output and save the file.

So now slice it a different way. For 2005, Florida was the top grant recipient with $315 billion, and here are Florida's top 5 programs:

  • Flood Insurance: $237 billion (note this disagrees with the number above. Hmm.)
  • Social Security retirement insurance, $25 billion
  • Medicare supplementary insurance, $14 billion
  • Medicare hospital insurance, $14 billion
  • Social Security survivor's insurance, $6.3 billion.

In FY2005 California received $146 billion grants; the top five programs were:

  • Flood Insurance $42 billion
  • Social Security retirement insurance $31.9 billion
  • Medicare Hospital insurance $20 billion
  • Medicare supplementary insurance $18.7 billion
  • Social Security survivor's insurance: $9.1 billion

In 2005 third-ranked Texas received $145 billion grants; the top five programs were:

  • Flood Insurance $75.5 billion (contrast with Louisiana's $51 billion flood insurance)
  • Social Security retirement insurance $18.8 billion
  • Medicare Hospital insurance $11.6 billion
  • Medicare supplementary insurance $8.3 billion
  • Mortgage insurance homes: $7.8 billion
  • (Hmm, Social Security survivor didn't even make the top 5, and what's this mortgage insurance payout? Do most widows leave Texas for Florida-California ?)

Interesting Grant Category

So, just picking on a random recipient for 2005, I see that BUY-LOW DISCOUNT BEER & WINE (recipient ID 118509) of Texas was a recipient of $1.815 million in FY2005 grant money. Of this, it breaks down to two grant programs:

  • 59.041: Certified Development Company Loans (504 Loans): $1,065,000
  • 59.012: Small Business Loans: $750,000

I think if I was going to start a business, I'd look into how these two programs work!