Name: Obama White House Budgets
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Obama White House Budgets

Context:

Each year, after the President's State of the Union address, the Office of Management and Budget (OMB) releases the Administration's Budget, offering proposals on key priorities and newly announced initiatives. In 2016 & 2017 Obama’s OMB released all of the data included in the President's budget in a machine-readable format here on GitHub. “The budget process should be a reflection of our values as a country, so we think it's important that members of the public have as many tools as possible to see the data behind the President's proposals. And, if people are motivated to create their own visualizations or products from the data, they should have that chance as well.”

Content:

This branch includes three data files that contain an extract of the Office of Management and Budget (OMB) budget database. These files can be used to reproduce many of the totals published in the budget and examine unpublished details below the levels of aggregation published in the budget.
The user guide file contains detailed information about this data, its format, and its limitations.

Acknowledgements:

Datasets were compiled by Obama White House officials and released at this Github repo.

Inspiration:

What significant changes were there between 2016 and 2017 proposals?
How was the federal budget distributed across agencies?
Where there any interesting changes in federal receipts?

Tables

N 2016budauth

@kaggle.jboysen_obama_budgets.n_2016budauth

558.89 kB
4,442 rows
57 columns

CREATE TABLE n_2016budauth (
  "agency_code" BIGINT,
  "agency_name" VARCHAR,
  "bureau_code" BIGINT,
  "bureau_name" VARCHAR,
  "account_code" DOUBLE,
  "account_name" VARCHAR,
  "treasury_agency_code" DOUBLE,
  "subfunction_code" BIGINT,
  "subfunction_title" VARCHAR,
  "bea_category" VARCHAR,
  "on_or_off_budget" VARCHAR  -- On- Or Off- Budget,
  "n_1976" BIGINT  -- 1976,
  "tq" BIGINT,
  "n_1977" BIGINT  -- 1977,
  "n_1978" BIGINT  -- 1978,
  "n_1979" BIGINT  -- 1979,
  "n_1980" BIGINT  -- 1980,
  "n_1981" BIGINT  -- 1981,
  "n_1982" BIGINT  -- 1982,
  "n_1983" BIGINT  -- 1983,
  "n_1984" BIGINT  -- 1984,
  "n_1985" BIGINT  -- 1985,
  "n_1986" BIGINT  -- 1986,
  "n_1987" BIGINT  -- 1987,
  "n_1988" BIGINT  -- 1988,
  "n_1989" BIGINT  -- 1989,
  "n_1990" BIGINT  -- 1990,
  "n_1991" BIGINT  -- 1991,
  "n_1992" BIGINT  -- 1992,
  "n_1993" BIGINT  -- 1993,
  "n_1994" BIGINT  -- 1994,
  "n_1995" BIGINT  -- 1995,
  "n_1996" BIGINT  -- 1996,
  "n_1997" BIGINT  -- 1997,
  "n_1998" BIGINT  -- 1998,
  "n_1999" BIGINT  -- 1999,
  "n_2000" BIGINT  -- 2000,
  "n_2001" BIGINT  -- 2001,
  "n_2002" BIGINT  -- 2002,
  "n_2003" BIGINT  -- 2003,
  "n_2004" BIGINT  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017,
  "n_2018" BIGINT  -- 2018,
  "n_2019" BIGINT  -- 2019,
  "n_2020" BIGINT  -- 2020
);

N 2016outlays

@kaggle.jboysen_obama_budgets.n_2016outlays

719.5 kB
4,999 rows
72 columns

CREATE TABLE n_2016outlays (
  "agency_code" BIGINT,
  "agency_name" VARCHAR,
  "bureau_code" BIGINT,
  "bureau_name" VARCHAR,
  "account_code" DOUBLE,
  "account_name" VARCHAR,
  "treasury_agency_code" DOUBLE,
  "subfunction_code" BIGINT,
  "subfunction_title" VARCHAR,
  "bea_category" VARCHAR,
  "grant_non_grant_split" VARCHAR,
  "on_or_off_budget" VARCHAR  -- On- Or Off- Budget,
  "n_1962" BIGINT  -- 1962,
  "n_1963" BIGINT  -- 1963,
  "n_1964" BIGINT  -- 1964,
  "n_1965" BIGINT  -- 1965,
  "n_1966" BIGINT  -- 1966,
  "n_1967" BIGINT  -- 1967,
  "n_1968" BIGINT  -- 1968,
  "n_1969" BIGINT  -- 1969,
  "n_1970" BIGINT  -- 1970,
  "n_1971" BIGINT  -- 1971,
  "n_1972" BIGINT  -- 1972,
  "n_1973" BIGINT  -- 1973,
  "n_1974" BIGINT  -- 1974,
  "n_1975" BIGINT  -- 1975,
  "n_1976" BIGINT  -- 1976,
  "tq" BIGINT,
  "n_1977" BIGINT  -- 1977,
  "n_1978" BIGINT  -- 1978,
  "n_1979" BIGINT  -- 1979,
  "n_1980" BIGINT  -- 1980,
  "n_1981" BIGINT  -- 1981,
  "n_1982" BIGINT  -- 1982,
  "n_1983" BIGINT  -- 1983,
  "n_1984" BIGINT  -- 1984,
  "n_1985" BIGINT  -- 1985,
  "n_1986" BIGINT  -- 1986,
  "n_1987" BIGINT  -- 1987,
  "n_1988" BIGINT  -- 1988,
  "n_1989" BIGINT  -- 1989,
  "n_1990" BIGINT  -- 1990,
  "n_1991" BIGINT  -- 1991,
  "n_1992" BIGINT  -- 1992,
  "n_1993" BIGINT  -- 1993,
  "n_1994" BIGINT  -- 1994,
  "n_1995" BIGINT  -- 1995,
  "n_1996" BIGINT  -- 1996,
  "n_1997" BIGINT  -- 1997,
  "n_1998" BIGINT  -- 1998,
  "n_1999" BIGINT  -- 1999,
  "n_2000" BIGINT  -- 2000,
  "n_2001" BIGINT  -- 2001,
  "n_2002" BIGINT  -- 2002,
  "n_2003" BIGINT  -- 2003,
  "n_2004" BIGINT  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017,
  "n_2018" BIGINT  -- 2018,
  "n_2019" BIGINT  -- 2019,
  "n_2020" BIGINT  -- 2020
);

N 2016receipts

@kaggle.jboysen_obama_budgets.n_2016receipts

93.92 kB
237 rows
72 columns

CREATE TABLE n_2016receipts (
  "source_category_code" BIGINT,
  "source_category_name" VARCHAR,
  "source_subcategory" BIGINT,
  "source_subcategory_name" VARCHAR,
  "agency_code" BIGINT,
  "agency_name" VARCHAR,
  "bureau_code" BIGINT,
  "bureau_name" VARCHAR,
  "account_code" BIGINT,
  "account_name" VARCHAR,
  "treasury_agency_code" BIGINT,
  "on_or_off_budget" VARCHAR  -- On- Or Off-budget,
  "n_1962" BIGINT  -- 1962,
  "n_1963" BIGINT  -- 1963,
  "n_1964" BIGINT  -- 1964,
  "n_1965" BIGINT  -- 1965,
  "n_1966" BIGINT  -- 1966,
  "n_1967" BIGINT  -- 1967,
  "n_1968" BIGINT  -- 1968,
  "n_1969" BIGINT  -- 1969,
  "n_1970" BIGINT  -- 1970,
  "n_1971" BIGINT  -- 1971,
  "n_1972" BIGINT  -- 1972,
  "n_1973" BIGINT  -- 1973,
  "n_1974" BIGINT  -- 1974,
  "n_1975" BIGINT  -- 1975,
  "n_1976" BIGINT  -- 1976,
  "tq" BIGINT,
  "n_1977" BIGINT  -- 1977,
  "n_1978" BIGINT  -- 1978,
  "n_1979" BIGINT  -- 1979,
  "n_1980" BIGINT  -- 1980,
  "n_1981" BIGINT  -- 1981,
  "n_1982" BIGINT  -- 1982,
  "n_1983" BIGINT  -- 1983,
  "n_1984" BIGINT  -- 1984,
  "n_1985" BIGINT  -- 1985,
  "n_1986" BIGINT  -- 1986,
  "n_1987" BIGINT  -- 1987,
  "n_1988" BIGINT  -- 1988,
  "n_1989" BIGINT  -- 1989,
  "n_1990" BIGINT  -- 1990,
  "n_1991" BIGINT  -- 1991,
  "n_1992" BIGINT  -- 1992,
  "n_1993" BIGINT  -- 1993,
  "n_1994" BIGINT  -- 1994,
  "n_1995" BIGINT  -- 1995,
  "n_1996" BIGINT  -- 1996,
  "n_1997" BIGINT  -- 1997,
  "n_1998" BIGINT  -- 1998,
  "n_1999" BIGINT  -- 1999,
  "n_2000" BIGINT  -- 2000,
  "n_2001" BIGINT  -- 2001,
  "n_2002" BIGINT  -- 2002,
  "n_2003" BIGINT  -- 2003,
  "n_2004" BIGINT  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017,
  "n_2018" BIGINT  -- 2018,
  "n_2019" BIGINT  -- 2019,
  "n_2020" BIGINT  -- 2020
);

N 2017budauth

@kaggle.jboysen_obama_budgets.n_2017budauth

571.33 kB
4,521 rows
58 columns

CREATE TABLE n_2017budauth (
  "agency_code" BIGINT,
  "agency_name" VARCHAR,
  "bureau_code" BIGINT,
  "bureau_name" VARCHAR,
  "account_code" DOUBLE,
  "account_name" VARCHAR,
  "treasury_agency_code" DOUBLE,
  "subfunction_code" BIGINT,
  "subfunction_title" VARCHAR,
  "bea_category" VARCHAR,
  "on_or_off_budget" VARCHAR  -- On- Or Off- Budget,
  "n_1976" BIGINT  -- 1976,
  "tq" BIGINT,
  "n_1977" BIGINT  -- 1977,
  "n_1978" BIGINT  -- 1978,
  "n_1979" BIGINT  -- 1979,
  "n_1980" BIGINT  -- 1980,
  "n_1981" BIGINT  -- 1981,
  "n_1982" BIGINT  -- 1982,
  "n_1983" BIGINT  -- 1983,
  "n_1984" BIGINT  -- 1984,
  "n_1985" BIGINT  -- 1985,
  "n_1986" BIGINT  -- 1986,
  "n_1987" BIGINT  -- 1987,
  "n_1988" BIGINT  -- 1988,
  "n_1989" BIGINT  -- 1989,
  "n_1990" BIGINT  -- 1990,
  "n_1991" BIGINT  -- 1991,
  "n_1992" BIGINT  -- 1992,
  "n_1993" BIGINT  -- 1993,
  "n_1994" BIGINT  -- 1994,
  "n_1995" BIGINT  -- 1995,
  "n_1996" BIGINT  -- 1996,
  "n_1997" BIGINT  -- 1997,
  "n_1998" BIGINT  -- 1998,
  "n_1999" BIGINT  -- 1999,
  "n_2000" BIGINT  -- 2000,
  "n_2001" BIGINT  -- 2001,
  "n_2002" BIGINT  -- 2002,
  "n_2003" BIGINT  -- 2003,
  "n_2004" BIGINT  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017,
  "n_2018" BIGINT  -- 2018,
  "n_2019" BIGINT  -- 2019,
  "n_2020" BIGINT  -- 2020,
  "n_2021" BIGINT  -- 2021
);

N 2017outlays

@kaggle.jboysen_obama_budgets.n_2017outlays

571.33 kB
4,521 rows
58 columns

CREATE TABLE n_2017outlays (
  "agency_code" BIGINT,
  "agency_name" VARCHAR,
  "bureau_code" BIGINT,
  "bureau_name" VARCHAR,
  "account_code" DOUBLE,
  "account_name" VARCHAR,
  "treasury_agency_code" DOUBLE,
  "subfunction_code" BIGINT,
  "subfunction_title" VARCHAR,
  "bea_category" VARCHAR,
  "on_or_off_budget" VARCHAR  -- On- Or Off- Budget,
  "n_1976" BIGINT  -- 1976,
  "tq" BIGINT,
  "n_1977" BIGINT  -- 1977,
  "n_1978" BIGINT  -- 1978,
  "n_1979" BIGINT  -- 1979,
  "n_1980" BIGINT  -- 1980,
  "n_1981" BIGINT  -- 1981,
  "n_1982" BIGINT  -- 1982,
  "n_1983" BIGINT  -- 1983,
  "n_1984" BIGINT  -- 1984,
  "n_1985" BIGINT  -- 1985,
  "n_1986" BIGINT  -- 1986,
  "n_1987" BIGINT  -- 1987,
  "n_1988" BIGINT  -- 1988,
  "n_1989" BIGINT  -- 1989,
  "n_1990" BIGINT  -- 1990,
  "n_1991" BIGINT  -- 1991,
  "n_1992" BIGINT  -- 1992,
  "n_1993" BIGINT  -- 1993,
  "n_1994" BIGINT  -- 1994,
  "n_1995" BIGINT  -- 1995,
  "n_1996" BIGINT  -- 1996,
  "n_1997" BIGINT  -- 1997,
  "n_1998" BIGINT  -- 1998,
  "n_1999" BIGINT  -- 1999,
  "n_2000" BIGINT  -- 2000,
  "n_2001" BIGINT  -- 2001,
  "n_2002" BIGINT  -- 2002,
  "n_2003" BIGINT  -- 2003,
  "n_2004" BIGINT  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017,
  "n_2018" BIGINT  -- 2018,
  "n_2019" BIGINT  -- 2019,
  "n_2020" BIGINT  -- 2020,
  "n_2021" BIGINT  -- 2021
);

N 2017receipts

@kaggle.jboysen_obama_budgets.n_2017receipts

96.18 kB
244 rows
73 columns

CREATE TABLE n_2017receipts (
  "source_category_code" BIGINT,
  "source_category_name" VARCHAR,
  "source_subcategory" BIGINT,
  "source_subcategory_name" VARCHAR,
  "agency_code" BIGINT,
  "agency_name" VARCHAR,
  "bureau_code" BIGINT,
  "bureau_name" VARCHAR,
  "account_code" BIGINT,
  "account_name" VARCHAR,
  "treasury_agency_code" BIGINT,
  "on_or_off_budget" VARCHAR  -- On- Or Off-budget,
  "n_1962" BIGINT  -- 1962,
  "n_1963" BIGINT  -- 1963,
  "n_1964" BIGINT  -- 1964,
  "n_1965" BIGINT  -- 1965,
  "n_1966" BIGINT  -- 1966,
  "n_1967" BIGINT  -- 1967,
  "n_1968" BIGINT  -- 1968,
  "n_1969" BIGINT  -- 1969,
  "n_1970" BIGINT  -- 1970,
  "n_1971" BIGINT  -- 1971,
  "n_1972" BIGINT  -- 1972,
  "n_1973" BIGINT  -- 1973,
  "n_1974" BIGINT  -- 1974,
  "n_1975" BIGINT  -- 1975,
  "n_1976" BIGINT  -- 1976,
  "tq" BIGINT,
  "n_1977" BIGINT  -- 1977,
  "n_1978" BIGINT  -- 1978,
  "n_1979" BIGINT  -- 1979,
  "n_1980" BIGINT  -- 1980,
  "n_1981" BIGINT  -- 1981,
  "n_1982" BIGINT  -- 1982,
  "n_1983" BIGINT  -- 1983,
  "n_1984" BIGINT  -- 1984,
  "n_1985" BIGINT  -- 1985,
  "n_1986" BIGINT  -- 1986,
  "n_1987" BIGINT  -- 1987,
  "n_1988" BIGINT  -- 1988,
  "n_1989" BIGINT  -- 1989,
  "n_1990" BIGINT  -- 1990,
  "n_1991" BIGINT  -- 1991,
  "n_1992" BIGINT  -- 1992,
  "n_1993" BIGINT  -- 1993,
  "n_1994" BIGINT  -- 1994,
  "n_1995" BIGINT  -- 1995,
  "n_1996" BIGINT  -- 1996,
  "n_1997" BIGINT  -- 1997,
  "n_1998" BIGINT  -- 1998,
  "n_1999" BIGINT  -- 1999,
  "n_2000" BIGINT  -- 2000,
  "n_2001" BIGINT  -- 2001,
  "n_2002" BIGINT  -- 2002,
  "n_2003" BIGINT  -- 2003,
  "n_2004" BIGINT  -- 2004,
  "n_2005" BIGINT  -- 2005,
  "n_2006" BIGINT  -- 2006,
  "n_2007" BIGINT  -- 2007,
  "n_2008" BIGINT  -- 2008,
  "n_2009" BIGINT  -- 2009,
  "n_2010" BIGINT  -- 2010,
  "n_2011" BIGINT  -- 2011,
  "n_2012" BIGINT  -- 2012,
  "n_2013" BIGINT  -- 2013,
  "n_2014" BIGINT  -- 2014,
  "n_2015" BIGINT  -- 2015,
  "n_2016" BIGINT  -- 2016,
  "n_2017" BIGINT  -- 2017,
  "n_2018" BIGINT  -- 2018,
  "n_2019" BIGINT  -- 2019,
  "n_2020" BIGINT  -- 2020,
  "n_2021" BIGINT  -- 2021
);