Obama White House Budgets

2016 & 2017 OMB Proposals

@kaggle.jboysen_obama_budgets

Table List

6 tables(2.49 MB)

N 2016receipts

@kaggle.jboysen_obama_budgets.n_2016receipts

91.72 KB
237 rows
72 columns

source_category_code Source Category Code	source_category_name Source Category Name	source_subcategory Source Subcategory	source_subcategory_name Source Subcategory Name	agency_code Agency Code	agency_name Agency Name	bureau_name Bureau Name	account_code Account Code	account_name Account Name	treasury_agency_code Treasury Agency Code	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
931	Individual Income Taxes		Individual Income Taxes	9	Department of Health and Human Services	Department of Health and Human Services	800415	Supplemental Catastrophic Premium, Refunds, FSMI	20	On-budget																														-566000
931	Individual Income Taxes		Individual Income Taxes	9	Department of Health and Human Services	Department of Health and Human Services	818210	FHICCR supplemental catastrophic premium	20	On-budget																													527000	39000
931	Individual Income Taxes		Individual Income Taxes	15	Department of the Treasury	Department of the Treasury	551010	Private Collection Agent Program	20	On-budget																																															11000	13000	10000
931	Individual Income Taxes		Individual Income Taxes	901	Governmental Receipts	Governmental Receipts	11050	Individual Income Taxes	99	On-budget	45571090	47587746	48696942	48791672	55446121	61525756	68725513	87248949	90411787	86230010	94736616	103245521	118951631	122385980	131602555	38800969	157626065	180987774	217840966	244068898	285917100	297744492	288937814	298415430	334531018	348959411	392557016	401181069	445163230	467378818	467795124	475933931	509652473	542984997	590175000	656351000	737399000	828523000	879419000	1004401000	994281000	858278000	793644000	808903000	927169000	1043858000	1163411000	1145685000	915253000	898508000	1091433000	1132169000	1316370000	1394538000	1478026000	1645578000	1770297000	1886834000	1999750000	2118356000
931	Individual Income Taxes		Individual Income Taxes	901	Governmental Receipts	Governmental Receipts	508110	Presidential Election Campaign Fund	20	On-budget																														32469	32319	29571	27643	69755	69000	66000	67000	63000	61000	61000	58000	67000	55000	56000	53000	50000	50000	49000	45000	41000	40000	37000	35000	30000	50000	50000	50000	50000	50000	50000
932	Corporation Income Taxes		Corporation Income Taxes	20	Environmental Protection Agency	Environmental Protection Agency	814515	Corporation Income Taxes, Hazardous Substance Superfund	68	On-budget																											196000	313000	292000	460955	591113	379954	885773	652695	612000	323000	4000	79000	10000	3000	4000	7000	-99000	1000	4000	1000	3000		1000	2000						996000	1257000	1282000	1305000	1315000
932	Corporation Income Taxes	5	Corporation Income Taxes	901	Governmental Receipts	Governmental Receipts	11100	Corporation Income and Excess Profits Taxes	99	On-budget	20522658	21578900	23492522	25460945	30073028	33971357	28664673	36677558	32829330	26784575	32165916	36152530	38619654	40621179	41408703	8460466	54892364	59951866	65676588	64599673	61137136	49206969	37021566	56892983	61330690	63143307	83729770	94195098	102999115	93045743	97494709	99890412	116634409	139732030	156392000	171501000	182289000	188598000	184670000	207286000	151071000	148037000	131877000	189370000	278278000	353914000	370240000	304346000	138228000	191435000	181085000	242289000	273506000	320731000	341688000	472308000	498506000	501745000	505901000	511220000
933	Social Insurance Taxes and Contributions	5	Employment Taxes and Contributions	9	Department of Health and Human Services	Department of Health and Human Services	800500	FHI Trust Fund, Receipts	20	On-budget					893007	2644884	3492662	4398012	4755096	4874233	5204673	7603340	10551433	11251845	11987415	3456555	13473539	16667773	19874177	23216569	30339920	34301279	35641215
933	Social Insurance Taxes and Contributions	5	Employment Taxes and Contributions	9	Department of Health and Human Services	Department of Health and Human Services	800501	FHI Trust Fund, Transfers from General Fund (FICA Taxes)	75	On-budget																								34556795	38500530	43550277	50969256	56199570	61710313	64271999	67595245	73362137	76170466	83952176	88934000	97866000	103500000	110455000	123360000	125909000	139507000	138876000	136885000	139409000	154400000	165160000	171022000	178875000	175443000	165547000	175094000	186773000	192707000	205296000	214828000	225665000	238354000	251684000	264237000	275211000
933	Social Insurance Taxes and Contributions	5	Employment Taxes and Contributions	9	Department of Health and Human Services	Department of Health and Human Services	800510	FHI Trust Fund, Receipts from Railroad Retirement Board	75	On-budget																								308000	325700	321100	329900	332400	344600	332300	329000	336800	381000	394400	358000	362000	380000	381000	388000	418000	422000	388000	396000	391000	416000	440000	455000	494000	496000	507000	452000	484000	547000	581000	594000	608000	622000	641000	663000	683000


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,
  "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
);