Obama White House Budgets

2016 & 2017 OMB Proposals

@kaggle.jboysen_obama_budgets

Table List

6 tables(2.49 MB)

N 2017budauth

@kaggle.jboysen_obama_budgets.n_2017budauth

557.94 KB
4521 rows
58 columns

agency_code Agency Code	agency_name Agency Name	bureau_code Bureau Code	bureau_name Bureau Name	account_code Account Code	account_name Account Name	subfunction_code Subfunction Code	subfunction_title Subfunction Title	bea_category BEA Category	on_or_off_budget On- Or Off- Budget	n_1976 1976	tq TQ	n_1977 1977	n_1978 1978	n_1979 1979	n_1980 1980	n_1981 1981	n_1982 1982	n_1983 1983	n_1984 1984	n_1985 1985	n_1986 1986	n_1987 1987	n_1988 1988	n_1989 1989	n_1990 1990	n_1991 1991	n_1992 1992	n_1993 1993	n_1994 1994	n_1995 1995	n_1996 1996	n_1997 1997	n_1998 1998	n_1999 1999	n_2000 2000	n_2001 2001	n_2002 2002	n_2003 2003	n_2004 2004	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021
1	Legislative Branch		Legislative Branch		Receipts, Central fiscal operations	803	Central fiscal operations	Mandatory	On-budget	-287	-132	-429	-385	-726
1	Legislative Branch		Legislative Branch		Receipts, Central fiscal operations	908	Other interest	Net interest	On-budget	-30	-17	-104	-61	-548
1	Legislative Branch		Legislative Branch	241400	Charges for services to trust funds	803	Central fiscal operations	Mandatory	On-budget	-28	-31	-16
1	Legislative Branch	5	Senate		Senate	801	Legislative functions	Discretionary	On-budget	126428	36115	154249	166424	215918	214602	160310	227030	248764
1	Legislative Branch	5	Senate	100	Compensation of Members, Senate	801	Legislative functions	Mandatory	On-budget										8793	8578	8976	9776	10800	11676	17675	17675	17675	17656	18015	18000	17000	17000	17000	18000	18000	18000	19000	20000	21000	21000	22000	23000	23000	23000	24000	24000	24000	24000	24000	24000	24000	24000	24000	24000	24000	24000
1	Legislative Branch	5	Senate	101	Mileage of the Vice President and Senators	801	Legislative functions	Discretionary	On-budget										60	60	57	60	60	60	60	60	60	60	60
1	Legislative Branch	5	Senate	107	Expense allowances of the Vice President, President Pro Tempore, Majority and Minority Leaders and Majority and Minority Whips	801	Legislative functions	Discretionary	On-budget										50	56	54	73	71	66	70	68	56	56	56
1	Legislative Branch	5	Senate	108	Representation allowances for the Majority and Minority Leaders	801	Legislative functions	Discretionary	On-budget											20	19	3	5	10	16	18	30	30	30
1	Legislative Branch	5	Senate	110	Salaries, Officers and Employees	801	Legislative functions	Discretionary	On-budget										162245	172342	165277	190895	97425	51576	55110	62213	69382	66143	70052	65000	59000	64000	72000	81000	82000	87000	96000	117000	125000	135000	147000	148000	158000	172000	179000	186000	176000	166000	173000	172000	179000	186000	190000	194000	197000	201000
1	Legislative Branch	5	Senate	115	Payments to widows and heirs of deceased members of Congress	801	Legislative functions	Mandatory	On-budget										70			165			98		231


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,
  "n_1976" BIGINT,
  "tq" BIGINT,
  "n_1977" BIGINT,
  "n_1978" BIGINT,
  "n_1979" BIGINT,
  "n_1980" BIGINT,
  "n_1981" BIGINT,
  "n_1982" BIGINT,
  "n_1983" BIGINT,
  "n_1984" BIGINT,
  "n_1985" BIGINT,
  "n_1986" BIGINT,
  "n_1987" BIGINT,
  "n_1988" BIGINT,
  "n_1989" BIGINT,
  "n_1990" BIGINT,
  "n_1991" BIGINT,
  "n_1992" BIGINT,
  "n_1993" BIGINT,
  "n_1994" BIGINT,
  "n_1995" BIGINT,
  "n_1996" BIGINT,
  "n_1997" BIGINT,
  "n_1998" BIGINT,
  "n_1999" BIGINT,
  "n_2000" BIGINT,
  "n_2001" BIGINT,
  "n_2002" BIGINT,
  "n_2003" BIGINT,
  "n_2004" BIGINT,
  "n_2005" BIGINT,
  "n_2006" BIGINT,
  "n_2007" BIGINT,
  "n_2008" BIGINT,
  "n_2009" BIGINT,
  "n_2010" BIGINT,
  "n_2011" BIGINT,
  "n_2012" BIGINT,
  "n_2013" BIGINT,
  "n_2014" BIGINT,
  "n_2015" BIGINT,
  "n_2016" BIGINT,
  "n_2017" BIGINT,
  "n_2018" BIGINT,
  "n_2019" BIGINT,
  "n_2020" BIGINT,
  "n_2021" BIGINT
);