US Campaign Finance 2013-2014 FEC

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

@kaggle.jeegarmaru_us_campaign_finance_20132014_fec

Table List

10 tables(191.52 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_20132014_fec.pac_summary

615.94 KB
10027 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
C00000042	ILLINOIS TOOL WORKS INC. FOR BETTER GOVERNMENT COMMITTEE	Q	B	T	104714.99		104714.99		140168.44					35453.45						Wed May 14 2014 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000059	HALLMARK CARDS PAC	Q	U	M	107646.8		107621.59		56500					53647.56	104794.36		56500			Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000422	AMERICAN MEDICAL ASSOCIATION POLITICAL ACTION COMMITTEE	Q	B	M	2273363.73		2265084.86		2021380.69	197.5	6399.94			300481.34	552464.38		1979000			Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000489	D R I V E POLITICAL FUND CHAPTER 886	N	U	Q	30186.33	30184.25			30069.57					75	192					Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000547	KANSAS MEDICAL SOCIETY POLITICAL ACTION COMMITTEE	Q	U	Q	26707.5	10000	16707.5		24500					2473.76	4681.26		14500			Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000638	INDIANA STATE MEDICAL ASSOCIATION POLITICAL ACTION COMMITTEE	Q	U	Q	168140		167540		192447.07	62362.5	365			59837.98	35530.91		2500			Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000729	AMERICAN DENTAL ASSOCIATION POLITICAL ACTION COMMITTEE	Q	B	M	2778224.96	186669.47	2572485.64		2472583.79	220000	11525	100		113669.82	419310.99		1970600			Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000885	INTERNATIONAL UNION OF PAINTERS AND ALLIED TRADES POLITICAL ACTION TOGETHER POLITICAL COMM	Q	B	M	5361601.55		5289491.91		5894214.85		925			983110.06	450496.76		2136160			Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000901	BUILD POLITICAL ACTION COMMITTEE OF THE NATIONAL ASSOCIATION OF HOME BUILDERS (BUILDPAC)	Q	B	M	2577660.25		2487544.36	7500	2543604.08		24628.46			327441.21	361497.38		2411600			Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)
C00000935	DEMOCRATIC CONGRESSIONAL CAMPAIGN COMMITTEE	Y	U	M	206791993.49	8041586.37	148006412.43	26245907.65	206130775.71	31537124.11	1015148.15	79000	12000000	1488220.98	2149438.76	10000000	550784.63	68817280.29	2938747	Wed Dec 31 2014 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
);