US Federal Budget

This is my work to make the US federal budget more machine readable, in hopes of building more meaningful tools on top of it. You can access the historical budget via spreadsheets, but I am looking to make the information easier to integrate with, as an Adopta project.

Data Files

This is a list of JSON and CSV conversions of the Excel files made avalable as part of the Office of Management and Budget Historical Tables, providing data on budget receipts, outlays, surpluses or deficits, Federal debt, and Federal employment over an extended time period, generally from 1940 or earlier to 2016 or 2020.

Table 1.1 - Summary of Receipts, Outlays, and Surpluses or Deficits
Table 1.2 - Summary of Receipts, Outlays as Percentages of GDP
Table 1.3 - Summary of Receipts, Outlays in Current Dollars and as Percentages of GDP
Table 1.4 - Receipts, Outlays, and Surpluses or Deficits by Fund Group 1934–2020
Table 2.1 - Receipts by Source 1934–202
Table 2.2 - Percentage Composition of Receipts by Source 1934–2020
Table 2.3 - Receipts by Source as Percentages of GDP 1934–2020
Table 2.4 - Composition of Social Insurance, Retirement Receipts and of Excise Taxes
Table 2.5 - Composition of Other Receipts 1940–2020
Table 3.1 - Outlays by Superfunction and Function 1940–2020
Table 3.2 - Outlays by Function and Subfunction 1962–2020
Table 4.1 - Outlays by Agency 1962–2020
Table 4.2 - Percentage Distribution of Outlays by Agency 1962–2020
Table 5.1 - Budget Authority by Function and Subfunction 1976–2020
Table 5.2 - Budget Authority by Agency 1976–2020
Table 5.3 - Percentage Distribution of Budget Authority by Agency 1976–2020
Table 5.4 - Discretionary Budget Authority by Agency 1976–2020
Table 5.5 - Percentage Distribution of Discretionary Budget Authority by Agency
Table 5.6 - Budget Authority for Discretionary Programs 1976–2020
Table 6.1 - Composition of Outlays 1940–2020
Table 7.1 - Federal Debt at the End of Year 1940–2020
Table 7.2 - Debt Subject to Statutory Limit 1940–2020
Table 7.3 - Statutory Limits on Federal Debt 1940 to Current
Table 8.1 - Outlays by Budget Enforcement Act Category 1962–2020
Table 8.2 - Outlays by Budget Enforcement Act Category in Constant Dollars
Table 8.3 - Percentage Distribution of Outlays by Budget Enforcement Act Category
Table 8.4 - Outlays by Budget Enforcement Act Category as Percentages of GDP
Table 8.5 - Outlays for Mandatory and Related Programs
Table 8.6 - Outlays for Mandatory and Related Programs in Constant Dollars
Table 8.7 - Outlays for Discretionary Programs 1962–2020
Table 8.8 - Outlays for Discretionary Programs in Constant Dollars 1962–2020
Table 9.1 - Total Investment Outlays for Physical Capital Research and Development
Table 9.2 - Major Public Physical Capital Investment Outlays
Table 9.3 - Major Public Physical Capital Investment Outlays in Percentage Terms
Table 9.4 - National Defense Outlays for Major Public Direct Physical Capital Investment
Table 9.5 - Non Defense Outlays for Major Public Direct Physical Capital Investment
Table 9.6 - Composition of Outlays for Grants for Major Public Physical Capital Investment
Table 9.7 - Summary of Outlays for the Conduct of Research and Development 1949–2016
Table 9.8 - Composition of Outlays for the Conduct of Research and Development 1949–2016
Table 9.9 - Composition of Outlays for the Conduct of Education and Training 1962–2016
Table 10.1 - Gross Domestic Product and Deflators Used in the Historical Tables 1940–2020
Table 11.1 - Summary Comparison of Outlays for Payments for Individuals 1940–2020
Table 11.2 - Functional Composition of Outlays for Payments for Individuals 1940–2020
Table 11.3 - Outlays for Payments for Individuals by Category and Major Program 1940–2020
Table 12.1 - Summary Comparison of Total Outlays for Grants to State and Local Governments
Table 12.2 - Total Outlays for Grants to State and Local Governments by Function and Fund Group
Table 12.3 - Total Outlays for Grants to State and Local Governments by Function Agency and Program
Table 13.1 - Cash Income - Outgo - and Balances of the Social Security and Medicare Trust Funds
Table 14.1 - Total Government Receipts in Absolute Amounts and as Percentages of GDP
Table 14.2 - Total Government Expenditures 1948–2014
Table 14.3 - Total Government Expenditures as Percentages of GDP 1948–2014
Table 14.4 - Total Government Expenditures by Major Category of Expenditure 1948–2014
Table 14.5 - Total Government Expenditures by Major Category of Expenditure as Percentages of GDP
Table 14.6 - Total Government Surpluses or Deficits in Absolute Amounts and as Percentages of GDP
Table 15.1 - Total Outlays for Health Programs 1962–2020
Table 16.1 - Total Executive Branch Civilian Full_Time Equivalent Employees 1981–2016
Table 16.2 - Total Executive Branch Civilian Full Time Equivalent Employees as Percentage

The goal of publishing these CSV and JSON alternatives is to make this data easier to consumer, and integrate into websites, applications, visualizations, and other integrations.

APIs

This is a list of APIs generated from the Excel files made avalable as part of the Office of Management and Budget Historical Tables, providing data on budget receipts, outlays, surpluses or deficits, Federal debt, and Federal employment over an extended time period, generally from 1940 or earlier to 2016 or 2020.

Table 1
Table 2
Table 3
Table 4
Table 5
Table 6
Table 7
Table 8
Table 9
Table 10
Table 11
Table 12
Table 13
Table 14
Table 15
Table 16

The goal of launching these APIs is to make this data easier to consumer, and integrate into websites, applications, visualizations, and other integrations.

Showcase

These are some of the things being build on top of this open data and APIs.

Showcase Item One - This is the description for the first thing that was build on top of the data or APIs included as part of this project....view.

Showcase Item Two - This is the description for the first thing that was build on top of the data or APIs included as part of this project....view.

Showcase Item Four - This is the description for the first thing that was build on top of the data or APIs included as part of this project....view.

This project is designed to be used, and extended, please share what you have built so it can be included.

Team

This is a solo project conducted by Kin Lane as part of the Adopta.Agency project.

Kin Lane - The API Evangelist, working to make data, content, and other digital resources more accessible.

If you would like to get involved with this work, please submit an issue via the Github repo.

Tools

This is a list of tools that are used as part of this project.

Github (A social network built around software development platform Git.).
Github Pages (Websites for projects that are hosted directly from a GitHub repository.).
Google Spreadsheets (Cloud-based spreadsheets as part of the overall Google Dirve platform.).
API Spark (A platform for the creation, hosting, management, and consumption of web APIs.).
CSV Converter (A CSV conversion tool that runs on Github, created from Mr. Data Converter.).

We share the tools we used to help others understand how to recreate the work.

FAQ

These are some of the common questions that need answering or get asked as part of this work.

Why are you doing this? - I want to make the data around the US federal budget more accessible and usable, encouraging people to build it into more websites, applications, visualizations, and anywhere it can be used.
Where did this data come from? - It is from the Office of Management and Budget Historical Tables.
What are you planning on doing with this data? - You can visit the roadmap for more information.

How do I talk to someone behind this project? - This site runs on Github Pages, and relies on Github issue management for support. Go ahead and submit an issue via the project repository.

Questions that get submitted via the projects Github issue managment are sometimes added here.

Support

If you need any help, have questions, or would like to get involved, please use the following links.