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

All Candidates

@kaggle.jeegarmaru_us_campaign_finance_20172018_fec.all_candidates

285.66 KB
3690 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	trans_from_auth TRANS FROM AUTH	ttl_disb TTL DISB	trans_to_auth TRANS TO AUTH	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	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
H8AK00132	SHEIN, DIMITRI	C	1	DEM	209916.04		209574.16			367.52	43004.59	101440.14	7229.6	101072.62	7229.6	367.52	58188.98	AK				Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)
H6AK00045	YOUNG, DONALD E	I	2	REP	1234680.31		1387687.05		269726.86	116720.12							670374.33	AK		559861.9		Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	2700	500
H8AK00116	LEDOUX, GABRIELLE R	C	2	REP			540033		479	479						366000		AK				Sun Sep 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)
H8AK01031	NELSON, THOMAS JOHN	C	2	REP	9288.48		8821.97			466.51	1888.27						7100.05	AK				Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	600
H8AK00140	GALVIN, ALYSE	C	3	IND	1949643.68	154.7	1943398.59			6245.09	20982.07						1809591.38	AK		114833.97		Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	8166.36
H6AK00235	LINDBECK, STEVE	nan	1	DEM	33277.59		37489.27	10000	4211.68									AK				Tue Jan 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)
H8AL01066	KENNEDY, ROBERT JR.	C	1	DEM	166845.21		166845.21					120000		120000			39095.21	AL	1	7750		Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)
H8AL01082	MCCONNELL, LIZZETTA HILL	C	1	DEM	5127		6021			-894							5127	AL	1			Sat Jun 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)
H4AL01123	BYRNE, BRADLEY ROBERTS	I	2	REP	1463187.12	63923.25	834780.43		446318.33	1074725.02							343761.59	AL	1	1054650	663.98	Mon Dec 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	3050
H4AL01149	FINCHER, CHAD	C	2	REP					1904.14	1904.14						38000		AL	1			Thu Feb 16 2017 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
);