Tuesday, March 31, 2009
But the data series of Federal Government Expenditure, by Function: 1902 to 1970 in the Census Bureaus Historical Statistics of the United States: From Colonial Times to 1970 only tabulates federal spending every two years: 1940, 1942, 1944, etc.
Fortunately, the Executive Branch budget documents published by the US Government Printing Office at gpoaccess.gov include a set of historical tables, including Table 3.1 — Outlays by Superfunction and Function: 1940–2012. This table includes spending for national defense for each year of World War II. The problem is that the numbers in Table 3.1 dont match up with the Census Bureau numbers in Historical Statistics.
|Comparison of World War II Defense Spending|
(millions of dollars)
|Census Bureau Numbers for National defense and international relations|
|Military services only||1,567||22,633||74,670||42,677||10,642|
|Executive Branch budget numbers in Table 3.1|
You can see the problem. Not only does the Census Bureau not include the odd years, but the numbers dont agree with the Executive Branch budget.
We chose to fill in the missing numbers in the the Census Bureau dataset by making them track the trajectory of the numbers in the Executive Branch dataset. Here are the results:
|Construction of World War II Defense Spending Dataset|
(millions of dollars)
|Census Bureau numbers interpolated with numbers from Executive Branch dataset|
|Total defense & intl||1,590||6,696||26,555||69,884||85,503||92,016||50,461||19,560||16,075|
|Executive Branch budget numbers in Table 3.1|
|Total federal outlays||9,468||13,653||35,137||78,555||91,304||92,712||55,232||34,496||29,764|
We have interpolated values for national defense and for total federal spending in the odd years by translating the shape of the Executive Branch data into the Census Bureau dataset.
But the data series of Series Y 605-637. Federal Government Expenditure, by Function: 1902 to 1970 in the Census Bureaus Historical Statistics of the United States: From Colonial Times to 1970 only tabulates federal spending for 1913 and 1922, completely missing out on the years of World War I.
But the Census Bureau does publish annual federal government expenditures in another table,
|Comparison of World War I Defense Spending|
(millions of dollars)
|Census Bureau Numbers from Series Y 605-637. Federal Government Expenditure, by Function: 1902 to 1970|
|Total national defense||250||875|
|Military services only||245||864|
|Census Bureau Numbers from |
Series Y 466-471. Outlays of the Federal Government, by Major Function: 1900-1939.
|Major national security||293||298||297||305||602||7,110||13,548||3,997||2,581||929|
|International affairs and finance||5||5||5||6||591||4,748||3,500||435||83||10|
|Veterans services and benefits||175||173||176||171||171||235||324||332||646||686|
You can see the problem. The entire war spending effort is missing from the data series that we are using. And in 1913 and 1922 they don't match up.
We chose to fill in the missing numbers by matching the spending numbers from Outlays of the Federal Government, by Major Function: 1900-1939 to the numbers on the incomplete Federal Government Expenditure by Function: 1902-1970. then track the trajectory of the numbers in the Outlays dataset. Here are the results:
|Construction of World War I Defense Spending Dataset|
(millions of dollars)
|Numbers interpolated from Outlay table shown in italic. Updated: 4/15/2015|
|Total defense and intl||250||253||250||258||1,438||11,801||16,989||4,372||2,602||875|
We have interpolated values for national defense and for total federal spending by applying the entire Outlays data items to the Expenditures table by adjusting all numbers so that they match the numbers in the Expenditure table for 1913 and 1922.
Monies transferred to other governments are called intergovernmental transfers. To avoid double-counting at usgovernmentspending.com we show a “Gov. Xfer” column. It represents intergovernmental transfers from the federal government to the states and local governments. For instance, Medicaid (included under Health Care) is a joint federal-state program in which the federal government reimburses state governments for 50 percent or more of their expenses. The federal government's outlay for Medicaid includes monies directly spent by the federal government and monies sent to the states as grants and then spent by the states on Medicaid.
You can see that Health Care has the biggest “Gov. Xfer” number.
The intergovernmental transfer numbers used in the Numbers table are all Census Bureau “B” codes, as described in Census Bureau's Government Finance & Employment Classification Manual. For example, Census Bureau code “B01” is an intergovernmental transfer for “Air Transportation (Airports)”. The numbers are rolled up to provide the totals you can see at the top level. However, we have not used the Census Bureau numbers to report the intergovernmental transfers. Instead we have used OMB's Historical Table 12.3—Total Outlays for Grants to State and Local Governments, by Function, Agency, and Program.
If you drill down two levels (using the [+] controls) you will uncover the specific Census Bureau “B” spending codes used to compute the “rolled-up” intergovernmental transfer numbers. Each code is a link to the Census Bureau page that lists codes.
In summary, usgovernmentspending.com shows federal spending amounts as published by OMB that include monies transferred to other governments, but shows state and local spending as "direct spending" net of transfers to other governments as published by the US Census Bureau. Total spending is calculated as the sum of OMB federal spending plus Census Bureau state and local spending less "intergovernmental transfers" as published by the US Census Bureau.
Of course, intergovernmental transfers affect the revenue side as well as the spending side. You can see intergovernmental transfers on the revenue details page here. Intergovernmental Transfers equal (Total Revenue less Total Direct Revenue) at the state and local level.
IF YOU DRILL down below the federal subfunction level you can see federal spending at the agency code level. This spending information is obtained from Outlays, an Excel spreadsheet (4.5MB) that contains federal spending numbers classified by department, bureau, and agency code for FY 1962 through FY 2008. There are about 4,000 line items at the agency code level. The file can be downloaded from Budget of the United States Government: Public Budget Database Fiscal Year 2008 in xls, csv, or zip format. Only spending line items in excess of $0.05 billion are displayed atusgovernmentspending.com.
See below the table for additional information on sources.
You can access the budgeted federal data prior to FY96 used in usfederalbudget.us here:
- Historical Tables in pdf format for FY1991, FY1992, FY1993, FY1994, FY1995.
- Historical Tables for FY1986-FY1990 from St Louis Fed. FRASER database.
Federal data prior to 1962 is extracted from “Bicentennial Edition: Historical Statistics of the United States, Colonial Times to 1970.” You can download the relevant extracts in a pdf file here or from the Federal Reserve Archive here.
State and local data from 1902 to 1970 is extracted from the US Census Bureau’s “Bicentennial Edition: Historical Statistics of the United States, Colonial Times to 1970.” You can download the relevant extracts in a pdf file here.
State and local data for 1890 is extracted from the US Census Bureau’s “Historical Statistics of the United States, 1789 - 1945.” You can download the relevant extracts in a pdf file here.
State and local data for 1891-1901 is interpolated from the 1902 Census Bureau data and the 1890 Census Bureau data.
State and local data for 1830-1889 is interpolated from decadal estimates in Michael Mann, The Sources of Social Power, Volume 2, page 363.
Monday, March 30, 2009
Most of the data is actual government spending as reported by the Office of Management and Budget or the United States Census Bureau. But there is also interpolated data for the years not covered by the data sources. In addition, we have included budgeted and estimated spending as well. We have used color and italics to tell you the source of each item of spending.
Here is the key:
- Actual reported government spending is shown in blue text
- Interpolated data filling in for missing years in the source records is shown in blue italic text
- Budgeted spending is shown in normal text
- Estimated spending is shown in italic text
- “Guesstimated” spending, i.e. future state and local spending projected by usgovernmentspending.com, is shown in red italic text
Data SourcesThe government spending information is obtained from several sources of data.
Federal spending since 1962 is obtained from a spreadsheet file Table 3.2 - Outlays by Function and Subfunction in Budget of the United States Government published by the Executive Office of the President of the United States. It contains actual historical federal government spending from 1962 to the fiscal year ending before the current budget, and budgeted and estimated spending the current fiscal year and out five years.
Federal revenue since 1962 is obtained from spreadsheet files Table 2.1 - Receipts by Source: 1934–2016,
Table 2.4 - Composition of Social Insurance and Retirement Receipts and of Excise Taxes: 1940–2016, and Table 2.5 - Composition of “Other Receipts”: 1940–2016.
State and local government spending from 1992 is obtained from tables of state and local government spending published annually by the United States Census Bureau. For instance, the data for fiscal year 2004 is available as a zip file: State by Level of Government - Comma Delimited.
State and local government spending from 1962 to 1991 is obtained from tables of state and local government spending in the Statistical Abstract of the United States published by the United States Census Bureau.
Federal, state, and local government spending prior to 1962 is obtained from “Series Y 605-637. Federal Government Expenditure, by Function: 1902 to 1970” and from “Series Y 682-709. State and Local Government Expenditure, by Function: 1902 to 1970.” These are tables included in Bicentennial Edition: Historical Statistics of the United States, Colonial Times to 1970 published by the United States Census Bureau.
This information is given in tabular form in Government Spending Data: Sources by Year.
Guesstimated SpendingThe federal government provides budgetary data for the current year and the next year. It also provides estimated budgetary data for the following four years.
But the Census Bureau data on state and local spending is historical data only. It does not include any information on state and local budgets or on state and local government spending projections.
So at usgovernmentspending.com we have massaged the recent historical data to come up with a “guesstimate” of future state and local spending.
The method used is to take the average change in spending for the last four years of historical data and estimate the percentage change in spending that this represents, limiting the percentage change to plus 20 percent and zero. We then apply that percentage for each year after the last year in the Census Bureau data.
You will notice that this method has its problems. The line “All Other Spending” for states goes negative in the out years, because the rate of increase in individual programs presently exceeds the rate of increase in overall spending. That is what you call a “budget crisis.”