US Campaign Finance 2015-2016 FEC

Candidate & PAC info, contributions, expenditures, campaigns & committees data

@kaggle.jeegarmaru_us_campaign_finance_20152016_fec

Table List

10 tables(1014.15 MB)

All Candidates

Any Transaction From One Committee To Another

Candidate Master

Candidate Committee Linkages

Committee Master

Contributions By Individuals

Contributions From Committees To Candidates Independen 1de6a035

House Senate Current Campaigns

Operating Expenditures

Pac Summary

Pac Summary

@kaggle.jeegarmaru_us_campaign_finance_20152016_fec.pac_summary

697.12 KB
12049 rows
27 columns

cmte_id CMTE ID	cmte_nm CMTE NM	cmte_tp CMTE TP	cmte_dsgn CMTE DSGN	cmte_filing_freq CMTE FILING FREQ	ttl_receipts TTL RECEIPTS	trans_from_aff TRANS FROM AFF	indv_contrib INDV CONTRIB	other_pol_cmte_contrib OTHER POL CMTE CONTRIB	ttl_disb TTL DISB	tranf_to_aff TRANF TO AFF	indv_refunds INDV REFUNDS	other_pol_cmte_refunds OTHER POL CMTE REFUNDS	loan_repay LOAN REPAY	coh_bop COH BOP	coh_cop COH COP	debts_owed_by DEBTS OWED BY	contrib_to_other_cmte CONTRIB TO OTHER CMTE	ind_exp IND EXP	pty_coord_exp PTY COORD EXP	cvg_end_dt CVG END DT
C00000059	HALLMARK CARDS PAC	Q	U	M	123198.92		123198.92		88500					104794.36	139493.28		88500			Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000422	AMERICAN MEDICAL ASSOCIATION POLITICAL ACTION COMMITTEE	Q	B	M	2114478.16		2099958.16		2047839.79	1790	12621.71			552464.38	619102.75		1853000	141616.35		Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000489	D R I V E POLITICAL FUND CHAPTER 886	N	U	Q	41455.17	41453			39672.85					192	1974					Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000547	KANSAS MEDICAL SOCIETY POLITICAL ACTION COMMITTEE	Q	U	Q	19065		19065		17592.5	2592.5				4681.26	6153.76		15000			Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000638	INDIANA STATE MEDICAL ASSOCIATION POLITICAL ACTION COMMITTEE	Q	U	Q	143170		142570		85918.48	13222.5				35530.91	92782.43		3000			Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000729	AMERICAN DENTAL ASSOCIATION POLITICAL ACTION COMMITTEE	Q	B	M	2662755.28	123134.88	2500235.05		2584197.84	295000	8386.73			419310.99	497868.43		2222995			Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000885	INTERNATIONAL UNION OF PAINTERS AND ALLIED TRADES POLITICAL ACTION TOGETHER POLITICAL COMMITTEE	Q	B	M	5754649.9		5680825.24		5477767.42		500			450496.76	727379.24		2189076			Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000901	BUILD POLITICAL ACTION COMMITTEE OF THE NATIONAL ASSOCIATION OF HOME BUILDERS (BUILDPAC)	Q	B	M	3052617.19		2961408.28	7500	2949971.94		28657.34			361497.38	464142.63		2812000			Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000935	DCCC	Y	U	M	220891388.49	6619252.47	147346246.71	38631410.54	216358583.53	26206817.84	2732586.69	14300	13000000	2149438.76	6682243.72	14000000	403810.19	80378630.35	3612999.17	Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000984	UNITED STATES TELECOM ASSOCIATION POLITICAL ACTION COMMITTEE (TELECOMPAC)	Q	B	M	209068		154320	54558.46	212569.98					117600.99	114099.01		212500			Sat Dec 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE pac_summary (
  "cmte_id" VARCHAR,
  "cmte_nm" VARCHAR,
  "cmte_tp" VARCHAR,
  "cmte_dsgn" VARCHAR,
  "cmte_filing_freq" VARCHAR,
  "ttl_receipts" DOUBLE,
  "trans_from_aff" DOUBLE,
  "indv_contrib" DOUBLE,
  "other_pol_cmte_contrib" DOUBLE,
  "cand_contrib" DOUBLE,
  "cand_loans" DOUBLE,
  "ttl_loans_received" DOUBLE,
  "ttl_disb" DOUBLE,
  "tranf_to_aff" DOUBLE,
  "indv_refunds" DOUBLE,
  "other_pol_cmte_refunds" DOUBLE,
  "cand_loan_repay" DOUBLE,
  "loan_repay" DOUBLE,
  "coh_bop" DOUBLE,
  "coh_cop" DOUBLE,
  "debts_owed_by" DOUBLE,
  "nonfed_trans_received" DOUBLE,
  "contrib_to_other_cmte" DOUBLE,
  "ind_exp" DOUBLE,
  "pty_coord_exp" DOUBLE,
  "nonfed_share_exp" DOUBLE,
  "cvg_end_dt" TIMESTAMP
);