TITLE: Data Tuesday: 45 Years of US Budget Data
SUBTITLE: Very cool!
AUTHOR: Peter Banks
DATE: 2025-07-22
URL: https://peterbanks.org/essays/data-tuesday-45-years-of-us-budget
SOURCE: https://peteribanks.substack.com/p/data-tuesday-45-years-of-us-budget

This week I will be taking a break from dot maps—have no fear, they will return—and instead am looking at data from The Bureau of Fiscal Service, specifically their Monthly Treasury Statement: These reports contain outlays and receipts for the period between late 1980 and June 2025. 

What originally drew me to this data were headlines a couple of weeks ago claiming America had posted a budget surplus for the month of June.

When I went to confirm this (to me, surprising) fact, I discovered this very neat dataset. So here are some graphics that came about from me playing around with the data!

First off, here is the annual deficit.

Here are the receipts and outlays.

As you can see, there was a brief period of time in the late 1990s and early 2000s where America had a surplus. Visually, it appears we mostly lost this surplus due to declining revenue—perhaps from tax cuts, perhaps from the 2000 crash.

Everything so far is in nominal terms which can give a false impression about the true scale of the deficit over time. The correct response to this is to try and “deflate” the numbers to some base year. In order to do this, I used the “Consumer Price Index for All Urban Consumers: All Items in U.S. City Average” from FRED. I’ve adjusted all of the values so they are now in June 2025 terms.

If this is the wrong deflator, I’d love to be corrected, so let me know in the comments and I can update the graphics. 

Everything is much the same, although prior deficits now look comparatively larger. 

It is interesting that in real terms, our government spends ~3.5 times as much money as it did in 1980. Now, I did not live during that period, but it doesn’t seem like we get 3.5× the services. Even just between 2005 and 2025—a period of time I know well—real government spending has almost doubled. I would like to understand why the real spending doesn’t seem to map to ‘real’ services, and I suspect the explanation is we spend an enormous amount on transfer payments to people who are not 27-year-olds.

What had originally interested me in this data was how our budget changed throughout the year. A surplus in June could be very unusual, as some headlines implied, or just something that happens sometimes. So, sticking to the June 2025 dollars, I thought I would graph the monthly deficit for each year. The darker the line, the closer to 2025 it is. Open to suggestions on how to make this graphic better!

As you can see, we tend to have a monthly surplus mostly in April (when taxes are due) and then in June and September. I assume quarterly estimated tax payments are the main driver of this. That means if we were going to have a surplus, having one in June isn’t particularly shocking.

How much of this is the result of DoGE spending cuts, though? For this, I’ll continue to stick to the 2025-adjusted dollars.

Government spending doesn’t seem to be altered at all from the baseline.

Similarly, the deficit continues to look basically normal.

For comparison here are two other interesting periods. 

First, 1995-2000

Second, 2005-2015

For $5/month or $50/year, you'll gain access to all my paywalled articles and earn a permanent spot in my heart.

Alternatively you can support me via buymeacoffee or by shopping on amazon while using my affiliate link
