Baselight

US Campaign Finance 2017-2018 FEC

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

@kaggle.jeegarmaru_us_campaign_finance_20172018_fec

Loading...
Loading...

About this Dataset

US Campaign Finance 2017-2018 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 2017 to Dec 2018.
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_20172018_fec.all_candidates
  • 285.66 KB
  • 3690 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_20172018_fec.any_transaction_from_one_committee_to_another
  • 38.83 MB
  • 1015306 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_20172018_fec.candidate_master
  • 433.62 KB
  • 7380 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_20172018_fec.candidate_committee_linkages
  • 145.79 KB
  • 7203 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_20172018_fec.committee_master
  • 1.3 MB
  • 19026 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_20172018_fec.contributions_by_individuals
  • 850.31 MB
  • 21729810 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_20172018_fec.contributions_from_committees_to_candidates_independen_1de6a035
  • 11.58 MB
  • 349601 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_20172018_fec.house_senate_current_campaigns
  • 228.2 KB
  • 2679 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" BIGINT,
  "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_20172018_fec.operating_expenditures
  • 65.58 MB
  • 1799700 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_20172018_fec.pac_summary
  • 733.1 KB
  • 12402 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.