OpenFEC Data

All Data From the Federal Election Commission (Except Individual Contributions)

@kaggle.dubradave_openfec_data

Table List

10 tables(1.19 GB)

All Candidates 2010–2024

Allcandidates 2010–2024

Any Transactions From One Committee To Another 2010–2024

Candidate Committe Linkages 2010–2024

Candidate Master 2010–2024

Committee Master 2010–2024

Contributions From Committees To Candidates 2010–2024

House Senate Current Campaigns 2010–2024

Operating Expenditures 2010–2024

Pac Summary 2010–2024

All Candidates 2010–2024

@kaggle.dubradave_openfec_data.all_candidates_2010_2024

1.49 MB
24350 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	cand_loan_repay CAND 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	gen_election GEN ELECTION	gen_election_precent GEN ELECTION PRECENT	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
H0AK00089	CRAWFORD, HARRY T JR	C	1	DEM	240439.24	235571.43		4867.81	5832.41			5000	214136.59	AK		nan	W	L	30	14200	1749.99	Fri Dec 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	850	500
H6AK00144	BENSON, DIANE E MS	C	1	DEM	772.52	5258.6	2040.5	-2445.58					693.07	AK		nan	nan	nan				Fri Dec 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)
H8AK00108	BERKOWITZ, ETHAN A	C	1	DEM	107.39	11685.93	11078.54				3350.25	3549.75	103	AK		nan	nan	nan				Sun Oct 18 2009 00:00:00 GMT+0000 (Coordinated Universal Time)
H0AK01038	FISHER, SHELDON ALLRED	C	2	REP	179483.43	179483.43			6568.46	118360	1501.99		54540.98	AK		nan	nan	nan				Wed Dec 15 2010 00:00:00 GMT+0000 (Coordinated Universal Time)
H6AK00045	YOUNG, DONALD E	I	2	REP	1001015.37	887310.33	57037.18	170742.22					620188.18	AK		nan	W	W	69	341854.57	350	Fri Dec 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	20600	1130.65
H8AK00116	LEDOUX, GABRIELLE R	C	2	REP			479.17	479				366000		AK		nan	nan	nan				Fri Dec 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)
H8AK00124	PARNELL, SEAN	C	2	REP	5801.97	38084.61	32282.64							AK		nan	nan	nan				Wed Mar 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)
H8AL01041	LODMELL, BENJAMIN	C	1	DEM										AL	1	nan	nan	nan				Wed Sep 30 2009 00:00:00 GMT+0000 (Coordinated Universal Time)
H0AL01030	GOUNARES, PETER HUNTER	C	2	REP	51236.51	51233.71		2.8	1055	14700	500	14354.49	33395.2	AL	1	nan	nan	nan		35		Fri Dec 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	200
H2AL01077	BONNER, JO	I	2	REP	913052.62	1101701	468459.25	279810.87					503564.43	AL	1	nan	W	W	83	397600	312.79	Fri Dec 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	850


CREATE TABLE all_candidates_2010_2024 (
  "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" DOUBLE,
  "other_pol_cmte_contrib" DOUBLE,
  "pol_pty_contrib" DOUBLE,
  "cvg_end_dt" TIMESTAMP,
  "indiv_refunds" DOUBLE,
  "cmte_refunds" DOUBLE
);