Free Republic
Browse · Search
General/Chat
Topics · Post Article

Skip to comments.

National Debt Chart
CodeToad | 8 September 2011 | CodeToad

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)


TOPICS: Miscellaneous
KEYWORDS: nationaldebt

1 posted on 09/08/2011 12:30:51 PM PDT by CodeToad
[ Post Reply | Private Reply | View Replies]

To: CodeToad

BTTT. Great work, thanks.


2 posted on 09/08/2011 12:37:18 PM PDT by Palter (Even liberals need jobs.)
[ Post Reply | Private Reply | To 1 | View Replies]

To: SeekAndFind

Thought this might be of interest to you.


3 posted on 09/08/2011 12:39:14 PM PDT by CodeToad (Islam needs to be banned in the US and treated as a criminal enterprise.)
[ Post Reply | Private Reply | To 1 | View Replies]

To: Palter

Thanks. It took a number of hours but it was worth it.


4 posted on 09/08/2011 12:39:54 PM PDT by CodeToad (Islam needs to be banned in the US and treated as a criminal enterprise.)
[ Post Reply | Private Reply | To 2 | View Replies]

To: CodeToad

I’m still trying to figure out what everything is.

Legends help, fyi.


5 posted on 09/08/2011 12:45:18 PM PDT by wastedyears (Of course you realize, this means war.)
[ Post Reply | Private Reply | To 1 | View Replies]

To: wastedyears

Green = Debt went down, also shown by values in ().
Red = Debt went up.


6 posted on 09/08/2011 12:47:21 PM PDT by CodeToad (Islam needs to be banned in the US and treated as a criminal enterprise.)
[ Post Reply | Private Reply | To 5 | View Replies]

To: CodeToad; Sudetenland; Scotswife; DrDan4Congress; KansasGirl; HiTech RedNeck; Notary Sojac

Absolutely STUNNING!

Thank you very much!


7 posted on 09/08/2011 12:47:41 PM PDT by Graewoulf ( obamatrauma"care" violates the 1890 Sherman Anti-Trust Law.)
[ Post Reply | Private Reply | To 1 | View Replies]

To: CodeToad
Wow! That's a lot of work. Here's a graph of my own work on a shorter time frame...


8 posted on 09/08/2011 12:49:02 PM PDT by pgyanke (Republicans get in trouble when not living up to their principles. Democrats... when they do.)
[ Post Reply | Private Reply | To 1 | View Replies]

To: pgyanke

Very cool. What is interesting is that our least spending has been with a Democrat President and a Republican controlled Senate and House.


9 posted on 09/08/2011 12:53:21 PM PDT by CodeToad (Islam needs to be banned in the US and treated as a criminal enterprise.)
[ Post Reply | Private Reply | To 8 | View Replies]

To: Travis McGee

Know of any good ping lists that might be interested?


10 posted on 09/08/2011 12:54:52 PM PDT by CodeToad (Islam needs to be banned in the US and treated as a criminal enterprise.)
[ Post Reply | Private Reply | To 1 | View Replies]

To: CodeToad
It took a number of hours but it was worth it.

The problem, however, is that a sea of numbers glazes over the eyes.

A visual solution is a chart in the style of Minard's famous map of Napoleon's march to Moscow. The width of the line denotes the number of troops still alive in Napoleon's Grand Army. The shocking information is conveyed at a glance. (Below)

In the case of a debt chart, for historical accuracy, debt numbers should be in inflation-adjusted, per capita debt dollars.


11 posted on 09/08/2011 12:58:24 PM PDT by Polybius (Defeating Obama is Priority Number One)
[ Post Reply | Private Reply | To 4 | View Replies]

To: CodeToad

Ah cain’t figyer it owt. Is there an abridged version for dummies?


12 posted on 09/08/2011 12:59:20 PM PDT by Travis McGee (www.EnemiesForeignAndDomestic.com)
[ Post Reply | Private Reply | To 10 | View Replies]

To: Polybius

That’s an awesome “tableau graphique,” especially for the era!


13 posted on 09/08/2011 1:01:44 PM PDT by Travis McGee (www.EnemiesForeignAndDomestic.com)
[ Post Reply | Private Reply | To 11 | View Replies]

To: Polybius

Per capita and inflation adjusted numbers don’t tell the whole and accurate story. The percentages, however, do. People really don’t care what the actual numbers are, just how much the changes have been. Besides, no one has accurate inflationary figures to adjust dollar figures by. So, if $1 was spent in 1791 what, excatly, would that number be for 2011? No one really knows.

I find it best to leave all numbers as they were originally reported and let the reader determine what the numbers mean to them. One thing our government does is play loose with number using “seasonally adjusted” or “adjusted for inflation” or “per capita” numbers. They are meaningless as they have no concrete basis, so people do not trust them. Real numbers as reported tend to have more meaning.


14 posted on 09/08/2011 1:03:35 PM PDT by CodeToad (Islam needs to be banned in the US and treated as a criminal enterprise.)
[ Post Reply | Private Reply | To 11 | View Replies]

To: CodeToad
Thank you! I have wanted this sort of material for a long time.
You should publish this along with a narrative format to tie it all together. Some thing which lists each president and who controlled each house during their tenure and the yearly changes. Something like, “Bill Clinton's first two years were dominated by democrats in both chambers and it wasn't till the Republican revolution that the budgets were balanced.” Or, “Ronald Reagan's terms were hampered by democrat...”
I would pay for such an article maybe someone else would too.
15 posted on 09/08/2011 1:06:11 PM PDT by outofsalt ("If History teaches us anything it's that history rarely teaches us anything")
[ Post Reply | Private Reply | To 1 | View Replies]

To: Travis McGee

The left side of the chart shows individual years and the national debt plus the percentage change from the year before.

The President, Senate, and House columns show the debt during the continuous period held by that political party.

The Period column shows the debt for the period of the specific combination of President, Senate, and House party. A Period is a period of time during which the controlling party of the President, Senate and House does not change.

The Event column is simply to show major events during that period of time that might sugggest why spending was higher than normal.


16 posted on 09/08/2011 1:12:22 PM PDT by CodeToad (Islam needs to be banned in the US and treated as a criminal enterprise.)
[ Post Reply | Private Reply | To 12 | View Replies]

To: outofsalt

Unfortunately, I do not know the narratives as to why spending increased or decreased. There is little to go on other than news reports that are themselves biased and inaccurate.

I am letting the numbers speak for themselves. We cannot go back in time and try to conclude why a budget was more or less; we can only say that it was. Attempting to rationalize spending is extremely difficult and horribly inaccurate. What political pressures were exerted is unknown, as everything from personal political views to political lobbyists play heavy in all political actions, and those activities are simply unknown.


17 posted on 09/08/2011 1:19:55 PM PDT by CodeToad (Islam needs to be banned in the US and treated as a criminal enterprise.)
[ Post Reply | Private Reply | To 15 | View Replies]

To: Apple Blossom; theKid51

ping


18 posted on 09/08/2011 1:25:38 PM PDT by bmwcyle (Obama is a Communist, a Muslim, and an illegal alien)
[ Post Reply | Private Reply | To 1 | View Replies]

To: CodeToad
Per capita and inflation adjusted numbers don’t tell the whole and accurate story. The percentages, however, do. People really don’t care what the actual numbers are, just how much the changes have been.

I respectfully disagree because just going for the shock value of "Look how much the debt has grown since the 1700's" will bring the counter-argument one second later of, "Of course it has grown by a huge percent. The population has grown by a huge percent.".

It costs far less money to run a country of 4 million (the U.S. in 1790) than it costs to run a country of 308 million (the U.S. in 2010).

When a population has tremendous growth over time, even if the per capita debt is kept constant with impeccable financial conservatism, the total debt chart would be a mirror image of the population growth chart:


19 posted on 09/08/2011 1:37:25 PM PDT by Polybius (Defeating Obama is Priority Number One)
[ Post Reply | Private Reply | To 14 | View Replies]

To: Polybius

A “Per Capita” comparison attempts to rationalize debt. There are baseline numbers such as defense. How much defense today in 2011 does it take to defend this nation from known enemies? That number would be the same regardless if we had 100 million or 200 million citizens.

The purpose of the chart is to show the increase each political party has caused during their period of control. Comparing actual dollars from one year to the next is fine enough as few periods exceeded but a few years. The chart also shows percentage increases which helps define the differences.

A full analysis would be needed to determine fault, to include categories of expenditures, political pressures, agreements made, etc, when all people want to know is when a Republican or a Democrat holds the presidency, Senate or House what happens to spending. Does it go up a lot, a little, or down any? What about the relationship between the President and Congress? What about the Senate versus the House? This chart gives meaning to those questions by providing the data for the answers.


20 posted on 09/08/2011 1:45:40 PM PDT by CodeToad (Islam needs to be banned in the US and treated as a criminal enterprise.)
[ Post Reply | Private Reply | To 19 | View Replies]

To: CodeToad

Thanks very much. This is eminently bookmarkable.


21 posted on 09/08/2011 1:50:46 PM PDT by SeekAndFind (u)
[ Post Reply | Private Reply | To 3 | View Replies]

To: CodeToad

You find decreasing deficits with a GOP Congress... wars notwithstanding.


22 posted on 09/08/2011 2:01:00 PM PDT by pgyanke (Republicans get in trouble when not living up to their principles. Democrats... when they do.)
[ Post Reply | Private Reply | To 9 | View Replies]

To: CodeToad

Ping.


23 posted on 09/08/2011 2:38:34 PM PDT by PubliusMM (RKBA; a matter of fact, not opinion. 01-20-2013: Change we can look forward to.)
[ Post Reply | Private Reply | To 1 | View Replies]

To: PubliusMM

Pong.


24 posted on 09/08/2011 6:00:56 PM PDT by CodeToad (Islam needs to be banned in the US and treated as a criminal enterprise.)
[ Post Reply | Private Reply | To 23 | View Replies]

To: SeekAndFind

I’ll be updating the files and images as people respond with comments and suggestions.


25 posted on 09/08/2011 6:02:14 PM PDT by CodeToad (Islam needs to be banned in the US and treated as a criminal enterprise.)
[ Post Reply | Private Reply | To 21 | View Replies]

To: CodeToad

bttt


26 posted on 09/09/2011 8:33:22 AM PDT by Luigi Vasellini (End the political class.......TERM LIMITS NOW!!!!!!!!!!)
[ Post Reply | Private Reply | To 1 | View Replies]

To: Polybius
I used page 90 of Visual Explanations as a general format for this chart:Image and video hosting by TinyPic

FR thread on this chart.

27 posted on 09/13/2011 6:17:58 PM PDT by MontaniSemperLiberi (Moutaineers are Always Free)
[ Post Reply | Private Reply | To 11 | View Replies]

To: CodeToad

Do you think the Debt in 2009 caused by TARP should be ascribed to Obama, Bush or both?


28 posted on 09/13/2011 6:30:49 PM PDT by MontaniSemperLiberi (Moutaineers are Always Free)
[ Post Reply | Private Reply | To 1 | View Replies]

To: MontaniSemperLiberi

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.


29 posted on 09/13/2011 7:32:04 PM PDT by CodeToad (Islam needs to be banned in the US and treated as a criminal enterprise.)
[ Post Reply | Private Reply | To 28 | View Replies]

To: CodeToad

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.


30 posted on 09/13/2011 8:05:25 PM PDT by MontaniSemperLiberi (Moutaineers are Always Free)
[ Post Reply | Private Reply | To 29 | View Replies]

To: MontaniSemperLiberi

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.


31 posted on 09/14/2011 7:37:47 AM PDT by CodeToad (Islam needs to be banned in the US and treated as a criminal enterprise.)
[ Post Reply | Private Reply | To 30 | View Replies]

To: CodeToad

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.


32 posted on 09/14/2011 3:43:40 PM PDT by MontaniSemperLiberi (Moutaineers are Always Free)
[ Post Reply | Private Reply | To 31 | View Replies]

To: MontaniSemperLiberi

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.


33 posted on 09/14/2011 3:51:53 PM PDT by CodeToad (Islam needs to be banned in the US and treated as a criminal enterprise.)
[ Post Reply | Private Reply | To 32 | View Replies]

To: CodeToad
Very nice charts in terms of content. Also very impressive that you could get an image out of Excel that is this sharp. I've never been able to do that.

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.

Here is the ASAP link.

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.

34 posted on 10/31/2011 8:30:55 AM PDT by InterceptPoint
[ Post Reply | Private Reply | To 1 | View Replies]

To: CodeToad

ping


35 posted on 10/31/2011 8:32:28 AM PDT by CanadianYankee
[ Post Reply | Private Reply | To 1 | View Replies]

To: InterceptPoint

I use Office 2010. It outputs everything real nice.


36 posted on 10/31/2011 8:32:39 AM PDT by CodeToad (Islam needs to be banned in the US and treated as a criminal enterprise.)
[ Post Reply | Private Reply | To 34 | View Replies]

To: CodeToad

>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.


37 posted on 03/26/2012 1:45:26 PM PDT by B4Ranch (There's Two Choices... Stand Up and Be Counted ... Or Line Up and Be Numbered ...)
[ Post Reply | Private Reply | To 17 | View Replies]

To: B4Ranch

Yep. Businesses love war so they politicians to keep us at war circa 1984.


38 posted on 03/26/2012 2:12:59 PM PDT by CodeToad (I'm so right-wing if I lifted my left leg I'd go into a spin.)
[ Post Reply | Private Reply | To 37 | View Replies]

To: B4Ranch

Yep. Businesses love war so they pay politicians to keep us at war, circa 1984.


39 posted on 03/26/2012 2:13:15 PM PDT by CodeToad (I'm so right-wing if I lifted my left leg I'd go into a spin.)
[ Post Reply | Private Reply | To 37 | View Replies]

To: CodeToad
Dude, Your data is much better than mine. I'll see if I can pull your spreadsheet into OpenOffice.

Here's what I've done... Zeugma's Debt page. I'm working on updating it.

40 posted on 07/29/2012 12:24:16 AM PDT by zeugma (Those of us who work for a living are outnumbered by those who vote for a living.)
[ Post Reply | Private Reply | To 1 | View Replies]

To: zeugma

Feel free to copy my data, images, etc. It took some time to get all that together as it isn’t in once single place to be found. Some of my links are the raw Excel data so that should help.


41 posted on 07/29/2012 5:57:32 AM PDT by CodeToad (History says our end is near.)
[ Post Reply | Private Reply | To 40 | View Replies]

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.

Free Republic
Browse · Search
General/Chat
Topics · Post Article

FreeRepublic, LLC, PO BOX 9771, FRESNO, CA 93794
FreeRepublic.com is powered by software copyright 2000-2008 John Robinson