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

Candidate Master

@kaggle.jeegarmaru_us_campaign_finance_20132014_fec.candidate_master

328.97 KB
5536 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
H0AK00097	COX, JOHN R.	REP	2014	AK	H		C	N	C00525261	P.O. BOX 1092	nan	ANCHOR POINT	AK	99556
H0AL02087	ROBY, MARTHA	REP	2014	AL	H	2	I	C	C00462143	3260 BANKHEAD AVE	nan	MONTGOMERY	AL	361062448
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	2014	AL	H	5	I	C	C00464149	7610 FOXFIRE DR.	nan	HUNTSVILLE	AL	35802
H0AL05189	SHEPARD, TAZEWELL	DEM	2010	AL	H	5	C	P	C00477026	303 WILLIAMS AVE	SUITE 1311	HUNTSVILLE	AL	35801
H0AL06088	COOKE, STANLEY KYLE	REP	2010	AL	H	6	C	N	C00464222	723 CHERRY BROOK ROAD	nan	KIMBERLY	AL	35091
H0AL07086	SEWELL, TERRI A.	DEM	2014	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
H0AL07177	CHAMBERLAIN, DON	REP	2012	AL	H	7	C	P	C00482059	512 LAPSLEY ST	nan	SELMA	AL	36701
H0AR01083	CRAWFORD, ERIC ALAN RICK	REP	2014	AR	H	1	I	C	C00462374	34 CR 455	nan	JONESBORO	AR	72404


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
);