Archive for Excel

Government Finance Data in Excel and CSV

A little while back I got sick of parsing through BLS datasets looking for jobs data, so I posted jobs data in handy dandy Excel (CSV) format.

I’ve decided to do the same thing with government finance data. This data is actually much easier to find, but getting all the relevent information into the same spreadsheet can be something of a chore. So I’ve went ahead and did it in a “once and for all” sort of way, combining separate data sets into one handy spreadsheet.

Before you go ahead and download this, please know that this information ins free because a) it didn’t cost me anything but also b) I think it is important that everyone is able to look through government finance data. That being said, it does take significant time and effort to grab the data, re-format it properly, and combine it in the most useful way. If you’re using this data in any kind of professional capacity or if you appreciate the work it takes to do this, please consider donating to my efforts.

 Raw Monthly Data 1947 – Present

This data has not been changed in any way. It is a straight translation of the monthly official government data for:

  • GDP
  • Federal Revenue (Receipts), Federal Outlays (Spending), Federal Deficit
  • Public Debt, Intergovernmental Holdings, National Debt
  • Consumer Price Index

If there was no data for a given month, I do not interpolate it. This is exactly what you’ll find if you went to the sources yourself.

If you use these spreadsheets for research or visualization, please mention me and link back here. That’s just the polite thing to do.

GDP, Treasury, Debt, Inflation 1947 – Feb 2012 (CSV)

GDP, Treasury, Debt, Inflation 1947 – Feb 2012 (Excel)

Extended Monthly Data 1947 – Present

This data has been extended in several important ways. In addition to the data in the raw files, it includes:

  • National Debt, interpolated monthly from 1947-1992 (when only yearly data was available)
  • Current Dollar Multiplier (this field times any value equals an inflation adjusted value)
  • Debt as a % of GDP
  • 12 month rolling Revenues, Outlays, and Deficits
  • Revenue, Outlays, and Deficit as a % of GDP
  • GPD, Revenue, Outlays, Deficit, and National Debt adjusted for inflation

The Excel file has the calculations built in so you can check my work.

Again, if you use these spreadsheets for research or visualization, please mention me and link back here.

Extended Government Finance Data 1947 – Feb 2012 (CSV)

Extended Government Finance Data 1947 – Feb 2012 (Excel)

Data Sources

Bureau of Economic Analysis GDP (real dollars)

Treasury Reports (monthly revenue/outlay reports back to 1981)

Inflation (Consumer Price Index) from Bureau of Labor Statistics (US City Average Price Data)

Debt (monthly, 1993 – Present)

Debt (1947 – 1993)