National Debt Chart

CodeToad | 8 September 2011 | CodeToad

[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)

[Palter]

BTTT. Great work, thanks.

[CodeToad]

Thought this might be of interest to you.

[CodeToad]

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

[wastedyears]

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

Legends help, fyi.

[CodeToad]

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

[Graewoulf]

Absolutely STUNNING!

Thank you very much!

[pgyanke]

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

[CodeToad]

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

[CodeToad]

Know of any good ping lists that might be interested?

[Polybius]

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.

[Travis McGee]

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

[Travis McGee]

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

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

[outofsalt]

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.

[CodeToad]

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.

[CodeToad]

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.

[bmwcyle]

ping

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

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:

[CodeToad]

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.