US Campaign Finance 2015-2016 FEC

Candidate & PAC info, contributions, expenditures, campaigns & committees data

@kaggle.jeegarmaru_us_campaign_finance_20152016_fec

Table List

10 tables(1014.15 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_20152016_fec.committee_master

1.18 MB
17652 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
C00000059	HALLMARK CARDS PAC	ERIN BROWER	2501 MCGEE	MD#288	KANSAS CITY	MO	64108	U	Q	UNK	M	C	nan	nan
C00000422	AMERICAN MEDICAL ASSOCIATION POLITICAL ACTION COMMITTEE	WALKER, KEVIN	25 MASSACHUSETTS AVE, NW	SUITE 600	WASHINGTON	DC	20001	B	Q	nan	M	M	AMERICAN MEDICAL ASSOCIATION	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	C. RICHARD BONEBRAKE, M.D.	623 SW 10TH AVE	nan	TOPEKA	KS	66612	U	Q	UNK	Q	T	nan	nan
C00000638	INDIANA STATE MEDICAL ASSOCIATION POLITICAL ACTION COMMITTEE	VIDYA KORA, M.D.	322 CANAL WALK, CANAL LEVEL	nan	INDIANAPOLIS	IN	46202	U	Q	nan	Q	M	nan	nan
C00000729	AMERICAN DENTAL ASSOCIATION POLITICAL ACTION COMMITTEE	HARRISON, THOMAS C. DR	1111 14TH STREET, NW	SUITE 1100	WASHINGTON	DC	20005	B	Q	UNK	M	M	AMERICAN DENTAL ASSOCIATION	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	WARD, KELLY C.	430 SOUTH CAPITOL STREET, SE	2ND FLOOR	WASHINGTON	DC	200034024	U	Y	DEM	M	nan	nan	nan
C00000984	UNITED STATES TELECOM ASSOCIATION POLITICAL ACTION COMMITTEE (TELECOMPAC)	VERSAGGI, SARAH	607 14TH STREET NORTHWEST	SUITE 400	WASHINGTON	DC	20005	B	Q	UNK	M	T	UNITED STATES TELECOM ASSOCIATION	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
);