Obama White House Budgets

2016 & 2017 OMB Proposals

@kaggle.jboysen_obama_budgets

Table List

6 tables(2.49 MB)

N 2016outlays

@kaggle.jboysen_obama_budgets.n_2016outlays

702.64 KB
4999 rows
72 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	grant_non_grant_split Grant/non-grant Split	on_or_off_budget On- Or Off- Budget	n_1962 1962	n_1963 1963	n_1964 1964	n_1965 1965	n_1966 1966	n_1967 1967	n_1968 1968	n_1969 1969	n_1970 1970	n_1971 1971	n_1972 1972	n_1973 1973	n_1974 1974	n_1975 1975	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
1	Legislative Branch		Legislative Branch		Receipts, Central fiscal operations	803	Central fiscal operations	Mandatory	Nongrant	On-budget	-628	-390	-469	-413	-410	-722	-464	-522	-439	-360	-343	-427	-539	-307	-287	-132	-429	-385	-726
1	Legislative Branch		Legislative Branch		Receipts, Central fiscal operations	908	Other interest	Net interest	Nongrant	On-budget				-8	-7	-7	-7	-6	-6	-6	-5	-4	-4	-4	-30	-17	-104	-61	-548
1	Legislative Branch		Legislative Branch	241400	Charges for services to trust funds	803	Central fiscal operations	Mandatory	Nongrant	On-budget								-32	-40	-24		-26	-50		-28	-31	-16
1	Legislative Branch	5	Senate		Senate	801	Legislative functions	Discretionary	Nongrant	On-budget	26946	29310	29914	33261	35388	38060	42441	47619	57585	65050	74140	78870	93066	102237	123851	31104	138507	158208	169454	183890	195467	213229	227439
1	Legislative Branch	5	Senate	100	Compensation of Members, Senate	801	Legislative functions	Mandatory	Nongrant	On-budget																								8278	8562	8648	9717	10596	10762	11517	12633	15539	16164	16382	18000	16000	17000	17000	17000	18000	18000	19000	18000	20000	21000	21000	21000	22000	22000	23000	23000	23000	23000	23000	27000	24000	24000	24000	24000	24000
1	Legislative Branch	5	Senate	101	Mileage of the Vice President and Senators	801	Legislative functions	Discretionary	Nongrant	On-budget																								48	48	49	49	48	49	50	48	48	47	49
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	Nongrant	On-budget																								35	54	42	58	47	57	55	43	23	29	30
1	Legislative Branch	5	Senate	108	Representation allowances for the Majority and Minority Leaders	801	Legislative functions	Discretionary	Nongrant	On-budget																										1				2
1	Legislative Branch	5	Senate	110	Salaries, Officers and Employees	801	Legislative functions	Discretionary	Nongrant	On-budget																								153377	161276	158249	178968	96512	47429	51321	55625	61712	65755	67912	65000	61000	63000	66000	78000	81000	86000	96000	95000	115000	125000	133000	139000	147000	155000	165000	167000	165000	165000	158000	211000	186000	190000	194000	195000	197000
1	Legislative Branch	5	Senate	115	Payments to widows and heirs of deceased members of Congress	801	Legislative functions	Mandatory	Nongrant	On-budget																								70			165			98		102	130


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,
  "n_1962" BIGINT,
  "n_1963" BIGINT,
  "n_1964" BIGINT,
  "n_1965" BIGINT,
  "n_1966" BIGINT,
  "n_1967" BIGINT,
  "n_1968" BIGINT,
  "n_1969" BIGINT,
  "n_1970" BIGINT,
  "n_1971" BIGINT,
  "n_1972" BIGINT,
  "n_1973" BIGINT,
  "n_1974" BIGINT,
  "n_1975" BIGINT,
  "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
);