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

Candidate Master

@kaggle.jeegarmaru_us_campaign_finance_20172018_fec.candidate_master

433.62 KB
7380 rows
15 columns

cand_id CAND ID	cand_name CAND NAME	cand_pty_affiliation CAND PTY AFFILIATION	cand_election_yr CAND ELECTION YR	cand_office_st CAND OFFICE ST	cand_office CAND OFFICE	cand_office_district CAND OFFICE DISTRICT	cand_ici CAND ICI	cand_status CAND STATUS	cand_pcc CAND PCC	cand_st1 CAND ST1	cand_st2 CAND ST2	cand_city CAND CITY	cand_st CAND ST	cand_zip CAND ZIP
H0AL02087	ROBY, MARTHA	REP	2018	AL	H	2	I	C	C00462143	3260 BANKHEAD AVE	nan	MONTGOMERY	AL	361062448
H0AL03192	THOMPSON, HANNAH	DEM	2020	AL	H	3	nan	N	C00681452	2181 N BROADWAY	nan	ALEXANDER CITY	AL	35010
H0AL05049	CRAMER, ROBERT E "BUD" JR	DEM	2008	AL	H	5	nan	P	C00239038	PO BOX 2621	nan	HUNTSVILLE	AL	35804
H0AL05163	BROOKS, MO	REP	2018	AL	H	5	I	C	C00464149	7610 FOXFIRE DR.	nan	HUNTSVILLE	AL	35802
H0AL06088	COOKE, STANLEY KYLE	REP	2010	AL	H	6	C	N	C00464222	723 CHERRY BROOK ROAD	nan	KIMBERLY	AL	35091
H0AL06104	ALLEN, ANDERS POPE	REP	2020	AL	H	6	nan	N	C00681213	123 KATY CIRCLE	nan	BIRMINGHAM	AL	35242
H0AL07086	SEWELL, TERRI A.	DEM	2018	AL	H	7	I	C	C00458976	P.O. BOX 1964	nan	BIRMINGHAM	AL	35201
H0AL07094	HILLIARD, EARL FREDERICK JR	DEM	2010	AL	H	7	O	P	C00460410	PO BOX 12804	nan	BIRMINGHAM	AL	35202
H0AR01083	CRAWFORD, ERIC ALAN RICK	REP	2018	AR	H	1	I	C	C00462374	34 CR 455	nan	JONESBORO	AR	72404
H0AR01091	GREGORY, JAMES CHRISTOPHER	DEM	2010	AR	H	1	O	N	C00472126	510 S LILLY ST	nan	BLYTHEVILLE	AR	72315


CREATE TABLE candidate_master (
  "cand_id" VARCHAR,
  "cand_name" VARCHAR,
  "cand_pty_affiliation" VARCHAR,
  "cand_election_yr" BIGINT,
  "cand_office_st" VARCHAR,
  "cand_office" VARCHAR,
  "cand_office_district" DOUBLE,
  "cand_ici" VARCHAR,
  "cand_status" VARCHAR,
  "cand_pcc" VARCHAR,
  "cand_st1" VARCHAR,
  "cand_st2" VARCHAR,
  "cand_city" VARCHAR,
  "cand_st" VARCHAR,
  "cand_zip" DOUBLE
);