Baselight

US Campaign Finance 2015-2016 FEC

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

@kaggle.jeegarmaru_us_campaign_finance_20152016_fec

Loading...
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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

Share link

Anyone who has the link will be able to view this.