US Campaign Finance 2013-2014 FEC

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

@kaggle.jeegarmaru_us_campaign_finance_20132014_fec

Table List

10 tables(191.52 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_20132014_fec.operating_expenditures

47.79 MB
1351071 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
C00280222	N	2013	M3	13961108081	21B	F3X	SB	PNC BANK	WASHINGTON	DC	20036	02/28/2013	233.7	nan	BANK FEES	1.0	Administrative/Salary/Overhead Expenses	nan	nan	ORG	4030420131184959072	858920	C3DAC92CA4023BE8C43	nan
C00280222	N	2013	M3	13961108081	21B	F3X	SB	SKADDEN, ARPS, SLATE, MEAGHER, & FLOM LLP	WHITE PLAINS	NY	10602	02/18/2013	3622.25	nan	LEGAL FEES	1.0	Administrative/Salary/Overhead Expenses	nan	nan	ORG	4030420131184959073	858920	V038CA69EB4A8BC04E6E	nan
C00488940	T	2013	TER	13961128995	21B	F3X	SB	THE HOWARD AGENCY	SACRAMENTO	CA	95814	02/21/2013	7028.31	nan	IN-KIND: DIRECT MAIL	nan	nan	nan	* IN-KIND RECEIVED	ORG	4030520131185006078	858957	D308605	C5678594
C00488940	T	2013	TER	13961128993	21B	F3X	SB	NGP VAN, INC.	WASHINGTON	DC	20005	02/14/2013	400	nan	DATABASE SERVICES	nan	nan	nan	nan	ORG	4030520131185006075	858957	D308384	nan
C00488940	T	2013	TER	13961128993	21B	F3X	SB	PERKINS COIE LLP	WASHINGTON	DC	20005	02/21/2013	874.8	nan	LEGAL & ACCOUNTING SERVICES	nan	nan	nan	nan	ORG	4030520131185006076	858957	D308383	nan
C00488940	T	2013	TER	13961128993	21B	F3X	SB	THE HOWARD AGENCY	SACRAMENTO	CA	95814	02/21/2013	27600	nan	IN-KIND: DIRECT MAIL/ISSUE ADVOCACY	nan	nan	nan	* IN-KIND RECEIVED	ORG	4030520131185006077	858957	D308604	C5678593
C00488940	T	2013	TER	13961128995	21B	F3X	SB	THE HOWARD AGENCY	SACRAMENTO	CA	95814	02/21/2013	6771.69	nan	DIRECT MAIL	nan	nan	X	nan	ORG	4030520131185006079	858957	D308606	nan
C00488940	T	2013	TER	13961128995	21B	F3X	SB	THE HOWARD AGENCY	SACRAMENTO	CA	95814	02/21/2013	7028.31	nan	IN-KIND: DIRECT MAIL	nan	nan	X	nan	ORG	4030520131185006080	858957	D308607	nan
C00488940	T	2013	TER	13961128997	21B	F3X	SB	THE HOWARD AGENCY	SACRAMENTO	CA	95814	02/21/2013	27600	nan	IN-KIND: DIRECT MAIL/ISSUE ADVOCACY	nan	nan	X	nan	ORG	4030520131185006081	858957	D308612	nan
C00383232	T	2013	TER	13940240539	21B	F3X	SB	AMERICAN WEB SERVICES, INC.	SACRAMENTO	CA	95811	02/14/2013	231.25	nan	WEBSITE SERVICES	nan	nan	nan	nan	ORG	4030520131185006073	858954	D539	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
);