Tuesday, March 31, 2009

Table of Data Sources by Year

THE FOLLOWING table specifies the source of government spending and revenue data for each range of years for which usgovernmentspending.com provides government spending data and usgovernmentrevenue.com provides government revenue data.
UPDATED: 2/2/2012
United States Federal, State, and Local Government Spending and Revenue Sources of Spending and Revenue Data
YearFederal Spending and Revenue Intergovernmental Transfer State Spending and Revenue Local Spending and Revenue
2016 thru 2011 budgeted
US Budget Historical Tables FY 2012 (pdf) Table 2.1 (xls) Table 2.4 (xls) Table 2.5 (xls) Table 3.2 (xls) Table 7.1 (xls) Table 10.1 (xls)
guesstimated
by usgovernmentspending.com
2010 actual
US Budget Historical Tables FY 2012 (pdf) Table 2.1 (xls) Table 2.4 (xls) Table 2.5 (xls) Table 3.2 (xls) Table 7.1 (xls) Table 10.1 (xls)
guesstimated
by usgovernmentspending.com
2009 thru 1992 actual
US Budget Historical Tables FY 2012 (pdf) Table 2.1 (xls) Table 2.4 (xls) Table 2.5 (xls) Table 3.2 (xls) Table 7.1 (xls) Table 10.1 (xls)
actual
US Census Bureau State and Local Government Finances:
2008-09 2007-08 2006-07 2005-06 2004-05 2003-04 2002-03 2001-02
etc.
1991 thru 1962 actual
US Budget Historical Tables FY 2012 (pdf) Table 2.1 (xls) Table 2.4 (xls) Table 2.5 (xls) Table 3.2 (xls) Table 7.1 (xls) Table 10.1 (xls)
actual
US Census Bureau Statistical Abstract of the United States
1993, Table: 474
etc.
1961 thru 1950 actual
US Census Bureau Bicentennial Edition: Historical Statistics of the United States, Colonial Times to 1970
1961 thru 1902 actual; and interpolated
US Census Bureau Bicentennial Edition: Historical Statistics of the United States, Colonial Times to 1970
See also: World War II Spending and: World War I Spending
1901 thru 1792 actual
US Census Bureau Bicentennial Edition: Historical Statistics of the United States, Colonial Times to 1970
none

17 comments:

  1. Do you have the data for the states approved budgeted amount for FY2009 and FY2010? Please assist if you can. thanks

    ReplyDelete
  2. No. The state budgets are all different and it would be too hard to align the "guesstimates" with individual state budgets.

    ReplyDelete
  3. This page is called Table of Data SOURCES yet all I find here for sources are spreadsheets compiled by you. A source is the place from where you got the information you used in putting together the spreadsheets.

    ReplyDelete
  4. Do you have data on the breakdown of deficit spending for fiscal year 2011?

    ReplyDelete
    Replies
    1. This liberal would to like to see this breakdown. It's a shame our government does not provide this needed information. This administration just does not know how to support its cause. I to am developing spreadsheets of financial data and it is proving to be hard confusing work. We thank you...

      Delete
  5. I will second what Lidia said. What are the sources of your data? Anyone can throw some numbers on a spreadsheet, but listing where the original data comes from is an essential part of responsible reporting.

    ReplyDelete
  6. Sorry. I don't understand the question about sources. The links go to official government spreadsheets published by the federal government. For the state and local data from 1992 forward the sources are flat-files at the US Census Bureau. Those links are the sources for the numbers in my online database, except for the links to World War I and II spending, which describe how I mash up defense spending from incomplete government data.

    If you go to the Numbers page, which tabulates data for a specific year, you will find in the Notes at the bottom of the table links to the government data source for that data for that year.

    Am I missing something?

    ReplyDelete
  7. I double checked the federal revenue and spending numbers presented in Chris' website against the actual numbers from the CBO website, and can report that Chris is spot-on.
    Chris doesn't make up data. All he does is assemble it into formats that are easier to read and more meaningful.

    ReplyDelete
  8. Thanks, Anonymous. You're a pal!

    --Chris

    ReplyDelete
  9. Excellent resource. Accuracy is doubted by those on the left because it conflicts with their narrative that the debt crisis is exaggerated and that government revenues are dropping due to the Bush tax cuts. It has been suggested to me that the charts are not accurate because this is a conservative site.

    WJL

    ReplyDelete
  10. Dear Chris, I am much benifited by your data. Thank you. However, I have two questions.
    First is about the state & local government amount. In the census data, the sum of state government amount and local government amount is NOT equal to the state & local government amount. This may be due to some statistical reason. But I find you just make the sum of state government amount and local government amount as the amount of state & local government. You can check the data of Total Revenue of Total Direct Rev for Alabama. In census data, the state & local government amount, state government amount and local government amount are 31.834billion, 18.353billion, and 20.312billion respectively. The sum of latter two is 38.665, which is the number you reported as "state & local government".
    Second is about the GDP. You use the GDP data at http://measuringworth.com/. Why do you not use the data in BEA in current dollar value at http://www.bea.gov/national/xls/gdplev.xls?

    ReplyDelete
  11. @anon

    1. It's true; you can't add state to local on the Total Revenue line. that's because Total Revenue includes monies from other governmental levels, so you get double counting. But my top line figure is "Total Direct Revenue" which is Total Revenue less intergovernmental revenue. And that should remove the double counting. You can, if you like, look at "state and local" combined by clicking the appropriate list control.

    2. I use measuringworth.com for GDP because it goes back to the 18th century, and so does the data on federal spending. I want to be able to show spending and revenue as percent of GDP. The BEA numbers only go back to 1929.

    ReplyDelete
  12. Chris: This is an excellent website with lots of interesting information. The burgeoning national debt will soon sink the U.S. unless we get Congress to act now to reduce spending drastically. Several questions: 1) what is a good source for identifying current and historical federal employee compensation and benefits for purposes of comparing by job titles to private industry; 2) What is a good source for analyzing current and historical defense spending. Something that would show the components of defense spending by Fiscal Year. Thanks and keep up the good work.

    ReplyDelete
  13. Chris
    Thanks for a excellent resource for assimulating spending data without talking points. you have helped me to show a learned person how Welfare, health Care, and Federal Pensions out paced defense spending even during the G W Bush admin. Excellent Site

    ReplyDelete
  14. Using statistics out of context is misleading to say the least. If the debt is such a problem the why haven't yields on 10 year bonds gone up? Why when we were downgraded did investors jump from private debt to public debt?

    ReplyDelete
  15. WJL - I am a so-called liberal and it would never occur to me to interpret Chris' excellent resource as an attack on or vindication of one or the other political party or left-right ideological orientation. But since you brought it up, it is Tea Party and like-minded Republicans who have been sounding the alarm on federal spending and deficit levels -- not progressives. I, for one, just want our system to operate as cost-efficiently as possible while meeting the needs of an aging and growing population. I think Chris summarized it best in his analysis: Today’s federal deficit always seems dangerous and unprecedented. In fact, you need a war to really get a big deficit. The peak deficits came during World War I (16% of GDP in 1919) and World War II (24% in 1945), as Chart 4 shows. The deficits of the Great Depression only came to about five percent of GDP, and the big $1.4 trillion deficit for FY 2009 amounted to 13% of GDP." So can we as a Nation finally invest in much-needed infrastructure maintenance and upgrades and finally get people back to work?

    ReplyDelete
  16. When was the "US Federal Debt by Year" last updated, I am using it for a research paper of mine, and I need to know this. Can you reply to, bsly1994@yahoo.com. Thank you for your time.

    ReplyDelete