Skip to comments.National Debt Chart
Posted on 09/08/2011 12:30:50 PM PDT by CodeToad
People often ask if there is a chart that shows the national debt for each year and one that shows which political party was President and held the Senate and House for each year. The following chart shows that information. I gathered the data and tried to arrange and format it so as to show without bias the debt spending throughout the life of our country since 1791. I have not added any commentary as to what the data shows, leaving that for you to decide.
I created the data in Microsoft Excel 2010 and then exported the data into images for web page display and individual file formats for downloading of the actual data. The images are hosted on ImageShack.com and the files on Google Docs. So, if the images are not good enough feel free to download the actual Excel spreadsheet or one of the other file formats, such as PDF, from the links below.
I hope this answers the question of who spends the most.
National Debt 1791-2011:
National Debt 1791-2011 by Party:
This chart shows the spending by who controls the President, Senate, and House. This is the primary chart people ask for.
National Debt 1791-2011 by President, Senate, House:
The following documents are hosted on Google Docs. Clicking a link will take you to Google Docs where you may view the file or select to download it. These files were created by me, codetoad, and are provided for public use without copyright restrictions of any kind. Feel free to copy, modify, and even republish them freely.
National Debt Chart in Microsoft Excel 2010 format (also compatible with Excel 2007) : National Debt Excel 2010 (NationalDebt.xlsx)
National Debt Chart in Microsoft Excel 2003 or prior format: National Debt Excel 2003(NationalDebt.xls)
National Debt Chart as a PDF: National Debt PDF(NationalDebt.pdf)
National Debt Chart as a web page that you can view or save as a file: National Debt Web Page (NationalDebt.mht)
Thanks very much. This is eminently bookmarkable.
You find decreasing deficits with a GOP Congress... wars notwithstanding.
I’ll be updating the files and images as people respond with comments and suggestions.
Do you think the Debt in 2009 caused by TARP should be ascribed to Obama, Bush or both?
While spending is authorized perhaps in one year, the year it is spent, I believe, is when it is attributed. So, no, I would leave the numbers as reported as I think the year each President spent the money is when the money is recognized. I could be wrong about that.
I agree. It’s murky.
Bush signed TARP but he didn’t modify it to save GM and Chrysler the way Obama did. I put that spending mostly on Bush but with an asterisk.
Bush signed a continuing resolution lasting until March of ‘09 that did include increases in discretionary spending although Obama signed off on the rest of ‘09 that doubled down on what Bush signed.
I do think the loss of revenue from 2008 to 2009 can be ascribed to Bush as that correlates best with the stock market on December 31st and Obama wasn’t even in office yet.
The stimulus is, of course, all Obama’s doing.
While I have no doubt Bush loves this country, he created this monster for massive spending, and he created the TSA, PATRIOT Act, etc. He over reacted to 9/11 and to the banking issue.
Agree mostly although I will say that no one realizes they are in a bubble when they are in a bubble. We were in a bubble in 1999. The Fed and Bush re-inflated the bubble by 2007. At the time, it looked like a normal economic expansion from 2001. With 20/20 hindsight, we can say it was a bubble.
Of this I am sure, we are now running deficits now that are going to crush our country’s future. Hopefully it will be a slow decline although there is every reason to think it won’t be. We have about two to five years before we become the latest chapter in this book, “This Time is Different” (A 121 page pdf, http://www.nber.org/~wbuiter/cr1.pdf . We don’t have a Germany to pay our bills like Greece does.
The Tech Bubble of 2001 was obvious and known to exist since at least 1996.
The Housing Bubble was obvious by 1997, since the Tech Bubble helped fuel easy money and it was also well known that mortgage lenders simply stopped asking questions and just pushed through paperwork. I was surprised it took so long to pop. I thought for sure it was a goner in 2005.
OTOH, I do use the free ASAP utility for Excel that includes an Excel to HTML routine that really works. Unless you're on a Mac you should give it try and see how it looks in FR's HTML sandbox. The results are pretty much one to one with what you see in Excel and the links (if you have any) are live. That's a big advantage if you need to include links that are built into the spreadsheet. I don't know any other way to do it.
Note that ASAP Utilities is free to use for Home users, Students and Charitable Organizations. You only need to buy it if you are a business.
I use Office 2010. It outputs everything real nice.
>We cannot go back in time and try to conclude why a budget was more or less; we can only say that it was.<
Looking at the war years it explains why businesses love them. Gov’t spends during them like there’s no tomorrow.
Yep. Businesses love war so they politicians to keep us at war circa 1984.
Yep. Businesses love war so they pay politicians to keep us at war, circa 1984.
Here's what I've done... Zeugma's Debt page. I'm working on updating it.
Disclaimer: Opinions posted on Free Republic are those of the individual posters and do not necessarily represent the opinion of Free Republic or its management. All materials posted herein are protected by copyright law and the exemption for fair use of copyrighted works.