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

All Candidates

@kaggle.jeegarmaru_us_campaign_finance_20132014_fec.all_candidates

232.05 KB
2989 rows
30 columns

cand_id CAND ID	cand_name CAND NAME	cand_ici CAND ICI	pty_cd PTY CD	cand_pty_affiliation CAND PTY AFFILIATION	ttl_receipts TTL RECEIPTS	ttl_disb TTL DISB	coh_bop COH BOP	coh_cop COH COP	cand_contrib CAND CONTRIB	cand_loans CAND LOANS	other_loans OTHER LOANS	cand_loan_repay CAND LOAN REPAY	other_loan_repay OTHER LOAN REPAY	debts_owed_by DEBTS OWED BY	ttl_indiv_contrib TTL INDIV CONTRIB	cand_office_st CAND OFFICE ST	cand_office_district CAND OFFICE DISTRICT	spec_election SPEC ELECTION	prim_election PRIM ELECTION	other_pol_cmte_contrib OTHER POL CMTE CONTRIB	pol_pty_contrib POL PTY CONTRIB	cvg_end_dt CVG END DT	indiv_refunds INDIV REFUNDS	cmte_refunds CMTE REFUNDS
H2AK00101	MOORE, MATTHEW EDWARD	C	1	DEM	60679.5	60679.5				12000	29150		1076.38	40123.62	19521.5	AK		nan	nan			Tue May 13 2014 00:00:00 GMT+0000 (Coordinated Universal Time)
H4AK00057	VONDERSAAR, FRANK J	C	1	DEM	500	400		100		500				500		AK		nan	nan			Thu Jul 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)
H4AK00123	DUNBAR, FORREST	C	1	DEM	237456.58	230088.83		7367.75							233131.98	AK		nan	nan	1000	3324.6	Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)
H0AK00097	COX, JOHN R.	C	2	REP		2391	1042									AK		nan	nan			Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)
H6AK00045	YOUNG, DONALD E	I	2	REP	788960.16	809039.2	508299.46	488220.42							461857.82	AK		nan	nan	289540.14		Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	6450	400
H8AK00116	LEDOUX, GABRIELLE R	C	2	REP			479	479								AK		nan	nan			Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)
H2AK00143	MCDERMOTT, JIM C	C	3	LIB	7877	7877			7437						140	AK		nan	nan		300	Wed Nov 19 2014 00:00:00 GMT+0000 (Coordinated Universal Time)
H4AL01156	LEFLORE, BURTON R	C	1	DEM	36974.05	35603		2592	4932	3500				3500	33474	AL	1	nan	W			Tue Sep 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)
H2AL01077	BONNER, JOSIAH ROBINS JR.	I	2	REP	87681.86	244891.08	157209.22								37650	AL	1	nan	nan	48000		Tue Sep 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	750
H2AL01176	YOUNG, LARRY DEAN JR	O	2	REP	284899.73	287647.43		-2747.7		174500		108264.6			109700.54	AL	1	nan	nan			Sun Mar 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE all_candidates (
  "cand_id" VARCHAR,
  "cand_name" VARCHAR,
  "cand_ici" VARCHAR,
  "pty_cd" BIGINT,
  "cand_pty_affiliation" VARCHAR,
  "ttl_receipts" DOUBLE,
  "trans_from_auth" DOUBLE,
  "ttl_disb" DOUBLE,
  "trans_to_auth" DOUBLE,
  "coh_bop" DOUBLE,
  "coh_cop" DOUBLE,
  "cand_contrib" DOUBLE,
  "cand_loans" DOUBLE,
  "other_loans" DOUBLE,
  "cand_loan_repay" DOUBLE,
  "other_loan_repay" DOUBLE,
  "debts_owed_by" DOUBLE,
  "ttl_indiv_contrib" DOUBLE,
  "cand_office_st" VARCHAR,
  "cand_office_district" DOUBLE,
  "spec_election" VARCHAR,
  "prim_election" VARCHAR,
  "run_election" VARCHAR,
  "gen_election" VARCHAR,
  "gen_election_precent" VARCHAR,
  "other_pol_cmte_contrib" DOUBLE,
  "pol_pty_contrib" DOUBLE,
  "cvg_end_dt" TIMESTAMP,
  "indiv_refunds" DOUBLE,
  "cmte_refunds" DOUBLE
);