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

Operating Expenditures 2010–2024

@kaggle.dubradave_openfec_data.operating_expenditures_2010_2024

429.13 MB
12196238 rows
26 columns

cmte_id CMTE ID	amndt_ind AMNDT IND	rpt_yr RPT YR	rpt_tp RPT TP	image_num IMAGE NUM	line_num LINE NUM	form_tp_cd FORM TP CD	sched_tp_cd SCHED TP CD	name NAME	city CITY	state STATE	zip_code ZIP CODE	transaction_dt TRANSACTION DT	transaction_amt TRANSACTION AMT	transaction_pgi TRANSACTION PGI	purpose PURPOSE	category CATEGORY	category_desc CATEGORY DESC	memo_cd MEMO CD	memo_text MEMO TEXT	entity_tp ENTITY TP	sub_id SUB ID	file_num FILE NUM	tran_id TRAN ID	back_ref_tran_id BACK REF TRAN ID
C00377002	N	2009	M3	29932813318	21B	F3X	SB	1ST NATIONAL PROCESSING	CALABASAS	CA	913023829	02/02/2009	30.34	nan	CREDIT CARD PROCESSING FEES	nan	nan	nan	nan	ORG	4030320091108841808	406022	SB21B.13398	nan
C00377002	N	2009	M3	29932813318	21B	F3X	SB	1ST NATIONAL PROCESSING	CALABASAS	CA	913023829	02/05/2009	6.29	nan	CREDIT CARD PROCESSING FEES	nan	nan	nan	nan	ORG	4030320091108841809	406022	SB21B.13405	nan
C00377002	N	2009	M3	29932813318	21B	F3X	SB	AMERICAN EXPRESS	PHOENIX	AZ	85072	02/06/2009	4.95	nan	CREDIT CARD PROCESSING FEES	nan	nan	nan	nan	ORG	4030320091108841810	406022	SB21B.13406	nan
C00377002	N	2009	M3	29932813319	21B	F3X	SB	AMERICAN EXPRESS	PHOENIX	AZ	85072	02/10/2009	0.33	nan	CREDIT CARD PROCESSING FEES	nan	nan	nan	nan	ORG	4030320091108841811	406022	SB21B.13415	nan
C00377002	N	2009	M3	29932813319	21B	F3X	SB	DISCOVER BUSINESS SERVICES	PHOENIX	AZ	85072	02/03/2009	10.71	nan	CREDIT CARD PROCESSING FEE	nan	nan	nan	nan	ORG	4030320091108841812	406022	SB21B.13400	nan
C00377002	N	2009	M3	29932813319	21B	F3X	SB	GMT CORPORATION	GREENWOOD	MS	389304212	02/03/2009	39.95	nan	HOST FOR WEB	nan	nan	nan	nan	ORG	4030320091108841813	406022	SB21B.13401	nan
C00377002	N	2009	M3	29932813320	21B	F3X	SB	GMT CORPORATION	GREENWOOD	MS	389304212	02/03/2009	43.09	nan	FREEDOM VOICE SYSTEMS	nan	nan	nan	nan	ORG	4030320091108841814	406022	SB21B.13402	nan
C00377002	N	2009	M3	29932813320	21B	F3X	SB	GMT CORPORATION	GREENWOOD	MS	389304212	02/03/2009	143.4	nan	ROUTINE MAILING COSTS	nan	nan	nan	nan	ORG	4030320091108841815	406022	SB21B.13403	nan
C00377002	N	2009	M3	29932813320	21B	F3X	SB	GMT CORPORATION	GREENWOOD	MS	389304212	02/03/2009	82.78	nan	2008-10-NL POSTAGE, PRINTING	nan	nan	nan	nan	ORG	4030320091108841816	406022	SB21B.13404	nan
C00377002	N	2009	M3	29932813321	21B	F3X	SB	LIBERTY APPLIQUE	ROLLA	MO	65401	02/09/2009	20	nan	1 L SHIRT AND 1 CAP	nan	nan	nan	nan	ORG	4030320091108841817	406022	SB21B.13414	nan


CREATE TABLE operating_expenditures_2010_2024 (
  "cmte_id" VARCHAR,
  "amndt_ind" VARCHAR,
  "rpt_yr" BIGINT,
  "rpt_tp" VARCHAR,
  "image_num" BIGINT,
  "line_num" VARCHAR,
  "form_tp_cd" VARCHAR,
  "sched_tp_cd" VARCHAR,
  "name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "transaction_dt" VARCHAR,
  "transaction_amt" DOUBLE,
  "transaction_pgi" VARCHAR,
  "purpose" VARCHAR,
  "category" VARCHAR,
  "category_desc" VARCHAR,
  "memo_cd" VARCHAR,
  "memo_text" VARCHAR,
  "entity_tp" VARCHAR,
  "sub_id" BIGINT,
  "file_num" BIGINT,
  "tran_id" VARCHAR,
  "back_ref_tran_id" VARCHAR,
  "n_25" VARCHAR
);