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

Committee Master

@kaggle.jeegarmaru_us_campaign_finance_20172018_fec.committee_master

1.3 MB
19026 rows
15 columns

cmte_id CMTE ID	cmte_nm CMTE NM	tres_nm TRES NM	cmte_st1 CMTE ST1	cmte_st2 CMTE ST2	cmte_city CMTE CITY	cmte_st CMTE ST	cmte_zip CMTE ZIP	cmte_dsgn CMTE DSGN	cmte_tp CMTE TP	cmte_pty_affiliation CMTE PTY AFFILIATION	cmte_filing_freq CMTE FILING FREQ	org_tp ORG TP	connected_org_nm CONNECTED ORG NM	cand_id CAND ID
C00000018	IRONWORKERS LOCAL UNION NO. 25 POLITICAL EDUCATION COMMITTEE	STEVEN N GULICK	43335 W 10 MILE	P O BOX 965	NOVI	MI	48050	U	Q	nan	T	nan	IRON WORKERS; INT'L ASS'N OF BRIDGE...	H8TX22313
C00000059	HALLMARK CARDS PAC	SARAH MOE	2501 MCGEE	MD #500	KANSAS CITY	MO	64108	U	Q	UNK	M	C	nan	nan
C00000422	AMERICAN MEDICAL ASSOCIATION POLITICAL ACTION COMMITTEE	WALKER, KEVIN MR.	25 MASSACHUSETTS AVE, NW	SUITE 600	WASHINGTON	DC	200017400	B	Q	nan	M	M	DELAWARE MEDICAL PAC	nan
C00000489	D R I V E POLITICAL FUND CHAPTER 886	TOM RITTER	3528 W RENO	nan	OKLAHOMA CITY	OK	73107	U	N	nan	Q	L	TEAMSTERS LOCAL UNION 886	nan
C00000547	KANSAS MEDICAL SOCIETY POLITICAL ACTION COMMITTEE	JERRY SLAUGHTER	623 SW 10TH AVE	nan	TOPEKA	KS	666121627	U	Q	UNK	Q	M	KANSAS MEDICAL SOCIETY	nan
C00000638	INDIANA STATE MEDICAL ASSOCIATION POLITICAL ACTION COMMITTEE	ACHENBACH, GRANT MR.	322 CANAL WALK, CANAL LEVEL	nan	INDIANAPOLIS	IN	46202	U	Q	nan	Q	M	INDIANA STATE MEDICAL ASSOCIATION	nan
C00000729	AMERICAN DENTAL ASSOCIATION POLITICAL ACTION COMMITTEE	ORTEGO, L STEPHEN DR.	1111 14TH STREET, NW	SUITE 1100	WASHINGTON	DC	200055627	B	Q	UNK	M	T	NEW JERSEY DENTAL PAC	nan
C00000885	INTERNATIONAL UNION OF PAINTERS AND ALLIED TRADES POLITICAL ACTION TOGETHER POLITICAL COMMITTEE	GALIS, GEORGE	7234 PARKWAY DRIVE	nan	HANOVER	MD	21076	B	Q	UNK	M	L	INTERNATIONAL UNION OF PAINTERS AND ALLIED TRADES	nan
C00000901	BUILD POLITICAL ACTION COMMITTEE OF THE NATIONAL ASSOCIATION OF HOME BUILDERS (BUILDPAC)	RAMAGE, EILEEN	1201 15TH STREET, NW	nan	WASHINGTON	DC	20005	B	Q	UNK	M	T	NATIONAL ASSOCIATION OF HOME BUILDERS	nan
C00000935	DCCC	SENA, DANIEL	430 SOUTH CAPITOL STREET, SE	2ND FLOOR	WASHINGTON	DC	200034024	U	Y	DEM	M	nan	nan	nan


CREATE TABLE committee_master (
  "cmte_id" VARCHAR,
  "cmte_nm" VARCHAR,
  "tres_nm" VARCHAR,
  "cmte_st1" VARCHAR,
  "cmte_st2" VARCHAR,
  "cmte_city" VARCHAR,
  "cmte_st" VARCHAR,
  "cmte_zip" VARCHAR,
  "cmte_dsgn" VARCHAR,
  "cmte_tp" VARCHAR,
  "cmte_pty_affiliation" VARCHAR,
  "cmte_filing_freq" VARCHAR,
  "org_tp" VARCHAR,
  "connected_org_nm" VARCHAR,
  "cand_id" VARCHAR
);