OpenFEC Data

All Data From the Federal Election Commission (Except Individual Contributions)

@kaggle.dubradave_openfec_data

Table List

10 tables(1.19 GB)

All Candidates 2010–2024

Allcandidates 2010–2024

Any Transactions From One Committee To Another 2010–2024

Candidate Committe Linkages 2010–2024

Candidate Master 2010–2024

Committee Master 2010–2024

Contributions From Committees To Candidates 2010–2024

House Senate Current Campaigns 2010–2024

Operating Expenditures 2010–2024

Pac Summary 2010–2024

Committee Master 2010–2024

@kaggle.dubradave_openfec_data.committee_master_2010_2024

5.31 MB
130506 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
C00000042	ILLINOIS TOOL WORKS FOR BETTER GOVERNMENT COMMITTEE	LYNCH, MICHAEL J.	3600 WEST LAKE AVENUE	nan	GLENVIEW	IL	60026.0	B	Q	nan	Q	C	ILLINOIS TOOL WORKS INC.	nan
C00000059	HALLMARK CARDS PAC	SWARENS, GREG	2501 MCGEE	MD #288	KANSAS CITY	MO	64108.0	U	Q	UNK	M	C	HALLMARK CARDS INCORPORATED	nan
C00000422	AMERICAN MEDICAL ASSOCIATION POLITICAL ACTION COMMITTEE	WALKER, KEVIN	25 MASSACHUSETTS AVENUE, NW	SUITE 600	WASHINGTON	DC	20001.0	B	Q	nan	M	M	AMERICAN MEDICAL ASSOCIATION	nan
C00000489	D R I V E POLITICAL FUND, TEAMSTERS LOCAL UNION CHAPTER 886	RON COBB	3528 WEST RENO	nan	OKLAHOMA CITY	OK	73107.0	U	Q	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.0	U	Q	UNK	Q	T	MEDICAL ASS'N; KANSAS [AMPAC]	nan
C00000638	INDIANA STATE MEDICAL ASSOCIATION POLITICAL ACTION COMMITTEE	KORA, M.D., VIDYA	322 CANAL WALK, CANAL LEVEL	nan	INDIANAPOLIS	IN	46202.0	U	Q	nan	Q	M	INDIANA STATE MEDICAL ASSOCIATION	nan
C00000729	AMERICAN DENTAL ASSOCIATION POLITICAL ACTION COMMITTEE	CONNOR, FRANCIS DR	1111 14TH STREET, NW	SUITE 1100	WASHINGTON	DC	20005.0	B	Q	UNK	M	M	AMERICAN DENTAL ASSOCIATION	nan
C00000885	INTERNATIONAL UNION OF PAINTERS AND ALLIED TRADES POLITICAL ACTION TOGETHER POLITICAL COMM	GALIS, GEORGE	7234 PARKWAY DRIVE	nan	HANOVER	MD	21076.0	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)	BARNEY, JOSEPH	1201 15TH STREET, NW	nan	WASHINGTON	DC	20005.0	B	Q	UNK	M	T	NATIONAL ASSOCIATION OF HOME BUILDERS	nan
C00000935	DEMOCRATIC CONGRESSIONAL CAMPAIGN COMMITTEE	VOGEL, JONATHAN S.	430 SOUTH CAPITOL STREET, SE	2ND FLOOR	WASHINGTON	DC	20003.0	U	Y	DEM	M	nan	RHODE ISLAND VICTORY	nan


CREATE TABLE committee_master_2010_2024 (
  "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
);