Dataset: US Campaign Finance 2015-2016 FEC

About this Dataset

US Campaign Finance 2015-2016 FEC

Context

I wanted to make the US Campaign Finance data available to everyone in an easily analyzable form to study it more effectively.

Content

This dataset contains information about candidates, committees, PACs (political action committees), House & Senate campaigns & about transactions, contributions by individuals & committees & operating & independent expenditures for US elections from Jan 2015 to Dec 2016.
This dataset was created by downloading the bulk dataset from the FEC website page here & then, creating csv files using the correct headers. You will also find data description links from the bulk dataset FEC page linked above.

Acknowledgements

Thanks to the US Federal Election Commission (FEC) for providing this data in an easily accessible form. Their website is here.
Please follow their data usage policies as stated on this page. Here's a brief note on their bulk data download page if that helps (but refer to the above page for completeness):

Anyone can inspect and copy reports and statements filed by political committees. But the names and addresses of individual contributors may not be sold or used for commercial purposes or to solicit contributions or donations.

Tables

All Candidates

@kaggle.jeegarmaru_us_campaign_finance_20152016_fec.all_candidates

225.89 KB
2906 rows
30 columns


CREATE TABLE all_candidates (
  "cand_id" VARCHAR,
  "cand_name" VARCHAR,
  "cand_ici" VARCHAR,
  "pty_cd" BIGINT,
  "cand_pty_affiliation" VARCHAR,
  "ttl_receipts" DOUBLE,
  "trans_from_auth" DOUBLE,
  "ttl_disb" DOUBLE,
  "trans_to_auth" DOUBLE,
  "coh_bop" DOUBLE,
  "coh_cop" DOUBLE,
  "cand_contrib" DOUBLE,
  "cand_loans" DOUBLE,
  "other_loans" DOUBLE,
  "cand_loan_repay" DOUBLE,
  "other_loan_repay" DOUBLE,
  "debts_owed_by" DOUBLE,
  "ttl_indiv_contrib" DOUBLE,
  "cand_office_st" VARCHAR,
  "cand_office_district" DOUBLE,
  "spec_election" VARCHAR,
  "prim_election" VARCHAR,
  "run_election" VARCHAR,
  "gen_election" VARCHAR,
  "gen_election_precent" VARCHAR,
  "other_pol_cmte_contrib" DOUBLE,
  "pol_pty_contrib" DOUBLE,
  "cvg_end_dt" TIMESTAMP,
  "indiv_refunds" DOUBLE,
  "cmte_refunds" DOUBLE
);

Any Transaction From One Committee To Another

@kaggle.jeegarmaru_us_campaign_finance_20152016_fec.any_transaction_from_one_committee_to_another

89.03 MB
2147088 rows
21 columns


CREATE TABLE any_transaction_from_one_committee_to_another (
  "cmte_id" VARCHAR,
  "amndt_ind" VARCHAR,
  "rpt_tp" VARCHAR,
  "transaction_pgi" VARCHAR,
  "image_num" BIGINT,
  "transaction_tp" VARCHAR,
  "entity_tp" VARCHAR,
  "name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "employer" VARCHAR,
  "occupation" VARCHAR,
  "transaction_dt" DOUBLE,
  "transaction_amt" BIGINT,
  "other_id" VARCHAR,
  "tran_id" VARCHAR,
  "file_num" BIGINT,
  "memo_cd" VARCHAR,
  "memo_text" VARCHAR,
  "sub_id" BIGINT
);

Candidate Master

@kaggle.jeegarmaru_us_campaign_finance_20152016_fec.candidate_master

430.93 KB
7396 rows
15 columns


CREATE TABLE candidate_master (
  "cand_id" VARCHAR,
  "cand_name" VARCHAR,
  "cand_pty_affiliation" VARCHAR,
  "cand_election_yr" BIGINT,
  "cand_office_st" VARCHAR,
  "cand_office" VARCHAR,
  "cand_office_district" DOUBLE,
  "cand_ici" VARCHAR,
  "cand_status" VARCHAR,
  "cand_pcc" VARCHAR,
  "cand_st1" VARCHAR,
  "cand_st2" VARCHAR,
  "cand_city" VARCHAR,
  "cand_st" VARCHAR,
  "cand_zip" DOUBLE
);

Candidate Committee Linkages

@kaggle.jeegarmaru_us_campaign_finance_20152016_fec.candidate_committee_linkages

129.14 KB
6412 rows
7 columns


CREATE TABLE candidate_committee_linkages (
  "cand_id" VARCHAR,
  "cand_election_yr" BIGINT,
  "fec_election_yr" BIGINT,
  "cmte_id" VARCHAR,
  "cmte_tp" VARCHAR,
  "cmte_dsgn" VARCHAR,
  "linkage_id" BIGINT
);

Committee Master

@kaggle.jeegarmaru_us_campaign_finance_20152016_fec.committee_master

1.18 MB
17652 rows
15 columns


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

Contributions By Individuals

@kaggle.jeegarmaru_us_campaign_finance_20152016_fec.contributions_by_individuals

844.94 MB
20467708 rows
21 columns


CREATE TABLE contributions_by_individuals (
  "cmte_id" VARCHAR,
  "amndt_ind" VARCHAR,
  "rpt_tp" VARCHAR,
  "transaction_pgi" VARCHAR,
  "image_num" BIGINT,
  "transaction_tp" VARCHAR,
  "entity_tp" VARCHAR,
  "name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "employer" VARCHAR,
  "occupation" VARCHAR,
  "transaction_dt" DOUBLE,
  "transaction_amt" BIGINT,
  "other_id" VARCHAR,
  "tran_id" VARCHAR,
  "file_num" BIGINT,
  "memo_cd" VARCHAR,
  "memo_text" VARCHAR,
  "sub_id" BIGINT
);

Contributions From Committees To Candidates Independen 1de6a035

@kaggle.jeegarmaru_us_campaign_finance_20152016_fec.contributions_from_committees_to_candidates_independen_1de6a035

15.23 MB
516393 rows
22 columns


CREATE TABLE contributions_from_committees_to_candidates_independen_1de6a035 (
  "cmte_id" VARCHAR,
  "amndt_ind" VARCHAR,
  "rpt_tp" VARCHAR,
  "transaction_pgi" VARCHAR,
  "image_num" BIGINT,
  "transaction_tp" VARCHAR,
  "entity_tp" VARCHAR,
  "name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "employer" VARCHAR,
  "occupation" VARCHAR,
  "transaction_dt" DOUBLE,
  "transaction_amt" BIGINT,
  "other_id" VARCHAR,
  "cand_id" VARCHAR,
  "tran_id" VARCHAR,
  "file_num" BIGINT,
  "memo_cd" VARCHAR,
  "memo_text" VARCHAR,
  "sub_id" BIGINT
);

House Senate Current Campaigns

@kaggle.jeegarmaru_us_campaign_finance_20152016_fec.house_senate_current_campaigns

168.1 KB
1898 rows
30 columns


CREATE TABLE house_senate_current_campaigns (
  "cand_id" VARCHAR,
  "cand_name" VARCHAR,
  "cand_ici" VARCHAR,
  "pty_cd" BIGINT,
  "cand_pty_affiliation" VARCHAR,
  "ttl_receipts" DOUBLE,
  "trans_from_auth" DOUBLE,
  "ttl_disb" DOUBLE,
  "trans_to_auth" DOUBLE,
  "coh_bop" DOUBLE,
  "coh_cop" DOUBLE,
  "cand_contrib" DOUBLE,
  "cand_loans" DOUBLE,
  "other_loans" DOUBLE,
  "cand_loan_repay" DOUBLE,
  "other_loan_repay" DOUBLE,
  "debts_owed_by" DOUBLE,
  "ttl_indiv_contrib" DOUBLE,
  "cand_office_st" VARCHAR,
  "cand_office_district" DOUBLE,
  "spec_election" VARCHAR,
  "prim_election" VARCHAR,
  "run_election" VARCHAR,
  "gen_election" VARCHAR,
  "gen_election_precent" VARCHAR,
  "other_pol_cmte_contrib" DOUBLE,
  "pol_pty_contrib" DOUBLE,
  "cvg_end_dt" TIMESTAMP,
  "indiv_refunds" DOUBLE,
  "cmte_refunds" DOUBLE
);

Operating Expenditures

@kaggle.jeegarmaru_us_campaign_finance_20152016_fec.operating_expenditures

62.15 MB
1747230 rows
25 columns


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

Pac Summary

@kaggle.jeegarmaru_us_campaign_finance_20152016_fec.pac_summary

697.12 KB
12049 rows
27 columns


CREATE TABLE pac_summary (
  "cmte_id" VARCHAR,
  "cmte_nm" VARCHAR,
  "cmte_tp" VARCHAR,
  "cmte_dsgn" VARCHAR,
  "cmte_filing_freq" VARCHAR,
  "ttl_receipts" DOUBLE,
  "trans_from_aff" DOUBLE,
  "indv_contrib" DOUBLE,
  "other_pol_cmte_contrib" DOUBLE,
  "cand_contrib" DOUBLE,
  "cand_loans" DOUBLE,
  "ttl_loans_received" DOUBLE,
  "ttl_disb" DOUBLE,
  "tranf_to_aff" DOUBLE,
  "indv_refunds" DOUBLE,
  "other_pol_cmte_refunds" DOUBLE,
  "cand_loan_repay" DOUBLE,
  "loan_repay" DOUBLE,
  "coh_bop" DOUBLE,
  "coh_cop" DOUBLE,
  "debts_owed_by" DOUBLE,
  "nonfed_trans_received" DOUBLE,
  "contrib_to_other_cmte" DOUBLE,
  "ind_exp" DOUBLE,
  "pty_coord_exp" DOUBLE,
  "nonfed_share_exp" DOUBLE,
  "cvg_end_dt" TIMESTAMP
);