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

Operating Expenditures

@kaggle.jeegarmaru_us_campaign_finance_20172018_fec.operating_expenditures

65.58 MB
1799700 rows
25 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
C00650028	N	2017	YE	201801319091194960	17	F3	SB	OVERNIGHT PRINTING, INC.	SEATTLE	WA	981341422	10/04/2017	94.85	P2018	PRINTING	nan	nan	nan	nan	ORG	4021320181504516216	1204782	VTQ0T9Q1TZ8	nan
C00650028	N	2017	YE	201801319091194960	17	F3	SB	OVERNIGHT PRINTING, INC.	SEATTLE	WA	981341422	11/06/2017	302.22	P2018	PRINTING	nan	nan	nan	nan	ORG	4021320181504516218	1204782	VTQ0T9Q1V06	nan
C00650028	N	2017	YE	201801319091194961	17	F3	SB	REVUP SOFTWARE, INC.	REDWOOD CITY	CA	940651177	12/04/2017	1000	P2018	SOFTWARE RENTAL	nan	nan	nan	nan	ORG	4021320181504516220	1204782	VTQ0T9Q1V14	nan
C00650028	N	2017	YE	201801319091194961	17	F3	SB	SMITH, JESSE	SEATTLE	WA	981123504	10/04/2017	1500	P2018	EMAIL PRODUCTION	nan	nan	nan	nan	IND	4021320181504516222	1204782	VTQ0T9Q1SM1	nan
C00650028	N	2017	YE	201801319091194947	17	F3	SB	ACTBLUE TECHNICAL SERVICES	CAMBRIDGE	MA	022382110	12/17/2017	602.74	P2018	CREDIT CARD FEES	nan	nan	nan	nan	ORG	4021320181504516140	1204782	VTQ0T9PJD25	nan
C00650028	N	2017	YE	201801319091194946	17	F3	SB	ACTBLUE TECHNICAL SERVICES	CAMBRIDGE	MA	022382110	11/26/2017	54.66	P2018	CREDIT CARD FEES	nan	nan	nan	nan	ORG	4021320181504516134	1204782	VTQ0T9PE4J0	nan
C00650028	N	2017	YE	201801319091194947	17	F3	SB	ACTBLUE TECHNICAL SERVICES	CAMBRIDGE	MA	022382110	12/03/2017	282.64	P2018	CREDIT CARD FEES	nan	nan	nan	nan	ORG	4021320181504516136	1204782	VTQ0T9PFM68	nan
C00650028	N	2017	YE	201801319091194947	17	F3	SB	ACTBLUE TECHNICAL SERVICES	CAMBRIDGE	MA	022382110	12/10/2017	200.11	P2018	CREDIT CARD FEES	nan	nan	nan	nan	ORG	4021320181504516138	1204782	VTQ0T9PH1E6	nan
C00650028	N	2017	YE	201801319091194948	17	F3	SB	ACTBLUE TECHNICAL SERVICES	CAMBRIDGE	MA	022382110	12/24/2017	944.08	P2018	CREDIT CARD FEES	nan	nan	nan	nan	ORG	4021320181504516142	1204782	VTQ0T9PKVY4	nan
C00650028	N	2017	YE	201801319091194948	17	F3	SB	ACTBLUE TECHNICAL SERVICES	CAMBRIDGE	MA	022382110	12/31/2017	1323.83	P2018	CREDIT CARD FEES	nan	nan	nan	nan	ORG	4021320181504516144	1204782	VTQ0T9PN3Y8	nan


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