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

Operating Expenditures

@kaggle.jeegarmaru_us_campaign_finance_20152016_fec.operating_expenditures

62.15 MB
1747230 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
C00415182	N	2015	Q1	15951142498	17	F3	SB	CHASE CARDMEMBER SERVICE	WILMINGTON	DE	198865153	02/21/2015	3301.24	P2016	CREDIT CARD PAYMENT	001	Administrative/Salary/Overhead Expenses	nan	nan	ORG	4041520151241882404	1002978	VN81E9TS8X8	nan
C00415182	N	2015	Q1	15951142495	17	F3	SB	GOOGLE INC.	SAN FRANCISCO	CA	941390001	01/21/2015	56.42	P2016	INTERNET SERVICE	001	Administrative/Salary/Overhead Expenses	X	*	ORG	4041520151241882396	1002978	VN81E9TQB00	VN81E9TQAP1
C00415182	N	2015	Q1	15951142495	17	F3	SB	LINKEDIN CORPORATION	MOUNTAIN VIEW	CA	94043	01/21/2015	49.95	P2016	INTERNET SERVICE	001	Administrative/Salary/Overhead Expenses	X	*	ORG	4041520151241882397	1002978	VN81E9TQB76	VN81E9TQAP1
C00415182	N	2015	Q1	15951142496	17	F3	SB	NATIONBUILDER	LOS ANGELES	CA	900131155	01/21/2015	99	P2016	INTERNET SERVICE	001	Administrative/Salary/Overhead Expenses	X	*	ORG	4041520151241882398	1002978	VN81E9TS9X1	VN81E9TQAP1
C00415182	N	2015	Q1	15951142496	17	F3	SB	NGP VAN, INC.	WASHINGTON	DC	20005	01/21/2015	2000	P2016	INTERNET SERVICE	001	Administrative/Salary/Overhead Expenses	X	*	ORG	4041520151241882399	1002978	VN81E9TQAX7	VN81E9TQAP1
C00415182	N	2015	Q1	15951142496	17	F3	SB	NGP VAN, INC.	WASHINGTON	DC	20005	01/21/2015	4650	P2016	INTERNET SERVICE	001	Administrative/Salary/Overhead Expenses	X	*	ORG	4041520151241882400	1002978	VN81E9TS8D2	VN81E9TQAP1
C00415182	N	2015	Q1	15951142497	17	F3	SB	STAPLES	BALTIMORE	MD	212123612	01/21/2015	397.43	P2016	OFFICE SUPPLIES	001	Administrative/Salary/Overhead Expenses	X	*	ORG	4041520151241882401	1002978	VN81E9TQAY5	VN81E9TQAP1
C00415182	N	2015	Q1	15951142497	17	F3	SB	THE BALTIMORE SUN MEDIA GROUP	BALTIMORE	MD	212780001	02/21/2015	-50	P2016	ADVERTISEMENT REFUND	001	Administrative/Salary/Overhead Expenses	X	*	ORG	4041520151241882402	1002978	VN81E9TSQF9	VN81E9TQAP1
C00415182	N	2015	Q1	15951142497	17	F3	SB	US POST OFFICE	TOWSON	MD	212044920	01/21/2015	67.92	P2016	POSTAGE	001	Administrative/Salary/Overhead Expenses	X	*	ORG	4041520151241882403	1002978	VN81E9TQB84	VN81E9TQAP1
C00415182	N	2015	Q1	15951142498	17	F3	SB	AMERICAN AIRLINES, INC.	DALLAS	TX	752619616	02/21/2015	389.1	P2016	TRAVEL	002	Travel Expenses	X	*	ORG	4041520151241882405	1002978	VN81E9TS9E3	VN81E9TS8X8


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
);