US Campaign Finance 2017-2018 FEC

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

@kaggle.jeegarmaru_us_campaign_finance_20172018_fec

Table List

10 tables(969.39 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_20172018_fec.pac_summary

733.1 KB
12402 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
C00000018	IRONWORKERS LOCAL UNION NO. 25 POLITICAL EDUCATION COMMITTEE	Q	U	T
C00000059	HALLMARK CARDS PAC	Q	U	M	129002.59		126502.59		119500					139493.28	148995.87		117500			Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000422	AMERICAN MEDICAL ASSOCIATION POLITICAL ACTION COMMITTEE	Q	B	M	1962844.52	25	1930839.85		1439794.05	25	11819.75			619102.75	1142153.22		1379800			Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000489	D R I V E POLITICAL FUND CHAPTER 886	N	U	Q	60611	60611			51890.23					1974	13740					Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000547	KANSAS MEDICAL SOCIETY POLITICAL ACTION COMMITTEE	Q	U	Q	11375		11375		12650		150			6153.76	4878.76		12500			Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000638	INDIANA STATE MEDICAL ASSOCIATION POLITICAL ACTION COMMITTEE	Q	U	Q	88365		88365		69809.43		250			92782.43	111338		2000			Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000729	AMERICAN DENTAL ASSOCIATION POLITICAL ACTION COMMITTEE	Q	B	M	2491513.97	110349.55	2351485.8		2494460.61	72000	10730			497868.43	494921.79		2354940			Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000885	INTERNATIONAL UNION OF PAINTERS AND ALLIED TRADES POLITICAL ACTION TOGETHER POLITICAL COMMITTEE	Q	B	M	5751003.42		5691102.46		5907286.43	10954.39	644.27			727379.24	571096.23		2065100			Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000901	BUILD POLITICAL ACTION COMMITTEE OF THE NATIONAL ASSOCIATION OF HOME BUILDERS (BUILDPAC)	Q	B	M	3040617.37		2923877.76	19500	3047667.86		27430.13			464142.63	457092.14		2894000			Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000935	DCCC	Y	U	M	296422427.59	8455780.43	206633015.96	44079565.28	297489175.42	36210149.01	2724376.62	47570	16000000	6682243.72	5615495.89	18943553.22	510608.3	84632372.87	6853756.9	Mon Dec 31 2018 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
);