Baselight

US Campaign Finance 2013-2014 FEC

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

@kaggle.jeegarmaru_us_campaign_finance_20132014_fec

Loading...
Loading...

About this Dataset

US Campaign Finance 2013-2014 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 2013 to Dec 2014.
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_20132014_fec.all_candidates
  • 232.05 KB
  • 2989 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_20132014_fec.any_transaction_from_one_committee_to_another
  • 20.45 MB
  • 570489 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" DOUBLE,
  "memo_cd" VARCHAR,
  "memo_text" VARCHAR,
  "sub_id" BIGINT
);

Candidate Master

@kaggle.jeegarmaru_us_campaign_finance_20132014_fec.candidate_master
  • 328.97 KB
  • 5536 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_20132014_fec.candidate_committee_linkages
  • 120.19 KB
  • 6245 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_20132014_fec.committee_master
  • 1.02 MB
  • 14905 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_20132014_fec.contributions_by_individuals
  • 109.66 MB
  • 2192151 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" DOUBLE,
  "memo_cd" VARCHAR,
  "memo_text" VARCHAR,
  "sub_id" BIGINT
);

Contributions From Committees To Candidates Independen 1de6a035

@kaggle.jeegarmaru_us_campaign_finance_20132014_fec.contributions_from_committees_to_candidates_independen_1de6a035
  • 11.17 MB
  • 350272 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" DOUBLE,
  "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_20132014_fec.house_senate_current_campaigns
  • 165.98 KB
  • 1841 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_20132014_fec.operating_expenditures
  • 47.79 MB
  • 1351071 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_20132014_fec.pac_summary
  • 615.94 KB
  • 10027 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.